[OSM-dev] Osm2pgsql not importing routes?

yvecai yvecai at gmail.com
Sun Feb 26 17:31:07 GMT 2012


With route_name or not in default.style, in slim or non-slim mode, with 
or without hstore, still no relations in planet_osm_line !

I just added the following entry in default.style:

    way    piste:type    text    linear
    way       route_name       text     linear

If I take the hstore option (-k), I have the relation in planet_osm_rels:

    select * from planet_osm_rels where id = 1401913;
        id    | way_off | rel_off |        parts        |          
    members           |                                 
    tags                                  | pending
    ---------+---------+---------+---------------------+-----------------------------+------------------------------------------------------------------------+---------
      1401913 |       0 |       2 | {48769799,97599611} |
    {w97599611,"",w48769799,""} |
    {type,route,route,ski,piste:type,nordic,name,"Haute
    Joux",color,green} | f

However, it is not in_planet_osm_line.

    select * from planet_osm_line where osm_id = -1401913; -> null

To make this test, I directly get a small extract from the export page 
to be sure my osm file is ok, if somebody is cool enough to test, it's 
available here (1.6MB) http://www.pistes-nordiques.org/download/map.osm.

I use ubuntu 10.04,  postgresql 8.4.10, postgis 2.0, libgeos 3.2.2.

Find here the complete osm2pgsql install and output: 
http://www.pistes-nordiques.org/download/osm2pgsql.out

Yves
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20120226/430d4956/attachment.html>


More information about the dev mailing list