Utilities to download and analyze Ann Arbor water utilities use.

This is largely obviated by the city's AquaHawk system.

If you look on your water bill you'll find a "meterID", like 12345678-0.12. Replace that ID with yours in this "curl" command to get readings for a range of dates.

curl -s 'https://secure.a2gov.org/WaterConsumption/DownloadData.aspx?meterID=12345678-0.12&startDate=3/10/2018&endDate=3/12/2018' > water.html

It's a funky HTML file. This bit of sed will normalize it back down to something easy to parse.

cat water.html | sed -e 1,4d -e /tr/d -e /table/d -e 's;</td><td>;,;g' -e 's/.*<td>//' -e 's;.</td>.*;;'

Use your favorite graphing tool. Examples welcomed; the file waterusage.sh here generates a plot.

The City of Ann Arbor released a reporting and alert monitoring tool, Aquahawk, which you can use once you've registered your meter. It gives you a day-by-day estimate of use, as well as monthly or weekly totals, and you can export by hour, day, or month. The system can also send alerts to a provided cell phone number if it suspects that you have a leak.