I'm wondering how to generate with the given lonlat in OSM PostGIS entities.
In pgrouting's website, they are telling that source and target are identifier of the vertex but not telling if this an osm_id
for OSM database or any. My only given to generate is lonlat of the potential source/target. I'm using osm2po to create routable database.
Can anyone give me a clue, so that I can make my map more dynamic?
Answer
In case you haven't tried it yet, the pgRouting Workshop is always a good place to get started.
When you used osm2po to convert your OSM data, then source
and target
attributes are already there and ready to use.
Sometimes the vertices
table, that contains all source and target ID's, is useful to find the nearest vertex from a geographic point. The osm2po SQL file does not contain this table, but there is a function to create it:
SELECT pgr_createVerticesTable('','geom_way','source','target');
To find the nearest node is now a simple PostGIS query.
No comments:
Post a Comment