[OSM-dev] Osm2pgsql not importing routes?

[Sven Geggus]

yvecai <yvecai at gmail.com> wrote:

> Which contains 49 relations according to osm2pgsql output, but the 
> following requests find nothing:
> 
>    select count(*) from planet_osm_line where osm_id = -1401913;
>    select count(*) from planet_osm_line where osm_id < 0;
> 
> and the column route_name does not exists.

You might consider importing using a hstore column for test purposes.

"name" will be changed to "route_name" during import and _only_ routes with
a "type=route" tag (well, not the routes themselves, just their members) get
imported at all.

I just tested on a full planet Database featuring hstore and using the most
recent Version of osm2pgsql.

Looks fine IMO:
osm=> select count(*) from planet_osm_line where osm_id = -1401913;
 count 
-------
     1
(1 Zeile)

osm=> select tags from planet_osm_line where osm_id = -1401913;
                                             tags                                              
-----------------------------------------------------------------------------------------------
 "color"=>"green", "piste:type"=>"nordic", "route_name"=>"Haute Joux", "route_pref_color"=>"0"
(1 Zeile)

Regards

Sven

-- 
Das Internet wird vor allem von Leuten genutzt, die sich Pornografie
ansehen, während sie Bier trinken, es ist daher für Wahlen nicht
geeignet (Jaroslaw Kaczynski)
/me is giggls at ircnet, http://sven.gegg.us/ on the Web