Calculate distance between point and linestring, save the distance as table and represent that on QGIS? [duplicate]
I have loaded my data with osm2pgrouting and I have my network with ways (Linestring) and nodes (Point). The problem is : I have a database of doctors addresses (point) and I should calculate the ...
I'm studying GIS services to solve one specific need: Given x/y coordinates of one city, I want a JSON result that lists only cities (not facilities) that are nearby the specified city, within a ...
I have a road network where I do a driving distance operation through pgrouting. This is my SQL: SELECT * FROM driving_distance('SELECT gid AS id,source,target, cost FROM ...
I haven't used PgRouting much so I'm a little in the dark here. However, I am attempting a driving distance calculation like the one described by Underdark here. My SQL is identical, I have a ...