Nebraska Test Hole Database

General Characteristics Metadata:

• Identification_Information
• Data_Quality_Information
• Spatial_Data_Organization_Information
• Spatial_Reference_Information
• Entity_and_Attribute_Information
• Distribution_Information
• Metadata_Reference_Information

Identification_Information:

Citation:

Citation_Information:

Originator:

Conservation & Survey Division, University of Nebraska-Lincoln (CSD)

Publication_Date: 2007

Title: Nebraska Test Hole Database

Edition: 1.0

Geospatial_Data_Presentation_Form: Tabular digital data

Publication_Information:

Publication_Place: Lincoln, NE

Publisher:

Conservation & Survey Division, University of Nebraska-Lincoln (CSD)

Online_Linkage: <http://csd.unl.edu/general/gis-datasets.asp>

Description:

Abstract:

From the early 1930's to the present, the University of Nebraska-Lincoln Conservation and Survey Division (CSD) has drilled 'test holes' to examine the geology and hydrogeology of Nebraska. On-site sample description and collection of samples for analysis are major parts of the 'survey' mission. Over 5000 wells have been drilled as part of the test hole program. CSD geoscientists described the drilling logs in detail on-site. Reworking of the log and description are common, as staff and abilities change. This database emphasizes spatially referenced lighologic and stratigraphic data for the state.

Purpose:

To provide spatially referenced geologic data for the state of Nebraska.

Time_Period_of_Content:

Time_Period_Information:

Range_of_Dates/Times:

Beginning_Date: 1931

Ending_Date: Present

Currentness_Reference:

The beginning date was determined from the earliest year identified in the test hole log books. The drilling efforts are on-going. This version of the database was finalized in early 2007.

Status:

Progress: In work

Maintenance_and_Update_Frequency: As needed

Spatial_Domain:

Bounding_Coordinates:

West_Bounding_Coordinate: -104.052016

East_Bounding_Coordinate: -95.381093

North_Bounding_Coordinate: 42.998818

South_Bounding_Coordinate: 40.000349

Keywords:

Theme:

Theme_Keyword_Thesaurus: ESRI

Theme_Keyword: geoscientificInformation

Theme:

Theme_Keyword_Thesaurus: none

Theme_Keyword: Stratigraphy

Theme_Keyword: Lithology

Theme_Keyword: Hydrology

Theme_Keyword: Groundwater

Theme_Keyword: Geology

Place:

Place_Keyword_Thesaurus: none

Place_Keyword: Nebraska

Access_Constraints: None

Use_Constraints:

The data are the intellectual property of the University of Nebraska. The data may not be redistributed without permission to do so by the person(s) or unit listed as the Originator(s). In any product, including data, publications, or presentations generated using these data, it is required that the Conservation and Survey Division, University of Nebraska-Lincoln be acknowledged. Please include the following source citation: "Test holes drilled in Nebraska by the Conservation and Survey Division, University of Nebraska-Lincoln (CSD), for the study of geology.

Point_of_Contact:

Contact_Information:

Contact_Organization_Primary:

Contact_Organization:

Conservation & Survey Division, University of Nebraska-Lincoln (CSD)

Contact_Position: GIS Manager

Contact_Address:

Address_Type: mailing address

Address:

Hardin Hall 3310 Holdrege Street

City: Lincoln

State_or_Province: NE

Postal_Code: 68583-0961

Country: USA

Contact_Voice_Telephone: 402-472-3471

Contact_Facsimile_Telephone: 402-472-2410

Contact_Electronic_Mail_Address: gismanager@unl.edu

Hours_of_Service: 8:00-5:00 Central Time

Contact_Instructions: Business is conducted Monday-Friday, except holidays

Browse_Graphic:

Browse_Graphic_File_Name: <http://csd.unl.edu/general/metadata/thumbnails/tn_testholes.jpg>

Browse_Graphic_File_Description: Test hole locations

Browse_Graphic_File_Type: JPEG

Native_Data_Set_Environment:

MS Access ArcInfo in a Windows environment; versions very with data set.

Data_Quality_Information:

Attribute_Accuracy:

Attribute_Accuracy_Report:

