Skip to content

Data dictionary

Every field the Water API returns, with its type, its unit and the rule behind it. Then the sources with their dates, and the checks the numbers passed before going out.

Sources, processing and refresh

DatasetPublic sourcesWhat we do to themRefreshLicense and DOI
WellsTexas Water Development Board, Submitted Driller's Reports database; U.S. Census Bureau, 2024 cartographic boundary file, counties (1:500,000)Keep water-supply wells (domestic, stock, irrigation, public supply; new wells and replacements). Drop coordinates that are missing, outside Texas or flagged by the driller as wrong, and mark whether each point falls in its reported county. Classify each driller's rock log into layer types. Read ground elevation from terrain tiles. Never load owner, address or driller names.Every night, from the state's file of that dayCC BY 4.0, 10.5281/zenodo.24126380
Water qualityTexas Water Development Board, Groundwater Database (file of 2026-11-13); Water Quality Portal (USGS and EPA) (file of 2026-11-15)Accept only results with a known sampling protocol. Match the same well across the two sources so it counts once. Turn the three ways nitrate is stored into nitrogen. Take each well's most recent accepted test since 1992 and compare it with the limit; a 'less than' above the limit leaves the well undetermined.Versioned releases; the upstream databases change slowlyCC BY 4.0, 10.5281/zenodo.24287393
County rulesCounty and district rules, state agency maps and lists; each answer links its ownRead the rule, write a plain answer, keep the quote and the document behind it, record the date verified.Reviewed by hand; each answer has its dateCC BY 4.0
County of a pointU.S. Census Bureau, 2024 cartographic boundary file, counties (1:500,000)Texas counties, lines simplified by at most about 11 m (62,284 vertices).With each Census releasePublic domain

Methods in full: wells, water quality. What is ours and not in the public files: the cleaning rules, the per-point and per-county summaries, the 20-year comparison with its bootstrap intervals, the layer classification of the drillers' logs, the water quality counting rules and their study, and the county rule answers.

GET /api/v1/water

Location

FieldTypeMeaning
pointobjectThe point, after rounding to 5 decimals.
point.latnumberLatitude.
point.lonnumberLongitude.
locationobjectWhere the point is.
location.statestringTX.
location.countyobjectA Texas county.
location.county.fipsstring5-digit FIPS code.
location.county.namestringName.
location.county.slugstringSlug of its pages on terrafunded.com.
location.near_county_linebooleantrue within about 0.15 miles of a county line; then other_county names the neighbor.
location.other_countyobject or nullA Texas county.
location.other_county.fipsstring5-digit FIPS code.
location.other_county.namestringName.
location.other_county.slugstringSlug of its pages on terrafunded.com.

wells.nearby

FieldTypeMeaning
populationstringWhich wells are counted.
radius_milesnumberRadius used.
radius_rulestringHow the radius was chosen.
wellsintegerHome wells with depth inside the radius.
reliabilitystring: high, medium, lowhigh: 20+ wells within 3 miles with a tight spread; medium: 10+ wells within 5 miles; low: otherwise.
depth_ftobject or nullQuartiles.
depth_ft.p25number25th percentile.
depth_ft.mediannumberMedian.
depth_ft.p75number75th percentile.
static_water_level_ftobject or nullDepth to water, feet below ground, with the number of wells that reported it.
static_water_level_ft.p25number25th percentile.
static_water_level_ft.mediannumberMedian.
static_water_level_ft.p75number75th percentile.
yield_gpmobject or nullReported yield.
yield_gpm.mediannumberMedian, gallons per minute.
yield_gpm.wellsintegerWells that reported a yield.
yield_gpm.share_measured_by_pump_testnumber or nullShare of those measured with a pump test, 0 to 1.
nearest_well_milesnumber or nullDistance to the nearest home well.
wells_completed_last_10_yearsintegerOf those wells, how many were completed in the last 10 years.
oldest_completedstring or nullOldest completion date.
newest_completedstring or nullNewest completion date.
other_uses_in_radiusobjectWells of other uses in the same radius, by use.
nearest_reports[]array of objectThe nearest reports of any use (see the records parameter).

