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've been following the "Beginners Guide to pgRouting" in an attempt to create an in-house application that provides drive-time isochrones. I have a server, postgreSQL and PostGIS and pgRouting - no problem. I have drivers to I can talk to the database from ASP.Net pages - easy again. I've got the data from OS too - imported shapefiles into the database - all easy.

Now I've run the bits of code in that article and the first two are easy again (and quick) so I've got my Node table and the road_ext view OK. However the third statement that creates the "Network" table is killing me, or more specifically the server. I have been trying with just the OS Grid tile "SO" which is not the most remote part of the UK by any means but still not going to have anything like as many roads as the London / Birmingham / Manchester area tiles surely. I'm running it on a quad-core box with a decent chunk of RAM, it's been running for 15 hours and not done yet. Box is not doing anything else, it's dedicated to the task. Even a little tile like the tip of Scotland (John O'Groats) took about 3 hours. At this rate I'm looking at over a week to build a network which is ridiculous. Am I doing anything obviously wrong here or is it just going to take that long and I have to deal with it.

Ultimately I want to produce these polygons and overlay them on Bing Maps. If I have gone off-course above, could anyone please suggest an alternate dataset like OSM or something that's ready made I can use?

Thanks, Michael

share|improve this question
4  
It's been a while since "Beginners Guide to pgRouting" and I have learned a lot of new things since then. The information is spread over my follow-up posts on pgRouting: underdark.wordpress.com/tag/pgrouting. I'm planning to update the beginners guide with what I've learned in the close future. –  underdark Oct 12 '11 at 10:38
    
Yes, I've been following all the things you've covered with interest - you're doing almost exactly what I want to do with routing, catchment areas and so on. I just can't find a machine powerful enough to build a network for the whole UK in order to use your stuff in a production environment. I either need more patience, more time or a pre-built network! –  Michael Oct 12 '11 at 12:56
    
Which OS (Opendata) dataset are you using Merdian2? or Vector District? –  Mapperz Oct 12 '11 at 14:43
    
It's Vector District (the one which offers a shapefile for each OS Grid tile. I had a little look at Meridan2 yesterday but if the machine hadn't crunched up one tile of Vector District in 15 hours, how long will it take to do Meridan2 as one lump? –  Michael Oct 12 '11 at 14:52
    
Did you try assign_vertex_id() function? –  underdark Feb 19 '13 at 19:14
show 2 more comments

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.