Question:
How do I to get the lat, long for all the toll booths stored in OSM for Virginia?
Current Query:
> gis=# select * from planet_osm_nodes where ('toll_booth' = ANY(tags)); id | lat | lon | tags ------------+-----------+------------+------------------------------------------------------------ 496668427 | 448545276 | -881565606 | {name,"Airport Parking",barrier,toll_booth} 525372041 | 463020204 | -874380697 | {name,"Swift Run Gap Entrance Station",barrier,toll_booth} 526241181 | 470778112 | -870435097 | {name,"Front Royal Entrance Station",barrier,toll_booth} 534508045 | 458513289 | -877777774 | {name,"Rockfish Gap Entrance Station",barrier,toll_booth} 563894077 | 470183057 | -857852817 | {barrier,toll_booth} ... Rest of the table
Additional Info
أكثر...
How do I to get the lat, long for all the toll booths stored in OSM for Virginia?
Current Query:
> gis=# select * from planet_osm_nodes where ('toll_booth' = ANY(tags)); id | lat | lon | tags ------------+-----------+------------+------------------------------------------------------------ 496668427 | 448545276 | -881565606 | {name,"Airport Parking",barrier,toll_booth} 525372041 | 463020204 | -874380697 | {name,"Swift Run Gap Entrance Station",barrier,toll_booth} 526241181 | 470778112 | -870435097 | {name,"Front Royal Entrance Station",barrier,toll_booth} 534508045 | 458513289 | -877777774 | {name,"Rockfish Gap Entrance Station",barrier,toll_booth} 563894077 | 470183057 | -857852817 | {barrier,toll_booth} ... Rest of the table
Additional Info
- OSM Import Log
- Failed Attempts
- Tutorial -- manually building a tile server
- Data source -- Cloudmade/virginia.osm.bz2.
أكثر...