Derek Eder

Chicago web developer interested in open government, transit, maps, and web design/usability.

I work at Webitects and for Open City in Chicago. Email or tweet at me if you like my stuff, have a question, or have an idea for something I should make.

Code


I like to work with, analyze, and build tools using open data. As a result, I have created several open source projects using Google Fusion Tables to help do that. You can find the source code for all of them (and more) on my github page.

Searchable Map Template with Google Fusion Tables »

Last updated Mar 7th, 2012

You want to put your data on a searchable, filterable map. This is a free, open source tool and template to help you do it. Powered by Google Fusion Tables. Get it on github.

Google Fusion Tables to HTML Table »

Last updated Oct 30th, 2011

Reads in a Google Fusion Table and outputs it in to a searchable and sortable HTML table using jQuery Datatables. Created as a companion to the above searchable map template and written in PHP. Get it on github.

Socrata to Google Fusion Tables »

hosted on github

PHP script to scrape a Socrata dataset and import it in to a Google Fusion Table. Example data uses Chicago's 311 requests for vacant and abandoned buildings and is used to update this map.

Websites


Most of these are works of passion. The more recent ones are contributions to the ever-growing open government movement in Chicago. I like to work with Ruby, Fusion Tables and jQuery

Chicago Public School Tiers »

Launched Mar 8th, 2012

In Chicago, a student's chance of getting into the city's top selective schools depends on where he or she lives. Chicago Public Schools (CPS) places every part of the city into one of four socio-economic "tiers" and requires selective schools to reserve the same number of spots for the students from each tier. This tool helps you find which CPS tier you are in.
Press: EdWeek | CLTV "Politics Tonight" | WTTW "Chicago Tonight" | Chicagoist

ClearStreets - Plow Tracker »

Launched Jan 20th, 2012

The City of Chicago launched Plow Tracker, an app that tracks the city's snow plows in real time. This app uses the same data. By knowing where the plows are, we've figured which streets have been plowed.
Press: WTTW "Chicago Tonight" | Chicago Tribune | Chicagoist | GridChicago

ChicagoLobbyists.org »

Updated Dec 2nd, 2011

An open data, open government, and open source project intended to improve the transparency of interactions between the City of Chicago and lobbyists and their clients.
Press: article on govfresh | article on Chicagoist | Apps for Metro Chicago Contest | City release on updated lobbyist data | @ChiLobbyists on Twitter

Vacant and Abandoned Building Finder - Chicago »

Launched Sept 30th, 2011

Find vacant and abandoned buildings in Chicago. Data comes from reports made for open and vacant buildings to 311 since January 1, 2010.
Press: article on govfresh | Webitects blog | Apps for Metro Chicago Contest (7th place)

LookAtCook.com »

Launched Aug 17th, 2011

Budget transparency visualization for Cook County, IL displaying all county departments broken down by fund and control officer from 1993 to 2011. Done as a collaboration with 12th District Commissioner John Fritchey. Built with Fusion Tables and jQuery.
Press: Article on O'Reilly Radar | Article on govfresh | Webitects blog

Chicago Recycling Dropoff »

Launched June 12th, 2010

My wife Aya and I created a map of all City of Chicago recycling drop off locations. We also set up a mobile site so you can find the nearest drop off point from your current location.

Maps


These are all done using Google Fusion Tables. Let me know if you have a cool dataset you think I should make a map of. If you're feeling adventurous, you can make one of your own by starting with this.

Health Clinics in Chicago »

Created Oct 26th, 2011

Find Neighborhood, Mental Health and Women, Infants & Children (WIC) clinics in Chicago.

Chicago Bike Crash Reports »

Last updated July 12th, 2011

Searchable map of nearly 5,000 reported bicycle crashes in the City of Chicago from 2007-2009 as reported to the Illinois Department of Transportation. Recently added some more advanced filters.

Cook County Hospitals »

Last updated June 24th, 2011

All hospitals in Cook County compared to ward and neighborhood.

2011 IL Senate Redistricting Plan »

Last updated May 19th, 2011

View the IL senate's redistricting plan released on May 19th, 2011 to see what district you will fall in and compare it to the existing 2001 boundaries.

Chicago TIF Projects »

Last updated Feb 27th, 2011

I teamed up with a group of journalism students from Columbia College to present a searchable map of Tax Increment Financing (TIF) Projects in Chicago. Also includes a heat map of amounts allocated per ward.
Press: New York Times | Chicago News Cooperative | ChicagoTalks