[Tile-serving] [osm2pgsql] ids used multiple times (#33)
michael1e23
notifications at github.com
Fri May 31 15:51:24 UTC 2013
Hello,
is it normal behaviour, that the same osm_id is used multiple times in the database? I wanted to use the osm_id as primary key, but this makes it problematic now.
```
osm=# SELECT * from planet_osm_polygon where name = 'München';
osm_id | note | source | created_by | access | addr:housename | addr:housenumber | addr:interpolation | admin_level | aerialway | aeroway | amenity | area | barrier | bicycle | brand | bridge | boundary | building | construction | covered | culvert | cutting | denomination | disused | embankment | foot | generator:source | harbour | highway | historic | horse | intermittent | junction | landuse | layer | leisure | lock | man_made | military | motorcar | name | natural | office | oneway | operator | place | population | power | power_source | public_transport | railway | ref | religion | route | service | shop | sport | surface | toll | tourism | tower:type | tracktype | tunnel | water | waterway | wetland | width | wood | z_order | way_area | timezone | way
--------+------+--------+------------+--------+----------------+------------------+--------------------+-------------+-----------+---------+---------+------+---------+---------+-------+--------+----------------+----------+--------------+---------+---------+---------+--------------+---------+------------+------+------------------+---------+---------+----------+-------+--------------+----------+---------+-------+---------+------+----------+----------+----------+---------+---------+--------+--------+----------+-------+------------+-------+--------------+------------------+---------+-----+----------+-------+---------+------+-------+---------+------+---------+------------+-----------+--------+-------+----------+---------+-------+------+---------+----------+----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-62428 | | | | | | | | 6 | | | | | | | | | administrative | | | | | | | | | | | | | | | | | | | | | | | | München | | | | | | | | | | | | | | | | | | | | | | | | | | | | 0 | 0 | | 0103000020E6100000010000000A00000087E8C6AAF7FA2640FC766DCA700948408D367D2C33FB264092CF2B9E7A0948408B86318E36FB26406231EA5A7B094840DE23F66459FB2640D56E055E770948405473B9C150FB2640357D76C075094840E72ED3403DFB26401F8FCF1A72094840F28B5C8132FB2640BBCF961870094840E784758824FB2640BA2583ED71094840744694F606FB2640E6FE8FB86C09484087E8C6AAF7FA2640FC766DCA70094840
-62428 | | | | | | | | 6 | | | | | | | | | administrative | | | | | | | | | | | | | | | | | | | | | | | | München | | | | | | | | | | | | | | | | | | | | | | | | | | | | 0 | 1e-06 | | 0103000020E61000000100000006000000679EB70C931C274089FB7E202F0A48404B2B7414D61C27405ECA0A8F470A4840E79CE96F531D2740B62BF4C1320A48400675DBCF731D2740CB1E57D92D0A48404DF8A57EDE1C2740E1AD98B6240A4840679EB70C931C274089FB7E202F0A4840
(2 rows)
```
---
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/33
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20130531/3876ff1d/attachment.html>
More information about the Tile-serving
mailing list