You are not logged in.

Announcement

*** NOTICE: forum.openstreetmap.org is being retired. Please request a category for your community in the new ones as soon as possible using this process, which will allow you to propose your community moderators.
Please create new topics on the new site at community.openstreetmap.org. We expect the migration of data will take a few weeks, you can follow its progress here.***

#1 2015-04-27 08:37:51

mLohmann
Member
Registered: 2015-04-27
Posts: 2

Negative IDs in planet_osm_polygon

Hello, after I imported the osm data with osm2pgsql in my PostgreSQL database, I noticed some negative oms_ids in the table 'planet_osm_polygon'.
My Problem is now that I need to make a link to the table 'planet_osm_ways' where the corresponding entry doesn't have the same ID anymore.
So how do I get the link between these two tables?

positive ID: planet_osm_polygon.osm_id = 2452897
                   planet_osm_ways.id = 2452897

negative ID: planet_osm_polygon.osm_id = -2812465
                    planet_osm_ways.id = 4599230

Thanks for any help.

Offline

#2 2015-04-27 19:42:22

SimonPoole
Member
Registered: 2010-03-14
Posts: 2,195

Re: Negative IDs in planet_osm_polygon

IMHO osm2pgsql will not "invent" new ids, it -will- however create extra entries for polygons that are members of relations with the neg. id of the relation see http://wiki.openstreetmap.org/wiki/Osm2pgsql/schema

Offline

Board footer

Powered by FluxBB