Is it feasible to make a query on a spatial database to find out how many main roads need to be crossed on a journey between two point features? I understand there is a ST_Intersects function but can this be used where the intersection is between records on one of the tables and the result of say a distance query.

  • Probably, but likely not sufficiently; it's not clear if you are looking to actually route on your network or postprocess a generated geometry. In any case, though, you likely rather want to utilize a graph analytics suite like pgRouting. – geozelot Nov 18 at 8:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.