Schemas
base Shopping centers
|
Name |
Data Type |
Can be Null |
Description |
Definition |
|
PropertyID |
Integer |
No |
CAP Unique Property Identifier |
The primary key of the Shopping Center File. The propertyID is unique and indicates the id of the shopping center. |
|
Placekey |
String |
Yes |
Placekey Identifier |
Unique global identifier for each Shopping Center.Can be used for matching third-party datasets with CAP Shopping Centers. |
|
PropertyName |
String |
No |
Shopping Center Name |
Shopping Center Name or Market Name. |
|
CAP_ClassName |
List |
No |
Shopping Center Website |
Designates the Shopping Center Type. The CAP_ClassName attribute is linked with the CAP_CategoryID attribute. The name of the Shopping Center Category (see Shopping Center Categories) |
|
CAP_CategoryID |
Integer |
No |
Shopping Center Classification Identifier |
|
| Address1 | String | No |
Shopping Center Address |
The street address of the Shopping Center. |
|
City |
List |
No |
City |
City Name |
|
StateProvince |
List |
No |
Abbreviated State or Province |
US State or Canadian Province Abbreviation |
|
StateProvince_Code |
Integer |
No |
Unique Code for each State or Province |
US State or Canadian Province Unique Code |
| ZipPostal_Code | String | No |
Zip code or Postal code |
US Zip Code or Canadian Postal Code |
| Zip4 | String | Yes | Zip+4 | Expanded US Zip Codes |
| Country | List | No | Country Name | [United States, Canada] |
| Latitude | Float | No |
Latitude Coordinate of Shopping Center |
Latitude Coordinate of Shopping Center |
| Longitude | Float | No | Longitude Coordinate of Shopping Center | Longitude Coordinate of Shopping Center |
| GeocodeLevelID | Integer | No | Geocode Level Identifier | Identifier of the Shopping Center Geocode Accuracy |
| GeocodeLevel | List | No | Indicator on the level of accuracy of the Geocode | [Manual, Rooftop, Address]. Manual geocodes are rooftop geocodes that have been manually reviewed/adjusted by CAP.Rooftop geocodes are geocodes that are on the top of the Shopping Center property. Address geocodes are geocodes that can be either on Rooftop or in the Shopping Center parking lot and closer to the street. |
Real Estate
Base Shopping Centers needs to be purchased
|
Name |
Data Type |
Can be Null |
Description |
Definition |
|
PropertyID |
Integer |
No |
CAP Unique Property Identifier |
The primary key of the Shopping Center File. The propertyID is unique and indicates the id of the shopping center. |
|
GLA |
Integer |
Yes |
Shopping Center’s GLA |
Total Gross Leasable Area (measured in square footage) |
|
GLA_Source |
List |
Yes |
GLA Source ‐ The Source where GLA was derived |
A=Actual (from developer), E=Estimated (by CAP), X=SC Class Average |
|
PhoneNumber |
String |
Yes |
Phone Number |
Phone Number |
|
DeveloperID |
Integer |
Yes |
CAP Developer Identifier |
|
| DeveloperName | String | Yes |
Name of Shopping Center Developer |
Property Developer that either built or has taken ownership of the property |
Real Estate enhanced
Base Shopping Centers needs to be purchased
|
Name |
Data Type |
Can be Null |
Description |
Definition |
|
PropertyID |
Integer |
No |
CAP Unique Property Identifier |
The primary key of the Shopping Center File. The propertyID is unique and indicates the id of the shopping center. |
|
Year_Opened |
Integer |
Yes |
Shopping Center Year Opened |
The Year the shopping center was originally opened |
|
Year_Remodeled |
Integer |
Yes |
Year Shopping Center was Remodeled |
The last year the center was remodeled |
|
Parking_Count |
Integer |
Yes |
Number of Parking Spots |
Total parking count of Shopping Center |
|
Parking_Source |
List |
Yes |
The source where Parking Count was derived |
A=Actual (from developer), E=Estimated (byCAP), X=SC Class Average |
| Unit_Count | Integer | Yes |
Number of Tenant Units |
Total number of tenants within the center |
| Units_Source | List | Yes |
The source where Tenant Units was derived |
A=Actual (from developer), E=Estimated (byCAP), X=SC Class Average |
| Linked_Unit_Count | Integer | Yes |
Linked Unit Count |
The number of records that were matched to CAP’s Retail and Restaurant files as tenants or anchors of the Shopping Center. |
SHopping Center’s Linked Tenants
Base Shopping Centers needs to be purchased
|
Name |
Data Type |
Can be Null |
Description |
Definition |
|
PropertyID |
Integer |
No |
CAP Unique Property Identifier |
The primary key of the Shopping Center File. The propertyID is unique and indicates the id of the shopping center. |
|
LocationID |
Integer |
Yes |
CAP Unique Location Identifier |
Unique and Persistent ID from the CAP Retail and CAP Restaurant Datasets. |
|
TradeNameID |
Integer |
Yes |
CAP Unique Trade Name ID |
Unique and Persistent Identifier of Trade Name / Brand Name / Chain Name. |
|
TradeName |
String |
No |
Trade Name of the Store |
Trade Name / Brand Name / Chain Name. |
|
CompanyID |
Integer |
Yes |
CAP Unique Company ID |
Unique and Persistent Identifier of the Company (Owner). |
| CompanyName | String | Yes |
Company Name |
The Name of the Company that owns the Trade Name. |
| ParentCompanyName | String | Yes |
Parent Company Name |
The Name of the Parent Company that owns the Trade Name. |
| CAP_CategoryID | Integer | Yes |
CAP Unique Category ID |
Unique and Persistent Identifier of the Category of the Trade Name. |
| CAP_CategoryName | List | Yes |
CAP Category Name |
The Name of the Category of the Trade Name. |
| CAP_ClassName | List | Yes |
CAP Class Name |
The Name of the Class (Sub-Category) of the Trade Name. |
| SQFT | Integer | Yes |
Square Footage |
The total size (square footage) of the store. |
| PhoneNumber | String | Yes |
Phone Number |
The phone number of the store. |
Geofence (Polygons)
Base Shopping Centers needs to be purchased
|
Name |
Data Type |
Can be Null |
Description |
Definition |
|
PropertyID |
Integer |
No |
CAP Unique Property Identifier |
The primary key of the Shopping Center File. The propertyID is unique and indicates the id of the shopping center. |
|
PropertyPolygon |
Polygon |
No |
The Fence of the Shopping Center. |
Can be a Polygon or Multi-Polygon in Well Known Text (WKT) format and include the Shopping Center building(s) as well as the parking spaces. |
Class ID | Shopping Center Type | Size Range | Comments |
1 | Super Regional | 800,000 + | Similar to regional center but has more variety and assortment |
2 | Regional | 400,000 ‐ 800,000 | General merchandise; fashion (mall, typically enclosed) |
4 | Power Center | 250,000 ‐ 600,000 | Category‐dominant anchors; few small tenants |
6 | Community Center | 100,000 ‐ 350,000 | General merchandise; convenience |
5 | Lifestyle Center | 150,000 ‐ 500,000 | Typically an open air center with parking adjacent to stores; combination of apparel and specialty chains and restaurants; category killers, especially book stores and sporting goods are also usually present; defined primarily by the layout |
3 | Outlet Center | 50,000 ‐ 400,000 | Outlet stores and quick service restaurants |
7 | Neighborhood Center | 30,000 ‐ 250,000 | Convenience |
11 | Specialty Center | 40,000 ‐ 80,000 | A shopping center devoted to a particular market segment. The most common type has upscale fashion and home accessory stores. |
13 | Strip Center / Convenience | Up to 150000 | Convenience, restaurant, general merchandise and services |
25 | Entertainment/Festival/Theme | 80,000 ‐ 250,000 | Leisure; tourist‐oriented; retail and service |
9 | Mixed Use | 0 ‐ 60,000 + | Mix of commercial office space and retail and service |