CCRPC

QGIS plugin

An extensible python plugin for QGIS to help planners within the organization quickly download Census data using the Census and TIGER APIs. The plugin provides a neat UI for querying their data so that they spend less time in the python IDE and more time utilizing the data for effective means. The plugin was originally over 3000 lines with limited extensibility. I was able to reduce it to under 1000 lines while increasing performance and functionality.

Ameren Demographic Tool

A webmap that aggregates Census and CDC demographic data into a dynamically generated and weighted priority index to inform Ameren where to focus their funding resources. Additional functionality includes overlays for geographic entities and population density.

Sidewalk Inventory

An inventory of all sidewalks, curbramps, pedestrian signals, and crosswalks in the Champaign Urban Area since 2015. The data is stored in a PostgreSQL database, where SQL scripts generate condition and ADA compliance scores. These are then converted to MBtiles and served as a webmap.

SS4A (Safe Streets for All)

A live comment map for infrastructure in Champaign county.

Linux Desktops

The department’s development is done on linux laptops. When I had joined the organization was using unmaintained Ubuntu configurations that were 2-4 years out of date with several issues concerning configuration drift.

I decided to move the department over to a cloud native model with Bluefin. OCI snapshots, layering, and a container oriented design philosphy simplified setup/deployment, made auditing systems simpler, and greatly minimized machine downtime.