WTO Exports

Screenshot of map

This is an interactive graphic showing U.S. agricultural exports and imports with TPP trading partners.

It was built using Leaflet.js and d3.js, and is hosted on GitHub.

It is available here.

Property Record Search Database

Screenshot of map

Using the property records used through the investigative piece on homeowner’s exemptions, The Midwest Center for Investigative Reporting sponsored the build for a searchable database to accompany the story.

This application is bulit using Python and GeoDjango. Records and map points are served up from a PostgreSQL database and presented using leaflet.js. Search queries are handled by Elastic Search. The application is hosted on Heroku.com.

Homestead Exemptions

Screenshot of map

This project has been almost entirely a database driven story using off the shelf products such as PostgreSQL and SQL queries, with the presentation produced using CartoDB and some web markup.

Using property records for Champaign County, this story looks at how a loosely written state law allows property owners to claim more than one property as owner occupied.

My contribution to the project began with a simple database query on my own home, in which I noticed that the landlord was claiming a homeowner’s exemption on the house.

The map is available here, and the story is available here.

The curiosity of this situation led to further inquiries, and the investigative team found that the landlords are all behaving within the law, though the law as it is written is left up to the interpretation of the county supervisor of assessments.

The team further found that the tax assessor was interpreting the law differently then every other county in the state, which amounted to millions in lost taxes.

GMO Petitions

Screenshot of map

This is an interactive graphic showing a breakdown of GMO petitions submitted by agriculture companies to the USDA.

It was built using d3.js and is hosted on GitHub.

Click here to interact with the graphic.

Ethanol Capacity

Screenshot of map

These are a series of static info-graphics created to show the production capacity at various regions throughout the country involved in the production of ethanol.

Graphics were developed using Adobe Illustrator and the interactive table is built using JQuery DataTables. The page is hosted on GitHub.com.

It is available here.

Restaurant Inspection Search

Screenshot of map

This is an ongoing project for CU-CitizenAccess.org to track health inspections for local area restaurants.

The application is built using Python, GeoDjango, PostGres, and hosted on Heroku.

A Python script runs weekly to update our database using a scraper that pulls data from the local public health department website.

3D Communities

Using the popular game creation engine Unity 3D and some 3D models downloaded from Open Street Maps project, to display real-time maps of Champaign, IL.

This is a very early and rough prototype.

2014 Fire Maps

Screenshot of map

Screenshot of map

These are two separate and similar mapping projects tracking fires throughout the Urbana, Champaign, and the University of Illinois campus.

Data was requested through FOIA through the local government.

The map is made using leaflet.js and served from the CU-CitizenAccess.org GitHub repository.

Champaign-Urbana map is available here University of Illinosi map is available here

2014 Illinois Campaign Contributions

Screenshot of map

This is an interactive map made for WILL Radio in Urbana during the Illinois governor’s race to show where campaign contributions were coming from and where they were going.

Data was taken from the Illinois State Board of Elections.

The map is made using leaflet.js and records are formatted from shapefiles and exported into geojson.

The map is available here

Made with ♥ in Urbana-Champaign