Openprise provides open data for metro areas for the United States, Canada, Australia, Austria, Finland, France, Germany, Ireland, Italy, the Netherlands, Norway, Spain, Sweden, Switzerland, and the United Kingdom. The tables are found in Openprise in Data>Open Data>
Reference - US Metro & Urban Area ZIP Codes
United States urban/metro data is sourced from the US Census. As a result, Metro Areas can provide unexpected results, as some of the areas are defined by voting districts rather than location. Best practice is to use Urban Area so that the areas are geographically, rather than politically, defined.
Urban Area data uses zip codes to define regions. If you have city and state but not zip code, you can infer a postal code for the city/state combination and use that to infer the Urban Area, without writing the inferred postal code back to your database of record.
Reference - Canada Cities and Postal Codes
Canadian urban areas are inferred from postal codes or cities. The urban area can be found in the Census Division field in the data source. For postal code, the data source uses only the first 3 characters/digits of the postal code, so you will want to match using “Begins with: Input value begins with reference value”.
Reference - Australian Metro Areas
Australian Urban Areas can be matched on city (Place Name in the data source) or postal code. Use the data from the Metro Area field in the data source.
Return values will include both urban areas such as “Greater Melbourne” as well as non-urban areas such as “Rest of NSW.” For the Canberra area, the value returned is “Australian Capital Territory”.
Reference - Europe Metro Areas
European Urban Areas must be matched on both country and city or country and postal code because of duplicate place names and postal codes in multiple countries. Use the data from the Metro Area field in the data source.
Because the data contains the “alternate names” field, you may match on alternate names and country as well as “Place Name” and country in case you have variations such as Cologne, Köln, Koln, and Koeln in your database, or you may use the table to pre-clean and standardize place names prior to assigning metro area.