Well Information and Water-Level Databases

Data used to prepare the well information and water-level measurement databases used throughout this web site were obtained from the Rio Grande Water Conservation District (RGWCD), the US Bureau of Reclamation (USBR), The US Geological Survey Ground Water Site Inventory Database (GWSI), and the Rio Grande Decision Support System Database (RGDSS).

Download 1.3MB file dbf.zip containing well information & water-level measurement databases in DBF format (modified on Fri Jun 20 11:36:23 2008).

Field definitions for well information database master.dbf

UID

[PM] Unique Well Identifier

ALIAS

[PM] Well names from source agency

AQFR

[PM] Aquifer selected from RGDSS piezometer, Designated in GRSA model, Well depth

AQUIFER

[PM] Selected Aquifer Definition from AQFR or LAYER fields

AQ_SRC

[PM] Source used to select AQUIFER field

BOT0

[PM] Depth to top of Layer 1 RGDSS Model

BOT1

[PM] Depth to Bottom of Layer 1 RGDSS Model

BOT2

[PM] Depth to Bottom of Layer 2 RGDSS Model

BOT3

[PM] Depth to Bottom of Layer 3 RGDSS Model

BOT4

[PM] Depth to Bottom of Layer 4 RGDSS Model

BOT5

[PM] Depth to Bottom of Layer 5 RGDSS Model

CAWS

[PM] Designated Confined Aquifer Well Sites

DStoPM

[PM] Original source of data

GS

[PM] Selected ground surface elevation (NGD88)

GS_SRC

[PM] Ground surface elevation source

LAT

[PM] Selected Latitude data (NAD83)

LON

[PM] Selected Longitude data (NAD83)

LL_SRC

[PM] Selected Lat/Lon source

LAYER

[PM] Selected RGDSS Model Layer

LAYER_SRC

[PM] RGDSS Model Layer Source

NED3

[PM] Ground surface elevation from National 1/3-Arc Second Elevation Dataset (based on selected LON/LAT)

NED

[PM] Ground surface elevation from National Elevation Dataset (based on selected LON/LAT)

SRTM

[PM] Ground surface elevation from Shuttle Radar Topography Mission (based on selected LON/LAT)

TD

[PM] Selected Total Depth

TGTID

[PM] Calibration Target Well ID

TRS

[PM] Selected Township-Range-Section

VID

[PM] Valley Well Identification

XVAL

[PM] RGDSS Coordinate System Easting

YVAL

[PM] RGDSS Coordinate System Northing

GW_AGENCY

[GWSI] Agency

GW_SID

[GWSI] Site identification number

GW_STA_NAM

[GWSI] Site name

GW_LATDMS

[GWSI] DMS latitude

GW_LONDMS

[GWSI] DMS longitude

GW_LAT

[GWSI] Decimal latitude

GW_LON

[GWSI] Decimal longitude

GW_LL_METH

[GWSI] Latitude-longitude method

GW_LL_ACCU

[GWSI] Latitude-longitude accuracy

GW_HOR_DAT

[GWSI] Latitude-longitude datum

GW_DMS_METH

[GWSI] Decimal Latitude-longitude datum

GW_DIS_COD

[GWSI] District code

GW_STATE

[GWSI] State code

GW_CTY_COD

[GWSI] County code

GW_COUNTRY

[GWSI] Country code

GW_TRS_2

[GWSI] Land net location description

GW_MAP_NAM

[GWSI] Name of location map

GW_MAP_SCL

[GWSI] Scale of location map

GW_GS_ELEV

[GWSI] Altitude of Gage/land surface

GW_ALT_METH

[GWSI] Method altitude determined

GW_GE_ACCU

[GWSI] Altitude accuracy

GW_VERTDAT

[GWSI] Altitude datum

GW_HUC

[GWSI] Hydrologic unit code

GW_BAS_COD

[GWSI] Drainage basin code

GW_TOPO

[GWSI] Topographic setting code

GW_STATION

[GWSI] Site type code

