Organic Geochemical Data Base--Provisional Release

Energy Resources Program Geochemistry Data Base


	Home
	Introduction
	Download Data
	Documentation
	Contact Us
	Links

Last Data Base Update:

July, 2009

Data Base Documentation

Data Base Documentation In the public release of the Energy Geochemistry Database (EGDB), an attempt to place reasonable accuracy in reporting all site location (latitude and longitude) was undertaken in the generation of pseudo coordinates for sample locations originally derived from proprietary information. In instances where the information is proprietary in nature the site location information is derived from cell maps designed by the USGS as a part of the resource assessment effort. In the assessment effort, each cell represents a quarter-mile square of the land surface and the cells are coded to represent whether the wells included within the cell are predominantly oil producing, gas producing, both oil and gas producing, or dry or unknown. Some well information was initially retrieved from the IHS Energy Group, PI/Dwights PLUS Well Data on CD-ROM, which is a proprietary, commercial Data Base containing information for most oil and gas wells in the United States. However, no proprietary data are displayed or included in the cell maps and the latitudes and longitudes of the center-cell points are published with permission (click here for a copy of this letter) and are used in this Data Base. The accuracy of the cells, as created by the Arc Macro Language (AML) program of Laura R.H. Biewick , Susan Weiler, and Christopher Skinner, depends upon the accuracy of the oil and gas well information in the 2001 version of the IHS Energy data. For the National Assessment of Oil and Gas Project, the assumption was made that the data were of sufficient accuracy for a national-scale analysis. The remaining data locations are either unknown or supplied by the sample submitter.

The EGDB is available in Microsoft Access on the download page.

Data Tables

Samples table --> SampleDetails table --> Analysis table

The Samples table contains records of samples and information pertaining to the location where the samples were collected. The SampleDetails table contains geologic information about the samples and the location where the samples were collected. The Analysis table contains records of the analysis and results from the analysis performed in the laboratory. The relation ship between the tables is a one-to-one relationship between Samples and SampleDetails tables and a one-to-many between Samples and Analysis, and SampleDetails and Analysis.

Data Queries

Similar analysis types have been grouped together to assist with basic database queries. A separate query has been configured for each of the analysis groups to give the user a starting point for querying the tables for specific data. These queries are named according to the analysis group for which it has been configured. Several queries have also been configured to query on Matrix Type. These queries are named as by<MatrixType>. Queries on Matrix types Altered Rock, Rock, and Oil could not be configured due to the number of parameters exceeding 256 (MS Access limitation).

Table, Analysis, and Parameter Documentation

Complete documentation of table fields, analysis, and parameters associated with the database are included with the database download.