OvertureMaps / OvertureMaps/data
Potential duplicate Prague macrohood divisions
Nobody has claimed this yet.
- Dominant language
- Python
- Stars
- 1.2k
- Forks
- 47
- Avg merge
- 3h 42m
- Merged PRs (30d)
- 1
Description
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 alsosuburb - 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-XversusX
Suggested consideration
Could Overture consider one of the following?
- Conflate the records into one canonical division where geometry, hierarchy, and identity evidence agree.
- Preserve both source objects but publish an explicit equivalence/conflation relationship.
- 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.
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by inspecting the attached cz_prague_divisions_duplicate.parquet file and compare the listed pairs' geometry, hierarchy, OSM types, and Wikidata IDs. The issue does not name source files or tests; work is done when a canonical or equivalence behavior is chosen, implemented, and the 34 pairs—including the excluded Újezd collision—are validated against that decision.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- python
- Domain
- data-engineering
- Issue type
- Bug
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Active
- Clarity
- Mostly clear
- Newbie friendliness
- 45/100