GW_AGE_USE

[GWSI] Agency use of site code

GW_DATAKIND

[GWSI] Flags for the type of data collected

GW_INSTRU

[GWSI] Flags for instruments at site

GW_CONDATE

[GWSI] Date of first construction

GW_INVDATE

[GWSI] Date site established or inventoried

GW_DR_AREA

[GWSI] Drainage area

GW_CDR_AREA

[GWSI] Contributing drainage area

GW_GMTOFF

[GWSI] Mean Greenwich time offset

GW_LTIME

[GWSI] Local standard time flag

GW_RELIA

[GWSI] Data reliability code

GW_GWFILE

[GWSI] Data-other GW files

GW_GWTYPE

[GWSI] Type of ground water site

GW_NAT_AQFR

[GWSI] National aquifer code

GW_AQNAME

[GWSI] Local aquifer code

GW_AQ_TYPE

[GWSI] Local aquifer type code

GW_WEL_DEP

[GWSI] Well depth

GW_HOL_DEP

[GWSI] Hole depth

GW_DD_SRC

[GWSI] Source of depth data

GW_PRO_NUM

[GWSI] Project number

GW_RT

[GWSI] Real-time data flag

GW_WQSTRT

[GWSI] Water quality data begin date

GW_WQEND

[GWSI] Water quality data end date

GW_WQNUM

[GWSI] Water quality data count

GW_GWSTRT

[GWSI] Ground-water data begin date

GW_GWEND

[GWSI] Ground-water data end date

GW_GWNUM

[GWSI] Ground-water data count

GW_WATERUSE

[GWSI] Groundwater use (primary)

GW_SITEUSE

[GWSI] Site use (primary)

SRV01_ID

[RGWCD] 2006 Survey Data IDs

RGWCD_AQ

[RGWCD] Aquifer

RGWCD_GS

[RGWCD] Ground Surface Elevation

RGWCD_COM

[RGWCD] Comments

RGWCD_LAYER

[RGWCD] RGDSS Groundwater Model layer intercepted by well

RGWCD_ID

[RGDSS] Identification Number

RGWCD_TRS

[RGWCD] Township-Range-Section

RGWCD_MP

[RGWCD] Measureing Point Elevation

RGWCD_SU

[RGWCD] Well casing stickup

RGWCD_TD

[RGWCD] Total depth of well

RGWCD_LON

[RGWCD] Longitude (decimal)

RGWCD_LAT

[RGWCD] Latitude (decimal)

RGWCD_LON0

[RGWCD] Longitude (in original format)

RGWCD_LAT0

[RGWCD] Latitude (in original format)

RGWCD_DATUM

[RGWCD] LON/LAT Datum

RGWCD_NAD

[RGWCD] Vertical Datum

RGWCD_ID

[RGDSS] Identification Number

RGDSS_GS

[RGDSS] Ground Surface Elevation

RGDSS_DATUM

[RGDSS] Horizontal Datum

RGDSS_PERM

[RGDSS] Well permit number

RGDSS_PLSS

[RGDSS] Township-Range-Section

RGDSS_LON

[RGDSS] Longitude

RGDSS_LAT

[RGDSS] Latitude

RGDSS_NAD

[RGDSS] Vertical Datum

RGDSS_VID

[RGDSS] Valley Identification Number

RGDSS_TD

[RGDSS] Total Depth

RGDSS_AQFR

[RGDSS] Unconfined or confined aquifer layer

RGDSS_LAYER

[RGDSS] RGDSS Groundwater Model Layer

EW_NAD

[USBR] Vertical Datum

EW_DATUM

[USBR] Horizontal Datum

EW_AQFR

[USBR] Aquifer

EW_GS_ELEV

[USBR] Ground Surface Elevation

EW_LAT

[USBR] Latitude

EW_LON

[USBR] Longitude

EW_SID

[USBR] Site Identification Number

EW_TD

[USBR] Total Depth

EW_TRS

[USBR] Township-Range-Section

