I am using pgRouting with a street network. I added lines to the network that represent straight lines from destination points I am interested to the nearest street using
ST_ShortestLine(). Now I ran
pgr_nodeNetwork() to split the street network accordingly, so that it is ready for basic routing. However, when I run
pgr_createTopology() the vertices are not all included to have efficient routing:
select pgr_createTopology('my_table_wgs84', 0.0001, 'geom', 'street_id');
Here is a screenshot, which shows that for the highlighted red line, there are actually no vertices (red rectangles) created at all (plus you see that the connection line I created from the green destination point is actually splitted into several sublines by
For the red line, for instance, the source and target is both the red rectangle you see in the bottom left.
What might be the issue that
pgr_createTopology don't create vertices everywhere a line ends?