Look into California groundwater wells database - water rights

[amabdallah]

We're interested in sharing data about groundwater wells in California. These are not part of the prior appropriation water rights but could be under the Rule of Capture. Or we need to come up with a better Application Type that covers this type of data for CA and TX.

https://data.cnra.ca.gov/dataset/calgw-live/resource/5cfcc956-6b47-491b-96b9-cfb2ab1b7deb

These wells will likely be related to the Sustainable Groundwater Management Act (SGMA)

[amabdallah]

Here is the data source. There seem to be a tone of metadata to work with. Groundwater is not regulated in CA through the prior-appropriation doctrine. So these all are exempt water rights data: no priority date and no flow or volume amounts. https://data.cnra.ca.gov/dataset/well-completion-reports/resource/8da7b93b-4e69-495d-9caa-335691a1896b

[amabdallah]

Eric Senter from the Sustainable Groundwater Management Office, California Department of Water Resources, responded eric.senter@water.ca.gov

The best source to use for our groundwater level dataset is from our Open Data platform, which includes the station location data in addition to the groundwater level data for each well.

The “other data set” that you referred to relates to our well completion report database. The two data sets can be linked to each other via the Well Numbers data set from the well completion report database. However, there is not a one-to-one correlation between the well completion report and the groundwater levels. Most of the wells in the groundwater level data set do NOT have entries in the well completion report database.

More metadata https://data.cnra.ca.gov/dataset/periodic-groundwater-level-measurements

My thoughts The Stations dataset has ~50K stations, while the "Well Completion Reports" dataset has ~1 million. We need to do a few joins to generate a dynamic state landing page URL

• Fill in the StationID and WellNumber into the base URL for each well as in this example https://wdl.water.ca.gov/WaterDataLibrary/GroundwaterBrowseData.aspx?StationId=9799&StateWellNumber=09N08W20L001M

This will work for a fraction of the dataset because only ~50K sites have station id. The rest won't have station id and so we may need to use the WCR link for them from here https://data.cnra.ca.gov/dataset/well-completion-reports/resource/bff565b3-b3b4-4727-b10b-e09e0012ec3b