Berlin's War on Duplicate Images in Public Records: How the Capital Stacks Up Against Amsterdam and Vienna

Berlin's Senate Department for Urban Development and Housing confirmed this spring that its digitised building permit archive — spanning records dating back to 1998 — contained an estimated 340,000 duplicate image files, inflating storage costs and slowing planning application processing across all twelve of the city's boroughs. The cleanup effort, now entering its operational phase after months of preparation, has turned the German capital into an unlikely test case for how large European cities manage the unglamorous but increasingly expensive problem of redundant visual data in public sector databases.

The timing matters. Berlin's housing shortage has pushed planning departments to process applications faster than at any point in the past decade. Every bottleneck — including clogged digital archives — translates directly into delays on new construction approvals, a politically sensitive issue for the SPD-led Senate coalition that has staked part of its credibility on accelerating homebuilding in districts like Tempelhof-Schöneberg and Marzahn-Hellersdorf. Duplicate images embedded in permit files slow automated document-reading systems, forcing case workers at offices on Württembergische Straße to intervene manually.

The Senatsverwaltung für Stadtentwicklung, Bauen und Wohnen partnered with the Zentraler IT-Dienstleister des Landes Berlin — known as ZIT.BB — to deploy a deduplication pipeline beginning in March 2026. The project targets the central GIS-linked document management system used by borough planning offices from Pankow to Steglitz-Zehlendorf. According to the project brief published on the Senate's open-data portal in February, the first audit phase identified redundant files consuming roughly 2.1 terabytes of primary storage, at an annual hosting cost the department put at approximately €47,000.

What Amsterdam and Vienna Are Doing Differently

Berlin is not alone in confronting this problem, but its scale and the fragmentation of its borough-level administration make the challenge distinctly complicated. Amsterdam's Gemeente Amsterdam completed a comparable deduplication exercise across its spatial planning database in late 2024, working with a contracted data engineering team over six months. The Dutch capital's unified municipal IT structure — it operates a single planning platform across all city districts — allowed a faster rollout than Berlin's federated model, where each of the twelve boroughs historically maintained semi-autonomous records systems before partial centralisation under the 2021 Berlin E-Government Act.

Vienna's MA 41 spatial data authority took a different route, embedding real-time duplicate detection directly into its document upload interface so that redundant images are flagged at the point of entry rather than discovered retrospectively. That architecture, in place since January 2025, has reduced retrospective cleanup workloads by a margin the city cited in its 2025 digital transformation report, though Berlin planners contacted for background on this piece noted that Vienna's smaller total archive volume makes direct comparison difficult.

London's planning authorities present a more cautious model. The Greater London Authority and individual borough councils each operate separate document systems with no shared deduplication protocol, a structural gap that a 2025 audit by the Local Government Association flagged as generating redundant storage costs across the capital. Berlin administrators have quietly pointed to London as the example they are trying not to become.

What Happens Next for Berliner Applicants

ZIT.BB has set a completion target of the fourth quarter of 2026 for the first full deduplication pass across the archive. From that point, updated submission guidelines will require all documents uploaded to the planning portal to pass an automated hash-check before they are accepted — the same basic mechanism Vienna uses, adapted for Berlin's existing infrastructure.

For architects and developers filing applications through the city's eBauantrag online portal, the practical effect should eventually be shorter processing queues. Planning consultants working out of offices along the Kurfürstendamm corridor say the current manual workarounds add between three and seven working days to complex permit reviews — time that compounds when applications involve multiple properties or phased construction schedules.

The Senate's digital infrastructure team has indicated it will publish a progress report by September 2026. Whether the borough offices in Mitte and Friedrichshain-Kreuzberg, which handle some of the city's heaviest application volumes, will hit that timeline is the question practitioners are watching most closely.