open-city / chicago-river-sewage

Is there sewage in the Chicago River?
http://istheresewageinthechicagoriver.com
29 stars 12 forks source link

View historical CSO events #4

Closed evz closed 10 years ago

evz commented 10 years ago

Would be cool to do something like:

screenshot 2013-12-04 19 10 15

to show a history of these events (maybe even scraping the data as far back as we can to backfill it). I suppose this would involve adding a DB to the operation which, if we don't go over 10,000 rows, we can do for free on Heroku.

Any interest here? I can probably whomp up the code for it.

derekeder commented 10 years ago

Hmm could be interesting. Since 2007, there have been 372 CSO events. Wonder if there's a better way to show 6 years of data (@fgregg?). Either way, we'd need to scrape everything and stuff it in a DB.

evz commented 10 years ago

Could aggregate it to the month or week or...?

fgregg commented 10 years ago

week or month seem like good options

derekeder commented 10 years ago

@sbeslow if you get a chance to work on charting CSO events since 2007, post your stuff here.

For displaying charts on the web, I'm a big fan of HighCharts.

derekeder commented 10 years ago

You can now with 3f81c825363dbec89fc9fcb5eca099e4a6c78272