Geography

A reference for users, Motionworks provides geographic references with additional attributes for mapping and cross-referencing between types and through time.

Motionworks provides much of its data referenced to standard units of geography like Census Block Groups in the United States or Statistics Canada Dissemination Areas. As a reference for users, Motionworks provides the versions of these geographic references with additional attributes allowing users to:

  • Show the geographies on a map.
  • Analyze the data geospatially.
  • Cross-reference between geography types
  • Understanding how geographies are changing through time

In addition to the basic geography definitions shown here, the following supplemental tabulations are available:

Available Geography

CountyGeographies AvailableFrequency
Australia
  • Local Government Areas
  • Localities
  • Postal Areas
  • States and Territories
  • Statistical Area 1
  • Statistical Area 2
  • Statistical Area 3
  • Statistical Area 4
2021
Canada
  • Census Division
  • Census Subdivision
  • Census Tracts
  • Dissemination Areas
  • Economic Regions
  • Metropolitan Areas
  • Provinces and Territories
2016
United States
  • Block Groups
  • Counties
  • Metro Divisions
  • Metropolitan Statistical Areas
  • Micropolitan Statistical Areas
  • States
  • ZIP Code Tabulation Areas
2010
2020

Schema

Motionworks delivers Geography via Snowflake or can be delivered using a compressed flat file output (csv.gz) via cloud storage. The following describes the schema.

NameDescriptionTypeExample
geography_idUnique identifier for the geography across the country, year, geography type, and national identifier.stringUS2020STCO36061
country_codeTwo-letter ISO-3166 country code for which country this geography applies.stringUS
yearYear for which this record is relevant.integer2020
geography_typeA description of the geography type. See available Available Geography above.stringstco (county)
national_idThe unique identifier for the geography within the country of origin. Usually unique to the year and geography_type.string36061
geography_nameThe common name, if applicable, for the geography.stringNew York County
geographyThe Well-Known-Text (WKT) spatial representation of the geography.stringPOLYGON((-81.849327 38.422626, -81.84939 38.422903,...))