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

Interesting comparison between owner classification and owner name search filter #156

Open amabdallah opened 1 year ago

amabdallah commented 1 year ago

Here is an interesting query search as FYI for owner name ="reclam" which returned ~2,350 water rights compared to ~2,100 rights classified as reclamation.

Two observations about the owner search name filer

  1. It works well in getting all owners with "reclam." Getting Lower and Upper case + part of the term.
  2. It's not smart compared to the classification code. It does return owners that are not related to the Bureau of Reclamation, such as this owner who happens to have "Reclamation." Pima County Regional Wastewater Reclamation Department
  3. The owner classification is useful, and it could be refined over time as we go.

reclam owner name search https://westdaat.westernstateswater.org/?state=N4IgtghgDiBcoC8D2SwBkCmA3DAbOAbAHQCMAHACwDsArAAwECcZJVATGwMwEA0IuEAC4BLQQFcAJhjgVORKgTqcydEiQ5sKNEn1xIAdgHNRk6bAC0akkTJkmBBRxI1tFAL58A7gCc4oAEYY%2BhgAZsIAxsIQuACqAM4YcXAA2gC6fEiewd4AwgJxccJh4ULCBkmwaXzReiUiBgDyWRi%2BsCDeGOECYCBeQi0Aykhi3uEYACoAnlCJKekgcYL9FVXtwjjeAEIQhfoAchBgs5XzUEi4k7jCwXN8%2BrgSwgBiwriCLQAiQhBw%2BmK4uDcbiAA

Classified as Reclamation https://westdaat.westernstateswater.org/?state=N4IgtghgDiBcoC8D2SwBkCmA3DAbOAbAHQCMAHACwDsArAAwECcZJVATGwMwEA0IuEAC4BLQQFcAJhjgVORKgTqcydEiQ5sKNEn1xIAdgHNRk6bAC0akkTJkmBBRxI1tFAL58A7gCc4oAEYY%2BhgAZsIAxsIQuACqAM4YcXAA2gC6fEiewd4AwgJxccJh4ULCBkmwySAAQmLeGBBiAAQAShjhApAiBk0AFDEAytUtAJQg6SCeQhjeA0h14RgAKgCeUIkpE3GC0xVpfN7CON7VEIX6AHIQYBuVE1BIuCu4wsGbfPq4EsIAYsK4ghmABEhBA4PoxLhcG43EA

amabdallah commented 1 year ago

Interesting. So "Reclam" only is not specific enough and includes Reclamation unrelated to USBOR. So the owner classification code is working well.

image

rwjam commented 1 year ago

Correct. Those are state native Reclaim departments. They are not the USBR.

amabdallah commented 10 months ago

Let's revisit this work and see how this new dataset can help. Adel to add details later

https://www.arcgis.com/apps/mapviewer/index.html?layers=1df76b35789f448094cec79c53c42555

image