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 followed these instructions to install postgresql and pgrouting on our ubuntu server:

http://obsessivecoder.com/2010/02/01/installing-postgresql-8-4-postgis-1-4-1-and-pgrouting-1-0-3-on-ubuntu-9-10-karmic-koala/

I am working with united_kingdom.highway.osm, It all seemed to go ok.

I have pgAdminIII on my windows machine, and can connect to my postgresql db and I see the tables: geometry_columns, planet_osm_line, planet_osm_nodes, planet_osm_point, planet_osm_polygon, planet_osm_rels, planet_osm_roads, planet_osm_ways, spatial_ref_sys.

Now, I have not done anything with postgresql before, and I am looking for the simplest possible way of getting something out to show it is working, like finding the distance beween two uk points.

Any help appriciated

best regards

Mark

share|improve this question

2 Answers 2

This question got referenced from another one, but this question (including answers) is quite old and outdated in the meanwhile.

To get started with pgRouting and OSM, you best start with the pgRouting workshop

share|improve this answer

OpenStreetMap road data is NOT routable by default. You'll have to use a tool that creates a routable network from the data. There are many around and since you work on Ubuntu, most of them should work for your. Also see the answers to this question How to make routable OSM map

Note that "The current version of osm2pgrouting needs to load all data into memory, which makes it fast but also requires a lot or memory for large datasets.".

I had more luck with osm2po which doesn't seem to have these memory restrictions. For a full tutorial go to http://underdark.wordpress.com/tag/pgrouting/

share|improve this answer
    
I have run osm2pgrouting, but am not sure if it worked, how can I check? From the output it does not give me any indication of wheather or not it succeeded. I mostly see "Trying to load data" and "Trying to parse data". –  Mark Jul 24 '12 at 14:33
    
I imagine the whole UK dataset is rather huge. It might well exceed the capabilities of osm2pgrouting –  underdark Jul 24 '12 at 15:39
    
Thank you for your help so far! So you recommend using osm2po? Are there any tutorials on using osm2po on ubuntu? –  Mark Jul 25 '12 at 15:45
    
You just need to download and extract the java .jar file. It makes no difference which OS you use (as long as java is installed). –  underdark Jul 25 '12 at 16:57
    
I am trying to use osm2po, and it runs, and then waits for requests on localhost:8888/Osm2poService. Are there any instructions on configuring apache for this? If I configure apache to listen on port 8888, and rerun osm2po, then osm2po crashes. Any assistance would we appriciated! many thanks mark –  Mark Aug 3 '12 at 16:22

Your Answer

 
discard

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.