WSWCWaterDataExchange / MappingStatesDataToWaDE2.0

Manage all code to map and import state's data into WaDE 2.0
BSD 3-Clause "New" or "Revised" License
4 stars 1 forks source link

Review Idaho (ID) water right data: water source type: reuse #266

Closed amabdallah closed 6 months ago

amabdallah commented 8 months ago

Is this a Mapbox bug, or does Idaho have a "water reuse" source type?

I was looking into example water rights like this one but did not see "reuse" in the state native landing page. The PODs are in the Colombia River Basin, so I'm not sure how the "reuse" came in. https://westdaat.westernstateswater.org/details/right/IDwr_WR123A

https://westdaat.westernstateswater.org/?state=N4Ig7gTiBcoEYFMB2CBmBLAxughgGwFUBnBAORwFsEiYBtEAQQHMIsBXPAFzYgQAIAkhFZMcndAHskIALoAacGIQQAyhJ6YEAFQCeAB2p0QAJQRsSshUU5Ka0egS0gFAgCKWQeiQBMACupgQXwB5AmcQdCJSPG90ADF0LmUGTHEANwQYVHwSAF8FChw9GFAALwkJCgAZBAy8GAAOADoAVgAWACYWgDYABj6AZg6Adg7ehoaFPDF0bm9M6E6mtoBGboGpqSZZtnmYAFoVlYGmhpW2gE4B-PAIbxLPCXQkThV0UoWQe4KigHEIdR6Z5MQJgIi6AwgXK5IA

image

rwjam commented 7 months ago

For IDwr, it's a little tricky in identifying water source type. We essentially get WaterSourceName and WaterSourcetypeCV from the same column (see 1st img). For WaterSourcetypeCV we use a keyword search to look for specific values (see 2nd img). It's not perfect because they do mix surface water and groundwater names together.

Some of the source values do contain a "Waste" or "Waste Water" value (see 3rd img), which is where we identify a "Reuse" value. link.

We could go back and change that "Reuse" value in our keyword search and tag it with a "Surface Water" value, if that is a better approach. image image image

amabdallah commented 7 months ago

This is very interesting! Thanks for looking into all this. Let's discuss more over a Zoom call, and I would probably prefer to ask Idaho if they could add water source type themselves. Wastewater is interesting, for sure. "Waste" alone may actually indicate return flow, which is different from urban wastewater/treatment and reuse.

rwjam commented 7 months ago

List of distinct water source names from the IDwr data.

IDwr Distinct Water Source Names.xlsx

amabdallah commented 7 months ago

Thanks! so I see these unique native water source names we classified for "reuse." I think its reasonable to keep the red color ones as "reuse." Not sure what to do with the other ones. Wasteway appears to be a ~name image

amabdallah commented 6 months ago

We decided to follow this:

Reuse = Treated Municipal Wastewater, Waste Water, Wastewater Surface Water = the Wasteway names.

rwjam commented 6 months ago