yvecai <yve...@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@ircnet, http://sven.gegg.us/ on the Web _______________________________________________ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev