You are not logged in.
- Topics: Active | Unanswered
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.***
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.***
Pages: 1
#1 2019-10-23 10:57:43
- Andrew Jilin
- Member
- Registered: 2019-10-23
- Posts: 1
Дубли в таблице BOUNDARY_POLYGON
Добрый день!
Загрузил с сайта https://data.nextgis.com/ два файл shape-1c со слоями новой Москвы и МО.
После загрузки в базе в таблице BOUNDARY_POLYGON нахожу кучу дублей по OSM_ID (см. запрос ниже).
Это почему?
SELECT * from OBIEE_MAPS.BOUNDARY_POLYGON t1
INNER JOIN OBIEE_MAPS.BOUNDARY_POLYGON t2 ON
t1.OSM_ID = t2.OSM_ID);
Offline
#2 2019-10-24 15:55:36
- alexey_zakharenkov
- Member
- From: Московская область
- Registered: 2015-12-09
- Posts: 87
Re: Дубли в таблице BOUNDARY_POLYGON
Может потому что отдельная запись создаётся на каждую линию-член мультиполигона? По крайней мере так делает osm2pgsql.
Offline
Pages: 1