A demonstration of OpenStreetMap place classification reform in the United States based on census urban areas.
- Download Natural Earth I with Shaded Relief, Water, and Drainages (large size), Admin 0 – Countries, and Admin 1 – States, Provinces from the Natural Earth project.
- Download a shapefile of 2020 urban areas from the Census Bureau.
- Query Sophox for urban areas and their namesakes.
- Run
sed -i 's/https:\/\/www\.openstreetmap\.org\/node\///g' ua-namesake.tsv
. - Query the Wikidata Query Service for urban areas classified as major and minor by population.
- In QGIS, join the urban area shapefile to the classified urban areas.
- Query QLever for place points in the United States (“osm-planet”).
- Run
sed '1 s/?//g' osm-planet_YCt2Be.tsv | csvjson --quoting 1 --lat 'latitude' --lon 'longitude' --no-bbox > osm-planet.geojson
. - Reproject osm-planet to ESRI:102039 Contiguous Albers Equal Area Conic USGS.
- Buffer the reprojected points by 1 kilometer.
- Join the buffered circles to the classified urban area shapes.
- Join the OSM place points by location within the buffered, classified circles.
- Join the classified place points to the urban area namesakes.