well-n-calm¶

The well-n-calm is a resource to guide archiving various well data related to groundwater problems in California. Currently, it is focused to provide a consistent format to organize compiled well data in Envrionmental Geophysics group at Stanford. We share our lessons learned to compile well data in our group for past 5 years while solving groundwater problems in California. List of major projects incuding well data are:

Butte
Kaweah (Tulare)
Indian Wells Valley
San Louis Obispo

With the organization of well data in these projects, we also develop a basic python code base such that one can easily explore the existing data sets, import new data, and export the data sets to various formats (e.g. LAS, CSV).

Location of the water wells in California. Around milllon wells are plotted.

Contents:¶

Data Sources¶

WCR¶

Well Completion Report (WCR)

Provider: California Department of Water Resources (DWR)
Data types: PDF version of Lithology logs and geophysical logs (not discretized as readable to computer; ~10 \(^6\))
Web links:
- https://data.ca.gov/dataset/well-completion-reports

CASGEM¶

The California Statewide Groundwater Elevation Monitoring (CASGEM) Program

Provider:
Data types:
Web links:
- https://water.ca.gov/Programs/Groundwater-Management/Groundwater-Elevation-Monitoring–CASGEM

DOGGR¶

Division of Oil, Gas, and Geothermal Resources (DOGGR)

Provider: California Department of conservation
Data types: lithology logs, geophysical logs (resistivity, self-potential, gamma, …)
Web links:
- https://www.conservation.ca.gov/dog/Pages/WellFinder.aspx

GAMMA¶

Groundwater Ambient Monitoring and Assessment (GAMMA) Program

Provider: California Water Boards
Data types: water quality data (~282,000 wells)
Web links:
- https://www.waterboards.ca.gov/water_issues/programs/gama/about.html

SGMA¶

Sustainable Groundwater Management Act (SGMA).

Provider: California Department of Water Resources (DWR)
Data types:
Web links:
- https://www.waterboards.ca.gov/water_issues/programs/gama/about.html

EM resistivity¶

SkyTEM
towed-TEM

Data Format¶

To organize the well data, we consider two diffent file format:

Interval file
Collar file

Common Variables¶

Project:
ID:
ReferenceDepth:
From:
To:
Projection
Zone
X:
Y:

Data Types¶

Lithology log
Water level data
Water quality data (e.g. total dissoved solidds(TDS))

Data explorer¶

Data explorer is a python code base which allows us to explore the organized well data connected to specific projects in our Environmental Geophysics group.

Lessons Learned¶

Exploring well data in California, and convert them into a usuable format such that one can extract useful information about groundwater is not simple. Main roadblock for this is …

Feedback:¶

Have comments or suggestions? Submit feedback here.

Contributors:¶

Akash Ahamed
Alex Kendrick
Ian Gottschalk
Matt Lees
Meredith Goebel
Noah Dewar
Rosemary Knight
Seogi Kang (@sgkang)