[OSM-dev] No more negative ids in osm2pgsql-imported DB?

Jon Burgess jburgess777 at gmail.com
Sun Feb 10 17:21:12 GMT 2013


On Sun, 2013-02-10 at 17:28 +0100, yvecai wrote:
> I've just updated osm2pgsql from source (osm2pgsql SVN version 0.81.0 
> (64bit id space))
> 
> I don't have no negative ids in my DB anymore ???
> 
> I'm primarily interested in 'route' relations:
>      select count(*) from planet_osm_line where route is not null; -> 
> 2998 OK
>      select count(*) from planet_osm_rels; -> 1579 OK
> 
>      select count(*) from planet_osm_line where osm_id < 0; -> 0 not OK

Seems to be working on Yevaud. For example, this route relation appeared
a few minutes ago:

gis=# select osm_id,route from planet_osm_line where osm_id<-2751100 and route is not null;
  osm_id  | route  
----------+--------
 -2751190 | hiking
 -2751189 | hiking
(2 rows)

http://www.openstreetmap.org/browse/relation/2751189


I remember seeing a similar problem once before which was caused by a
problem with the Geos libraries. A mismatch between the data structures
in Geos header files and the linked library caused all relations to be
silently discarded. Try making sure you only have one set of geos
libraries & headers installed.

   Jon







More information about the dev mailing list