Custom web app for data-driven delivery district planning
Statistical result layers, BWB/UWB/PLZ/district filters, min/max values, AND/OR polygon logic, KML delivery districts, saved selections, PDF/KML polygon export, and CSV export.
Built an Angular/Firebase web app for Berlin campaign planning with statistical CSV datasets, Google Maps polygons, overlap-based Zustellbezirk calculation, cost visibility, PDF/KML polygon export, and CSV handover.
Statistical result layers, BWB/UWB/PLZ/district filters, min/max values, AND/OR polygon logic, KML delivery districts, saved selections, PDF/KML polygon export, and CSV export.
Campaign areas, statistical results, delivery districts, household counts, and costs had to be compared manually across spreadsheets, maps, and KML data.
Postwurfmanager turns statistical filters into visible map polygons, calculates matching Zustellbezirke by overlap percentage, shows selectable cost data, and exports operational delivery-district IDs.
Postwurfmanager helps users plan area-based distribution campaigns in Berlin without operating professional GIS software. The application combines parsed statistical datasets, Google Maps polygon rendering, BWB/UWB/PLZ/Bezirk filters, overlap-based Zustellbezirk matching, campaign cost visibility, saved selections, and PDF/KML/CSV exports in one browser workflow.
The product needed to connect election and demographic CSV data with map-based polygon selection and postal delivery-district KML files. Users had to filter complex statistical results, understand the selected Berlin areas visually, calculate matching Zustellbezirke, and export delivery-district IDs for downstream campaign execution.
The Angular frontend owns the interactive planning workflow: dataset selection, filter controls, map overlays, delivery-district review, manual polygon selection, and exports. Firebase Hosting, Firestore, and Cloud Functions provide deployment, persistence for saved selections and metadata, and backend support for processing where the workflow needs it.
The system calculates delivery districts from KML polygons against the currently displayed result polygons. A configurable overlap percentage controls the strictness: at 99%, a Zustellbezirk must lie at least 99% inside the selected result polygon before it is automatically selected. Users can then manually select or deselect polygons for a better operational fit.
Postwurfmanager connects dataset import, map selection, polygon matching, cost control, and operational CSV export in one workflow.
The home view lists parsed statistical results such as Europawahl 2024, Abgeordnetenhauswahl 2023, Bundestagswahl 2021, and other imported datasets. Users select relevant result entries and apply filters before the map updates.
The Google Maps view renders selected BWB and UWB polygons, calculated result areas, and matched Zustellbezirke. The planning process stays visual while still producing operational delivery-district data.
The Datensaetze verwalten view lets users upload statistical CSV data so new result layers become available for filtering in the selection screen.
The application replaces manual spreadsheet and map comparison with an interactive planning workflow. Users can explore Berlin visually, refine target areas, calculate overlapping Zustellbezirke, control campaign costs, and export the final delivery-district IDs without direct GIS expertise.