[OSM-talk] List of tags in use/database

Brian Quinion openstreetmap at brian.quinion.co.uk
Thu Apr 10 16:14:29 BST 2008


Hi,

Is there anywhere I can get a list of the tags / values that are
actually in use in the system (i.e. an empirical list as opposed to
the wiki) without downloading the whole planet file and searching it?

Something like the output produced by Jon Burgess in the recent
discussion would be very helpful for seeing what other people are
currently using:

>  gis=> select amenity,count(amenity) as number from planet_osm_point
>  where amenity like 'bus%' group by amenity order by number desc;
>      amenity     | number
>  -----------------+--------
>   bus_station     |   1051
>   bus_stop        |    216
>   bus stop        |      5
>   bus_depot       |      3
>   bus_terminal    |      2
>   busstop         |      2
>   bus_parking     |      2
>   bus station     |      1
>   business_park   |      1
>   business centre |      1
>   bus_stop?       |      1
>  (11 rows)
>
>  gis=> select highway,count(highway) as number from planet_osm_point
>  where highway like 'bus%' group by highway order by number desc;
>      highway      | number
>  ------------------+--------
>   bus_stop         |  13532
>   bus_halt         |    230
>   bus_station      |     69
>   bus stop         |      4
>   busstop          |      4
>   bus_stop         |      2
>   bus_sluice       |      1
>   bus_stop:forward |      1
>  (8 rows)




More information about the talk mailing list