Skip past footer information
USGS logo with link to USGS Home Page
Contaminated Sediments Database for the Gulf of Maine, OFR 02-403
Skip past footer information
Site Map
Content Overview
How to Reach Us

Database Construction


How to Access
 the Data
Data Utilization
Data Tables & Maps
Geographic Context
 & Outside Links

References Cited


Database Content Overview

This 'Content Overview' page summarizes material that is presented in the Database Construction section of this publication. Please read the full text for details.

Database Structure

The Contaminated Sediments Database is a matrix (spreadsheet format) having samples in one dimension and properties, or parameters, in the other. In the database, each sample is assigned a row and the columns contain data about the location, parameters analyzed, methods, and measurements for each sample. The structure and content of the database are defined by the Data Dictionary, which defines what types of data are entered into each parameter field for each of six separate data tables. Each sample in the database is linked across the tables by a unique identification number (Sample ID) that is assigned when the data are entered and by a citation to the original source. The sample matrix format is flexible; it allows for addition of both samples and parameters.

Data are contained in six Data Tables. The parameters within each table are given below.

  1. Station Table Parameter List
  2. Inorganics Table Parameter List
  3. General Organics Table Parameter List
  4. Polychorinated Biphenyls (PCB's) and Pesticides Table Parameter List
  5. Polyaromatic Hydrocarbons (PAH's) Table Parameter List
  6. Texture/Grain Size Table Parameter List

Download/view the Data Dictionary.
File Name: GOMD2002.pdf (Adobe Acrobat PDF)
FileSize: 147 KB
File Name: GOMD2002.xls(Microsoft Excel 5.0/95)
File Size: 226 KB

Data Sources

References include documents that were reviewed for data content, those which are sources of compiled data, those which are cited in the text of this document, and documents on related topics that were not reviewed for data content. All of these are presented in bibliographies discussed in the methods section. Citations for data that is compiled in the Contaminated Sediments Database for the Gulf of Maine are given for every sample in each data table under the short name for the "Source of Information or Reference " and are shown with the full bibliographic citation for that reference in the Gulf of Maine Database Bibliography (Excel 4.0).

Citations for data in the Gulf of Maine Database
References for Sources of Entered Data
Download/View other formats:
File name: GOMDBBib.xls (Microsoft Excel 5.0/95)
File Size: 57 KB
File name:GOMDBBib.doc(Microsoft Word 6.0/95)
File size: 44 KB


Information tables about data sources and entry

The data dictionary and data tables are further supported by a working dictionary and glossary (download below), and by reference information. All of the data tables allow for generous use of qualifiers and comments about the data and the sample. The working dictionary contains abbreviations, types of methods or devices used, and new parameters. Source-Reference lists (download below) provide full bibliographic citations for the Source of Data and commentary about the content and physical location of each document. The paper-trail information that is in the station table, reference tables, and data tables is provided to aid the user in evaluating the data and in locating the original sources.

Download/view the Working Dictionary and the Glossary, and the Data Sources
File Name: workdict.xls (Microsoft Excel 5.0/95)
FileSize: 54 KB
File Name: glossary.xls (Microsoft Excel 5.0/95)
File Size: 36 KB

FGDC compliant Metadata:

Metadata or "data about data" describe the content, quality, condition, and other characteristics of data. Metadata describing the data in the Data tables for the Gulf of Maine contaminated sediments database are presented as frequently anticipated questions and in FGDC outline format

Skip past navigation information

Home  /  Site Map  /  Introduction  /  Overview  /  Contacts  /  DB Construction  /  Data Access  /  Data Utilization  /  Data Tables & Maps  /  Geographic Context/Links  /  References  /  Collaborators  /  Acknowledgements  /  Disclaimer
Skip past footer information

Department of Interior
> U.S. Geological Survey > Coastal and Marine Geology > Woods Hole Field Center

USGS Privacy Statement / Disclaimer / Accessibility
Maintained by Eastern Publications Group
Modified Friday, 11-Jan-2013 03:30:54 EST