After searching a several long time... i decide to ask here for help, im currently using ubuntu 12.04(because of compatibility) with postgresql 9.1, postgis2, pgrouting2 and qgis2.2

i need to make a system for network adding one by one the lines and their "fixed routes" to the database, with eclipse/c# or something like that, so i can do custom interface to add polyliness into database with a GUI :

  • Polylines(routes with name tag or ID, for later use on queries)
  • A polyline is composed by 2 routes (one to go and on to back, where the last node of one is the first of the other like a circle)
  • Polylines have infinite reverse cost(one way direction).
  • Some linestrings might use some of the same nodes of other line.

I'm kinda newbie in this GIS world, so a detailed guide would be nice.

i read that each thread should contain exactly one question and its answers, so other parts would go in other threads.


  • "lines", mean public transport routes
  • i have a network(streets) that i want to extend with public transport (PT) routes in another layer
  • i want to add one by one because there is no PT info available(lines or their routes)

EDIT3: i did some research again and see that what i need are polylines for each of my routes

i have a network(streets) like this: enter image description here i want to add polyliness like this: enter image description here and one by one like this (but in the same table/layer, so i can use them on shortest patch query later): enter image description here

  • 1
    So far, it's not clear what you are trying to do. If you say "lines", do you mean public transport routes? Or are you trying to create a routable network for car routing? – underdark Feb 23 '14 at 21:02
  • hi @underdark actually i follow your guide link but it give me some problems in windows... between i mean public transport routes, i want a way to add them one by one(node per node if needed). – user27260 Feb 23 '14 at 21:09
  • Please edit your question with additional detail: Do you already have some network which you want to extend with public transport (PT) routes? In which format do you have the PT route data? Why do you want to add them one by one instead of importing them all at once? – underdark Feb 23 '14 at 21:13
  • hi again @underdark i dont have any network with PT,i want to add them one by one because in my country there is none(on google maps or openstreetmap and openrouteservice only works on Europe) but if there is a better way then it would save me a lot of time, there are 126. – user27260 Feb 23 '14 at 22:20
  • If you answer my questions, maybe someone can help. – underdark Feb 24 '14 at 15:49

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.