Potential duplicate Prague macrohood divisions

[janpopovic]

Context

In the Overture Czech divisions release: 2026-08-19.0 we identified 34 Prague macrohood pairs where:

• one record is named Praha-X
• the counterpart is named X
• both records have identical Overture point geometry
• both represent Prague divisions
• 24 of the 34 pairs share the same Wikidata ID

The likely cause is that Overture is preserving two related OSM objects:

• an administrative Prague borough relation, usually with OSM local_type=borough
• a suburb/place node, usually with local_type=suburb

Among the confirmed pairs:

• 33 prefixed records are borough
• 1 prefixed record (Praha-Ďáblice) is also suburb
• all 34 unprefixed counterparts are suburb

The attached Parquet file contains both records for every pair.

cz_prague_divisions_duplicate.parquet.zip

Potential issue

These records appear to represent duplicate geographic divisions at the Overture division level. The different OSM types may be meaningful in the source data, but downstream consumers that need one geographic division per area cannot safely retain both records.

This creates issues such as:

• duplicate divisions in administrative hierarchies
• ambiguous place-to-division assignments
• duplicate search and display results
• duplicated macrohood counts
• inconsistent use of Praha-X versus X

Suggested consideration

Could Overture consider one of the following?

1. Conflate the records into one canonical division where geometry, hierarchy, and identity evidence agree.
2. Preserve both source objects but publish an explicit equivalence/conflation relationship.
3. Designate the administrative borough relation as canonical while retaining the suburb record as source provenance or an alternate representation.

If conflated, the canonical display name should probably be the unprefixed form (Troja, not Praha-Troja), while preserving:

• both OSM source record IDs
• both source OSM types
• the shared Wikidata ID where available
• the best available boundary geometry

Confirmed duplicate pairs