DUNES_ID

[HRS] Original DUNES Identification

DUNE_LAYER

[HRS] Layer Definitions from Dunes data

HRS_AQUIFER

[HRS] Aquifer Type

HRS_DATUM

[HRS] Horizontal Datum

HRS_GS

[HRS] Ground Surface Elevation

HRS_LAT

[HRS] Latitude

HRS_LON

[HRS] Longitude

HRS_NAD

[HRS] Vertical Datum

HRS_SEQ

[HRS] Sequence Number

HRS_SOURCE

[HRS] Data Source

HRS_X_UTM

[HRS] UTM Easting

HRS_Y_UTM

[HRS] UTM Northing

JCHA_DATE

[JHCA] Construction Date

JCHA_DATUM

[JHCA] Horizontal Datum

JCHA_DESC

[JHCA] Description

JCHA_GS

[JHCA] Ground Surface Elevation

JCHA_HRS_GS

[JHCA] Ground Surface Elevation from HRS

JCHA_NAD

[JHCA] Vertical Datum

JCHA_SPCS_E

[JHCA] State Place Coordinate System Easting

JCHA_SPCS_N

[JHCA] State Place Coordinate System Northing

JCHA_TD

[JHCA] Total Depth

JCHA_TRS

[JHCA] Township-Range-Section

GRSA_ID

[GSDNP] GSDNP Well Identification Number

GRSA_AQFR

[GSDNP] Aquifer

GRSA_MP

[GSDNP] Measuring Point Elevation

GRSA_TPERF

[GSDNP] Top of Perforations

GRSA_BPERF

[GSDNP] Bottom of Perforations

CSU_GS

[CSU] Ground Surface Elevation

Field definitions for well information REMARKS database rmks.dbf

UID

Unique Site Identifier: Consists of GWSI Site ID (approximate LAT/LON) where available. Otherwise, consists of ID in source database

C184

[GWSI] Remark date: YYYYMMDD

C185

[GWSI] Remark

C311

[GWSI] Remark record sequence number

C463

[GWSI] Person creating record

C464

[GWSI] Date created

C465

[GWSI] Person updating record

C788

[GWSI] Record type

C789

[GWSI] Date of last update

C870

[GWSI] Record ready for web

Field definitions for well information PRODUCTION (Discharge) database prod.dbf

UID

Unique Site Identifier: Consists of GWSI Site ID (approximate LAT/LON+COUNTER) where available. Otherwise, consists of ID in source database

C148

[GWSI] Date discharge measured

C150

[GWSI] Discharge in gpm

C151

[GWSI] Source of discharge data

C152

[GWSI] Method discharge measured

C153

[GWSI] Producing water level

C154

[GWSI] Static water level

C155

[GWSI] Source of water-levels dat

C156

[GWSI] Method water levels measured

C157

[GWSI] Duration of discharge before producing level

C272

[GWSI] Specific capacity

C309

[GWSI] Drawdown

C430

[GWSI] Person creating record

C431

[GWSI] Date created

C432

[GWSI] Person updating record

C702

[GWSI] Date of last update

C703

[GWSI] Type of discharge: P = pump, F = flow

C859

[GWSI] Record ready for Web: Codes are defined below.
Y = The record has been checked and is ready for display.
C = The record has not been checked.
N = The record has failed one or more data verification checks.
P = The record is proprietary.
L = Display of the record has been turned off.

Field definitions for well information AQUIFER database aq.dbf

UID

Unique Site Identifier: Consists of GWSI Site ID (approximate LAT/LON+COUNTER) where available. Otherwise, consists of ID in source database

C095

[GWSI] Date data collected: YYYYMMDD

C126

[GWSI] Static Water Level

C132

[GWSI] Percentage of the total yield of the well that is contributed by this lithologic unit, if known.

C256

[GWSI] Aquifers record sequence number

C469

[GWSI] Person creating record

C470

[GWSI] Date created

C471

[GWSI] Person updating record

