Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I have two tables: one, the resulting table from converting osm.xml via osm2po so I can use pgRouting, and another one that contains information on what edges each public vehicle passes through (|vehicle_code|edge_ids|). Note: one edge_id might contain many public vehicle codes.

So after executing pgRouting shortest path query, I want to know which vehicles are the best to use to navigate the shortest path to avoid too many transitions.

I'm kinda new to SQL; please help. Thanks!

share|improve this question
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.