Places
At the core of the Motionworks Population Intelligence Platform are places. These records allow all kinds of customers to focus on places that matter to them. For every place that a customer recieves in their data delieveries, they will also have access to the metadata about that place. More information on how Motionworks creates and maintains this data can be found at Place Polygon Creation Methodology
Schema
Motionworks delivers Places via Snowflake or can be delivered using a compressed flat file output (csv.gz) via cloud storage. The following describes the schema.
| Name | Description | Type | Example |
|---|---|---|---|
| place_id | Unique and persistent identifier of this place. | Integer | 77303 |
| name | Name of the place. | String | American Dream |
| short_name | An abbreviated version of the name. | String | NULL |
| place_type_id | Motionworks identifier for the place_type. | Integer | 30 |
| place_type | Description of the type or category this place falls within. | String | Shopping Mall |
| is_focused | The general type of data collection process used for this place record. | Boolean | TRUE |
| parent_place_id | The Motionworks identifier for the parent place of this place record, if applicable. | Integer | NULL |
| audit_status_id | Motionworks identifier for the audit status of the place record. | Integer | 5 |
| audit_status | The Motionworks audit status of the place record. | String | Certified |
| co_geoid | The geography identifier of the county (or county equivalent) that this place is within. | String | 34003 |
| co_name | The name of the county (or county equivalent) that this place is within. | String | Bergen |
| st_usps | The postal abbreviation of the state (or state equivalent) that this place is within. | String | NJ |
| st_name | The name of the state (or state equivalent) that this place is within. | String | New Jersey |
| cbsa_geoid | The identifier of the US Census Bureau's Combined Statistical Area that this place is within. | String | 35620 |
| cbsa_name | The name of the US Census Bureau's Combined Statistical Area that this place is within. | String | New York-Newark-Jersey City, NY-NJ-PA |
| cbsa_type | The type (metropolitan or micropolitan) of the US Census Bureau's Combined Statistical Area that this place is within. | String | cbsa_metro |
| dma_geoid | The identifier for the DMA (Designated Market Area) that this place is within. | String | 501 |
| dma_name | The name for the DMA (Designated Market Area) that this place is within. | String | New York, NY |
| su | The hours (in 24 hour time) for this place from opening to closing on a typical Sunday. | String | 1100-2000 |
| mo | The hours (in 24 hour time) for this place from opening to closing on a typical Monday. | String | 1100-2000 |
| tu | The hours (in 24 hour time) for this place from opening to closing on a typical Tuesday. | String | 1100-2000 |
| we | The hours (in 24 hour time) for this place from opening to closing on a typical Wednesday. | String | 1100-2000 |
| th | The hours (in 24 hour time) for this place from opening to closing on a typical Thursday. | String | 1100-2000 |
| fr | The hours (in 24 hour time) for this place from opening to closing on a typical Friday. | String | 1100-2000 |
| sa | The hours (in 24 hour time) for this place from opening to closing on a typical Saturday. | String | 1100-2200 |
| su_hours | The total hours that this place is open for on a typical Sunday. | Float | 9.0 |
| mo_hours | The total hours that this place is open for on a typical Monday. | Float | 9.0 |
| tu_hours | The total hours that this place is open for on a typical Tuesday. | Float | 9.0 |
| we_hours | The total hours that this place is open for on a typical Wednesday. | Float | 9.0 |
| th_hours | The total hours that this place is open for on a typical Thursday. | Float | 9.0 |
| fr_hours | The total hours that this place is open for on a typical Friday. | Float | 9.0 |
| sa_hours | The total hours that this place is open for on a typical Saturday. | Float | 11.0 |
| no_entrances | The number of entrances that visitors can use to enter this place. | Integer | 5 |
| no_floors | The number of floors or levels that visitors can access in this place | Integer | 5 |
| no_concourses | For transit stations, the number of concourses the station has that visitors can access that do not directly connect to a transit vehicle. | Integer | NULL |
| no_platforms | For transit stations, the number of platforms the station has where visitors can directly access a transit vehicle. | Integer | NULL |
| no_gates | For airports, the number of gates where visitors can board or exit aircraft. | Integer | NULL |
| collection_sqft | The total square footage of the data collection area for this place. | Float | 3024075.229660857 |
| building_sqft | The total square footage of the building shape for this place. | Float | NULL |
| timezone | The timezone that this place is within. | String | America/New_York |
| lat | The latitude of a point that represents this place. | Float | 40.808919 |
| lon | The longitude of a point that represents this place. | Float | -74.06875 |
| geography | A well-known text (WKT) representation of the collection area of this place. (This sample value is truncated) | String | POLYGON((-74.070388118 40.811727762, -74.070633116 40.811775028, -74.070930955 40.811513246, -74.07142095 40.810655174, -74.071949375 40.809484398, -74.072208784 40.808757197, -74.072333684 40.808248152, -74.07163232 40.808073621, -74.071075071 40.807375494)) |
| modified | The timestamp of the last time this place was modified. | String | 2022-12-26 19:49:08 UTC |
Audit Statuses
Motionworks employs a dedicated team of GIS professionals who maintain our place database and are continually reviewing new and existing places for accuracy. To track records as they are reviewed, the team uses audit statuses that are reported in the data.
| Audit Status ID | Name | Description |
|---|---|---|
| 1 | Requested | Place has been requested for audit. |
| 2 | Started | Place has had an audit started but not yet completed. |
| 3 | Requires Review | Place was audited but some type of secondary metadata could not be found or was estimated. |
| 4 | Reviewed | Place was audited and is complete. |
| 5 | Certified | Place was audited and is complete. Output data has been reviewed and is as expected. |
| 7 | Closed | Place was audited and found to be permanently closed. |
| 9 | Approximate | Place was audited but the shape associated with it is an approximation. |
| 12 | Published - Third Party | Place has not been audited, but metadata and shape have been taken from a 3rd party data source and used. |
| 67 | Geofence Only | Place details are not available, only a data collection area has been defined. |