[pgrouting-users] compare routes between full network and subset

[Hugh Kelley]

Hi,

I am looking to compare the directness of routes between the entirety of a
network and a subset of the same network.

I see in pgr_createTopology that there is a rows_where argument to filter
the network.

When I use pgr_dijkstra to calculate routes between node pairs, if I've
created two separate topologies, one with the full network and another with
the subset using "rows_where". Can i somehow specify which topology the
dijkstra algorithm should use?

It occurred to me that I could just include a where clause in the "edges
sql" that I provide pgr_dijkstra but I can't find an example of that being
done anywhere.

In previous work I've simply made two tables, network and network_subset
and then just created topologies for each and calculated routes for each
network separately but it seems like I'm just not seeing exactly how to do
the same thing in a simpler manner with the "rows_where" argument or some
other option.

Thanks for any solutions or suggestions!

Hugh
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20240606/4f515242/attachment.htm>