I am using osm database imported with osm2pgsql in slim mode. In my current app I have locations of different vehicles in lat lon. I want to get max speed, road name and road type for each location. So here is the approach I am looking to implement -- for each set of lat lon values find the closest point in -- find a node in -- get the node id and find all ways in -- if max speed is not present use the maxspeed for that road type in that country. So I have a few questions regarding this scenario 1- Is there a more optimized way of getting these values since I would be doing them for 1-2M records on a daily basis. 2- how can i find road name? which tag represents that? 3- Since I am doing all of this offline. is there any source from where I can get country wise max speed for roads programatically and dump it in my db? Thanks asked 25 Jul '17, 16:18 aitizazk |