CBP/TRS 191/97
EPA903R 97-032
The 1997 Users Guide to
Chesapeake Bay Program
Biological and Living Resources
Monitoring Data
Chesapeake Bay Program
December 1997
EPA Report Collection
Regional Center for Environmental Information
U.S. EPA Region III
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 (EPA), 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 Chesapeake
Executive Council, made up of the governors of Maryland, Pennsylvania, and
Virginia; the mayor of Washington, D.C.; the EPA administrator; and the chair
of the Chesapeake Bay Commission, guided the restoration effort in 1993 with
five directives addressing key areas of the restoration, including the tributaries,
toxics, underwater bay grasses, fish passages, and agricultural nonpoint source
pollution. In 1994, partners outlined initiatives for habitat restoration of
aquatic, riparian, and upland environments; nutrient reduction in the Bay's
tributaries; and toxics reductions, with an emphasis on pollution prevention.
The 1995 Local Government Partnership Initiative engages the watershed's
1,650 local governments in the Bay restoration effort. The Chesapeake
Executive Council followed this in 1996 by adopting the Local Government
Participation Action Plan and the Priorities for Action for Land, Growth and
Stewardship in the Chesapeake Bay Region, which address land use
management, growth and development, stream corridor protection, and
infrastructure improvements. A 1996 riparian forest buffers initiative furthers
the Bay Program's commitment to improving water quality and enhancing
habitat with the goal of increasing riparian buffers on 2,010 miles of stream and
shoreline in the watershed by the year 2010.
Since its inception, the Chesapeake Bay Program's highest priority has been the
restoration of the Bay's living resources—its finfish, 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.
-------
U.S. EPA Region III
Regional Center for Environmental
Information
1650 Arch Street (3PM52)
Philadelphia, PA 19103
The 1997 Users Guide
to Chesapeake Bay Program
Biological and Living Resources Monitoring Data
December 1997
Regional C uiuci tot Lmnonuiuiral iriformaiion
US TPA Region III
1650 ArchSt
Philadelphia, P\ IQ101
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 97-032
CBP/TRS 191/97
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).
This document is available online at http //www.chesapeakebay net/bayprogram/infobase/lr/lrscpg7 htm
Development of The 1997 Users Guide to Chesapeake Bay Program Biological and Living Resources Monitoring
Data was supported by the U S Environmental Protection Agency (Grant CB-993038-02-0) and the Interstate
Commission on the Potomac River Basin, an interstate compact river basin commission whose signatories are the U S
Environmental Protection Agency, Maryland, Virginia, Pennsylvania, West Virginia and the District of Columbia
-------
SUMMARY
This document describes how to access biological monitoring data from 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
CHESIE computer, online from the CBP Internet Home Page,
(http://www.chesapeakebay.net/bayprogram/) 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.
Currently Available Databases
Phytoplankton. Zooplankton and Benthos
Much of the phytoplankton, zooplankton (including microzooplankton,
mesozooplankton, jellyfish and ctenophores) and benthos monitoring data and data
documentation for Maryland and Virginia from 1984 to 1996 can now be obtained
directly from the Biological Data and Information World Wide Web home page; from
CHESIE by individuals with user accounts; or from the Biological Monitoring Data
Manager. 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 datasets from the ASCII flat files with conversion scripts available
from the Data Manager.
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 (http://www.vims.edu/bio/sav/mdex.html).
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.
-------
Mammals and Turtles
The Maryland Marine Mammal and Sea Turtle Strandings data from 1990-1995 is now
available by request from the Living Resources Data Manager.
Soon-To-Be-Released Databases
Waterfowl
The Annual Chesapeake Bay Midwinter Waterfowl Survey are expected to be available
in the Fall of 1998. State distribution rights/costs issues need to be resolved for other
aquatic bird surveys before they can be made available on CHESIE or on the Internet.
Finfish and Blue Crabs
The Biological Monitoring Data Manager is working with staff of the Maryland
Department of Natural Resources and the Virginia Institute of Marine Sciences to
establish distributed databases and make available the Maryland and Virginia juvenile
seine surveys and summer trawl surveys.
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
VIMS Home Page for these data.
-------
TABLE OF CONTENTS
SUMMARY i
TABLE OF CONTENTS iii
INTRODUCTION
Chesapeake Bay Program Data Center
Types of Data
Distributed Databases
The Living Resources Biological Monitoring Data Management Program
CURRENTLY AVAILABLE CBP DATA FILES 5
Point Data
GIS (Geographical Information System) Data
LIVING RESOURCES AND BIOLOGICAL MONITORING DATABASES
AVAILABLE FROM OTHER SOURCES 12
Chesapeake Bay Submerged Aquatic Vegetation Aerial Surveys (Arclnfo Coverages)
Virginia Fish Trawl Surveys (Summary Statistics and Juvenile Indices)
Chesapeake Bay Ocean Data Aquesition System Project (Imaging Acquisitions)
National Marine Fisheries Service Commercial and Recreational Fishery Landings
Reports (Database)
DATA FILES AVAILABLE SOON FROM THE CBP DATA CENTER 14
Point Data
GIS Data
Priority Datasets
DATA DIRECTORIES 16
CHESIE
CBP Internet Home Page
RELATIONAL DATABASES FOR POINT DATA FILES 18
Relational database systems
Data Format
File naming protocol
ACCESSING DATABASES 20
CBP CHESIE Computer
Obtaining data from the CBP Internet Web Page
Obtaining data on diskettes from Biological Data Manager
-------
TABLE OF CONTENTS (continued)
MERGING AND WORKING WITH RELATIONAL DATA 24
Phytoplankton and Picoplankton
Primary Production
Fluorescence
Microzooplankton and Mesozooplankton
Benthos
Submerged Aquatic Vegetation
CBP DATA CENTER CONTACTS 31
REFERENCES 32
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 CENTER CONTACTS AND
INTERNET RESOURCES
APPENDIX E: DATA ACQUISITION PRIORITIES
IV
-------
The Chesapeake Bay and Its Major Tributaries
Susquehanna / ^"v ^~—
•3 I) Mr^r
Sassafras
Patapsco ^v^'
Vy'
Potomac
Patuxent^
^
Rappahannock '"-'
.-,. Chester
Nanticoke
- -
\;s,? v , -x Wicomico
! "" l ' -'
"£ "^
i> ~i" *
Pocomoke
York
James -"^9
20
N
1
W — _ E
1
S
20
40 Miles
-------
VI
-------
THE 1997 USERS GUIDE TO CHESAPEAKE BAY PROGRAM
BIOLOGICAL AND LIVING RESOURCES
MONITORING DATA
INTRODUCTION
The 1997 Users Guide is intended to aid data users with in effectively accessing and
using biological monitoring data collected in'Chesapeake Bay and its tidal tributaries. The 1997
Users 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 and data products reside and how to obtain them. Future versions will include
guidance for obtaining scientific 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 Data Center provides data management and technical support to
program participants to accomplish the goals agreed on by the Chesapeake Executive Council.
The Data Center manages computer hardware and software, provides user support for these
computer resources, acquires and stores datasets, and provides data analysis support for CBP
activities. Recipients of Data Center services are the CBP subcommittees, CBP 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 local platforms, although an increasing number of
geographically distributed platforms and datasets are being 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 met 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. The newest additions to the data centers computing resources include: a
World Wide Web home page maintained on an Unix based, EPA Server in Research Triangle
Park, North Carolina; and a database server, running on a Microsoft NT platform, at the data
Center in Annapolis. (See Appendix D for contacts)
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.
Multiple distributed relational database systems connected via the Internet are currently being
established at the Data Center and other sites in the Watershed to allow all monitoring data to be
related and accessed.
Introduction 1
-------
The 1997 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. These types of data were described in the 1996 USEPA
Chesapeake Bay Program document Chesapeake Bay Program Information Management
Requirements and Recommendations (EPA Contract Number 01-08833-07-3872-005). These
data types can be described as follows:
CIMS Information Pyramid
Technical Reports
Publications
Summary Reports
Graphs
Charts
Interpretations
News Accounts
Press Releases
Information Summaries
High Level Interpretations
Trends
CBP Data
Primary Data
Raw Data
Figure 1. The Chesapeake Bay Information Management System (CIMS)Data Information
Pyramid
4- Technical Data - Original field sampling and laboratory results
4- Raw Data - Original field sampling and laboratory results
4- Primary Data - Information submitted and exchanged "as is" by data providers
4- Chesapeake Bay Program Data - Information reviewed (e.g. QA/QC) and
processed according 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
4- Documents - Technical Reports, Technical Publications and Summary Reports based on
analyzed data
4- Public Information - News Accounts and Press Releases based on results from data
analysis
2 Introduction
-------
The 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
The Living Resources Biological Monitoring Data Management Program
The Living Resources Biological Monitoring Data Management program focuses on the
lower levels of the data pyramid, the Technical Data and the Analyzed Data. Data at these levels
consists of:
4- "Raw data" are collected and managed offsite by the data originators - typically a
monitoring program - and are not available from the Data Center.
4- "Primary data" are the datasets 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 datasets that meet or come close to CBP standards and specifications,
and to de-emphasize use of primary data in favor of "Chesapeake Bay Program data."
4- "Chesapeake Bay Program data" are in databases 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 CHESIE and the CBP Internet
Home Page.
4- "Scientific Indicator databases" are also presently under development. These
databases of derived information will consist of analyzed data and technical 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
In 1996, the Chesapeake Executive Council, adopted the Strategy for Increasing Basin-
wide Public Access to Chesapeake Bay Information. This strategy calls for the Chesapeake Bay
Program partners to develop the Chesapeake Information Management System (CIMS). CIMS
will electronically link a variety of information about the Bay and rivers and make this
information available to anyone—from students to scientists to citizen groups —electronically
through the Internet and the World Wide Web. The information targeted by CIMS includes
technical and public information, educational material, environmental indicators, policy
documents and scientific data. (See Figure 1.)
As a result of the CIMS initiative the Bay program is working to establish a system of
distributed databases. In the ideal system, 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
Introduction 3
-------
The 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
data originators, will 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.
4 Introduction
-------
The 1997 Users Guide to CEP Biological and Living Resources Monitoring Data
CURRENTLY AVAILABLE CBP DATA FILES
Point Data
Most of the 1984-1995 phytoplankton, zooplankton and benthos monitoring data for the
Maryland and Virginia CBP monitoring programs are currently on CHESIE or the CBP Internet
Home Page as CBP databases. Data for 1996 are available as CBP databases from the Biological
Monitoring Data Manager. Plankton and benthos datasets 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)
format and scripts to convert the ASCII files into SAS files are available on request.
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 on CHESIE.ANN.EPA.GOV in the directory LRDATA:[LR.PUBLIC] and
at on the World WideWeb at http://www.chesapeakebay.net/bayprogram/infobase/lr/lrsctop.htm
include:
4- Phytoplankton taxonomic counts
4- Picoplankton 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 identifications and coverages, and ancillary water quality data (CHESIE
ONLY)
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)
Database structures (i.e. field names, definitions and attributes) for the currently available
Currently Available 5
-------
The 1997 Users Guide to CEP Biological and Living Resources Monitoring Data
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, tributaries in Maryland and the
Potomac River since July 1984. Sampling was coordinated with the CBP water quality surveys.
The data through December 1996 is available on the CBP Home Page and 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. The data through
December 1996 is available on the CBP Home Page and 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.
Picoplankton Abundance
Virginia Picoplankton Count 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. The data through December of 1996 is available on the CBP
Home Page and on CHESIE. Data files are for single calendar years and include epifluorescence
counts of picoplankton abundance. 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, tributaries in Maryland and the
Potomac River since July 1984. Sampling was coordinated with the CBP water quality surveys.
The data through December 1996 is available on the CBP Home Page and on CHESIE. 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.
6 Currently Available
-------
The 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
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. The data through December of 1996 is available
on the CBP Home Page and on CHESIE. 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.
Fluorescence (Note: These datasets 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, tributaries in Maryland and
the Potomac River since July 1984. Sampling was coordinated with the CBP water quality
surveys. The data through December of 1996 is available on the CBP Home Page and on
CHESIE. 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 in situ 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 is available from the Data Center by request.
Maryland Horizontal Fluorescence Transects. In situ fluorescence measurements were taken
along surface transects between monitoring stations in the upper Chesapeake Bay and some
tributaries in Maryland since 1984, and between monitoring stations in the Potomac River since
1989. Sampling was coordinated with the CBP water quality surveys. The data through
December 1996 is available on the CBP Home Page and on CHESIE Data files contain
calculated values of chlorophyll a. 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. 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 Loran receiver. See
Data Set Documentation found on World Wide Web or Chesie accompanying for details.
Virginia Horizontal Fluorescence Transects. Insitu fluorescence measurements were taken
along surface transects between monitoring stations in the lower Chesapeake Bay and some
Currently Available 7
-------
The 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
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 is available by request from the Data Center. Note: In
some cases sampling site positions were not determined with Geographic Positioning System
(GPS) 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 Set
Documentation found on World Wide Web or Chesie accompanying data for details.
Microzooplankton
Maryland Microzooplankton Count Files (and Related Event Files). Data have been collected at
fixed sampling stations in the upper Chesapeake Bay, tributaries in Maryland and the Potomac
River since July 1984. Sampling was coordinated with the CBP water quality surveys. The data
through December 1996 is available on the CBP Home Page and 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. The data
through December 1996 is available on the CBP Home Page and 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, tributaries in
Maryland and the Potomac River since July 1984. Sampling was coordinated with the CBP
water quality surveys. Data through December of 1996 are available on the CBP Home Page and
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 (>202/j.) count files are for single calendar
years and include taxonomic identifications of species. Biomass and Biovolume data was
8 Currently Available
-------
The 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
collected sporadically from 1985-1995 and is available from the Data Center by request. The
taxon count data through December of 1996 is available on the CBP Home Page and through
December of 1996 is available on CHESIE. 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,
tributaries in Maryland and the Potomac River since July 1984. Sampling was not coordinated
with the CBP water quality surveys. Data through December of 1996 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.
Virginia Benthic Count, Biomass, and Sediment and Bottom Water Analyses Files (and Related
Event Files). Data were collected 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 1996 are
available on CHESIE 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
datasets to the CBP database structure:
STUDY SITE DATE REFERENCE
+ Piney Point, Potomac River 1975 Virnstein & Boesch, 1975
+ Possum Point, Potomac River 1977-78 Ecological Analysts, 1979
4- Tangier Island, Chesapeake Bay 1975 Orth & Boesch, 1975
+ Amoco Refinery, Lower York River 1977 Hinde, 1981
+ Thimble Shoals, Chesapeake Bay 1981 Hobbset al., 1985
4- Warwick River, James River 1975-76 Diaz & Boesch, 1976
+ Hampton Roads to Richmond,
James River 1981 Schaffher et al., 1987
Currently Available 9
-------
The 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
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 datasets are
available on CHESIE.
Marine Mammal and Sea Turtle Standings Data
Maryland Department of Natural Resources/National Oceanographic & Atmospheric
Administration Marine Mammal and Sea Turtle Stranding Data. The MDDNR's Cooperative
Oxford Laboratory responds to all reported strandings of Marine Mammals and Sea Turtles in the
state of Maryland. Most of these strandings occur in the open ocean waters, but a few do occur
in Chesapeake Bay. The available stranding data has been reported to the CBP Data Center,
computerized and is available by request from the Biological Data Manager.
GIS (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
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 & III Migratory Fish Passage Blockages
4- Maryland Fish Passage Blockage Database
4- New York Dams Database
Submerged Aquatic Vegetation
4- Historical surveys for 1971, 1974, 1978, 1979, 1980, 1981, 1985, 1986, 1989, 1990,
1991, 1992, 1993, 1994 and 1995 (coverages are not baywide until 1978)
4- Tier I 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
10 Currently Available
-------
The 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
Habitat
Pennsylvania Stream Habitat Survey Data for Selected Streams in the Lower
Susquehanna Watershed
Cuirentlv Available 11
-------
The 1997 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 as part of the CIMS
initiative 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. Several distributed databases and
information resources presently exists for CBP data. Other distributed databases are in various
stages of development by CBP participants.
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 dataset will satisfy your needs. The Internet address for the Virginia
Institute of Marine Sciences SAV home page is:
http://www.vims.edu/bio/sav/index.html
Virginia Juvelille Fish Surveys (Summary Statistics and Juvenile Indices)
The Virginia Institute of Marine Science (VIMS) has conducted a trawl, seine and
pushnet surveys 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.fisheries.vims.edu/
12 Other Sources
-------
The 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
Chesapeake Bay Ocean Data Acquisition System (ODAS) Project
One of the objectives of this program was to improve the monitoring of changes in
phytoplankton biomass in response to nutrient reductions in the Bay. The distribution of
phytoplankton in estuaries and coastal waters is characterized by high spatial and temporal
variability. This makes it difficult to quantify phytoplankton in these regions using
measurements from ships alone. This has made remote sensing an attractive tool for sampling in
coastal areas. In Chesapeake Bay, a remote sensing program began in 1989 with the goal of
determining concentrations of chlorophyll using measurements of ocean color from aircraft.
These data have been enumerated using the Ocean Data Acquisition System (ODAS), a relatively
simple ocean color instrument that was developed in the mid-1980s by NASA's Goddard Space
Flight Center with funding from NASA and NOAA. The Internet address for the ODAS home
page is:
http://l 55.206.19.100/odas.html
The National Marine Fisheries Statistics & Economics Division Home Page
The Statistics & Economics Division of National Marine Fisheries Service (NMFS)
maintains a home page which provides a wide range of fisheries-related data collected by NMFS
for the entire country. Through these on-line data bases information on Commercial Fisheries
Landings, Fisheries Trade Information, Recreational Fisheries Landing, Fishery Market News,
and other Fisheries Economic Information pertaining to Chesapeake Bay, as well the rest of the
United States, is available. The Internet address for the NMFS Statistics and Economics Division
home page is:
http://remora.ssp.nmfs.gov/
The CBP Data Center is interested in listing and describing Chesapeake Bay living
resources and biological monitoring datasets which are presently available on the
Internet. If you know of datasets of this nature, please contact the Biological
Monitoring Data Manager at the CBP Data Center (see "CBP Data Center
Contacts").
Other Sources 13
-------
The 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
DATASETS AVAILABLE SOON FROM THE CBP DATA CENTER OR FROM
OTHER BAY PROGRAM PARTNERS
Point Data
Additional plankton and benthic datasets are currently being restructured, reformatted,
QA/QC'ed and documented, and will become available on the CBP Home Page and on CHESIE
as they are completed.
4- Taylor Phytoplankton Data
4 District of Columbia Plankton Monitoring Data (1983 - 1992)
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 establish data distributed databases and make the following
data available on 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 US 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:
Boundary Layers
4 Maryland Tributary Strategy Boundaries
4 Virginia Tributary Strategy Boundaries
14 Available Soon
-------
The 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
Habitat
•f Bay Bottom Survey (Oxford Lab)
Fish. Fisheries and Fish Passage
+ Virginia Impediment Database
+ EPA RF3 Streams by 8-digit Hue @ 1:100,000
+ Basin-wide Hydrography @ 1:24,000 (PA,MD) and 1:100,000 (remainder)
Priority Datasets
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 datasets 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 15
-------
The 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
DATA DIRECTORIES
CHESIE
The living resources data directory on CHESIE is LRDATA:[LR.PUBLIC]. The
CHESIE 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 CHESIE. 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]
Pico-plankton
Phytoplankton
Production
Fluorescence
Microzooplankton
Mezozooplankton
Benthic
SAV
I I I
VA
^ i r*
MD VA HI
\ \ I
MD VA
I I I
MD VA
I I I
MD VA
I I I
MD VA
1^ I I
MD VA HI
->
I I I
HI
Figure 2. 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.
16 Directories
-------
The 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
CBP Internet Home Page
The CBP has established a Biological Data and Information Internet Home Page. On this
page a series of menus leading to a directory of CBP biological databases has been created. The
data provided on the home page are 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
are being added as the CBP distributed databases are 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 Biological Data and Information Internet Home Page address is:
http://www.chesapeakebay.net/bayprogram/infobase/lr/lrsctop.htm
The CBP Home Page clearly requests that data users
acknowledge the original monitoring programs as the data originators
in publications which reference or use the databases.
BIOLOGICAL DATA AND
INFORMATION WEB PAGE
INTRODUCTION PAGE
INVENTORY OF TIDAL DATASETS
DATA SETS
DATA AVAILABLE
INCLUDING GtS LAYERS
SUMMARY STAT
ONLINE
UHKS TO OTHER PAGES
DOCUMENTS
FOR DOWNLOAD
REQUEST FORM
ACCESS FORM
DESCRIPTIONS
E G MANAGEMENT PLANS
MONITORING ATLAS
DATA USERS GUIDE
INDICATOR DATA
Figure 3. Diagram of the Present Biological Data and Information Web Page
Directories 17
-------
The 1997 Users Guide to CEP 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. 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.
-------
The 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
Table 1. File naming protocol for living resources monitoring datasets.
All CBP biological database or documentation files are named using the following convention:
SSDDTTYY.TXT or SSDDTTYY.ASC
HISSDDTT.TXT or HIDDTTYY.ASC
SSDDDOC.TXT or SSDDDOC.ASC
Where
SS
HI
DD
TT
YY
DOC
State Providing Data
Historic Dataset
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
for data on CHESIE.
The extension .ASC refers to the file type which is comma delimited ASCII
for data on the Chesapeake Bay Program World Wide Web home page.
State Provider Abbreviations
VA = Virginia
MD = Maryland
PA = Pennsylvania
DC = District of Columbia
NY = New York
WV = West Virginia
Data Type Abbreviations
PH = Phytoplankton
PP = Picoplankton
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
EB
Biota Sampling Event (Benthic Data Only)
Relational databases for Point Data 19
-------
The 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
ACCESSING DATABASES
CBP CHESIE 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 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
ZMODEM 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 dataset, 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.
20 Accessing Databases
-------
The 1997 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 CHESIE 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 datasets. 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: [Ir.public.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 dataset.
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.
Accessing Databases 21
-------
The 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
4) Login to CHESIE with your usemame and password.
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 datasets by typing cd LRDISK:[lr.public.*.*]. (For *.*, insert
data type and state directory names. For example, type the command cd
LRDISK:[lr.pubIic.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 dataset 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 Biological Data and Information Home Page is:
http://www.chesapeakebay.net/bayprogram/cbp_home/infobase/lr/lrsctop.htm
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 Internet access, without accounts on CHESIE, users wishing to obtain
SAS conversion scripts or users wishing to obtain the data files in dBASE (.DBF) format can
request datasets 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
22 Accessing Databases
-------
The 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
The data form may be copied. Please request only one dataset 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
Accessing Databases 23
-------
The 1997 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 data management. Providing adequate
guidance to data users on correctly handling the databases and interpreting the data is a
challange. Unsatisfactory results may be due to use of data unsuitable for the analysis or
incorrect interpretation of the information in a database. On a more basic level, incorrect
merging 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 with the end data user in mind. They assume that a user
has no previous knowledge of the data collection program. The biological datasets 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, baywide questions. Another portion of the datasets,
predominantly the historic datasets, 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 dataset 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 dataset 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 and Picoplankton
CBP Databases
These datasets 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:
DATE
STATION
LAYER
SER_NUM (optional)
24 Merging and Working with Relational Data Files
-------
The 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
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 codes 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 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) Virginia Picoplankton Counts: Picoplankton counts are available for Virginia waters
but not for Maryland. The data files are structured the same as phytoplankton data. The
count data are provided in the taxon file and are identified taxonomically as "Autotrophic
Picoplankton."
Primary Production
CBP Databases
These datasets 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 (optional)
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 RJDATE prior to May 31,
1995.
2) It should be noted that the CBP sampling protocol utilizes composite samples. There
are no samples for individual depths.
Merging and Working with Relational Data Files 25
-------
The 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
Fluorescence
CBP Databases
These datasets 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 Global Positioning System (G.P.S.). 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 were 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 datasets 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 (optional)
Mesozooplankton Biomass, Biovolume and Event files can be merged by linking the following
fields:
DATE
STATION
LAYER
SER_NUM
26 Merging and Working with Relational Data Files
-------
The 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
Please READ THE DATA DOCUMENTATION FILE before 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 taxonomic 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 (optional)'
The Microzooplankton and Mesozooplankton Taxon files can be merged provided the following
corrections are made to the mesozooplankton:
1) Mesozooplankton 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) Copepod nauplii were counted in both the mesozooplankton and microzooplankton
samples and included in both datasets. 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.
Common user errors and pitfalls for these data include:
1) Not paying attention to the life stage column. These datasets 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 codes and permanent Taxon Serial Numbers (TSN) where
Merging and Working with Relational Data Files 27
-------
The 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
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 modem 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) CBP monitoring program components collect composite 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 serjium.
Benthos
CBP Databases
These datasets require merging to be fully functional. The Virginia and Maryland CBP
monitoring programs and the historic files may be combined with no special preparation. There
are two types of sampling event files presented with the benthic monitoring data, the event and
biota event files. The Event data files contain records for all sampling events which have
occurred as part of the benthic monitoring program. This includes all instances where water
quality, sediment or biota data were collected. The Biota Event files contain only event records
for sampling events where biota samples were analyzed for content. Note: Not all sampling
events had biota data collected or have had the biota samples analyzed for content. All
Benthic Taxon, Biomass, Sediment, Water Quality, Biota Event and Event files can be merged
by linking the following fields:
DATE
STATION
(REP_NUM) for taxon and biomass files
(NETMESH) for taxon and biomass files
Protocols in the Maryland CBP benthos monitoring program diverge significantly from
those in the Virginia CBP benthos monitoring programs and the historic datasets. 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. As of January of 1996 Virginia has also added a random site selection
component to their monitoring program. It is critical to READ THE DATA DOCUMENTATION
28 Merging and Working with Relational Data Files
-------
The 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
FILE before attempting to use either the Maryland or Virginia 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 datasets.
2) One sampling gear used.
3) Sampling frequency is quarterly.
4) A random sampling component was added in 1996.
5) Water quality data for bottom of water column only.
Historic Benthic Datasets
Most of the historic benthic datasets 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 baselines to examine the
environmental effect of the operation of these facilities before and after they went
Merging and Working with Relational Data Files 29
-------
The 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
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.
These studies frequently did not measure all the parameters found in current monitoring
datasets 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 codes 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 modem 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
Datasets and GIS coverages from the annual aerial survey are one of the Bay Program's
first attempts at supporting a distributed dataset. 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 ONL Yguidelines 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.
REMEMBER: PLEASE READ THE DATA DOCUMENTATION FILES!
30 Merging and Working with Relational Data Files
-------
The 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
CBP DATA CENTER CONTACTS
The following 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@CHESIE.ANN.EPA.GOV
LRDATAMGR@CHESIE.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
The Chesapeake Bay Program Data Center Manager is:
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
Phone (local): 410-267-5671
FAX: 410-267-5666
E-mail: LBAHNER@CHESIE.ANN.EPA.GOV
CBP Data Center Contacts 31
-------
The 1997 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.
32 References
-------
-------
APPENDIX A
DATABASE STRUCTURES FOR AVAILABLE CBP DATA
December 1997
This appendix lists the field names, attributes and descriptions for
the phytoplankton, zooplankton and benthos databases which are
available through Chesapeake Bay Program Internet Home Page
and through the CHESIE on LRDISK:[LR.PUBLIC]. For
complete data documentation please see the data documentation
files which accompany the datasets at either source.
-------
The 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
Table 1. Phytoplankton and Picoplankton Count Data
LRDISK:[LR.PUBLIC.PHYTOPLANKTONJ or LRDISK:[LR.PUBLIC.PICOPLANKTON]
and http://www.chesapeakebay.net/bayprogram/infobase/lr/lrsctop.htm.
Field
Name
1 AGENCY
2 COLTYPE
3 CRUISE
4 DATE
5 DEN L
6 GMETHOD
7 LAYER
8 LBL
9 MAXDEPTH
10 R DATE
11 REP NUM
12 REP TYPE
13 SER NUM
14 NODCCODE
15 SPECCODE
16 STATION
17 TDEN L
18 TRIB COD
19 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 (YYYYMMDD)
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 and Picoplankton Event Data Files
LRDISK:[LR.PUBLIC.PHYTOPLANKTON] or LRDISK:[LR.PUBLIC.PICOPLANKTON]
and http://www.chesapeakebay.net/bayprogram/infobase/lr/lrsctop.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
P DEPTH
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
9
8
8
2
8
12
8
8
8
3
(4)
(4)
(1)
(1)
(1)
Descriptions
Data Collection Agency
Collection Type
Chesapeake Bay Program Cruise Number
Sampling Date (YYYYMMDD)
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 (YYYYMMDD)
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 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
Table 3. Primary Production Data Files
in LRDISK:[LR.PUBLIC.PRODUCTION]
and http://www.chesapeakebay.netl3ayprogram/infobase/lr/lrsctop.htni.
Field
Name
1 AGENCY
2 ASM RATIO
3 C14_D
4 C14_M
5 CARBFIX
6 CHLA
7 COLTYPE
8 CRUISE
9 DATE
10 GMETHOD
11 INS_CODE
12 LAYER
13 MAXDEPTH
14 R_DATE
15 REP_NUM
16 REP_TYPE
17 SER_NUM
18 STATION
19 TRIB COD
Field Width
Type (dec) Descriptions
Character 6 Data Collection Agency
Numeric 8 (2) Production Efficiency (ug-c/ug-chl)
Character 2 C.I. Limits Method
Character 7 Chesapeake Bay Program Analytical Method Code
Numeric 8 (2) Carbon Fixed (ug/l/hr)
Numeric 8 (2) Chlorophyll A (ug/l)
Character 2 Collection Type
Character 6 Chesapeake Bay Program Cruise Number
Character 8 Sample date (YYYYMMDD)
Character 3 Chesapeake Bay Program Gear Method
Character 5 Chesapeake Bay Program Instrument Code for C14
Measurement
Character 2 Layer in Water Column From Which Sample was Taken
Numeric 8(1) Maximum Depth of Composite Sample (meters)
Character 8 Data Version Date (YYYYMMDD)
Numeric 8 Replicate Number
Character 4 Replicate Type
Character 12 Sample Serial Number
Character 8 Sampling Station
Character 3 Tributary Code
Table 4. Primary Production Event Data Files
LRDISK: [LR.PUBLIC.PRODUCTION]
and http://www.chesapeakebay.net/bayprogram/infobase/lr/lrsctop.htm.
Field
Name
1 AGENCY
2 COLTYPE
3 CRUISE
4 DATE
5 LAYER
6 LAT
7 LONG
8 PDEPTH
9 R DATE
10 SALZONE
11 SAMVOL L
12 SER NUM
13 STATION
14 TDEPTH
15 TIME
16 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
2
8 (1)
12
8
8 (1)
8
3
Descriptions
Data Collection Agency
Collection Type
Chesapeake Bay Program Cruise Number
Sampling Date (YYYYMMDD)
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 (YYYYMMDD)
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 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
Table 5. In Situ Fluorescence Data Files
LRDISK: [LR.PUBLIC .FLUORESCENCE]
and http://www.chesapeakebay.net/bayprogram/infobase/lr/lrsctop.htm.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
Field
Name
AGENCY
CHL F
CHL F D
CHL F M
CRUISE
DATE
LAT
LONG
P DEPTH
R DATE
SALZONE
SDEPTH
SER NUM
STATION
TDEPTH
TIME
TRIE COD
Field
Type
Character
Numeric
Character
Character
Character
Character
Numeric
Numeric
Numeric
Character
Character
Numeric
Character
Character
Numeric
Character
Character
Width
(dec)
6
8
2
7
6
8
9
9
8
8
2
8
12
8
8
8
3
(2)
(4)
(4)
(1)
(1)
(1)
Descriptions
Data Collection Agency
Fluorescence Value in Micrograms Chlorophylla per Liter
Chlorophyll a Detection Limit Code
Chlorophyll a Method Code
Chesapeake Bay Program Cruise Number
Sampling Date (YYYYMMDD)
Latitude in Decimal Degrees
Longitude in Decimal Degrees
Composite Sample Cut Off Depth
Version Date of Data (YYYYMMDD)
Salinity Zone
Sample Collection Depth (Meters)
Sample Serial Number
Sampling Station
Total Station Depth (Meters)
Sample Collection Time (HH:MM:SS)
Tributary Code
Appendix A-3 Database Structures
-------
The 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
Table 6. Microzooplankton Count Data Files
LRDISK: [LR.PUBLIC.MICROZOOPLANKTON] and
http://www.chesapeakebay.net/bayprogram/infobase/lr/lrsctop.htm.
Field
Name
1 AGENCY
2 COLTYPE
3 CRUISE
4 DATE
5 DEN L
6 GMETHOD
7 LAYER
8 LBL
9 LIFE STG
10 MAXDEPTH
11 R DATE
12 REP NUM
13 REP TYPE
14 SER NUM
15 NODCCODE
16 SPECCODE
17 STATION
18 TDEN L
19 TRIB COD
20 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 (YYYYMMDD)
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 (YYYYMMDD)
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
LRDISK:[LR.PUBLIC.MICROZOOPLANKTON] and
http://www.chesapeakebay.net/bayprogram/infobase/lr/lrsctop.htm.
Field
Name
1 AGENCY
2 COLTYPE
3 CRUISE
4 DATE
5 LAYER
6 LAT
7 LONG
8 PDEPTH
9 R DATE
10 SALZONE
11 SAMVOL L
12 SER NUM
13 STATION
14 TDEPTH
15 TIME
16 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
2
8 (1)
12
8
8 (1)
8
3
Descriptions
Data Collection Agency
Collection Type
Chesapeake Bay Program Cruise Number
Sampling Date (YYYYMMDD)
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 (YYYYMMDD)
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 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
Table 8. Mesozooplankton Count Data Files
LRDISK:[LR.PUBLIC.MEZOZOOPLANKTON] and
http://www.chesapeakebay.net/bayprogram/infobase/lr/lrsctop.htm.
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 MUM
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 (YYYYMMDD)
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 (YYYYMMDD)
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
LRDISK: [LR.PUBLIC.MEZOZOOPLANKTON] and
http://www.chesapeakebay.net/bayprogram/infobase/lr/lrsctop.htm.
Field
Name
1 AEASH
2 AEDRY
3 AGENCY
4 ASH FRWT
5 ASH WT
6 AFDW
7 ASHWT
8 COLTYPE
9 CRUISE
10 DATE
11 DRY WT
12 DRYWT
13 GMETHOD
14 LAYER
15 MAXDEPTH
16 R DATE
17 REP NUM
18 REP TYPE
19 SER NUM
20 STATION
21 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 (YYYYMMDD)
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 (YYYYMMDD)
Replicate Number
Replicate Type
Sample Serial number
Sampling Station
Tributary Code
Appendix A-5 Database Structures
-------
The 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
Table 10. Mesozooplankton Biovolume Data Files
LRDISK:[LR.PUBLIC.MEZOZOOPLANKTON]and
http://www.chesapeakebay.net/bayprogram/infobase/lr/lrsctop.htm.
Field
Name
1 AGENCY
2 BEROE
3 BEROEVOL
4 COLTYPE
5 CRUISE
6 CTENO
7 CTENOVOL
8 DATE
9 GMETHOD
10 HYDRA
11 HYDRAVOL
12 JELLY
13 JELLYVOL
14 LAYER
15 MAXDEPTH
16 MNEMIOP
17 MNEMVOL
18 R DATE
19 REP NUM
20 REP TYPE
21 SER NUM
22 SET VOL
23 SET VOLZ
24 SETVOL
25 SETVOLZ
26 STATION
27 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
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 (YYYYMMDD)
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 (YYYYMMDD)
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
Appendix A-6 Database Structures
-------
The 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
Table 11. Mesozooplankton Event Data Files
LRDISK:[LR.PUBLIC.MEZOZOOPLANKTON]and
http://www.chesapeakebay.net/bayprogram/infobase/lr/lrsctop.htm.
1
2
3
4
5
6
7
8
9
Field
Name
AGENCY
COLTYPE
CRUISE
DATE
LAYER
FVOL_M3
LAT
LONG
P DEPTH
10 R_DATE
11 SALZONE
12 SER_NUM
13 STATION
14 TDEPTH
15 TIME
16 TRIB COD
Field Width
Type (dec) Descriptions
Character 6 Data Collection Agency
Character 2 Collection Type
Character 6 Chesapeake Bay Program Cruise Number
Character 8 Sampling Date (YYYYMMDD)
Character 2 Layer in Water Column Which Sample was Taken
Numeric 8 (2) Volume Filtered (M**3)
Numeric 9 (5) Latitude in Decimal Degrees
Numeric 9 (5) Longitude in Decimal Degrees
Numeric 8(1) Composite Samples Cut Off Depth (meters)
Character 8 Data Version Date (YYYYMMDD)
Character 2 Salinity Zone
Character 12 Sample Serial Number
Character 8 Sampling Station
Numeric 8 (1) Total Station Depth (meters)
Character 5 Sample Collection Time (HHMM)
Character 3 Tributary Code
Appendix A-7 Database Structures
-------
The 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
Table 12. Benthic Count Data Files
LRDISK:[LR.PUBLIC.BENTHIC] and
http://www.chesapeakebay.net/bayprogram/infobase/lr/lrsctop.htm.
Field
Name
1 SOURCE
2 SAMPLE TYPE
3 STATION
4 SAMPLE DATE
5 SAMPLE NUM
6 GMETHOD
7 CONVFACT
8 NET MESH
9 TSN
10 LIFESTG
11 LATIN NAME
12 CNT TAX
13 UNITS
14 NODCCODE
15 SPEC CODE
16 SER NUM
17 R DATE
18 BASIN
Field
Type
Character
Character
Character
Character
Numeric
Character
Numeric
Numeric
Character
Character
Character
Numeric
Character
Character
Character
Character
Character
Character
Width
(dec)
6
10
15
8
8
3
8(2)
8(3)
7
45
45
8
15
12
14
12
8
20
Descriptions
Data Collection Agency
Sample Collection Type
Sampling Station
Sampling Date (YYYYMMDD)
Replicate Number
Chesapeake Bay Program Gear Method Code
Conversion Factor (# Individual/Sample to individuals
./MeterSquared)
Screen Mesh Width (Millimeters)
National Oceanographic Data Center Taxon Serial
Number
Life Stage
Species Latin Name
Total Count of Given Taxa in Sample
Reporting Units of Value
National Oceanographic Data Center Species
Agency Species Code
Sample Serial Number
Data Version Date (YYYYMMDD)
Tributary Designation
Code
Table 13. Benthic Biomass Data Files
LRDISK:[LR.PUBLIC.BENTHIC] and
http://www.chesapeakebay.net/bayprogram/infobase/lr/lrsctop.htm.
Field
Name
1 SOURCE
2 SAMPLE TYPE
3 STATION
4 SAMPLE DATE
5 SAMPLE NUM
6 GMETHOD
7 CONVFACT
8 NET MESH
9 TSN
10 LATIN NAME
11 VALUE TYPE
12 AFDW_TAX
13 UNITS
14 NODCCODE
15 SPEC_CODE
16 R DATE
17 SER NUM
18 BASIN
Field
Type
Character
Character
Character
Character
Numeric
Character
Numeric
Numeric
Character
Character
Character
Numeric
Character
Character
Character
Character
Character
Character
Width
(dec)
6
10
15
8
8
3
8(2)
8(2)
7
45
10
12(5)
15
12
14
8
12
20
Descriptions
Data Collection Agency
Sample Collection Type
Sampling Station
Sampling Date (YYYYMMDD)
Replicate Number
Chesapeake Bay Program Gear Method Code
Conversion Factor (# Individual/Sample
to # Individuals/Meter Squared)
Screen Mesh Width (millimeter)
National Oceanographic Data Center Taxon Serial
Number
Species Latin Name
Actual or Estimated Ash Free Dry Weight
Taxon Ash Free Dry Weight (grams/sample)
Reporting Units of Value
National Oceanographic Data Center Species Code
Agency Species Code
Data Version Date (YYYYMMDD)
Agency Sample Serial Number
Tributary Designation
Appendix A-8 Database Structures
-------
The 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
Table 14. Benthic Water Quality Data Files
LRDISK:[LR.PUBLIC.BENTHIC] and
http://www.chesapeakebay.net/bayprogram/infobase/lr/lrsctop.htm.
1
2
3
4
5
6
7
8
9
10
11
12
Field
Name
SOURCE
SAMPLE TYPE
STATION
SAMPLE DATE
SAMPLE DEPTH
SAMPLE NUM
PARAMETER
VALUE
UNITS
INS CODE
R DATE
BASIN
Field
Type
Character
Character
Character
Character
Numeric
Numeric
Character
Numeric
Character
Character
Character
Character
Width
(dec)
6
2
15
8
8(1)
8
15
8
15
5
8
20
Descriptions
Data Collection Agency
Sample Collection Type
Sampling Station
Sampling Date (YYYYMMDD)
Sample Collection Depth
Replicate Number
Sampling Parameter
Sampling Parameter Value
Reporting Units of Value
Chesapeake Bay Program Instrument Code
Data Version Date (YYYYMMDD)
Tributary Designation
Table 15. Benthic Sediment Data Files
LRDISK:[LR.PUBLIC.BENTHIC] and
http://www.chesapeakebay.net/bayprogram/infobase/lr/lrsctop.htrn.
1
2
3
8
4
5
6
7
8
9
10
Field
Name
SOURCE
SAMPLE TYPE
STATION
SAMPLE DATE
TOTAL DEPTH
SAMPLE NUM
PARAMETER
VALUE
UNITS
R DATE
BASIN
Field
Type
Character
Character
Character
Character
Numeric
Numeric
Character
Numeric
Character
Character
Character
Width
(dec)
6
2
15
8
8(1)
8
15
8
15
8
20
Descriptions
Data Collection Agency
Sample Collection Type
Sampling Station
Sampling Date (YYYYMMDD)
Total Station Depth
Replicate Number
Sampling Parameter
Sampling Parameter Value
Reporting Units of Value
Data Version Date (YYYYMMDD)
Tributary Designation
Appendix A-9 Database Structures
-------
The 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
Table 16. Benthic Event Data Files
LRDISK:[LR.PUBLIC.BENTHIC] and
http://www.chesapeakebay.net'bayprograni/infobase/lr/lrsctop.htm.
Field
Name
1 SOURCE
2 SAMPLE_DATE
3 LAT
4 LONG
5 R_DATE
6 SITETYPE
7 STATION
8 TOTAL_DEPTH
9 SAMPLE_TIME
10 BASIN
Field Width
Type (dec) Descriptions
Character 6 Data Collection Agency
Character 8 Sampling Date (YYYYMMDD)
Numeric 8 (4) Latitude (Decimal Degrees)
Numeric 8 (4) Longitude (Decimal Degrees)
Character 8 Data Version Date (YYYYMMDD)
Character 4 Sampling Site Type
Character 15 Sampling Station
Numeric 8(1) Total Station Depth (Meters)
Character 5 Sample Collection Time (HHMM)
Character 20 Tributary Designation
Table 17. Benthic Biota Event Data Files
LRDISK:[LR.PUBLIC.BENTHIC] and
http://www.chesapeakebay.net/bayprogram/infobase/lr/lrsctop.htm.
1
2
3
4
5
6
7
8
9
10
11
Field
Name
SOURCE
SAMPLE DATE
LAT
LONG
PENETR
R DATE
SITETYPE
STATION
TOTAL_DEPTH
SAMPLE TIME
BASIN
Field
Type
Character
Character
Numeric
Numeric
Numeric
Character
Character
Character
Numeric
Character
Character
Width
(dec)
6
8
8(4)
8(4)
8(1)
8
4
15
8(1)
5
20
Descriptions
Data Collection Agency
Sampling Date (YYYYMMDD)
Latitude (Decimal Degrees)
Longitude (Decimal Degrees)
Sampling Gear Penetration Depth (cm)
Data Version Date (YYYYMMDD)
Sampling Site Type
Sampling Station
Total Station Depth (Meters)
Sample Collection Time (HHMM)
Tributary Designation
Appendix A-10 Database Structures
-------
APPENDIX B
BIOLOGICAL AND LIVING RESOURCES DATA DICTIONARY:
POSSIBLE FIELD NAMES
December 1997
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. Some of the terms
in this dictionary will be subject to change as the Chesapeake Bay
Information Managment System implements data dictionary
consolidation among monitoring programs.
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 Datasets.
Bold-Underlined text indicates a new parameter or an exsisting'
parameter whose name has changed for CIMS compliance
-------
The 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
CBP CODE
DESCRIPTION
UNITS
ABOVEMLW Meters above mean low water meter
ACTIV_ML 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
ANSCODE 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
ASMRATIO Production Efficiency Ratio ug-C/ug-chl A
ATEMP Air Temperature deg C
ATEMP_M Method code Table 21
BASIN Tributary or River Basin Designation char
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
CHLAM_O 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
CHLA_SK Background and spike value number
Appendix B-1 Possible Field Names
-------
The 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
CBP CODE
CHL_A
CHL_A_A
CHL_A_C
CHL_A_D
CHL_A_M
CHL_A_N
CHL_A_O
CHL_A_P
CHL_A_S
CHL_A_SK
CHL_B
CHL_B_A
CHL_B_C
CHL_B_D
CHL_B_M
CHL_B_N
CHL_B_O
CHL_B_P
CHL_B_S
CHL_B_SK
CHL_C
CHL_C_A
CHL_C_C
CHL_C_D
CHL_C_M
CHL_C_N
CHL_C_O
CHL_C_P
CHL_C_S
CHL_C_SK
CHL_F
CHL_F_A
CHL_F_C
CHL_F_D
CHL_F_M
CHL_F_N
CHL_F_0
CHL_F_P
CHL_F_S
CHL_F_SK
CKTL_VOL
CLAY
CLAY_G
CLAY_MG
CLOUD
CNIDA
CNIDAVOL
CNT
CNT_AL
CNT_DE
CNT_FE
CNTJM
CNT L
DESCRIPTION
UNITS
Trichromatic chlorophyll A (corrected for turbidity) ug/l
Analysis problem Table 28
Spike concentration number
Detection limit Table 27
Method code Table 21
Number of values for standard deviation number
Lab analysis sign-off Initial
Percent recovery %
Standard deviation of lab replicates number
Background and spike value number
Trichromatic chlorophyll B (corrected for turbidity) ug/l
Analysis problem Table 28
Spike concentration number
Detection limit Table 27
Method code Table 21
Number of values for standard deviation number
Lab analysis sign-off Initial
Percent recovery %
Standard deviation of lab replicates number
Background and spike value number
Trichromatic chlorophyll C (corrected for turbidity) ug/l
Analysis problem Table 28
Spike concentration number
Detection limit Table 27
Method code Table 21
Number of values for standard deviation number
Lab analysis sign-off Initial
Percent recovery %
Standard deviation of lab replicates number
Background and spike value number
Fluorometric chlorophyll A ug/l
Analysis problem Table 28
Spike concentration number
Detection limit Table 27
Method code Table 21
Number of values for standard deviation number
Lab analysis sign-off Initial
Percent recovery %
Standard deviation of lab replicates number
Background and spike value number
Cocktail volume - C14 production ml
Percent clay %
Clay Weight g/sample
Clay weight mg/sample
Cloud cover Table 6
Number of Cnidarians number/sample
Volume of Cnidarians ml/sample
#/sample number
#/sample of species alive number
#/sample of species dead number
#/sample of females number
#/sample of immature number
Raw count/sample of a given length number
Appendix B-2 Possible Field Names
-------
The 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
CBP CODE
DESCRIPTION
UNITS
CNTJ.M2 Normalized count/m"2 of a given length number
CNT_MA #/sample of males number
CNT_PROF #/profile sample number
CNT_SUB #/subsample number
CNT_TAX #organisms of a species/sample number
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 YYYYMMDD
DENMOOI #/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 off shore 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
DOJJ Light bottle dissolved oxygen mg/l
DO_NETPR LightlDark 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
DOCJD Documentation identification number
DODEL_DK Final DO - hit DO (dark) mg/l
DODELJ.T Final DO - Init DO (light) mg/l
DRY_WT Dry weight 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
Appendix B-3 Possible Field Names
-------
The 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
CBP CODE DESCRIPTION UNITS
JELLYVOL Volume of jellyfish ml/sample
KURT Kurtosis (Folk Method) number
LAT Latitude DEC DEC
LAYER Water column description Table 15
LATIN NAME Species Latin name char
LBL Species Latin name (may include size or lifestage descriptors) . char
LEN_CM Length of individual cm
LEN_MM Length of individual mm
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 Nitrogen-CHN analyzer (Percent) percent
NODCCODE NOAA-NODC species code Table 17
ODUCODE Old Dominion University species code char
ORP Redox potential . mv/cm
PARAMETER Parameter measured char
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
PHEAJD 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
REPJTYPE Replicate type code Table 24
SALINJ Interstitial salinity ppt
SALIN_M Salinity method code Table 21
SALINITY Salinity ppt
SALZONE Salinity zone Table 13
Appendix B-4 Possible Field Names
-------
The 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
CBP CODE
DESCRIPTION
UNITS
SAMPLE DATE Date of sample collection YYYYMMDD
SAMPLE DEPTH Sample depth from water surface meters
SAMPLE NUMBER Sample replicate number number
SAMPLE TIME Sample collection time 24 Hour time
SAMPLE TYPE Sample Collection type char
SAMVOLJ. 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
SC850 #/sample - 850 um size class number
SDEPTH Sample depth from water surface meters
SECCHI Secchi depth meters
SEGMENT Chesapeake Bay Program segment designation Table 4
SERJMUM 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 Silt weight grams/sample
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
SOURCE Data collection agency char
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
TDEN_M3 Total density per meter cubed number
TDEPTH Total water depth at station (bottom depth) meters
TIDE Tidal stage Table 8
TIM_CNT Time counted - C14 production DEC min
TIMDUR_H Duration of incubation period HHMM
TIME Sampling time 2400
TIME_BEG Beginning time HHMM
TIME_END Ending time HHMM
TOW_DUR Towing duration HHMMSS
Appendix B-5 Possible Field Names
-------
The 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
CBP CODE DESCRIPTION UNITS
TOWJ.EN 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
VALUE Parameter Value num
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
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
WTEMP Water temperature DEG C
WTEMP_M Water temperature measurement method Table 21
As part of the implementation of the Chesapeake Bay Information Management System it will be necessary
to modify the exsisting Living Resouces Data Dictionary. Changes are being implemented as the new
relational data bases come on line. As of 1 December 1997, the following Living Resources Data Dictionary
terms have been renamed for CIMS compliance. Changes have been applied to the BENTHIC MONITORING
DATA ONLY:
OLD NAME
AGENCY
COLTYPE
DATE
TIME
REP_NUM
LBL
TRIB_COD
AEAFDW
SDEPTH
TDEPTH
NEW CIMS NAME
SOURCE
SAMPLE_TYPE
SAMPLE_DATE
SAMPLE_TIME
SAMPLE_NUMBER
LATIN_NAME
BASIN
VALUE_TYPE
SAMPLE_DEPTH
TOTAL DEPTH
Appendix B-6 Possible Field Names
-------
APPENDIX C
LIVING RESOURCES DATA DICTIONARY:
EXPLANATION OF PARAMETER CODES
December 1997
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 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
Table 1. Data Collecting Agency (AGENCY or SOURCE).
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.0C
CB4.0W
CB4.0E
CB4.1W
CB4.1C
CB4.1E
CB4.2W
CB4.2C
CB4.2E
LATITUDE
39.5467
39.4400
39.3483
39.2500
39.1650
39.0033
38.9958
39.0033
38.9269
38.9272
38.9269
38.8142
38.8267
38.8167
38.6433
38.6467
38.6450
LONGITUDE
76.0817
76.0250
76.1750
76.2400
76.3083
76.3883
76.3600
76.3467
76.3947
76.4331
76.3872
76.4650
76.4000
76.3717
76.5017
76.4183
76.4017
TRIB COD
BAY
BAY
BAY
BAY
BAY
BAY
BAY
BAY
BAY
BAY
BAY
BAY
BAY
BAY
BAY
BAY
BAY
RIVER BASIN
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-I Explanation of Parameter Codes
-------
The 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
STATION
CB4.3W
CB4.3C
CB4.3E
CB4.4
CB5.1
CB5.2
CB5.3
LE2.3
CB5.4
CB5.4W
CB5.5
EE3.4
EE3.5
LE3.6
LE3.7
CB6.1
CB6.2
CB6.3
CB7.1N
CB7.1
CB7.1S
CB7.2
CB7.2E
WE4.1
WE4.2
WE4.3
WE4.4
LE5.5
CB8.1
CB8.1E
CB7.4
CB7.4N
CB7.3
CB7.3E
CB6.4
ELI1
ELI2
ELI3
WBE1
LAF1
SBE1
SBE2
SBE3
SBE4
SBE5
EBE1
EBE2
ANA01
ANA02
ANA03
ANA04
ANA05
ANA06
ANA07
LATITUDE LONGITUDE TR|B rOr> RIVER BASIN
38.5575 76.4933
38.5567 76.4367
38.5567 76.3917
38.4133 76.3433
38.3183 76.2933
38.1367 76.2292
37.9117 76.1683
38.0217 76.3500
37.8000 76.1750
37.8133 76.2950
37.6917 76.1900
37.9083 75.7917
37.7925 75.8436
37.5967 76.2850
37.5306 76.3069
37.5883 76.1625
37.4867 76.1567
37.4114 76.1600
37.7750 75.9750
37.6833 75.9900
37.5811 76.0583
37.4114 76.0800
37.4114 76.0250
37.3117 76.3467
37.2417 76.3867
37.1767 76.3733
37.1100 76.2933
36.9967 76.3033
36.9875 76.1681
36.9450 76.0250
36.9933 76.0106
37.0581 75.9731
37.1167 76.1256
37.2286 76.0542
37.2364 76.2083
36.9500 76.3458
36.8822 76.3392
36.8589 76.3256
36.8431 76.3597
36.9056 76.3061
36.8325 76.2950
36.8125 76.3061
36.7903 76.3042
36.7767 76.3000
36.7697 76.2964
36.8406 76.2894
36.8394 76.2656
38.9181 76.9419
38.9156 76.9456
38.9147 76.9503
38.9128 76.9533
38.9092 76.9561
38.9056 76.9583
38.9019 76.9606
BAY Chesapeake Bay
BAY Chesapeake Bay
BAY Chesapeake Bay
BAY Chesapeake Bay
BAY Chesapeake Bay
BAY Chesapeake Bay
BAY Chesapeake Bay
BAY Chesapeake Bay
BAY Chesapeake Bay
BAY Chesapeake Bay
BAY Chesapeake Bay
BAY Chesapeake Bay
BAY Chesapeake Bay
BAY Chesapeake Bay
BAY Chesapeake Bay
BAY Chesapeake Bay
BAY Chesapeake Bay
BAY Chesapeake Bay
BAY Chesapeake Bay
BAY Chesapeake Bay
BAY Chesapeake Bay
BAY Chesapeake Bay
BAY Chesapeake Bay
BAY Chesapeake Bay
BAY Chesapeake Bay
BAY Chesapeake Bay
BAY Chesapeake Bay
BAY Chesapeake Bay
BAY Chesapeake Bay
BAY Chesapeake Bay
BAY Chesapeake Bay
BAY Chesapeake Bay
BAY Chesapeake Bay
BAY Chesapeake Bay
BAY Chesapeake Bay
ELZ Elizabeth
ELZ Elizabeth
ELZ Elizabeth
ELZ Elizabeth
ELZ Elizabeth
ELZ Elizabeth
ELZ Elizabeth
ELZ Elizabeth
ELZ Elizabeth
ELZ Elizabeth
ELZ Elizabeth
ELZ Elizabeth
ANA Anacostia
ANA Anacostia
ANA Anacostia
ANA Anacostia
ANA Anacostia
ANA Anacostia
ANA Anacostia
Appendix C-2 Explanation of Parameter Codes
-------
SMDQN LATITUDE LQN£IIUDE JR|B_£QD RIVER BASIN
ANA08 38.8986 76.9625 ANA Anacoste '
ANA09
ANA10
ANA11
ANA12
ANA13
ANA14
ANA15
ANA16
ANA17
ANA18
ANA19
ANA20
ANA21
ANA22
ANA23
ANA24
ANA25
ANA26
ANA27
ANA29
ANA30
KNG01
KNGO2
PEC01
PEC02
PEC03
PEC04
PEC05
PEC06
PEC07
PEC08
PEC09
PEC10
PMS01
PMS02
PMS03
PMS04
PMS05
PMS06
PMS07
PMS08
PMS09
PMS10
PMS11
PMS12
PMS13
PMS14
PMS15
PMS16
PMS17
PMS18
PMS19
PMS20
38.8950 76.9625
38.8908 76.9633
38.8839 76.9692
38.8839 76.9692
38.8772 76.9722
38.8772 76.9758
38.8758 76.9806
38.8742 76.9850
38.8750 76.9886
38.8697 76.9428
38.8703 76.9469
38.8714 76.0014
38.8528 77.0050
38.8683 77.0072
38.8631 77.0094
38.8611 77.0131
38.8589 77.0172
38.8561 77.0194
38.8528 77.0208
38.8506 77.0225
38.9428 76.9675
38.8903 76.9444
38.8975 76.9661
38.8122 77.0278
38.8083 77.0244
38.8053 77.0250
38.8042 77.0244
38.8003 77.0244
38.7947 77.0250
38.7908 77.0264
38.7869 77.0225
38.7833 77.0228
38.7794 77.0283
38.9178 77.1050
38.9144 77.1028
38.9111 77.1003
38.9086 77.0964
38.7564 77.0925
38.9050 77.0883
38.9036 77.0842
38.9033 77.0797
38.9028 77.0753
38.9022 77.0697
38.9014 77.0658
38.9003 77.0617
38.8983 77.0581
38.8950 77.0567
38.8917 77.0556
38.8881 77.0544
38.8847 77.0533
38.8811 77.0522
38.8789 77.0489
38.8764 77.0383
ANA Anacostia
ANA Anacostia
ANA Anacostia
ANA Anacostia
ANA Anacostia
ANA Anacostia
ANA Anacostia
ANA Anacostia
ANA Anacostia
ANA Anacostia
ANA Anacostia
ANA Anacostia
ANA Anacostia
ANA Anacostia
ANA Anacostia
ANA Anacostia
ANA Anacostia
ANA Anacostia
ANA Anacostia
ANA Anacostia
ANA Anacostia
RC Rock Creek
RC Rock Creek
POT Potomac
POT Potomac
POT Potomac
POT Potomac
POT Potomac
POT Potomac
POT Potomac
POT Potomac
POT Potomac
POT Potomac
POT Potomac
POT Potomac
POT Potomac
POT Potomac
POT Potomac
POT Potomac
POT Potomac
POT Potomac
POT Potomac
POT Potomac
POT Potomac
POT Potomac
POT Potomac
POT Potomac
POT Potomac
POT Potomac
POT Potomac
POT Potomac
POT Potomac
POT Potomac
Appendix C-3 Explanation of Parameter Codes
-------
The 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
STATION
PMS21
PMS22
PMS23
PMS24
PMS25
PMS26
PMS27
PMS28
PMS29
PMS30
PMS31
PMS32
PMS33
PMS34
PMS35
PMS36
PMS37
PMS38
PMS39
PMS40
PMS41
PMS42
PMS43
PMS44
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
LATITUDE
38.8742
38.8719
38.8697
38.8664
38.8631
38.8600
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
38.7908
38.7869
38.7833
38.7794
38.7792
38.7758
38.7700
38.8869
38.8811
38.8797
38.8769
38.8736
38.8706
38.8669
38.8631
38.8600
38.9864
38.9603
38.9339
38.9283
38.9178
38.8944
38.9275
38.9286
38.8833
38.9275
38.8867
38.8700
38.8667
38.9083
LONGITUDE
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
77.0314
77.0328
77.0342
77.0350
77.0361
77.0364
77.0369
77.0372
77.0375
77.0375
77.0350
77.0358
77.0344
77.0344
77.0317
77.0397
77.0314
77.0281
77.0247
77.0225
77.0203
77.0203
77.0217
77.0197
77.0639
77.0442
77.0492
77.0497
77.1208
77.0750
77.1017
77.1222
76.9767
77.0833
76.9375
76.9583
76.9750
76.9625
TRIB COD
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
RC
RC
RC
RC
RC
RC
RC
RC
RC
RC
RC
RC
RC
RC
RIVER BASIN
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 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
Channel
Channel
Channel
Channel
Channel
Channel
Channel
Channel
Appendix C-4 Explanation of Parameter Codes
-------
The 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
STATION
THR04
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
XED4892
PXT0603
WXT0045
PXT0456
XDE9401
XDE5339
XDE2792
XDF0407
XCF8747
PXT0904
MET5.1
MEE2.1
MET5.2
MEE2.2
XFB2470
XFB1433
XEA6596
MAT0016
XEA1840
LATITUDE LONGITUDE TRIB COD RIVER BASIN
38.9156 76.9633
38.9225 76.9683
38.9186 76.9664
38.9156 76.9631
38.9100 76.9417
38.8317 77.0411
38.8783 76.9722
38.8683 76.9694
38.9183 76.9533
38.9033 76.9458
38.8978 76.9489
38.8956 76.9389
38.8936 76.9292
38.8908 76.9178
38.8903 76.9183
39.5750 75.9580
39.5250 75.8170
39.5080 75.9000
39.4670 75.8750
39.3670 75.8830
39.2580 75.9250
38.9920 76.2170
38.8830 76.2500
39.4330 76.2420
39.3830 76.3420
39.3000 76.4000
39.2920 76.4500
39.2080 76.5250
39.0750 76.4750
39.0170 76.5080
38.9330 76.5170
38.8830 76.5330
38.8500 76.5330
38.7100 76.7020
38.6580 76.6850
38.5820 76.6810
38.8560 76.6930
38.8140 76.7510
38.7730 76.7100
38.4910 76.6640
38.4250 76.6020
38.3790 76.5110
38.3410 76.4880
38.3120 76.4220
38.8100 76.7130
38.8070 75.9120
38.6500 76.2750
38.5800 76.0600
38.5330 76.3080
38.7060 77.0490
38.6910 77.1110
38.6080 77.1740
38.5650 77.1940
38.5300 77.2660
RC
RC
RC
RC
RC
RC
RC
RC
RC
RC
RC
RC
RC
RC
RC
CHS
CHS
PAT
PAX
PAX
PAX
PAX
PAX
PAX
PAX
PAX
PAX
PAX
PAX
PAX
CHP
CHP
CHP
CHP
POT
POT
POT
POT
POT
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 Bay
Bush
Gunpowder
Middle
Back
Patapsco
Magothy
Severn
South
Rhode
West
Patuxent
Pati jypnt
r a lu ACI 1 l
Patuxent
Patuxent
Pati jypnt
1 O IU ACI 1 1
Patuxent
Patuxent
Patuxent
Patuxent
Patuxent
Patuxent
Patuxent
Choptank
Lower Choptank
Choptank
Choptank
Potomac
Potomac
Potomac
Potomac
Potomac
Appendix C-5 Explanation of Parameter Codes
-------
The 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
STATION
MET6.1
MET6.2
MAT0078
XDA4238
XDB3321
XDC1706
XDA1177
MLE2.2
XCF9575
XCG8613
MEE3.0
MEE3.1
MEE3.2
MEE3.3
TF3.1A
TF3.1B
TF3.2
TF3.3
RET3.1
RET3.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. 1 A
TF5.5
TF5.4
TF5.5A
TF5.6
LE5.1
RET5.2
LE5.2
LE5.3
LE5.4
LE5.6
TF4.4
TF4.2
RET4.1
SUSQ4.8
SUSQ44.5
SUSQ289
SUSQ340
SUSQ365
CHEM12.0
TIOG10.8
SEEL10.3
LATITUDE
38.5330
38.3330
38.5880
38.4030
38.3880
38.3630
38.3520
38.1670
38.3250
38.3110
38.2830
38.2000
37.9670
37.9420
38.2550
38.2460
38.1750
38.0190
37.9200
37.8080
37.7610
37.6930
37.6700
37.6330
37.5720
37.5070
37.4180
37.2920
37.2350
37.5310
37.4500
37.4030
37.3120
37.3130
37.3110
37.3000
37.2750
37.2070
37.2100
37.0580
36.9900
36.9550
36.9030
37.7230
37.5800
37.5250
39.5710
40.0540
41.9850
41.9660
42.0740
42.0020
42.0290
42.0010
LONGITUDE
75.7170
75.8830
77.1190
77.2690
77.1310
76.9910
77.2050
76.5830
76.3760
76.3120
76.0170
75.9750
75.9330
75.7670
77.4120
77.2340
77.1890
76.9080
76.8220
76.7130
76.6210
76.4730
76.5540
76.4630
76.7930
76.7880
76.6930
76.5580
76.4850
77.4340
77.4200
77.3920
76.8730
77.2330
77.2970
77.1250
76.9890
76.6520
76.7930
76.5830
76.4600
76.3920
76.3330
77.0240
77.0220
76.8700
76.0920
76.5310
76.5010
75.7430
75.6370
76.4680
77.1320
76.9030
TRIB COD
POT
POT
POT
POT
POT
POT
PAX
PAX
TAN
TAN
RAP
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
SUS
SUS
SUS
SUS
SUS
SUS
SUS
SUS
RIVER BASIN
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
Rappahannock
Corrotoman
Rappahannock
Rappahannock
Mattaponi
York
York
York
York
James
James
James
Chickahominy
James
James
James
James
James
James
James
James
James
James
Mattaponi
Pumunkey
Pumunkey
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Appendix C-6 Explanation of Parameter Codes
-------
The 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
STATION LATITUDE LONGITUDE TRIB COD RIVER BASIN
CAYT1.7 42.0000 76.5230
SNAK2.3 41.9940 75.7950
DEER44.2 39.7170 76.5860
EBAV1.5 39.7250 76.5960
CNWG4.4 39.7260 76.1860
OCTO6.6 39.7070 76.1160
APAL6.9 41.9950 76.1330
BNTY0.9 42.0090 76.7300
CPBK2.0 41.9970 77.3380
CACS1.6 42.0000 75.5790
CHOC9.1 41.9910 76.0010
COWN2.2 41.9890 77.1470
HLDN3.5 42.0040 77.3930
LSNK7.6 41.9970 75.8980
NFCR7.6 41.9970 77.6230
SOUT2.8 41.9890 76.7740
TRUP4.5 41.9900 77.4920
TROW1.8 42.0000 75.7320
WAPP2.6 41.9940 76.3440
BRHR0.1 41.9960 76.3440
SACK2.6 41.9950 76.3970
PARK0.7 41.9980 76.4600
HESS0.1 41.9780 77.2500
LNGA2.5 39.7250 76.9820
SBCC20.4 39.7260 76.9810
BBCC4.1 39.7170 76.4920
FBDC4.1 39.7120 76.4430
SCTT3.0 39.7230 76.3370
N0201 40.0290 76.5170
N0202 40.2580 76.8870
N0203 40.8540 76.8060
N0204 39.8930 76.3580
N0206 40.0550 76.5260
N0207 40.0110 76.7110
N0210 40.0810 76.7180
N0211 40.1990 76.7170
N0212 40.2240 76.8610
N0213 40.2600 77.1030
N0214 40.4780 77.1290
N0217 40.6090 78.1360
N0220 40.5960 77.5730
N0223 40.2150 78.2650
N0224 40.4770 78.1780
N0228 40.7750 76.8700
N0229 40.8660 77.0490
N0231 39.9610 76.3660
N0240 40.2710 76.9150
N0243 40.3810 77.0820
N0245 40.5290 77.3920
N0249 40.3350 77.8600
N0252 40.4310 78.3630
N0301 40.9580 76.6190
N0302 41.1890 76.0870
N0303 41.3500 75.8010
SUS Susquehanha
SUS Susquehanna
SUS Susquehanna
SUS Susquehanna
SUS Susquehanna
SUS Susquehanna
SUS Susquehanna
SUS Susquehanna
SUS Susquehanna
SUS Susquehanna
SUS Susquehanna
SUS Susquehanna
SUS Susquehanna
SUS Susquehanna
SUS Susquehanna
SUS Susquehanna
SUS Susquehanna
SUS Susquehanna
SUS Susquehanna
SUS Susquehanna
SUS Susquehanna
SUS Susquehanna
SUS Susquehanna
SUS Susquehanna
SUS Susquehanna
SUS Susquehanna
SUS Susquehanna
SUS Susquehanna
SUS Susquehanna
SUS Susquehanna
SUS Susquehanna
SUS Susquehanna
SUS Susquehanna
SUS Susquehanna
SUS Susquehanna
SUS Susquehanna
SUS Susquehanna
SUS Susquehanna
SUS Susquehanna
SUS Susquehanna
SUS Susquehanna
SUS Susquehanna
SUS Susquehanna
SUS Susquehanna
SUS Susquehanna
SUS Susquehanna
SUS Susquehanna
SUS Susquehanna
SUS Susquehanna
SUS Susquehanna
SUS Susquehanna
SUS Susquehanna
SUS Susquehanna
SUS Susquehanna
Appendix C-7 Explanation of Parameter Codes
-------
The 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
STATION LATITUDE LONGITUDE
N0305 41.7650 76.4410
N0306 41.9630 75.7430
N0308 40.9950 76.4740
N0309 41.0550 76.2320
N0310 41.0710 76.1340
N0313 41.3590 75.7450
N0317 41.5580 75.8950
N0318 41.7080 76.4850
N0320 41.9960 77.1420
N0324 41.9580 77.1160
N0332 41.9780 76.5490
N0333 41.7900 76.4620
N0334 41.6970 76.2310
N0335 41.8310 76.3500
N0337 41.4160 76.0910
N0401 40.9670 76.8790
N0402 41.2290 77.0190
N0406 40.8970 78.6770
N0407 41.2170 76.7880
N0408 41.3250 76.9120
N0409 41.4180 77.0330
N0410 41.2830 77.3230
N0412 41.1260 77.4330
N0413 40.9750 77.7430
N0415 40.8900 77.7940
N0418 41.2610 77.9030
N0419 41.3200 78.0810
N0420 41.4130 78.1970
N0422 40.9860 78.4060
N0423 41.0750 77.5920
N0427 41.0750 76.8730
N0428 41.4560 76.6900
N0429 41.3090 77.3630
N0430 41.7380 77.4310
N0433 41.0750 77.4780
N0434 41.3190 77.8740
N0439 41.3340 78.1360
N0501 39.5070 77.7910
N0503 39.7330 77.2290
N0505 39.7230 78.0600
N0506 39.9270 78.6600
MET7.1 38.2670 75.7920
MET8.1 38.1420 75.8170
MET9.1 38.0580 75.8080
ANPC 38.9717 76.4633
ANPS 39.0067 76.4033
MLE2.3 38.0217 76.3483
SOL 38.3217 76.4500
TIL 38.7200 76.3333
TOLCHES 39.2133 76.2467
XDA3000C 38.4388 77.2752
XDA3000E 38.4312 77.2700
XDA3000 38.4312 77.3150
XEA4000C 38.5598 77.2385
TRIB COD
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
SEV
BAY
POT
PAT
BAY
BAY
POT
POT
POT
POT
RIVER BASJN
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
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Susquehanna
Wicomico
Manokin
Big Annemessey
Severn
Chesapeake Bay
Lower Potomac
Patuxent
Chesapeake Bay
Chesapeake Bay
Potomac
Potomac
Potomac
Potomac
Appendix C-8 Explanation of Parameter Codes
-------
The 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
STATION
XEA4000E
XEA5000C
XEA5000E
XEA6000
XEA9075
LE3.4B
LE4.3B
RET5.2A
LATITUDE
38.5632
38.5940
38.5878
38.6772
38.6720
37.6242
37.2294
37.2078
LONGITUDE
77.1930
77.2032
77.1950
77.1657
77.1322
76.4622
76.4728
76.7042
TRIE COD
POT
POT
POT
POT
POT
RAP
YRK
JAM
RIVER BASIN
Potomac
Potomac
Potomac
Potomac
Potomac
Rappahanock
York
James
Appendix C-9 Explanation of Parameter Codes
-------
The 1997 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
BAY014
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
BAY044
BEGINNING
DATE
06/15/84
07/01/84
07/16/84
08/01/84
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
08/01/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/1 5/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
08/1 5/86
CRUISE
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/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/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-IO Explanation of Parameter Codes
-------
The 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
Table 3. Cruise Identifier (continued)
CRUISE
BAY087
BAY088
BAY089
BAY090
BAY091
BAY092
BAY093
BAY094
BAY095
BAY096
BAY097
BAY098
BAY099
BAY100
BAY101
BAY102
BAY103
BAY104
BAY105
BAY106
BAY 107
BAY 108
BAY109
BAY110
BAY1 1 1
BAY112
BAY113
BAY114
BAY115
BAY116
BAY117
BAY118
BAY119
BAY120
BAY121
BAY122
BAY123
BAY 124
BAY125
BAY126
BAY127
BAY128
BAY 129
BAY 130
BAY131
BAY132
BAY133
BAY134
BAY135
BAY136
BAY137
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/1 5/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
BAY 138
BAY 139
BAY140
BAY141
BAY142
BAY 143
BAY 144
BAY145
BAY146
BAY 147
BAY148
BAY149
BAY 150
BAY151
BAY 152
BAY153
BAY 154
BAY155
BAY156
BAY 157
BAY158
BAY159
BAY 160
BAY161
BAY162
BAY 163
BAY164
BAY165
BAY166
BAY167
BAY168
BAY169
BAY 170
BAY171
BAY172
BAY173
BAY174
BAY 175
BAY 176
BAY177
BAY178
BAY179
BAY180
BAY181
BAY 182
BAY 183
BAY184
BAY 185
BAY186
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
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
Appendix C-11 Explanation of Parameter Code!,
-------
The 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
Table 3. Cruise Identifier (continued)
CRUISE
BAY187
BAY188
BAY189
BAY190
BAY191
BAY192
BAY193
BAY194
BAY195
BAY196
BAY197
BAY198
BAY199
BAY200
BAY201
BAY202
BAY203
BAY204
BAY205
BAY206
BAY207
BAY208
BAY209
BAY210
BAY211
BAY212
BAY213
BAY214
BAY215
BAY216
BAY217
BAY218
BAY219
BAY220
BEGINNING
DATE
09/16/93
10/01/93
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/0 1/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
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
ENDING
DATE
09/30/93
10/15/93
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
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
CRUISE
BAY221
BAY222
BAY223
BAY224
BAY225
BAY226
BAY227
BAY228
BAY229
BAY230
BAY231
BAY232
BAY233
BAY234
BAY235
BAY236
BAY237
BAY238
BAY239
BAY240
BAY241
BAY242
BAY243
BAY244
BAY245
BAY246
BAY247
BAY248
BAY249
BAY250
BAY251
BEGINNING
DATE
06/16/95
07/01/95
07/16/95
08/01/95
08/16/95
09/01/95
09/16/95
10/01/95
10/16/95
11/01/95
12/01/95
01/01/96
02/01/96
03/01/96
03/16/96
04/01/96
04/16/96
05/01/96
05/16/96
06/01/96
06/16/96
07/01/96
07/16/96
08/01/96
08/16/96
09/01/96
09/16/96
10/01/96
10/16/96
11/01/96
12/01/96
ENDING
DATE
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
01/31/96
02/29/96
03/15/96
03/31/96
04/15/96
04/30/96
05/15/96
05/31/96
06/15/96
06/30/96
07/15/96
07/31/96
08/15/96
08/31/96
09/15/96
09/30/96
10/15/96
10/31/96
11/30/96
12/31/96
Appendix C-12 Explanation of Parameter Codes
-------
The 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
Table 4. Original 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 datasets. However, segment codes are used in other CBP Monitoring datasets 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
RET3 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-13 Explanation of Parameter Codes
-------
The 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
Table 5. Tributary Code (TRIB_COD) and Basin Desinations (BASIN).
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:
TRIB_COD BASIN
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-14 Explanation of Parameter Codes
-------
The 1997 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. Possible 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 (WINDIR).
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:
Not Recorded
N 0 degrees, winds from the NORTH
NNE 22.5 degrees, winds from the NORTH NORTHEAST
NE 45 degrees, winds from the NORTHEAST
ENE 67.5 degrees, winds from the EAST NORTHEAST
E 90 degrees, winds from the EAST
ESE 112.5 degrees, winds from the EAST SOUTHEAST
SE 135 degrees, winds from the SOUTHEAST
SSE 157.5 degrees, winds from the SOUTH SOUTHEAST
S 180 degrees, winds from the SOUTH
SSW 202.5 degrees, winds from the SOUTH SOUTHWEST
SW 225 degrees, winds from the SOUTHWEST
WSW 247.5 degrees, winds from the WEST SOUTHWEST
W 270 degrees, winds from the WEST
WNW 292.5 degrees, winds from the WEST NORTHWEST
NW 315 degrees, winds from the NORTHWEST
NNW 337.5 degrees, winds from the NORTH NORTHWEST
Appendix C-l 5 Explanation of Parameter Codes
-------
The 1997 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 greater than 18.0 ppt
N Not Recorded
E An asterick accompanying an F, O, M, or P indicates an estimated salinity zone.
Salzone value based on salinity data NOT collected synchronous with biological data.
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 - 1cm)
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-16 Explanation of Parameter Codes
-------
The 1997 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 (10ft, 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 Reserved
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
Appendix C-17 Explanation of Parameter Codes
-------
The 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
Table 16. Sampling Gear (continued).
57 Reserved
58 Reserved
59 Reserved
60 Endico current meter
61 Branco current meter
62 Sediment trap array (6 3" X 30'' cups, W.R.Boynton, CBL)
63 Reserved
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-18 Explanation of Parameter Codes
-------
The 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
Table 17. NO AA Species Code (NODCCODE).
Reference the NOAA-NODC taxonomic code version 8.0 released in 1996. 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 the document A Comprehensive List
of Chesapeake Bay Basin Species, 1997 or on the Bay Program World Wide Web Page under
Biological Monitoring Data, Indicators and Publications as a downloadable document and as
searchable database. The data base is also searchable online at
http://www.chesapeakebay.net/bayprogram/infobase/lr/lrscpg6.htm.
NODC code tables are subject to revision on a semi annual basis.
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 GALER1CULATA
AIX SPONSA
ALOSA MEDIOCRIS
ALOSA PSEUDOHARENGUS
ALOSA SAPIDISSIMA
ALPHEUS NORMANNI
AMMODYTES AMERICANUS
ANAS RUBRIPES
CANCER BOREALIS
CENTROPRISTIS STRIATA
CHARABRAUNII
CLUPEA HARENGUS HARENGUS
ELYSIACATULUS
EURYTEMORA AFFINIS
EUTHYNNUS ALLETTERATUS
HYDRACTINIA ECHINATA
HYDRILLA VERTICILLATA
LARUS 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-19 Explanation of Parameter Codes
-------
The 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
Table 18. Life Stage (LIFE_STG).
Life stage code for biological monitoring of fish 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-20 Explanation of Parameter Codes
-------
The 1997 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 datasets but are used in other CBP monitoring datasets. They are
included here for the convience of the data user. The valid entries for this field are as follows:
GONADJ = (^Organisms 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 or VALUEJTYPE).
Biomass measurement type code.
A = Actual Measurement of Ash Free Dry Weight
E = Estimated Ash Free Dry Weight
Appendix C-21 Explanation of Parameter Codes
-------
The 1997 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
CHUM 03
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
N02102
N02103
NO23101
NO23102
N02F01
NO2F02
NO2F03
NO2F04
NO2F05
NO3101
N03102
N03103
NO3104
NO3105
NO3F01
NO3F02
NO3F03
N03F04
N03F05
N03F06
PHEA101
PHEA102
PHEAF01
PHEAF02
PHEAF03
PHEAF04
PHEAF05
PHEAF06
PHEAF07
PHEAF08
PHF01
PHF02
PHOSP101
PHOSP102
PO4F101
PO4F102
PO4F103
PO4F104
PO4FF01
PO4FF02
PO4FF03
PO4FF04
P04FF05
PO4FF06
PO4FF07
POC101
POC102
POC103
POCF01
PON101
PON 102
PON 103
PONF01
SALINF01
SECCHIF01
SI101
S1 102
SI103
S1 104
SI105
SIF01
SIF02
SIF03
SIF04
SIF05
SOE101
TCOLI101
TCOLIF01
TCOLIF02
TCOLIF03
TDN101
TON 102
TON 103
TDNF01
TDP101
TDP102
TOP 103
TOP 104
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-22 Explanation of Parameter Codes
-------
The 1997 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 Ultraviolet/Visible 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 CHEMetrics' 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-23 Explanation of Parameter Codes
-------
The 1997 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
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
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 (REPJTYPE).
This character code identifies sample types, and kinds and levels of sample replication. It is usually
used in conjunction with REP_NUM or SAMPLE_NUMBER. 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 dataset
Method comparison
Spike sample
Field split
Appendix C-24 Explanation of Parameter Codes
-------
The 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
Table 25. Sampling Media Type.
These codes are not reported in current Living Resources datasets but are used in other CBP
Monitoring datasets. 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
SEDH2O = 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 datasets but are used in other CBP
Monitoring datasets. 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 two-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
Appendix C-25 Explanation of Parameter Codes
-------
The 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
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 datasets but are used in other CBP Monitoring datasets.
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
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
Appendix C-26 Explanation of Parameter Codes
-------
The 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
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 bv 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-27 Explanation of Parameter Codes
-------
APPENDIX D
CHESAPEAKE BAY PROGRAM DATA CENTER CONTACTS
December 1997
-------
The 1997 Users Guide to CBP Biological and Living Resources Monitoring Data
The Chesapeake Bay Program Data Center Staff
Individuals without Internet access, 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 datasets 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 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@CHESIE.ANN.EPA.GOV
LRDATAMGR@CHESIE.ANN.EPA.GOV
Individuals without Internet access, wishing to obtain GIS data products can request datasets directly
from the Living Resources GIS Specialist. All requests must be made in writing. A data request form is
provided in this Appendix and can be sent to:
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: hwember@cbpws 1 .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
The Chesapeake Bay Program Data Center Manager is:
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
Phone (local): 410-267-5671
FAX: 410-267-5666
E-mail: LBAHNER@CHESIE.ANN.EPA.GOV
Appendix D-l Data Center Contacts
-------
List of frequently accessed Internet Addresses:
CHESIE
FTP://CHESIE.ANN.EPA.GOV
the directory LRDATA:[LR.PUBLIC]
THE CHESAPEAKE BAY PROGRAM HOME PAGE
http://www.chesapeakebay.net/bayprogram/infobase/lr/lrsctop.htm
THE CHESAPEAKE BAY PROGRAM LIVING RESOURCES HOME PAGE
http://www.chesapeakebay.net/bayprogram/infobase/lr/lrsctop.htm
THE CHESAPEAKE BAY PROGRAM CIS HOME PAGE
http://www.chesapeakebay.net/bayprogram/infobase/gis/gis.htm
THE VIRGINIA INSTITUTE OF MARINE SCIENCES SAV HOME PAGE
http://www.vims.edu./bio/sav/
THE VIRGINIA INSTITUTE OF MARINE SCIENCES FISHERIES HOME PAGE
http://www.fisheries.vims.edu/
THE NATIONAL OCEANOGRAPHIC AND ATMOSPHERIC ADMINISTRATION
CHESAPEAKE BAY PROGRAM OFFICE-OCEAN DATA AQUESITION SYSTEM
http://155.206.199.100/odas.html
THE NATIONAL MARINE FISHERIES STATISTICS AND ECONOMICS DIVISION
HOMEPAGE
http://remora.ssp.nmfs.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 pkzip mime compression
COMMA DELIMITED ASCII TAB DELIMITED ASCII DBF
CIS FORMATS (CHECK ALL APPROPRIATE):
COVERAGE ARC/INFO EXPORT UNIX TAR 8 MM TAPE_
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
****.**************„*********FOR BAY PROGRAM USE ONLY****
DATA PREPARED RELEASE
AND PROCESSED BY: DATE
-------
-------
APPENDIX E
DATA ACQUISITION PRIORITIES
December 1997
In 1995, the Living Resources/Monitoring Workgroup prioritized the categories
of biological monitoring data believed to be critically important to CBP
activities (Table 1, Appendix E). The workgroup recommended that key
datasets 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 January 16, 1996.
-------
-------
The 1997 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 Datasets:
Phytoplankton1
Zooplankton'
Benthos1
Seine Surveys - MD, VA, DC:
Trawl Surveys - MD, VA, DC:
Fish Passage2
Blue crab surveys2
Oyster surveys2
Water bird concentrations and distributions2
SAV3
Medium Priority Datasets:
Light (Photosynthetically Active Radiation [PAR], possibly PAR at depth)
Stream surveys2
RMAP2
1 Datasets which have been restructured (relational database with standard CBP field names),
QA/QC, documented and are presently available on CHESIE 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 datasets 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.
3 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.
Appendix E-l Data Acquisition Priorities
-------
Background
This document is one of several CBP 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
baywide, 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 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 Bay
Program Computer Center in 1993, the Living Resources Subcommittee
hired three staff persons 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 GIS coverages, b) facilitating use of the databases and
coverages, and c) providing data analysis support to the Living Resources
Subcommittee and other CBP participants. Contact the Living Resources
Subcommittee Coordinator at 1-800-YOURBAYfor more information.
-------
U.S. Environmental Protection Agency
Chesapeake Bay Program Office
410 Severn Avenue
Annapolis, MD 21403
1-800-YOUR BAY
www.chesapeakebay.net/bayprogram
------- |