ah..now..I am pretty sure that osm2pgsql only processes a limited set of relation types. From the <a href="https://github.com/openstreetmap/osm2pgsql">readme</a> file:<blockquote style="margin:0 0 0 40px;border:none;padding:0px">
<blockquote style="margin:0 0 0 40px;border:none;padding:0px"><div><pre style="margin-top:0px;margin-bottom:0px;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;font:normal normal normal 12px/normal 'Bitstream Vera Sans Mono',Courier,monospace;font-size:17px;white-space:pre-wrap;background-color:rgb(255,255,255)">
6) The relations are parsed. Osm2pgsql has special handling for a</pre></div></blockquote><blockquote style="margin:0 0 0 40px;border:none;padding:0px"><div><pre style="margin-top:0px;margin-bottom:0px;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;font:normal normal normal 12px/normal 'Bitstream Vera Sans Mono',Courier,monospace;font-size:17px;white-space:pre-wrap;background-color:rgb(255,255,255)">
limited number of types: multipolygon, route, boundary</pre></div></blockquote><blockquote style="margin:0 0 0 40px;border:none;padding:0px"><div><pre style="margin-top:0px;margin-bottom:0px;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;font:normal normal normal 12px/normal 'Bitstream Vera Sans Mono',Courier,monospace;font-size:17px;white-space:pre-wrap;background-color:rgb(255,255,255)">
The code will build the appropriate geometries by referencing the</pre></div></blockquote><blockquote style="margin:0 0 0 40px;border:none;padding:0px"><div><pre style="margin-top:0px;margin-bottom:0px;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;font:normal normal normal 12px/normal 'Bitstream Vera Sans Mono',Courier,monospace;font-size:17px;white-space:pre-wrap;background-color:rgb(255,255,255)">
members and outputing these into the database.</pre></div></blockquote></blockquote><div><br></div><div>On my database I can do :</div><blockquote style="margin:0 0 0 40px;border:none;padding:0px"><blockquote style="margin:0 0 0 40px;border:none;padding:0px">
<div>select name,route from planet_osm_line where osm_id<0;</div></blockquote></blockquote><div>and get a log list of relations with things like this in my default.style file.</div><blockquote style="margin:0 0 0 40px;border:none;padding:0px">
<blockquote style="margin:0 0 0 40px;border:none;padding:0px"><div><div>node,way religion text nocache</div></div></blockquote><blockquote style="margin:0 0 0 40px;border:none;padding:0px"><div><div>node,way route text linear</div>
</div></blockquote><blockquote style="margin:0 0 0 40px;border:none;padding:0px"><div><div>node,way service text linear</div></div></blockquote></blockquote><div>I do not think I told it to do anything special to include route relations.</div>
<div><br></div><div>Are you trying to use a different sort of relation?</div><div><br></div><div>Graham.</div><div><br></div><div><br><div class="gmail_quote">On 22 January 2012 19:03, Morten Olsen Lysgaard <span dir="ltr"><<a href="mailto:morten@lysgaard.no">morten@lysgaard.no</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">On 01/22/2012 06:22 PM, Graham Jones wrote:<br>
> I think that osm2pgsql stores relations in the relevant line or polygon<br>
> table with an id of -1 * the relation ID - try searching for relations<br>
> with negative IDs and see if that is what you are looking for.<br>
<br>
I can't even get osm2gpsql to import the relations in my database. What's required of one and what required of the style file for one to be included?<br>
<br>
______________________________<u></u>_________________<br>
dev mailing list<br>
<a href="mailto:dev@openstreetmap.org" target="_blank">dev@openstreetmap.org</a><br>
<a href="http://lists.openstreetmap.org/listinfo/dev" target="_blank">http://lists.openstreetmap.<u></u>org/listinfo/dev</a><br>
</blockquote></div><br><br clear="all"><div><br></div>-- <br>Graham Jones<div>Hartlepool, UK.</div><br>
</div>