Skip to content

Instantly share code, notes, and snippets.

@jnicho02

jnicho02/osm_station_tags

Created October 27, 2012 09:12
Show Gist options
  • Save jnicho02/3963677 to your computer and use it in GitHub Desktop.
Save jnicho02/3963677 to your computer and use it in GitHub Desktop.
Download ZIP
What other OSM tags do train stations have
Raw
osm_station_tags
SELECT
tag.k, count(*)
FROM
public.node_tags tag
WHERE
tag.node_id in
(SELECT
node_id
FROM
public.node_tags t2
WHERE
t2.k = 'railway' and t2.v = 'station')
AND tag.k != 'railway'
GROUP BY tag.k
ORDER BY count(*) DESC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment