Database backend for a festival WebGIS: schema, spatial data and queries to support event management, visitor navigation and facility lookups.
Project summary
I designed and implemented a spatial database to support a festival mobile/web backend (venues, booths, events, facilities). The database supports proximity queries (nearest facility), event listings, and vendor/booth management. Implementation uses PostgreSQL + PostGIS with spatial indexes and example queries to demonstrate functionality.
