Is there a reason why osm2pgsql produces negative osm_id values?

I am examining data imported into a PostGIS database with osm2pgsql and I have noticed some values in the osm_id (which I assume is unique) are negative. Is that ok?

osm2pgsql osm_id

asked 18 Jan '11, 13:28

Tomas Pajonk
191●8●8●17
accept rate: 0%

edited 21 Jan '11, 09:17

TomH ♦♦
3.3k●8●39●43

One Answer:

active answers oldest answers newest answers popular answers

osm_id is only unique within element types in OSM database (but not in osm2pgsql schema, see the comment from pnorman below). So the same osm_id can apply to a node, a way and a relation. That's why osm2pgsql polygon table changes the sign of the relation id when it comes from relations and the original positive way id when it comes from simple closed ways.

permanent link

answered 18 Jan '11, 13:49

Pieren
9.8k●20●83●157
accept rate: 15%

edited 03 Jul '14, 12:12

Thank you.

(18 Jan '11, 17:00) Tomas Pajonk

More background Information is in Wiki http://wiki.openstreetmap.org/wiki/Osm2pgsql/schema#Processed_Data

(02 Apr '13, 14:13) geekQ

osm_id is not unique in osm2pgsql's tables. Long ways are split by osm2pgsql into multiple rows with the same osm_id and multipolygons with distinct areas are also split into multiple rows.

(29 Sep '13, 05:58) pnorman

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Question tags:

osm2pgsql ×263
osm_id ×10

question asked: 18 Jan '11, 13:28

question was seen: 11,650 times

last updated: 03 Jul '14, 12:12

Is there a reason why osm2pgsql produces negative osm_id values?

Follow this question

Related questions