wells.county

FieldTypeMeaning
wellsintegerWells used.
periodstringWhich wells: the last 10 years when there are 30 or more, otherwise all since 2001.
confidencestring: standard, limited, insufficientstandard: 30+ wells; limited: 10 to 29; insufficient: fewer than 10, no figure.
depth_ftobject or nullDepth percentiles.
depth_ft.p10number10th.
depth_ft.p25number25th.
depth_ft.mediannumberMedian.
depth_ft.p75number75th.
depth_ft.p90number90th.
static_water_level_ftobject or nullQuartiles.
static_water_level_ft.p25number25th percentile.
static_water_level_ft.mediannumberMedian.
static_water_level_ft.p75number75th percentile.
yield_gpmobject or nullQuartiles.
yield_gpm.p25number25th percentile.
yield_gpm.mediannumberMedian.
yield_gpm.p75number75th percentile.
texas_median_depth_ftnumber or nullStatewide median, for comparison.
aquifers[]array of objectAquifer under the county (state maps).
aquifers[].namestringName.
aquifers[].kindstringmajor or minor.
aquifers[].zonestring or nulloutcrop or subsurface.
aquifers[].share_of_countynumberShare of the county's area, 0 to 1.
change_over_20_yearsobjectHome wells completed in 2003-2007 against 2021-2025, for the county.
change_over_20_years.comparablebooleanfalse when either period has too few wells.
change_over_20_years.periodsobjectThe two periods.
change_over_20_years.periods.earlystring2003-2007
change_over_20_years.periods.latestring2021-2025
change_over_20_years.rulestringWhen a change counts.
change_over_20_years.depthobjectTotal depth.
change_over_20_years.depth.early_median_ftnumberMedian, early period.
change_over_20_years.depth.late_median_ftnumberMedian, late period.
change_over_20_years.depth.early_wellsintegerWells, early.
change_over_20_years.depth.late_wellsintegerWells, late.
change_over_20_years.depth.change_ftnumberLate minus early.
change_over_20_years.depth.change_pctnumberPercent change.
change_over_20_years.depth.change_95_interval_ft[]array of number
change_over_20_years.depth.resultstring: deeper, shallower, no_clear_changeResult.
change_over_20_years.static_water_levelobject or nullDepth to water. A positive change means the water stands lower.
change_over_20_years.static_water_level.early_median_ftnumberMedian, early.
change_over_20_years.static_water_level.late_median_ftnumberMedian, late.
change_over_20_years.static_water_level.change_ftnumberLate minus early, feet.
change_over_20_years.static_water_level.change_95_interval_ft[]array of number
change_over_20_years.static_water_level.resultstring: lower, higher, no_clear_changeResult.

A well report

Returned by /api/v1/wells and under wells.nearby.nearest_reports. One driller report as filed with the state, plus two added fields: the distance to your point and the ground elevation.

FieldTypeMeaning
state_report_idintegerTexas Water Development Board well report tracking number.
state_report_urlstringThe official report on the state's site.
distance_milesnumberGreat-circle miles from the point.
latnumberLatitude on the report, 5 decimals.
lonnumberLongitude on the report, 5 decimals.
usestringProposed use on the report.
year_completedinteger or nullYear the well was completed.
depth_ftinteger or nullTotal depth, feet.
static_water_level_ftnumber or nullDepth to water when the well was finished, feet below ground.
yield_gpmnumber or nullReported yield, gallons per minute.
yield_test_methodstring or nullHow the yield was measured (Pump, Bailer, Jetted, Estimated, Unknown).
ground_elevation_ftinteger or nullGround elevation from terrain tiles, feet (added by the Well Atlas, not on the report).

