- Downloaded planet file planet-110202.osm.bz2 - Extracted a osm for the zone 43.5N -3.5W | 42N -1W with osmosis : bzcat planet-101027.osm.bz2 | osmosis --read-xml file=/dev/stdin enableDateParsing=no --bounding-box top=43.5 left=-3.5 bottom=42 right=-1 --write-xml file=- | bzip2 > extracted.osm.bz2 It takes 2 hours to complete but it finishes with no errors.
- Clear the API DB : dropdb openstreetmap createdb -E UTF8 -O openstreetmap openstreetmap dropdb osm_test createdb -E UTF8 -O openstreetmap osm_test dropdb osm createdb -E UTF8 -O openstreetmap osm psql -d openstreetmap < /usr/share/postgresql/8.4/contrib/btreet_gist.sql rake db:migrate rake test - Import extracted osm file to the API DB with osmosis : bzcat extracted.osm.bz2 | osmosis --read-xml-0.6 file=- --write-apidb-0.6 populateCurrentTables=yes host="localhost" database="openstreetmap" user="openstreetmap" password="xxx" validateSchemaVersion=no Ends with error : org.openstreetmap.osmosis.core.OsmosisRuntimeException: Unable to load current way nodes. ... Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on table "current_way_nodes" violates foreign key constraint "current_way_nodes_node_id_fkey" Detail: Key (node_id)=(490767853) is not present in table "current_nodes" ... The 'weird' thing is that 490767853 node is out of the bounding box http://www.openstreetmap.org/browse/node/490767853 : 42.3951781, -3.5017794<http://www.openstreetmap.org/?lat=42.3951781&lon=-3.5017794&zoom=18> Am I doing the process to extract+import correctly ? Is there a way to avoid this error ?
_______________________________________________ osmosis-dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/osmosis-dev
