1970-01-01

Water Table

Every aquifer has a balance sheet. We show who's draining it, how fast it's falling, and what happens when the underground bank account hits zero.

Consumer-facing aquifer depletion intelligence — automated groundwater countdowns, aquifer scorecards, county-by-county well decline tracking, recharge-vs-pumping explainers, and weekly data journalism that turns invisible water loss into something people can finally see, share, and act on.

Niche Explored

Global aquifer depletion tracking — consumer-facing countdown timers and accountability for the world’s draining freshwater reserves. Satellite + ground-well data mashed into “years until empty” projections, aquifer-by-aquifer.

Existing Competition

Direct competitors

“Invisible Waters” Substack (Daniel Rothberg) — Nevada/western US focus, text-only newsletter, no automated data visualizations, no per-aquifer scorecards. Well-written but narrow geographic scope and no interactive data products. ~hundreds of subscribers.
USGS National Groundwater Conditions App (rconnect.usgs.gov/gwapp/) — Official government tool. Purely technical. Ugly interface, no narrative, no “years left” projections, no accountability framing. Useful as a data source, not a competitor for consumer attention.
NASA GRACE Data Assimilation viewer (nasagrace.unl.edu) — Research-grade maps showing groundwater percentiles. Zero narrative. Zero design. No consumer framing.
Climate Water Project Substack — Occasional groundwater posts among broader climate content. Not systematic, not data-automated.

Gap identified

Nobody combines USGS ground-station well data + NASA GRACE-FO satellite gravity data + state water authority data into per-aquifer countdown clocks with automated narrative journalism. The visual/emotional hook of “your aquifer has X years left” doesn’t exist anywhere as a continuously-updated product.

Data Sources Found

Primary — USGS Water Services REST API

URL: https://waterservices.usgs.gov/nwis/gwlevels/
Format: JSON, WaterML, RDB (tab-delimited)
Coverage: ~850,000 monitoring wells across the US
Parameters: stateCd, countyCd, startDT, endDT, format=json
Rate limits: No API key required. Generous limits for automated collection.
Example: https://waterservices.usgs.gov/nwis/gwlevels/?format=json&stateCd=KS&startDT=2024-01-01
New OGC API: https://api.waterdata.usgs.gov/ogcapi/v0/ — modernized endpoints for monitoring locations and continuous data

Primary — NASA GRACE-FO Satellite Data

Source: JPL TELLUS GRACE-FO Level-3 Monthly Land Water-Equivalent-Thickness
URL: https://podaac.jpl.nasa.gov/dataset/TELLUS_GRFO_L3_JPL_RL06.3_LND_v04
Coverage: Global, 0.5-degree grid, monthly updates
Format: NetCDF4
Access: Free via NASA Earthdata login (automated token auth)
Also: Interactive browser at https://grace.jpl.nasa.gov/data/data-analysis-tool/

Secondary — Drought.gov GRACE Groundwater Viewer

URL: https://drought.gov/data-maps-tools/groundwater-and-soil-moisture-conditions-grace-data-assimilation
What: Pre-processed groundwater percentile maps
Format: GIS-ready tiles, downloadable

Secondary — California SGMA Data Portal

URL: https://sgma.water.ca.gov/webgis/
What: California-specific groundwater sustainability data, well measurements, basin boundaries
Format: API + download portal

Secondary — USGS GRACE Groundwater Subsetting Tool (GGST)

URL: https://ggst.readthedocs.io/
What: Python tool for generating time series from GRACE data for specific aquifer regions

Tertiary — State water authority APIs

Kansas Geological Survey annual aquifer reports
Texas Water Development Board groundwater database
Arizona Department of Water Resources well registry

Key Academic Data

Jasechko et al. 2024, Nature: “Rapid groundwater decline and some cases of recovery in aquifers globally” — analyzed 170,000+ monitoring wells across 1,693 aquifer systems in 40+ countries. Found 71% of monitored aquifer systems declining since 2000.
NASA GRACE analysis: 21 of Earth’s 37 largest aquifers have exceeded sustainability tipping points.

SEO Analysis

Keywords (high volume, moderate-low competition)

“Ogallala aquifer depletion” — high search interest, mostly news articles, no data product
“groundwater levels near me” — high local intent, zero automated consumer tools
“aquifer levels” — moderate volume, dominated by USGS technical pages
“water table dropping” — consumer phrasing, almost no quality content
“will we run out of water” — evergreen anxiety query, huge volume
“groundwater crisis” — growing search trend per Google Trends
“aquifer map” / “groundwater map” — visual content gap

Google Trends signals

“groundwater” searches steady with spikes during drought events
“Ogallala aquifer” searches up significantly 2024-2026 as Kansas farmers face mandatory water cuts
“water crisis” trending upward globally, especially India + US Southwest
Seasonal spikes in summer (drought season) = predictable traffic patterns

Communities

r/water (96K members)
r/farming (250K+) — frequent groundwater anxiety posts
r/collapse — groundwater/Ogallala is a recurring topic
r/climate (500K+) — water crisis posts consistently high engagement
r/California, r/Arizona, r/Kansas — local water crisis engagement
Water Twitter/X — active community of hydrologists, journalists, policy advocates
Farming forums, ag industry media

Image/Graphic Feasibility

Excellent. This niche is inherently visual:

Aquifer cross-section diagrams (AI-generated, schematic style)
Choropleth maps of depletion rates by county/region
“Countdown clock” graphics per aquifer
Time-series line charts of water table depth
Before/after satellite imagery composites
Infographic scorecards (depletion rate, recharge rate, years remaining)
County-level heatmaps of well depth trends

Chart.js / D3.js / Observable Plot for interactive charts. AI image generation for aquifer cross-sections and mascot.