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 _______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
