Geospatial web application
Community Services Explorer
A geospatial web application for exploring public schools in nine contiguous communities of the San Bernardino Valley and examining population and land within a straight-line radius of schools.
Problem space
The project brings school locations and community population data together so users can explore school coverage across the San Bernardino Valley.
Project approach
An interactive map supports filters by community and school type, school attribute pop-ups, proximity coverage, and comparative population and area statistics.
Engineering
Architecture
California public-school and Census sources flow through a Python and GeoPandas data pipeline into PostGIS. A FastAPI service exposes the data to a React and Leaflet frontend.
Technical decisions documented in the project
- School locations are assigned to communities using boundaries rather than mailing addresses.
- Spatial analysis runs in PostGIS using EPSG:26911; the API returns GeoJSON in EPSG:4326.
- Population coverage uses 2020 Census blocks apportioned by area.
Limitations
Known constraints and validation
- Proximity is straight-line distance, not travel time.
- Coverage counts public schools of any type and grade level.
- Population coverage is an area-based estimate from Census blocks, with its method and limits stated in the project.
Future improvements
The repository describes incorporating additional community services as a future direction. The current documented map focuses on public schools.