Estuarine, Coastal, and Near Coastal Regional Assessments
Metadata also available as - [Questions & Answers] - [Parseable text] - [XML]
Metadata:
- Identification_Information:
-
- Citation:
-
- Citation_Information:
-
- Originator:
-
US Department of Commerce (USDOC)/National Oceanic and Atmospheric Administration (NOAA)/National Ocean Service (NOS)/National Centers for Coastal Ocean Science (NCCOS)/Center for Coastal Environmental Health and Biomolecular Research (CCEHBR)/Coastal Ecology Program
- Publication_Date: 2013
- Title: Estuarine, Coastal, and Near Coastal Regional Assessments
- Geospatial_Data_Presentation_Form: database
- Publication_Information:
-
- Publication_Place: Charleston, South Carolina
- Publisher:
-
NOAA's Ocean Service, National Centers for Coastal Ocean Science (NCCOS)
- Description:
-
- Abstract:
-
Since 1993, a series of estuarine, coastal, and offshore regional assessments have been conducted to assess the status of ecological condition and potential stressor impacts throughout various coastal regions of the United States. These survey areas cover estuaries, near-coastal areas, and four of the U.S. Large Marine Ecosystems (LMEs): California Current, the Northeastern U.S. Continental Shelf, the Southeastern U.S. Continental Shelf, and Gulf of Mexico. They also coincide with various regional planning areas of the Coastal and Marine Spatial Planning (CMSP) Interim Framework developed recently by the Interagency Ocean Policy Task Force (2009). Sampling sites are also included within marine protected areas, such as NOAA’s National Marine Sanctuaries (NMSs) and National Estuarine Research Reserves, where applicable. The studies have applied methodologies and indicators similar to EPA’s National Coastal Assessment program, including probabilistic sampling designs and multiple measures of water quality, sediment quality, benthic condition, and fish-tissue contamination.
- Purpose:
-
Results of these surveys will be valuable in providing new information on ecological characteristics over broad estuarine, coastal, and continental shelf regions of the U.S., inclusive of important marine protected areas. The consistent and systematic sampling of the different biological and environmental variables across such a vast pool of stations provides an opportunity for learning more about the spatial patterns of living resources in these waters and processes controlling their distributions. Additionally, the synoptic sampling of a variety of different ecological indicators is important in providing a means to support integrative “weight-of-evidence” assessments of condition across these sites, and to allow the examination of potential associations between presence of stressors and biological responses. Another useful feature of the sampling framework in these studies is the incorporation of a random probabilistic survey design. This approach provides the ability to make unbiased statistical estimates of the spatial extent of the study area having degraded versus non-degraded condition, based on the status of the various measured ecological indicators relative to desired management thresholds. This information can then be used as a baseline for quantifying long-term trends and how environmental conditions may be changing in relation to potential human or natural disturbances. Comparisons also can be made of conditions within NOAA's National Marine Sanctuaries, National Estuarine Research Reserves, and the broader surrounding environments. Results are expected to support several NCCOS and NOAA strategic goals, including: (1) providing baseline assessments of ecological resources in NOAA protected areas and coastal ecosystems; (2) conducting studies to quantify impacts of potential ecosystem stressors in these areas; 3) determining social, economical, & biological effects of human activities on coastal ecosystems; & (4) building effective partnerships. Data should be useful in the development of a variety of related products including contributions to National Coastal Condition reports, revised Sanctuary Management Plans & reports, scientific publications, & educational outreach modules. Results also support NOAA's emerging goal to move toward ecosystem-based approaches to the management of coastal resources and to fulfill such priorities through Integrated Ecosystem Assessments and Regional Collaborations.
- Time_Period_of_Content:
-
- Time_Period_Information:
-
- Range_of_Dates/Times:
-
- Beginning_Date: 1993
- Beginning_Time: Unknown
- Ending_Date: Present
- Ending_Time: Unknown
- Currentness_Reference: ground condition
- Status:
-
- Progress: In work
- Maintenance_and_Update_Frequency: As needed
- Spatial_Domain:
-
- Bounding_Coordinates:
-
- West_Bounding_Coordinate: -178.4
- East_Bounding_Coordinate: -68.7
- North_Bounding_Coordinate: 49.00
- South_Bounding_Coordinate: 23.0
- Keywords:
-
- Theme:
-
- Theme_Keyword_Thesaurus: None
- Theme_Keyword:
-
water quality; nutrients; sediment quality; sediment contaminants; sediment toxicity; tissue contaminants; benthic species abundance; taxa; benthos; macroinfauna; infauna; marine; oceans; coastal monitoring; estuarine; U.S. continental shelf;
- Place:
-
- Place_Keyword_Thesaurus: None
- Place_Keyword:
-
United States; National Marine Sanctuary; Coastal Ocean; Continental Shelf; Marine; Estuarine
- Access_Constraints: None
- Use_Constraints:
-
By accessing and downloading data presented in this web site you are agreeing to the following conditions: 1. The information, data records, or images presented in these databases may not be reproduced, redistributed, repackaged or publicly displayed in any form without the express written permission of a staff member of the NOAA Ocean Service. 2. Downloaded records, information or images from this site may be used strictly for non-profit purposes such as scientific, scholarly or educational activities provided this web site is acknowledged using standard citation for electronic materials (hyperlink to citations) in all copies and the webmaster notified. 3. Data are provided on an end-user basis. These data should not be redistributed to third parties without prior approval. 4. Information in the databases may be published or remain unpublished. It is the users responsibility to verify if any information has already been published for citation purposes. 5. Although every effort is made to ensure the accuracy of information provided within these databases, use of the information is entirely at your own risk. All data and images are provided "AS IS" for the end user's informational purposes only. Staff are not responsible for any negative consequences resulting from reliance on or use of information contained in the databases. Risk of injury rests entirely with the user. 6. The information presented is as accurate as the staff can reasonably make it. Data provided in the databases are compiled from various researchers working though several different institutions. If ever you believe a data record presented is in error for any reason, let us know what and why. The updating of information and ensuring its accuracy are continual processes.
- Point_of_Contact:
-
- Contact_Information:
-
- Contact_Organization_Primary:
-
- Contact_Organization: USDOC/NOAA/NOS/NCCOS/CCEHBR/Coastal Ecology
- Contact_Address:
-
- Address_Type: physical
- City: Charleston
- State_or_Province: SC
- Postal_Code: 29412
- Contact_Voice_Telephone: 843-762-8511
- Data_Quality_Information:
-
- Attribute_Accuracy:
-
- Attribute_Accuracy_Report:
-
Values were checked against hard-copy data sheets collected in the field, electronic data files generated by sampling instruments (data sondes), and laboratory analytical instrumentation.
- Logical_Consistency_Report: All data are believed to be logically consistent.
- Completeness_Report: A data point is provided for every sample location.
- Positional_Accuracy:
-
- Horizontal_Positional_Accuracy:
-
- Horizontal_Positional_Accuracy_Report:
-
Sample locations were located in the field using a differential Global Positioning System (GPS), and station coordinates, date, and time of day were recorded upon arrival at each station.
- Vertical_Positional_Accuracy:
-
- Vertical_Positional_Accuracy_Report:
-
Water depth of sediment samples are obtained from vessel depth sounder, if available, or from maximum depth of data sonde readings. Tide corrections have not been applied.
- Lineage:
-
- Source_Information:
-
- Source_Citation:
-
- Citation_Information:
-
- Originator:
-
NOAA, National Centers for Coastal Ocean Science (NCCOS), Center for Coastal Environmental Health and Biomolecular Research (CCEHBR), Charleston, SC.
- Publication_Date: 2013
- Title: Coastal Ecology Database
- Type_of_Source_Media: Relational database
- Source_Time_Period_of_Content:
-
- Time_Period_Information:
-
- Range_of_Dates/Times:
-
- Beginning_Date: 1993
- Ending_Date: Present
- Source_Currentness_Reference: ground condition
- Source_Citation_Abbreviation: Coastal Ecology Database
- Source_Contribution:
-
Data on water, sediment, and biological condition collected and maintained by the Coastal Ecology Program.
- Process_Step:
-
- Process_Description:
-
Upon arriving at a sampling station, observations of general site conditions are recorded on a data sheet. Measurements of physical water parameters are then measured using a data sonde. If applicable, discrete water samples are collected for nutrient analysis. After all water measurements are completed, grab sampling is initiated in order to collect sediments for analysis of benthic macroinfaunal abundance and diversity, sediment granulometry, sediment toxicity, and chemical contaminant analysis. When all water and sediment sampling is complete, organisms (fish or shellfish) are collected for subsequent tissue contaminant analysis.
- Process_Date: Not complete
- Entity_and_Attribute_Information:
-
- Detailed_Description:
-
- Entity_Type:
-
- Entity_Type_Label: station
- Entity_Type_Definition: Table of primary sampling stations.
- Entity_Type_Definition_Source: Assigned
- Attribute:
-
- Attribute_Label: stationId
- Attribute_Definition:
-
Sequential integer key that uniquely identifies a record in station table. Automatically generated by SQL Server. Set as primary key.
- Attribute_Definition_Source: Microsoft SQL Server
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Sequential integer automatically generated by SQL Server to uniquely identify table record and used as primary key.
- Attribute:
-
- Attribute_Label: stationCode
- Attribute_Definition: Character string to uniquely identify a sampling station
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain: Unique station identifier.
- Attribute:
-
- Attribute_Label: zone
- Attribute_Definition: Sampling zone
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Zone is used in some field surveys to identify sub-regions of the overall sampling area.
- Attribute:
-
- Attribute_Label: stratum
- Attribute_Definition: Sampling stratum
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Corresponds to sampling stratum for stratified random survey designs.
- Attribute:
-
- Attribute_Label: station
- Attribute_Definition: Station identifier
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Station identifier for a given study. Only globablly unique in combination with studyId.
- Attribute:
-
- Attribute_Label: plannedLatitude
- Attribute_Definition: Latitude of targeted sampling station in decimal degrees.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Latitude of station, assigned during study design and prior to field sampling.
- Attribute:
-
- Attribute_Label: plannedLongitude
- Attribute_Definition: Longitude of targeted sampling station in decimal degrees.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Longitude of station, assigned during study design and prior to field sampling.
- Attribute:
-
- Attribute_Label: statisticalArea
- Attribute_Definition:
-
Area represented by station (in square kilometers). Used to assign station weights in probabilistic survey design.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain: Area represented by station in square kilometers.
- Attribute:
-
- Attribute_Label: locationId
- Attribute_Definition:
-
Foreign key used to relate a record in the station table to a unique location name in the location table.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Integer key relating records in the station table to corresponding locations in the location table.
- Attribute:
-
- Attribute_Label: studyId
- Attribute_Definition:
-
Integer foreign key used to relate records in the station table to a unique study name in the study table.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Integer key relating records in the station table to corresponding records in the study table.
- Attribute:
-
- Attribute_Label: estuaryClassId
- Attribute_Definition:
-
Integer foreign key used to relate records in the station table to a unique estuary class type in the tableEntry table.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Integer key relating records in the station table to an estuary type in the tableEntry table.
- Attribute:
-
- Attribute_Label: stationTypeId
- Attribute_Definition:
-
Integer foreign key used to relate records in the station table to a unique station type in the tableEntry table.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Integer key relating records in the station table to unique station types in the tableEntry table.
- Attribute:
-
- Attribute_Label: siteID
- Attribute_Definition:
-
Character string assigned to a station in the statistical survey design phase.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Character string assigned to a station during statistical survey design phase.
- Attribute:
-
- Attribute_Label: xcoord
- Attribute_Definition:
-
X-coordinate for a sampling site. May be in decimal degrees or projected coordinate system. Generated as part of statistical survey design.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
X-coordinate for a sampling station. May be in decimal degrees or projected coordinate system.
- Attribute:
-
- Attribute_Label: ycoord
- Attribute_Definition:
-
Y-coordinate for a sampling site. May be in decimal degrees or projected coordinate system. Generated as part of statistical survey design.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Y-coordinate for a sampling site. May be in decimal degrees or projected coordinate system.
- Attribute:
-
- Attribute_Label: mdcaty
- Attribute_Definition:
-
Multi-density category. Used to classify sites as part of a Generalized Random Tesselation Stratified (GRTS) survey design.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Character string representing multi-density categories used to classify sites in a GRTS survey design.
- Attribute:
-
- Attribute_Label: wgt
- Attribute_Definition:
-
Area (in square meters) represented by a sampling station. Used to assign station weights in probabilistic sampling design and analysis.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain: Area (in square meters) represented by a sampling station.
- Attribute:
-
- Attribute_Label: panel
- Attribute_Definition:
-
Character string used to identify panel structure for a survey over time. Used in Generalized Random Tessellation Stratified (GRTS) survey design.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Character string identifying panel structure in a survey over time. Used in GRTS survey design.
- Attribute:
-
- Attribute_Label: frame_sqkm
- Attribute_Definition:
-
Size (in square kilometers) of the sampling frame defining a targeted survey area. Used to obtain station weights in a probabilistic survey design.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain: Size of the sampling frame in a probabilistic survey design.
- Detailed_Description:
-
- Entity_Type:
-
- Entity_Type_Label: collection
- Entity_Type_Definition: Table of sample collections at each sampling station.
- Entity_Type_Definition_Source: CEP
- Attribute:
-
- Attribute_Label: collectionId
- Attribute_Definition:
-
Unique sequential integer identifying each record in the collection table. Automatically generated by Microsoft SQL Server. Set as primary key for the table.
- Attribute_Definition_Source: Microsoft SQL Server.
- Attribute_Domain_Values:
-
- Unrepresentable_Domain: Sequential integer key automatically generated by SQL Server.
- Attribute:
-
- Attribute_Label: stationId
- Attribute_Definition:
-
Integer foreign key relating records in the collection table to a unique station in the station table.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Integer key relating collections to the station where the collections were made.
- Attribute:
-
- Attribute_Label: collectionDTstart
- Attribute_Definition: Starting date and time of sample collection at a station.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Date and time when sample collection was initiated at a station.
- Attribute:
-
- Attribute_Label: collectionDTend
- Attribute_Definition: Ending date and time for sample collection at a station.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Date and time when sample collection was completed at a station.
- Attribute:
-
- Attribute_Label: timeZone
- Attribute_Definition: Time zone for the location where sample was collected.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Character string representing the time zone where a sample was collected.
- Attribute:
-
- Attribute_Label: fieldMethodId
- Attribute_Definition:
-
Integer foreign key relating records in the collection table to the field method description in the method table. Defines the field sample collection method.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Integer key relating sample collection records to the field collection method used to collect the sample(s).
- Attribute:
-
- Attribute_Label: fieldReplicate
- Attribute_Definition:
-
Integer value used to identify replicates when multiple field samples were obtained for a given collection event at a station.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Integer value that identifies a field replicate sample for a collection.
- Attribute:
-
- Attribute_Label: collectionLatitude
- Attribute_Definition: Latitude of sample collection location in decimal degrees.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain: Latitude of sample collection location in decimal degrees.
- Attribute:
-
- Attribute_Label: collectionLongitude
- Attribute_Definition: Longitude of sample collection location in decimal degrees.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain: Longitude of sample collection location in decimal degrees.
- Attribute:
-
- Attribute_Label: originalCollectionCode
- Attribute_Definition:
-
Character string originally assigned to sample on collection in the field.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain: Character string identifying field-collected sample.
- Attribute:
-
- Attribute_Label: labCollectionCode
- Attribute_Definition: Character string assigned by laboratory.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain: Character string identifying a lab-collected sample.
- Attribute:
-
- Attribute_Label: supplierCollectionCode
- Attribute_Definition: Character string identifying a sample provided by a supplier.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain: Character string identifying a sample provided by a supplier.
- Attribute:
-
- Attribute_Label: comment
- Attribute_Definition:
-
Free text character string providing information about the sample collected in the field.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Character string describing conditions unique to the sample collected in the field.
- Attribute:
-
- Attribute_Label: vesselId
- Attribute_Definition:
-
Integer foreign key relating records in the collection table to description of the vessel from which samples were collected, found in the tableEntry table.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Integer key used to relate records in the collection table to the corresponding vessel description in the tableEntry table.
- Attribute:
-
- Attribute_Label: positioningAuthorityId
- Attribute_Definition:
-
Integer foreign key relating records in the collection table to positioning authority information in the tableEntry table.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Integer key relating records in the collection table to the corresponding entry in the tableEntry table which describes the positioning authority (LORAN, GPS, DGPS).
- Attribute:
-
- Attribute_Label: infaunaReplicate
- Attribute_Definition: Integer value identifying the benthic infaunal replicate.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Range_Domain:
-
- Range_Domain_Minimum: 1
- Range_Domain_Maximum: 5
- Detailed_Description:
-
- Entity_Type:
-
- Entity_Type_Label: exposureData
- Entity_Type_Definition:
-
Table containing records for exposure or in-situ measurements of water and sediment parameters. Includes measurements of water chemistry and physical parameters, water-column nutrients, sediment characteristics, sediment chemistry, and sediment toxicity.
- Entity_Type_Definition_Source: CEP
- Attribute:
-
- Attribute_Label: exposureDataId
- Attribute_Definition:
-
Integer key that uniquely identifies a row in the exposureData table. Sequential integer value automatically generated by SQL Server. Set as primary key.
- Attribute_Definition_Source: SQL Server
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Auto-generated integer key used to uniquely identify records in the exposureData table.
- Attribute:
-
- Attribute_Label: collectionId
- Attribute_Definition:
-
Integer foreign key relating records in the exposureData table to the corresponding collection records in the collection table.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Integer key relating measurements to the corresponding field collections.
- Attribute:
-
- Attribute_Label: labSampleCode
- Attribute_Definition: Character string assigned to sample by analytical lab.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Character string sample code assigned by the lab analyzing the sample.
- Attribute:
-
- Attribute_Label: labReplicate
- Attribute_Definition:
-
Integer value identifying the replicate number of the laboratory analysis performed on the sample. Used when multiple replicate analyses are performed on the same sample.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Integer value identifying analytical replicate performed on a sample.
- Attribute:
-
- Attribute_Label: parameterId
- Attribute_Definition:
-
Integer foreign key relating records in the exposureData table to a description of the measured parameter in the parameter table.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Integer key relating exposureData records to the corresponding parameter description in the parameter table.
- Attribute:
-
- Attribute_Label: resultNumeric
- Attribute_Definition: Numeric value of the measurement made on the sample.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain: Decimal values obtained from measurements made on a sample.
- Attribute:
-
- Attribute_Label: resultText
- Attribute_Definition: Character representation of a measurement made on a sample.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Character string representing the text result of a measurement taken on a sample.
- Attribute:
-
- Attribute_Label: unitId
- Attribute_Definition:
-
Integer foreign key relating records in the exposureData table to an entry in the tableEntry table which describes the units of the measurement made on a sample.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Integer key relating measurements in the exposureData table to the corresponding units described in the tableEntry table.
- Attribute:
-
- Attribute_Label: detectionLimit
- Attribute_Definition: The method detection limit of a measurement taken on a sample.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain: Decimal values representing the method detection limit.
- Attribute:
-
- Attribute_Label: analyticalMethodId
- Attribute_Definition:
-
Integer foreign key relating records in the exposureData table to the corresponding analytical method described in the method table.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Integer key relating records in the exposureData table to corresponding records in the method table.
- Attribute:
-
- Attribute_Label: qaCode
- Attribute_Definition:
-
Character string representing a quality assurance code used to qualify an analytical measurement.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain: Character string assigned by analytical lab to qualify result.
- Attribute:
-
- Attribute_Label: comment
- Attribute_Definition:
-
Free text character string describing conditions unique to a measurement result for a sample.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Character string used to provide additional information about a sample measurement result.
- Attribute:
-
- Attribute_Label: processDate
- Attribute_Definition: The date when a sample was analyzed.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain: Date of sample analysis.
- Detailed_Description:
-
- Entity_Type:
-
- Entity_Type_Label: bioAbundanceData
- Entity_Type_Definition:
-
Table of biological abundance data. Contains quantitative measurements of abundance of macro-benthic infauna and other organisms collected for tissue contaminants analysis (e.g., fish, molluscs).
- Entity_Type_Definition_Source: CEP
- Attribute:
-
- Attribute_Label: bioAbundanceDataId
- Attribute_Definition:
-
Sequential integer key that uniquely identifies a record in the bioAbundanceData table. Automatically generated by SQL Server. Set as primary key.
- Attribute_Definition_Source: SQL Server
- Attribute_Domain_Values:
-
- Unrepresentable_Domain: Auto-generated integer key.
- Attribute:
-
- Attribute_Label: collectionId
- Attribute_Definition:
-
Integer foreign key relating records in the bioAbundanceData table to the corresponding collection information in the collection table.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Integer key relating bioAbundanceData records to the corresponding collection information.
- Attribute:
-
- Attribute_Label: labSampleCode
- Attribute_Definition: Code assigned by lab analyzing the sample.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain: Character string used to identify sample by the analytical lab.
- Attribute:
-
- Attribute_Label: labReplicate
- Attribute_Definition:
-
Integer replicate number assigned to a sample by the analytical lab.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain: Integer value assigned to a replicate analytical sample.
- Attribute:
-
- Attribute_Label: parameterId
- Attribute_Definition:
-
Integer foreign key relating measurements in the bioAbundanceData table the corresponding parameter description in the parameter table.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Integer key relating bioAbundanceData measurements to the corresponding parameter description in the parameter table.
- Attribute:
-
- Attribute_Label: analyticalMethodId
- Attribute_Definition:
-
Integer foreign key relating records in the bioAbundanceData table to corresponding analytical method description in the method table.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Integer key relating records in the bioAbundanceData table to the corresponding analytical method description.
- Attribute:
-
- Attribute_Label: tsn
- Attribute_Definition: Taxonomic Serial Number (TSN) assigned for a taxon.
- Attribute_Definition_Source:
-
Integrated Taxonomic Information System (ITIS)
http://www.itis.gov/
- Attribute_Domain_Values:
-
- Unrepresentable_Domain: Integer-valued code assigned to a taxon by ITIS.
- Attribute:
-
- Attribute_Label: taxonName
- Attribute_Definition: Taxon name assigned to a specimen.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Character string representing the taxonomic name assigned to a specimen.
- Attribute:
-
- Attribute_Label: resultInteger
- Attribute_Definition: Number of specimens of a taxon collected.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Integer value corresponding to counts (abundances) of organisms collected.
- Attribute:
-
- Attribute_Label: resultText
- Attribute_Definition: Text result of organism abundance.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain: Character string representing abundance of organisms.
- Attribute:
-
- Attribute_Label: unitId
- Attribute_Definition:
-
Integer foreign key relating records in the bioAbundanceData table to the corresponding units description in the tableEntry table.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Integer key relating bioAbundanceData records to description of the corresponding units of measurement.
- Attribute:
-
- Attribute_Label: qaCode
- Attribute_Definition:
-
Quality assurance code associated with a measurement to provide additional information regarding confidence in the result.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Character string representing a quality assurance qualifier code.
- Attribute:
-
- Attribute_Label: taxFlag
- Attribute_Definition:
-
Taxonomic flag assigned to indicate whether a taxon should be ignored for calculation of ecological indices.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Enumerated_Domain:
-
- Enumerated_Domain_Value: 0
- Enumerated_Domain_Value_Definition:
-
Do not ignore taxon for calculation of abundance, richness, or diversity.
- Enumerated_Domain_Value_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Enumerated_Domain:
-
- Enumerated_Domain_Value: 1
- Enumerated_Domain_Value_Definition:
-
Ignore taxon only for calculation of richness and diversity (but not abundance).
- Enumerated_Domain_Value_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Enumerated_Domain:
-
- Enumerated_Domain_Value: 2
- Enumerated_Domain_Value_Definition:
-
Ignore taxon for all calculations of abundance, richness, and diversity.
- Enumerated_Domain_Value_Definition_Source: CEP
- Attribute:
-
- Attribute_Label: comment
- Attribute_Definition:
-
Free text character string used to provide additional information about a sample measurement.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Character string used to provide additional information about a sample measurement.
- Attribute:
-
- Attribute_Label: areaSampled
- Attribute_Definition: Surface area of the sampling device.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Numeric value representing the area (usually in square meters) of a sampling device.
- Attribute:
-
- Attribute_Label: child_tsn
- Attribute_Definition:
-
TSN of another taxon in the same sample that is a child (lower level in taxonomic hierarchy) of the current taxon.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain: Integer-valued taxonomic serial number (TSN).
- Attribute:
-
- Attribute_Label: parent_tsn
- Attribute_Definition:
-
Taxonomic Serial Number (TSN) of a taxon in the same sample that is a parent (higher level in taxonomic hierarchy) of the current taxon.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain: Integer-valued Taxonomic Serial Number (TSN).
- Attribute:
-
- Attribute_Label: lump_tsn
- Attribute_Definition:
-
Taxonomic Serial Number (TSN) that can be used to lump the current taxon to a higher taxonomic level.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain: Integer-valued Taxonomic Serial Number (TSN).
- Detailed_Description:
-
- Entity_Type:
-
- Entity_Type_Label: bioMetricsData
- Entity_Type_Definition:
-
Table of measurements of specimen biometrics (length, weight, sex).
- Entity_Type_Definition_Source: CEP
- Attribute:
-
- Attribute_Label: bioMetricsDataId
- Attribute_Definition:
-
Sequential integer key value that uniquely identifies a record in the bioMetricsData table. Automatically generated by SQL Server. Set as primary key.
- Attribute_Definition_Source: SQL Server
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Auto-generated integer key that uniquely identifies a record in the bioMetricsData table.
- Attribute:
-
- Attribute_Label: bioAbundanceDataId
- Attribute_Definition:
-
Integer foreign key relating records in the bioMetricsData table to the corresponding abundance record in the bioAbundanceData table.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Integer key relating records in the bioMetricsData table to corresponding abundance data.
- Attribute:
-
- Attribute_Label: labReplicate
- Attribute_Definition: Replicate number assigned by the lab processing the specimen.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain: Integer-valued laboratory replicate number.
- Attribute:
-
- Attribute_Label: specimenNumber
- Attribute_Definition:
-
Integer ID assigned when measurements were made on multiple specimens of the same species in a sample.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Sequential integer-valued ID assigned to each of multiple specimens of the same species in a sample.
- Attribute:
-
- Attribute_Label: parameterId
- Attribute_Definition:
-
Integer foreign key used to relate records in the bioMetricsData table to corresponding parameter descriptions in the parameter table.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Integer key relating records in the bioMetricsData table to corresponding parameter descriptions in the parameter table.
- Attribute:
-
- Attribute_Label: resultInteger
- Attribute_Definition: Integer-valued result for a measured parameter.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain: Integer-valued measurement result.
- Attribute:
-
- Attribute_Label: resultNumeric
- Attribute_Definition: Numeric (decimal) value result for a measured parameter.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain: Numeric- (decimal-) valued measurement result.
- Attribute:
-
- Attribute_Label: resultText
- Attribute_Definition: Character (text) result for a measured parameter.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain: Text-valued measurement result.
- Attribute:
-
- Attribute_Label: unitId
- Attribute_Definition:
-
Integer foreign key relating records in bioMetricsData table to corresponding description of units in the tableEntry table.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Integer key relating records in the bioMetricsData table to corresponding measurement units.
- Attribute:
-
- Attribute_Label: qaCode
- Attribute_Definition:
-
Character string representing a quality assurance code used to qualify a measurement value.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain: Character string representing a quality assurance code.
- Attribute:
-
- Attribute_Label: analyticalMethodId
- Attribute_Definition:
-
Integer foreign key relating records in the bioMetricsData table to the corresponding analytical method description in the method table.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Integer key relating records in the bioMetricsData table to the corresponding analytical method description.
- Attribute:
-
- Attribute_Label: isAggregate
- Attribute_Definition:
-
Logical value indicating whether measurement was performed on an aggregate of multiple specimens.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Enumerated_Domain:
-
- Enumerated_Domain_Value: 0
- Enumerated_Domain_Value_Definition: No
- Enumerated_Domain_Value_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Enumerated_Domain:
-
- Enumerated_Domain_Value: 1
- Enumerated_Domain_Value_Definition: Yes
- Enumerated_Domain_Value_Definition_Source: CEP
- Attribute:
-
- Attribute_Label: numberInAggregate
- Attribute_Definition:
-
If measurement was on an aggregate of multiple specimens, numberInAggregate is number of specimens comprising the aggregate.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain: Integer count of the number of specimens in aggregate.
- Attribute:
-
- Attribute_Label: comment
- Attribute_Definition:
-
Free text character string used to provide additional information about a measurement.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Character string providing additional information about a measurement in the form of a comment.
- Attribute:
-
- Attribute_Label: labSampleCode
- Attribute_Definition: Code assigned by laboratory processing the sample.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Character string representing the sample code used by the laboratory processing the sample.
- Detailed_Description:
-
- Entity_Type:
-
- Entity_Type_Label: bioResponseData
- Entity_Type_Definition:
-
Table of biological response data. These are typically concentrations of chemical contaminants measured in edible tissues of fish and shellfish.
- Entity_Type_Definition_Source: CEP
- Attribute:
-
- Attribute_Label: bioResponseDataId
- Attribute_Definition:
-
Sequential integer key that uniquely identifies a record in the bioResponseData table. Automatically generated by SQL Server. Set as primary key.
- Attribute_Definition_Source: SQL Server
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Auto-generated integer key uniquely identifying a record in bioResponseData table.
- Attribute:
-
- Attribute_Label: bioAbundanceDataId
- Attribute_Definition:
-
Integer foreign key relating records in the bioResponseData table to corresponding abundance records in the bioAbundanceData table.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Integer key relating records in bioResponseData table to corresponding records in bioAbundanceData table.
- Attribute:
-
- Attribute_Label: labSampleCode
- Attribute_Definition: Code assigned by the laboratory analyzing the sample.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain: Character string sample code assigned by analytical lab.
- Attribute:
-
- Attribute_Label: labReplicate
- Attribute_Definition:
-
Integer value identifying the replicate number of the laboratory analysis performed on the sample. Used when multiple replicate analyses are performed on the same sample.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Integer value assigned to each replicate analysis performed on the same sample.
- Attribute:
-
- Attribute_Label: parameterId
- Attribute_Definition:
-
Integer foreign key relating records in the bioResponseData table to a description of the measured parameter in the parameter table.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Integer key relating records in the bioResponseData table to parameter description in the parameter table.
- Attribute:
-
- Attribute_Label: resultNumeric
- Attribute_Definition:
-
Numeric result of the measured parameter analyzed for the sample.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain: Decimal numeric result for a measured parameter.
- Attribute:
-
- Attribute_Label: resultText
- Attribute_Definition: Character representation of a measurement made on a sample.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain: Text result for a measured parameter on a sample.
- Attribute:
-
- Attribute_Label: unitId
- Attribute_Definition:
-
Integer foreign key relating records in the bioResponseData table to an entry in the tableEntry table describing the units of measurement made on a sample.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Integer key relating records in the bioResponseData table to units of measurement in the tableEntry table.
- Attribute:
-
- Attribute_Label: detectionLimit
- Attribute_Definition: The method detection limit of a measurement taken on a sample.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Decimal numeric value representing the method detection limit for a measurement taken on a sample.
- Attribute:
-
- Attribute_Label: qaCode
- Attribute_Definition:
-
Quality assurance code used to qualify an analytical measurement on a sample.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Character string representing a quality assurance code used to qualify an analytical measurement on a sample.
- Attribute:
-
- Attribute_Label: analyticalMethodId
- Attribute_Definition:
-
Integer foreign key relating records in the bioResponseData table to the corresponding analytical method described in the method table.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Integer key relating records in the exposureData table to the corresponding analytical method description in the method table.
- Attribute:
-
- Attribute_Label: sampleDescriptionId
- Attribute_Definition:
-
Integer foreign key relating records in the bioResponseData table to a corresponding sample description in the tableEntry table.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Integer key relating records in the bioResponseData table to a corresponding sample description record in the tableEntry table.
- Attribute:
-
- Attribute_Label: specimenNumber
- Attribute_Definition:
-
Integer ID assigned when measurements were made on multiple specimens of the same species in a sample.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Integer value identifying individual specimens of the same species analyzed in a sample.
- Attribute:
-
- Attribute_Label: isAggregate
- Attribute_Definition:
-
Logical value indicating whether analysis was performed on an aggregate of multiple specimens in a sample.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Enumerated_Domain:
-
- Enumerated_Domain_Value: 0
- Enumerated_Domain_Value_Definition:
-
Analysis was not performed on an aggregate of specimens for the sample.
- Enumerated_Domain_Value_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Enumerated_Domain:
-
- Enumerated_Domain_Value: 1
- Enumerated_Domain_Value_Definition:
-
Analysis was performed on an aggregate of specimens for a sample.
- Enumerated_Domain_Value_Definition_Source: CEP
- Attribute:
-
- Attribute_Label: numberInAggregate
- Attribute_Definition:
-
The number of specimens comprising an aggregate of specimens analyzed for a sample.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Integer count of the number of specimens in an aggregate sample.
- Attribute:
-
- Attribute_Label: comment
- Attribute_Definition:
-
Free text character string used to provide additional information about a measurement on a sample.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Character string used to provide additional information about a measurement on a sample.
- Detailed_Description:
-
- Entity_Type:
-
- Entity_Type_Label: tableEntry
- Entity_Type_Definition:
-
Table of character descriptions of various attributes related to sample collection and analysis.
- Entity_Type_Definition_Source: CEP
- Attribute:
-
- Attribute_Label: tableEntryId
- Attribute_Definition:
-
Sequential integer key that uniquely identifies a record in the tableEntry table. Automatically generated by SQL Server. Set as primary key.
- Attribute_Definition_Source: SQL Server
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Integer key uniquely identifying a record in the tableEntry table.
- Attribute:
-
- Attribute_Label: shortDesc
- Attribute_Definition: Short description of an attribute.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain: Character string providing a short description of an attribute.
- Attribute:
-
- Attribute_Label: longDesc
- Attribute_Definition: Detailed description of an attribute.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Character string providing a detailed description of an attribute.
- Attribute:
-
- Attribute_Label: codeTableId
- Attribute_Definition:
-
Integer foreign key relating records in the tableEntry table to a description of the attribute type in codeTable.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Integer key relating records in the tableEntry table to a corresponding record in codeTable.
- Detailed_Description:
-
- Entity_Type:
-
- Entity_Type_Label: codeTable
- Entity_Type_Definition:
-
Table linking descriptions of attribute types to the corresponding attribute descriptions in the tableEntry table.
- Entity_Type_Definition_Source: CEP
- Attribute:
-
- Attribute_Label: codeTableId
- Attribute_Definition:
-
Sequential integer key that uniquely identifies a record in codeTable. Automatically generated by SQL Server. Set as primary key.
- Attribute_Definition_Source: SQL Server
- Attribute_Domain_Values:
-
- Unrepresentable_Domain: Integer key uniquely identifying a record in codeTable.
- Attribute:
-
- Attribute_Label: shortDesc
- Attribute_Definition: Short description of an attribute type.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Character string representing a short description of an attribute type.
- Attribute:
-
- Attribute_Label: longDesc
- Attribute_Definition: Long description of an attribute type.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Character string representing a long description of an attribute type.
- Detailed_Description:
-
- Entity_Type:
-
- Entity_Type_Label: method
- Entity_Type_Definition: Table of collection and analytical method descriptions.
- Entity_Type_Definition_Source: CEP
- Attribute:
-
- Attribute_Label: methodId
- Attribute_Definition:
-
Sequential integer key uniquely identifying a record in the method table. Automatically generated by SQL Server. Set as primary key.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Integer key that uniquely identifies a record in the method table.
- Attribute:
-
- Attribute_Label: shortDesc
- Attribute_Definition: Short description of a collection or analytical method.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Character string representing the short description of a collection or analytical method.
- Attribute:
-
- Attribute_Label: longDesc
- Attribute_Definition: Detailed description of a collection or analytical method.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Character string representing a detailed description of a collection or analytical method.
- Attribute:
-
- Attribute_Label: typeId
- Attribute_Definition:
-
Integer foreign key relating records in the method table to corresponding method type in the tableEntry table.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Integer key relating records in the method table to corresponding method description in the tableEntry table.
- Detailed_Description:
-
- Entity_Type:
-
- Entity_Type_Label: parameter
- Entity_Type_Definition: Table of parameter descriptions.
- Entity_Type_Definition_Source: CEP
- Attribute:
-
- Attribute_Label: parameterId
- Attribute_Definition:
-
Sequential integer key uniquely identifying a record in the parameter table. Automatically generated by SQL Server. Set as primary key.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Integer key that uniquely identifies a row in the parameter table.
- Attribute:
-
- Attribute_Label: shortDesc
- Attribute_Definition: Short description of a parameter.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Character string representing the short description of a parameter.
- Attribute:
-
- Attribute_Label: longDesc
- Attribute_Definition: Detailed description of a parameter.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Character string representing the long description of a parameter.
- Attribute:
-
- Attribute_Label: casNumber
- Attribute_Definition:
-
Unique identifier assigned by the Chemical Abstracts Service to every chemical described in the open scientific literature (currently including those described from at least 1957 through the present) and including elements, isotopes, organic and inorganic compounds, ions, organometallics, metals, nonstructurable materials (aka 'UVCB's- i.e., materials of Unknown, Variable Composition, or Biological origin).
- Attribute_Definition_Source: Chemical Abstracts Service (http://www.cas.org).
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Character string representing the unique identifier assigned to a chemical by the Chemical Abstracts Service.
- Attribute:
-
- Attribute_Label: classId
- Attribute_Definition:
-
Integer foreign key relating records in the parameter table to the corresponding chemical class description in the tableEntry table.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Integer key that related records in the parameter table to the corresponding chemical class description in the tableEntry table.
- Detailed_Description:
-
- Entity_Type:
-
- Entity_Type_Label: location
- Entity_Type_Definition: Table of location descriptions.
- Entity_Type_Definition_Source: CEP
- Attribute:
-
- Attribute_Label: locationId
- Attribute_Definition:
-
Sequential integer key that uniquely identifies a record in the location table. Automatically generated by SQL Server. Set as primary key.
- Attribute_Definition_Source: SQL Server
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Integer key uniquely identifying a record in the location table.
- Attribute:
-
- Attribute_Label: locationName
- Attribute_Definition: The name of a location.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain: Character string representing the name of a location.
- Attribute:
-
- Attribute_Label: stateId
- Attribute_Definition:
-
Integer foreign key relating records in the location table to U.S. states listed in the state table.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Integer key relating location name in the location table to the corresponding U.S. state(s) in which the location occurs.
- Attribute:
-
- Attribute_Label: oceanName
- Attribute_Definition: Name of the ocean (if applicable) where the location occurs.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain: Character string representing the name of an ocean.
- Attribute:
-
- Attribute_Label: seaGulfName
- Attribute_Definition:
-
Name of a sea or gulf (if applicable) in which a location occurs.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain: Character string representing the name of a sea or gulf.
- Attribute:
-
- Attribute_Label: bayName
- Attribute_Definition: Name of a bay (if applicable) where a location occurs.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain: Character string representing the name of a bay.
- Attribute:
-
- Attribute_Label: riverLakeName
- Attribute_Definition:
-
Name of a river or lake (if applicable) where a location occurs.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain: Character string representing the name of a river or lake.
- Detailed_Description:
-
- Entity_Type:
-
- Entity_Type_Label: study
- Entity_Type_Definition: Table of study descriptions.
- Entity_Type_Definition_Source: CEP
- Attribute:
-
- Attribute_Label: studyId
- Attribute_Definition:
-
Sequential integer key uniquely identifying records in the study table. Automatically generated by SQL Server. Set as primary key.
- Attribute_Definition_Source: SQL Server
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Integer key that uniquely identifies a record in the study table.
- Attribute:
-
- Attribute_Label: studyName
- Attribute_Definition: The name of a study.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain: Character string representing the name of a study.
- Attribute:
-
- Attribute_Label: studyCode
- Attribute_Definition: Unique code assigned to a study.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Character string representing the unique code assigned to a study.
- Attribute:
-
- Attribute_Label: cruiseCode
- Attribute_Definition:
-
A unique code identifying an individual cruise event for a study.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Character string representing the unique cruise code assigned to a study.
- Attribute:
-
- Attribute_Label: year
- Attribute_Definition: The year in which a study occurred.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Character string representing the year in which a study occurred.
- Attribute:
-
- Attribute_Label: nbiStudyName
- Attribute_Definition: Name of study used in the National Benthic Inventory (NBI).
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Character string representing the study name used in the National Benthic Inventory (NBI).
- Attribute:
-
- Attribute_Label: projectId
- Attribute_Definition:
-
Integer foreign key relating records in the study table to project descriptions in the tableEntry table.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Integer key relating records in the study table to corresponding project descriptions.
- Attribute:
-
- Attribute_Label: provinceId
- Attribute_Definition:
-
Integer foreign key relating records in the study table to the corresponding biogeographic province description in the tableEntry table.
- Attribute_Definition_Source: CEP
- Attribute_Domain_Values:
-
- Unrepresentable_Domain:
-
Integer key relating records in the study table to the corresponding biogeographic province description.
- Overview_Description:
-
- Entity_and_Attribute_Overview: Coastal Ecology Database
- Entity_and_Attribute_Detail_Citation:
-
Relational database maintained by the Coastal Ecology Program (CEP) at the NOAA Center for Coastal Environmental Health and Biomolecular Research (CCEHBR) in Charleston, SC.
- Entity_and_Attribute_Detail_Citation:
-
Database contains information gathered during field sampling surveys for water quality, water-column nutrients, sediment characteristics, sediment contaminant concentrations, sediment toxicity, abundance and diversity of macro-benthic infaunal organisms, and fish tissue contaminant concentrations.
- Distribution_Information:
-
- Distributor:
-
- Contact_Information:
-
- Contact_Organization_Primary:
-
- Contact_Organization: USDOC/NOAA/NOS/NCCOS/CCEHBR/Coastal Ecology
- Contact_Address:
-
- Address_Type: physical
- City: Charleston
- State_or_Province: SC
- Postal_Code: 29412
- Contact_Voice_Telephone: 843-762-8511
- Distribution_Liability: none
- Standard_Order_Process:
-
- Digital_Form:
-
- Digital_Transfer_Information:
-
- Format_Name: ASCII
- Digital_Transfer_Option:
-
- Online_Option:
-
- Computer_Contact_Information:
-
- Network_Address:
-
- Network_Resource_Name: http://coastalscience.noaa.gov/
- Fees: none
- Metadata_Reference_Information:
-
- Metadata_Date: 2013
- Metadata_Review_Date: 2013
- Metadata_Contact:
-
- Contact_Information:
-
- Contact_Organization_Primary:
-
- Contact_Organization: USDOC/NOAA/NOS/NCCOS/CCEHBR/Coastal Ecology
- Contact_Address:
-
- Address_Type: physical
- Address: 219 Fort Johnson Road
- City: Charleston
- State_or_Province: South Carolina
- Postal_Code: 29412
- Contact_Voice_Telephone: (843) 762 8511
- Metadata_Standard_Name: FGDC Content Standard for Digital Geospatial Metadata
- Metadata_Standard_Version: FGDC-STD-001-1998
Generated by mp version 2.9.26 on Thu Jun 26 08:49:31 2014