pgRouting/osm2pgrouting

Import tool for OpenStreetMap data to pgRouting database

Isaac Boates

@iboates

there it is

ok, thank you

i will finish up the last things i want on this commit and then i will begin migrating it

Vicky Vergara

@cvvergara

ok, I will be here

are you subscribed to pgRouting-dev list?

Isaac Boates

@iboates

Hi Vicky

I am not

also, I need to have permission to create repositories in order to transfer the repository to the pgRouting organisation

Vicky Vergara

@cvvergara

@dkastl do you know how to do that?

Vicky Vergara

@cvvergara

@MarPetra https://github.com/osgeo/osgeo

Vicky Vergara

@cvvergara

@iboates trying to contact @dkastl again

Vicky Vergara

@cvvergara

@iboates dont forget to subscribe to pgrouting-dev & pgRouting-user list

Daniel Kastl

@dkastl

@iboates thanks for contributing to pgRouting! That's very much appreciated!
I just found a setting in Github to allow members of the organization to create repositories, so I enabled it.
You are already osm2pgrouting member, so could you try, if it works?

Isaac Boates

@iboates

all done

and you're welcome, thanks for the invitation

now i finally have a valid reason to put my pgrouting sticker on my laptop :)

Vicky Vergara

@cvvergara

Welcome :)

Debashish Nanda

@debashishnanda

hello mentors

Vicky Vergara

@cvvergara

Hello, if you are appliying please go to https://gitter.im/pgRouting/pgrouting

Debashish Nanda

@debashishnanda

Tobias Werner

@Tobias-Werner

Hi! I have a question about processing multiple OSM files. I want to split up large areas in multiple smaller files which i want to import separately for building a topology. Does osm2pgrouting take into account already imported topology? My intention is to build a topology of germany by importing the states sequentially. I read the docs that if the --clean paramter is missing the new imported data will be appended to the existing data - but will the existing topology be considered?

Daniel Kastl

@dkastl

@Tobias-Werner , yes, this should work as expected. When you do not use the --clean flag, then missing data will be apppended.

Tobias Werner

@Tobias-Werner

@dkastl thank you!

Sergii

@curiousaboutgis

Hello! I am trying to start osm2pgrouting by loading osm data into it, but I get the following error message:

osm2pgrouting --f your-OSM-XML-File.osm --conf mapconfig.xml --dbname routing --username postgres --clean
Execution starts at: Tue Jul 14 15:40:48 2020

       COMMAND LINE CONFIGURATION             *

Filename = your-OSM-XML-File.osm
Configuration file = mapconfig.xml
host = localhost
port = 5432
dbname = routing
username = postgres
schema=
prefix =
suffix =
Drop tables
Don't create indexes
Don't add OSM nodes

Testing database connection: routing
fe_sendauth: no password supplied

What could be the problem?

Vicky Vergara

@cvvergara

@atene468

# work on the home folder
cd

# login to postgres
psql -U postgres

-- Create youruser
CREATE ROLE youruser SUPERUSER CREATEDB CREATEROLE INHERIT LOGIN PASSWORD 'your_pass';

-- exit psql
\q

# Add the user to .pgpass
echo :5432:*:youruser:yourpass >> .pgpass

Then try with

osm2pgrouting --f your-OSM-XML-File.osm --conf mapconfig.xml --dbname routing \
     --username youruser \
     --clean

Sergii

@curiousaboutgis

Thanks a lot for your quick answer. Unfortunately it doesnt work. Got the message like this

Vicky Vergara

@cvvergara

chmod 0600 ~/.pgpass

try again

https://www.postgresql.org/docs/12/libpq-pgpass.html

Sergii

@curiousaboutgis

echo :5432:*routing:routing >> chmod 0600 ~/.pgpass
I did same and got the same error message.

Vicky Vergara

@cvvergara

I dont know you are using the same name everywhere

can you do createdb foo ?

Sergii

@curiousaboutgis

ok now I tried it with sudo, error about permission group/world access disappeared. but the problem stays same: fe_sendauth: no password supplied

oh ok, I will try

Vicky Vergara

@cvvergara

why sudo?

if you cant do createdb foo just like that without sudo is because you dont have in pgpass your name and password

Sergii

@curiousaboutgis

Thanks a lot for your instant answers! I tried it as you said: it still shows: fe_sendauth: no password supplied

Vicky Vergara

@cvvergara

that is postgres issue

why dont you google it and see what you find

Sergii

@curiousaboutgis

I have definitely searched about it a lot before landing here, but yes, will try to dig a bit more :)

Sergii

@curiousaboutgis

It finally worked. I added -W password. I mean I tried before, but my password for postgres contained symbols like !,1234, and the response was always: !,1234, event not recognized. I had to change my postgres password by choosing just letter symbols and it worked!

osm2pgrouting --f your-OSM-XML-File.osm --conf mapconfig.xml --dbname routing --username postgres -W yourpassword --clean

Vicky Vergara

@cvvergara

good you could solve it

gregorhuh

@gregorhuh

Hi there, would you have some guidance on how to install osm2pgrouting? I'm an absolute greenhorn when it comes to compiling from source code (which is what I believe I have to do?). I have postgresql (via pgAdmin 4), postgis and pgrouting. I also installed boost and he CMAKE gui from pre-compiled binaries (I think that's the the term). I have the git cmd application as well, but no idea how to go about the rest ... :-/ Any guidance would be much appreciated

gregorhuh

@gregorhuh

Also, I should say I'm on Windows 10 (whereas the main page says that "Currently osm2pgrouting is only tested on Linux distributions."). Can I use osm2pgrouting on windows?

Daniel Kastl

@dkastl

@gregorhuh , the majority of pgRouting developers does not work on Windows.
But you could try to use the Docker images of pgRouting. They also contain osm2pgrouting: https://hub.docker.com/r/pgrouting/pgrouting/
I haven't tested this on Windows, but it might work and you don't need to compile anything then.

gregorhuh

@gregorhuh

Great, thanks a million Daniel!

Where communities thrive

People

Repo info

Activity