The new DrillerDB is out of beta.See what's new

Understanding Well Data

Read the fields available on a well record and understand missing depth values

Understanding Well Data

DepthMap shows well records from public sources. The fields available on a card depend on the record.

Quick Start: View Well Details

Step-by-Step

  1. Click a well marker on the map.
  2. Review the well ID and depth, then the other fields available on the record.
  3. Open View Well Log where a source log link is available.
  4. Compare nearby records and check the source report before relying on the information.

Well Information Fields

The console's full well card can show these fields when the record has a value:

FieldWhat to read
DepthRecorded depth, in feet
Owner and AddressOwner and address on the record
LocationCity, county and state
Casing and Casing DiameterCasing depth in feet and diameter in inches
Static Water LevelRecorded water level, in feet
YieldRecorded flow rate, in gallons per minute
Date DrilledDate on the record
Well Use and StatusReported use and status
DrillerDriller on the record
Aquifer and FormationAquifer and formation information on the record
Bedrock DepthRecorded depth to bedrock, in feet

A missing value does not establish the conditions at the site. Use the source report and professional advice for planning decisions.

Exporting Well Data

Use Export wells on the map to download well records as a CSV file. Map Navigation explains how to choose the area. The file has one row per well and these columns:

ColumnContents
drillerdb_idDrillerDB record number for the well
well_idWell ID assigned by the reporting agency
stateState or province
countyCounty named on the state record
latitude, longitudeWell location in decimal degrees
distance_kmDistance from the center point (radius exports only)
total_depth_ftTotal depth drilled, in feet
static_water_level_ftStatic water level, in feet
yield_gpmYield, in gallons per minute
date_drilledDate drilled (YYYY-MM-DD)
bore_diameter_inBore diameter, in inches
casing_diameter_inCasing diameter, in inches
casing_depth_ftCasing depth, in feet
well_useUse reported by the state (domestic, irrigation, and so on)
well_statusStatus reported by the state
aquiferAquifer, where the state reports one
drillerDrilling company on the record
source_datasetThe state data set the record came from
state_well_log_urlThe state's well log page or scan, where one exists
drillerdb_urlLink that opens the well on the DepthMap map

A blank cell means the state record has no value for that field. It is not a zero. Field coverage follows what each state publishes, so some columns are mostly blank in some states. Owner names are not included in exports.

The data comes from state agency well records. When you use an export in a report or another tool, credit the source as "state agency well records via DrillerDB (drillerdb.com)". The state_well_log_url and drillerdb_url columns give the source of each row.

Troubleshooting

Total Depth shows N/A?

  • N/A means the state's record for that well has no depth on file. A numeric depth of 0 also shows N/A.
  • N/A does not tell you why the depth is missing or whether drilling is complete. Check the source record for that information.
  • Compare nearby records that do have a depth, and check the state well log where one is linked.
  • The console well card uses Unknown for missing depth. Legacy nearby-well cards can show Depth N/A, and label casing-only records separately from total depth.

A well shows a note instead of its full record?

When you click a well, its card opens at once with the basic details from the map, then loads the full record. If the full record cannot load, the card keeps the basic details and adds one of these notes:

Note on the cardWhat to do
"Too many well lookups. Try again in 30 seconds." The note gives the time left.You opened many wells in a short time. Wait for the time in the note. Until then, a click on a well shows the note again with the time left, and the map does not look the well up.
"The full record could not load. Click the well again to try again."Click the well again.
"No full record was found for this well."The map has only the basic details for this well.
"You are signed out. Sign in again to see this well's full record."Sign in again, then click the well.
"Your subscription is not active, so the full record is not shown. Renew it in Settings > Billing."Renew the subscription in Settings > Billing. See Managing Your DepthMap Subscription.
"Your role cannot open full well records. Ask an admin for Well Map access."Ask an admin on your account to check your role.