C750

[GWSI] Record type

C751

[GWSI] Date of last update

C872

[GWSI] Record Ready for Web: Codes are defined below.
Y = The record has been checked and is ready for display.
C = The record has not been checked.
N = The record has failed one or more data verification checks.
P = The record is proprietary.
L = Display of the record has been turned off.

Field definitions for well information CONSTRUCTION database cons.dbf

UID

Unique Site Identifier: Consists of GWSI Site ID (approximate LAT/LON+COUNTER) where available. Otherwise, consists of ID in source database

C060

[GWSI] Date of Completed Construction

C063

[GWSI] Name of Contractor/Driller

C064

[GWSI] Source of Construction Data

C065

[GWSI] Method of Construction: Codes are defined below.
A = Air-rotary
B = Bored or augered
C = Cable-tool
D = Dug
H = Hydraulic rotary
J = Jetted
P = Air percussion
R = Reverse rotary
T = Trenching
V = Driven
W = Drive and wash
Z = Other (explain in remarks)

C066

[GWSI] Type of Finish: Codes are defined below.
C = Porous concrete
F = Gravel pack w/perforations
G = Gravel pack w/screen
H = Horizontal gallery
O = Open end
P = Perforated or slotted
S = Screen
T = Sand point
W = Walled
X = Open hole
Z = Other (explain in remarks)

C067

[GWSI] Type of Seal: Codes are defined below.
B = Bentonite
C = Clay or cuttings
G = Cement grout
N = None
Z = Other (explain in remarks)

C068

[GWSI] Depth to Bottom of Seal: feet below land surface

C069

[GWSI] Method of Development: Codes are defined below.
A = Pumped with air lift
B = Bailed
C = "Blown" or surged w/compressed air
J = Washed or jetted
N = None
P = Pumped
S = Surged with surge block

C070

[GWSI] Hours of Development

C071

[GWSI] Special Treatment During Development: Codes are defined below.
C = Chemical (acid, and so forth)
D = Dry ice
E = Explosives
F = Deflocculent
H = Hydrofracturing
M = Mechanical abrasion
Z = Other (explain in remarks)

C403

[GWSI] Person Creating Record

C404

[GWSI] Date/time that construction record was created

C405

[GWSI] Person Updating Record

C754

[GWSI] Record Type

C755

[GWSI] Date of Last Update

C850

[GWSI] Record Ready for Web: Codes are defined below.
Y = The record has been checked and is ready for display.
C = The record has not been checked.
N = The record has failed one or more data verification checks.
P = The record is proprietary.
L = Display of the record has been turned off.

Field definitions for well information GEOHYDROLOGY database geoh.dbf

UID

Unique Site Identifier: Consists of GWSI Site ID (approximate LAT/LON+COUNTER) where available. Otherwise, consists of ID in source database

C091

[GWSI] Depth to Top of Unit in feet below land surface

C092

[GWSI] Depth to Bottom of Unit in feet below land surface

C093

[GWSI] Unit Identifier: Codes defined below.
110QRNR = Quaternary System, 111ALFP = Alluvium, Flood Plain
111AVMT = Alluvium, terrace
111VLFL = Valley-Fill Deposits
112SNTF = Santa Fe Formation
120TRTR = Tertiary System
121ALMS = Alamosa Formation

C096

[GWSI] Lithology: Codes defined below.
ALVM Alluvium
GRDS Gravel, sand
SAND Sand
SDGL Sand and gravel

C097

[GWSI] Lithologic Modifier

C304

[GWSI] Contributing Unit: Codes are defined below.
P = Principal contributing aquifer (only one per site)
S = Secondary contributing aquifer
N = Contributes no water
U = Unknown contribution

C466

[GWSI] Person Creating Record

C467

[GWSI] Date Created

C468

[GWSI] Person Updating Record

C748

[GWSI] Record Type

C749

[GWSI] Date of last update

C871

