<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
<title></title>
</head>
<body text="#000000" bgcolor="#ffffff">
Hi,<br>
<br>
thank you, Brett, for me this is the perfect setup. I hope that
others will find it useful as well. The names are OK. Two problems:<br>
<br>
1) I read XML or PBF, dump it to CSV and then read the dump, but now
my feature tables are blank because of these errors:<br>
<br>
ERROR: extra data after last expected column<br>
CONTEXT: COPY nodes, line 1: "125799 5 45445 2010-09-30
21:23:30+0200 5922698
0101000020E610000034034B64D592214088BE164F98894A40"<br>
ERROR: extra data after last expected column<br>
CONTEXT: COPY ways, line 1: "3999478 17 4473 1970-01-07
21:53:09+0100 4957195
"mapping_status"=>"incomplete","highway"=>"secondar..."<br>
ERROR: extra data after last expected column<br>
CONTEXT: COPY relations, line 1: "2952 23 29975 1970-01-15
10:56:44+0100 5014762 "type"=>"multipolygon""<br>
<br>
I use COPY instead of \copy like this:<br>
<br>
COPY nodes FROM 'path/to/nodes.txt';<br>
...<br>
<br>
I don't know why this happens. The number and type of columns of the
simple schema table and the CSV do fit.<br>
<br>
Reading straight into database works (but is much slower).<br>
<br>
2) <span class="mw-headline" id="--write-pgsimp-change_.28--wsc.29">--write-pgsimp-change</span><span
class="Apple-style-span" style="border-collapse: separate; color:
rgb(0, 0, 0); font-family: sans-serif; font-size: 16px;
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;"><span class="Apple-style-span"
style="font-size: 13px; line-height: 19px;"></span></span>
results in this error log:<br>
<br>
Nov 20, 2010 2:49:20 PM org.openstreetmap.osmosis.core.Osmosis run<br>
INFO: Osmosis Version SNAPSHOT-r24310<br>
Nov 20, 2010 2:49:20 PM org.openstreetmap.osmosis.core.Osmosis run<br>
INFO: Preparing pipeline.<br>
Nov 20, 2010 2:49:20 PM org.openstreetmap.osmosis.core.Osmosis run<br>
INFO: Launching pipeline execution.<br>
Nov 20, 2010 2:49:20 PM org.openstreetmap.osmosis.core.Osmosis run<br>
INFO: Pipeline executing, waiting for completion.<br>
Nov 20, 2010 2:49:23 PM
org.openstreetmap.osmosis.core.pipeline.common.ActiveTaskManager
waitForCompletion<br>
SEVERE: Thread for task 1-read-replication-interval failed<br>
org.openstreetmap.osmosis.core.OsmosisRuntimeException: Unable to
insert action with type=NODE, action=MODIFY and id=996097244.<br>
at
org.openstreetmap.osmosis.pgsimple.v0_6.impl.ActionDao.addAction(ActionDao.java:80)<br>
at
org.openstreetmap.osmosis.pgsimple.v0_6.impl.EntityDao.modifyEntity(EntityDao.java:263)<br>
at
org.openstreetmap.osmosis.pgsimple.v0_6.impl.NodeDao.modifyEntity(NodeDao.java:74)<br>
at
org.openstreetmap.osmosis.pgsimple.v0_6.impl.ChangeWriter.write(ChangeWriter.java:123)<br>
at
org.openstreetmap.osmosis.pgsimple.v0_6.impl.ActionChangeWriter.process(ActionChangeWriter.java:48)<br>
at
org.openstreetmap.osmosis.core.container.v0_6.NodeContainer.process(NodeContainer.java:58)<br>
at
org.openstreetmap.osmosis.pgsimple.v0_6.PostgreSqlChangeWriter.process(PostgreSqlChangeWriter.java:71)<br>
at
org.openstreetmap.osmosis.core.sort.v0_6.ChangeSorter.complete(ChangeSorter.java:64)<br>
at
org.openstreetmap.osmosis.replication.v0_6.ReplicationDownloader.processComplete(ReplicationDownloader.java:93)<br>
at
org.openstreetmap.osmosis.replication.v0_6.BaseReplicationDownloader.runImpl(BaseReplicationDownloader.java:284)<br>
at
org.openstreetmap.osmosis.replication.v0_6.BaseReplicationDownloader.run(BaseReplicationDownloader.java:345)<br>
at java.lang.Thread.run(Thread.java:619)<br>
Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key
value violates unique constraint "pk_actions"<br>
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)<br>
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)<br>
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)<br>
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)<br>
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)<br>
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321)<br>
at
org.openstreetmap.osmosis.pgsimple.v0_6.impl.ActionDao.addAction(ActionDao.java:77)<br>
... 11 more<br>
Nov 20, 2010 2:49:23 PM org.openstreetmap.osmosis.core.Osmosis main<br>
SEVERE: Execution aborted.<br>
org.openstreetmap.osmosis.core.OsmosisRuntimeException: One or more
tasks failed.<br>
at
org.openstreetmap.osmosis.core.pipeline.common.Pipeline.waitForCompletion(Pipeline.java:146)<br>
at org.openstreetmap.osmosis.core.Osmosis.run(Osmosis.java:92)<br>
at org.openstreetmap.osmosis.core.Osmosis.main(Osmosis.java:37)<br>
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br>
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<br>
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<br>
at java.lang.reflect.Method.invoke(Method.java:597)<br>
at
org.codehaus.plexus.classworlds.launcher.Launcher.launchStandard(Launcher.java:329)<br>
at
org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:239)<br>
at
org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:409)<br>
at
org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:352)<br>
at org.codehaus.classworlds.Launcher.main(Launcher.java:31)<br>
<br>
Is it always guaranteed that a change for datatype/id is unique?<br>
<br>
Am 20.11.10 07:27, schrieb Brett Henderson:
<blockquote
cite="mid:AANLkTim9QmCmStVtFa___3jgYxKoR4okXHXvo+RTjgNf@mail.gmail.com"
type="cite">
<div class="gmail_quote">On Sat, Nov 20, 2010 at 12:09 PM, Brett
Henderson <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:brett@bretth.com">brett@bretth.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt
0.8ex; border-left: 1px solid rgb(204, 204, 204);
padding-left: 1ex;">
Hmm, I've given all of this a bit more thought. Perhaps there
is a need for a "simple" schema that is easy for people to
populate and utilise. I'm quite happy with hstore, but it's
not as simple for those familiar with basic SQL.<br>
<br>
The original reason I created the so-called simple schema was
to support improved bounding box functionality because I
couldn't do it via flat files efficiently. It was called
"simple" because I was also working on a full history schema
that I never found time to complete. My intent has always
been to optimise for accurate bounding box query performance
and not simplicity so the name is something of a misnomer.<br>
<br>
Anyway, perhaps I should re-instate the old tasks and run them
alongside the new ones. I'll have to re-think the naming of
these tasks and schemas. Perhaps "simple" and "snapshot" or
something ...<br>
<br>
But I don't know when I'll get to do this. I'm very time poor
at the moment.</blockquote>
<div><br>
Okay, that wasn't too painful. I found an hour or two to
today so I've created new (actually old) tasks and documented
them here:<br>
<a moz-do-not-send="true"
href="http://wiki.openstreetmap.org/wiki/Osmosis/Detailed_Usage_0.39#PostGIS_Tasks_.28Simple_Schema.29">http://wiki.openstreetmap.org/wiki/Osmosis/Detailed_Usage_0.39#PostGIS_Tasks_.28Simple_Schema.29</a><br>
<br>
It's available in SVN for now. These "new" tasks are just the
old tasks retrieved out of SVN history and renamed. Note that
these tasks are effectively at a dead end because any new
development is likely to proceed on the new hstore schema.
They should continue to work for the foreseeable future.<br>
</div>
</div>
<br>
I'll probably cause further confusion with schema names. But I'm
now calling the new style hstore schema the "pgsnapshot" schema,
and the older tag table style schema the "pgsimple" schema. I'm
open to suggestions, but any change will need to be reflected on
the wiki and in the codebase.<br>
<br>
Brett<br>
<br>
</blockquote>
<br>
</body>
</html>