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 the same location records independently across multiple sites created duplicated work and more opportunities for information to drift.
One update. Five websites. No duplicated work.
The architecture
One central source. A reusable interface. Updates that travel.
01Google Sheetone editable source
02Central datanormalized and shared
03Map applicationcustom OpenStreetMap UI
04Reusable embedone interface, anywhere
05Five websitesupdated together
The result
One update. Five websites. No duplicated work.
The strongest outcome is not simply that the interface works. It is that the system is easier to understand, update and trust.
This case-study shell is ready to move to MDX when final project imagery and detailed metrics are available.