Testholes were initially located using legal description and footages from known points. The database coordinates were derived from a program that converts legal descriptions to latitude and longitude. Using ArcInfo GIS software, the point locations were plotted on 1:50,000 scale county maps and locational accuracy was checked against the original test hole logs. Any decrepancies were checked and edited accordingly. If a test hole was "relocated", the location was edited using ArcInfo. Once all points were properly located, the 'addxy' command was excecuted in ArcInfo to add the current and correct coordinates to the county GIS layer. County layers were then merged to form a statewide layer.
Other programs were written to extract detailed information from the existing digital test hole log documents and to develop the relational database within MS Access.

Logical_Consistency_Report:

Records in the database have been checked against the original test hole log books.

Completeness_Report: The database is statewide and updated as needed

Lineage:

Source_Information:

Source_Citation:

Citation_Information:

Originator:

Conservation & Survey Division, University of Nebraska-Lincoln (CSD)

Publication_Date: 2007

Title: Nebraska Statewide Test Hole Database

Edition: 1.0

Geospatial_Data_Presentation_Form: Tabular digital data

Publication_Information:

Publication_Place: Lincoln, NE

Publisher:

Conservation & Survey Division, University of Nebraska-Lincoln (CSD)

Type_of_Source_Media: Online

Source_Time_Period_of_Content:

Time_Period_Information:

Range_of_Dates/Times:

Beginning_Date: 1930

Ending_Date: Present

Source_Currentness_Reference: publication date

Source_Citation_Abbreviation: CSD test hole logs

Source_Contribution:

Information from the original test hole logs was used to develop this database

Process_Step:

Process_Description:

Testholes were initially located using legal description and footages from known points. The database coordinates were derived from a program that converts legal descriptions to latitude and longitude. Using ArcInfo GIS software, the point locations were plotted on 1:50,000 scale county maps and locational accuracy was checked against the original test hole logs. Any decrepancies were checked and edited accordingly. If a test hole was "relocated", the location was edited using ArcInfo. Once all points were properly located, the 'addxy' command was excecuted in ArcInfo to add the current and correct coordinates to the county GIS layer. County layers were then merged to form a statewide layer.
Other programs were written to extract detailed information from the existing digital test hole log documents and to develop the relational database within MS Access.

Source_Used_Citation_Abbreviation: CSD test hole log books

Process_Date: 2006

Process_Contact:

Contact_Information:

Contact_Organization_Primary:

Contact_Organization:

Conservation & Survey Division, University of Nebraska-Lincoln (CSD)

Contact_Position:

Jerry Ayers Hydrogeologist

Contact_Address:

Address_Type: mailing address

Address:

Hardin Hall 3310 Holdrege Street

City: Lincoln

State_or_Province: NE

Postal_Code: 68583-0961

Country: USA

Contact_Voice_Telephone: 402-472-3471

Contact_Facsimile_Telephone: 402-472-2410

Contact_Electronic_Mail_Address: gismanager@unl.edu

Hours_of_Service:

8:00-5:00 M-F Central Time except holidays

Spatial_Data_Organization_Information:

Direct_Spatial_Reference_Method: Point

Point_and_Vector_Object_Information:

SDTS_Terms_Description:

SDTS_Point_and_Vector_Object_Type: Entity point

Point_and_Vector_Object_Count: 5432

Spatial_Reference_Information:

Horizontal_Coordinate_System_Definition:

Geographic:

Latitude_Resolution: 0.000001

Longitude_Resolution: 0.000001

Geographic_Coordinate_Units: Decimal degrees

Entity_and_Attribute_Information:

Detailed_Description:

Entity_Type:

Entity_Type_Label: General_Char

Entity_Type_Definition: General characteristics of CSD test holes

Entity_Type_Definition_Source: CSD

Attribute:

Attribute_Label: LogID

Attribute_Definition: Name used to identify individual test holes

Attribute_Definition_Source: CSD

Attribute_Domain_Values:

Unrepresentable_Domain: Unique test hole identification

Attribute:

Attribute_Label: Log Type

Attribute_Definition: Type of log

Attribute_Definition_Source: CSD

Attribute_Domain_Values:

Enumerated_Domain:

Enumerated_Domain_Value:

Unk - unknown Fld - raw field log Sum - summarized log (no stratigraphy) Cmp - completed log

Enumerated_Domain_Value_Definition:

Unk - unknown Fld - raw field log Sum - summarized log (no stratigraphy) Cmp - completed log

