I am interested in building a database table of as many city parks as I can. Looking through the docs of Open Street Map, it looks like there are lots of big hammers, but the operation I want to accomplish is quite simple: I just want to get the name, city/state, and lat/long of as many city parks as I can. How can I accomplish this with OSM data? Do I need to download the 40GB world and start filtering from there? I am comfortable working with SQL databases, if I could get it into that format I could perhaps query and trim down the extra data from there. asked 02 Mar '20, 05:47 broderick99 |
You can start with this 7 GB file http://download.geofabrik.de/north-america/us-latest.osm.pbf and then import that into a PostGIS database with the Be aware that the word "park" means many different things - anything between "a patch of green in the city" and "a state-sized highly protected natural reserve", and you might have to invest a little time to get the queries right. See the discussion starting at https://lists.openstreetmap.org/pipermail/talk-us/2018-January/018263.html for some background. answered 02 Mar '20, 08:06 Frederik Ramm ♦ |
This is not an answer to your question because you specified "with OSM data" but... you can query the USGS geonames server for features of class "park" and download the results per state. (I don't know of any way to do a single query for the whole country.)
https://geonames.usgs.gov/apex/f?p=138:1:0:::::
This query will likely only return a fraction of what OSM has, because all of the USGS parks were imported into OSM but many more parks have been manually mapped by OSM users.
Be aware that 1) coordinates are sometimes approximate 2) some info is out of date 3) the definition of "park" is quite inconsistent, as Frederik mentioned.
It's not got all the data for each entry, but there are bulk downloads for GNIS:
https://www.usgs.gov/core-science-systems/ngp/board-on-geographic-names/download-gnis-data