water_quality.indicators[]

idWhat is measuredLimitWhere the limit comes from
arsenicArsenic (dissolved)above 10 µg/LFederal drinking-water standard for public water systems (EPA maximum contaminant level)
nitrateNitrate (as nitrogen)above 10 mg/L as NFederal drinking-water standard for public water systems (EPA maximum contaminant level)
fluorideFluoride (dissolved)above 4 mg/LFederal drinking-water standard for public water systems (EPA maximum contaminant level)
fluoride_secondaryFluoride (dissolved), secondary levelabove 2 mg/LFederal secondary level (EPA secondary maximum contaminant level)
tdsTotal dissolved solidsabove 1,000 mg/LTexas secondary level for public water systems

The limits are standards for public water systems, used here as a yardstick. No law applies them to a private well. "Above" means greater than the limit; equal does not count.

Fields

FieldTypeMeaning
idstring: arsenic, nitrate, fluoride, fluoride_secondary, tdsStable id.
namestringName.
limitobjectThe yardstick.
limit.valuenumberLimit.
limit.unitstringUnit.
limit.comparisonstringabove: equal to the limit does not count.
limit.basisstringWhere the limit comes from.
nearbyobjectTested wells around the point.
nearby.wells_testedintegerWells with an accepted lab test that decides (above or not above the limit).
nearby.wells_above_limitintegerOf those, wells whose most recent accepted test was above the limit.
nearby.share_above_limit_pctnumber or nullPercent above the limit, one decimal. null with fewer than 10 tested wells.
nearby.share_95_interval_pct[]array of number or null95% Wilson interval of that percent. It assumes independent wells; wells near each other are not, so the real interval is wider.
nearby.wells_undeterminedintegerWells whose most recent test could not be compared with the limit (a 'less than' with a reporting limit above it). They are left out of wells_tested.
nearby.median_test_yearinteger or nullMedian year of the tests used.
nearby.radius_milesnumberRadius used: 5, 10 or 15.
nearby.radius_rulestringfirst_radius_with_10_tested_wells, or all_within_15_miles when not even 15 miles gathers 10.
nearby.oldest_test_yearinteger or nullOldest test used.
nearby.newest_test_yearinteger or nullNewest test used.
nearby.nearest_tested_well_milesnumber or nullDistance to the nearest tested well for this indicator.
countyobject or nullPublished county figure.
county.wells_testedintegerWells with an accepted lab test that decides (above or not above the limit).
county.wells_above_limitintegerOf those, wells whose most recent accepted test was above the limit.
county.share_above_limit_pctnumber or nullPercent above the limit, one decimal. null with fewer than 10 tested wells.
county.share_95_interval_pct[]array of number or null95% Wilson interval of that percent. It assumes independent wells; wells near each other are not, so the real interval is wider.
county.wells_undeterminedintegerWells whose most recent test could not be compared with the limit (a 'less than' with a reporting limit above it). They are left out of wells_tested.
county.median_test_yearinteger or nullMedian year of the tests used.
county.domestic_share_of_tested_wells_pctnumber or nullPercent of the tested wells that are domestic.
county.sensitivity_range_pct[]array of number or nullLowest and highest percent when the counting rules are changed one at a time.
texasobjectHow many tested wells were above the limit. Below 10 tested wells there is no percentage, only the count.
texas.wells_testedintegerWells with an accepted lab test that decides (above or not above the limit).
texas.wells_above_limitintegerOf those, wells whose most recent accepted test was above the limit.
texas.share_above_limit_pctnumber or nullPercent above the limit, one decimal. null with fewer than 10 tested wells.
texas.share_95_interval_pct[]array of number or null95% Wilson interval of that percent. It assumes independent wells; wells near each other are not, so the real interval is wider.
texas.wells_undeterminedintegerWells whose most recent test could not be compared with the limit (a 'less than' with a reporting limit above it). They are left out of wells_tested.
texas.median_test_yearinteger or nullMedian year of the tests used.