[GWSI] Record Ready for Web: Codes are defined below.
Y = The record has been checked and is ready for display.
C = The record has not been checked.
N = The record has failed one or more data verification checks.
P = The record is proprietary.
L = Display of the record has been turned off.

Field definitions for well information LOG database log.dbf

UID

Unique Site Identifier: Consists of GWSI Site ID (approximate LAT/LON+COUNTER) where available. Otherwise, consists of ID in source database

C199

[GWSI] Type of log: Codes are defined below.
DT = Drilling time
DR = Drillers log
DG = Geologists log
DC = Core log
WC = Casing collar log
WD = Borehole deviation log
AS = Sonic log
AV = Acoustic velocity log
AW = Acoustic waveform log
AT = Acoustic televiewer log
CP = Caliper log
CS = Single caliper log
CT = Three caliper log
CM = Multi caliper log
CA = Acoustic caliper log
EE = Electric log
ER = Single-point resistance
EP = Spontaneous potential
EL = Long-normal resistivity
ES = Short-normal resistivity
EF = Focused resistivity log
ET = Lateral resistivity log
EN = Microresistivity log
FH = Heat-pulse flowmeter log
FE = EM flowmeter log
FD = Doppler flowmeter log
FA = Radioactive tracer log
FY = Dye tracer log
FB = Brine tracer log
MD = EM dual induction log
MM = Magnetic log
MS = Magnetic susceptibility
MI = EM induction log
MR = Radar reflection image log
MV = Radar direct-wave velocity
MA = Radar direct-wave amplitude
NG = Gamma log
NS = Spectral gamma log
NA = Gamma-gamma log
NN = Neutron log
NT = Neutron activation log
NM = Nuclear magnetic resonance
OV = Video log
OF = Fisheye video log
OS = Sidewall video log
OT = Optical televiewer log
EC = Microresist focused log
EO = Microresist lateral log
ED = Dipmeter log
FC = Fluid conductivity log
FR = Fluid resistivity log
FT = Fluid temperature log
FF = Fluid diff temperature
FV = Fluid velocity log
FS = Spinner flowmeter log
ZF = Gamma, fluid resist, temp
ZI = Gamma and EM induction log
ZR = Long/short normal resist log
ZT = Fluid resist, temperature
ZM = EM flowmeter, resist, SP log
ZN = Long/short normal resist, SP
ZP = Single point resist, SP
ZE = Gamma l/s resist, SP
OR = Other

C200

[GWSI] Depth to the top of the logged interval in feet below land surface

C201

[GWSI] Depth to the bottom of the logged interval, in feet below land surface

C202

[GWSI] Source of Data: Codes are defined below.
A = Reported by another government agency. Do not use "A" if the reporting agency is the owner of the well--use "O".
D = From driller's log or report.
G = Private geologist-consultant or university associate.
L = Depth interpreted from geophysical logs by personnel of source agency.
M = Memory (owner, operator, driller).
O = Reported by the owner of the well.
R = Reported by person other than the owner, driller, or another government agency.
S = Measured by personnel of reporting agency.
Z = Other source (explain in remarks).

C448

[GWSI] Person Creating Record

C449

[GWSI] Date Created

C450

[GWSI] Person Updating Record

C778

[GWSI] Record Type

C779

[GWSI] Date of Last Update

C865

[GWSI] Record Ready for Web: Codes are defined below.
Y = The record has been checked and is ready for display.
C = The record has not been checked.
N = The record has failed one or more data verification checks.
P = The record is proprietary.
L = Display of the record has been turned off.

Field definitions for water-level measurement database wl.dbf

UID

Unique Site Identifier: Consists of GWSI Site ID (approximate LAT/LON+COUNTER) where available. Otherwise, consists of ID in source database

DATE

Date of measurement

DTW

Depth to water in feet below ground surface

SOURCE

Source of data: G = US Geological Survey GWSI Database, R = US Bureau of Reclamation Database, D = RGWCD Database, S = RGDSS Database

The GWSI field decriptions were paraphrased from USGS Documentation