High Plains Ground-Water Quality Data Base 
(MS Access version)

The file data.mdb contains the MS Access version of 
the High Plains Ground-Water Quality Data Base. 
This is an MS Access 2000 data base file which 
requires the user to have a copy of MS Access 2000 
available on their computer. It can be opened 
simply by double clicking on the data file name.

Appendices A and B of the report WRIR00-4254 
contain details about the content and structure of 
the data base. There are 8 primary linked tables 
contained in the data base (AGENCIES, DATASOURCE, 
GEOHYDROLOGY, OPENINGS, PARAMETER, PROJECTS, 
QW_RESULT, SITE) and the links between the tables 
are shown in Appendix B-4. The remaining 10 tables 
(prefixed with 'tbl') are lookup tables that 
contain the meanings of some of the codes used in 
the data base. The basic content of the tables is 
as follows:


AGENCIES: Agencies whose data is contained in the data base. 
Each water-quality result is linked to an AGENCY using the 
AGENCY-CODE.

DATASOURCE: Agencies that transmitted data to the data base. 
Some data sources supplied data for multiple agencies. Each 
site in the data base is linked to a DATASOURCE using the 
DATASOURCE code.

GEOHYDROLOGY: Information about the aquifers penetrated by 
wells. Some wells penetrate multiple aquifers; a sequence 
number is used to code multiple aquifers for a well. 
Relatively few wells had geohydrology information available. 
The GEOHYDROLOGY table is linked to the SITE table using the 
site ID.

OPENINGS: Information about the open intervals in the well 
casings. Some wells had multiple open intervals; a sequence 
number is used to code multiple well opening intervals. 
Relatively few wells had opening information available. The 
OPENINGS table is linked to the SITE table using the site 
ID.

PARAMETER: Information defining each result or measurement 
made at a well. The PARAMETER table is linked to the 
QW_RESULT table using the Ppcode.
PROJECTS: Information about projects under which data were 
collected. Relatively few results had project information. 
The PROJECTS table is linked to the QW_RESULT table using 
the ProjectID.

QW_RESULT: This is the primary and largest table in the data 
base. It contains each result or measurement made at a well 
site. It is linked to the SITE table using the site ID, and 
it is linked to the PARAMETER table using the Ppcode.

SITE: This is the second largest table in the data base, and 
contains information about each well site. It is linked to 
the QW_RESULT, OPENINGS, and GEOHYDROLOGY table using the 
site ID, and to the DATASOURCE table using the 
DataSourceCode.

The remaining tables are lookup tables:

tblAquiferType: Meaning of aquifer type codes used in the 
SITE table.

tblCasingMaterial: Meaning of casing material codes used in 
the SITE table.

tblCoordinateAccuracy: Meaning of coordinate accuracy codes 
used in the SITE table.

tblCounties: Meaning of the county codes used in the SITE 
table.

tblDataQuality: Meaning of the data quality codes used in 
the QW_RESULT table.

tblGroundWaterSiteType: Meaning of the ground water site 
type codes used in the SITE table.

tblGeoHydrologicUnits: Meaning of the aquifer codes used in 
the SITE table, and the geohydroloic unit codes used in the 
GEOHYDROLOGY table.

tblSiteUse: Meaning of the site use codes in the SITE table.

tblValueRemarks: Meaning of the value remark codes used in 
the QW_RESULT table.

tblWaterUse: Meaning of the water use codes used in the SITE 
table.

