Public Water Supply Demo App: add population data + filter

[amabdallah]

One of the valuable use cases for urban water data is the comparison of per capita water use across "similar" cities in the West.

This project is a great example for us. It only focuses on the Colorado River Basin, and their data (I think) is a snapshot for one year or average (not time series).
https://uagis.maps.arcgis.com/apps/dashboards/8502820c41374e6eb35fd90a2ffb656a

Use case for WestDAAT: show me the cities (POUs) with more than 50K and 70K population (population served). Then show me their per capita water use over time. The result would help city managers benchmark and compare their per capita use with other cities.

So we need to ask our states about the served population (we have it in the schema), and we need to add the "gallon per capita per day" new field to the table: VariableAmounts_fact

Add a new fieldcalled~: GallonPerCapitaPerDay
https://schema.westernstateswater.org/diagrams/2_SiteSpecificAmounts.html

This issue evaluates what it takes to support this use case.
Here is a relevant doc regarding the importance of such data and how it could be used.
https://www.lincolninst.edu/incorporating-water-comprehensive-planning

[rwjam]

Interesting idea. For now we can add the PopulationServed value as a filter. We will have to wait for DPL to add that new GallonPerCapitaPerDay field, then we will have to reach out to states and see if they have this value first before we can full explore this idea.

One issue with this approach is that, in WaDE, PopulationServed is a VaribleAmounts_fact value, not a Sites_dim one. Meaning that we track it by the given record and not by site. This can mean that the given value could change over time (see image), making building a filter, particularly a filter that search by site, difficult.

We might need to consider the following....

• Move PopulationServed to the Sites_dim Table. In the even the value has changed over time, we would just pick the more concurrent value.
• DPL might be able to build a filter for this on WestDAAT as it. Not sure how difficult that would be though, or how much the cost will be.

[amabdallah]

Here is the current implementation. Let's discuss