Good call. Grepping now. Might take a while. :)<div><br></div><div>So two other things:</div><div><br></div><div>1) Trying to use osm2pgsql to import the merged .pbf file directly died with a generic error immediately (as opposed to importing the merged XML, which dies 10-15 minutes in). Maybe an error in Osmosis' pbf handling?</div>
<div><br></div><div>2) What's the expected behavior for Osmosis when merging contiguous but non-overlapping extracts? Would I have gotten the same problem if I'd started with .osm.bz2 ?</div><div><br></div><div>Thanks,</div>
<div>~W<br><br><div class="gmail_quote">On Mon, Dec 20, 2010 at 4:59 PM, Jon Burgess <span dir="ltr"><<a href="mailto:jburgess777@gmail.com">jburgess777@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div class="im">On Mon, 2010-12-20 at 16:15 -0500, Will Wilson wrote:<br>
> Hi All,<br>
><br>
><br>
> I sent this to the newbies list, but it might belong better here.<br>
><br>
><br>
> I'm trying to load OSM data for the USA into PostGres 9.0 with<br>
> PostGIS. Downloaded the .pbf extracts for the different US regions<br>
> from Geofabrik, combined them with Osmosis, and wrote the result to<br>
> uncompressed XML like so:<br>
><br>
><br>
> osmosis --rb us-pacific.osm.pbf --rb us-northeast.osm.pbf --rb<br>
> us-south.osm.pbf --rb us-midwest.osm.pbf --rb us-west.osm.pbf<br>
> --merge --merge --merge --merge --wb USA.osm.pbf<br>
> osmosis --rb USA.osm.pbf --wx USA.osm<br>
><br>
><br>
> Now, osm2pgsql fails with the following error:<br>
><br>
><br>
> Processing: Node(62940k) Way(0k) Relation(0k)pgsql_nodes_set -<br>
> bad result during COPY, data 114176303 415528523<br>
> -914342252 \N<br>
><br>
<br>
</div>Try looking for nodes with id="114176303" in the USA.osm file. I suspect<br>
it may be on the border between two areas and may be duplicated in the<br>
XML file. This would violate the primary key condition during the COPY.<br>
<font color="#888888"><br>
Jon<br>
<br>
<br>
<br>
</font></blockquote></div><br></div>