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, 2013, Estuarine, Coastal, and Near Coastal Regional Assessments: NOAA's Ocean Service, National Centers for Coastal Ocean Science (NCCOS), Charleston, South Carolina.
Sequential integer automatically generated by SQL Server to uniquely identify table record and used as primary key.
Unique station identifier.
Zone is used in some field surveys to identify sub-regions of the overall sampling area.
Corresponds to sampling stratum for stratified random survey designs.
Station identifier for a given study. Only globablly unique in combination with studyId.
Latitude of station, assigned during study design and prior to field sampling.
Longitude of station, assigned during study design and prior to field sampling.
Area represented by station in square kilometers.
Integer key relating records in the station table to corresponding locations in the location table.
Integer key relating records in the station table to corresponding records in the study table.
Integer key relating records in the station table to an estuary type in the tableEntry table.
Integer key relating records in the station table to unique station types in the tableEntry table.
Character string assigned to a station during statistical survey design phase.
X-coordinate for a sampling station. May be in decimal degrees or projected coordinate system.
Y-coordinate for a sampling site. May be in decimal degrees or projected coordinate system.
Character string representing multi-density categories used to classify sites in a GRTS survey design.
Area (in square meters) represented by a sampling station.
Character string identifying panel structure in a survey over time. Used in GRTS survey design.
Size of the sampling frame in a probabilistic survey design.
Sequential integer key automatically generated by SQL Server.
Integer key relating collections to the station where the collections were made.
Date and time when sample collection was initiated at a station.
Date and time when sample collection was completed at a station.
Character string representing the time zone where a sample was collected.
Integer key relating sample collection records to the field collection method used to collect the sample(s).
Integer value that identifies a field replicate sample for a collection.
Latitude of sample collection location in decimal degrees.
Longitude of sample collection location in decimal degrees.
Character string identifying field-collected sample.
Character string identifying a lab-collected sample.
Character string identifying a sample provided by a supplier.
Character string describing conditions unique to the sample collected in the field.
Integer key used to relate records in the collection table to the corresponding vessel description in the tableEntry table.
Integer key relating records in the collection table to the corresponding entry in the tableEntry table which describes the positioning authority (LORAN, GPS, DGPS).
Range of values | |
---|---|
Minimum: | 1 |
Maximum: | 5 |
Auto-generated integer key used to uniquely identify records in the exposureData table.
Integer key relating measurements to the corresponding field collections.
Character string sample code assigned by the lab analyzing the sample.
Integer value identifying analytical replicate performed on a sample.
Integer key relating exposureData records to the corresponding parameter description in the parameter table.
Decimal values obtained from measurements made on a sample.
Character string representing the text result of a measurement taken on a sample.
Integer key relating measurements in the exposureData table to the corresponding units described in the tableEntry table.
Decimal values representing the method detection limit.
Integer key relating records in the exposureData table to corresponding records in the method table.
Character string assigned by analytical lab to qualify result.
Character string used to provide additional information about a sample measurement result.
Date of sample analysis.
Auto-generated integer key.
Integer key relating bioAbundanceData records to the corresponding collection information.
Character string used to identify sample by the analytical lab.
Integer value assigned to a replicate analytical sample.
Integer key relating bioAbundanceData measurements to the corresponding parameter description in the parameter table.
Integer key relating records in the bioAbundanceData table to the corresponding analytical method description.
Integer-valued code assigned to a taxon by ITIS.
Character string representing the taxonomic name assigned to a specimen.
Integer value corresponding to counts (abundances) of organisms collected.
Character string representing abundance of organisms.
Integer key relating bioAbundanceData records to description of the corresponding units of measurement.
Character string representing a quality assurance qualifier code.
Value | Definition |
---|---|
0 | Do not ignore taxon for calculation of abundance, richness, or diversity. |
1 | Ignore taxon only for calculation of richness and diversity (but not abundance). |
2 | Ignore taxon for all calculations of abundance, richness, and diversity. |
Character string used to provide additional information about a sample measurement.
Numeric value representing the area (usually in square meters) of a sampling device.
Integer-valued taxonomic serial number (TSN).
Integer-valued Taxonomic Serial Number (TSN).
Integer-valued Taxonomic Serial Number (TSN).
Auto-generated integer key that uniquely identifies a record in the bioMetricsData table.
Integer key relating records in the bioMetricsData table to corresponding abundance data.
Integer-valued laboratory replicate number.
Sequential integer-valued ID assigned to each of multiple specimens of the same species in a sample.
Integer key relating records in the bioMetricsData table to corresponding parameter descriptions in the parameter table.
Integer-valued measurement result.
Numeric- (decimal-) valued measurement result.
Text-valued measurement result.
Integer key relating records in the bioMetricsData table to corresponding measurement units.
Character string representing a quality assurance code.
Integer key relating records in the bioMetricsData table to the corresponding analytical method description.
Value | Definition |
---|---|
0 | No |
1 | Yes |
Integer count of the number of specimens in aggregate.
Character string providing additional information about a measurement in the form of a comment.
Character string representing the sample code used by the laboratory processing the sample.
Auto-generated integer key uniquely identifying a record in bioResponseData table.
Integer key relating records in bioResponseData table to corresponding records in bioAbundanceData table.
Character string sample code assigned by analytical lab.
Integer value assigned to each replicate analysis performed on the same sample.
Integer key relating records in the bioResponseData table to parameter description in the parameter table.
Decimal numeric result for a measured parameter.
Text result for a measured parameter on a sample.
Integer key relating records in the bioResponseData table to units of measurement in the tableEntry table.
Decimal numeric value representing the method detection limit for a measurement taken on a sample.
Character string representing a quality assurance code used to qualify an analytical measurement on a sample.
Integer key relating records in the exposureData table to the corresponding analytical method description in the method table.
Integer key relating records in the bioResponseData table to a corresponding sample description record in the tableEntry table.
Integer value identifying individual specimens of the same species analyzed in a sample.
Value | Definition |
---|---|
0 | Analysis was not performed on an aggregate of specimens for the sample. |
1 | Analysis was performed on an aggregate of specimens for a sample. |
Integer count of the number of specimens in an aggregate sample.
Character string used to provide additional information about a measurement on a sample.
Integer key uniquely identifying a record in the tableEntry table.
Character string providing a short description of an attribute.
Character string providing a detailed description of an attribute.
Integer key relating records in the tableEntry table to a corresponding record in codeTable.
Integer key uniquely identifying a record in codeTable.
Character string representing a short description of an attribute type.
Character string representing a long description of an attribute type.
Integer key that uniquely identifies a record in the method table.
Character string representing the short description of a collection or analytical method.
Character string representing a detailed description of a collection or analytical method.
Integer key relating records in the method table to corresponding method description in the tableEntry table.
Integer key that uniquely identifies a row in the parameter table.
Character string representing the short description of a parameter.
Character string representing the long description of a parameter.
Character string representing the unique identifier assigned to a chemical by the Chemical Abstracts Service.
Integer key that related records in the parameter table to the corresponding chemical class description in the tableEntry table.
Integer key uniquely identifying a record in the location table.
Character string representing the name of a location.
Integer key relating location name in the location table to the corresponding U.S. state(s) in which the location occurs.
Character string representing the name of an ocean.
Character string representing the name of a sea or gulf.
Character string representing the name of a bay.
Character string representing the name of a river or lake.
Integer key that uniquely identifies a record in the study table.
Character string representing the name of a study.
Character string representing the unique code assigned to a study.
Character string representing the unique cruise code assigned to a study.
Character string representing the year in which a study occurred.
Character string representing the study name used in the National Benthic Inventory (NBI).
Integer key relating records in the study table to corresponding project descriptions.
Integer key relating records in the study table to the corresponding biogeographic province description.
843-762-8511 (voice)
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.
NOAA, National Centers for Coastal Ocean Science (NCCOS), Center for Coastal Environmental Health and Biomolecular Research (CCEHBR), Charleston, SC., 2013, Coastal Ecology Database.
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.
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.
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.
A data point is provided for every sample location.
All data are believed to be logically consistent.
Are there legal restrictions on access or use of the data?
- 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.
843-762-8511 (voice)
none
Data format: | ASCII |
---|---|
Network links: |
http://coastalscience.noaa.gov/ |
(843) 762 8511 (voice)