--
You received this message because you are subscribed to the Google Groups "SpatiaLite Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to spatialite-use...@googlegroups.com.
To post to this group, send email to spatiali...@googlegroups.com.
Visit this group at https://groups.google.com/group/spatialite-users.
For more options, visit https://groups.google.com/d/optout.
-- Andy Harfoot GeoData Institute University of Southampton Southampton SO17 1BJ Tel: +44 (0)23 8059 2719 www.geodata.soton.ac.uk
Hi Antonio,
I have successfully tackled this using the Isochrone query syntax shown in this page:
https://www.gaia-gis.it/fossil/libspatialite/wiki?name=VirtualNetwork+reloaded
If the cost limit is set to be very large, then the returned table will cover the whole network and will report the cost to reach every node. This can then be filtered for the destination node IDs. The drawback to this method is that the route line itself is not returned.
Alternatively you can automate the writing of the 500 queries by using a CROSS JOIN to feed into the call to the virtual network:
https://groups.google.com/forum/#!topic/spatialite-users/9L_H5FrVIIU
However, you may encounter the issues that I had:
https://groups.google.com/forum/#!topic/spatialite-users/YZ5Lp9N_n4U
On Tuesday, 8 May 2018 15:48:44 UTC+2, Andrew Harfoot wrote:Hi Antonio,
I have successfully tackled this using the Isochrone query syntax shown in this page:
https://www.gaia-gis.it/fossil/libspatialite/wiki?name=VirtualNetwork+reloaded
If the cost limit is set to be very large, then the returned table will cover the whole network and will report the cost to reach every node. This can then be filtered for the destination node IDs. The drawback to this method is that the route line itself is not returned.
Alternatively you can automate the writing of the 500 queries by using a CROSS JOIN to feed into the call to the virtual network:
https://groups.google.com/forum/#!topic/spatialite-users/9L_H5FrVIIU
However, you may encounter the issues that I had:
https://groups.google.com/forum/#!topic/spatialite-users/YZ5Lp9N_n4U
Have you tried this with the new VirtualRouting to determine if these difficulties still apply?
Mark