Place	Prefixed GERS ID	Unprefixed GERS ID	Prefixed OSM type	Unprefixed OSM type
Lipence	b34adbc1-9497-404f-995a-e14cd73649e2	da81a9ba-4a6d-4e68-8aab-5fb5e309b573	borough	suburb
Slivenec	73212f19-dff1-4030-b77e-f4a0e764ed66	975ea77b-2d19-4471-8715-2eaf4ed0b63a	borough	suburb
Lochkov	3db4c30f-ce5d-4854-a004-e43e98e8cab2	4c349393-43cb-4672-88cb-d1ebe58f2b08	borough	suburb
Velká Chuchle	6eb3505c-975c-437e-b19f-3e31c5cc92f1	336be1a5-9e2e-4550-b873-e0ef95282530	borough	suburb
Kunratice	d4a80819-6a35-4404-a605-0c0798350a18	93b70480-f896-4f21-811e-41b2cb2f40de	borough	suburb
Šeberov	ee5a47e6-226a-44aa-89ef-6c36cd67dfdd	f681eb09-30dc-47df-a666-153b9eaaae39	borough	suburb
Libuš	e10a3860-8a30-4109-b3f0-164b6897b1ef	4109b202-8d43-4cca-b108-0f7198db7c22	borough	suburb
Zbraslav	b7bdc2ee-d1da-495b-94e1-f96f0274ddf8	16fd92ad-6734-4466-9159-4f60d5139ba1	borough	suburb
Nedvězí	ccd926d0-f5e4-4838-8dd9-62184cfb4a1d	c267daa3-b875-412b-9aa8-c25b2dfaf0c5	borough	suburb
Kolovraty	1d3d058c-ba72-466e-a2b8-c0c0d1354a41	c5439289-5fe2-4b85-9fef-125d232355c9	borough	suburb
Benice	d808bab0-219d-4dd6-a3a3-b3126b34a848	c5cf781f-5cbe-4a71-b921-35556b0b8e32	borough	suburb
Křeslice	9f884e8e-1c8f-4282-bf45-ad6488c4e80d	01c75d80-6c50-48e8-b293-b3751c7884e7	borough	suburb
Petrovice	9d738c61-fbcb-4f50-b68a-70d94c4c144b	ddccbf8d-d441-4f98-8893-931a239db67f	borough	suburb
Královice	ec460773-ed23-4ea0-bb52-552c8ad0ad87	dce5eff4-0a1a-44f7-a3bc-98871d8bc3e5	borough	suburb
Koloděje	0535d172-f58d-44dc-8708-fd5038e4084d	86611c1f-8e12-4087-8b65-f8b3f7afc529	borough	suburb
Dubeč	8758fe68-aeff-4631-b87b-87e71df54154	56cd9669-6a25-4305-b16d-b66b6548af19	borough	suburb
Dolní Měcholupy	5454e039-5dec-4fac-9809-d4d43a8b7ebd	d325ed8e-d87c-40e2-b156-8ce75a320f0c	borough	suburb
Štěrboholy	f493898e-f1f4-407a-811f-31257ab86423	57efed94-e7de-45a9-a022-eaf24e534791	borough	suburb
Běchovice	7fb53727-074a-4c0b-96ee-a4b066f30e68	11712809-d0ec-411e-b14f-934cb773d8c5	borough	suburb
Řeporyje	7897149a-ac78-4c76-b2d0-ad6f7aa6e72f	e4404938-5596-4c78-b7de-cc44abf14ca1	borough	suburb
Zličín	ff5b2d93-30f3-49b0-a1c1-a5e14e857cbe	f4f33de0-985a-4d72-97a7-32db9c601962	borough	suburb
Nebušice	962016da-0472-4e9c-8b84-d6249cd8d414	0e2e9617-5425-426c-a8d5-bc5dcbd5ecac	borough	suburb
Troja	03dbebe6-7621-4fd7-8f05-253b7ae849b2	1504a8f6-84f1-4b3a-8da2-778a09e12666	borough	suburb
Suchdol	8d37e93d-5c3a-46b4-919a-dce25394387f	980a7a65-c09b-46e0-9cb5-f5d244b58e37	borough	suburb
Lysolaje	f4becf88-8ad0-41ec-af73-5f9232ed8bbb	e090bba4-8d4a-4d83-9202-2f3b7cad1ec8	borough	suburb
Přední Kopanina	c089f507-939b-4259-8bb3-9d827019cf53	620bb569-75aa-483a-a233-b22d07732b73	borough	suburb
Březiněves	b9eed0ae-73ce-4367-b4df-17ccff0137a0	0778e9c6-ec52-4280-9719-4b71b77a7377	borough	suburb
Dolní Chabry	bce6d502-15a1-44e0-8a5a-de4d93a356d6	82292599-8268-473e-a99e-f6d5895f5e10	borough	suburb
Ďáblice	6ac67c07-e062-4c6b-8231-9bf2f7c9171c	f7490be1-2e7d-4f24-9cfb-2ed58230851a	suburb	suburb
Čakovice	76023ab2-cb96-4354-b7af-bc34617913ec	6e61dc59-6aa6-4bf9-a539-5f1b1e09a66e	borough	suburb
Vinoř	e141d2a5-090a-4bad-b191-006276f631ad	9eece99c-710c-48b0-8b98-2e8c34a38798	borough	suburb
Satalice	3ccca143-71d3-465c-aa6f-93a61fceef40	d2b2ce89-218a-4bd5-9da8-a9e3d2d35b1b	borough	suburb
Dolní Počernice	8acea9e4-98dd-4883-8c94-2c9a212cacb2	0593614b-6eb6-492e-aec2-123db002b26d	borough	suburb
Klánovice	7a3f1b50-184d-409e-ba8d-ded1efc12471	f20167c0-1b71-4c9c-af83-13a26b42f2fa	borough	suburb

Excluded name collision

Praha-Újezd and Újezd were not included because they have different geometry, parent hierarchy, and Wikidata identity. They should not be conflated based on name alone.