<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi all, <br>
<br>
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:
<a class="moz-txt-link-freetext" href="https://docs.google.com/document/d/1n8g1skzgcvXQF9RtRYNtK2rKdQ_R4JYmC6TNnsGeA9o/edit?hl=en">https://docs.google.com/document/d/1n8g1skzgcvXQF9RtRYNtK2rKdQ_R4JYmC6TNnsGeA9o/edit?hl=en</a><br>
<br>
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?<br>
<br>
The salient error message for the latest attempt:<br>
<br>
<span class="Apple-style-span" style="border-collapse: separate;
color: rgb(0, 0, 0); font-family: Times; font-style: normal;
font-variant: normal; font-weight: normal; letter-spacing: normal;
line-height: normal; orphans: 2; text-indent: 0px; text-transform:
none; white-space: normal; widows: 2; word-spacing: 0px;
font-size: medium;">
<div style="margin: 0px; background-color: transparent;"><span
id="internal-source-marker_0.17541301809251308"
style="font-size: 8pt; font-family: 'Courier New'; color:
rgb(0, 0, 0); background-color: transparent; font-weight:
normal; font-style: normal; text-decoration: none;
vertical-align: baseline; white-space: pre-wrap;">Caused by:
org.postgresql.util.PSQLException: ERROR: null value in column
"relation_version" violates not-null constraint</span><br>
<span style="font-size: 8pt; font-family: 'Courier New'; color:
rgb(0, 0, 0); background-color: transparent; font-weight:
normal; font-style: normal; text-decoration: none;
vertical-align: baseline; white-space: pre-wrap;"> Where:
COPY relation_members, line 1: "1613<span
class="Apple-tab-span" style="white-space: pre;"> </span>6292794<span
class="Apple-tab-span" style="white-space: pre;"> </span>W
<span class="Apple-tab-span" style="white-space: pre;"> </span>0"</span><br>
<span style="font-size: 8pt; font-family: 'Courier New'; color:
rgb(0, 0, 0); background-color: transparent; font-weight:
normal; font-style: normal; text-decoration: none;
vertical-align: baseline; white-space: pre-wrap;"><span
class="Apple-tab-span" style="white-space: pre;"><br>
</span></span></div>
</span>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.<br>
<br>
Any idea what's going on here? Should we be doing this on a Linux
machine?<br>
<br>
Thanks<br>
Martijn<br>
<pre class="moz-signature" cols="72">--
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: <a class="moz-txt-link-abbreviated" href="mailto:martijn@geodan.nl">martijn@geodan.nl</a>
Website: <a class="moz-txt-link-abbreviated" href="http://www.geodan.nl">www.geodan.nl</a>
KvK-nummer: 33 247475
Disclaimer: <a class="moz-txt-link-abbreviated" href="http://www.geodan.nl/disclaimer">www.geodan.nl/disclaimer</a>
-------------------------------------
</pre>
</body>
</html>