CBP/TRS 149/96
EPA903R 96-007
The 1996 Users Guide to
Chesapeake Bay Program
Biological and Living Resources
Monitoring Data
Chesapeake Bay Program
September 1996
EPA Report Collection
Regional Center for Environmental Information
U.S. EPA Region HI
Philadelphia, PA 19103
-------
Chesapeake Bay Program
The Chesapeake Bay Program is a unique regional
partnership leading and directing restoration of
Chesapeake Bay since 1983. The Chesapeake Bay
Program partners include the states of Maryland,
Pennsylvania, and Virginia; the District of Columbia;
the Chesapeake Bay Commission, a tri-state legislative
body; the U. S. Environmental Protection Agency, which
represents the federal government; and participating
citizen advisory groups.
In the 1987 Chesapeake Bay Agreement, Chesapeake Bay
Program partners set a goal to reduce the nutrients
nitrogen and phosphorus entering the Bay by 40% by the
year 2000. In the 1992 Amendments to the Chesapeake
Bay Agreement, partners agreed to maintain the 40%
goal beyond the year 2000 and to attack nutrients at
their source - upstream in the tributaries. The Executive '
Council guided the restoration effort in 1993 with five
directives addressing key areas of the restoration,
including the tributaries, toxics, underwater grasses, fish
passages, and agricultural nonpoint source pollution. In
1994, partners outlined initiatives for habitat restoration
in the Bay's tributaries; and toxics reductions, with an
emphasis on pollution prevention.
Since its inception, the Chesapeake Bay Program's
highest priority has been the restoration of the Bay's
living resources - itsfinfish, shellfish, bay grasses, and
other aquatic life and wildlife. Improvements include
fisheries and habitat restoration, recovery of bay
grasses, nutrient reductions, and significant advances in
estuarine science.
-------
Online Library System (OLS) Libraries US EPA
Page 1 of 2
http://cave.epa.gov/cgi/nph-bwcgis/BASIS/ncat/pub/ncat/DDW?W%3DREPNUM+PH+IS+%27903/r-
Libraries
OLS ; Record Display
Search:1 Sjmmra2 jrmrj3 jit] |&4 jeipJS [ Display Records as Bibliography ^ [ Item Status
RECORD NUMBER: 2 OF 2
Main Title
Publisher
Year
Published
OCLC
Number
Subject
Added Ent
Collation
Holdings
Notes
Corp Au
Added Ent
Title Ser Add
En:
Place
Published
PUB Date
Free Form
Series Ti
Untraced
Holdings
1996 users guide to Chesapeake Bay Program biological and living
resources monitoring data
The Program,
1996
37014596
Environmental monitoring—Chesapeake Bay (Md. and Va.) ; Natural
resources—Chesapeake Bay (Md. and Va.)
i v. (various pagings) : map ; 28 cm.
LIBRARY CALL NUMBER LOCATION
EJAD EPA 903/R-96-O07 Region 3 Library/Philadelphia, PA
"September 1996." "EPA 9O3R 96-007"— Cover. Includes bibliographical
references (p. 31).
United States. Environmental Protection Agency. Chesapeake Bay
Program. ; Interstate Commission on the Potomac River Basin.
CBP/TRS ;
Annapolis, Md. :
{1996}
CBP/TRS ; 149/96
LIBRARY Date Modified
-------
Online Library System (OLS) Libraries US EPA
Page 2 of 2
Modified
Bib Level
OCLC Time
Stamp
Cataloging
Source
Language
OCLC/NTIS
Type
OCLC Rec
Leader
EJA 19990813
m
19990812133716
OCLC/T
eng
OCLC
CAT
oiO93nam 220027713 45020
Q
Prinr
Tl r
|3 jfegj Manual. 4 JjeljJS I
Display Records as Bibliography
Item Status
URLs Provided for your Reference
i. http://cave.epa.gov/cgi/nph-bwcgis/BASIS/ncat/pub/ncat/SF
2. http://cave.epa.gov/cgi/nph-bwcgis/BASIS/ncat/pub/ncat/SDW?W%
3DREPNUM+PH+IS+%27903/r-96-007%27+ORDER+BY+YR/Descend%26M%3D2%
26R%3DY
3. http://cave.epa.gov/cgi/nph-bwcgis/BASIS/ncat/pub/ncat/DDW?W%
3DREPNUM+PH+IS+%27903/r-96-007%27+ORDER+BY+YR/Descend%26M%3Di%
26K%3D242769%26R%3DY%26U%3Di
4. http://cave.epa.gov/cgi/nph-bwcgis/BASIS/ncat/pub/ncat/SBC
5. http://www.epa.gov/natlibra/olshelp.htm
i_. // _____ --- ---- / -- : /„„!- 1 ___ , -- :„/!"> A OTO / --- *
T1V A i TIT I I TC
o it 1 i"if\f\t:
-------
U.S. EPA Region III
Regional Center for Environmental
Information
1650 Arch Street (3PM52)
Philadelphia, PA 19103
The 1996 Users Guide to Chesapeake Bay Program
Biological and Living Resources Monitoring Data
September 1996
Region il C enter lot I miionnlentti! Tnionniilion
I'SFPA Region III
1650 \ichSt
Philadelphia I'-V 10103
Prepared for
Chesapeake Bay Program
410 Severn Avenue
Annapolis, Maryland 21403
by
Interstate Commission on the Potomac River Basin
Suite 300, 6110 Executive Blvd.
Rockville, Maryland 20852
-------
Printed by the United States Environmental Protection Agency
for the Chesapeake Bay Program
EPA903R 96-007
CBP/TRS 149/96
To receive additional copies of this report, please write
Chesapeake Bay Program
410 Severn Avenue
Annapolis, Maryland 21403
or call 1-800-YOURBAY (1-800-968-7229).
Development of The 1996 Users Guide to Chesapeake Bay Program Biological and Living Resources Monitoring
Data was supported by the U.S. Environmental Protection Agency (Contract CB-993038-02-0) and the Interstate
Commission on the Potomac River Basin, an interstate compact river basin commission whose signatories are the US
Environmental Protection Agency, Maryland, Virginia, Pennsylvania, West Virginia and the District of Columbia.
-------
SUMMARY
This document describes how to access biological monitoring data at the Chesapeake Bay
Program (CBP) Data Center in Annapolis, Maryland. It provides information on:
4 currently available and soon-to-be-released CBP databases;
4 how to obtain biological and living resources monitoring data online from the CBP's
CHESEE computer, online from the CBP Internet Home Page, online from other
Home Pages, or directly from the Biological Monitoring Data Manager;
4 the semi-relational database structure used for biological and living resources monitoring
data, including field names and attributes; and
4 data dictionary tables.
•®" WATCH FOR DOCUMENT UPDATES AS NEW DATA SETS BECOME AVAILABLE
Currently Available Databases
Phytoplankton, Zooplankton and Benthos
Much of the phytoplankton, zooplankton (includes microzooplankton, mesozooplankton,
jellyfish and ctenophores) and benthos monitoring data and data documentation for
Maryland and Virginia from 1984 to 1995 can now be obtained directly from CHESEE by
individuals with user accounts or from the Biological Monitoring Data Manager.
Historical plankton and benthic data sets and the District of Columbia plankton monitoring
data are currently being placed on CHESIE. All data are in standardized, semi-relational
databases and are compatible with the CBP water quality databases (BayStats). They are
a) available as comma delimited, ASCII flat files; b) available from the Data Manager as
dBASE (*.DBF) files; and c) can be converted to SAS data sets from the ASCII flat files
with conversion scripts available on-line or from the Data Manager.
Benthos data sets for 1984 through 1995 are available in comma delimited, ASCII flat files
on the Internet at the Chesapeake Bay Program Home Page. Other data are being added.
Submerged Aquatic Vegetation (SAV)
Data and documentation for the annual Chesapeake Bay Submerged Aquatic Vegetation
Aerial Survey are generated and managed by the Virginia Institute of Marine Sciences
(VIMS). Data is maintained as Geographic Information System (GIS) Data Layers and
are available from the VIMS Internet Home Page. Pointers on the CBP Home Page direct
users to the VIMS Home Page for the SAV data.
-------
Data and documentation for the Maryland Department of Natural Resources Trends in
Distribution and Abundance of Submerged Aquatic Vegetation can now be obtained
directly from CHESIE by individuals with user accounts or from the Biological
-Monitoring Data Manager. The data are currently being made available "as is" in the
original SAS data files.
Soon-To-Be-Released Databases
Mammals, Turtles, and Birds
The Maryland Marine Mammal and Sea Turtle Strandings data and the Annual
Chesapeake Bay Midwinter Waterfowl Survey are expected to be available on CHESIE by
the Fall of 1996. State distribution rights/costs issues need to be resolved for other
aquatic bird surveys before they can be made available on CHESIE.
Finfish and Blue Crabs
The Biological Monitoring Data Manager is working with staff of the Maryland
Department of Natural Resource's, the Virginia Institute of Marine Sciences and the
NOAA Chesapeake Bay Office this year to obtain, reformat and document as needed, and
make available a) the Maryland and Virginia juvenile seine surveys and trawl surveys, and
b) the Blue Crab Winter Dredge Survey data.
Summary statistics for the Virginia juvenile seine survey are presently available through
the VIMS Internet Home Page. Pointers on the CBP Home Page direct users to the
VDVIS Home Page for these data.
-------
TABLE OF CONTENTS
SUMMARY i
TABLE OF CONTENTS iii
INTRODUCTION 1
Chesapeake Bay Program Data Center
Types of Data
Distributed Databases
CURRENTLY AVAILABLE CBP DATA FILES 4
Point Data
GIS (Geographical Information System) Data
LIVING RESOURCES AND BIOLOGICAL MONITORING DATABASES
AVAILABLE FROM OTHER SOURCES 10
Chesapeake-Bay Submerged Aquatic Vegetation Aerial Surveys (Arclnfo Coverages)
Virginia Fish Trawl Surveys (Summary Statistics and Juvenile Indices)
DATA FILES AVAILABLE SOON FROM THE CBP DATA CENTER 12
PoinfData
GIS Data
Priority Data Sets
DATA DIRECTORIES 14
CHESffi
CBP Internet Home Page
RELATIONAL DATABASES FOR POINT DATA FILES 16
Relational database systems
Data Format
File naming protocol
ACCESSING DATABASES 18
CBP CHESffi Computer
Obtaining data from the CBP Internet Web Page
Obtaining data on diskettes
MERGING AND WORKING WITH RELATIONAL DATA 22
Phytoplankton
Primary Production
Fluorescence
Microzooplankton and Mesozooplankton
iii
-------
TABLE OF CONTENTS (continued)
Benthos
Submerged Aquatic Vegetation
CBP DATA CENTER CONTACTS 29
REFERENCES 31
APPENDIX A: DATABASE STRUCTURES FOR AVAILABLE CBP DATA
APPENDIX B: BIOLOGICAL AND LIVING RESOURCES DATA DICTIONARY:
POSSIBLE FIELD NAMES
APPENDIX C: LIVING RESOURCES DATA DICTIONARY. EXPLANATION OF
PARAMETER CODES
APPENDIX D: CHESAPEAKE BAY PROGRAM DATA REQUEST FORM
APPENDIX E: DATA ACQUISITION PRIORITIES
IV
-------
The Chesapeake Bay and its Major Tributaries
ocomoke
zabetn.
-------
-------
THE 1996 USERS GUIDE TO CHESAPEAKE BAY PROGRAM
BIOLOGICAL AND LIVING RESOURCES
MONITORING DATA
INTRODUCTION
The 1996 Users Guide is intended to aid the Bay community in effectively accessing and
using biological monitoring data collected in Chesapeake Bay and its tidal tributaries. The 1996
Guide describes all biological and living resources databases currently available in standardized,
Chesapeake Bay Program structures and formats ("CBP databases"). It describes where the data
reside and how to obtain them. Future versions will include guidance for obtaining indicators and
summary statistics derived from the monitoring data.
Chesapeake Bay Program Data Center
The Chesapeake Bay Program (CBP) presently maintains a Data Center at its office in
Annapolis, Maryland. The purpose of the Data Center is to provide data management and
technical support to program participants in order to accomplish the goals agreed on by the
Chesapeake Executive Council. The Data Center manages the computer hardware and software
of the office, provides user support for these computer resources, acquires and stores data sets,
and provides data analysis support for Bay Program activities. Recipients of Data Center services
are the CBP subcommittees, Bay Program managers, and the watershed's scientific community
and stakeholders.
The current CBP information management system is centrally located on a variety of
controlled platforms at the Chesapeake Bay Program Office. The majority of data used by the
CBP are distributed across these platforms, although a few geographically distributed platforms
and data sets are included. The primary information and data analysis system is a-DEC Alpha
3800 Computer running an Open-VMS operating system. This system is referred to as CHESIE.
Other high level computing needs are meet with a variety of SUN, Data General, and Alpha PC
workstations running UNIX operating systems. Normal computer needs are met with the multiple
networked IBM and Macintosh personal computers on site.
A menu-driven software package entitled CHESSEE is currently on the CHESIE
computer. It is an information retrieval program designed to give users data documentation files
about selected water quality and toxic pollutant monitoring data available from the Data Center.
A relational database engine will be chosen in 1996 and configured to allow all monitoring
databases at the Data Center to be related and accessed.
Introduction 1
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
Types of Data
Five different kinds of data are collected, used or generated by the Chesapeake Bay-
Program and its participants. Thesejtypes of data are described in the 1996.USEPA Chesapeake
Bay Program document "Chesapeake Bay Program Information Management Requirements and
Recommendations, version 1.0" (Contract Number 01-08833-07-3872-005).
+ Raw Data - Original field sampling and laboratory results
+ Primary Data - Information submitted and exchanged "as is" by data providers
4- Chesapeake Bay Program Data - Information reviewed (e.g. QA/QC) and processed to
Chesapeake Bay Program standards and specifications
4- Analyzed Data - Summary results from data analysis
4 Indicators Data - Highly summarized data designed to tell a story about the health of the
Bay
"Raw data" are collected and managed offsite by the data originators - typically a monitoring
program - and are not available from the Data Center. "Primary data" are the data sets delivered
to the CBP Data Center by the data originators. Many are currently available from the Data
Center "as is" with their existing documentation. A long-term goal of the CBP is to work with
the data originators to produce primary data sets that meet or come close to CBP standards and
specifications, and to deemphasize use of primary data in favor of "Chesapeake Bay Program
data."
"Chesapeake Bay Program data" are in databases directly compatible with other CBP
databases such as the existing water quality monitoring data available in CBP BAYSTATS and
the CBP Toxics Database. Biological and living resources point data become CBP data after they
are placed in uniform, semi-relational database structures, with indexing fields or information.
The data are rigorously checked for duplicate fields, outliers, erroneous data, and other errors,
and problems in the data are resolved with the data providers. Biological and living resources
point data in CBP database structures are presently stored as comma delimited, ASCII flat files on
CHESEE. They will eventually be directly accessible through the CBP Internet Home Page as
well.
An effort is presently underway to create and make available databases of derived
information consisting of analyzed data and biological indicators. The information is calculated
from biological and living resources CBP databases using accepted algorithms or GIS
(Geographical Information System) methods. These forms of the data are expected to be most
useful to CBP participants and resource managers.
Distributed Databases
The Chesapeake Bay Program is developing a system of distributed databases as a result
of the rapid expansion of the Internet and the advancement of data management practices. In the
system envisioned, a CBP database would be created and managed by the data originator, reside
with the data originator, and made directly available from the data originator's institution on an
Internet server. This system has several advantages over a single data repository. Primarily, the
people with the most expertise and knowledge about the data - the data originators - are
2 Introduction
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
managing the data. Additional advantages include reduced costs due to elimination of
intermediate data handling at a central repository, and decreased time between collection and
release of the data.
Introduction 3
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
CURRENTLY AVAILABLE CBP DATA FILES
Point Data
Most of the 1984 - 1994 phytoplankton, zooplankton and benthos monitoring data for the
Maryland and Virginia CBP monitoring programs are currently on CHESIE as CBP databases.
Data for 1995 are available as CBP databases from the Biological Monitoring Data Manager. The
benthos and Primary Production CBP databases can also be found on the CBP Internet Home
Page and the other plankton databases are scheduled to be placed on the web shortly. Plankton
and benthos data sets are currently submitted by the monitoring program Principal Investigators in
structures very close to the CBP standardized, semi-relational database structure. The Biological
Monitoring Data Manager at the Data Center (see "CBP Data Center Contacts" below) rigorously
QA/QC's the data, finishes carrying them into the CBP database structure, and updates the data
document provided. The data are in comma delimited, ASCII flat files in single calendar year
blocks. Files in dBASE (*.DBF) are available on request and scripts to convert the ASCII files
into SAS files will be on-line soon.
Selected historical benthos files in CBP database structures and submerged aquatic
vegetation (SAV) files in their original SAS files are available on CHESIE. The benthos data files
were assembled Dr. Robert Diaz and staff at the Virginia Institute of Marine Sciences. The
Maryland SAV ground survey data were provided to the Bay Program several years ago by the
Maryland Department of Natural Resources.
Data in the directory LRDATA:[LR.PUBLIC] include:
4- Phytoplankton taxonomic counts
4- Primary productivity (C14)
4 Vertical and horizontal insitu fluorescence
4 Microzooplankton taxonomic counts
4- Mesozooplankton taxonomic counts
4- Mesozooplankton measured and estimated biomass
4- Gelatinous zooplankton measured biovolume
4- Benthos taxonomic counts
4- Benthos measured biomass
4- Sediment data (collected simultaneously with benthos samples)
4- Bottom water quality data (collected simultaneously with benthos samples)
4 Submerged aquatic vegetation biomass as measured by volume displacement, % crown
cover, species idenfications and coverages, and ancillary water quality data
Files associated with these data files in the relational database system are:
4- Various event files (contain information on station name, latitude, longitude, and depth;
sample volume; sample time; salinity zone; pycnocline depth; tide stage, etc.)
4- Chesapeake Bay species codes file (NODC code, Taxonomic Serial Number, and
individual agency codes)
4 Currently Available
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
Database structures (i.e. field names, definitions and attributes) for the currently available
CBP standardized data files are provided in Appendix A and online with the data files. A list of
possible CBP field names for biological and living resources data, and their definitions and units,
are provided in Appendix B. Appendix C contains definitions of the parameter codes used in the
databases.
Phytoplankton Abundance
Maryland Phytoplankton Taxonomic Count Files (and Related Event Files). Data have been
collected at fixed sampling stations in the upper Chesapeake Bay, Maryland tributaries and the
Potomac River since July 1984. Sampling was coordinated with the CBP water quality surveys.
The data through December of 1995 are available on CHESIE. Count files are for single
calendar years and include taxonomic identifications of species. Data were collected by the
Academy of Natural Sciences Benedict Estuarine Research Center through the Maryland
Department of the Environment/Maryland Department of Natural Resources.
Virginia Phytoplankton Taxonomic Count Files (and Related Event Files). Data for the lower
Chesapeake Bay and the Virginia tributaries have been collected at fixed sampling stations since
July 1985 (Chesapeake Bay mainstem), July 1986 (tributaries), and January 1989 (Elizabeth
River). Sampling was coordinated with the CBP water quality surveys. Data through 1995 is
available on CHESIE. Count files are for single calendar years and include taxonomic
identifications of species and conversion factors for biomass estimation. Data were collected by
Old Dominion University through the Virginia Department of Environmental Quality.
Primary Productivity
Maryland Carbon-14 Primary Production Files (and Related Event Files). Data have been
collected at fixed sampling stations in the upper Chesapeake Bay, Maryland tributaries and the
Potomac River since July 1984. Sampling was coordinated with the CBP water quality surveys.
The data through December of 1995 are available on CHESIE and the CBPO Home Page. Data
files are for single calendar years and includes precision measurements of primary photosynthetic
production. Data were collected by the Academy of Natural Sciences Benedict Estuarine
Research Center through Maryland Department of the Environment / Maryland Department of
Natural Resources.
Virginia Carbon-14 Primary Production Files (and Related Event Files). Data were collected at
fixed sampling stations in the Chesapeake Bay mainstem since January 1989 in Virginia tributaries
since July 1996, and in the Elizabeth River since January 1989. Sampling was coordinated with
the CBP water quality surveys. Data through December 1995 are available on CHESIE and the
CBP Home Page. Data files are for single calendar years and include precision measurements of
primary photosynthetic production. Data prior to 1995 lacks concurrent measurement of
chlorophyll a for determination of assimilation ratio (production efficiency). Data were collected
by Old Dominion University through the Virginia Department of Environmental Quality.
Currently Available 5
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
Fluorescence (Note: These data sets are the only exception to the relational data structure
format. Each file contains both instrument readings and event information for single calendar
years.)
Maryland Vertical Fluorescence Profiles. Surface to bottom fluorescence measurements have
been made at fixed sampling stations in the upper Chesapeake Bay, Maryland tributaries and the
Potomac River since July 1984. Sampling was coordinated with the CBP water quality surveys.
The data through December of 1995 are available on CHESEE. Files contain calculated values of
chlorophyll a. Data were collected by the Academy of Natural Sciences Benedict Estuarine
Research Center through Maryland Department of the Environment / Maryland Department of
Natural Resources.
Virginia Vertical Fluorescence Profiles. Surface to bottom insitu fluorescence measurements
were conducted at fixed sampling stations in the lower Chesapeake Bay and some Virginia
tributaries since 1990. Sampling was coordinated with the CBP water quality surveys. Data for
the tributaries were collected by Old Dominion University through Virginia Department of
Environmental Quality and have not been completely delivered to the CBP Data Center. Data for
the bay mainstem prior to January 1995 was collected by the Virginia Institute for Marine Science
and will be available shortly from the Data Center pending processing.
Maryland Horizontal Fluorescence Transects. Insitu fluorescence measurements were taken
along surface transects between monitoring stations in the upper Chesapeake Bay and some
Maryland tributaries since 1984, and between monitoring stations in the Potomac River since
1989. Sampling was coordinated with the CBP water quality surveys. Data through December
1995 are available on CFfESJJE. Data files contain calculated values of chlorophyll a. Note:
Sampling sites along all transects except those in the Potomac were extrapolated from the time-
of-travel and the known distance between stations. Potomac transect sites were measured with a
Lor an receiver. See Data Documentation for details. Data were collected by the Academy of
Natural Sciences Benedict Estuarine Research Center through the Maryland Department of the
Environment/Maryland Department of Natural Resources.
Virginia Horizontal Fluorescence Transects. Insitu fluorescence measurements were taken along
surface transects between monitoring stations in the lower Chesapeake Bay and some Virginia
tributaries since 1990. Sampling was coordinated with the CBP water quality monitoring surveys.
Data for the tributaries were collected by Old Dominion University through Virginia Department
of Environmental Quality and have not been completely delivered to the CBP Data Center. Data
for the bay mainstem prior to January 1995 were collected by the Virginia Institute for Marine
Science and will be available shortly from the Data Center pending processing. Note: In some
cases sampling site postions were not determined with G.P.S. or Loran receivers and
latitude/longitude values in the files will be extrapolated from the time-of-travel and the known
distance between stations. See data documentation files for details.
Microzooplankton
Maryland Microzooplankton Count Files (and Related Event Files). Data have been collected at
fixed sampling stations in the upper Chesapeake Bay, Maryland tributaries and the Potomac River
6 Currently Available
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
since July 1984. Sampling was coordinated with the CBP water quality surveys. Data through
December 1995 are available on CHESIE. Count files are for single calendar years and include
taxonomic identifications of species. Data were collected by the Academy of Natural Sciences
Benedict Estuarine Research Center through the Maryland Department of the
Environment/Maryland Department of Natural Resources.
Virginia Microzooplankton Count Files (and Related Event Files). Data were collected at fixed
sampling stations in the lower Chesapeake Bay and the Virginia tributaries, including Elizabeth
River since July 1993. Sampling was coordinated with the CBP water quality surveys. Data
through December 1995 are available on CHESIE. Count files are for single calendar years and
include identifications of general taxonomic groups. Data were collected by Old Dominion
University through the Virginia Department of Environmental Quality.
Mesozooplankton and Gelatinous Zooplankton
Maryland Zooplankton Count, Biomass and Biovolume Files (and Related Event Files). Data
have been collected at fixed sampling stations in the upper Chesapeake Bay, Maryland tributaries
and the Potomac River since July 1984. Sampling was coordinated with the CBP water quality
surveys. Data through December of 1995 are available on CHESIE. Count files are for single
calendar years and include taxonomic identifications of mesozooplankton (>202/u.) species, actual
or estimated measurements of mesozooplankton biomass, and measurements of gelatinous
zooplankton biovolumes. Data were collected by Versar, Incorporated, through the Maryland
Department" of the Environment/Maryland Department of Natural Resources.
Virginia Zooplankton Count and Biovolume Files (and Related Event Files). Data were
collected at fixed sampling stations in the lower mainstem since July 1985, at tributary stations
since July 1986, and in the Elizabeth River since January 1989. Sampling was coordinated with
the CBP water quality surveys. Mesozooplankton (>202yu) count files are for single calendar
years and include taxonomic identifications of species. Biovolume data was collected sporadically
from 1985-1995 and is available in a single file. Data files are currently being resubmitted to the
Data Center, please contact the Biological Data Manager for details. Data were collected by Old
Dominion University through the Virginia Department of Environmental Quality.
Benthos
Maryland Benthic Count, Biomass, and Sediment and Bottom Water Analyses Files (and Related
Event Files). Data have been collected at fixed sampling stations in the upper Chesapeake Bay,
Maryland tributaries and the Potomac River since July 1984. Sampling was not coordinated with
the CBP water quality surveys. Data through December of 1995 are available on CHESIE and
the CBPO Home page. Files include detailed taxonomic identifications and counts of species,
determination of sample biomass, sediment analysis and hydrographic profiles. The protocol for
selection of sampling stations, collection gear and methods of biomass analysis has changed over
the ten years of the monitoring program. Please see the Data Documentation for details. Data
were collected by Versar, Incorporated, through the Maryland Department of the
Environment/Maryland Department of Natural Resources.
Currently Available 7
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
Virginia Benthic Count, Biomass, and Sediment and Bottom Water Analyses Files (and Related
Event Files). Data were . ollected at fixed sampling stations in the lower Chesapeake Bay and its
Virginia tributaries since July 1985 and in the Elizabeth River monitoring data since January 1989.
Sampling is done quarterly and separately from the regular CBP water quality surveys. Locations
of the sampling stations deviate slightly from those in CBP water quality and plankton monitoring
program. The files include taxonomic identifications and counts of species, biomass
determinations, sediment analysis and hydrographic profiles. Data through December of 1995 are
available on CHESffi and the CBPO Home Page. Data were collected by Old Dominion
University through the Virginia Department of Environmental Quality.
Historic Benthic Count, Sediment and Bottom Water Analyses Files (and Related Event File).
Data were collected at fixed sampling stations in Chesapeake Bay and some of its tributaries prior
to 1984. These data complement and enhance the ongoing CBP benthic monitoring programs
which began in 1984. In all cases, the raw data from these studies are kept by the authors. Dr.
Robert Diaz, Virginia Institute of Marine Sciences, reformatted the following data sets to the
CBP database structure:
4- Piney Point, Potomac River 1975 Virnstein & Boesch, 1975
4- Possum Point, Potomac River 1977-78 Ecological Analysts, 1979
4- Tangier Island, Chesapeake Bay 1975 Orth & Boesch; 1975
4- Amoco Refinery, Lower York River 1977 Hinde, 1981
4- Thimble Shoals, Chesapeake Bay 1981 Hobbset al., 1985
4- Warwick River, James River 1975-76 Diaz & Boesch, 1976
4- Hampton Roads to Richmond,
James River 1981 Schaffher et al., 1987
The studies were combined into single files for taxon counts, sediment water analysis, bottom
water analysis and event information because of their small size. These related data sets are
available on CHESffi.
Submerged Aquatic Vegetation
Maryland Department of Natural Resources Trends in Distribution and Abundance of
Submerged Aquatic Vegetation. Ground surveys of SAV were conducted periodically between
1971 and 1983 in the Chesapeake Bay mainstem between Susquehanna Flats and Smith Island.
Additionally, regular surveys of SAV were conducted in the Potomac River between 1984 and
1986. Survey information includes SAV biomass as measured by volume displacement, percent
crown cover, species identifications and coverages, depth, salinity, surface temperature, and
secchi depth. The data have not been converted to a CBP database structure and are available on
CHESffi as the original PAS files.
CIS (Geographical Information System) Data
Several types of biological, living resources and habitat coverages are available by
contacting the Living Resources GIS Specialists (see "CBP Data Center Contacts"). The
8 Currently Available
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
coverages are listed below. They are available as uncompressed Arc Info export files. Detailed
information about the coverages can be provided by the Living Resources GIS Specialists.
Oysters
4 Virginia's Public Oyster Grounds and Privately Leased Oyster Grounds
4- Virginia's Oyster and Aquatic Reef Restoration Sites
4- Maryland's Legal Oyster Bed Boundaries
4 Maryland's Aquatic Reef Restoration Sites
4 Yates Survey for Maryland
Fish. Fisheries and Fish Passage
4 Recreational fishing areas in Maryland
4 Commercial fishing areas in Maryland
4- Miscellaneous low resolution stream reach files
4- Pennsylvania Phase I & II migratory fish passage blockages
Submerged Aquatic Vegetation
4 Historical surveys for 1971, 1974, 1978, 1979, 1980, 1981, 1985, 1986, 1989, 1990,
1991, 1992, 1993 and 1994 (coverages are not bay-wide until 1978)
4 Tier! coverage (all areas historically supporting SAV from 1971 - 1990)
4- Tier III (old "hand drawn" coverage that will be updated with new bathymetry layer)
4 SAV bed perimeter, area and density
Habitat
4 Pennsylvania stream habitat survey data for selected streams in the lower Susquehanna
watershed
Currently Available 9
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
LIVING RESOURCES AND BIOLOGICAL MONITORING DATABASES
AVAILABLE FROM OTHER SOURCES
The Chesapeake Bay Program partners are working together to developing a system of
distributed databases to better utilize the rapid expansion of the Internet and the advancement of
data management practices. In the envisioned distributed database system, data will be collected,
managed and maintained by the data originator. The data access is provided via the data
originator's Internet server. One distributed database presently exists for CBP data: the Bay
Program funded Submerged Aquatic Vegetation Aerial Survey. Other distributed databases are
in various stages of development by CBP participants, including the completed database of
summary statistics and indices for the Virginia Fish Trawl Surveys.
Chesapeake Bay Submerged Aquatic Vegetation Aerial Surveys (Arclnfo Coverages)
The Chesapeake Bay Submerged Aquatic Vegetation (SAV) data are mapped from
1:24,000 aerial photography for 1971, 1974, and 1980; 1984 (Virginia only); 1979 (Maryland
only); 1978, 1984 through 1987, and 1989 through 1995. Each area of SAV was traced onto
1:24,000 USGS quadrangles and classified into one of four density classes by the percentage of
cover. The SAV beds were then digitized into an Arc/Info GIS coverage using the quality control
procedures documented in the individual metadata files. Data were collected by the Virginia
Institute of Marine Sciences. The SAV data files are in uncompressed Arc/Info (ESRI, Redlands,
CA) export format. They have been compressed using PKZIP compression to form .zip files for
use on IBM-compatible personal computers and also compressed using UNIX standard
compression to form .tar.Z files for use on UNIX platforms. Each file contains both the .eOO
Arc/Info export file and also a .txt metadata file. Please consult the metadata file to determine if a
particular data set will satisfy your needs. The Internet address for the Virginia Institute of
Marine Sciences SAV Home page is:
http: //www. vims, edu/bi o/sav/index. html
Virginia Fish Trawl Surveys (Summary Statistics and Juvenile Indices)
The Virginia Institute of Marine Science (VIMS) has conducted a trawl survey annually
since 1955. The primary objective of the survey is to monitor trends in abundance of juvenile fish
of about twenty recreationally, commercially, and ecologically important finfish and invertebrates.
Currently, the survey samples waters from the mouth of the Chesapeake Bay north to the
freshwater interfaces of the James, York, and Rappahannock Rivers. Samples from about 60
stations are collected every month. At each station, a 30 foot wide shrimp trawl is towed for five
minutes. The Internet address for the Virginia Institute of Marine Sciences Fisheries Home page
is:
http ://www. vims, edu/fish/trawlsurvey/index. html
10 Other Sources
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
The CBP Data Center is interested in listing and describing Chesapeake Bay living
resources and biological monitoring data sets which are presently available on the Internet.
If you know of data sets of this nature, please contact the Biological Monitoring Data
Manager at the CBP Data Center (see "CBP Data Center Contacts").
Other Sources 11
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
DATA FILES AVAILABLE SOON FROM THE CBP DATA CENTER
Point Data
Additional plankton and benthic data sets are currently being restructured, reformatted,
QA/QC'ed and documented, and will become available on CHESBE as they are completed. These
data sets are close to being final because of earlier work of prior computer support contractors
and the Interstate Commission on the Potomac River Basin (ICPRB).
4 Taylor Phytoplankton Data
4- District of Columbia Plankton Monitoring Data (1983 - 1992)
The Cooperative Oxford Laboratory (Maryland Department of Natural
Resources/National Oceanographic & Atmospheric Administration) has forwarded the following
data to the CBP Data Center to be computerized, augmented with National Marine Fisheries
Service data, and made available:
4 Maryland Marine Mammal and Sea Turtle Strandings Data
The Biological Monitoring Data Manager is working with staff of the Maryland
Department of Natural Resources, the Virginia Institute of Marine Sciences and the NOAA
Chesapeake Bay Office this year to obtain, reformat and document as needed, and make the
following data available on CHESEE and possible the Internet:
4 Juvenile Finfish Summer Seine Surveys
4 Finfish Summer Trawl Surveys
4 Blue Crab Winter Dredge Survey
CIS Data
The CBP Biological Monitoring Data Manager is working with the U. S. Fish & Wildlife
Service to make several aquatic bird survey databases and GIS coverages more readily available
from the CBP Data Center or from the US Fish and Wildlife Service. State distribution
rights/costs issues need to be resolved for some of these surveys. However one survey is
available:
4 Annual Chesapeake Bay Midwinter Waterfowl Survey
The Living Resources GIS Specialists will also be finishing or receiving the following coverages
soon and making them available from the CBP Data Center:
12 Available Soon
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
Boundary Layers
4- Maryland Tributary Strategy Boundaries
4- Virginia Tributary Strategy Boundaries
Habitat
4 Bay bottom survey (Oxford Lab)
Fish. Fisheries and Fish Passage
4 Virginia impediment database
4 Maryland blockage database
4 Pennsylvania Phase III blockage data
4 New York dams database
4 EPA RF3 streams by 8-digit Hue @ 1:100,000
4 Basin-wide hydrography @ 1:24,000 (PA,MD) and 1:100,000 (remainder)
Submerged Aquatic Vegetation
4 1995 SAV aerial survey
Oysters
4 Maryland Oyster Reef Restoration Sites (MDDNR)
Priority Data Sets
The Living Resources/Monitoring Workgroup (jointly held by the Living Resources and
Monitoring Subcommittees) has prioritized the categories of biological monitoring data that they
believed are critically important to CBP activities (see Appendix E). The Workgroup
recommended that key data sets in these categories be made available from the CBP Data Center,
preferably as CBP databases. The Biological Monitoring Data Manager and the Living Resources
GIS Specialists are using this prioritized list of data categories as a guide for obtaining and
assembling data.
Available Soon 13
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
DATA DIRECTORIES
CHES1E
The living resources data directory on CHESEE is LRDATA:[LR.PUBLIC]. The
CHESDE computer system consists of a DEC Alpha 3800 computer with an Open-VMS operating
system. Point data and data documentation are directly accessible as ASCII flat files to all
individuals with user accounts on CHESEE. Subdirectories presently in LRDISK:[LR.PUBLIC]
contain the CBP plankton and benthos monitoring data (Figure 1). Other types of point data will
be placed in additional, appropriately named subdirectories of LRDISK:[LR.PUBLIC] when they
become available from the Data Center. Data from ongoing programs will remain in separate
subdirectories and historical data will be placed in a single subdirectory.
LRDISK:[LR. PUBLIC]
Phytoplankton
I 1 \
MD VA HI
Production
Fluorescence
Microzooplankton
Mezozooplankton
Benthic
SAV
i i r
MD VA
I I I
MD VA
I I I
MD VA
MD VA
i i r^*^
MD VA HI
->
HI
I I
Figure 1. Diagram of present LRDISK:[LR.PUBLIC] directory structure for point data. MD =
Maryland; VA = Virginia; HI = historical. Arrows indicate future directories.
Biological and living resources GIS (Geographical Information System) coverages will not
be stored on CHESIE. They will be accessible from a GIS directory on the CBP Internet Home
Page and "hot linked" to biological and living resources point data residing on the Home Page.
14 Directories
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
CEP Internet Home Page
The CBP effort to establish and populate an Internet Home Page is in its early stages. A
series of menus leading to a directory of CBP biological databases has been created at this time.
However, only the Maryland and Virginia benthos and C14 productivity data and an order form for
other biological data currently reside there. The data are provided in the same format as on
CHESIE: comma delimited, ASCII flat files. Other CBP databases and data management "tools"
(e.g. QA/QC programs, documentation, conversion tables, algorithms to calculate indicators) are
being added to the Home Page server in installments. "Hot links" to Chesapeake Bay data on
other Internet servers will be formed as the developing CBP distributed database is implemented.
A user will eventually be able to download databases, summary statistics and indicators, data
documentation, and key data management documents and data inventories from several servers
via the CBP Home Page. The CBP Internet Home Page address is:
http://www.epa.gov/r3chespk/
The Home Page clearly requests that data users acknowledge the original monitoring
programs as the data originators in future publications which reference or use the
databases.
Directories 15
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
RELATIONAL DATABASES FOR POINT DATA FILES
Relational database systems
The Chesapeake Bay Program has experimented in the development of a relational
database for point data collected in monitoring programs which it fully/partially sponsors or
matches. This specifically includes the CBP plankton and benthos monitoring data. However, the
Bay Program is still searching for a database engine and applications which meet the diverse needs
of the Program. In lieu of a functioning relational database system at the Data Center, the
plankton and benthos data were placed in a semi-relational database structure which consists of
sets of related computer files.1 For example, benthos monitoring information is distributed in files
of species count data, simultaneously collected water quality, sediment data, and a related event
file which includes repetitive ancillary information. In addition, there is a supporting file
containing species Latin names and the various species coding schemes used in the bay area. The
files can be linked, or related, on several common fields, eliminating the need to include repetitive
sample information. This arrangement of the data saves electronic storage space and electronic
transfer time for files, and aids in QA/QC'ing the data. Related files can be quickly merged to
create a single, complete data record when necessary.
^ Please read the section below entitled "Merging and Working with Relational Data
Files." Incorrectly merged data files may result in problematic databases and
erroneous results.
Field names and attributes defined in the CBP Data Management Plan (USEPA, March
1993) and the CBP Living Resources Data Management Plan, Revision 1 (USEPA, August 1989)
were used in constructing the plankton and benthos semi-relational database system. This feature
of the databases allows them to be joined and compared with ease to independent water quality
and toxic contaminant data sets containing common fields.
Data Format
Data in the LRDISK:[LR.PUBLIC] are stored as comma delimited, ASCII flat files.
ASCII files can be readily uploaded to a relational database system at a future time.
File naming protocol
A standard method for naming the CHESIE living resources data sets and data
documentation has been established. The protocol is described in Table 1.
1 Technically, the files are in a semi-relational database structure since a true RDBS contains files linked by
only one common field and these are linked by two to seven common fields. Multiple common fields make the files
easier to use in the absence of a relational database application.
16 Relational Databases for Point Data
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
Table 1. File naming protocol for living resources monitoring data sets.
All CBP biological database or documentation files are named using the following
convention:
SSDDTTYY.TXT
HISSDDTT.TXT
SSDDDOC.TXT
Where
SS
HI
DD
TT
YY
DOC
State Providing Data
Historic Data Set
Data Type
Data File Type
Collection Year of Data in File
Data Documentation Text
The extension .TXT refers to the file type which is comma delimited ASCII.
State Provider Abbreviations
VA = Virginia
MD " = Maryland
PA = Pennsylvania
DC = District of Columbia
NY = New York
WV = West Virginia
Data Type Abbreviations
PH = Phytoplankton
MZ = Mesozooplankton
MI = Microzooplankton
PD = Primary Production
FL = Fluorescence
BE = Benthic
Data File Type Abbreviations
DOC = Data Dictionary
TX = Taxonomic
EV = Sampling Event
BM = Biomass
BV = Biovolume
LD = Production (Light/Dark Bottle)
KY = TaxonKey
SD = Sediment data
CF = Carbon 14 Fixation Rates
LD = Light/Dark Bottle
VF = Vertical Fluorescence
HF = Horizontal Fluorescence
FL = Fluorescence (Light/Dark Bottle)
WQ = Water Quality
Relational databases for Point Data 17
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
ACCESSING DATABASES
CBP CHES1E Computer
Individuals with user accounts on CHESIE can obtain living resources and water quality
monitoring data as well as access to computing resources. You can apply for a user account by
calling the of the CBP Computer Support Help Desk, at 1-800-968-7229, extension 769. The
help desk will explain the application procedure and provide you with the necessary paper work
to receive an account. (If you do not want to apply for a user account but would like to obtain
data, see "Obtaining data on diskettes" below.)
CHESIE can be accessed by TELNET (for working on CHESIE via Internet from a
remote location), FTP (for Internet data transfer) and by dial-in modem (KERMIT and
ZMODDEM protocol are supported for data download). Anonymous FTP is not allowed into
CHESIE at this time. The directions below provide basic instructions for accessing files by
these three methods. For problems connecting to the system and transferring files, please call the
help desk. If you have problems with the actual contents of a data set, please contact the
Biological Monitoring Data Manager.
Dial in Procedures
1) Configure your local communications software package for the following settings:
no parity
8 bit per character
1- stop bit
software flow control (ctrl-S, ctrl-Q)
ASCII format
modem speed may be set anywhere between 1200 and 14400 baud
2) Initiate dial-in procedure. The local phone numbers are either 410-267-5782, 5783 or 5784
and they connect you directly with CHESIE. There is a toll free dial-in line: 1-800-968-7229, ext.
782, 783 or 784. The phones are programmed to automatically select the next available line so
that users do not have to call several numbers to find an open line.
NOTE: A pause is required between dialing the 800 number and the extension. In your dial
string, insert a sufficient number of commas between the 800 number and the extension to ensure
proper handling of your computer dial-in by the CBP phone system. The length of the pause
between the 800 number and the extension depends on your modem software. Suggested starting
number of commas is nine and add or subtract as necessary.
3) At the EPA47> prompt, enter c CHESIE and hit return. You will then reach a screen asking
for your username and password.
4) Note when logging out of the system you will need to type logout from both CHESIE and
from the EPA47> prompt before you can disconnect from the system.
18 Accessing Databases
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
Telnet Procedures
1) Login to your local machine with INTERNET access as usual.
2) Type TELNET.
3) Type connect chesie.ann.epa.gov.
4) Login to CHESIE with your username and password.
5) For details on copying files to your personal user space see "Working with Files" below.
6) Typing logout or logoff will end your CFTESIE TELNET session.
7) Typing exit will end your TELNET session.
Working with Files
1) Once logged onto CHESIE you are in your home directory. You will need to enter the
Living Resources public access directory as described above to obtain data sets. Enter the living
resources directory by typing set def LRDISK:[lr.public.*.*]. (For *.*, insert data type and
state directory names. For example, Maryland benthic data requires the command set def
LRDISK: [lr.puhlic.benthic.md | )
2) The living resources LR.PUBLIC directory has READ ONLY areas. You must copy data to
your user area to use the data. The command copy *.txt userdisk: [yourusername] will copy all
the data files and necessary documentation to your user area for a given data set.
3) Type set def userdisk: [yourusername] followed by dir to confirm all files were copied.
4) Type help at any point to receive online help.
5) Water quality data may be accessed by typing baystats from your userdisk space. The menu
driven BAYSTATS explains how to retrieve data. Please see the Users Guide to Water Quality
Data for details.
File Transfer Protocol (FTP')
1) Login to your local machine with INTERNET access as usual.
2) Type ftp
3) Type open chesie.ann.epa.gov
4) Login to CHESIE with your username and password.
Accessing Databases 19
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
5) After the initial login you will be in your own personal user space so to transfer files to your
local machine you will need to change directories. Type cd LRDISK:[lr.public].
(Please note that proper VMS disk and file addresses must be used with ftp command)
6) You will enter the living resources public access directory as described above. Enter the
directory containing the desired data sets by typing cd LRDISK:[lr.public.*.*j. (For *.*, insert
data type and state directory names. For example, type the command cd
LRDISK:[lr.public.benthic.md] for Maryland benthic data.)
7) You are now ready to transfer data. (The default data transfer mode is ASCII.) To transfer
the complete data set and documentation type mget . You will be prompted if
you wish to transfer the first file. Type a (for all) when prompted and all files in the current
directory will be transferred to your local machine.
8) Type bye or quit to end your FTP session.
Obtaining data from the CBP Internet Web Page
The Internet address for the Chesapeake Bay Program Home Page is:
http://www.epa.gov/r3 chespk/
The procedure to download data will vary according to web browser type. Please see your in-
house or online documentation for details.
Obtaining data on diskettes
Individuals without user accounts on CHESIE, users wishing to obtain S AS conversion
scripts or users wishing to obtain the data files in dBASE (.dbf) format can request data sets
directly from the Biological Monitoring Data Manager. All requests must be made in writing. A
data request form is provided in Appendix D and can be sent to:
Ms. Jacqueline Johnson
Biological Monitoring Data Manager
Chesapeake Bay Program Data Center
410 Severn Avenue, Suite 109
Annapolis, MD 21403
Phone (local): 410-267-5729
Phone (long distance): 800-968-7229, ext. 729
FAX: 410-267-5777
E-mail: JJOHNSON@CHESIE.ANN.EPA.GOV
20 Accessing Databases
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
The data form may be copied. Please request only one data set per form. Requests for data other
than living resources data may be made on this form but should be mailed to the Chesapeake Bay
Program Data Center Manager:
Mr. Lowell Banner
Data Center Manager
Chesapeake Bay Program Data Center
410 Severn Avenue, Suite 109
Annapolis, MD 21403
Phone (long distance): 1-800-968-7229, ext. 671
FAX: 410-267-5777
E-mail: LBAHNER@CHESIE.ANN.EPA.GOV
Accessing Databases 21
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
MERGING AND WORKING WITH RELATIONAL DATA FILES
Data availability and demand for data access have grown at exponential rates due to the
extensive growth of the Internet. The combination of increased data access and new mechanisms
to store and distribute data have radically changed the job of the data management. It has become
increasingly difficult to provide adequate guidance to data users on correctly handling the
databases and interpreting the data. Analysts frequently derived unsatisfactory results because
they used data unsuitable for the analysis or incorrectly interpret the information in a database. On
a more basic level, they can incorrectly merge related files in a relational database system and
create corrupted databases.
PLEASE READ THE DATA DOCUMENTATION FILES. Before you use the data, make
yourself aware of the original objective(s) and sampling design of a study or monitoring program
as well as the database structure. The data documentation files explain the details of sample
collection and processing and the structure of the data files for each study. All of the data
documentation sets have been written or rewritten with the end data user in mind. They assume
that a user has no previous knowledge of the data collection program. The biological data sets
described in this document are typically either from large scale monitoring programs or intensive,
targeted studies. The Chesapeake Bay monitoring programs and other long term efforts are
intended to detect changes and/or trends in the status of living resources on a large scale. They
were designed to be used in a wide variety of analyses. These monitoring programs do not have a
spatial or temporal scale fine enough to answer many site or time specific questions. However,
they are useful in answering complex, bay-wide questions. Another portion of the data sets,
predominantly the historic data sets, are targeted studies. These studies were originally designed
to answer specific scientific or resource management questions on a fine scale. Therefore,
sampling design, analytical protocol or site selection criteria may preclude or obscure elements of
the data set critical for your analytical questions.
This chapter provides guidance on how to correctly merge related files of the CBP
biological and living resources monitoring data. Common pitfalls in using the data are also noted.
The Chesapeake Bay Program relational database structures and formats have been discussed in
previous sections of this document. Actual field names and attributes appear in Appendix A and
online in the individual data set documentation files. A list of possible CBP field names for
biological and living resources data, and their definitions and units, are provided in Appendix B.
Appendix C contains definitions of parameter codes used in the databases.
Phytoplankton
CBP Databases
These data sets require merging to be fully functional. The Virginia and Maryland files
may be combined with no special preparation. The Taxon and Event files should be merged by
linking the following fields:
22 Merging and Working -with Relational Data Files
-------
The 1996 I ".-zrs Guide to CBP Biological and Living Resources Monitoring Data
DATE
STATION
LAYER
SER_NUM
Common user errors or pitfalls for these data include:
1) Composite Samples: It should be noted that the CBP sampling protocol utilizes
composite samples. There are no samples for individual depths.
2) NODC CODES and TSN's: All species were assigned National Oceanographic Data
Center (NODC) species coded and permanent Taxon Serial Numbers (TSN) where
available. The NODC taxonomic Code is a hierarchical system of numerical codes used to
represent the scientific names of organisms. The Code links the Linnean system of
biological nomenclature to a numerical schema that facilitates modern methods of
computerized data storage and retrieval. Additionally each recognized species is given an
unique permanent taxon serial number. The TSN value does not ever change regardless of
changes in taxonomic classification over time. NODC CODES are updated regularly.
Please look at the RJDATE field in the Taxon Key file for each Data type, this date
should never be more than a year old.
3) Virginia Picoplankton Counts: Picoplankton counts are available in the Virginia
phytoplankton data and not in the Maryland data. They appear as a single record for each
Virginia sample and are listed as "Autotrophic Picoplankton." They are included in the
total count of organisms (TDEN_L) for a sample. It may be desirable to separate this
size fraction and recalculate total count of organisms (TDEN_L) for some analysis.
Primary Production
CBP Databases
These data sets require merging to be fully functional. The Virginia and Maryland files may be
combined with no special preparation. The Taxon and Event files can be merged by linking the
following fields:
DATE
STATION
LAYER
SER_NUM
Common user errors or pitfalls for these data include:
1) The Maryland production data was resubmitted in 1995 due to errors in the calculation
of some primary production values. Do not use data with an R_DATE prior to May 31,
1995.
Merging and Working with Relational Data Files 23
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
2) It should be noted that the CBP sampling protocol utilizes composite samples. There
are no samples for individual depths.
Fluorescence
CBP Databases
These data sets do not require merging to be fully functional. The horizontal and vertical
files may be combined with no special preparation. You should pay attention to the SDEPTH
field. Some measurements are at depth and others at the surface. A note of caution in regards to
the Maryland Horizontal Fluorescence data between 1984 and 1995 and all Virginia Horizontal
fluorescence: the station latitudes and longitudes in these data records are approximations of
actual positions in the field. Please see FORMULAS, CALCULATIONS, AND
CONVERSIONS in the Data Documentation for detailed explanation of how the positions were
estimated. This method of locating position does not meet EPA sampling position policy since
sampling locations were not measured with G.P.S. (Global Positioning System). Inaccuracies in
the estimated station locations may be problematic in GIS or other mapping applications. The
Horizontal Potomac Fluorescence locations and the Maryland and Virginia Vertical Fluorescence
locations were determined with Loran-C and should be less problematic than the remaining
Horizontal Fluorescence locations which were estimated by extrapolating between the start and
end locations.
Common user errors and pitfalls for these data include:
1) The Maryland Fluorescence data was resubmitted due to errors in the calculation of
fluorescence values. Do not use data with an R_DATE prior to May 31, 1995.
Microzooplankton and Mesozooplankton
CBP Databases
These data sets require merging to be fully functional. The Virginia and Maryland files for
mesozooplankton may be combined with no special preparation. The Taxon and Event files for
mesozooplankton can be merged by linking the following fields:
DATE
STATION
LAYER
SER NUM
24 Merging and Working -with Relational Data Files
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
Mesozooplankton Biomass, Biovolume and Event files can be merged by linking the following
fields:
DATE
STATION
LAYER
SER_NUM
Please READ THE DATA DOCUMENTATION F/LEbefore attempting to merge the Maryland and
Virginia microzooplankton data. The taxonomic identification levels in the Virginia
microzooplankton data are not as detailed as those in the Maryland data. You may want to make
the taxononic identification levels comparable by removing species identifications in specific cases
and summing counts for genus, family or order levels. The Taxon and Event files for
microzooplankton can be merged by linking the following fields:
DATE
STATION
LAYER
SER_NUM
The Microzooplankton and Mesozooplankton Taxon files can be merged provided the following
corrections are made to the mesozooplankton:
1) Mezozooplankton counts are reported in organisms per cubic meters.
Microzooplankton counts are reported in organisms per liter. The mesozooplankton
taxon counts and total counts must be converted to liters before the sets can be merged.
The conversion is:
DEN_M3 /1000 = DEN_L
and
TDEN_M3 / 1000 = TDEN_L
2) Copepoda nauplii were counted in both the mesozooplankton and microzooplankton
samples and included in both data sets. The smaller mesh size (<44u) of the net used to
collect microzooplankton samples in Maryland and the whole water sample collection
method in Virginia are more efficient in retaining the smallest copepod nauplii. Therefore,
the microzooplankton estimates of copepod nauplii density are considered by the Principal
Investigators to be more accurate. Remove the copepod nauplii in the Mesozooplankton
files prior to merging the Micro- and Mesozooplankton files.
3) Barnacle nauplii were reported in the Virginia Mesozooplankton data from January
1985 through December 1992. After January 1993 barnacle nauplii were reported only in
the Microzooplankton data.
Merging and Working with Relational Data Files 25
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
Common user errors and pitfalls for these data include:
1) Not paying attention to the life stage column. These data sets will have multiple
records for the same species that differ by the life stage. An empty life stage column
means the taxon counted were adult organisms.
2) NODC CODES and TSN's: All species were assigned National Oceanographic Data
Center (NODC) species coded and permanent Taxon Serial Numbers (TSN) where
available. The NODC taxonomic Code is a hierarchical system of numerical codes used to
represent the scientific names of organisms. The Code links the Linnean system of
biological nomenclature to a numerical schema that facilitates modern methods of
computerized data storage and retrieval. Additionally each recognized species is given an
unique permanent taxon serial number. The TSN value does not ever change regardless of
changes in taxonomic classification over time. NODC CODES are updated regularly.
Please look at the RJDATE field in the Taxon Key file for each Data type, this date
should never be more than a year old.
3) CBP monitoring program components collect composited samples. There are no
samples for individual depths.
4) Mesozooplankton settled volumes for non-gelatinous zooplankton were estimated in
all cases where biomass was estimated. Values were estimated when samples contained
high levels of detritus. To determine if the settled volume is actual or estimated, merge
the biomass and biovolume files by station, date, rep_num and ser_num.
Benthos
CBP Databases
These data sets require merging to be fully functional. The Virginia and Maryland CBP
monitoring programs and the historic files may be combined with no special preparation. All
Benthic Taxon, Biomass, Sediment, Water Quality and Event files can be merged by linking the
following fields:
DATE
STATION
(REP_NUM) for most files
NETMESH
Protocols in the Maryland CBP benthos monitoring program diverge significantly from
those in the Virginia CBP benthos monitoring programs and the historic data sets. The
Maryland Benthic Monitoring program has changed its criteria for selecting sampling locations
several times in the course of the program, going from fixed sites to randomly stratified sites to a
mixture of the two. The Living Resources Data Manager can not stress enough how critical it is
26 Merging and Working with Relational Data Files
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
to READ THE: DATA DOCUMENTATION FILE before attempting to use the Maryland Benthic
Monitoring data. Below is a brief outline of the differences between the Maryland and Virginia
CBP programs.
Maryland CBP Benthic Monitoring Program
1) Multiple sampling schemes: fixed stations, sites randomly selected for identified strata,
and a combination random strata and fixed site sampling. Sampling sites are not
associated with any standard CBP monitoring stations. Analysts must use a geographic
mechanism to relate stations (e.g., CBP Chesapeake Bay segmentation scheme,
centroids). A unique station naming convention was developed to account for the various
site selection processes.
2) Multiple sampling gears. Sampling gear artifacts vary in data.
3) Changing sampling frequencies. Sampling frequency varies from 7 to 10 times
annually, and occur in the spring, summer and fall.
4) Major change in biomass methodology in 1989. (See data documentation.)
5) Analyses performed on sediment samples varied by date.
6) Full water column hydro casts were made at each site.
Virginia CBP Benthic Monitoring Program
1) Single sampling scheme: fixed sampling sites, most of which corresponded with
regular CBP monitoring stations. The data, therefore, has direct locational linkages to
plankton, zooplankton and water quality data sets.
2) One sampling gear used.
3) Sampling frequency is quarterly.
4) No change in any methodologies until 1996.
5) Water quality data for bottom of water column only.
Historic Benthic Data Sets
Most of the historic benthic data sets were "targeted studies". This means they were
concentrated around areas of resource management interest such as power plants and
industrial sites. Some of the studies were meant as baseline studies to study the
environmental effect of the operation of these facilities before and after they went
operational. Other studies were begun after a power plant or industrial site was
operational and were designed to determine how much damage had been done to an area.
Merging and Working with Relational Data Files 2 7
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
These studies frequently did not measure all the parameters found in current monitoring
data sets and do not include biomass determinations.
Common user errors and pitfalls for these data include:
1) Using the Maryland CBP Monitoring data without understanding the randomized strata
sampling protocol which was adapted in 1989.
2) NODC CODES and TSN's: All species were assigned National Oceanographic Data
Center (NODC) species coded and permanent Taxon Serial Numbers (TSN) where
available. The NODC taxonomic Code is a hierarchical system of numerical codes used to
represent the scientific names of organisms. The Code links the Linnean system of
biological nomenclature to a numerical schema that facilitates modern methods of
computerized data storage and retrieval. Additionally each recognized species is given an
unique permanent taxon serial number. The TSN value does not ever change regardless of
changes in taxonomic classification over time. NODC CODES are updated regularly.
Please look at the R_DATE field in the Taxon Key file for each Data type, this date
should never be more than a year old.
3) In the CBP monitoring data, Benthic Biomass values are done on a per taxon basis.
See documentation for Maryland methodology changes.
Submerged Aquatic Vegetation
CBP Databases
Data sets and GIS coverages from the annual aerial survey are one of the Bay Program's
first attempts at supporting a distributed data set. The SAV data are collected and processed by
the Virginia Institute of Marine Sciences. The data are then made available for distribution on the
VIMS Internet server. The ONLY guidelines the CBP Data Center can provide for effective use
of this information is: READ THE DATA DOCUMENTATION FILES BEFORE ATTEMPTING TO
USE THE DATA AND THE GIS LAYERS.
Historical Data
CBP documentation for this data set has not been prepared. The data files available on
CHESEE are the original SAS data files.
Even if you choose to ignore all other recommendations and cautions made
in this section, PLEASE READ THE DATA DOCUMENTATION FILES!
28 Merging and Working with Relational Data Files
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
CBP DATA CENTER CONTACTS
Three staff at the Chesapeake Bay Program Data Center in Annapolis, Maryland, are
responsible for creating, maintaining, facilitating the use of, and analyzing biological and living
resources data and GIS coverages:
Ms. Jacqueline Johnson
Biological Monitoring Data Manager
Chesapeake Bay Program Data Center
410 Severn Ave.
Annapolis, MD 21403
Phone (local): 410-267-5729
Phone (long distance): 1-800-968-7229, ext. 729
FAX: 410-267-5777
E-mail: JJOHNSON@CHESEE.ANN.EPA.GOV
Ms. Paula Hill Jasinski
Living Resources GIS Specialist
Chesapeake Bay Program Office
410 Severn Avenue
Annapolis, Maryland 21403
Phone (local): 410-267-5835
Phone (long distance): 1-800-968-7229, ext. 835
FAX: 410-267-5777
E-mail: phill@cbpws4.ann.epa.gov
Mr. Howard Weinberg
Living Resources GIS Specialist
Chesapeake Bay Program Office
410 Severn Avenue
Annapolis, Maryland 21403
Phone (local): 410-267-5735
Phone (long distance): 1-800-968-7229, ext.5735
FAX: 410-267-5777
E-mail: hweinber@cbpwsl .ann.epa.gov
Chesapeake Bay Program, maintains a computer support desk to assist in resolving hardware and
software difficulties with Data Center equipment. You can contact the help desk at:
Phone (local): 410-267-5769
Phone (long distance): 1-800-968-7229, ext. 769
FAX: 410-267-5777
CBP Data Center Contacts 29
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
The Chesapeake Bay Program Data Center Manager is:
Mr. Lowell Bahner
Data Center Manager
Chesapeake Bay Program Data Center
410 Severn Avenue, Suite 109
Annapolis, MD 21403
Phone (long distance): 1-800-968-7229 EXT. 671
Phone (local): 410-267-5671
FAX: 410-267-5666
E-mail: LBAHNER@CHESffi.ANN.EPA.GOV
30 Data Center Contacts
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
REFERENCES
US Environmental Protection Agency. July 1988. Chesapeake Bay Living Resources
Monitoring Plan, Agreement Commitment Report. Chesapeake Bay Program, Annapolis,
Maryland, 94pp.
US Environmental Protection Agency. August 1989. Living Resources Data Management Plan,
Revision 1. Chesapeake Bay Program, Annapolis, MD, CBP/TRS 33/89.
US Environmental Protection Agency. March 1993. Chesapeake Bay Program Data
Management Plan. Chesapeake Bay Program, Annapolis, MD.
References 31
-------
-------
APPENDIX A
DATABASE STRUCTURES FOR AVAILABLE CBP DATA
September 1996
This appendix lists the field names, attributes and descriptions for
the phytoplankton, zooplankton and benthos databases which are
available through CHESffi on LRDISK:[LR.PUBLIC] and through
the Chesapeake Bay Program Internet Home Page. For complete
data documentation please see the data documentation files which
accompany the data sets at either source.
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
Table 1. Phytoplankton Count Data Files in LRDISK:[LR.PUBLIC.PHYTOPLANKTON]
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
Field
Name
AGENCY
COLTYPE
CRUISE
DATE
DEN L
GMETHOD
LAYER
LBL
MAXDEPTH
R DATE
REP NUM
REP TYPE
SER NUM
NODCCODE
SPECCODE
STATION
TDEN L
TRIE COD
TSN
Field
Type
Character
Character
Character
Character
Numeric
Character
Character
Character
Numeric
Character
Numeric
Character
Character
Character
Character
Character
Numeric
Character
Character
Width
(dec)
6
2
6
8
12
3
2
45
8 (1)
8
8
3
12
12
14
8
12
3
7
Descriptions
Data Collection Agency
Sample Collection Type
Chesapeake Bay Program Cruise Number
Sampling Date (MM/DD/YY)
Density of a Taxon (individual per Liter)
Chesapeake Bay Program Gear Method Code
Layer of Water Column in which Sample was Taken
Species Latin Name (with Size Groupings when
Taken)
Maximum Depth of Composite Sample (Meters)
Version Date of Data (MM/DD/YY)
Replicate Number
Replicate Type
Sample Serial Number
National Oceanographic Data Center Species Code
Agency Species Code
Sampling Station
Total Density (# All Individuals/ Liter)
Tributary Code
National Oceanographic Data Center Taxon Serial
Number
Table 2. Phytoplankton Event Data Files in LRDISK:[LR.PUBLIC.PHYTOPLANKTON]
1
2
3
4
5
6
7
8
g
10
11
12
13
14
15
16
Field
Name
AGENCY
COLTYPE
CRUISE
DATE
LAYER
LAT
LONG
P DEPTH
R DATE
SALZONE
SAMVOL L
SER NUM
STATION
TDEPTH
TIME
TRIE COD
Field
Type
Character
Character
Character
Character
Character
Numeric
Numeric
Numeric
Character
Character
Numeric
Character
Character
Numeric
Character
Character
Width
(dec)
6
2
6
8
2
9 (4)
9 (4)
8 (1)
8
1
8 (1)
12
8
8 (1)
8
3
Descriptions
Data Collection Agency
Collection Type
Chesapeake Bay Program Cruise Number
Sampling Date (MM/DD/YY)
Layer of Water Column in which Sample was Taken
Latitude in Decimal Degrees
Longitude in Decimal Degrees
Composite Sample Cut Off Depth (Meters)
Data Version Date (MM/DD/YY)
Salinity Zone
Total Volume of Sample (Liters)
Sample Serial Number
Sampling Station
Total Station Depth (Meters)
Sample Collection Time (HHMM)
Tributary Code
Appendix A-1 Database Structures
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
Table 3. Primary Production Data Files in LRDISK:[LR.PUBLIC.PRODUCTION]
and http//www.epa.gov/r3chespk/infobase/lr/lrscpgl .htm.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
Field
Name
AGENCY
ASMRATIO
C14 D
C14 M
CARBFIX
CHLA
COLTYPE
CRUISE
DATE
GMETHOD
INS_CODE
LAYER
MAXDEPTH
R DATE
REP NUM
REP TYPE
SER NUM
STATION
TRIB COD
Field
Type
Character
Numeric
Character
Character
Numeric
Numeric
Character
Character
Character
Character
Character
Character
Numeric
Character
Numeric
Character
Character
Character
Character
Width
(dec)
6
8 (2)
2
7
8 (2)
8 (2)
2
6
8
3
5
2
8 (1)
8
8
4
12
8
3
Descriptions
Data Collection Agency
Production Efficiency (ug-c/ug-chl)
C.I. Limits Method
Chesapeake Bay Program Analytical Method Code
Carbon Fixed (ug/l/hr)
Chlorophyll A (ug/l)
Collection Type
Chesapeake Bay Program Cruise Number
Sample date (MM/DD/YY)
Chesapeake Bay Program Gear Method
Chesapeake Bay Program Instrument Code for C14
Measurement
Layer in Water Column From Which Sample was Taken
Maximum Depth of Composite Sample (meters)
Data Version Date (MM/DD/YY)
Replicate Number
Replicate Type
Sample Serial Number
Sampling Station
Tributary Code
Table 4. Primary Production Event Data Files in LRDISK:[LR.PUBLIC.PRODUCTION]
and http//www.epa.gov/r3chespk/infobase/lr/lrscpgl .htm.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
Field
Name
AGENCY
COLTYPE
CRUISE
DATE
LAYER
LAT
LONG
PDEPTH
R DATE
SALZONE
SAMVOL L
SER NUM
STATION
TDEPTH
TIME
TRIB COD
Field
Type
Character
Character
Character
Character
Character
Numeric
Numeric
Numeric
Character
Character
Numeric
Character
Character
Numeric
Character
Character
Width
(dec)
6
2
6
8
2
9 (4)
9 (4)
8 (1)
8
1
8 (1)
12
8
8 (1)
8
3
Descriptions
Data Collection Agency
Collection Type
Chesapeake Bay Program Cruise Number
Sampling Date (MM/DD/YY)
Layer in Water Column Which Sample was Taken
Latitude in Decimal Degrees
Longitude in Decimal Degrees
Composite Sample Cut Off Depth (meters)
Data Version Date (MM/DD/YY)
Salinity Zone
Total Volume of Sample (liters)
Sample Serial Number
Sampling Station
Total Station Depth (meters)
Sampling Time (HH:MM:SS)
Tributary Code
Appendix A-2 Database Structures
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
Table 5 In Situ Fluorescence Data Files in LRDISK: [LR.PUBLIC.FLUQRESCENCE]
Field Field Width
Name Type (dec) Descriptions
1 AGENCY Character 6 Data Collection Agency
2 CHL_F Numeric 8 (2) Fluorescence Value in Micrograms Chlorophyll a per Liter
3 CHL_F_D Character 2 Chlorophyll a Detection Limit Code
4 CHL_F_M Character 7 Chlorophyll a Method Code
5 CRUISE Character 6 Chesapeake Bay Program Cruise Number
6 DATE Character 8 Sampling Date (MM/DD/YY)
7 GMETHOD Character 3 Chesapeake Bay Program Gear Method Code
8 LAT Numeric 9 (4) Latitude in Decimal Degrees
9 LONG Numeric 9 (4) Longitude in Decimal Degrees
10 P_DEPTH Numeric 8 (1) Composite Sample Cut Off Depth
11 R_DATE Character 8 Version Date of Data (MM/DD/YY)
12 SALZONE Character 1 Salinity Zone
13 SDEPTH Numeric 8(1) Sample Collection Depth (Meters)
14 SER_NUM Character 12 Sample Serial Number
15 STATION Character 8 Sampling Station
16 TDEPTH Numeric 8 (1) Total Station Depth (Meters)
17 TIME Character 8 Sample Collection Time (HH:MM:SS)
18 TRIB_COD Character 3 Tributary Code
Appendix A-3 Database Structures
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
Table 6. Microzooplankton Count Data Files in LRDISK:[LR.PUBLIC.MICROZOO-
PLANKTON]
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Field
Name
AGENCY
COLTYPE
CRUISE
DATE
DEN L
GMETHOD
LAYER
LBL
LIFE .STG
MAXDEPTH
R DATE
REP NUM
REP TYPE
SER NUM
NODCCODE
SPECCODE
STATION
TDEN L
TRIB COD
TSN
Field
type
Character
Character
Character
Character
Numeric
Character
Character
Character
Character
Numeric
Character
Numeric
Character
Character
Character
Character
Character
Numeric
Character
Character
Width
(dec)
6
2
6
8
12 (2)
3
2
45
3
8 (1)
8
8
4
12
12
14
8
12 (2)
3
7
Descriptions
Data Collection Agency
Collection Type
Chesapeake Bay Program Cruise Number
Sampling date (MM/DD/YY)
Density of a Taxon ^Individuals per liter)
Chesapeake Bay Program Gear Method Code
Layer in Water Column Which Sample was Taken
Species Latin Name with Size Grouping
Life stage, Chesapeake Bay Program Code
Maximum Depth of Composite Sample (Meters)
Version Date of Data (MM/DD/YY)
Replicate Number
Replicate Type
Sample Serial number
NODC Species code
Agency Taxon code
Sampling station
Total Density (# All individuals/liter)
Tributary Code
National Oceanographic Data Center Taxon Serial
Number
Table 7. Microzooplankton Event Data Files in LRDISK:[LR.PUBLIC.MICROZOO-
PLANKTON]
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
Field
Name
AGENCY
COLTYPE
CRUISE
DATE
LAYER
LAT
LONG
PDEPTH
R DATE
SALZONE
SAMVOL L
SER NUM
STATION
TDEPTH
TIME
TRIB COD
Field
Type
Character
Character
Character
Character
Character
Numeric
Numeric
Numeric
Character
Character
Numeric
Character
Character
Numeric
Character
Character
Width
(dec)
6
2
6
8
2
9 (4)
9 (4)
8 (1)
8
1
8 (1)
12
8
8 (1)
8
3
Descriptions
Data Collection Agency
Collection Type
Chesapeake Bay Program Cruise Number
Sampling Date (MM/DD/YY)
Layer in Water Column Which Sample was Taken
Latitude in Decimal Degrees
Longitude in Decimal Degrees
Composite Sample Cut Off Depth (meters)
Data Version date (MM/DD/YY)
Salinity Zone
Total Volume of Sample (liters)
Sample Serial Number
Sampling Station
Total Station Depth (meters)
Sample Collection Time (HHMM)
Tributary Code
Appendix A-4 Database Structures
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
Table 8 Mesozooplankton Count Data Files in LRDISK:[LR.PUBLIC.MEZOZOO-
PLANKTON]
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
. Field
Name
AGENCY
COLTYPE
CRUISE
DATE
DEN M3
GMETHOD
LAYER
LBL
LIFE STG
MAXDEPTH
R DATE
REP NUM
REP TYPE
SER NUM
NODCCODE
SPECCODE
STATION
TDEN M3
TRIB COD
TSN
Field
Type
Character
Character
Character
Character
Numeric
Character
Character
Character
Character
Numeric
Character
Numeric
Character
Character
Character
Character
Character
Numeric
Character
Character
Width
(dec)
6
2
6
8
12 (3)
3
2
45
3
8 (1)
8
8
4
12
12
14
8
12 (3)
3
7
Descriptions
Data Collection Agency
Collection Type
Chesapeake Bay Program Cruise Number
Sampling Date (MM/DD/YY)
Density of a Taxon (# individual per meter cubed)
Chesapeake Bay Program Gear Method Code
Layer in Water Column in Which Sample was Taken
Species Latin Name
Chesapeake Bay Program Life Stage Code
Maximum Depth of Composite Sample (Meters)
Data Version Date (MM/DD/YY)
Replicate Number
Replicate Type
Sample Serial Number
NODC Species Code
Agency Species Code
Sampling Station
Total Density (# all individual per meter Cubed)
Tributary Code
Taxon Serial Number
Table 9. Mesozooplankton Biomass Data Files in LRDISK:[LR.PUBLIC.MEZOZOO-
PLANKTON]
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
Field
Name
AEASH
AEDRY
AGENCY
ASH FRWT
ASH WT
AFDW
ASHWT
COLTYPE
CRUISE
DATE
DRY WT
DRYWT
GMETHOD
LAYER
MAXDEPTH
R DATE
REP NUM
REP TYPE
SER NUM
STATION
TRIB COD
Field
Type
Character
Character
Character
Numeric
Numeric
Numeric
Numeric
Character
Character
Character
Numeric
Numeric
Character
Character
Numeric
Character
Numeric
Character
Character
Character
Character
Width
(dec)
1
1
6
10(5)
9 (4)
9 (4)
9 (4)
2
6
8
10(5)
9 (4)
3
2
8 (1)
8
8
4
12
8
3
Descriptions
Actual or Estimated Ash Free Dry Weight
Actual or Estimated Dry Weight
Data Collection Agency
Ash Free Dry Weight (mg/m**3)
Total Ash Weight (mg/m**3)
Ash Free Dry Weight (g/sample)
Total Ash Weight (g/sample)
Collection Type
Chesapeake Bay Program Cruise Number
Sampling Date (MM/DD/YY)
Total Dry Weight (mg/m**3)
Total Dry Weight (g/sample)
Chesapeake Bay Program Gear Method Code
Layer in Water Column Which Sample was
Taken
Maximum Depth of Composite Sample (Meters)
Version date of data (MM/DD/YY)
Replicate Number
Replicate Type
Sample Serial number
Sampling Station
Tributary Code
Appendix A-5 Database Structures
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
Table 10. Mesozooplankton Biovolume Data Files in LRDISK:[LR.PUBLIC.MEZOZOO-
PLANKTQN]
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
Table
Field
Name
AGENCY
BEROE
BEROEVOL
COLTYPE
CRUISE
CTENO
CTENOVOL
DATE
GMETHOD
HYDRA
HYDRAVOL
JELLY
JELLYVOL
LAYER
MAXDEPTH
MNEMIOP
MNEMVOL
R DATE
REP NUM
REP TYPE
SER NUM
SET VOL
SET VOLZ
SETVOL
SETVOLZ
STATION
TRIB_COD
Field
Type
Character
Numeric
Numeric
Character
Character
Numeric
Numeric
Character
Character
Numeric
Numeric
Numeric
Numeric
Character
Numeric
Numeric
Numeric
Character
Numeric
Character
Character
Numeric
Numeric
Numeric
Numeric
Character
Character
1 1 . Mesozooplankton Event
Width
(dec)
6
8
8
2
6
8
8
8
3
8
8
8
8
2
8 (1)
8
8
8
8
4
12
8 (4)
8 (4)
8
8
8
3
Descriptions
Data Collection Agency
Number of Beroe (#/sample)
Volume of Beroe (ml/sample)
Collection Type
Chesapeake Bay Program Cruise Number
Number of Ctenophores (#/sample)
Ctenophores Volume (ml/sample)
Sampling date (MM/DD/YY)
Chesapeake Bay Program Gear Code
Number of Hydromedusae (#/sample)
Volume of Hydromedusae (ml/sample)
Jellyfish Volume (ml/sample)
Number of Jellyfish (#/sample)
Layer in Water Column in Which Sample was Taken
Maximum Depth of Composite Sample (Meters)
Number of Mnemiopsis (#/sample)
Volume of Mnemiopsis (ml/sample)
Data Version Date (MM/DD/YY)
Replicate Number
Replicate Type
Sample Serial Number
Settled Volume All Non-Gelatinous Material (ml/m**3)
Settled Volume of Zooplankton (ml/m**3)
Settled Volume All Non-Gelatinous Material (ml/sample)
Settled Volume of Zooplankton (ml/sample)
Sampling Station
Tributary Code
Data Files in LRDISK:[LR.PUBLIC.MEZOZOO-
PLANKTON]
1
2
3
4
5
6
7
8
9
10
11
12
13
•14
15
16
Field
Name
AGENCY
COLTYPE
CRUISE
DATE
LAYER
FVOL M3
LAT
LONG
P DEPTH
R DATE
SALZONE
SER NUM
STATION
TDEPTH
TIME
TRIE COD
Field
Type
Character
Character
Character
Character
Character
Numeric
Numeric
Numeric
Numeric
Character
Character
Character
Character
Numeric
Character
Character
Width
(dec)
6
2
6
8
2
8 (2)
9 (5)
9 (5)
8 (1)
8
1
12
8
8 (1)
5
3
Descriptions
Data Collection Agency
Collection Type
Chesapeake Bay Program Cruise Number
Sampling Date (MM/DD/YY)
Layer in Water Column Which Sample was Taken
Volume Filtered (M**3)
Latitude in Decimal Degrees
Longitude in Decimal Degrees
Composite Samples Cut Off Depth (meters)
Data Version Date (MM/DD/YY)
Salinity Zone
Sample Serial Number
Sampling Station
Total Station Depth (meters)
Sample Collection Time (HHMM)
Tributary Code
Appendix A-6 Database Structures
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
Table 12. Benthic Count Data Files in LRDISK:[LR.PUBLIC.BENTHIC] and
http//www. epa.gov/r3 chespk/infobase/lr/lrscpg 1. htm.
Field Field Width
Name Type (dec) Descriptions
1 AGENCY Character 8 Data Collection Agency
2 CNT_TOT Numeric 8 Total Count of All Organisms in Sample
3 CNT_TAX Numeric 8 Total Count of Given Taxa in Sample
4 COLTYPE Character 2 Collection Type
5 CONVFACT Numeric 8 (2) Conversion Factor (# Individual /Sample to individuals
/MeterSquared)
6 CRUISE Character 6 Chesapeake Bay Program Cruise Number
7 DATE Character 8 Sampling Date (MM/DD/YY)
8 GMETHOD Character 3 Chesapeake Bay Program Gear Method Code
9 LBL Character 45 Species Latin Name
10 NETMESH Numeric 8 (3) Screen Mesh Width (Millimeters)
11 NODCCODE Character 12 National Oceanographic Data Center Species Code
12 REP_NUM Numeric 8 Replicate Number
13 REP_TYPE Character 3 Replicate Type
14 R_DATE Character 8 Data Version Date (MM/DD/YY)
15 SER_NUM Character 12 Sample Serial Number
16 SPECCODE Character 14 Agency Species Code
17 STATION Character 14 Sampling Station
18 TRIB_COD Character 3 Tributary Code
19 TSN Character 7 National Oceanographic Data Center Taxon Serial
Number
Table 13. Benthic Biomass Data Files in LRDISK:[LR.PUBLIC.BENTHIC] and
http//www.epa.gov/r3chespk/infobase/lr/lrscpgl.htm.
Field Field Width
Name Type (dec) Descriptions
1 AEAFDW Character 2 Actual or Estimated Ash Free Dry Weight
2 AFDW_TAX Numeric 12(5) Taxon Ash Free Dry Weight (grams/sample)
3 AGENCY Character 6 Data Collection Agency
4 COLTYPE Character 2 Sample Collection Type
5 CONVFACT Numeric 8 (2) Conversion Factor (# Individual/Sample to #
Individuals/Meter Squared)
6 CRUISE Character 6 Chesapeake Bay Program Cruise Number
7 DATE Character 8 Sampling Date (MM/DD/YY)
8 GMETHOD Character 3 Chesapeake Bay Program Gear Method Code
9 LBL Character 45 Species Latin Name
10 NETMESH Numeric 8 (2) Screen Mesh Width (millimeter)
11 NODCCODE Character 12 National Oceanographic Data Center Species Code
12 REP_NUM Numeric 8 Replicate Number
13 REP_TYPE Character 5 Replicate Type
14 R_DATE Character 8 Data Version Date (MM/DD/YY)
15 SER_NUM Character 12 Agency Sample Serial Number
16 SPECCODE Character 14 Agency Species Code
17 STATION Character 14 Sampling Station
18 TRIB_COD Character 3 Tributary Code
19 TSN Character 7 National Oceanographic Data Center Taxon Serial
Number
Appendix A-7 Database Structures
-------
The 1996 Users Cruide to CBP Biological and Living Resources Monitoring Data
Table 14. Benthic Water Quality Data Files in LRDISK:[LR.PUBLIC.BENTfflC
and http//www. epa.gov/r3chespk/infobase/lr/lrscpgl .htm.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
Field
Name
AGENCY
COLTYPE
CONDUCT
CRUISE
DATE
DISOXY
INS CODE
ORP
PH
REP NUM
REP TYPE
R DATE
SALINITY
SDEPTH
STATION
TEMP
TRIB COD
Field
Type
Character
Character
Numeric
Character
Character
Numeric
Character
Numeric
Numeric
Numeric
Character
Character
Numeric
Numeric
Character
Numeric
Character
Width
(dec)
6
2
8
6
8
8 (2)
5
8 (4)
8 (2)
8
3
8
8 (2)
8 (1)
14
8 (2)
3
Descriptions
Data Collection Agency
Sample Collection Type
Conductivity (umHo/cm)
Chesapeake Bay Program Cruise
Sampling Date (MM/DD/YY)
Dissolved Oxygen (ppm)
Number
Chesapeake Bay Program Instrument Code
Oxidation-Reduction Potential (mV/cm)
PH
Replicate Number
Replicate Type
Data Version Date (MM/DD/YY)
Salinity (ppt)
Sample Collection Depth
Sampling Station
Water Temperature (C)
Tributary Code
Table 15. Benthic Sediment Data Files in LRDISK:[LR.PUBLIC.BENTfflC]
and http//www. epa.gov/r3chesplc/infobase/lr/lrscpgl .htm.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
Field
Name
AGENCY
CARBNATE
CARCHN
CARIGN
CARWET
COLTYPE
CRUISE
DATE
GMETHOD
KURT
MEDDIAM
MOIST
NITCHN
REP NUM
REP TYPE
R DATE
SAND
SER NUM
SILTCLAY
SILT G
SKEW
SORT
STATION
VOLORG
TRIB COD
Field
Type
Character
Numeric
Numeric
Numeric
Numeric
Character
Character
Character
Character
Numeric
Numeric
Numeric
Numeric
Numeric
Character
Character
Numeric
Character
Numeric
Numeric
Numeric
Numeric
Character
Numeric
Character
Width
(dec)
6
8 (2)
8 (2)
8 (2)
8 (2)
2
6
8
3
8 (4)
8 (4)
8 (4)
8 (2)
8
5
8
8 (2)
12
8 (2)
8 (2)
8 (4)
8 (4)
14
8 (4)
3
Descriptions
Data Collection Agency
Carbonate Content (Percent)
Carbon-CHN Analyzer (Percent)
Carbon-Ignition (Percent)
Carbox-Wet Oxidation (Percent)
Sample Collection Type
Chesapeake Bay Program Bay Cruise Number
Sampling Date (MM/DD/YY)
Chesapeake Bay Program Gear Method Code
Kurtosis (Folk Method)
Median Diameter (PHI)
Sediment Moisture (Percent)
Nitrogen-CHN Analyzer (Percent)
Replicate Number
Replicate Type
Data Version Date (MM/DD/YY)
Sand Content (Percent)
Sample Serial Number
Silt-Clay Content (Percent)
Silt (Grams)
Skewness (Folk Method)
Sorting (Folk Method)
Sampling Station
Volatile Organics Content (Percent)
Tributary Code
Appendix A-8 Database Structures
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
Table 16. Benthic Event Data Files in LRDISK:[LR.PUBLIC.BENTHIC and
http//www. epa.gov/r3 chespk/infobase/lr/lrscpg 1. htm.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Field
Name
AGENCY
COLTYPE
CRUISE
DATE
LAT
LONG
PENETR
R DATE
SITETYPE
STATION
TRIP
TDEPTH
TIDE
TIME
TRIB COD
Field
Type
Character
Character
Character
Character
Numeric
Numeric
Numeric
Character
Character
Character
Character
Numeric
Character
Character
Character
Width
(dec)
6
2
6
8
8 (4)
8 (4)
8 (1)
8
4
14
8
8 (1)
12
5
3
Descriptions
Data Collection Agency
Sample Collection Type
Chesapeake Bay Program Cruise Number
Sampling Date (MM/DD/YY)
Latitude (Decimal Degrees)
Longitude (Decimal Degrees)
Sampling Gear Penetration Depth (cm)
Data Version Date (MM/DD/YY)
Site Selection Criteria
Sampling Station
Agency Trip Number
Total Station Depth (Meters)
Tidal Stage (When Recorded)
Sample Collection Time (HHMM)
Tributary Code
Appendix A-9 Database Structures
-------
-------
APPENDIX B
BIOLOGICAL AND LIVING RESOURCES DATA DICTIONARY:
POSSIBLE FIELD NAMES
September 1996
This data dictionary is the source of terms used in defining data in
the Chesapeake Bay Program living resources and biological
database. The purpose of the data dictionary is to provide
consistency within the CBP monitoring database by making data
submittal and retrieval compatible among institutions that
participate in the Program. This dictionary will be expanded as new
parameters names are required. Institutions submitting data to the
CBP monitoring database should use these variable names
whenever possible so that names and units of measure are
consistent within the CBP monitoring database.
This document of terms for living resources parameters lists the
one- to eight-character parameter name, a brief parameter
description, and the unit of measure for each parameter currently in
the living resources data base. Bold text indicates current field
name in Chesapeake Bay Program Living Resources Data sets.
-------
GBP CODE
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
DESCRIPTION
UNITS
ABOVEMLW Meters above mean low water meter
ACTIVJVIL Activity in sample (C14) uCi/ml
AEAFDW Actual or estimated ash-free dry weight char
AEDRY Actual or estimated dry weight char
AFDW Ash-free dry weight for a sample grams/sample
AFDWNB Ash-free dry weight of non-bivalve
species for a sample grams
AFDW_TAX Ash-free dry weight for a taxon grams/sample
AFDWNB_TAX Ash-free dry weight of non-bivalve species grams
AFDWPROF Total Ash-free dry weight of profile sample grams
AGENCY Data collecting agency Table 1
AIRBLD_B Presence or absence of an air bladder 0 or 1
ANSCOOE Academy of Natural Science species code char
ASH_FRWT Ash-free dry weight for a taxon mg/m**3
ASH_WT Total sample ash-free dry weight mg/m**3
ASHNB_WT Total Ash-free dry weight of non-bivalve species mg/m**3
ASHWT Total sample ash-free dry weight grams
ASM RATIO Production Efficiency Ratio ug-C/ug-chl A
ATEMP Air Temperature deg C
ATEMP_M Method code Table 21
BEROE Number of Beroe number/sample
BEROEVOL Volume of Beroe ml/sample
BOTTYPE1 Primary bottom sediment characterization Table 26
BOTTYPE2 Primary bottom sediment characterization Table 26
C14_D Carbon-14 detection limit Table 27
C14_M - Carbon-14 analytical methods char
CARBCHN Carbon content (chn analyzer) %
CARBFIX Carbon fixation Rate ug/L/H
CARBIGN Carbon content (ignition) %
CARBNATE Carbonate content %
CARBWET Carbon content (wet oxidation) %
CHLAM Monochromatic Total chlorophyll A (uncorrected for phaeophytin) ug/l
CHLAM_A Analysis problem Table 28
CHLAM_C Spike concentration number
CHLAM_D Detection limit Table 27
CHLAM_M Method code Table 21
CHLAM_N Number of values for standard deviation number
CHLAMJD Lab analysis sign-off Initial
CHLAM_P Percent recovery %
CHLAM_S Standard deviation of lab replicates number
CHLAM_SK Background and spike value number
CHLA Monochromatic active chlorophyll A
(corrected for phaeophytin and turbidity) ug/l
CHLA_A Analysis problem Table 28
CHLA_C Spike concentration number
CHLA_D Detection limit Table 27
CHLA_M Method code Table 21
CHLA_N Number of values for standard deviation number
CHLA_O Lab analysis sign-off Initial
CHLA_P Percent recovery %
CHLA_S Standard deviation of lab replicates number
CHI_A_SK Background and spike value number
CHL_A Trichromatic chlorophyll A (corrected for turbidity) ug/l
CHL_A_A Analysis problem Table 28
CHL_A_C Spike concentration number
Appendix B-l Possible Field Names
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
CBP CODE DESCRIPTION UNITS
CHL_A_D Detection limit Table 27
CHL_A_M Method code Table 21
CHL_A_N Number of values for standard deviation number
CHL_A_O Lab analysis sign-off Initial
CHL_A_P Percent recovery %
CHL_A_S Standard deviation of lab replicates number
CHL_A_SK Background and spike value number
CHL_B Trichromatic chlorophyll B (corrected for turbidity) ug/l
CHL_B_A Analysis problem Table 28
CHL_B_C Spike concentration number
CHL_B_D Detection limit Table 27
CHL_B_M Method code Table 21
CHL_B_N Number of values for standard deviation number
CHL_B_O Lab analysis sign-off Initial
CHL_B_P Percent recovery %
CHL_B_S Standard deviation of lab replicates number
CHL_B_SK Background and spike value number
CHL_C Trichromatic chlorophyll C (corrected for turbidity) ug/l
CHL_C_A Analysis problem Table 28
CHL_C_C Spike concentration number
CHL_C_D Detection limit Table 27
CHL_C_M Method code Table 21
CHL_C_N Number of values for standard deviation number
CHL_C_O Lab analysis sign-off Initial
CHL_C_P Percent recovery %
CHL_C_S - Standard deviation .of lab replicates number
CHL_C_SK Background and spike value number
CHL_F Fluorometric chlorophyll A ug/l
CHL_F_A Analysis problem Table 28
CHL_F_C Spike concentration number
CHL_F_D Detection limit Table 27
CHL_F_M Method code Table 21
CHL_F_N Number of values for standard deviation number
CHL_F_O Lab analysis sign-off Initial
CHL_F_P Percent recovery %
CHL_F_S Standard deviation of lab replicates number
CHL_F_SK Background and spike value number
CKTL_VOL Cocktail volume - C14 production ml
CLAY Percent clay %
CLAYJ3 Clay Weight g/sample
CLAYJvlG Clay weight mg/sample
CLOUD Cloud cover Table 6
CNIDA Number of Cnidarians number/sample
CNIDAVOL Volume of Cnidarians ml/sample
CNT #/sample number
CNT_AL #/sample of species alive number
CNT_DE #/sample of species dead number
CNT_FE ft/sample of females number
CNTJM #/sample of immature number
CNT_L Raw count/sample of a given length number
CNT_LM2 Normalized count/m**2 of a given length number
CNT_MA ft/sample of males number
CNT_PROF #/profile sample number
CNT_SUB #/subsample number
CNT_TAX ^organisms of a species/sample number
Appendix B-2 Possible Field Names
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
CBP CODE DESCRIPTION UNITS
CNT_TOT Total number organisms/sample number
CNT_VOL Volume of particular species (esp Jellyfish, Ctenophore) liters
CNTPROSP # species in a profile sample number
COLTYPE Integrated/discrete collection Table 14
COND_M Specific conductivity method code Table 21
CONDUCT Specific conductivity umhos/cm
CONVFACT Converts #/sample to normalized count number
CRUISE Chesapeake Bay Program Cruise identifier Table 3
CS_DEPTH Depth of core slice cm
CSDEPTHx Depth of core slice x cm
CTENO Number of Ctenophores number/sample
CTENOVOL Volume of Ctenophores ml/sample
DATE Date of sample collection MM/DD/YY
DEN_100I #/100L number
DENJHM3 #/hundred m**3 number
DEN_L #/liter number
DEN_M2 #/m**2 number
DEN_M3 #/m**3 number
DEN_ML #/milliliter number
DISOFFS Distance offshore meters
DISOXY Dissolved oxygen mg/l
DISOXY_M Dissolved oxygen method code Table 22
DO_DK Dark bottle dissolved oxygen mg/l
DO_GROPR Gross productivity mgC/l/hr
DO_LI Light bottle dissolved oxygen mg/l
DO_NETPR - LightVDark Bottle Net productivity mgC/l/hr
DO_PRO_D 02 rate of change/day - production number
DO_PRO_H 02 rate of change/hour - production number
DO_RES_D 02 rate of change/day - respiration number
DO_RES_H 02 rate of change/hour - respiration number
DOC_ID Documentation identification number
DODEL_DK Final DO - Init DO (dark) mg/l
DODELJ.T Final DO - Init DO (light) mg/l
DRY_WT Dry we»ght mg/m**3
DRYWT Dry weight grams
DVOL_L Dilution volume liters
EUDEPTH Euphotic zone (depth of 1 % light) meters
FOLKISTD Inclusive graphic standard deviation (Folk Method) number
FOLKMEAN Mean diameter (Folk Method) number
FVOL_L Filtered volume liters
FVOL_M3 Filtered volume m**3
GMETHOD Sampling gear Table 16
GONAD_G Gonad weight of individual grams
GONADJ Mean population gonadal index for bivalves (Table XX) number
HYDRA Number of Hydra medusae number/sample
HYDRA VOL Volume of Hydra medusae ml/sample
INS_CODE Instrument code Table 22
JELLY Number for jellyfish number/sample
JELLYVOL Volume of jellyfish ml/sample
KURT Kurtosis (Folk Method) number
LAT Latitude DEC DEG
LAYER Water column description Table 15
LBL Species Latin name char
LEN_CM Length of individual cm
LEN_MM Length of individual mm
Appendix B-3 Possible Field Names
-------
CBP CODE
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
DESCRIPTION
UNITS
LIFE_STG Life stages of individual Table 18
LIGHT_E Light expressed as microeinsteins uE/m2/sc
LIGHT_L LANGLEYS as radiant energy (light) g/cl/cm2
LIGHT_P Light expressed as photons number
LIGHT_Q Light expressed as quanta number
LIGHT_T Light transmitted %
LONG Longitude DEC DEC
MAXDEPTH Maximum sample depth meters
MEDDIAM Median diameter phi
MINDEPTH Minimum sample depth meters
MNEMIOP Number of Mnemiopsis number/sample
MNEMVOL Volume of Mnemiopsis ml/sample
MOIST Moisture of sediment %
MOMCKURT Kurtosis (Method of Moments - McBride in Carver 71) number
MOMCSKEW Skewness (Method of Moments - McBride in Carver 71) number
MOMEANM Mean diameter (Method of Moments) number
MOMTKURT Kurtosis (Method of Moments - Math Tables Handbook number
MOMTSKEW Skewness (Method of Moments - Math Tables Handbook) number
MOSTD_2 Standard deviation (Method of Moments) number
NETMESH Screen mesh width mm
NITCHN Nrtrogen-CHN analyzer (Percent) percent
NODCCODE NOAA-NODC species code Table 17
ODUCODE Old Dominion University species code char
ORP Redox potential mv/cm
P_DEPTH Composite sample cut-off depth meters
PENETR - Gear penetration depth cm
PH Sample pH number
PHEA Monochromatic Phaeophytin ug/liter
PHEA_A Analysis problem Table 28
PHEA_D Detection limit Table 27
PHEA_M Method code Table 21
PHEA_N Number of values for standard deviation number
PHEA_O Lab analysis sign-off Initial
PHEA_P Percent recovery %
PHEA_S Standard deviation of lab replicates number
PRECIP Precipitation Table 7
QUARTDEV Quartile deviation number
R_DATE Version date of data MM/DD/YY
REP_NUM Replicate number number
REP_TYPE Replicate type code Table 24
SALINJ Interstitial salinity ppt
SALIN_M Salinity method code Table 21
SALINITY Salinity ppt
SALZONE Salinity zone Table 13
SAMVOL_L Sample volume liters
SAND Percent sand %
SAND_G Sand weight grams
SAND_MG Sand weight mg/sample
SAV_B Presence or absence of submerged aquatic vegetation 0 or 1
SAV_P Maximum percent of area covered by aquatic vegetation %
SAVPRES Translated or natural submerged aquatic vegetation T/N
SC200 #/sample - 202 um size class number
SC2000 #/sample - 2000 um size class number
SC300 #/sample - 300 um size class number
SC600 #/sample - 600 um size class number
Appendix B-4 Possible Field Names
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
CBP CODE DESCRIPTION UNITS
SC850 #/sample - 850 urn size class number
SDEPTH Sample depth from water surface meters
SECCHI Secchi depth meters
SEGMENT Chesapeake Bay Program segment designation Table 4
SER_NUM Data collection agency sample serial number num/char
SET_VOL Settled volume (ml per cubic meter) ml/m**3
SET_VOLZ Settled volume of zooplankton (ml per cubic meter) ml/m**3
SETVOL Settled volume (ml per sample) ml/sample
SETVOLZ Settled volume of zooplankton (ml per sample) ml/sample
SEX Sex of individuals M/F/U
SIG_T Specific gravity of water number
SILT Percent silt %
SILT_G grams/sample
SILT_G Silt Weight grams
SILT_MG Silt weight mg/sample
SILTCLAY Percent silt to clay %
SITE Collecting agency site code char
SITETYPE Site type Table 12
SITENO Collecting agency site number char
SKEW Skewness (Folk Method) number
SORT Sorting (Folk Method) number
SPEC_ACT Specific activity of label(DPM) uCi/ml
SPECCODE Agency Species Code Table 29
SPIKETIM Spike time HHMM
SSVOL_ML Subsample volume ml
STATION - Sampling station identifier Table 2
STEMP Sediment temperature DEC C
TDEN_L Total number per liter number
TDENJVI3 Total density per meter cubed number
TDEPTH Total water depth at station (bottom depth) meters
TEMP Water temperature DEG C
TEMP_M Water temperature measurement method Table 21
TIDE Tidal stage Table 8
TIM_CNT Time counted - C14 production DEC min
TIMDURJH Duration of incubation period HHMM
TIME Sampling time 2400
TIME_BEG Beginning time HHMM
TIME_END Ending time HHMM
TOW_DUR Towing duration HHMMSS
TOW_LEN Length of tow meters
TOW_SPD Speed of the tow m/sec
TREATMT Treatment code - phytoplankton productivity Table 21
TRIB_COD Tributary or mainstem code Table 5
TRIP Agency sampling trip number num
TSN National Oceanographic Data Center Taxon Serial Number Char
TURB_JTU Turbidity in Jackson units JTU
TURB_NTU Turbidity in Nephelometric units NTU
TVS_P Total volatile solids (w/w) %
UNITS Reported units Table 22
VERCODE Maryland Power Plant Study (Versar) species codes char
VOLORG Volatile organics %
WAVHGT Wave height Table 9
WINDIR Wind direction Table 10
WINDSPD Wind speed Table 11
WT_ASH Ash weight mg/m**3
Appendix B-5 Possible Field Names
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
CBP CODE DESCRIPTION UNITS
WT_AWT Wet ash weight mg/m**3
WT_G Weight in grams grams
WT_MG Weight in milligrams mg
WT_MNG Mean weight in grams grams
WTASH Ash weight grams
WTAWT Wet ash weight grams
WTSED_G Weight of sediment/sample grams
Appendix B-6 Possible Field Names
-------
APPENDIX C
LIVING RESOURCES DATA DICTIONARY:
EXPLANATION OF PARAMETER CODES
September 1996
A variety of numeric and alphanumeric codes are
used by the Chesapeake Bay Program to identify
specific sampling gears, analytical methods,
collecting agencies, segment, cruise number, etc.
These codes are documented in this appendix.
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
Table 1. Data Collecting Agency (AGENCY). An eight-character code indicating who has
submitted the data. Current values for this field are given.
ANS Benedict Estuarine Research Center, Academy of Natural Sciences
DCRA District of Columbia Department of Consumer and Regulatory Affairs
ICPRB Interstate Commission on the Potomac River Basin
GMU George Mason University
MD/DNR Maryland, Department of Natural Resources
MD/MDE Maryland, Maryland Department of the Environment
ODU Old Dominion University
SRBC Susquehanna River Basin Commission
PA/DER Pennsylvania Department of Environmental Resources
UM/HPEL University of Maryland, Horn Point Environmental Laboratory
UM/CBL University of Maryland, Chesapeake Biological Laboratory
US/NOAA U.S. National Oceanic and Atmospheric Administration
VA/WCB Virginia Water Control Board
VERSAR Versar Incorporated
VIMS Virginia Institute of Marine Sciences
Table 2. Sampling Station Identifier (STATION). A list of the current, fixed monitoring stations
for Chesapeake Bay Program biological monitoring programs is given here. The list can be
obtained through CHESSEE by selecting 'Dictionary.' (CHESSEE is the menu-driven
information retrieval software program currently on the CHESIE computer which is designed to
give users data documentation files about selected water quality and toxic pollutant monitoring
data available from the Data Center.) The Sampling Station file is made up of the 1 to 8 character
station identifications and each station's associated latitude/longitude, basin, and station location
description. Zero's in the latitude and/or longitude columns indicates these values are not
available.
NOTE: the benthic monitoring program in Maryland and Virginia use randomly selected sampling
sites at times. These sites are given unique station identifiers in the databases and are not included
in the following list.
STATION
CB1.1
CB2.1
CB2.2
CB3.1
CB3.2
CB3 . 3W
CB3.3C
CB3 . 3E
CB4 . OC
CB4 . OW
CB4 . OE
CB4 . 1W
CB4 . 1C
CB4 . IE
CB4 . 2W
CB4.2C
CB4.2E
CB4 . 3W
CB4.3C
LATITUDE
39.5467
39.44
39.3483
39.25
39.165
39.0033
38.9958
39.0033
38.9269
38.9272
38.9269
38.8142
38.8267
38.8167
38.6433
38.6467
38.645
38.5575
38.5567
LONGITUDE TRIE COD RIVER
76 .0817
76.025
76.175
76.24
76.3083
76.3883
76.36
76.3467
76.3947
76.4331
76.3872
76.465
76.4
76.3717
76.5017
76.4183
76.4017
76.4933
76.4367
BAY
BAY
BAY
BAY
BAY
BAY
BAY
BAY
BAY
BAY
BAY
BAY
BAY
BAY
BAY
BAY
BAY
BAY
BAY
Chesapeake Bay
Chesapeake Bay
Chesapeake Bay
Chesapeake Bay
Chesapeake Bay
Chesapeake Bay
Chesapeake Bay
Chesapeake Bay
Chesapeake Bay
Chesapeake Bay
Chesapeake Bay
Chesapeake Bay
Chesapeake Bay
Chesapeake Bay
Chesapeake Bay
Chesapeake Bay
Chesapeake Bay
Chesapeake Bay
Chesapeake Bay
Appendix C-l Explanation of Parameter Codes
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
CB4.3E
CB4.4
CB5.1
CBS. 2
CBS. 3
LE2.3
CBS. 4
CB5.4W
CBS. 5
EE3.4
EE3.5
LE3.6
LE3.7
CB6.1
CB6.2
CB6.3
CB7 . IN
CB7.1
CB7.1S
CB7.2
CB7 . 2E
WE4.1
WE4.2
WE4.3
WE4.4
LE5.5
CB8.1
CBS . IE
CB7.4
CB7 . 4N
CB7.3
CB7.3E
CB6.4
ELI1
ELI2
ELI 3
WBE1
LAF1
SBE1
SBE2
SBE3
SBE4
SBE5
EBE1
EBE2
ANA01
ANA02
ANA03
ANA04
ANA05
ANA06
ANA07
ANA08
ANA09
ANA10
ANA11
ANA12
ANA13
ANA14
ANA15
ANA16
ANA17
ANA18
ANA19
ANA20
38.5567
38.4133
38.3183
38.1367
37.9117
38.0217
37.8
37.8133
37.6917
37..9083
37.7925
37.5967
37.5306
37.5883
37.4867
37.4114
37.775
37.6833
37.5811
37.4114
37.4114
37.3117
37.2417
37.1767
37.11
36.9967
36.9875
36.945
36.9933
37.0581
37.1167
-37.2286
37.2364
36.95
36.8822
36.8589
36.8431
36.9056
36.8325
36.8125
36.7903
36.7767
36.7697
36.8406
36.8394
38.9181
38.9156
38.9147
38.9128
38.9092
38.9056
38.9019
38.8986
38.895
38.8908
38.8839
38.8839
38.8772
38.8772
38.8758
38.8742
38.875
38.8697
38.8703
38.8714
76.3917
76.3433
76.2933
76.2292
76.1683
76.35
76.175
76.295
76.19
75.7917
75.8436
76.285
76.3069
76.1625
76.1567
76.16
75.975
75.99
76.0583
76.08
76.025
76.3467
76.3867
76.3733
76.2933
76.3033
76.1681
76.025
76.0106
75.9731
76.1256
76.0542
76.2083
76.3458
76.3392
76.3256
76.3597
76.3061
76.295
76.3061
76.3042
76.3
76.2964
76.2894
76.2656
76.9419
76.9456
76.9503
76.9533
76.9561
76.9583
76.9606
76.9625
76.9625
76.9633
76.9692
76.9692
76.9722
76.9758
76.9806
76.985
76.9886
76.9428
76.9469
76.0014
BAY
BAY
BAY
BAY
BAY
BAY
BAY
BAY
BAY
BAY
BAY
BAY
BAY
BAY
BAY
BAY
BAY
BAY
BAY
BAY
BAY
BAY
BAY
BAY
BAY
BAY
BAY
BAY
BAY
BAY
BAY
BAY
BAY
ELZ
ELZ
ELZ
ELZ
ELZ
ELZ
ELZ
ELZ
ELZ
ELZ
ELZ
ELZ
ANA
ANA
ANA
ANA
ANA
ANA
ANA
ANA
ANA
ANA
ANA
ANA
ANA
ANA
ANA
ANA
ANA
ANA
ANA
ANA
Chesapeake Bay
Chesapeake Bay
Chesapeake Bay
Chesapeake Bay
Chesapeake Bay
Chesapeake Bay
Chesapeake Bay
Chesapeake Bay
Chesapeake Bay
Chesapeake Bay
Chesapeake Bay
Chesapeake Bay
Chesapeake Bay
Chesapeake Bay
Chesapeake Bay
Chesapeake Bay
Chesapeake Bay
Chesapeake Bay
Chesapeake Bay
Chesapeake Bay
Chesapeake Bay
Chesapeake Bay
Chesapeake Bay
Chesapeake Bay
Chesapeake Bay
Chesapeake Bay
Chesapeake Bay
Chesapeake Bay
Chesapeake Bay
Chesapeake Bay
Chesapeake Bay
Chesapeake Bay
Chesapeake Bay
Elizabeth
• Elizabeth
Elizabeth
Elizabeth
Elizabeth
Elizabeth
Elizabeth
Elizabeth
Elizabeth
Elizabeth
Elizabeth
Elizabeth
Anacostia
Anacostia
Anacostia
Anacostia
Anacostia
Anacostia
Anacostia
Anacostia
Anacostia
Anacostia
Anacostia
Anacostia
Anacostia
Anacostia
Anacostia
Anacostia
Anacostia
Anacostia
Anacostia
Anacostia
Appendix C-2 Explanation of Parameter Codes
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
ANA21
ANA22
ANA23
ANA24
ANA25
ANA26
ANA27
ANA29
ANA30
KNG01
KNG02
PEC01
PEC02
PEC03
PEC04
PEC05
PECO 6
PEC07
PEC08
PEC09
PEC10
PMS01
PMS02
PMS03
PMS04
PMS05
PMS06
PMS07
PMS08
PMS09
PMS10
PMS11
PMS12
PMS13
PMS14
PMS15
PMS16
PMS17
PMS18
PMS19
PMS20
PMS21
PMS22
PMS23
PMS24
PMS25
PMS26
PMS27
PMS28
PMS29
PMS30
PMS31
PMS32
PMS33
PMS34
PMS35
PMS36
PMS37
PMS38
PMS39
PMS40
PMS41
PMS42
PMS43
PMS44
38.8528
38.8683
38.8631
38.8611
38.8589
38.8561
38.8528
38.8506
38.9428
38.8903
38.8975
38.8122
38.8083
38.8053
38.8042
38.8003
38.7947
38.7908
38.7869
38.7833
38.7794
38.9178
38.9144
38.9111
38.9086
38.7564
38.905
38.9036
38.9033
38.9028
38.9022
-38.9014
38.9003
38.8983
38.895
38.8917
38.8881
38.8847
38.8811
38.8789
38.8764
38.8742
38.8719
38.8697
38.8664
38.8631
38.86
38.8569
38.8536
38.8503
38.8467
38.8428
38.8392
38.8356
38.8322
38.8286
38.8253
38.8217
38.8178
38.8139
38.8103
38.8064
38.8042
38.8003
38.7947
77.005
77.0072
77.0094
77.0131
77.0172
77.0194
77.0208
77.0225
76.9675
76.9444
76.9661
77.0278
77.0244
77.025
77.0244
77.0244
77.025
77.0264
77.0225
77.0228
77.0283
77.105
77.1028
77.1003
77.0964
77.0925
77.0883
77.0842
77.0797
77.0753
77.0697
77.0658
77.0617
77.0581
77.0567
77.0556
77.0544
77.0533
77.0522
77.0489
77.0383
77.0425
77.0383
77.0344
77.0192
77.0294
77.0278
77.0264
77.0244
77.0225
77.0233
77.0239
77.0253
77.0267
77.0283
77.0308
77.0308
~7.0314
77.0328
77.0342
77.035
77.0361
77.0364
77.0369
77.0372
ANA
ANA
ANA
ANA
ANA
ANA
ANA
ANA
ANA
RC
RC
POT
POT
POT
POT
POT
POT
POT
POT
POT
POT
POT
POT
POT
POT
POT
POT
POT
POT
POT
POT
POT
POT
POT
POT
POT
POT
POT
POT
POT
POT
POT
POT
POT
POT
POT
POT
POT
POT
POT
POT
POT
POT
POT
POT
POT
POT
POT
POT
POT
POT
POT
POT
POT
POT
Anacostia
Anacostia
Anacostia
Anacostia
Anacostia
Anacostia
Anacostia
Anacostia
Anacostia
Rock Creek
Rock Creek
Potomac
Potomac
Potomac
Potomac
Potomac
Potomac
Potomac
Potomac
Potomac
Potomac
Potomac
Potomac
Potomac
Potomac
Potomac
Potomac
Potomac
Potomac
Potomac
Potomac
Potomac
Potomac
Potomac
Potomac
Potomac
Potomac
Potomac
Potomac
Potomac
Potomac
Potomac
Potomac
Potomac
Potomac
Potomac
Potomac
Potomac
Potomac
Potomac
Potomac
Potomac
Potomac
Potomac
Potomac
Potomac
Potomac
Potomac
Potomac
Potomac
Potomac
Potomac
Potomac
Potomac
Potomac
Appendix C-3 Explanation of Parameter Codes
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
PMS45
PMS46
PMS47
PMS48
PMS49
PMS50
PMS51
PTB01
PWC01
PWC02
PWC03
PWC04
PWC05
PWC06
PWC07
PWC08
RCR01
RCR04
RCR07
RCR09
TBK01
TC001
TCO06
TDA01
TDU01
TFB01
TFC01
TFD01
TFS01
THR01
THRO 4
THRN4
THRP1
THRP2
TNA01
TOR01
TPB01
TTX27
TUT01
TWB01
TWB02
TWB03
TWB04
TWB05
TWB06
MET1.1
MET2.1
MET2.3
MET2.2
MET3.1
MET4.1
MET4.2
MEE1.1
MWT1.1
MWT2.1
MWT3.1
MWT4.1
MWT5.1
MWT6.1
MWT7.1
MWT8.1
MWT8.2
MWT8.3
PXT0402
XED9490
38
38
38
38
38
38
38
38
38
38
38
38
38
38
38
38
38
38
38
38
38
38
38
38
38
38
38
38
38
38
38
-38
38
38
38
38
38
38
38
38
38
38
38
38
38
39
39
39
39
39
39
38
38
39
39
39
39
39
39
39
38
38
38
38
38
.7908
.7869
.7833
.7794
.7792
.7758
.77
.8869
.8811
.8797
.8769
.8736
.8706
.8669
.8631
.86
.9864
.9603
.9339
.9283
.9178
.8944
.9275
.9286
.8833
.9275
.8867
.87
.8667
.9083
.9156
.9225
.9186
.9156
.91
.8317
.8783
.8683
.9183
.9033
.8978
.8956
.8936
.8908
.8903
.575
.525
.508
.467
.367
.258
.992
.883
.433
.383
.3
.292
.208
.075
.017
.933
.883
.85
.71
.658
77
77
77
77
77
77
77
77
77
77
77
77
77
77
77
77
77
77
77
77
77
77
77
77
76
77
76
76
76
76
76
76
76
76
76
77
76
76
76
76
76
76
76
76
76
75
75
75
75
75
75
76
76
76
76
76
76
76
76
76
76
76
76
76
76
.0375
.0375
.035
.0358
.0344
.0344
.0317
.0397
.0314
.0281
.0247
.0225
.0203
.0203
.0217
.0197
.0639
.0442
.0492
.0497
.1208
.075
.1017
.1222
.9767
.0833
.9375
.9583
.975
.9625
.9633
.9683
.9664
.9631
.9417
.0411
.9722
.9694
.9533
.9458
.9489
.9389
.9292
.9178
.9183
.958
.817
.9
.875
.883
.925
.217
.25
.242
.342
.4
.45
.525
.475
.508
.517
.533
.533
.702
.685
POT
POT
POT
POT
POT
POT
POT
POT
POT
POT
POT
POT
POT
POT
POT
POT
RC
RC
RC
RC
RC
RC
RC
RC
RC
RC
RC
RC
RC
RC
RC
RC
RC
RC
RC
RC
RC
RC
RC
RC
RC
RC
RC
RC
RC
CHS
CHS
PAT
PAX
PAX
Potomac
Potomac
Potomac
Potomac
Potomac
Potomac
Potomac
Potomac Tidal Basin
Potomac Washington
Potomac Washington
Potomac Washington
Potomac Washington
Potomac Washington
Potomac Washington
Potomac Washington
Potomac Washington
Rock Creek
Rock Creek
Rock Creek
Rock Creek
Rock Creek
Rock Creek
Rock Creek
Rock Creek
Rock Creek
Rock Creek
Rock Creek
Rock Creek
Rock Creek
Rock Creek
Rock Creek
Rock Creek
Rock Creek
Rock Creek
Rock Creek
Rock Creek
Rock Creek
Rock Creek
Rock Creek
Rock Creek
Rock Creek
Rock Creek
Rock Creek
Rock Creek
Rock Creek
Northeast
C & D Canal
Elk
Bohemia
Sassafras
Chester
Chester
Eastern Chesapeake
Bush
Gunpowder
Middle
Back
Patapsco
Magothy
Severn
South
Rhode
West
Patuxent
Patuxent
Channel
Channel
Channel
Channel
Channel
Channel
Channel
Channel
Bay
Appendix C-4 Explanation of Parameter Codes
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
XED4892
PXT0603
WXT0045
PXT0456
XDE9401
XDE5339
XDE2792
XDP0407
XCP8747
PXT0904
MET5.1
MEE2.1
MET5.2
MEE2.2
XFB2470
XFB1433
XEA6596
MAT0016
XEA1840
MET6 .1
MET6.2
MAT0078
XDA4238
XDB3321
XDC1706
XDA1177
MLE2.2
XCF9575
XCG8613
MEE3.0
MEE3.1
MEE3.2
MEE3.3
TF3 . 1A
TF3 . IB
TF3.2
TF3.3
RET3 . 1
RETS. 2
LE3.1
LE3.3
LE3.2
LE3.4
RET4 . 2
RET4.3
LE4.1
LE4.2
LE4.3
TF5.2
TF5 . 2A
TF5.3
RETS . 1A
TF5.5
TF5.4
TF5 . 5A
TF5.6
LE5.1
RETS. 2
LE5.2
LE5.3
LE5.4
LE5.6
TF4 .4
TF4.2
RET4 . 1
38.582
38.856
38.814
38.773
38.491
38.425
38.379
38.341
38.312
38.81
38.807
38.65
38.58
38.533
38.706
38.691
38.608
38.565
38.53
38.533
38.333
38.588
38.403
38.388
38.363
38.352
38.167
38.325
38.311
38.283
38.2
-37.967
37.942
38.255
38.246
38.175
38.019
37.92
37.808
37.761
37.693
37.67
37.633
37.572
37.507
37.418
37.292
37.235
37.531
37.45
37.403
37.312
' 37.313
37.311
37.3
37.275
37.207
37.21
37.058
36.99
36.955
36.903
37.723
37.58
37.525
76.681
76.693
76.751
76 .71
76.664
76.602
76.511
76.488
76.422
76.713
75.912
76.275
76.06
76.308
77.049
77.111
77.174
77.194
77.266
75.717
75.883
77.119
77.269
77.131
76.991
77.205
76.583
76.376
vg.312
76.017
75.975
75.933
75.767
77.412
77.234
77.189
76.908
76.822
76.713
76.621
76.473
76.554
76.463
76.793
76.788
76.693
76.558
76.485
77.434
77.42
77.392
76.873
77.233
77.297
77.125
76.989
76.652
76.793
76.583
76.46
76.392
76.333
77.024
77.022
76.87
PAX
PAX
PAX
PAX
PAX
PAX
PAX
PAX
PAX
PAX
CHP
CHP
CHP
CHP
POT
POT
POT
POT
POT
POT
POT
POT
POT
POT
POT
PAX
PAX
TAN
TAN
RAP
RAP
RAP
RAP
RAP
RAP
RAP
RAP
RAP
YRK
YRK
YRK
YRK
JAM
JAM
JAM
JAM
JAM
JAM
JAM
JAM
JAM
JAM
JAM
JAM
JAM
YRK
YRK
Patuxent
Patuxent
Patuxent
Patuxent
Patuxent
Patuxent
Patuxent
Patuxent
Patuxent
Patuxent
Choptank
. Lower Choptank
Choptank
Choptank
Potomac
Potomac
Potomac
Potomac
Potomac
Nanticoke
Nanticoke
Lower Potomac
Lower Potomac
Lower Potomac
Lower Potomac
Lower Potomac
Lower Potomac
Lower-Mid Chesapeake Bay
Lower -Mid Chesapeake Bay
Fishing Bay
Upper Tangier Sound
Lower Tangier Sound
Pocomoke Sound
Rappahannock
Rappahannock
Rappahannock
Rappahannock
Rappahannock
Rappahannock
Rapp ahanno c k
Corrotoman
Rappahannock
Rappahannock
Mattaponi
York
York
York
York
James
James
James
Chi ckahominy
James
James
James
James
James
James
James
James
James
James
Mattaponi
Pumunkey
Pumunkey
Appendix C-5 Explanation of Parameter Codes
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
SUSQ4 . 8
SUSQ44.5
SUSQ289.
SUSQ340.
SUSQ365.
CHEM12 . 0
TIOG10.8
SEEL10.3
CAYT1.7
SNAK2.3
DEER44.2
EBAV1 . 5
CNWG4 . 4
OCT06 . 6
APAL6.9
BNTY0.9
CPBK2 . 0
CACS1.6
CHOC9 . 1
COWN2 . 2
HLDN3 . 5
LSNK7 . 6
NFCR7 . 6
SODT2 . 8
TRUP4 . 5
TROW1 . 8
WAPP2 . 6
BRHRO . 1
SACK2 . 6
PARK0.7
HESSO.l
LNGA2.5
SBCC20.4
BBCC4 . 1
FBDC4 . 1
SCTT3 . 0
N0201
N0202
N0203
N0204
N0206
N0207
N0210
N0211
N0212
N0213
N0214
N0217
N0220
N0223
N0224
N0228
N0229
N0231
N0240
N0243
N0245
N0249
N0252
N0301
N0302
N0303
N0305
N0306
N0308
39.571
40,054
41.985
41.966
42.074
42.002
42.029
42.001
42
41.994
39.717
39.725
39.726
39.707
41.995
42.009
41.997
42
41.991
41.989
42.004
41.997
41.997
41.989
41.99
42
41.994
41.996
41.995
41.998
41.978
-39.725
39.726
39.717
39.712
39.723
40.029
40.258
40.854
39.893
40.055
40.011
40.081
40.199
40.224
40.26
40.478
40.609
40.596
40.215
40.477
40.775
40.866
39.961
40.271
40.381
40.529
40.335
40.431
40.958
41.189
41.35
41.765
41.963
40.995
76.092
76.531
76.501
75.743
75.637
76.468
77.132
76.903
76.523
75.795
76.586
76.596
76.186
76.116
76.133
76.73
77.338
75.579
76.001
77.147
77.393
75.898
77.623
76.774
77.492
75.732
76.344
76.344
76.397
76.46
77.25
76.982
76.981
76.492
76.443
76.337
76.517
76.887
76.806
76.358
76.526
76.711
76.718
76.717
76.861
77.103
77.129
78.136
77.573
78.265
78.178
76.87
77.049
76.366
76.915
77.082
77.392
77.86
78.363
76.619
76.087
75.801
76.441
75.743
76.474
SUS
SOS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
Susquehanna
Susquehanna
Susquehanna
Sus quehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Sus quehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Sus quehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Sus quehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Appendix C-6 Explanation of Parameter Codes
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
N0309
N0310
N0313
N0317
N0318
N0320
N0324
N0332
N0333
N0334
N0335
N0337
N0401
N0402
N0406
N0407
N0408
N0409
N0410
N0412
N0413
N0415
N0418
N0419
N0420
N0422
N0423
N0427
N0428
N0429
N0430
N0433
N0434
N0439
N0501
N0503
N0505
N0506
MET7.1
MET8.1
MET9.1
ANPC
ANPS
MLE2.3
SOL
TIL
TOLCHES
XDA3000C
XDA3000E
XDA3000
XEA4000C
XEA4000E
XEA5000C
XEA5000E
XEA6000
XEA9075
LE3.4B
LE4 . 3B
RETS . 2A
41.055
41.071
41.359
41.558
41.708
41.996
41.958
41.978
41.79
41.697
41.831
41.416
40.967
41.229
40.897
41.217
41.325
41.418
41.283
41.126
40.975
40.89
41.261
41.32
41.413
40.986
41.075
41.075
41.456
41.309
41.738
41.075
41.319
41.334
39.507
39.733
39.723
39.927
38.267
38.142
38.058
38.9717
39.0067
38.0217
38.3217
38.72
39.2133
38.4388
38.4312
38.4312
38.5598
38.5632
38.594
38.5878
38.6772
38.672
37.6242
37.2294
37.2078
76.232
76.134
75.745
75.895
76.485
77.142
77.116
76.549
76.462
76.231
76.35
76.091
76.879
77.019
78.677
76.788
76.912
77.033
77.323
77.433
77.743
77.794
77.903
78.081
78.197
78.406
77.592
76.873
76.69
77.363
77.431
77.478
77.874
78.136
77.791
77.229
78.06
78.66
75.792
75.817
75.808
76.4633
76.4033
76.3483
76.45
76.3333
76.2467
77.2752
77.27
77.315
77.2385
77.193
77.2032
77.195
77.1657
77.1322
76.4622
76.4728
76.7042
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
.SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SEV
BAY
POT
PAT
BAY
BAY
POT
POT
POT
POT
POT
POT
POT
POT
POT
RAP
YRK
JAM
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
S u s quehanna
Sus quehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Sus quehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Sus quehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Wicomico
Manokin
Big Annemessey
Severn
Chesapeake Bay
Lower Potomac
Patuxent
Chesapeake Bay
Chesapeake Bay
Potomac
Potomac
Potomac
Potomac
Potomac
Potomac
Potomac
Potomac
Potomac
Rappahanock
York
James
Appendix C-7 Explanation of Parameter Codes
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
Table 3. Cruise Identifier (CRUISE). This alpha-numeric code identifies the cruise to which the
data observation belongs. Cruise identification is useful for grouping data that are collected over
a range of sample dates, but which are considered data for a specific sampling period. The
complete listing may be found in LRDISK:[LR.PUBLIC] BAYCRUZ.TXT. Please note that the
Maryland Phytoplankton program has adjusted some cruise periods. Deviations from the regular
cruise schedule can be found in LRDISK:[LR.PUBLIC] ANSCRUZ.TXT. A sample of current
values for this field are below.
CRUISE
BAY001
BAY002
BAY003
BAY004
BAY005
BAY006
BAY007
BAY008
BAY009
BAY010
BAY01 1
BAY012
BAY013
BAYOU
BAY015
BAY016
BAY017
BAY018
BAY019
BAY020
BAY021
BAY022
BAY023
BAY024
BAY025
BAY026
BAY027
BAY028
BAY029
BAY030
BAY031
BAY032
BAY033
BAY034
BAY035
BAY036
BAY037
BAY038
BAY039
BAY040
BAY041
BAY042
BAY043
BEGINNING
DATE
06/15/84
07/01/84
07/16/84
08/01/8*4
08/16/84
09/01/84
09/16/84
10/01/84
10/16/84
11/01/84
12/01/84
01/01/85
02/01/85
- 03/01/85
03/16/85
04/01/85
04/16/85
05/01/85
05/16/85
06/01/85
06/16/85
07/01/85
07/16/85
08/01/85
08/16/85
09/01/85
09/16/85
10/03/85
10/15/85
11/07/85
12/01/85
01/01/86
02/01/86
03/01/86
03/16/86
04/01/86
04/16/86
05/01/86
05/16/86
06/01/86
06/16/86
07/01/86
07/16/86
ENDING
DATE
06/30/84
07/15/84
07/31/84
08/15/84
08/31/84
09/15/84
09/30/84
10/15/84
10/31/84
11/30/84
12/31/84
01/31/85
02/28/85
03/15/85
03/31/85
04/15/85
04/30/85
05/15/85
05/31/85
06/15/85
06/30/85
07/15/85
07/31/85
08/15/85
08/31/85
09/15/85
10/02/85
10/14/85
11/06/85
11/30/85
12/31/85
01/31/86
02/28/86
03/15/86
03/31/86
04/15/86
04/30/86
05/15/86
05/31/86
06/15/86
'06/30/86
07/15/86
07/31/86
CRUISE
BAY044
BAY045
BAY046
BAY047
BAY048
BAY049
BAY050
BAY051
BAY052
BAY053
BAY054
BAY055
BAY056
BAY057
BAY058
BAY059
BAY060
BAY061
BAY062
BAY063
BAY064
BAY065
BAY066
BAY067
BAY068
BAY069
BAY070
BAY071
BAY072
BAY073
BAY074
BAY075
BAY076
BAY077
BAY078
BAY079
BAY080
BAY081
BAY082
BAY083
BAY084
BAY085 .
BAY086
BEGINNING
DATE
08/01/86
08/16/86
09/01/86
09/16/86
10/01/86
10/16/86
11/01/86
12/01/86
01/01/87
02/01/87
03/01/87
03/16/87
04/01/87
04/16/87
05/01/87
05/16/87
06/01/87
06/16/87
07/01/87
07/18/87
08/01/87
08/16/87
09/01/87
09/16/87
10/01/87
10/16/87
11/01/87
12/01/87
01/01/88
02/01/88
03/01/88
03/16/88
04/01/88
04/16/88
05/01/88
05/16/88
06/01/88
06/15/88
07/01/88
07/16/88
08/01/88
08/16/88
09/01/88
ENDING
DATE
08/15/86
08/31/86
09/15/86
09/30/86
10/15/86
10/31/86
11/30/86
12/31/86
01/31/87
02/28/87
03/15/87
03/31/87
04/15/87
04/30/87
05/15/87
05/31/87
06/15/87
06/30/87
07/17/87
07/31/87
08/15/87
08/31/87
09/15/87
09/30/87
10/15/87
10/31/87
11/30/87
12/31/87
01/31/88
02/28/88
03/15/88
03/31/88
04/15/88
04/30/88
05/15/88
05/31/88
06/14/88
06/30/88
07/15/88
07/31/88
08/15/88
08/31/88
09/13/88
Appendix C-8 Explanation of Parameter Codes
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
TableS.
CRUISE
BAY087
BAY088
BAY089
BAY090
BAY091
BAY092
BAY093
BAY094
BAY095
BAY096
BAY097
BAY098
BAY099
BAY100
BAY101
BAY102
BAY103
BAY104
BAY105
BAY106
BAY107
BAY108
BAY109
BAY110
BAY111
BAY112
BAY113
BAY114
BAY115
BAY116
BAY117
BAY118
BAY119
BAY120
BAY121
BAY122
BAY123
BAY124
BAY125
BAY126
BAY127
BAY128
BAY129
BAY130
BAY131
BAY132
BAY133
BAY134
BAY135
BAY136
BAY137
Cruise Identifier (continued)
BEGINNING
DATE
09/14/88
10/01/88
10/16/88
11/01/88
12/01/88
01/01/89
02/01/89
03/01/89
03/16/89
04/01/89
04/16/89
05/01/89
05/16/89
06/01/89
06/16/89
07/01/89
07/16/89
08/01/89
08/16/89
09/01/89
09/16/89
10/01/89
" 10/16/89
11/01/89
12/01/89
01/01/90
02/01/90
03/01/90
03/16/90
04/01/90
04/16/90
05/01/90
05/16/90
06/01/90
06/16/90
07/01/90
07/16/90
08/01/90
08/16/90
09/01/90
09/16/90
10/01/90
10/16/90
11/01/90
12/01/90
01/01/91
02/01/91
03/01/91
03/16/91
04/01/91
04/16/91
ENDING
DATE
09/30/88
10/15/88
10/31/88
11/30/88
12/31/88
01/31/89
02/28/89
03/15/89
03/31/89
04/15/89
04/30/89
05/15/89
05/31/89
06/15/89
06/30/89
07/15/89
07/31/89
08/15/89
08/31/89
09/15/89
09/30/89
10/15/89
10/31/89
11/30/89
12/31/89
01/31/90
02/28/90
03/15/90
03/31/90
04/15/90
04/30/90
05/15/90
05/31/90
06/15/90
06/30/90
07/15/90
07/31/90
08/15/90
08/31/90
09/15/90
09/30/90
10/15/90
10/31/90
11/30/90
12/31/90
01/31/91
02/28/91
03/15/91
03/31/91
04/15/91
04/30/91
CRUISE
BAY138
BAY139
BAY140
BAY141
BAY142
BAY143
BAY144
BAY145
BAY146
BAY147
BAY148
BAY149
BAY150
BAY151
BAY152
BAY153
BAY154
BAY155
BAY156
BAY157
BAY158
BAY159
BAY160
BAY161
BAY162
BAY163
BAY164
BAY165
BAY166
BAY167
BAY168
BAY169
BAY170
BAY171
BAY172
BAY173
BAY174
BAY175
BAY176
BAY177
BAY178
BAY179
BAY180
BAY181
BAY182
BAY183
BAY184
BAY185
BAY186
BAY187
BAY188
BEGINNING
DATE
05/01/91
05/16/91
06/01/91
06/16/91
07/01/91
07/16/91
08/01/91
08/16/91
09/01/91
09/16/91
10/01/91
10/16/91
11/01/91
12/01/91
01/01/92
02/01/92
03/01/92
03/16/92
04/01/92
04/16/92
05/01/92
05/16/92
06/01/92
06/16/92
07/01/92
07/16/92
08/01/92
08/16/92
09/01/92
09/16/92
10/01/92
10/16/92
11/01/92
12/01/92
01/01/93
02/01/93
03/01/93
03/16/93
04/01/93
04/16/93
05/01/93
05/16/93
06/01/93
06/16/93
07/01/93
07/16/93
08/01/93
08/16/93
09/01/93
09/16/93
10/01/93
ENDING
DATE
05/15/91
05/31/91
06/15/91
06/30/91
07/15/91
07/31/91
08/15/91
08/31/91
09/15/91
09/30/91
10/15/91
10/31/91
11/30/91
12/31/91
01/31/92
02/28/92
03/15/92
03/31/92
04/15/92
04/30/92
05/15/92
05/31/92
06/15/92
06/30/92
07/15/92
07/31/92
08/15/92
08/31/92
09/15/92
09/30/92
10/15/92
10/31/92
11/30/92
12/31/92
01/31/93
02/28/93
03/15/93
03/31/93
04/15/93
04/30/93
05/15/93
05/31/93
06/15/93
06/30/93
07/15/93
07/31/93
08/15/93
08/31/93
09/15/93
09/30/93
10/15/93
Appendix C-9 Explanation of Parameter Codes
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
Table 3 . Cruise Identifier (continued)
CRUISE
BAY189
BAY190
BAY191
BAY192
BAY193
BAY194
BAY195
BAY196
BAY197
BAY198
BAY199
BAY200
BAY201
BAY202
BAY203
BAY204
BAY205
BAY206
BAY207
BAY208
BAY209
BAY210
BEGINNING
DATE
10/16/93
11/01/93
12/01/93
01/01/94
02/01/94
03/01/94
03/16/94
04/01/94
04/16/94
05/01/94
05/16/94
06/01/94
06/16/94
07/01/94
07/16/94
08/01/94
08/16/94
09/01/94
09/16/94
10/01/94
10/16/94
11/01/94
ENDING
DATE
10/31/93
11/30/93
12/31/93
01/31/94
02/28/94
03/15/94
03/31/94
04/15/94
04/30/94
05/15/94
05/31/94
06/15/94
06/30/94
07/15/94
07/31/94
08/15/94
08/31/94
09/15/94
09/30/94
10/15/94
10/31/94
11/30/94
CRUISE
BAY211
BAY212
BAY213
BAY214
BAY215
BAY216
BAY217
BAY218
BAY219
BAY220
BAY221
BAY222
BAY223
BAY224
BAY225
BAY226
BAY227
BAY228
BAY229
BAY230
BAY231
BEGINNING
DATE
12/01/94
01/01/95
02/01/95
03/01/95
03/16/95
04/01/95
04/16/95
05/01/95
05/16/95
06/01/95
06/16/95
07/01/95
07/16/95
08/01/95
08/16/95
09/01/95
09/15/95
10/01/95
10/16/95
11/01/95
12/01/95
ENDING
DATE
12/31/94
01/31/95
02/28/95
03/15/95
03/31/95
04/15/95
04/30/95
05/15/95
05/31/95
06/15/95
06/30/95
07/15/95
07/31/95
08/15/95
08/31/95
09/15/95
09/30/95
10/15/95
10/31/95
11/30/95
12/31/95
Appendix C-10 Explanation of Parameter Codes
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
Table 4. Chesapeake Bay Program Segment Designation (SEGMENT). This code identifies the
Chesapeake Bay Segment from which the sample was taken. Due to controversy about the
segmentation systems, these codes are not reported in current Living Resources data sets.
However, segment codes are used in other CBP Monitoring data sets and are included here for
the conveyance of the data user. The acceptable codes are given below.
CB1 Susquehanna Flats
CB2 Upper portion of the Chesapeake Bay mainstem
CBS Upper-most Estuarine zone in mainstem of the Chesapeake Bay
CB4 Upper portion of the central Chesapeake Bay mainstem
CBS Central portion of the mainstem of the Chesapeake Bay
CB6 Lower west-central mainstem of the Chesapeake Bay
CB7 Lower east-central mainstem of the Chesapeake Bay
CBS Southern-most segment of the Chesapeake Bay
ET1 Northeast River
ET2 Elk River and Bohemia River
ET3 Sassafras River
ET4 Chester River
ET5 Choptank River
ET6 Nanticoke River
ET7 Wicomico River
ET8 Manokin River
ET9 Big Annemessex River
ET10 Pocomoke River
EE1 Eastern Bay, Miles River, and Wye River
EE2 Choptank River, west of Castle Haven, including Tred Avon River, Broad Creek, Harris
Creek, and the Little Choptank
EE3 Tangier and Pocomoke Sounds
LE1 Patuxent River- Lower Estuarine Segment
LE2 Potomac River - Lower Estuarine Segment
LE3 Rappahannock River - Lower Estuarine Segment
LE4 York River - Lower Estuarine Segment
LE5 James River - Lower Estuarine Segment
RET1 Patuxent River- Riverine-estuarine transition zone
RET2 Potomac River - Riverine-estuarine transition zone
RETS Rappahannock River - Riverine-estuarine transition zone
RET4 York River - Riverine-estuarine transition zone
RETS James River- Riverine-estuarine transition zone
TF1 Patuxent River- Tidal Freshwater Segment
TF2 Potomac River- Tidal Freshwater Segment
TF3 Rappahannock River - Tidal Freshwater Segment
TF4 York River-Tidal Freshwater Segment
TF5 James River-Tidal Freshwater Segment
WT1 Bush River
WT2 Gunpowder River
WT3 Middle River and Seneca Creek
WT4 Back River
WT5 Patapsco River
WT6 Magothy River
WT7 Severn River
WT8 South, Rhode, and West Rivers
WE4 Mobjack Bay
Appendix C-ll Explanation of Parameter Codes
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
Table 5. Tributary Code (TREB_COD). This is a three character code describing the position of
a sampling station by tributary or mainstem. The codes for this field are as follows:
BAL Baltimore Harbor
BAY Main Bay
CHP Choptank River
CHS Chester River
ELZ Elizabeth River
JAM James River
PAX Patuxnet River
POT Potomac River
RAP Rappahanock River
TAN Tangier River
YRK York River
Table 6. Cloud Cover (CLOUD). This one digit code describes the type of cloud coverage
during a sampling period. If these data are collected, they are located in the EVENT DATA
FILE. Possible values for this field are:
Not Recorded
0 Clear Oto10%
1 Scattered to Partly 10 to 50 %
2 Partly to Broken 50 to 90 %
3 Overcast GT 90 %
4 Foggy
5 " Hazy
6 Clouds: No % given
Table 7. Precipitation Identifier (PRECIP). This code describes the weather conditions
encountered during a sampling period. If these data are collected, they are located in the EVENT
DATA FILE. The possible values for this field are given below.
Not Recorded
10 None
11 Drizzle
12 Rain
13 Rain, heavy
14 Squally
15 Frozen Precipitation
Appendix C-12 Explanation of Parameter Codes
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
TableS. Tidal Stage (TIDE). This code describes the tidal state during the sampling period. If
these data are collected, they are located in the EVENT DATA FILE. The possible values for this
field are given below.
Not recorded/not applicable
E Ebb tide (stage of water movement from a higher to a lower level)
F Flood tide (stage of water movement from a lower to higher level)
L Low slack tide (stage of water where the level is below mean and
velocity approaches zero)
H High slack tide (stage of water where the level is above mean
and velocity approaches zero)
Table 9. Wave Height (WAVHGT). This code describes the height of the wave during a
sampling period. If these data are collected, they are located in the EVENT DATA FILE. Pos-
sible values for this field are given below:
Not Recorded
0 0 to 0.1 Meters-Calm
1 0.1 to 0.3 Meters
2 0.3 to 0.6 Meters
3 0.6 to 1.0 Meters
4 1.0 to 1.3 Meters
5 GT 1.3 Meters
Table 10. Wind Direction (WINDER). This code describes the predominant direction of the
wind. If these data are collected, they are located in the EVENT DATA FILE. Possible values
for this field are given below:
N
NNE
NE
ENE
E
ESE
SE
SSE
S
SSW
SW
WSW
W
WNW
NW
NNW
Not Recorded
0 degrees, winds from the NORTH
22.5 degrees, winds from the NORTH NORTHEAST
45 degrees, winds from the NORTHEAST
67.5 degrees, winds from the EAST NORTHEAST
90 degrees, winds from the EAST
1 12.5 degrees, winds from the EAST SOUTHEAST
1 35 degrees, winds from the SOUTHEAST
157.5 degrees, winds from the SOUTH SOUTHEAST
1 80 degrees, winds from the SOUTH
202.5 degrees, winds from the SOUTH SOUTHWEST
225 degrees, winds from the SOUTHWEST
247.5 degrees, winds from the WEST SOUTHWEST
270 degrees, winds from the WEST
292.5 degrees, winds from the WEST NORTHWEST
315 degrees, winds from the NORTHWEST
337.5 degrees, winds from the NORTH NORTHWEST
Appendix C-13 Explanation of Parameter Codes
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
Table 11. Wind Speed (WINDSPD). This code describes the predominant speed of the wind
during a sampling period. If these data are collected, they are located in the EVENT DATA
FILE. Possible values for this field are given below.
Not Recorded
0 0 knots to 1 knot - Calm
1 greater than 1 knot to 10 knots
2 greater than 10 knots to 20 knots
3 greater than 20 knots to 30 knots
4 greater than 30 knots to 40 knots
5 greater than 40 knots
Table 12. Site Selection Type (SITETYPE). This code tells the user how a sampling site was
selected.
F Fixed Location Sampling Site
M Randomly selected site within Chesapeake Bay mainstem
R Randomly selected site within a habitat strata
Table 13. Salinity Zone (SALZONE). Salinity zone layer code. If these data are collected, they
are located in the EVENT DATA FILE.
F Freshwater less than 0.5 ppt
O - Oligohaline 0.5 - 5.0 ppt
M Mesohaline 5.0 -18.0 ppt
P Polyhaline 18.0-32.0 ppt
N Not Recorded
Table 14. Sample Collection Type (COLTYPE). Sample collection method code.
C Composite
D Discrete
Table 15. Sample Layer (LAYER). This code is used to describe the water layer being sampled.
S Surface
M Middle
B Bottom
SE Sediment
SW Sediment/water interface (0-1 cm)
AP Above pycnocline
BP Below pycnocline
AT Above thermocline
BT Below thermocline
AE Above euphotic zone
BE Below euphotic zone
Ml Microlayer
WC Whole Water column
Appendix C-14 Explanation of Parameter Codes
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
Table 16. Sampling Gear (GMETHOD). Sampling gear collection code.
1 Hand Collection
2 Dredge
3 Artificial Substrate (Unspecified)
4 Diatometer Slides
5 Clarke-Bumpus Sampler
6 Plankton Trap (Unspecified)
7 Plankton Pump (Unspecified)
8 Plankton Net (Unspecified)
9 Plankton Net (500 micron mesh)
10 Plankton Net (No. 20 size - 80 micron mesh
11 Plankton Net (10 micron mesh)
12 Beam plankton line
13 Anchor dredge
14 Hydraulic grab (1200 square centimeters)
15 Hand core (45 square centimeters)
16 Post-hole digger (25 square centimeters)
17 Ponar grab (200 square centimeters)
18 Ponar grab (1000 square centimeters)
19 Ponar grab (50 square centimeters, .05 m**2)
20 Box corer grab (unspecified)
21 Van veen grab (.07 m**2)
22 Shipek grab (.04 m**2)
23 Seine haul (unspecified)
24 Smith-Macintire grab (1000 square centimeters)
25 Seine net (15ft, 1/8 inch stretch mesh)
26 ' Seine net (50ft, 1/2 inch stretch mesh)
27 Seine net (50ft, 1/4 inch stretch mesh)
28 Seine net (200ft, 1/2 inch stretch mesh - net 200 x 20)
29 Seine net (1 Oft, 1 /4 inch stretch mesh - net 10 x 4)
30 Trawl (unspecified)
31 Trawl - 6ft otter trawl, 1 inch stretch mesh with 1/2 inch cod end inner liner.
32 Trawl - 25ft otter trawl, 1 1/4 inch stretch mesh with 1/2 inch cod end inner liner.
33 Trawl -15ft semi-balloon
34 2 mm mesh 1 square meter tucker trawl
35
36 Otter trawl - 16ft, 1/2 inch mesh (semi-balloon)
37 Trawl - 10ft otter trawl, 1/4 inch (6.4 mm) mesh with 500 um cod end liner
38 Trawl - 5ft midwater trawl, 1/4 inch (6.4 mm) mesh with 500 um cod end liner
39 Reserved for trawl sample
40 Trap net - 3ft x 6ft, 1/2 inch mesh, 50ft lead
42 Eckman dredge
43 Cage
44 Catfish trap
45 Crayfish trap
46 Crab trap
47 Animal trap
48 Hook and line fishing
49 Dip net
50 Diver
54 Pound net
55 Epifauna panels
56 Reserved
57 Reserved
58 Reserved
Appendix C-]5 Explanation of Parameter Codes
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
59 Reserved
60 Endico current meter
61 Branco current meter
62 Sediment trap array (6 3" X 30" cups, W.R.Boynton, CBL)
63
64 Bongo net (unspecified)
65 Purse seine
66 Fyke and hoop net
67 Pots
68 Box trap
69 Push net
70 Great Lakes shoal 1-2 inch
71 Great Lakes shoal 2-4 inch
72 Great lakes shoal 4-7 inch
73 Great lakes shoal 7-14 inch
74 Beam Trawl
75 Bongo net 202um mesh, 20 cm diameter opening
76 Bongo net 202um mesh, 50 cm diameter opening
77 Reserved
78 Slat trap
79 Reserved
80 Gill nets
81 0.06 meter squared spade box core
82 Reserved
83 Reserved
84 Reserved
85 Midwater trawl (unspecified)
86 - Drift gill net brails
87 Drift gill net flop
88 Drift gill net jugs
89 Electrofishing
90 Shore
91 Pick
92 Drift gill net (unspecified)
93 Set gill net
94 Bottom trawl (unspecified)
95 Fish house
96 Hydraulic Van Veen grab (1 square meter)
97 Young modified Van Veen grab (.1 square meter)
98 Petite Ponar grab (25 square centimeters, .025 m**2)
Appendix C-16 Explanation of Parameter Codes
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
Table 17. NOAA Species Code (NODCCODE). Reference the NOAA-NODC taxonomic code
version 7.0 released in January 1995. For the user's convenience, a subset of that code is
provided in here. The complete listing of currently recognized Chesapeake Bay basin species
may be found in file LRDISK:[LR.PUBLIC] NODCCODE.TXT or in the document A
Comprehensive List of Chesapeake Bay Basin Species, 1996. NODC code tables are subject to
revision on a semi annual basis. Please check the R_DATE or version date of the species list to be
sure you have the most current data set.
NODC
TAXONOMIC CODE
LATIN NAME
8803020101
8835160101
3258090112
8729010104
1608020501
9158320401
9112011002
9112011001
8747010103
8747010105
8747010101
6179140102
8845010102
9112010903
6188030107.
8835020301
0902010103
874701020102
5123030101
6118200201
8850030102
3703180304
3305010901
9128020108
9002040401
6169060701
9002030301
330605010603
ABLENNES HIANS
ACANTHARCHUS POMOTIS
ACER SACCHARINUM
ACIPENSER BREVIROSTRUM
AGARDHIELLA TENERA
AGELAIUS PHOENICEUS
AIX GALERICULATA
AIX SPONSA
ALOSA MEDIOCRIS
ALOSA PSEUDOHARENGUS
ALOSA SAPIDISSIMA
ALPHEUS NORMANNI
AMMODYTES AMERICANUS
ANAS RUBRIPES
CANCER BOREALIS
CENTROPRISTIS STRIATA
CHARA BRAUNII
CLUPEA HARENGUS HARENGUS
ELYSIA CATULUS
EURYTEMORA AFFINIS
EUTHYNNUS ALLETTERATUS
HYDRACTINIA ECHINATA
HYDRILLA VERTICILLATA
LARDS ARGENTATUS
LEPIDOCHELYS KEMPI
LEPTOCHEIRUS PLUMULOSUS
MALACLEMYS TERRAPIN
POTAMOGETON PERFOLIATUS
BUPLEUROIDES
COMMON NAME
FLAT NEEDLEFISH
MUD SUNFISH
SILVER MAPLE
SHORTNOSE STURGEON
TAPERED RED WEED
RED-WINGED BLACKBIRD
MANDARIN DUCK
WOOD DUCK
HICKORY SHAD
ALEWIFE
AMERICAN SHAD
GREEN SNAPPING SHRIMP
AMERICAN SAND LANCE
AMERICAN BLACK DUCK
JONAH CRAB
BLACK SEA BASS
MUSKGRASS
ATLANTIC HERRING
KITTY-CAT SEA SLUG
CALANOID COPEPOD
LITTLE TUNNY
SNAIL FUR
HYDRILLA
HERRING GULL
KEMP'S RIDLEY TURTLE
COMMON BURROWER AMPHIPOD
DIAMONDBACK TERRAPIN
REDHEAD GRASS
Appendix C-l 7 Explanation of Parameter Codes
-------
The 1996 £ 'ssrs Guide to CBP Biological and Living Resources Monitoring Data
Table 18. Life Stage (LIFE_STG). Life stage code for biological monitoring offish and
zooplankton.
1 ' = Adult
00 = Egg (viable; for non-viable eggs use
'90')
01 = Yolk Sac
02 = Fin fold
03 = Post fin fold (full development of
second dorsal fin)
04 = Young of the year — year class 0
05 = Specimens in year class 1 or older
06 = Juveniles and adults
07 = Larvae, juveniles and adults
08 = Larvae and juveniles
09 = Reserved for future use
10 = Nauplii or copepodites
11 = Nauplii
12 = Copepodite
13 = Orthonauplii stage 1-3
14 = Metanauplii stage 4-6
15 = Copepodite stage 1 -3
16 = Copepodite stage 4-6
17 = Cypris Larvae
18 = Reserved
19 = Copepod eggs
20 = Nymph
21 = Pupae
22 = Pharate
23 = Instar
24 = Naiad
25 = Reserved
26 = Reserved
27 = Reserved
28 = Reserved
29 = Reserved
30 = Prezoea
31 = Zoea
32 = Metazoea
33 = Megalops
34 = Reserved
35 = Reserved
36 = Reserved
37 = Reserved
38 = Reserved
39 = Reserved
40 = Nauplii stage 1
41 = Nauplii stage 2
42 = Nauplii stage 3
43 = Nauplii stage 4
44 = Nauplii stage 5
45 = Nauplii stage 6
46 = Copepodite stage 1
47 = Copepodite stage 2
48 = Copepodite stage 3
49 = Copepodite stage 4
50 = Copepodite stage 5
51 = Copepodite stage 6
80 = Molted
81 = Unmolted
90 = Egg, non-viable
91 = Subadult
92 = Post larvae
93 = Juvenile
94 = Taxon with count stored as volume in
milliliters
95 = Mature
96 = Immature
97 = Larvae
98 = Adult (mature)
Appendix C-18 Explanation of Parameter Codes
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
Table 19. Gonad Index for bivalve populations (GONAD_I). These codes were used to ensure
that non-spawning bivalve organisms are being collected for use in lipophilic organic contaminant
analyses (Batelle Ocean Sciences). These codes are not reported in current Living Resources data
sets but are used in other CBP monitoring data sets. They are included here for the convience of
the data user. The valid entries for this field are as follows:
GONADJ = (#Oraanbms in each stage x numerical ranking of each stage)
Total # of Organisms in Sample
Stage 0 = Resting or spent gonad - inactive or neuter including virgin.
Stage 1 = Developing gonad - gametogenesis has begun although no ripe gametes are visible
or
= Spawning gonad - only residual gametes remain with some cytolysis.
Stage 2 = Developing gonad - ripe gametes with gonad one-third of final size
or
= Spawning gonad - gonad reduction with follicles about one-third full of ripe gametes.
Stage 3 = Developing gonad - equal portions of ripe and developing gametes with gonad'
one- half of final size
or
= Spawning gonad - gonad is half empty.
Stage 4 = Developing gonad - gametogenesis progressing, follicles contain mainly ripe
gametes
or
= Spawning gonad - active emission has begun
Stage 5 = Ripe gonad - distended follicles with ripe gametes.
Table 20. Biomass Measurement Type (AEAFDW). Biomass measurement type code.
A = Actual Measurement of Ash Free Dry Weight
E = Estimated Ash Free Dry Weight
Appendix C-19 Explanation of Parameter Codes
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
Table 21. Analytical Method Codes (associated with multiple field names, e.g. CHL_F_M,
C14_M). This alpha-numeric code which refers to a method of analysis is described in detail in
CHESSEE. This table currently defines the methods for each parameter in the monitoring data
dictionary which are used by the data collection institutions of the Chesapeake Bay Program.
Codes relevant to living resources and biological data are as follows:
ALK101
ALK102
ALKF01
ALKF02
BOD5101
BOD5F01
C14101
CHLA101
CHLA102
CHLA103
CHLAF01
CHLAF02
CHLAF03
CHLAF04
CHLAF05
CHLAF06
CHLAF07
CHLAF08
CONDF01
DIN101
DIN102
DISOXY101
DISOXYF01
DISOXYF02
DOC101
DOC102
DOCF01
DOCF02
DOCF03
DOCF04
DON101
DON102
DOP101
FCOLI101
FCOLI102
FCOLIF01
FCOLIF02
FSS101
FSSF01
NH4101
NH4102
NH4103
NH4104
NH4F01
NH4F02
NH4F03
NH4F04
NH4F05
NH4F06
NH4F07
NO2101
NO2102
NO2103
NO23101
NO23102
NO2F01
N02F02
NO2F03
N02F04
NO2F05
NO3101
NO3102
NO3103
NO3104
N03105
NO3F01
NO3F02
NO3F03
NO3F04
NO3F05
N03F06
PHEA101
PHEA102
PHEAF01
PHEAF02
PHEAF03
PHEAF04
PHEAF05
PHEAF06
PHEAF07
PHEAF08
PHF01
PHF02
PHOSP101
PHOSP102
PO4F101
PO4F102
PO4F103
PO4F104
P04FF01
PO4FF02
PO4FF03
PO4FF04
PO4FF05
P04FF06
PO4FF07
POC101
POC102
POC103
POCF01
PON101
PON 102
PON103
PONF01
SALINF01
SECCHIF01
SI101
S1 102
SI103
S1 104
SI105
SIF01
SIF02
SIF03
SIF04
SIF05
SOE101
TCOLI101
TCOLIF01
TCOLIF02
TCOLIF03
TDN101
TDN102
TDN103
TDNF01
TDP101
TDP102
TDP103
TDP104
TDPF01
TDPF02
TDPF03
TDPF04
TDPF05
TDPF06
TDPF07
TKNF101
TKNF102
TKNF103
TKNF104
TKNFF01
TKNFF02
TKNFF03
TKNFF04
TKNFF05
TKNFF06
TKNW101
TKNW102
TKNW103
TKNW104
TKNWF01
TKNWF02
TKNWF03
TKNWF04
TKNWF05
TN101
TN102
TN103
TOC101
TOC102
TOCF01
TOCF02
TOCF03
TOCF04
TOCF05
TP101
TP102
TP103
TP104
TP105
TP106
TPF01
TPF02
TPF03
TPF04
TPF05
TPF06
TPF07
TSS101
TSSF01
TSSF02
TSSF03
TSSF04
TSSF05
TSSF06
TVS101
WTEMPF01
Appendix C-20 Explanation of Parameter Codes
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
Table 22. Analytical Instrument Codes (INS_CODE). Instrument method codes.
AACHE Atomic Absorption, Chelation Extraction Technique
AACV Atomic Absorption, Cold Vapor Technique
AAFLAM Atomic Absorption, Direct Aspiration Technique
AAGF Atomic Absorption, Graphite Furnace Technique
AAHYD Atomic Absorption, Gaseous Hydride Technique
AE Atomic Emission
AF Atomic Fluorescence
AMSCTD Applied Microsystem CTD.
AUTOA Auto-Analyzer (e.g., Technicon)
BECKRS-5 Beckman RS-5 Salinometer.
COLOR UltravioletA/isible Spectrophotometer
CTD In-situ probe (Field)
FLUOR Fluorometer
GC/ECD Gas Chromatograph with Electron Capture Detection
GC/FID Gas Chromatograph with Flame lonization Detection
GC/EC Gas Chromatograph with Electron Capture Detection
GC/MS Gas Chromatograph with Mass Spectrophotometer
GC/HECD Gas Chromatograph with Hall Electrolyte Conduction
GC Gas Chromatograph
GC/PID Gas Chromatograph with Photo ionization Detection
GRAV Gravimetric
HACH16300 Hach Portable cond. meter, Model 16300-00.
HL60 Hydrolab Model 60.
HL8000 Hydrolab 8000.
HLS4000 Hydrolab 4000.
HLSII " Hydrolab. (Hydrolab 4000 or Surveyor II)
HPLC/FL High Performance Liquid Chromatograph/Fluorescence
HPLC/EC High Performance Liquid Chromatograph/Electrochemical
HPLC/UV High Performance Liquid Chromatograph/Ultraviolet
HSSVR2 Hydrolab SVR2-SU.
1C Ion Chromatograph
ICP/MS Inductively Coupled Plasma/Mass Spectrophotometer
ICP Inductively Coupled Plasma Atomic Emission Spec.
IR Infrared Detection
ISE Ion Selective Electrode
KITS Field Kits (e.g., Hach or CHEMetrics1 or PCB comm. field kits)
PHMETER PH Meter
POA/FID Portable Organic Analyzer, Flame lonization (e.g., Foxboro OVA)
POA/PID Portable Organic Analyzer, Photo ionization (e.g., HNU, Photovac)
SCINT Scintillation Counter
TEM Transmission Electron Microscope
THERMO Thermometer
TITRA Titration
UNLISTED Instrument not listed
WET Analysis by Classical Wet Method
XRF/F X-Ray Fluorescence, Field Portable or Transportable
XRF/L X-Ray Fluorescence, Laboratory Scale Model
YSI33 YSI 33 S-C-T (back up).
YSI54 YSI Model 54.
YSI57 YSI Model 57
YSI59 YSI Model 54.
YSI85 YSI Model 58.
YSIS4 YSI S4ARC.
Appendix C-21 Explanation of Parameter Codes
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
Table 23. Reported Units (UNITS). This parameter describes the units in which a substance is
measured. Some of the possible values for this field are as follows:
absorbance
cm
cpm
cfs
DegC
9
g/m**2/day
g/m**2/yr
I
m
mg
mg/kg
mg/l
mg/m**2
mg/m**2/day
mg/m**3
mg/sample
ml
mm
MPN/100ml
mV
ng/l
number/m**2
number/m**3
NTU
pCi/kg wet
pCi/liter
phi
PPb
ppm
ppt
pptr
su
ug/g
ug/kg
ug/l
um/cm
Parts per hundred; percent
Spectrometer absorbance
Centimeters
Counts per minute
Cubic feet per second
Degrees Celsius
Grams
Grams per square meter per day
Grams per square meter per year
Liters
Meters
Milligrams
Milligrams per kilogram (ppm)
Milligrams per liter (ppm)
Milligrams per square meter
Milligrams per square meter per day
Milligrams per cubic meter
Milligrams per sample
Milliliters
Millimeters
Most Probable Number (Coliform)
Millivolts
Nanograms per liter
Number per square meter
Number per cubic meter
Nephelometric Turbidity Units
Picocuries per kilogram
Picocuries per liter
Sediment particle size
Parts per billion
Parts per million
Parts per thousand (0/00)
Parts per trillion
Standard units
Micrograms per gram
Micrograms per kilogram (ppb)
Micrograms per liter (ppb)
Micro mhos per centimeter
Table 24. Replicate Type (REP_TYPE). This character code identifies sample types, and kinds
and levels of sample replication. It is usually used in conjunction with REP_NUM. The current
valid entries are as follows:
CTRL
FLD
LAB
FL
METH
SPK
SPLT
Control sample
Field replicate
Laboratory replicate
Field and laboratory replicates in data set
Method comparison
Spike sample
Field split
Appendix C-Z2 Explanation of Parameter Codes
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
Table 25. Sampling Media Type. These codes are not reported in current Living Resources data
sets but are used in other CBP Monitoring data sets. They are included here for the convience of
the data user. The valid entries for this field are as follows:
MICROL = Microlayer (0 - .5cm)
WATCOL = Water column
SEDSAM = Sediment sample (other than core)
SEDCOR = Sediment core
SEDH20 = Core head water
SEDTRP = Sediment trap
SEDWAT = Sediment/water interface
WATINT = Interstitial water
Table 26. Sediment bottom codes (BOTTYPE1, BOTTYPE2). These codes are not reported in
current Living Resources data sets but are used in other CBP Monitoring data sets. They are
included here for the convience of the data user. The valid entries for this field are as follows.
CL = Clay
GR = Gravel
MD = Mud
RK = Rocks
SN = Sand
SH = Shell
SL = Silt
RB . = Rubble
UN = Unknown
Table 27. Detection Limit Codes (associated with multiple field names, e.g. CHL_F_D,
C14_D). This one-character code indicates when the value of the parameter is outside the
detection limits of the method being used. The valid entries for this field are as follows:
< = Less than the detection limit of the method
= Not recorded/not applicable/parameter value acceptable
# = Trace (less than an unknown detectable value)
J = Estimated value
N = Not detected
>0 = Greater than zero
Table 28. Analysis Problem Code. This letter code describes the problem associated with a
questionable parameter value. These codes are not reported in current Living Resources data sets
but are used in other CBP Monitoring data sets. They are included here for the convience of the
data user. The valid entries for this field are as follows:
A = Laboratory accident
B = Interference
C = Mechanical/materials failure
D = Insufficient sample
E = Sample received too late
F = Sample too old when received
H = Analysis run by another lab
Appendix C-23 Explanation of Parameter Codes
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
J = Wrong type sample (e.g., filtered sample requesting TSS)
K = Sample frozen when received (results questionable)
M = Sample received warm
N = Sample lost
P = Lost results
R = Sample contaminated
S = Sample container broken during analysis
T = No phaeophytin in sample
U = Matrix problem which is the result of the interrelationship between variables such as pH
and
ammonia
V = Sample results rejected due to QA/QC criteria
W = Duplicate results for all parameters
X = Sample not preserved properly
Y = Analyzed in duplicate, results below detection limit
Z = Analyzed by method of standard additions
AA = Sample thawed when received
BB = Torn filter pad
CC = Pad unfolded in foil pouch
DD = Assumed sample size (sample size not reported)
EE = Foil pouch very wet when received from field, therefore
poor replication between pads, mean reported
FF = Poor replication between pads, mean reported
GG = Sample received after holding time, therefore results are questionable
HH = Sample not taken
JJ = Amount filtered not recorded (therefore calculation could not be done)
KK = Parameter test not required for study
LL = Mislabeled
MM = Over 20% of sample adhered to pouch and outside of pad
NN = Particulates found in filtered sample
PP = Assumed sample volume (pouch volume differs from data sheet volume
pouch volume used)
QQ = Although value exceeds a theoretically equivalent or greater value (e.g., PO4F>TDP), the
excess is within precision of analytical techniques and therefore not statistically significant.
RR = No sample received
Table 29. Agency Species Codes (SPECCODE). Many of the agencies reporting data containing
species information have developed their own inhouse species codes. All of these codes are found
in the SPECCODE column of a given data type. Codes will vary by agency and data type. The
agency code column in most cases has been given the agency name code in the data
documentation. The valid alternate field names for SPECCODE are as follows:
ANSCODE = Academy of Natural Sciences, Benidict Estuarine Reseach Laboratory
VERCODE = Versar Incorporated- Maryland Power Plant Siting Codes
ODUCODE = Old Dominion University Species Code
VIMSCODE = Virginia Institute of Marine Sciences Species Codes
Appendix C-24 Explanation of Parameter Codes
-------
APPENDIX D
CHESAPEAKE BAY PROGRAM DATA REQUEST FORM
September 1996
Individuals without user accounts on CHESIE, users wishing to
obtain SAS conversion scripts or users wishing to obtain the data
files in dBASE (.dbf) format can request data sets directly from the
Biological Monitoring Data Manager. All requests must be made in
writing. A data request form is provided in this Appendix and can
be sent to
Ms. Jacqueline Johnson
Biological Monitoring Data Manager
Chesapeake Bay Program Data Center
410 Severn Avenue, Suite 109
Annapolis, MD 21403
Phone (local): 410-267-5729
Phone (long distance): 800-968-7229, ext. 729
FAX: 410-267-5777
E-mail: JJOHNSON@CHESIE.ANN.EPA.GOV
The data form may be copied. Please request only one data set per
form. Requests for data other than living resources data may be
made on this form but should be mailed to the Chesapeake Bay
Program Data Center Manager:
Mr. Lowell Bahner
Data Center Manager
Chesapeake Bay Program Data Center
410 Severn Avenue, Suite 109
Annapolis, MD 21403
Phone (long distance): 1-800-968-7229, ext. 671
FAX: 410-267-5777
E-mail: LBAHNER@CHESIE.ANN.EPA.GOV
-------
CHESAPEAKE BAY PROGRAM OFFICE
410 Severn Avenue, Suite 109
Annapolis, MD 21403
(410) 267-5700 or 1 800 YOUR BAY
FAX-410-267-5777
CHESAPEAKE BAY PROGRAM
DATA ACCESS FORM
DATE REQUESTED:
SUBMITTED BY:
REQUESTED FOR :
ORGANIZATION:
CHESAPEAKE BAY PROGRAM SUB-COMMITTEE AFFILIATION:,
ADDRESS:
PHONE:_( ) EXT..
INTERNET ADDRESS:
DESCRIPTION OF DATA AND ADDITIONAL DOCUMENTATION REQUESTED
INTENDED DATA USAGE:
FORMAT OF DATA TO BE RELEASED
POINT DATA FORMATS (CHECK ALL APPROPRIATE):
3 1/4" DISK FTP pfcrip mime compression
COMMA DELIMITED ASCII TAB DELIMITED ASCII DBF
CIS FORMATS (CHECK ALL APPROPRIATE):
COVERAGE ARC/INFO EXPORT UNIX TAR 8MMTAPE_
GZIP UNIX COMPRESSION FTP 0 150MB QIC TAPE
I, THE DATA REQUESTOR, AGREE TO ACKNOWLEDGE THE CHESAPEAKE BAY PROGRAM AND ANY OTHER AGENCIES
AND INSTITUTIONS AS SPECIFIED BY THE CHESAPEAKE BAY PROGRAM OFFICE AS DATA PROVIDERS. I AGREE TO
CREDIT THE DATA ORIGINATORS IN ANY PUBLICATIONS, REPORTS OR PRESENTATIONS GENERATED FROM THIS
DATA.
SIGNATURE OF DATA REQUESTOR:
NO DATA REQUEST WILL BE HONORED WITH OUT SIGNATURE
„„**«,«*«*****««*******«*****l-OR BAY PROGRAM USE ONLY****'********************'*************
DATA PREPARED DATE DATA RELEASED RELEASE AUTHORIZATION
YES/NO
AND PROCESSED BY: FROM CBP DATE
-------
-------
APPENDIX E
DATA ACQUISITION PRIORITIES
September 1996
In 1995, the Living Resources/Monitoring Workgroup prioritized
the categories of biological monitoring data believed to be critically
important to CBP activities (Table 1). The workgroup
recommended that key data sets in these categories be made
available from the CBP Data Center. Living Resources
Subcommittee staff are using this prioritized list of data categories
as a guide for obtaining living resources and biological monitoring
data for the Data Center. The list was updated at the January 16,
1996 Living Resources Subcommittee meeting.
-------
The 1996 Users Guide to CBP Biological and Living Resources Monitoring Data
Table 1. Categories of biological monitoring data which the Living Resources/Monitoring
Workgroup recommends should be available from the CBP Data Center. This table reflects
changes made at the January 16, 1996 Living Resources Subcommittee meeting.
High Priority Data Sets:
Phytoplankton1
Zooplankton1
Benthos1
Seine Surveys - MD, VA, DC2
Trawl Surveys - MD, VA, DC2
Fish Passage2
Blue crab surveys2
Oyster surveys2
Water bird concentrations and distributions2
SAV3
Medium Priority Data Sets:
Light (Photosynthetically Active Radiation [PAR], possibly PAR at depth)
Stream surveys2
RMAP2
1 Data sets which have been restructured (relational database with standard CBP field names),
QA/QC, documented and are presently available on CHESEE at the CBP Data Center. These
monitoring data are sponsored or matched by the Chesapeake Bay Program and as such are
required to be available at the Data Center in a standardized, relational database structure.
2 The Living Resources Monitoring Workgroup tentatively agreed that construction of relational
databases for the basin's diverse biological data sets was worth the additional effort. Numerous
problems were foreseen in trying to provide common fields for, for example, organisms sampled at different times
although possible solutions to the problems were also discussed. The Biological Monitoring Data Manager will be
trying in the next year to put data for fish surveys and water bird concentrations and distributions in a relational database
system. Her success or failure will help the workgroup decide if this is a reasonable goal.
SAV data and documentation are generated and managed by the Virginia Institute of Marine Sciences(VIMS). Data
is maintained as Geographic Information System (GIS) data layers and are available on VIMS Internet Home Page
Pointers on the CBP Home Page are available to direct users to the VIMS Home Page for the SAV data
Appendb: E-1 Data A cquisition Priorities
-------
-------
Background
This document is one of several CEP products designed to
implement the management goals set forth in the Living Resources
Monitoring Plan (Chesapeake Bay Program Agreement
Commitment Report, July 1988) and adopted by the Executive
Council. As called for in the 1987 Chesapeake Bay Agreement, the
Plan provides a framework for a bay-wide, core living resources
monitoring program based on existing programs. The Plan was
viewed as one step towards the goal of full integration of living
resources, habitat and water quality monitoring.
The Plan specifically charges the CBP with instituting a
data management and reporting system for the core living
resources monitoring program. The system would build on the
facilities of the existing CBP Computer Center and ultimately
provide:
+ a large quantity of consistent data of known quality, in
standardized formats and structures;
+ ready access to the data for analytical and reporting
purposes; and
+ thorough data documentation.
The Plan recognized that monitoring programs cannot achieve
their ultimate goals of providing information to the Bay community
and serving the restoration and management of the Bay if their
data are inaccessible, poorly managed, inadequately documented,
or not analyzed or reported in a timely manner.
In response to the charge, and to a restructuring of the
Computer Center in 1993, the Living Resources Subcommittee
hired three staff to continue implementing a data management and
reporting system for biological and living resources monitoring
data. These staff are responsible for a) creating, maintaining and
updating key databases and G1S coverages, b) facilitating use of
the databases and coverages, and c) providing data analysis
support to the Living Resources Subcommittee and other CBP
participan ts. Contact the Living Resources Subcommittee
Coordinator (Carin Bis land) at I-800-YOURBAYfor more
information.
-------
U.S. Environmental Protection Agency
Chesapeake Bay Program Office
410 Severn Avenue
Annapolis, MD 21403
1-800-YOUR BAY
http://www.epa.gov/r3chespk/
J-**'
-
------- |