Multiple entries in Entity table for the same building(osm_id)
I was trying to import the exposure data for Luxemburg from PostGIS into spatialite into my local computer (https://git.gfz-potsdam.de/dynamicexposure/globaldynamicexposure/exposure-lib/-/issues/45), but then I got the error : sqlite3.IntegrityError: UNIQUE constraint failed: Entity.quadkey, Entity.osm_id
I realized that the building with the OSM ID 1088134195
in the quadkey 120203220320302111
is assigned with two Entity.ids of 63372882
& 63372853
and this is where I get the error.
After talking to @ds , we think that the builder is not adding the building twice and it probably happens in Rabotnik
. Maybe one of the buildings that we added manually and then changed.
Can you trace this back please?