Enumerated_Domain_Value_Definition_Source: CSD

Attribute:

Attribute_Label: YrDrill

Attribute_Definition: Year the test hole was drilled

Attribute_Definition_Source: CSD

Attribute_Domain_Values:

Range_Domain:

Range_Domain_Minimum: 1930

Range_Domain_Maximum: Present

Attribute_Units_of_Measure: Year

Attribute:

Attribute_Label: TwnShp

Attribute_Definition: Township number

Attribute_Definition_Source: CSD

Attribute_Domain_Values:

Unrepresentable_Domain: Township number north of the 40th parallel

Attribute:

Attribute_Label: TwnShpDir

Attribute_Definition:

Township direction designated as N for north. All townships in Nebraska are designated as north.

Attribute_Definition_Source: CSD

Attribute_Domain_Values:

Enumerated_Domain:

Enumerated_Domain_Value: N - north

Enumerated_Domain_Value_Definition: Direction

Enumerated_Domain_Value_Definition_Source: CSD

Attribute:

Attribute_Label: Rng

Attribute_Definition: Range

Attribute_Definition_Source: CSD

Attribute_Domain_Values:

Unrepresentable_Domain: Range number east or west of the Principal Meridian.

Attribute:

Attribute_Label: RngDir

Attribute_Definition: Range direction either E (east) or W (west)

Attribute_Definition_Source: CSD

Attribute_Domain_Values:

Enumerated_Domain:

Enumerated_Domain_Value:

E - east W - west

Enumerated_Domain_Value_Definition: Direction

Enumerated_Domain_Value_Definition_Source: CSD

Attribute:

Attribute_Label: Sec

Attribute_Definition: Section number

Attribute_Definition_Source: CSD

Attribute_Domain_Values:

Range_Domain:

Range_Domain_Minimum: 1

Range_Domain_Maximum: 36

Attribute:

Attribute_Label: SubSec

Attribute_Definition:

Subsection designation (A, B, C, D) from the largest subsection to the smallest.

Attribute_Definition_Source: CSD

Attribute_Domain_Values:

Unrepresentable_Domain:

Standard method of describing the breakdown of a section into quater sections with a maximum of four iterations.

Attribute:

Attribute_Label: FtNS

Attribute_Definition:

Footage either + (north) or - (south) of an east-west section line.
A value of 9999.0 indicates no data avaialble.

Attribute_Definition_Source: CSD

Attribute_Domain_Values:

Unrepresentable_Domain:

Numeric value representing footage north (+) or south (-) of an east-west section line. Values of 9999.0 indicate no data available from the log.

Attribute:

Attribute_Label: FtEW

Attribute_Definition:

Footage either + (east) or - (west) of an north-south section line.
A value of 9999.0 indicates no data avaialble.

Attribute_Definition_Source: CSD

Attribute_Domain_Values:

Unrepresentable_Domain:

Numeric value representing footage east (+) or west (-) of a north-south section line. Values of 9999.0 indicate no data available from the log.

Attribute:

Attribute_Label: Lng

Attribute_Definition: Longitude

Attribute_Definition_Source: CSD

Attribute_Domain_Values:

Unrepresentable_Domain: Longitude

Attribute:

Attribute_Label: Lat

Attribute_Definition: Latitude

Attribute_Definition_Source: CSD

Attribute_Domain_Values:

Unrepresentable_Domain: Latitude

Attribute:

Attribute_Label: Datum

Attribute_Definition: Datum used for determination of latitude and longitude

Attribute_Definition_Source: CSD

Attribute_Domain_Values:

Unrepresentable_Domain: none

Attribute:

Attribute_Label: Cnty

Attribute_Definition: County

Attribute_Definition_Source: CSD

Attribute_Domain_Values:

Unrepresentable_Domain: Designated county name

Attribute:

Attribute_Label: NRD

Attribute_Definition: Natural Resources District

Attribute_Definition_Source: CSD

Attribute_Domain_Values:

Unrepresentable_Domain: Designated NRD name

Attribute:

Attribute_Label: Quad

Attribute_Definition: USGS 7.5 minute quadrangle name

Attribute_Definition_Source: CSD

Attribute_Domain_Values:

Unrepresentable_Domain: Designated 7.5" quad name

Attribute:

Attribute_Label: 100K_Map

