[OSM-dev] Osmosis and full history planet

Martijn van Exel martijn at geodan.nl
Fri Mar 4 07:25:56 GMT 2011

Hi all,

I recently posted this to osmosis-dev but I think there may be some 
folks knowledgeable on this around here too:

We have been trying to import an extract (bbox) of the full history 
planet file into a PostGIS database using the osmosis db schema. Without 
much success so far. We described the steps we took here: 

As you can see we have been following the history-specific threads on 
this list and dev, but we got stuck. Maybe something is amiss with the 
planet file, or should we be looking elsewhere?

The salient error message for the latest attempt:

Caused by: org.postgresql.util.PSQLException: ERROR: null value in 
column "relation_version" violates not-null constraint
  Where: COPY relation_members, line 1: "1613 6292794 W     0"

What we want to end up with is a PostGIS database that has all current 
and historic nodes, ways and relations + their attributes for analysis 

Any idea what's going on here? Should we be doing this on a Linux machine?

Martijn van Exel
Senior Researcher
Geodan S&R
President Kennedylaan 1
1079 MB Amsterdam (NL)
Tel: +31 (0)20 - 5711 318
Fax: +31 (0)20 - 5711 333
E-mail: martijn at geodan.nl
Website: www.geodan.nl
KvK-nummer: 33 247475
Disclaimer: www.geodan.nl/disclaimer

More information about the dev mailing list