Systems design · Custom application
Centralized multi-site location platform
A shared Google Sheet powers an OpenStreetMap-based application embedded across five websites—replacing duplicated location records with one maintainable source of truth.
- Data architecture
- OpenStreetMap
- Google Sheets
- Multi-site
The problem
Five websites needed accurate location information without five separate maintenance workflows. Maintaining each site independently created duplicated work and more opportunities for records to drift.
The work began by separating the source data from its presentation. A shared Google Sheet became the editorial interface, normalized data fed a reusable map application, and the same embed could be used wherever the locations needed to appear.
One update. Five websites. No duplicated work.
The architecture
One central source. A reusable interface. Updates that travel.
The result
One update. Five websites. No duplicated work.
The system gives the organization one understandable place to make an update while preserving a consistent experience across every participating website.
The result reflects the same goal throughout the work: make the experience clearer for users and the system easier for the next person to maintain.