I am trying to find all exits on
US 101 exits, preferably in the order North to South using the
OpenGIS osm2pgsql. But no luck so far.
Closes solution I found is:
http://stackoverflow.com/questions/1960005/how-to-get-lattitude-and-longitude-of-us-interstate-exits-programmatically comes close with the SQL:
select osm_id, name, ref from planet_osm_roads where highway='motorway_link';
select osm_id, name, ref from planet_osm_roads where highway='motorway';
Returns a lot more nodes with ref but I dont think those are freeway exits (whats special about the points noted on the freeway where highway="motorway"?
However most of the exits have null name and ref so while I have exit lat-longs its not clear which freeway these exits are on and nor are they ordered say North to South..