Hi all,

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: https://docs.google.com/document/d/1n8g1skzgcvXQF9RtRYNtK2rKdQ_R4JYmC6TNnsGeA9o/edit?hl=en

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: "16136292794W 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 purposes.

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

Thanks
Martijn

--
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: [email protected]
Website: www.geodan.nl
KvK-nummer: 33 247475
Disclaimer: www.geodan.nl/disclaimer
-------------------------------------

_______________________________________________
osmosis-dev mailing list
[email protected]
http://lists.openstreetmap.org/listinfo/osmosis-dev

Reply via email to