Country/Region Admin Levels
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
AB
1
STOP -- this effort as moved to the "Missing/Broken Cities Tracker" document .. please follow this link to help with data cleanup --------------------------------------------------->
https://docs.google.com/spreadsheets/d/1F9eB2cteelcdHXMTmMuXg4dIp_lkHWopKajzhJnhCpw/edit#gid=0
2
Visit OSMhttps://nominatim.openstreetmap.org
3
Search for the Country's name
4
NOTE: This sheet is no longer monitored, as I have gathered enough data to get this project started
5
If you would like to assist with the lingering countries, you may follow the steps below
6
7
8
9
Click the "details" button, which brings you to the country page (e.g. "usa")
https://nominatim.openstreetmap.org/details.php?place_id=197597979
10
Scroll down to the "Parent Of" section
11
Scroll down to the "Administrative" section
12
This list is displaying States, which is what we want
13
Put the value in the 5th column ("Admin level", 4 in this case) in the "Region Admin Level" column in the countries sheet
14
Click "details" for a State, bringing you to the State page (e.g. Massachusetts)
https://nominatim.openstreetmap.org/details.php?place_id=198027682
15
Scroll down to the "Parent Of" section
16
Scroll down to the "Administrative" section
17
This list is displaying Counties, which we don't want
18
Click "details" for a County, bringing you to the Country page (e.g. Middlesex County)
https://nominatim.openstreetmap.org/details.php?place_id=198561494
19
Scroll down to the "Parent Of" section
20
Scroll down to the "Administrative" section
21
This list is displaying Cities, which is what we want
22
Put the value in the 5th column ("Admin level", 8 in this case) in the "City Admin Level" column in the countries sheet (edits are blocked, you must comment on the sheet instead)
23
Repeat for as many countries as you can stand to research :-)
24
25
We can optionally confirm this by clicking "details" for a City, bringing you to the City page(e.g. Cambridge)
https://nominatim.openstreetmap.org/details.php?place_id=198544636
26
Scroll down to the "Parent Of" section
27
This list does not include an "Administrative" section, so we know that there are no further layers to traverse
28
This may require some knowledge of the area you're inspecting based on what people generally refer to as a "City"
29
A great example of this is United Arab Emirates
https://nominatim.openstreetmap.org/details.php?place_id=198175827
30
The "Region" admin level is also the "City" admin level
31
If you tried to apply the same idea of checking admin level 8 you would see neighborhoods
32
33
Another way to determine the City Admin Level value is to run a query at Overpass Turbohttp://overpass-turbo.eu/
34
[out:json];area['admin_level'='4']['name'='Massachusetts'];(relation['admin_level'='8'](area););out;
35
In this example, we know that Region admin level in USA is 4 & we know that one region's name is Massachusetts
36
So we're collecting all the stuff at admin level 8 within that ... This happens to be the correct City Admin Level value, so the data returned is correct
37
(You have to click the Data tab to view the results)
38
Here's a template query to get you started:http://overpass-turbo.eu/s/LE4
Loading...