|
Hello Everybody, I would like to use openstreetmaps to create some statistics about playgrounds. Specifically I would like to know how many playgrounds there are in Germany and in Berlin. But I would also love to understand how to generally count specific tags in a specific area. Thanks a lot and excuse me, if there is an easy anser - I haven't done much with Openstreetmaps yet. |
|
One could use Overpass. This query counts the number of playgrounds in Berlin. You could replace Berlin with Germany. Please note that because we export the count, the playgrounds are not displayed on the map. You have to look at the "data" tab after executing the query. The Overpass documentation has an example to count the number of Pharmacies per county. just a quick question. Here is the result for germany. What is the difference between "@count" and "@count:nodes"? @count: 84743 @count:nodes: 28559 55812 @count:ways: 372 @count:relations
(29 Oct '17, 19:54)
JannesPeters
2
Playgrounds can be represented as a point or area, "count" returns all the representations, "count:nodes" returns just the point features. More at http://wiki.openstreetmap.org/wiki/Elements.
(29 Oct '17, 20:43)
maxerickson
Naturally there could be some double counting (playgrounds mapped as an area and as a node), but I suspect (from spot checking the data) that this is likely to be minimal.
(29 Oct '17, 22:16)
SimonPoole ♦
The other thing to note, is that "kindergarten" is a fairly fuzzy concept (in general not just OSM). For example the Austrian variant would clearly include non-educational childcare on the other hand in Germany and Switzerland it would be more of a pre-school facility.
(29 Oct '17, 22:19)
SimonPoole ♦
|
|
Go to http://overpass-turbo.eu/ start the wizard and enter "leisure=playground in Germany" (without the quotes), build the query and set the timeout to 240 up from the standard 25 (that allows the query to run for a maximum of 240 seconds). Note the query is fairly slow and returns a lot of data, probably best to start with Berlin (leisure=playground in Berlin"). |