Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am trying to create the routable network table, as per Everytime I do it in PostGIS extension, QGIS crashes. The area is no so huge, consist of one British county. I'm also trying to do it with with pgAdminIII of PostgreSQL, it takes ages to do so. I do have the limited knowledge of queries, indexing etc. so I am not sure how to speed the process up. Is there something developed since 2011 (the last posts on that subject I found with this date) would enable me to do it efficiently? Thanks

UPDATE: (per @Pawel, Feb 19, 2013)

I have reinstalled PosrgreSQL and PostGIS. When I am trying to execute assign_vertex_id() I have: function assign_vertex_id(unknown, numeric, unknown, unknown) does not exist. What would be the problem?

share|improve this question
Which step "takes ages"? I don't think QGIS crashes, it's just waiting for PostGIS to finish - which can take longer. – underdark Feb 19 '13 at 19:13
Running the query in PgAdminIII takes a long time and I still do not know if it is achievable. How long does it usually takes? QGIS definitely crashes, both PostGIS and QGIS freeze and do not respond. Number of start and end point geometries - 52867, unique network nodes - 82257. – Pawel Feb 19 '13 at 19:29
You still didn't say which query hangs... – underdark Feb 19 '13 at 19:34
The one that creates routable network table, 'CREATE TABLE network AS ...' , the other ones ran with no problems. – Pawel Feb 19 '13 at 19:36
Did you try assign_vertex_id() instead? – underdark Feb 19 '13 at 19:39

You need to install pgRouting to get assign_vertex_id working. To install it, you can follow the steps in the link in your post itself.

I can add to it, here.

Suppose your directory where pgRouting gets installed is /usr/share/postlbs

To setup pgRouting extension to a database (say dbname):

    psql -U username -h localhost dbname -c 'CREATE EXTENSION postgis;'
    psql -U username -d dbname -h localhost < /usr/share/postlbs/routing_topology.sql
    psql -U username -d dbname -h localhost < /usr/share/postlbs/routing_core.sql
    psql -U username -d dbname -h localhost < /usr/share/postlbs/routing_core_wrappers.sql

Again, its just to help you try assign_vertex_id, I cant guarantee whether it could speed up your task. To know how assign_vertex_id works, you can follow How does assign_vertex_id() in pgRouting work?.

share|improve this answer

Your Answer


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

Not the answer you're looking for? Browse other questions tagged or ask your own question.