[OSM-dev] Inconsistency in database?

[Frank Bielig]

Hallo,

I found two more inconsistent ways:

45298547:
  http://api.openstreetmap.org/api/0.6/way/45298547
  http://api.openstreetmap.org/api/0.6/way/45298547/1

45770380:
  http://api.openstreetmap.org/api/0.6/way/45770380
  http://api.openstreetmap.org/api/0.6/way/45770380/4

44141527: (from previous mail)
  http://api.openstreetmap.org/api/0.6/way/44141527
  http://api.openstreetmap.org/api/0.6/way/44141527/2

The problem of inconsistency seems to affect more than one way. It might 
be good idea to fix these special ways in database directly.

BR,
Frank

> Hallo,
>
> I just checked the way 44141527. Calling 
> http://api.openstreetmap.org/api/0.6/way/44141527 I get following result:
>
> <osm version="0.6" generator="OpenStreetMap server">
>  <way id="44141527" visible="true" timestamp="2009-11-11T17:31:53Z" 
> version="2" changeset="3091813" user="Eric S" uid="45284">
>    <tag k="boundary" v="national_park"/>
>    <tag k="name" v="Réserve Nosy Hara"/>
>    <tag k="source" v="ANGAP 2007"/>
>  </way>
> </osm>
>
> No node references are returned. Asking for special version with  
> http://api.openstreetmap.org/api/0.6/way/44141527/2 node references 
> are returned:
>
> <osm version="0.6" generator="OpenStreetMap server">
>  <way id="44141527" visible="true" timestamp="2009-11-11T17:31:53Z" 
> user="Eric S" uid="45284" version="2" changeset="3091813">
>    <nd ref="560160550"/>
>    <nd ref="560160548"/>
>    <nd ref="560160549"/>
>    ...
>    <nd ref="560160626"/>
>    <nd ref="560160550"/>
>    <tag k="boundary" v="national_park"/>
>    <tag k="name" v="Réserve Nosy Hara"/>
>    <tag k="source" v="ANGAP 2007"/>
>  </way>
> </osm>
>
> Unfortunately these node references are not valid. This inconsistency 
> seems to be in planet file too. Does anybody has an idea of the 
> reason? Should be a foreign key constraint in database schema? 
> Currently only way id is checked:
>
>     Table "public.way_nodes"
>   Column    |  Type  | Modifiers
> -------------+--------+-----------
> id          | bigint | not null
> node_id     | bigint | not null
> version     | bigint | not null
> sequence_id | bigint | not null
> Indexes:
>    "way_nodes_pkey" PRIMARY KEY, btree (id, version, sequence_id)
>    "way_nodes_node_idx" btree (node_id)
> Foreign-key constraints:
>    "way_nodes_id_fkey" FOREIGN KEY (id, version) REFERENCES ways(id, 
> version)
>
>
>
> Frank
>
>


-- 
Frank Bielig               Tel:   +49 33398 687848
OneStepAhead AG            Fax:   +49 33398 687849
Research & Development     Mobil: +49 177 3339868
Leuschnerstr. 45           eMail: Frank.Bielig at OneStepAhead.de
D-70176 Stuttgart          Web:   http://www.OneStepAhead.de

Firma:                     OneStepAhead AG
Firmensitz/Amtsgericht:    Stuttgart, HRB 22686
Vorstand/Vorsitzender:     Nihat Kücük
Aufsichtsratvorsitzender:  Prof. Dr. Reinhold von Schwerin