← 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 Live U.S. Census API
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 the U.S. Census API in real time to analyze how healthcare access lines up against demographics.

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's gotten real, specific feedback from people in the field — a GIS data consultant flagged the clustering technique as worth borrowing, and a startup founder told me it directly shaped ideas for his own product. That kind of validation 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.