Counts are of wells that someone chose to test, using each well's most recent accepted lab test since 1992. They are not a sample of all wells and say nothing certain about the water of a particular well or an undrilled tract. The only way to know a well's water is to test it. The limits are standards for public water systems, used here as a yardstick; no law applies them to a private well.

county_rules

FieldTypeMeaning
last_reviewstringDate of the last full review.
languagestringen or es.
topicsobjectwater_well, septic, electricity, mobile_home_rv, ag_valuation.

Topics: water_well (groundwater district, permit or registration for a home well), septic (who permits it and what it costs), electricity (utilities with certificated territory in the county), mobile_home_rv (county orders that apply), ag_valuation (the agricultural appraisal rule and the appraisal district). Summaries of county and district rules with their official sources and the date each was verified. Rules change: confirm with the office named in the source before acting. Not legal advice.

Statewide files

/api/v1/counties (one row per county)

ColumnMeaning
fips, name, slugCounty FIPS code, name and the slug of its pages on terrafunded.com.
centroid_lat, centroid_lonA point inside the county (not the geometric center), decimal degrees.
home_wellsHome wells with a reported depth used for the county figure.
wells_periodlast_10_years when the county has 30 or more wells in that period, otherwise since_2001.
wells_confidencestandard (30+ wells), limited (10 to 29), insufficient (fewer than 10: the depth columns are empty).
depth_ft_p25, depth_ft_median, depth_ft_p75Quartiles of total well depth, feet.
static_water_level_ft_medianMedian depth to water when the well was finished, feet below ground.
yield_gpm_medianMedian reported yield, gallons per minute.
depth_change_20yr_result, depth_change_20yr_pct2003 to 2007 against 2021 to 2025: deeper, shallower or no_clear_change, and the percent change of the median.
water_level_change_20yr_result, water_level_change_20yr_ftThe same for the depth to water: lower, higher or no_clear_change, and the change in feet (positive: the water stands lower).
main_aquifersAquifers under at least 10% of the county, from the state's maps.
{indicator}_wells_testedWells with an accepted lab test since 1992 that decides, for arsenic, nitrate, fluoride (4 mg/L) and tds.
{indicator}_wells_above_limitOf those, wells whose most recent accepted test was above the limit.
{indicator}_share_above_limit_pctPercent above the limit, one decimal. Empty with fewer than 10 tested wells.

/api/v1/grid (one row per cell)

ColumnMeaning
south, west, north, eastEdges of the cell in decimal degrees. Cells are 0.1 by 0.1 degrees, about 6.9 miles north to south and 5.6 to 6.2 miles east to west in Texas.
home_wellsHome wells with a reported depth in the cell. Cells with fewer than 3 are left out.
depth_ft_medianMedian total depth of those wells, feet.

How the numbers were checked

  • Wells. The API reads the same database functions as the Texas Well Atlas pages, so a point or a county returns the figures the atlas shows. Each nightly run stops before loading anything if a download fails or more than 0.5% of wells get no elevation.
  • Water quality, statewide and county. The table behind the API reproduces to the well the five published statewide figures (for example, 742 of 10,379 wells above the arsenic limit) and all 1,016 county figures of the atlas. The build refuses to write the table otherwise.
  • Water quality, nearby. The count of tested wells around a point equals the study's own count for 96.9% of 8,475 test wells and is within one well for 99.9%.
  • Intervals. The Wilson intervals computed by the API equal the published ones in all 874 county figures with 10 or more wells.
  • Counties. The point the atlas keeps for each of the 254 counties falls inside that county's boundary.
  • Three independent programs. The atlas's water quality figures were computed by three programs that share no code, and the study's results by ours and two written only from the rules.

The water quality atlas had no external review by specialists; its pages say so. The lab results are public and anyone can recount them with the published rules.