[OSM-dev] How to clean up Negative IDs

andrzej zaborowski balrogg at gmail.com
Tue Aug 3 19:48:39 BST 2010


On 3 August 2010 20:28, Eric Wolf <ebwolf at gmail.com> wrote:
> This is in reference to the USGS OSMCP project - not the real OSM...
> When we imported our chunk of data initially (not me - the guy responsible
> is on walkabout in the Rockies), we followed the convention of using
> negative IDs in the .OSM file. But osmosis was used to load the data into
> the database and now all of our data has negative IDs. This seems to have a
> really nasty effect on the API - every time something is edited, a new copy
> is created with positive IDs and the old version with the negative IDs
> persists.
> I assume there is something in the API that says "negative IDs == BAD". I've
> been trying to test that theory but keep hitting stumbling blocks. Postgres
> doesn't seem to want to let me defer integrity constraints, so my efforts to
> change a few IDs to positive values keeps failing. Maybe I've lost my SQL
> chops (or maybe I just can't do that as the "openstreetmap" database user).
> Am I barking up the right tree? Should I just go ahead and destroy the
> database and repopulate it using bulk_upload.py instead of osmosis?

If there's no way disable the postgres contraints (I'm sure there is..
but I'm a sql noob), I'd filter your .osm file through sed removing
the '-' in 'ref="-'  and 'id="-' and reimport with osmosis, or modify
your conversion script.  Using bulk_upload.py and the API will take
ages.

Cheers



More information about the dev mailing list