Ann Arbor Queryless Demo

Monthly solid waste tonnages for the city of Ann Arbor, including commercial and residential sources.

All of the city's PFAS water sampling data. This data is also available for interactive analysis via the city's PFAS Monitoring Dashboard.

The City of Ann Arbor operates and maintains five tipping​ bucket rain gauges​ (5-min resolution) which are located at Barton Dam, South Industrial Hwy, Jackson Ave​/Parklake Ave, University of Michigan North Campus Area and City Hall​​​. This file contains the data from those gauges in 15-minute increments. Rainfall is visualized on our public-facing dashboards; we also offer the raw data here. The city populates a record of 0.00 inches for the interval 11:45pm-midnight every day for each gauge, unless rainfall occurred during that time in which case the value is preserved. We also temporarily populate a record of 0.00 for the latest timestamp that each gauge has reported data from, to make it clear when the gauge last called in. Since we began collecting this data in 2013, individual gauges have intermittently gone offline and/or reported invalid rain totals (either too high or too low). We have expunged some invalid rain total values for this .csv but these limitations of data incompleteness still affect this dataset.

Hourly air quality data collected by the city. The dataset begins in 2022 with data from a few stations that used AQMesh-brand sensors. Then it switches over to a few Clarity-brand sensors, and finally expands to ten Clarity stations. We have combined the two datasets into a single one here. You can use the "vendor" column to differentiate. The city's Air Quality Dashboard visualizes this data; we are also making it available here for further exploration.