Attribute_Definition: USGS 1:100,000 scale map name

Attribute_Definition_Source: CSD

Attribute_Domain_Values:

Unrepresentable_Domain: Designated name

Attribute:

Attribute_Label: 250K_Map

Attribute_Definition: USGS 1:250,000 scale map name

Attribute_Definition_Source: CSD

Attribute_Domain_Values:

Unrepresentable_Domain: Designated name

Attribute:

Attribute_Label: FldLog_Elev

Attribute_Definition: Elevatoin in feet noted on test hole field log

Attribute_Definition_Source: CSD

Attribute_Domain_Values:

Unrepresentable_Domain: Elevation in feet

Attribute:

Attribute_Label: ScrFld_Elev

Attribute_Definition: How elevation was determined in the field

Attribute_Definition_Source: CSD

Attribute_Domain_Values:

Enumerated_Domain:

Enumerated_Domain_Value:

i - instrument survey s - spriit level survey h - hand level survey t - estimated from topographic map u - unknown

Enumerated_Domain_Value_Definition:

i - instrument survey s - spriit level survey h - hand level survey t - estimated from topographic map u - unknown

Enumerated_Domain_Value_Definition_Source: CSD

Attribute:

Attribute_Label: DEM

Attribute_Definition:

Elevation in feet extracted from USGS Digital Elevation Model using ArcInfo GIS.

Attribute_Definition_Source: CSD

Attribute_Domain_Values:

Unrepresentable_Domain: Elevation in feet

Attribute:

Attribute_Label: Fin_Elev

Attribute_Definition: Best estimate of elevation for the test hole site

Attribute_Definition_Source: CSD

Attribute_Domain_Values:

Unrepresentable_Domain: Final elevation as best determined from available data sources

Attribute:

Attribute_Label: ScrFin_Elev

Attribute_Definition: Source of final elevation determination

Attribute_Definition_Source: CSD

Attribute_Domain_Values:

Enumerated_Domain:

Enumerated_Domain_Value:

LOG - used field log elevation DEM - used Digital Elevation Model elevation MAP - used 7.5 minute quadrangle elevation

Enumerated_Domain_Value_Definition:

LOG - used field log elevation DEM - used Digital Elevation Model elevation MAP - used 7.5 minute quadrangle elevation

Enumerated_Domain_Value_Definition_Source: CSD

Attribute:

Attribute_Label: DTW

Attribute_Definition: Depth to water measured at the time the test hole was drilled

Attribute_Definition_Source: CSD

Attribute_Domain_Values:

Unrepresentable_Domain: Depth to water

Attribute:

Attribute_Label: TD

Attribute_Definition: Total depth in feet of the test hole

Attribute_Definition_Source: CSD

Attribute_Domain_Values:

Unrepresentable_Domain: Total depth

Attribute:

Attribute_Label: G_Logs

Attribute_Definition: Indicates if a geophysical log was run for the test hole

Attribute_Definition_Source: CSD

Attribute_Domain_Values:

Unrepresentable_Domain:

A check mark indicates the log was run.
If exported or viewed within an ArcInfo GIS database, values translate to: 0 = no check mark, log not run 1 = check mark, log run

Attribute:

Attribute_Label: E_Logs

Attribute_Definition:

Indicates that a digitized electric log is included in the database

Attribute_Definition_Source: CSD

Attribute_Domain_Values:

Unrepresentable_Domain:

A check mark indicates the log was run.
If exported or viewed within an ArcInfo GIS database, values translate to: 0 = no check mark, log not run 1 = check mark, log run

Attribute:

Attribute_Label: D_Logs

Attribute_Definition: Indicates that a digital log suite is included in the database

Attribute_Definition_Source: CSD

Attribute_Domain_Values:

Unrepresentable_Domain:

A check mark indicates the log was run.
If exported or viewed within an ArcInfo GIS database, values translate to: 0 = no check mark, log not run 1 = check mark, log run

Attribute:

Attribute_Label: HdrNotes

Attribute_Definition:

Any narrative or comments that pertain to the test hole log in general

Attribute_Definition_Source: CSD

Attribute_Domain_Values:

Unrepresentable_Domain: General notes pertaining to the log

Overview_Description:

Entity_and_Attribute_Overview:

