[OSM-newbies] Howto: Query to get max speed limit of nearby road/highway

René Fournier m5 at renefournier.com
Thu Aug 23 22:32:44 BST 2012


So... I've imported 27 GB of canada.osm into PostGIS 1.5.4. Now I am trying to construct a query that, given a point (latitude, longitude), finds the max speed limit of the road it is on (or within 10 meters of — otherwise, return nothing). Can anyone help? I'm a total OSM noob, and have no idea how the data is structured or how best to extract this one piece of information. Thanks!

...Rene


More information about the newbies mailing list