Places

For all places a customer receives, they will get a library of the places and their metadata for reference.

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.

NameDescriptionTypeExample
place_idUnique and persistent identifier of this place.Integer77303
nameName of the place.StringAmerican Dream
short_nameAn abbreviated version of the name.StringNULL
place_type_idMotionworks identifier for the place_type.Integer30
place_typeDescription of the type or category this place falls within.StringShopping Mall
is_focusedThe general type of data collection process used for this place record.BooleanTRUE
parent_place_idThe Motionworks identifier for the parent place of this place record, if applicable.IntegerNULL
audit_status_idMotionworks identifier for the audit status of the place record.Integer5
audit_statusThe Motionworks audit status of the place record.StringCertified
co_geoidThe geography identifier of the county (or county equivalent) that this place is within.String34003
co_nameThe name of the county (or county equivalent) that this place is within.StringBergen
st_uspsThe postal abbreviation of the state (or state equivalent) that this place is within.StringNJ
st_nameThe name of the state (or state equivalent) that this place is within.StringNew Jersey
cbsa_geoidThe identifier of the US Census Bureau's Combined Statistical Area that this place is within.String35620
cbsa_nameThe name of the US Census Bureau's Combined Statistical Area that this place is within.StringNew York-Newark-Jersey City, NY-NJ-PA
cbsa_typeThe type (metropolitan or micropolitan) of the US Census Bureau's Combined Statistical Area that this place is within.Stringcbsa_metro
dma_geoidThe identifier for the DMA (Designated Market Area) that this place is within.String501
dma_nameThe name for the DMA (Designated Market Area) that this place is within.StringNew York, NY
suThe hours (in 24 hour time) for this place from opening to closing on a typical Sunday.String1100-2000
moThe hours (in 24 hour time) for this place from opening to closing on a typical Monday.String1100-2000
tuThe hours (in 24 hour time) for this place from opening to closing on a typical Tuesday.String1100-2000
weThe hours (in 24 hour time) for this place from opening to closing on a typical Wednesday.String1100-2000
thThe hours (in 24 hour time) for this place from opening to closing on a typical Thursday.String1100-2000
frThe hours (in 24 hour time) for this place from opening to closing on a typical Friday.String1100-2000
saThe hours (in 24 hour time) for this place from opening to closing on a typical Saturday.String1100-2200
su_hoursThe total hours that this place is open for on a typical Sunday.Float9.0
mo_hoursThe total hours that this place is open for on a typical Monday.Float9.0
tu_hoursThe total hours that this place is open for on a typical Tuesday.Float9.0
we_hoursThe total hours that this place is open for on a typical Wednesday.Float9.0
th_hoursThe total hours that this place is open for on a typical Thursday.Float9.0
fr_hoursThe total hours that this place is open for on a typical Friday.Float9.0
sa_hoursThe total hours that this place is open for on a typical Saturday.Float11.0
no_entrancesThe number of entrances that visitors can use to enter this place.Integer5
no_floorsThe number of floors or levels that visitors can access in this placeInteger5
no_concoursesFor transit stations, the number of concourses the station has that visitors can access that do not directly connect to a transit vehicle.IntegerNULL
no_platformsFor transit stations, the number of platforms the station has where visitors can directly access a transit vehicle.IntegerNULL
no_gatesFor airports, the number of gates where visitors can board or exit aircraft.IntegerNULL
collection_sqftThe total square footage of the data collection area for this place.Float3024075.229660857
building_sqftThe total square footage of the building shape for this place.FloatNULL
timezoneThe timezone that this place is within.StringAmerica/New_York
latThe latitude of a point that represents this place.Float40.808919
lonThe longitude of a point that represents this place.Float-74.06875
geographyA well-known text (WKT) representation of the collection area of this place. (This sample value is truncated)StringPOLYGON((-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))
modifiedThe timestamp of the last time this place was modified.String2022-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 IDNameDescription
1RequestedPlace has been requested for audit.
2StartedPlace has had an audit started but not yet completed.
3Requires ReviewPlace was audited but some type of secondary metadata could not be found or was estimated.
4ReviewedPlace was audited and is complete.
5CertifiedPlace was audited and is complete. Output data has been reviewed and is as expected.
7ClosedPlace was audited and found to be permanently closed.
9ApproximatePlace was audited but the shape associated with it is an approximation.
12Published - Third PartyPlace has not been audited, but metadata and shape have been taken from a 3rd party data source and used.
67Geofence OnlyPlace details are not available, only a data collection area has been defined.