<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
I've read that osm2pgsql doesn't really import everything from an
OSM file into the DB. Specifically,
<a class="moz-txt-link-freetext" href="http://wiki.openstreetmap.org/wiki/Osm2pgsql/schema">http://wiki.openstreetmap.org/wiki/Osm2pgsql/schema</a> says:<br>
<br>
<blockquote type="cite">Notice that relations are not imported
directly. Ways which are members of relations are imported in a
special manner (see description for planet_osm_line), but there is
no easy way to establish a relationship between a relation and its
members, or to get tags associated with a relation (unless they
have ways as members).
</blockquote>
<br>
Also:<br>
<br>
<blockquote type="cite">Note that the mechanism of creating
additional rows for each relation membership, with the tags of the
relation, does <b>not</b> apply to nodes. That is, with the
current scheme, there is no way to get parent relation data for a
given node.
</blockquote>
<br>
which, conjunction with the following from
<a class="moz-txt-link-freetext" href="http://wiki.openstreetmap.org/wiki/Osm2pgsql#From_source_.28generic.29">http://wiki.openstreetmap.org/wiki/Osm2pgsql#From_source_.28generic.29</a>,
may explain the lack of the route_name column.<br>
<br>
<blockquote type="cite">The default style for osm2pgsql does not
import all tags from an .OSM file to a pgsql database. see <a
href="http://svn.openstreetmap.org/applications/utils/export/osm2pgsql/default.style"
class="external free" rel="nofollow">http://svn.openstreetmap.org/applications/utils/export/osm2pgsql/default.style</a>
for a list of what keys are imported.
</blockquote>
<br>
I wonder if that's part of what you're running into?<br>
<br>
Lynn (D) - KJ4ERJ - Author of APRSISCE for Windows Mobile and Win32<br>
<br>
<br>
On 2/23/2012 3:20 PM, yvecai wrote:
<blockquote cite="mid:4F469F80.3010902@gmail.com" type="cite">
<meta http-equiv="content-type" content="text/html;
charset=ISO-8859-1">
Sorry, I took the subject from an old topic.<br>
<br>
Here an extract of my osm file:<br>
<blockquote><relation id="1401913" version="1"
timestamp="2011-01-31T21:31:42Z" changeset="7149413"
uid="171657" user="yvecai"><br>
<member type="way" ref="48769799" role=""/><br>
<member type="way" ref="97599611" role=""/><br>
<tag k="color" v="green"/><br>
<tag k="name" v="Haute Joux"/><br>
<tag k="piste:type" v="nordic"/><br>
<tag k="route" v="ski"/><br>
<tag k="type" v="route"/><br>
</relation><br>
</blockquote>
Which contains 49 relations according to osm2pgsql output, but the
following requests find nothing:<br>
<blockquote>select count(*) from planet_osm_line where osm_id =
-1401913;<br>
select count(*) from planet_osm_line where osm_id < 0;<br>
</blockquote>
and the column route_name does not exists.<br>
<br>
osm2pgsql SVN version 0.80.0<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
dev mailing list
<a class="moz-txt-link-abbreviated" href="mailto:dev@openstreetmap.org">dev@openstreetmap.org</a>
<a class="moz-txt-link-freetext" href="http://lists.openstreetmap.org/listinfo/dev">http://lists.openstreetmap.org/listinfo/dev</a>
</pre>
</blockquote>
<br>
</body>
</html>