Attributes found within the General Characteristics database include: LogID, YrDrill, TwnShp, TwnShpDir, Rng, RngDir, Sec, SubSec, FtNS, FtEW, Long, Lat, Datum, Cnty, NRD, Quad, 100k_Map, 250k_Map, FldLog_Elev, ScrFld_Elev, DEM, Fin_Elev, ScrFin_Elev, DTW, TD, G_Logs, E_Logs, D_Logs, HdrNotes.

Entity_and_Attribute_Detail_Citation: None

Distribution_Information:

Distributor:

Contact_Information:

Contact_Organization_Primary:

Contact_Organization:

Conservation & Survey Division, University of Nebraska-Lincoln (CSD)

Contact_Position: GIS Manager

Contact_Address:

Address_Type: mailing address

Address:

Hardin Hall 3310 Holdrege Street

City: Lincoln

State_or_Province: NE

Postal_Code: 68583-0961

Country: USA

Contact_Voice_Telephone: 402-472-3471

Contact_Facsimile_Telephone: 402-472-2410

Contact_Electronic_Mail_Address: gismanager@unl.edu

Hours_of_Service: 8:00-5:00 M-F Central Time

Contact_Instructions: Business is conducted Monday-Friday, except holidays

Resource_Description: Downloadable Data

Distribution_Liability:

The Conservation and Survey Division, University of Nebraska-Lincoln has produced this product using what is thought to be the most reliable information available or reproduced the material as provided. The detail and precision of the interpretations made are according to accepted professional standards and are dependent upon the techicques, hardware, and/or software utilized. The user must be aware of data conditions and bear responsibility for the appropriate use of the information with respect to possible errors, original map scale, collection methodology, currency of data and other conditions specific to certain data. No warranty expressed or implied is made by the University of Nebraska regarding the positional or attribute accuracy or utility of this information. The act of distribution shall not constitute any such warranty and no responsibility is assumed by the University of Nebraska in the use of the data.

Standard_Order_Process:

Digital_Form:

Digital_Transfer_Information:

Format_Name:

ARCE MS Access

File_Decompression_Technique: No compression applied

Transfer_Size: 275

Digital_Transfer_Option:

Online_Option:

Computer_Contact_Information:

Network_Address:

Network_Resource_Name: <http://csd.unl.edu/general/gis-datasets.asp>

Online_Computer_and_Operating_System: Varies

Offline_Option:

Offline_Media: CD-ROM

Recording_Format: Varies

Compatibility_Information: Varies

Fees:

No fee for online downloads. Fees may apply in other cases depending on media and processing time.

Ordering_Instructions: E-mail, FAX or write with request. Letterhead preferred.

Turnaround: varies with media

Custom_Order_Process: Written request, billed as Time & Materials

Technical_Prerequisites: Must have knowledge of MS Access to use the database

Available_Time_Period:

Time_Period_Information:

Range_of_Dates/Times:

Beginning_Date: 1931

Ending_Date: 2007

Metadata_Reference_Information:

Metadata_Date: 200703

Metadata_Contact:

Contact_Information:

Contact_Organization_Primary:

Contact_Organization:

Conservation & Survey Division, University of Nebraska-Lincoln (CSD)

Contact_Person: GIS Manager

Contact_Position: GIS Manager

Contact_Address:

Address_Type: mailing address

Address:

Hardin Hall 3310 Holdrege Street

City: Lincoln

State_or_Province: NE

Postal_Code: 68583-0961

Country: USA

Contact_Voice_Telephone: 402-472-3471

Contact_Facsimile_Telephone: 402-472-2410

Contact_Electronic_Mail_Address: rsimpson2@unl.edu

Hours_of_Service:

8:00-5:00 Central Time except holidays

Contact_Instructions: Contact by e-mail recommended.

Metadata_Standard_Name: FGDC Content Standards for Digital Geospatial Metadata

Metadata_Standard_Version: FGDC-STD-001-1998

Metadata_Time_Convention: local time

Metadata_Access_Constraints: none

Metadata_Use_Constraints:

This metadata file is intended to accompany the geospatial data set identified and received from the Conservation and Survey Division, University of Nebraska-Lincoln. It is not to be altered or summarized. CSD does not encourage secondary distribution of data. If this geospatial data set was received from anyone besides CSD, this metadata file and the geospatial data set it describes may lack integrity.