[OSM-talk] Oh dear - planet has duplicate id's

[Dan Moore]

wow - and you know what, it's true - somehow there is no primary / uniqueness constraint on that id:

http://trac.openstreetmap.org/browser/sites/rails_port/db/create_database.sql#L69

same goes for current_nodes - compare with current_ways (line 110) which has appropriate primary key declaration.  i see you've filed a ticket on this. perhaps we should move any further discussion to dev at openstreetmap.org.

cheers, dan.

----- Original Message ----
From: David Earl <david at frankieandshadow.com>
To: OSM <talk at openstreetmap.org>
Sent: Wednesday, May 30, 2007 6:42:54 PM
Subject: [OSM-talk] Oh dear - planet has duplicate id's

Oh dear, today's planet file contains two pairs of duplicate segments: they
have the same id. Surely id's are unique, yes? Isn't that the point? It
doesn't look like they are new, but it wasn't like this last week or I'd
have noticed.

(There may be others, but my program crashed trying to do an insert on a
duplicate primary key)

Excerpt below... 18591604 and 18591605 are the culprits, and this is a
contiguous section of the file.

(Also, note that 18591606 doesn't have any useful tags and 18591607 is
empty.)

David

----------------------
  <segment id="18591603" from="22542877" to="22542874"
timestamp="2007-05-11T08:24:21+01:00">
    <tag k="created_by" v="almien_coastlines" />
    <tag k="source" v="PGS(could be inacurately)" />
  </segment>
  <segment id="18591604" from="22542876" to="22542878"
timestamp="2006-12-31T00:20:10+00:00">
    <tag k="natural" v="coastline" />
    <tag k="created_by" v="almien_coastlines" />
    <tag k="source" v="PGS" />
  </segment>
  <segment id="18591605" from="22542869" to="22542875"
timestamp="2006-12-31T00:20:10+00:00">
    <tag k="natural" v="coastline" />
    <tag k="created_by" v="almien_coastlines" />
    <tag k="source" v="PGS" />
  </segment>
  <segment id="18591604" from="22542876" to="22542878"
timestamp="2006-12-31T00:20:10+00:00">
    <tag k="natural" v="coastline" />
    <tag k="created_by" v="almien_coastlines" />
    <tag k="source" v="PGS" />
  </segment>
  <segment id="18591605" from="22542869" to="22542875"
timestamp="2006-12-31T00:20:10+00:00">
    <tag k="natural" v="coastline" />
    <tag k="created_by" v="almien_coastlines" />
    <tag k="source" v="PGS" />
  </segment>
  <segment id="18591606" from="22542879" to="22542877"
timestamp="2007-05-11T08:24:37+01:00">
    <tag k="created_by" v="almien_coastlines" />
    <tag k="source" v="PGS(could be inacurately)" />
  </segment>
  <segment id="18591607" from="22542173" to="22542182"
timestamp="2006-12-31T00:20:10+00:00"/>
  <segment id="18591608" from="22542880" to="22542881"
timestamp="2006-12-31T00:20:10+00:00">
    <tag k="natural" v="coastline" />
    <tag k="created_by" v="almien_coastlines" />
    <tag k="source" v="PGS" />
  </segment>


_______________________________________________
talk mailing list
talk at openstreetmap.org
http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/talk





       
____________________________________________________________________________________Looking for a deal? Find great prices on flights and hotels with Yahoo! FareChase.
http://farechase.yahoo.com/