← Back to civic work
Civic — Independent Study

Hospital Accessibility Analysis

A dashboard analyzing healthcare accessibility across Illinois, built on live cloud-native geospatial data rather than a static extract.

Overture Maps GeoParquet via AWS S3 Census boundary data via pygris
Screenshot of the Hospital Accessibility Analysis dashboard showing clustered hospital counts across Illinois and neighboring states, with a legend distinguishing hospital facilities from census neighborhood centers.

This is the most technically ambitious thing I've built during my independent study. It streams live Overture Maps GeoParquet data straight from AWS S3 — rather than working from a downloaded, aging extract — and combines it with Census tract boundary data via pygris to analyze how healthcare access lines up against geography across Illinois.

Illinois-focused, not "national"

I want to be straightforward about scope here: the intent was always Illinois. The dashboard shows data for other states too, but that's incidental — Overture Maps and Census data are both national datasets, and I haven't filtered them down. It wasn't a deliberate design choice to go national, and I'd rather say that plainly than oversell it.

How it's held up

I posted this on LinkedIn without expecting much, and it sparked real technical conversation with people in the field — one GIS developer raised the challenge of trying the same approach on Overture's much larger buildings dataset, and a senior software engineer suggested an edge-caching architecture (CloudFront and Lambda@Edge) that could make a production version more efficient. That kind of engagement matters more to me than any metric I could put on the dashboard itself.

Worth knowing

This was the first app to migrate off dulcetgis.com onto my permanent domain, bergstromgis.com — driven by that outside validation, not just personal preference.

Let's talk about a job, a project, or both.

I'm open to full-time GIS Analyst roles and freelance/consulting work.