search

pgRouting / osm2pgrouting

Import tool for OpenStreetMap data to pgRouting database
https://pgrouting.org
GNU General Public License v2.0
289 stars 111 forks source link

Segmentation fault inside Docker container #158

Closed prevostc closed 7 years ago

prevostc commented 7 years ago

Hi guys,

I wanted to wrap osm2pgrouting inside a docker container but I get a segfault. Maybe you can help me debug this one :D

./osm2pgrouting/Dockerfile

FROM ubuntu

ENV builddir /build
WORKDIR ${builddir}

# install osm2pgrouting
RUN apt-get update
RUN apt-get -y install libboost-all-dev cmake libpq-dev libexpat1-dev g++
RUN apt-get -y install git
RUN git clone -b v2.2.0 --single-branch https://github.com/pgRouting/osm2pgrouting.git
WORKDIR ${builddir}/osm2pgrouting
RUN cmake -H. -Bbuild
WORKDIR ${builddir}/osm2pgrouting/build
RUN make
RUN make install

# slim up the image https://intercityup.com/blog/downsizing-docker-containers.html
RUN apt-get -y clean
RUN rm -rf /var/lib/apt/lists/* /tmp/* /var/tmp/*

CMD osm2pgrouting

./postgresql/Dockerfile

FROM postgres:9.6

RUN apt-get update
RUN apt-get install -y postgresql-contrib-9.6 postgresql-9.6-pgrouting postgresql-9.6-postgis-2.3 postgresql-9.6-postgis-scripts

./init-user-db.sh

#!/bin/bash
set -e

psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" <<-EOSQL
    create user mmu with encrypted password 'mmu';
    create database mmu with owner mmu;
EOSQL

export PG_PASSWORD=mmu
psql -v ON_ERROR_STOP=1 --username mmu <<-EOSQL
    create schema gis;
    create schema osm;
    ALTER DATABASE mmu SET SEARCH_PATH TO "\$user",public,gis,osm;
EOSQL

export PG_PASSWORD=${POSTGRES_PASSWORD}
psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" mmu -c "create extension postgis schema gis;"
psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" mmu -c "create extension pgrouting schema gis;"

Building both container images

$ docker build -t mmu/osm2pgrouting ./osm2pgrouting
$ docker build -t mmu/postgres ./postgresql

Using docker run directly (there is no clue what is going on)

$ docker run --rm -p 5000:5432 -v `pwd`/init-user-db.sh:/docker-entrypoint-initdb.d/init-user-db.sh --name mmu_db -e POSTGRES_PASSWORD=mmu mmu/postgres
$ docker run                                           \
    --link mmu_db:db                                 \
    -v `pwd`/paris_metro.osm:/data/data.osm          \
    -v `pwd`/mapconfig.xml:/data/mapconfig.xml       \
    --rm --name mmu_osmloader mmu/osm2pgrouting      \
    osm2pgrouting                                    \
    -h db -p 5432 -d mmu -U postgres -W mmu          \
    --file /data/data.osm                            \
    --conf /build/osm2pgrouting/mapconfig.xml        \
    --schema osm --addnodes --clean
***************************************************
           COMMAND LINE CONFIGURATION             *
***************************************************
Filename = /data/data.osm
Configuration file = /build/osm2pgrouting/mapconfig.xml
host = db
port = 5432
dbname = mmu
username = postgres
password = mmu
schema= osm
prefix = 
suffix = 
Drop tables
Add nodes
***************************************************
Connecting to the database
host=db user=postgres dbname=mmu port=5432 password=mmu
connection success
Opening configuration file: /build/osm2pgrouting/mapconfig.xml
    Parsing configuration

    Parsing data (progress line per 100000 elements)

------------------------------------------------------------

Using docker in interactive mode via bash (we can see the segfault)

docker run  -it                                          \       
    --link mmu_db:db                                 \
    -v `pwd`/paris_metro.osm:/data/data.osm          \
    -v `pwd`/mapconfig.xml:/data/mapconfig.xml       \
    --rm --name mmu_osmloader mmu/osm2pgrouting      \
    bash
root@2f80d1023a16:/build/osm2pgrouting/build# osm2pgrouting                                    \
>     -h db -p 5432 -d mmu -U postgres -W mmu          \
>     --file /data/data.osm                            \
>     --conf /build/osm2pgrouting/mapconfig.xml        \
>     --schema osm --addnodes --clean
***************************************************
           COMMAND LINE CONFIGURATION             *
***************************************************
Filename = /data/data.osm
Configuration file = /build/osm2pgrouting/mapconfig.xml
host = db
port = 5432
dbname = mmu
username = postgres
password = mmu
schema= osm
prefix = 
suffix = 
Drop tables
Add nodes
***************************************************
Connecting to the database
host=db user=postgres dbname=mmu port=5432 password=mmu
connection success
Opening configuration file: /build/osm2pgrouting/mapconfig.xml
    Parsing configuration

    Parsing data (progress line per 100000 elements)

Segmentation fault

Any idea on how to debug this ?

cvvergara commented 7 years ago

I would like to replicate. can you give me the bounding box please. When developing I had problems when the data contained this symbols: http://www.ascii.cl/htmlcodes.htm maybe I missed one

prevostc commented 7 years ago

Sorry, this is not at all an issue on your side but mine.

I tried to import the following file (./paris_metro.osm) but this file only contains references to some other data I need to import first so it is understandable that osm2pgrouting fails at this point.

I guess I need to import the OSM XML from there: https://mapzen.com/data/metro-extracts/metro/paris_france/ But then I have a LOG: could not fork autovacuum worker process: Cannot allocate memory on the PostgreSQL side that kills the connection. I'll investigate that instead.

./paris_metro.osm

<?xml version='1.0' encoding='UTF-8'?>
<osm version="0.6" generator="osmconvert 0.7T">
    <relation id="123564" version="44" timestamp="2015-09-29T10:27:51Z" changeset="34321682" uid="1779584" user="dhuyp">
        <member type="way" ref="24000179" role=""/>
        <member type="way" ref="313420254" role=""/>
        <member type="way" ref="313420253" role=""/>
        <member type="way" ref="27408185" role=""/>
        <member type="way" ref="27408100" role=""/>
        <member type="way" ref="27256031" role=""/>
        <member type="way" ref="27256005" role=""/>
        <member type="way" ref="27256042" role=""/>
        <member type="way" ref="27407928" role=""/>
        <member type="way" ref="27407692" role=""/>
        <member type="way" ref="157889678" role=""/>
        <member type="way" ref="157889691" role=""/>
        <member type="way" ref="157889679" role=""/>
        <member type="way" ref="157889670" role=""/>
        <member type="way" ref="146827257" role=""/>
        <member type="way" ref="157889676" role=""/>
        <member type="way" ref="37096882" role=""/>
        <member type="way" ref="146827256" role=""/>
        <member type="way" ref="248275325" role=""/>
        <member type="way" ref="79366079" role=""/>
        <member type="way" ref="27407888" role=""/>
        <member type="way" ref="79366078" role=""/>
        <member type="way" ref="146831143" role=""/>
        <member type="way" ref="79542055" role=""/>
        <member type="way" ref="146831142" role=""/>
        <member type="way" ref="280913922" role=""/>
        <member type="way" ref="157889668" role=""/>
        <member type="node" ref="928458344" role="stop"/>
        <member type="node" ref="300869641" role="stop"/>
        <member type="node" ref="300869611" role="stop"/>
        <member type="node" ref="300870034" role="stop"/>
        <member type="node" ref="300870186" role="stop"/>
        <member type="node" ref="300876896" role="stop"/>
        <member type="node" ref="300877457" role="stop"/>
        <member type="node" ref="264482296" role="stop"/>
        <member type="node" ref="264491320" role="stop"/>
        <member type="node" ref="264482297" role="stop"/>
        <member type="node" ref="1584432760" role="stop"/>
        <member type="node" ref="264482226" role="stop"/>
        <member type="node" ref="260762379" role="stop"/>
        <member type="node" ref="264481854" role="stop"/>
        <member type="node" ref="27371892" role="stop"/>
        <member type="node" ref="264481019" role="stop"/>
        <member type="node" ref="264480784" role="stop"/>
        <member type="node" ref="264479775" role="stop"/>
        <member type="node" ref="264479724" role="stop"/>
        <member type="node" ref="264476971" role="stop"/>
        <member type="node" ref="3193940515" role="stop"/>
        <member type="node" ref="256897077" role="stop"/>
        <member type="node" ref="256897078" role="stop"/>
        <member type="node" ref="256897079" role="stop"/>
        <member type="node" ref="256897080" role="stop"/>
        <member type="node" ref="243510336" role="stop"/>
        <member type="node" ref="264117312" role="stop"/>
        <member type="node" ref="1489806669" role="stop"/>
        <member type="node" ref="264473695" role="stop"/>
        <member type="node" ref="264473011" role="stop"/>
        <member type="node" ref="264469541" role="stop"/>
        <member type="node" ref="34909170" role="stop"/>
        <member type="node" ref="264469160" role="stop"/>
        <member type="node" ref="260231833" role="stop"/>
        <member type="node" ref="260231832" role="stop"/>
        <member type="node" ref="260231831" role="stop"/>
        <member type="node" ref="260231828" role="stop"/>
        <member type="node" ref="300867961" role="stop"/>
        <member type="node" ref="1489806675" role="stop"/>
        <tag k="colour" v="#C5A3CA"/>
        <tag k="line" v="subway"/>
        <tag k="name" v="Métro 8"/>
        <tag k="network" v="RATP"/>
        <tag k="operator" v="RATP"/>
        <tag k="ref" v="8"/>
        <tag k="ref:FR:STIF" v="1001100080001"/>
        <tag k="route" v="subway"/>
        <tag k="short_name" v="M8"/>
        <tag k="twitter" v="Ligne8_RATP"/>
        <tag k="type" v="route"/>
        <tag k="wheelchair" v="no"/>
        <tag k="wikipedia" v="fr:Ligne 8 du métro de Paris"/>
    </relation>
    <relation id="123652" version="38" timestamp="2015-09-22T20:39:51Z" changeset="34192816" uid="138059" user="Truchin">
        <member type="node" ref="270244850" role="stop"/>
        <member type="node" ref="270244435" role="stop"/>
        <member type="node" ref="270244436" role="stop"/>
        <member type="node" ref="264778142" role="stop"/>
        <member type="node" ref="264776910" role="stop"/>
        <member type="node" ref="264776029" role="stop"/>
        <member type="node" ref="264776028" role="stop"/>
        <member type="node" ref="235377792" role="stop"/>
        <member type="node" ref="264775552" role="stop"/>
        <member type="node" ref="326309672" role="stop"/>
        <member type="node" ref="264508548" role="stop"/>
        <member type="node" ref="264775805" role="stop"/>
        <member type="node" ref="264780947" role="stop"/>
        <member type="node" ref="264780946" role="stop"/>
        <member type="node" ref="256897458" role="stop"/>
        <member type="node" ref="243510336" role="stop"/>
        <member type="node" ref="264494507" role="stop"/>
        <member type="node" ref="27362259" role="stop"/>
        <member type="node" ref="264784170" role="stop"/>
        <member type="node" ref="3164606077" role="stop"/>
        <member type="node" ref="264785952" role="stop"/>
        <member type="node" ref="264785951" role="stop"/>
        <member type="node" ref="260040968" role="stop"/>
        <member type="node" ref="264786014" role="stop"/>
        <member type="node" ref="264789025" role="stop"/>
        <member type="node" ref="264790337" role="stop"/>
        <member type="node" ref="235371392" role="stop"/>
        <member type="node" ref="268467197" role="stop"/>
        <member type="node" ref="268467526" role="stop"/>
        <member type="node" ref="268467559" role="stop"/>
        <member type="way" ref="49993490" role=""/>
        <tag k="colour" v="#DF9AB1"/>
        <tag k="line" v="subway"/>
        <tag k="name" v="Métro 7"/>
        <tag k="network" v="RATP"/>
        <tag k="operator" v="RATP"/>
        <tag k="ref" v="7"/>
        <tag k="ref:FR:STIF" v="1001100070001"/>
        <tag k="route" v="subway"/>
        <tag k="short_name" v="M7"/>
        <tag k="stops" v="38"/>
        <tag k="twitter" v="Ligne7_RATP"/>
        <tag k="type" v="route"/>
        <tag k="wheelchair" v="no"/>
        <tag k="wikipedia" v="fr:Ligne 7 du métro de Paris"/>
    </relation>
    <relation id="123674" version="38" timestamp="2015-09-22T20:39:47Z" changeset="34192816" uid="138059" user="Truchin">
        <member type="node" ref="1771632724" role="stop"/>
        <member type="node" ref="2490099593" role="stop"/>
        <member type="node" ref="330026020" role="stop"/>
        <member type="node" ref="264772862" role="stop"/>
        <member type="node" ref="264772861" role="stop"/>
        <member type="node" ref="264772371" role="stop"/>
        <member type="node" ref="264772256" role="stop"/>
        <member type="node" ref="1997722992" role="stop"/>
        <member type="node" ref="235377792" role="stop"/>
        <member type="node" ref="264508125" role="stop"/>
        <member type="node" ref="264508548" role="stop"/>
        <member type="node" ref="251387813" role="stop"/>
        <member type="node" ref="3193943261" role="stop"/>
        <member type="way" ref="313420191" role="platform"/>
        <member type="node" ref="256896059" role="stop"/>
        <member type="node" ref="264769297" role="stop"/>
        <member type="node" ref="264769296" role="stop"/>
        <member type="node" ref="264480619" role="stop"/>
        <member type="node" ref="258068724" role="stop"/>
        <member type="node" ref="3419908162" role="stop"/>
        <member type="node" ref="265055434" role="stop"/>
        <member type="node" ref="265055750" role="stop"/>
        <member type="node" ref="235371392" role="stop"/>
        <member type="way" ref="165624512" role=""/>
        <member type="way" ref="117590223" role=""/>
        <member type="way" ref="131384682" role=""/>
        <member type="way" ref="131384683" role=""/>
        <member type="way" ref="134764716" role=""/>
        <member type="way" ref="334870913" role=""/>
        <member type="way" ref="24395322" role=""/>
        <member type="way" ref="31751763" role=""/>
        <member type="way" ref="23814820" role=""/>
        <member type="way" ref="23814819" role=""/>
        <member type="way" ref="23368036" role=""/>
        <member type="way" ref="23368039" role=""/>
        <member type="way" ref="30835560" role=""/>
        <member type="way" ref="23368038" role=""/>
        <member type="way" ref="23368037" role=""/>
        <member type="way" ref="23368043" role=""/>
        <member type="way" ref="334870917" role=""/>
        <tag k="colour" v="#DE8B53"/>
        <tag k="from" v="Bobigny – Pablo Picasso"/>
        <tag k="line" v="subway"/>
        <tag k="name" v="Métro 5"/>
        <tag k="network" v="RATP"/>
        <tag k="operator" v="RATP"/>
        <tag k="ref" v="5"/>
        <tag k="ref:FR:STIF" v="1001100050001"/>
        <tag k="route" v="subway"/>
        <tag k="short_name" v="M5"/>
        <tag k="stops" v="22"/>
        <tag k="to" v="Place d&#39;Italie"/>
        <tag k="twitter" v="Ligne5_RATP"/>
        <tag k="type" v="route"/>
        <tag k="wheelchair" v="no"/>
        <tag k="wikipedia" v="fr:Ligne 5 du métro de Paris"/>
    </relation>
    <relation id="123737" version="33" timestamp="2015-10-08T11:11:53Z" changeset="34507224" uid="1626" user="FredB">
        <member type="node" ref="3542631493" role="station"/>
        <member type="node" ref="243510338" role="stop"/>
        <member type="node" ref="264117312" role="stop"/>
        <member type="node" ref="3146958067" role="stop"/>
        <member type="node" ref="3146958063" role="stop"/>
        <member type="node" ref="1656938775" role="stop"/>
        <member type="node" ref="260762540" role="stop"/>
        <member type="node" ref="3146958064" role="stop"/>
        <member type="node" ref="3146958062" role="stop"/>
        <member type="node" ref="3325110405" role="station"/>
        <member type="node" ref="264491193" role="stop"/>
        <member type="way" ref="374417456" role=""/>
        <member type="way" ref="125667163" role=""/>
        <member type="way" ref="309364797" role=""/>
        <member type="way" ref="374417457" role=""/>
        <tag k="colour" v="#67328E"/>
        <tag k="from" v="Saint-Lazare"/>
        <tag k="line" v="subway"/>
        <tag k="name" v="Métro 14"/>
        <tag k="network" v="RATP"/>
        <tag k="operator" v="RATP"/>
        <tag k="ref" v="14"/>
        <tag k="ref:FR:STIF" v="1001100140001"/>
        <tag k="route" v="subway"/>
        <tag k="short_name" v="M14"/>
        <tag k="to" v="Olympiades"/>
        <tag k="twitter" v="Ligne14_RATP"/>
        <tag k="type" v="route"/>
        <tag k="wheelchair" v="yes"/>
        <tag k="wikipedia" v="fr:Ligne 14 du métro de Paris"/>
    </relation>
    <relation id="123767" version="46" timestamp="2015-09-22T20:39:45Z" changeset="34192816" uid="138059" user="Truchin">
        <member type="node" ref="1780486821" role="stop"/>
        <member type="node" ref="264505993" role="stop"/>
        <member type="node" ref="264507100" role="stop"/>
        <member type="node" ref="2504497535" role="stop"/>
        <member type="node" ref="264508548" role="stop"/>
        <member type="node" ref="264512252" role="stop"/>
        <member type="node" ref="256897077" role="stop"/>
        <member type="node" ref="243507794" role="stop"/>
        <member type="node" ref="264509793" role="stop"/>
        <member type="node" ref="264513655" role="stop"/>
        <member type="node" ref="3164606078" role="stop"/>
        <member type="node" ref="264514896" role="stop"/>
        <member type="node" ref="264515098" role="stop"/>
        <member type="node" ref="260079008" role="stop"/>
        <member type="node" ref="264519782" role="stop"/>
        <member type="node" ref="324352448" role="stop"/>
        <member type="node" ref="264520061" role="stop"/>
        <member type="node" ref="324363999" role="stop"/>
        <member type="node" ref="264526095" role="stop"/>
        <member type="node" ref="220289389" role="stop"/>
        <member type="node" ref="220289387" role="stop"/>
        <member type="node" ref="220289385" role="stop"/>
        <member type="node" ref="220289382" role="stop"/>
        <member type="node" ref="220289379" role="stop"/>
        <member type="node" ref="1480535477" role="stop"/>
        <member type="node" ref="1481147746" role="stop"/>
        <member type="node" ref="518319022" role="stop"/>
        <member type="node" ref="1014002216" role="stop"/>
        <member type="node" ref="2188235051" role="stop"/>
        <member type="way" ref="38088011" role=""/>
        <tag k="colour" v="#BB4D98"/>
        <tag k="from" v="Porte de Clignancourt"/>
        <tag k="line" v="subway"/>
        <tag k="name" v="Métro 4"/>
        <tag k="network" v="RATP"/>
        <tag k="operator" v="RATP"/>
        <tag k="ref" v="4"/>
        <tag k="ref:FR:STIF" v="1001100040001"/>
        <tag k="route" v="subway"/>
        <tag k="short_name" v="M4"/>
        <tag k="to" v="Mairie de Montrouge"/>
        <tag k="twitter" v="Ligne4_RATP"/>
        <tag k="type" v="route"/>
        <tag k="wheelchair" v="no"/>
        <tag k="wikipedia" v="fr:Ligne 4 du métro de Paris"/>
    </relation>
    <relation id="123768" version="37" timestamp="2015-09-22T20:39:40Z" changeset="34192816" uid="138059" user="Truchin">
        <member type="node" ref="264541617" role="stop"/>
        <member type="node" ref="264539964" role="stop"/>
        <member type="node" ref="260767428" role="stop"/>
        <member type="node" ref="264537727" role="stop"/>
        <member type="node" ref="264538576" role="stop"/>
        <member type="node" ref="264534424" role="stop"/>
        <member type="node" ref="264534423" role="stop"/>
        <member type="node" ref="261666122" role="stop"/>
        <member type="node" ref="34909170" role="stop"/>
        <member type="node" ref="261665825" role="stop"/>
        <member type="node" ref="245250755" role="stop"/>
        <member type="node" ref="473070143" role="stop"/>
        <member type="node" ref="261162833" role="stop"/>
        <member type="node" ref="260079322" role="stop"/>
        <member type="node" ref="260079008" role="stop"/>
        <member type="node" ref="260078622" role="stop"/>
        <member type="node" ref="260078619" role="stop"/>
        <member type="node" ref="260078615" role="stop"/>
        <member type="node" ref="260040968" role="stop"/>
        <member type="node" ref="260040829" role="stop"/>
        <member type="node" ref="3419908161" role="stop"/>
        <member type="way" ref="24380725" role=""/>
        <member type="way" ref="24380451" role=""/>
        <member type="way" ref="49482893" role=""/>
        <tag k="colour" v="#DFB039"/>
        <tag k="from" v="Boulogne - Pont de Saint-Cloud"/>
        <tag k="line" v="subway"/>
        <tag k="name" v="Métro 10"/>
        <tag k="network" v="RATP"/>
        <tag k="operator" v="RATP"/>
        <tag k="ref" v="10"/>
        <tag k="ref:FR:STIF" v="1001100100001"/>
        <tag k="route" v="subway"/>
        <tag k="short_name" v="M10"/>
        <tag k="twitter" v="Ligne10_RATP"/>
        <tag k="type" v="route"/>
        <tag k="wheelchair" v="no"/>
        <tag k="wikipedia" v="fr:Ligne 10 du métro de Paris"/>
    </relation>
    <relation id="123775" version="32" timestamp="2015-09-22T20:39:41Z" changeset="34192816" uid="138059" user="Truchin">
        <member type="way" ref="354119188" role=""/>
        <member type="way" ref="246854048" role=""/>
        <member type="way" ref="24331466" role=""/>
        <member type="way" ref="135681290" role=""/>
        <member type="node" ref="2075538669" role="stop"/>
        <member type="node" ref="264505930" role="stop"/>
        <member type="node" ref="249335596" role="stop"/>
        <member type="node" ref="1481147746" role="stop"/>
        <member type="node" ref="264505450" role="stop"/>
        <member type="node" ref="264505153" role="stop"/>
        <member type="node" ref="264505115" role="stop"/>
        <member type="node" ref="243496024" role="stop"/>
        <member type="node" ref="264504832" role="stop"/>
        <member type="node" ref="264495078" role="stop"/>
        <member type="node" ref="264495077" role="stop"/>
        <member type="node" ref="3542631493" role="station"/>
        <member type="node" ref="634996117" role="stop"/>
        <member type="node" ref="264117312" role="stop"/>
        <member type="node" ref="263917856" role="stop"/>
        <member type="node" ref="263497271" role="stop"/>
        <member type="node" ref="263497272" role="stop"/>
        <member type="node" ref="264495553" role="stop"/>
        <member type="node" ref="261162833" role="stop"/>
        <member type="node" ref="263499468" role="stop"/>
        <member type="node" ref="263499471" role="stop"/>
        <member type="node" ref="324363999" role="stop"/>
        <member type="node" ref="244494496" role="stop"/>
        <member type="node" ref="260764273" role="stop"/>
        <member type="node" ref="244494489" role="stop"/>
        <member type="node" ref="244494486" role="stop"/>
        <member type="node" ref="134305198" role="stop"/>
        <member type="node" ref="134305192" role="stop"/>
        <member type="node" ref="134299013" role="stop"/>
        <member type="node" ref="134299001" role="stop"/>
        <tag k="colour" v="#328E5B"/>
        <tag k="line" v="subway"/>
        <tag k="name" v="Métro 12"/>
        <tag k="network" v="RATP"/>
        <tag k="old_name" v="Ligne A du Nord-Sud"/>
        <tag k="operator" v="RATP"/>
        <tag k="ref" v="12"/>
        <tag k="ref:FR:STIF" v="1001100120001"/>
        <tag k="route" v="subway"/>
        <tag k="short_name" v="M12"/>
        <tag k="twitter" v="Ligne12_RATP"/>
        <tag k="type" v="route"/>
        <tag k="wheelchair" v="no"/>
        <tag k="wikipedia" v="fr:Ligne 12 du métro de Paris"/>
    </relation>
    <relation id="123782" version="38" timestamp="2015-09-22T20:39:54Z" changeset="34192816" uid="138059" user="Truchin">
        <member type="way" ref="206318501" role=""/>
        <member type="way" ref="142160901" role=""/>
        <member type="way" ref="142160900" role=""/>
        <member type="way" ref="29873630" role=""/>
        <member type="node" ref="370455978" role="stop"/>
        <member type="node" ref="355153536" role="stop"/>
        <member type="node" ref="29588070" role="stop"/>
        <member type="node" ref="260767430" role="stop"/>
        <member type="node" ref="260767429" role="stop"/>
        <member type="node" ref="260767428" role="stop"/>
        <member type="node" ref="260767427" role="stop"/>
        <member type="node" ref="260767426" role="stop"/>
        <member type="node" ref="260767425" role="stop"/>
        <member type="node" ref="260767424" role="stop"/>
        <member type="node" ref="260767423" role="stop"/>
        <member type="node" ref="260765389" role="stop"/>
        <member type="node" ref="260767422" role="stop"/>
        <member type="node" ref="260769132" role="stop"/>
        <member type="node" ref="27362251" role="stop"/>
        <member type="node" ref="260769651" role="stop"/>
        <member type="node" ref="260769652" role="stop"/>
        <member type="node" ref="256897554" role="stop"/>
        <member type="node" ref="243510337" role="stop"/>
        <member type="node" ref="256897458" role="stop"/>
        <member type="node" ref="256897080" role="stop"/>
        <member type="node" ref="256897079" role="stop"/>
        <member type="node" ref="256897078" role="stop"/>
        <member type="node" ref="256897077" role="stop"/>
        <member type="node" ref="243507791" role="stop"/>
        <member type="node" ref="256896059" role="stop"/>
        <member type="node" ref="256895609" role="stop"/>
        <member type="node" ref="256895321" role="stop"/>
        <member type="node" ref="256443438" role="stop"/>
        <member type="node" ref="256443205" role="stop"/>
        <member type="node" ref="241928557" role="stop"/>
        <member type="node" ref="243486950" role="stop"/>
        <member type="node" ref="256441194" role="stop"/>
        <member type="node" ref="704778" role="stop"/>
        <member type="node" ref="256442276" role="stop"/>
        <member type="node" ref="256442845" role="stop"/>
        <member type="node" ref="255160720" role="stop"/>
        <member type="node" ref="255160722" role="stop"/>
        <tag k="colour" v="#CDC83F"/>
        <tag k="from" v="Pont de Sèvres"/>
        <tag k="line" v="subway"/>
        <tag k="name" v="Métro 9"/>
        <tag k="network" v="RATP"/>
        <tag k="operator" v="RATP"/>
        <tag k="ref" v="9"/>
        <tag k="ref:FR:STIF" v="1001100090001"/>
        <tag k="route" v="subway"/>
        <tag k="short_name" v="M9"/>
        <tag k="twitter" v="Ligne9_RATP"/>
        <tag k="type" v="route"/>
        <tag k="wheelchair" v="no"/>
        <tag k="wikipedia" v="fr:Ligne 9 du métro de Paris"/>
    </relation>
    <relation id="123784" version="60" timestamp="2015-09-22T20:39:37Z" changeset="34192816" uid="138059" user="Truchin">
        <member type="way" ref="184333069" role=""/>
        <member type="way" ref="209249680" role=""/>
        <member type="way" ref="29880258" role=""/>
        <member type="way" ref="20326938" role=""/>
        <member type="way" ref="311825997" role=""/>
        <member type="way" ref="241744596" role=""/>
        <member type="way" ref="241744801" role=""/>
        <member type="way" ref="24788081" role=""/>
        <member type="node" ref="241928757" role="stop"/>
        <member type="node" ref="241928758" role="stop"/>
        <member type="node" ref="243487863" role="stop"/>
        <member type="node" ref="27371900" role="stop"/>
        <member type="node" ref="241928557" role="stop"/>
        <member type="node" ref="27371892" role="stop"/>
        <member type="node" ref="27371889" role="stop"/>
        <member type="node" ref="27371876" role="stop"/>
        <member type="node" ref="27371867" role="stop"/>
        <member type="node" ref="27371864" role="stop"/>
        <member type="node" ref="3175323853" role="stop"/>
        <member type="node" ref="27362260" role="stop"/>
        <member type="node" ref="27362259" role="stop"/>
        <member type="node" ref="27362258" role="stop"/>
        <member type="node" ref="27362256" role="stop"/>
        <member type="node" ref="282635141" role="stop"/>
        <member type="node" ref="3149359080" role="stop"/>
        <member type="node" ref="27362249" role="stop"/>
        <member type="node" ref="243496033" role="stop"/>
        <member type="node" ref="27362240" role="stop"/>
        <member type="node" ref="2493410447" role="stop"/>
        <member type="node" ref="27362238" role="stop"/>
        <member type="node" ref="3148750837" role="stop"/>
        <member type="node" ref="137533248" role="stop"/>
        <tag k="bicycle:conditional" v="yes @ (Su 05:30-16:30)"/>
        <tag k="colour" v="#F2C931"/>
        <tag k="from" v="Château de Vincennes"/>
        <tag k="line" v="subway"/>
        <tag k="name" v="Métro 1"/>
        <tag k="network" v="RATP"/>
        <tag k="operator" v="RATP"/>
        <tag k="ref" v="1"/>
        <tag k="ref:FR:STIF" v="1001100010001"/>
        <tag k="route" v="subway"/>
        <tag k="short_name" v="M1"/>
        <tag k="source" v="http://www.ratp.fr/fr/ratp/r_102432/cyclistes-et-pietons/"/>
        <tag k="to" v="La Défense"/>
        <tag k="twitter" v="Ligne1_RATP"/>
        <tag k="type" v="route"/>
        <tag k="wheelchair" v="no"/>
        <tag k="wikipedia" v="fr:Ligne 1 du métro de Paris"/>
    </relation>
    <relation id="123789" version="38" timestamp="2015-09-22T20:39:45Z" changeset="34192816" uid="138059" user="Truchin">
        <member type="node" ref="255161921" role="stop"/>
        <member type="node" ref="255000799" role="stop"/>
        <member type="node" ref="255162203" role="stop"/>
        <member type="node" ref="243510681" role="stop"/>
        <member type="node" ref="243510680" role="stop"/>
        <member type="node" ref="243510679" role="stop"/>
        <member type="node" ref="243510678" role="stop"/>
        <member type="node" ref="243496029" role="stop"/>
        <member type="node" ref="1981222779" role="stop"/>
        <member type="node" ref="635005158" role="stop"/>
        <member type="node" ref="3542631493" role="station"/>
        <member type="node" ref="243510337" role="stop"/>
        <member type="node" ref="243510336" role="stop"/>
        <member type="node" ref="243510335" role="stop"/>
        <member type="node" ref="243510334" role="stop"/>
        <member type="node" ref="3430515272" role="stop"/>
        <member type="node" ref="243507794" role="stop"/>
        <member type="node" ref="243507793" role="stop"/>
        <member type="node" ref="243507792" role="stop"/>
        <member type="node" ref="3193939360" role="stop"/>
        <member type="node" ref="243507790" role="stop"/>
        <member type="node" ref="243507789" role="stop"/>
        <member type="node" ref="243490762" role="stop"/>
        <member type="node" ref="243507235" role="stop"/>
        <member type="node" ref="243507234" role="stop"/>
        <member type="node" ref="243507233" role="stop"/>
        <member type="way" ref="305397727" role=""/>
        <member type="way" ref="313420251" role=""/>
        <member type="way" ref="313420252" role=""/>
        <member type="way" ref="114120357" role=""/>
        <member type="way" ref="114120358" role=""/>
        <tag k="colour" v="#9A9940"/>
        <tag k="name" v="Métro 3"/>
        <tag k="network" v="RATP"/>
        <tag k="operator" v="RATP"/>
        <tag k="ref" v="3"/>
        <tag k="ref:FR:STIF" v="1001100030001"/>
        <tag k="route" v="subway"/>
        <tag k="short_name" v="M3"/>
        <tag k="stops" v="25"/>
        <tag k="twitter" v="Ligne3_RATP"/>
        <tag k="type" v="route"/>
        <tag k="wheelchair" v="no"/>
        <tag k="wikipedia" v="fr:Ligne 3 du métro de Paris"/>
    </relation>
    <relation id="123792" version="39" timestamp="2015-09-22T20:39:41Z" changeset="34192816" uid="138059" user="Truchin">
        <member type="node" ref="3164606088" role="stop"/>
        <member type="node" ref="27371864" role="stop"/>
        <member type="node" ref="264592424" role="stop"/>
        <member type="node" ref="243507793" role="stop"/>
        <member type="node" ref="3193940961" role="stop"/>
        <member type="node" ref="264591604" role="stop"/>
        <member type="node" ref="243493845" role="stop"/>
        <member type="node" ref="264690372" role="stop"/>
        <member type="node" ref="264692522" role="stop"/>
        <member type="node" ref="2066461402" role="stop"/>
        <member type="node" ref="264690370" role="stop"/>
        <member type="node" ref="264690368" role="stop"/>
        <member type="node" ref="264795933" role="stop"/>
        <member type="way" ref="311826002" role=""/>
        <member type="way" ref="313420250" role=""/>
        <member type="way" ref="349629341" role=""/>
        <tag k="colour" v="#8E6538"/>
        <tag k="line" v="subway"/>
        <tag k="name" v="Métro 11"/>
        <tag k="network" v="RATP"/>
        <tag k="operator" v="RATP"/>
        <tag k="ref" v="11"/>
        <tag k="ref:FR:STIF" v="1001100110001"/>
        <tag k="route" v="subway"/>
        <tag k="short_name" v="M11"/>
        <tag k="stops" v="13"/>
        <tag k="twitter" v="Ligne11_RATP"/>
        <tag k="type" v="route"/>
        <tag k="wheelchair" v="no"/>
        <tag k="wikipedia" v="fr:Ligne 11 du métro de Paris"/>
    </relation>
    <relation id="123799" version="33" timestamp="2015-08-22T13:42:32Z" changeset="33505352" uid="181135" user="Manu1400">
        <member type="node" ref="331524254" role="stop"/>
        <member type="node" ref="260587051" role="stop"/>
        <member type="node" ref="331523267" role="stop"/>
        <member type="node" ref="313430306" role="stop"/>
        <member type="node" ref="313428413" role="stop"/>
        <member type="node" ref="265060965" role="stop"/>
        <member type="node" ref="265060832" role="stop"/>
        <member type="node" ref="265060052" role="stop"/>
        <member type="node" ref="269337982" role="stop"/>
        <member type="node" ref="269337980" role="stop"/>
        <member type="node" ref="249524554" role="stop"/>
        <member type="node" ref="261611470" role="stop"/>
        <member type="node" ref="261611873" role="stop"/>
        <member type="node" ref="261611884" role="stop"/>
        <member type="node" ref="261612240" role="stop"/>
        <member type="node" ref="243496027" role="stop"/>
        <member type="node" ref="331514770" role="stop"/>
        <member type="node" ref="3542631393" role="stop"/>
        <member type="way" ref="348035135" role="platform"/>
        <member type="way" ref="348035136" role="platform"/>
        <member type="node" ref="3542631493" role="station"/>
        <member type="node" ref="260769652" role="stop"/>
        <member type="node" ref="282635141" role="stop"/>
        <member type="node" ref="264473695" role="stop"/>
        <member type="node" ref="245250759" role="stop"/>
        <member type="node" ref="245250758" role="stop"/>
        <member type="node" ref="245250755" role="stop"/>
        <member type="node" ref="1805529567" role="stop"/>
        <member type="node" ref="264704365" role="stop"/>
        <member type="node" ref="264712433" role="stop"/>
        <member type="node" ref="264712432" role="stop"/>
        <member type="node" ref="2023231831" role="stop"/>
        <member type="node" ref="264717964" role="stop"/>
        <member type="node" ref="12388534" role="stop"/>
        <member type="node" ref="12388528" role="stop"/>
        <member type="way" ref="28660069" role=""/>
        <member type="way" ref="27585044" role=""/>
        <member type="way" ref="30097441" role=""/>
        <member type="way" ref="173343615" role=""/>
        <member type="way" ref="24150601" role=""/>
        <member type="way" ref="27866434" role=""/>
        <member type="way" ref="27866435" role=""/>
        <member type="way" ref="117430632" role=""/>
        <member type="way" ref="117430630" role=""/>
        <member type="way" ref="28660210" role=""/>
        <tag k="colour" v="#89C7D6"/>
        <tag k="line" v="subway"/>
        <tag k="name" v="Métro 13"/>
        <tag k="network" v="RATP"/>
        <tag k="operator" v="RATP"/>
        <tag k="ref" v="13"/>
        <tag k="ref:FR:STIF" v="1001100130001"/>
        <tag k="route" v="subway"/>
        <tag k="short_name" v="M13"/>
        <tag k="twitter" v="Ligne13_RATP"/>
        <tag k="type" v="route"/>
        <tag k="wheelchair" v="no"/>
        <tag k="wikipedia" v="fr:Ligne 13 du métro de Paris"/>
    </relation>
    <relation id="123802" version="16" timestamp="2015-08-17T19:19:34Z" changeset="33399581" uid="181135" user="Manu1400">
        <member type="way" ref="24397962" role=""/>
        <member type="node" ref="1997626380" role="stop"/>
        <member type="node" ref="264796181" role="stop"/>
        <member type="node" ref="264796182" role="stop"/>
        <member type="node" ref="243507235" role="stop"/>
        <tag k="colour" v="#89C7D6"/>
        <tag k="name" v="Métro 3bis"/>
        <tag k="network" v="RATP"/>
        <tag k="operator" v="RATP"/>
        <tag k="ref" v="3bis"/>
        <tag k="ref:FR:STIF" v="1001101030001"/>
        <tag k="route" v="subway"/>
        <tag k="short_name" v="M3bis"/>
        <tag k="source:colour" v="opendata RATP"/>
        <tag k="type" v="route"/>
        <tag k="wheelchair" v="no"/>
        <tag k="wikipedia" v="fr:Ligne 3 bis du métro de Paris"/>
    </relation>
    <relation id="123912" version="32" timestamp="2015-09-22T20:39:50Z" changeset="34192816" uid="138059" user="Truchin">
        <member type="node" ref="243496033" role="stop"/>
        <member type="node" ref="260765385" role="stop"/>
        <member type="node" ref="260765387" role="stop"/>
        <member type="node" ref="260765389" role="stop"/>
        <member type="node" ref="260765390" role="stop"/>
        <member type="node" ref="338930214" role="stop"/>
        <member type="node" ref="34909187" role="stop"/>
        <member type="node" ref="34909170" role="stop"/>
        <member type="node" ref="34909171" role="stop"/>
        <member type="node" ref="1659843199" role="stop"/>
        <member type="node" ref="260764273" role="stop"/>
        <member type="node" ref="260763474" role="stop"/>
        <member type="node" ref="1805529567" role="stop"/>
        <member type="node" ref="220289389" role="stop"/>
        <member type="node" ref="220289387" role="stop"/>
        <member type="node" ref="235369898" role="stop"/>
        <member type="node" ref="235370184" role="stop"/>
        <member type="node" ref="235370505" role="stop"/>
        <member type="node" ref="235371392" role="stop"/>
        <member type="node" ref="235371394" role="stop"/>
        <member type="node" ref="235371395" role="stop"/>
        <member type="node" ref="235374383" role="stop"/>
        <member type="node" ref="260762540" role="stop"/>
        <member type="node" ref="260762378" role="stop"/>
        <member type="node" ref="260762379" role="stop"/>
        <member type="node" ref="245455187" role="stop"/>
        <member type="node" ref="264490283" role="stop"/>
        <member type="node" ref="241928557" role="stop"/>
        <member type="way" ref="309532940" role=""/>
        <member type="way" ref="294074586" role=""/>
        <member type="way" ref="136698126" role=""/>
        <member type="way" ref="371959822" role=""/>
        <member type="way" ref="369405313" role=""/>
        <member type="way" ref="21840651" role=""/>
        <member type="way" ref="294074587" role=""/>
        <member type="way" ref="371959816" role=""/>
        <member type="way" ref="21840944" role=""/>
        <member type="way" ref="31739555" role=""/>
        <member type="way" ref="371959819" role=""/>
        <member type="way" ref="31739553" role=""/>
        <member type="way" ref="23622326" role=""/>
        <member type="way" ref="322696992" role=""/>
        <member type="way" ref="24044831" role=""/>
        <member type="way" ref="24369880" role=""/>
        <member type="way" ref="209249678" role=""/>
        <tag k="colour" v="#79BB92"/>
        <tag k="line" v="subway"/>
        <tag k="name" v="Métro 6"/>
        <tag k="network" v="RATP"/>
        <tag k="operator" v="RATP"/>
        <tag k="ref" v="6"/>
        <tag k="ref:FR:STIF" v="1001100060001"/>
        <tag k="route" v="subway"/>
        <tag k="short_name" v="M6"/>
        <tag k="to" v="Nation"/>
        <tag k="twitter" v="Ligne6_RATP"/>
        <tag k="type" v="route"/>
        <tag k="wheelchair" v="no"/>
        <tag k="wikipedia" v="fr:Ligne 6 du métro de Paris"/>
    </relation>
    <relation id="123917" version="37" timestamp="2015-09-22T20:39:43Z" changeset="34192816" uid="138059" user="Truchin">
        <member type="way" ref="334709717" role=""/>
        <member type="way" ref="49992529" role=""/>
        <member type="way" ref="334709718" role=""/>
        <member type="way" ref="24046308" role=""/>
        <member type="way" ref="3839425" role=""/>
        <member type="way" ref="117884563" role=""/>
        <member type="way" ref="117884562" role=""/>
        <member type="way" ref="117884565" role=""/>
        <member type="way" ref="117884564" role=""/>
        <member type="way" ref="117884569" role=""/>
        <member type="way" ref="334709725" role=""/>
        <member type="way" ref="366385022" role=""/>
        <member type="node" ref="241928557" role="stop"/>
        <member type="node" ref="243489718" role="stop"/>
        <member type="node" ref="243490764" role="stop"/>
        <member type="node" ref="243490763" role="stop"/>
        <member type="node" ref="243490762" role="stop"/>
        <member type="node" ref="243490761" role="stop"/>
        <member type="node" ref="243493846" role="stop"/>
        <member type="node" ref="243493845" role="stop"/>
        <member type="node" ref="243493916" role="stop"/>
        <member type="node" ref="1997722992" role="stop"/>
        <member type="node" ref="235377792" role="stop"/>
        <member type="node" ref="329096792" role="stop"/>
        <member type="way" ref="334709728" role="platform"/>
        <member type="node" ref="1762610977" role="stop"/>
        <member type="way" ref="334709727" role="platform"/>
        <member type="node" ref="243494998" role="stop"/>
        <member type="node" ref="243496024" role="stop"/>
        <member type="node" ref="243496025" role="stop"/>
        <member type="node" ref="243496027" role="stop"/>
        <member type="node" ref="243496028" role="stop"/>
        <member type="node" ref="243496029" role="stop"/>
        <member type="node" ref="243496030" role="stop"/>
        <member type="node" ref="2066488458" role="stop"/>
        <member type="node" ref="838533003" role="stop"/>
        <member type="node" ref="243496033" role="stop"/>
        <member type="node" ref="243496728" role="stop"/>
        <member type="node" ref="243496729" role="stop"/>
        <tag k="colour" v="#216EB4"/>
        <tag k="from" v="Nation"/>
        <tag k="line" v="subway"/>
        <tag k="name" v="Métro 2"/>
        <tag k="network" v="RATP"/>
        <tag k="operator" v="RATP"/>
        <tag k="ref" v="2"/>
        <tag k="ref:FR:STIF" v="1001100020001"/>
        <tag k="route" v="subway"/>
        <tag k="short_name" v="M2"/>
        <tag k="stops" v="25"/>
        <tag k="to" v="Porte Dauphine"/>
        <tag k="twitter" v="Ligne2_RATP"/>
        <tag k="type" v="route"/>
        <tag k="wheelchair" v="no"/>
        <tag k="wikipedia" v="fr:Ligne 2 du métro de Paris"/>
    </relation>
    <relation id="2554093" version="13" timestamp="2015-09-22T20:39:51Z" changeset="34192816" uid="138059" user="Truchin">
        <member type="way" ref="196309638" role=""/>
        <member type="way" ref="196309635" role=""/>
        <member type="way" ref="24397854" role=""/>
        <member type="node" ref="264775552" role="stop"/>
        <member type="node" ref="1997722992" role="stop"/>
        <member type="node" ref="243358029" role="stop"/>
        <member type="node" ref="243357000" role="stop"/>
        <member type="node" ref="1997722983" role="stop"/>
        <member type="node" ref="2066461402" role="stop"/>
        <member type="node" ref="264794353" role="stop"/>
        <member type="node" ref="264794354" role="stop"/>
        <tag k="colour" v="#79BB92"/>
        <tag k="name" v="Métro 7 bis"/>
        <tag k="network" v="RATP"/>
        <tag k="operator" v="RATP"/>
        <tag k="ref" v="7bis"/>
        <tag k="ref:FR:STIF" v="1001101070001"/>
        <tag k="route" v="subway"/>
        <tag k="short_name" v="M7bis"/>
        <tag k="type" v="route"/>
        <tag k="wheelchair" v="no"/>
        <tag k="wikipedia" v="fr:Ligne 7 bis du métro de Paris"/>
    </relation>
</osm>
cvvergara commented 7 years ago

This other issue also used mapzen data, this case was with brussels: https://github.com/pgRouting/osm2pgrouting/issues/150 try to use the overpass api to get the data. The brussels example:

BBOX="4.2878,50.8139,4.5023,50.8926"
wget --progress=dot:mega -O "brussels.osm" "http://www.overpass-api.de/api/xapi?*[bbox=${BBOX}][@meta]"
prevostc commented 7 years ago

Thx for your help !