For reference: https://docs.google.com/spreadsheets/d/1r7PavYHWZKrlRAvIbwJzmhcjkOUoW-r3uRrdPptrXAQ/edit#gid=0

The user prefers to search Water System Name rather than Water System ID

This was requested by David Okita at the CWC

Optimization suggested by Alissa Rubin:

When a single analyte is selected on the homepage of water.openoakland.org we still show the number of analytes chart with a big single bar. Should probably remove this chart in that case

The D3 powered map and graphs on the first page of water.openoakland.org could be more usable if the bars on the charts and regions on the maps show tooltips when you mouseover them

This issue was suggested by Alissa Rubin:
"graphs and map should have mouse-over information showing what system(s) are indicated by each bar, what number of violation counts they are at, and how many systems are blocked together at that number of violations"

The CA region map on the homepage of water.openoakland.org sticks at the statewide no filter data level but it would be cool if we could dynamically (or pregenerate) the regions color coded by severity to match the data in the selected filters.

also change the colors of the regions to match the designs here https://www.figma.com/file/zrPWQpnZyo0KI54BC1V0fc/CA-Water?node-id=0%3A1

Optimization suggested by Alissa Rubin

Water system data on system specific page would make more sense if it was sorted by date

Currently missing from this page, could be put on top of map as overlay at top of page

it is a manual process to load new data onto the site

For reference, we are currently updating the site data by a series of scripts which could be more streamlined:

• extracting the data from the h2rw page updated every few months
• running a series of scripts to prep and transform the data https://github.com/openoakland/clean-water/tree/master/data-v2
• loading / storing the transformed data

Optimization suggested by Alissa Rubin:

The bar graphs on the homepage showing number of systems out of compliance have this issue:

"- sometimes y axes of two charts show decimals when there is only a small number of systems/analytes which is a bit confusing; should only show whole numbers and can probably have less wide bars"

For example: http://water.openoakland.org/system.html?id=CA1000019
can only download the first table using the first button

Optimization suggested by Alissa Rubin:

"- the displayed water systems should probably be able to be ordered by each column, so you can view for most violations, or alphabetically, or by population, etc."

These designs are awesome: https://www.figma.com/file/zrPWQpnZyo0KI54BC1V0fc/CA-Water?node-id=0%3A1

There are a lot of accessibility fixes to be had by following these design recommendations, might want to split this up into smaller issues and addressed individually but a lot of beautiful improvements suggested here that will make the site better

There appears to be a data issue with the information displayed in the "Number of systems in violation" bar graph on the homepage of water.openoakland.org. How this data is generated and displayed should be reviewed.

This issues was noticed by Alissa Rubin

"- it seems for middle chart that the violation count maxes out at a lower number than the violation counts listed below in the spreadsheet, and not all systems in violation are shown? ex, when filtering for arsenic, it says 81 systems are in violation but the chart only goes to 40. I think a more useful way to display this would actually be to have past violation count as the X axis, and then # of systems in violation on the Y axis and have the bars somewhat discreet (aka spaced apart a little bit). A mouseover of each bar might list the systems at the level, or simply show the exact x and y axis numbers for easy reading."

I'm sure some of the following may already be on the list for their future improvements, but here are some suggestions I have:

• Can the graphics be made to be clicked on so they may be viewed larger?
  Wendy would probably want an asterisk by "unsafe drinking water" to define how we associate non-compliance with exceeding primary state/federal drinking water standards
• In regards to the links in top left-hand corner
  • Maybe rename the last link to "Map of Chronic Violations" (so viewers will see the word "Map" first) or "Map of Continuous Violations"
  • For top right, maybe reword as "Reporting Period : 2012-Current*"
• In regards to Map"
  • Review colors of "splashes" for color contrast; the grey over the background blue is a little hard to see in some places (Accessibility Issue)
  • Something I had to do with our HR2W map (and still need to work on) is using language around 6th grade level to ensure most people can understand it. Perhaps instead of the work chronic, use "continuous?" Just one example. Perhaps wording across the site can be reviewed and edited appropriately.
• In regards to Leaderboard:
  • Capitalize Title, maybe reword? Maybe: "Population at Risk by California State Assembly District"
  • Wording Example- 198,973 constituents without access to clean drinking water? This is a population count right?
  • Check color contrast of wording against blue background
  • Add button to return to home