PHASE 2 REPORT - REVIEW COPY
FURTHER SITE CHARACTERIZATION AND ANALYSIS
DATABASE REPORT
HUDSON RIVER PCBs REASSESSMENT RI/FS
EPA WORK ASSIGNMENT NO. 013-2N84
OCTOBER 1995
? vo
- v vy * ^
Region II
ALTERNATIVE REMEDIAL CONTRACTING STRATEGY (ARCS)
FOR
HAZARDOUS WASTE REMEDIAL SERVICES
EPA Contract No. 68-S9-2001
VOLUME 2A
TAMS CONSULTANTS, Inc.
and
Gradient Corporation
-------
PHASE 2 REPORT - REVIEW COPY
FURTHER SITE CHARACTERIZATION AND ANALYSIS
DATABASE REPORT
HUDSON RIVER PCBs REASSESSMENT RI/FS
EPA WORK ASSIGNMENT NO. 013-2N84
OCTOBER 1995
ALTERNATIVE REMEDIAL CONTRACTING STRATEGY (ARCS)
m
Region II
FOR
HAZARDOUS WASTE REMEDIAL SERVICES
EPA Contract No. 68-S9-2001
VOLUME 2A
TAMS CONSULTANTS, Inc.
and
Gradient Corporation
-------
PHASE 2 REPORT - REVIEW COPY
FURTHER SITE CHARACTERIZATION AND ANALYSIS
VOLUME 2A - DATABASE REPORT
HUDSON RTVER PCBs REASSESSMENT RI/FS
CONTENTS
Page
LIST OF TABLES iii
LIST OF FIGURES vi
EXECUTIVE SUMMARY ES-1
1. INTRODUCTION 1-1
2. DATABASE OVERVIEW 2-1
2.1 Historical Data 2-2
2.1.1 Sediment 2-2
2.1.2 Fish and Aquatic Biota 2-7
2.2 USGS Surface Water Flow and Water Quality Data 2-9
2.2.1 USGS Flow Records 2-10
2.2.2 USGS Suspended Sediment Data 2-11
2.2.3 Monitoring of PCBs in the Water Column 2-11
2.2.4 Total Organic Carbon (TOC) Data 2-12
2.2.5 Sources of Water Column Data Not Contained in Database . . . 2-12
2.3 GE Data 2-13
2.4 Staffing Gauge Data 2-14
2.5 RI/FS Phase 2 Sampling Effort 2-14
2.5.1 Water Column Transect, Flow-Averaged Sampling and
Suspended Solids Monitoring Programs 2-20
2.5.2 Confirmatory Sampling Study 2-26
2.5.3 High-Resolution Sediment Coring Study 2-29
2.5.4 Low-Resolution Sediment Coring Program 2-34
2.5.5 Ecological Program . . . . 2-35
2.5.6 Calculated Flow Data 2-37
2.6 NOAA Ecological Sampling Program 2-37
2.7 Aroclor Standard Analysis 2-38
3. DATABASE USER'S GUIDE 3-1
3.1 Assumptions 3-1
3.2 Data Dictionaries and Glossaries 3-1
3.3 Using the Data . 3-1
3.3.1 Historical Data 3-2
3.3.2 Lamont-Doherty Earth Observatory 3-7
i 1 MAS! Gradient
-------
CONTENTS (Continued)
3.3.3 USGS 3-7
3.3.4 GE Data 3-8
3.3.5 New York State Department of Transportation 3-9
3.3.6 Phase 2 Date 3-9
3.3.7 NOAA 3-15
3.4 Database Application Examples 3-16
4. REFERENCES 4-1
ii TAMS! Gradient
-------
LIST OF TABLES
Table 2-1 Studies Relating to PCB Contamination in the Hudson River
Table 2-2 Data Sets in the Reassessment Database Organized by Matrix
Table 2-3 Data Sets in the Reassessment Database Organized by Directory
Table 2-4 Sediment Sample Inventory from the 1984-1985 NYSDEC Hudson River Survey
Table 2-5 USGS Flow Monitoring Stations
Table 2-6 USGS Water Quality Monitoring Stations
Table 2-7 Laboratories Employed in Phase 2 Chemical Analyses
Table 2-8 Water Column Transect, Flow-Averaged Sampling and Suspended Solids Monitoring
Stations
Table 2-9 Water Column Transect, Flow-Averaged Sampling and Suspended Solids Monitoring
Dates
Table 2-10 Ecological Sampling Stations
Table 3-1 Data Dictionary for Table fflST_LUT in HISTORIC Directory
Table 3-2 Data Dictionary for Table PARAMKEY in HISTORIC Directory
Table 3-3 Tables in HISTORICXSED Subdirectory
Table 3-4 Data Dictionary for Table SAMPLES in HISTORIC\SED Subdirectory
Table 3-5 Data Dictionary for Table STATIONS in HISTORIGSED Subdirectory
Table 3-6 Data Dictionary for Table GRADNUMS in HISTORIC\SED Subdirectory
Table 3-7 Data Dictionary for Table SECTION in HISTORIC\SED Subdirectory
Table 3-8 Data Dictionary for Table REACHES in HISTORIC\SED Subdirectory
Table 3-9 Data Dictionary for Table CONCSED in HISTORIC\SED Subdirectory
Table 3-10 Data Dictionary for Table NONCHEM in HISTORIC\SED Subdirectory
Table 3-11 Data Dictionary for Table SOXHDUP in HISTORIGSED Subdirectory
Table 3-12 Data Dictionary for Table NONDETS in HISTORIC\SED Subdirectory
Table 3-13 Data Dictionary for Table REF in HISTORICXSED Subdirectory
Table 3-14 Data Dictionary for Table TEXTURES in HISTORICXSED Subdirectory
Table 3-15 Data Dictionary for Table GE89 in HISTORICXSED Subdirectory
Table 3-16 Data Dictionary for Table MASSPEC in HISTORICXSED Subdirectory
Table 3-17 Tables in HISTORIC\FISH Subdirectory
Table 3-18 Data Dictionary for Table GRADNUMF in HISTORICXFISH Subdirectory
Table 3-19 Data Dictionary for Table SAMPLEF in HISTORICXFISH Subdirectory
Table 3-20 Data Dictionary for Table CORRNUM in HISTORICXFISH Subdirectory
Table 3-21 Data Dictionary for Table COMPOS in HISTORICXFISH Subdirectory
Table 3-22 Data Dictionary for Table CONCFISH in HISTORICXFISH Subdirectory
Table 3-23 Data Dictionary for Table PREP in HISTORICXFISH Subdirectory
Table 3-24 Data Dictionary for Table SPECCODE in HISTORICXFISH Subdirectory
Table 3-25 Data Dictionary for Table REF in HISTORICXFISH Subdirectory
Table 3-26 Tables in HISTORIC\MACROINV Subdirectory
Table 3-27 Data Dictionary for Table SAMPLE in HISTORICXMACROINV Subdirectory
Table 3-28 Data Dictionary for Table SAMPREF in HISTORICXMACROINV Subdirectory
Table 3-29 Data Dictionary for Table NUMINDI in HISTORICXMACROINV Subdirectory
Table 3-30 Data Dictionary for Table CONC in HISTORICXMACROINV Subdirectory
Table 3-31 Data Dictionary for Table OTHER in HISTORICXMACROINV Subdirectory
Table 3-32 Data Dictionary for Table SPECCODE in HISTORICXMACROINV Subdirectory
in
T AMS/Gradient
-------
LIST OF TABLES (Continued)
Table 3-33 Data Dictionary for Table DOHSITE in HISTORIC\MACROINV Subdirectory
Table 3-34 Data Dictionary for Table USGS_LUT in USGS Directory
Table 3-35 Tables in USGS\FLOW Subdirectory
Table 3-36 Data Dictionary for All Tables in USGS\FLOW Subdirectory
Table 3-37 Tables in USGS\WQDATA Subdirectory
Table 3-38 Data Dictionary for Table USGSWQ in USGS\WQDATA Subdirectory
Table 3-39 Data Dictionary for Table TOCDAT in USGS\WQDATA Subdirectory
Table 3-40 Tables in GE Directory
Table 3-41 Data Dictionary for Table SAMPLE in GE Directory
Table 3-42 Data Dictionary for Table PCB in GE Directory
Table 3-43 Data Dictionary for Table PCBHOMOL in GE Directory
Table 3-44 Data Dictionary for Table PCBCONG in GE Directory
Table 3-45 Data Dictionary for Table NONPCB in GE Directory
Table 3-46 Data Dictionary for Table SPECCODE in GE Directory
Table 3-47 Data Dictionary for Table PCB_LUT in GE Directory
Table 3-48 Data Dictionary for Table GEPARAMS in GE Directory
Table 3-49 Data Dictionary for Table FIELD_LUT in GE Directory
Table 3-50 Data Dictionary for Table GAUGES in NYSDOT Directory
Table 3-51 Data Dictionary for Table CONG_LUT in PHASE2 Directory
Table 3-52 Data Dictionary for Table FIELDS in PHASE2 Directory
Table 3-53 Data Dictionary for Table PARAMS in PHASE2 Directory
Table 3-54 Data Dictionary for Table QUALIFY in PHASE2 Directory
Table 3-55 Data Dictionary for Table AROCLSTD in PHASE2 Directory
Table 3-56 Data Dictionary for Tables ASCREEN in PHASE2 Directory
Table 3-57 Tables in PHASE2\ WATER Subdirectory
Table 3-58 Data Dictionary for Table STATIONS in PHASE2\WATER Subdirectory
Table 3-59 Data Dictionary for Table GROUPS in PHASE2\WATER Subdirectory
Table 3-60 Data Dictionary for Tables PCBP, PCBW, PCBFA7, PCBPE, PCBWE in
PHASE2\WATER Subdirectory
Table 3-61 Data Dictionary for Tables PCBWTT, PCBWD, PCBPD in PHASE2\WATER
Subdirectory
Table 3-62 Data Dictionary for Tables NONPCBW, NONPCBWD in PHASE2\WATER Subdirectory
Table 3-63 Data Dictionary for Table FB in PHASE21WATER Subdirectory
Table 3-64 Data Dictionary for Table VOLUMES in PHASE21 WA TER Subdirectory
Table 3-65 Tables in PHASE2\SEDIMENT Subdirectory
Table 3-66 Data Dictionary for Table STATIONS in PHASE2\SEDIMENT Subdirectory
Table 3-67 Data Dictionary for Table PCBS in PHASE2\SEDIMENT Subdirectory
Table 3-68 Data Dictionary for Table PCBSD in PHASE2\SEDIMENT Subdirectory
Table 3-69 Data Dictionary for Tables NONPCBS, NONPCBSD, SIEVEGS, SIEVEGSD,
LASERGS, LASERGSD in PHASE2 \SEDIMENT Subdirectory
Table 3-70 Data Dictionary for Table FB in PHASE2\SEDIMENT Subdirectory
Table 3-71 Data Dictionary for Tables RADNUC, RADNUCD in PHASE2\SEDIMENTSubdirectory
Table 3-72 Data Dictionary for Table LRINFO in PHASE2\SEDIMENT Subdirectory
Table 3-73 Data Dictionary for Table SEDDESC in PHASE2\SEDIMENT Subdirectory
Table 3-74 Tables in PHASE2\ECO Subdirectory
iv
JAMS I Gradient
-------
LIST OF TABLES (Continued)
Table 3-75 Data Dictionary for Table STATIONS in PHASE2XECO Subdirectory
Table 3-76 Data Dictionary for Table COORDS in PHASE2XECO Subdirectory
Table 3-77 Data Dictionary for Table GROUPS in PHASE2XECO Subdirectory
Table 3-78 Data Dictionary for Table BENTHIC in PHASE2\ECO Subdirectory
Table 3-79 Data Dictionary for Table FISH in PHASE2\ECO Subdirectory
Table 3-80 Data Dictionary for Tables PCBS, PCBINV, PCBFISH in PHASE2\ECO Subdirectory
Table 3-81 Data Dictionary for Tables PCBSD. PCBINVD, PCBFISHD in PHASE2\ECO
Subdirectory
Table 3-82 Data Dictionary for Tables NONPCBB, NONPCBBD, NONPCBS, NONPCBSD,
LASERGS, LASERGSD in PHASE2KECO Subdirectory
Table 3-83 Data Dictionary for Table FB in PHASE2\ECO Subdirectory
Table 3-84 Data Dictionary for Table SPECIES in PHASE2\ECO Subdirectory
Table 3-85 Tables in PHASE2WRCORES Subdirectory
Table 3-86 Data Dictionary for Table STATIONS in PHASE2\HRCORES Subdirectory
Table 3-87 Data Dictionary for Table GROUPS in PHASE2\HRCORES Subdirectory
Table 3-88 Data Dictionary for Table PCBS in PHASE2\HRCORES Subdirectory
Table 3-89 Data Dictionary tor Table PCBSD in PHASE2\HRCORES Subdirectory
Table 3-90 Data Dictionary for Tables NONPCBS, NONPCBSD, LASERGS, LASERGSD in
PHASE2 \HRCORES Subdirectory
Table 3-91 Data Dictionary for Table FB in PHASE2SHRCORES Subdirectory
Table 3-92 Data Dictionary for Tables RADNUC, RADNUCD in PHASE2\HRCORES Subdirectory
Table 3-93 Data Dictionary for Table SEDDESC in PHASE2\HRCORES Subdirectory
Table 3-94 Data Dictionary for Table FLOW93 in PHASE2\FLOW Subdirectory
Table 3-95 Tables in NOAA Directory
Table 3-96 Data Dictionary for Table STATIONS in NOAA Directory
Table 3-97 Data Dictionary for Table COORDS in NOAA Directory
Table 3-98 Data Dictionary for Table FISH in NOAA Directory
Table 3-99 Data Dictionary for Table PCBFISH in NOAA Directory
Table 3-100 Data Dictionary for Table PCBFISHD in NOAA Directory
Table 3-101 Data Dictionary for Table NONPCBB in NOAA Directory
Table 3-102 Data Dictionary for Tables SPECIES in NOAA Directory
v
T MAS! Gradient
-------
LIST OF FIGURES
2-1 Descriptive Diagram of the Hudson River PCB Reassessment Database
2-2 Detailed Structure of the Hudson River PCB Reassessment Database
2-3 USGS Monitoring Sites in the Upper Hudson
2-4 NYSDEC 1976-78 Sediment Sampling Locations
2-5 1984 Thompson Island Pool Sediment Sampling Locations
2-6 NYSDOH Macroinvertebrate Sampling Sites, Hudson River, 1978-1985
2-7 1990 GE Sediment Sampling Locations
2-8 1991 GE Sediment Sampling Locations
2-9 1991 GE Water Column Sampling Locations
2-10 1992 GE Water Column Sampling Locations
2-11 1993 GE Water Column Sampling Locations
2-12 1994 GE Water Column Sampling Locations
2-13A Phase 2 Water Column Sampling Stations in the Upper Hudson (1993)
2-13B Phase 2 Water Column Sampling Stations in the Lower Hudson (1993)
2-14 Phase 2 High Flow Suspended Solids Monitoring Stations (1994)
2-15 Phase 2 Confirmatory Sediment Sampling Locations (1992)
2-16A Phase 2 High-Resolution Coring Sites in the Upper Hudson (1992)
2-16B Phase 2 High-Resolution Coring Sites in the Lower Hudson (1992)
2-17A Phase 2 Low Resolution Sediment Coring Locations (1994)
2-17B Phase 2 Low Resolution Sediment Coring Locations (1994)
2-17C Phase 2 Low Resolution Sediment Coring Locations (1994)
2-17D Phase 2 Low Resolution Sediment Coring Locations (1994)
2-18A Phase 2 Ecological Sampling Sites in the Upper Hudson (1993)
2-18B Phase 2 Ecological Sampling Sites in the Lower Hudson (1993)
3-1 Examples of One-to-Many Relationships from PHASE2\HRCORES Database Tables
3-2 Database Tables in HISTORIGSED Subdirectory
3-3 Database Tables in HISTORIC\FISH Subdirectory
3-4 Database Tables in HISTORIC\MACROINV Subdirectory
3-5 Database Tables in GE Directory
3-6 Database Tables in PHASE2\WATER Subdirectory
3-7 Database Tables in PHASE2\SEDIMENT Subdirectory
3-8 Database Tables in PHASE2\ECO Subdirectory
3-9 Database Tables in PHASE2\HRCORES Subdirectory
3-10 Database Tables in NOAA Directory
3-11 Table Links for Example Database Query 1
3-12 Table Links for Example Database Query 2
3-13 Table Links for Example Database Query 3
vi
TAiAS! Gradient
-------
EXECUTIVE SUMMARY
The Phase 2 Database Report describes the organization of the data collected for the Hudson
River PCBs Reassessment including both historical data, Phase 2 project data and recent data
collected by others. This Database Report is Volume 2A and addresses only the Hudson River
Reassessment database, its structure, and use. There are five additional reports (Volumes 2B
through 2F) which will be issued in Phase 2.
The report contains two main sections, specifically:
• Database Overview section which defines the database elements, explains the
sources of data, describes the organization of the data within the database itself,
and discusses the contents of each of the seven major database directories and
their subdirectories.
• Database User's Guide section which explains in considerable detail what
specific data are located in which directory, subdirectory or table and provides
(using examples from the actual database) practical examples of common queries
and applications.
Approximately 750,000 records reside in this Reassessment database. The database is organized
into over 100 database tables and spreadsheets. The entire data set is available from USEPA
in DOS-compatible format on CD-ROM, a "read-only" (i.e., the data can only be viewed)
compact disk which looks exactly like an ordinary audio CD but is formatted for use by
computer according to standards for computer data organization. The database on CD-ROM will
be in two database formats, Paradox™4.0 and FoxPro™/DBase IIF*.
The database is a combination of historical data collected prior to this Reassessment and field
data gathered during Phase 2 of the Reassessment, from sampling programs conducted by
USEPA and from complementary programs performed by other investigators (e.g., GE, NOAA,
etc.) which are relevant to this project. There are seven major directories in the database:
HISTORIC, LDEO, USGS, GE, NYSDOT, PHASE 2 and NOAA. Each of these main directories
are described more fully in the Report. Figure ES-1 represents an overview schematic of the
Reassessment database structure showing the major directories and subdirectories and a general
description of the directory contents.
The database created for the Reassessment provides the foundation for all studies to be
performed by the USEPA for the Reassessment RI/FS.
ES-1
TAMS/Gradient
-------
PAGE INTENTIONALLY LEFT BLANK
E-2 T AMS/Gradient
-------
Reassessment Database
GE
'Sediment
Water
Biota
USGS
FLOW WQDATA
| Discharge | ( Water \
[ | I Quality I
Legend:
HISTORIC
(NYSDEC\
I NYSDOIlJ
FISH
SED
(Sediment
LDEO NOAA NYSDOT
[Sediment |
^ Water I
MACROINV
(Macro- ^
invertebrates I
PHASE2
SEDIMENT
Low-Resolution
Coring and
Confinnatory
Sampling
WATER
f Water x
Column
Studies
HRCORES
/ \
High- A
Resolution
Coring
ECO
Ecological
Investigation
USGS - Main Directory
WQDA TA - Subdirectory
Fish
NYS
Champlain
Canal Guage
Data
FLOW
1993 Discharge
( NYSDEC
NYSDOT - Directory contents description
V GE /
TAMS/Gradient
Figure ES-1
Descriptive Diagram of the Hudson River PCB Reassessment Database
-------
PAGE INTENTIONALLY LEFT BLANK
E-4 T AMS! Gradient
-------
1. INTRODUCTION
This document provides a description and guide to the extensive database created for the
Hudson River PCBs Reassessment Remedial Investigation/Feasibility Study (RI/FS). The
database contains information obtained from a variety of sources: New York State Department
of Environmental Conservation (NYSDEC), New York State Department of Health (NYSDOH),
New York State Department of Transportation (NYSDOT), General Electric Company (GE),
the Lamont-Doherty Earth Observatory (LDEO), the United States Geological Survey (USGS),
the National Oceanic and Atmospheric Administration (NOAA), as well as the United States
Environmental Protection Agency (USEPA).
In December 1990 USEPA issued a Scope of Work for reassessing the 1984 No Action
decision for the Hudson River PCB site which identified the three phases as follows:
• Phase 1 - Interim Characterization and Evaluation
• Phase 2 - Further Site Characterization and Analysis
• Phase 3 - Feasibility Study
The Phase 1 Report is Volume 1 of the Reassessment documentation and was issued by
USEPA in August 1991. It contains a compendium of background material, discussion of
findings, where findings could be made, and preliminary assessment of risks. The
TAMS/Gradient team compiled a database of historical data to complete the Phase 1 work. The
database issued with this report represents an expansion of the previous compilation due to the
increase in new data collected or researched since the earlier work was performed. This
database provides the most comprehensive data set available to date for investigating PCBs in
the Hudson River.
This Database Report is Volume 2A of the Reassessment documentation and is one of
a series of reports in Phase 2. Companion Phase 2 documents are planned to include the
Preliminary Model Calibration Report (PCB fate and transport modeling), the Data Evaluation
and Interpretation Report (results of the Phase 2 investigations). Baseline Modeling Report
(baseline models used in the ecological and human health risk assessments), the Human Health
Risk Assessment Report and the Ecological Risk Assessment Report.
This Database Report includes two chapters following this brief introduction,
summarizing the contents of the database and its sources (Chapter 2) and directing the data users
through specific example queries and pertinent database details (Chapter 3). To facilitate
widespread and relatively easy use of the data set itself, this report contains details of database
design including listing of database tables, names and descriptions of fields, and relationships
between database elements. Additional tables of information are included as glossary tables
within the database itself to also assist the user. The data set is considered part of this report
and is available on CD-ROM in DOS-compatible format from the USEPA.
1-1
T MAS! Gradient
-------
It should be noted that the inclusion of non-USEPA data in the data set does not
constitute any approval, validation or certification of the data by the USEPA. Since these data
were not produced specifically for the USEPA, the USEPA cannot be responsible for any errors
they contain. Users of the non-USEPA data tables should refer to the original documents
containing these data for clarification of data quality and potential uses. In some cases, the user
will need to refer to the original documents for specific information concerning sample locations
and descriptions. The non-USEPA data provided in the database were reviewed and used as
needed in this Reassessment, and are included in the database for completeness.
1-2
T AM Si Gradient
-------
2. DATABASE OVERVIEW
In simplest terms, a database is an organized collection of information. The classic
example of a database is the telephone book which organizes information about people: names,
phone numbers, and addresses. A relational database arranges distinct categories of information
into tables where data are accumulated as rows or records in columns or fields. Relationships
or links between fields are explicitly defined so that information may be drawn from multiple
tables. Data dictionaries defining the names and sizes of table fields are provided for all
dataha^fi tables. The database elements are summarized below.
• Relational Database
Collection of computer files that store data
in the form of tables
• Record
Row in a database table
• Field
Column in a database table
• Links
Relationships between database tables
based on common fields (columns)
• Data Dictionary
Table that defines data table fields
• Data Glossary
Computer file that contains the definitions
of parameters and terms used in the
database
TAMS/Gradient has used the relational model in developing the Hudson River database.
Because of the quantity of information, the Hudson River database is organized by sampling
program and by environmental medium. The database tables are organized into several basic
elements, including chemical concentration data, sampling information, and reference
information. The basic elements may be composed of many tables that are linked together. The
organization provides a means for efficient data management.
The extensive size of the database is dictated by the large number of monitoring efforts
which have taken place in the Hudson. During the early 1970s, NYSDEC and several other
agencies began the first comprehensive monitoring studies for PCBs in the Upper Hudson. Fish,
which were some of the earliest environmental samples analyzed, showed high concentrations
of PCBs. These early investigations began over two decades of studies to date on PCBs in
2-1
T AMS/Gradient
-------
water, sediments, fish and other media affected by PCB discharges to the Upper Hudson. Table
2-1 summarizes the major investigations.
Of the many investigations listed in Table 2-1, nearly all are represented in some fashion
in the Reassessment database. In general, only those data which were explicitly used in the
Reassessment were included in the database. Thus, not every dataset represented in Table 2-1
is included in its entirety in the Reassessment database. Nonetheless, the non-Phase 2 data
contained in the database represent more than 400,000 of approximately 750,000 records in the
Reassessment database.
Figure 2-1 shows the seven major directories for the Reassessment database. Also shown
are the subdirectories for each of the major directories. This figure provides descriptive titles
of the directories along with some notation concerning the agency or type of data contained in
the directory. For those readers who are unfamiliar with computer terminology, a directory is
similar to a filing cabinet. Subdirectories, in turn, are similar to the individual drawers of the
cabinet, which contain the individual files (or tables) in the database. The report maintains
certain conventions when referring to specific database elements. When a file directory or
subdirectory is noted in the text, it is in italics and capital letters, e.g., HISTORIC\SED.
Database table names are in capital letters and bolded, e.g., STATIONS. Database fields are
in bold text and written as they appear in the tables, e.g., Yr or Ref.
Figure 2-2 shows the Reassessment database structure in more detail, providing exact
directory and subdirectory names as well as the names of all files contained in the database.
Table 2-2 provides a summary of the data sets contained in the database and Table 2-3 describes
the contents of the subdirectories for each of the seven major directories.
In the remaining portions of this chapter, the contents of each of the seven major
directories along with their subdirectories are described. These descriptions provide the original
source of the information contained in the Reassessment database as well as a general description
of the data itself, including the number of samples and the types of analyses. These descriptions
are not intended to address the quality or interpretation of these data. These discussions will be
found in subsequent Phase 2 documents.
2.1 Historical Data
2.1.1 Sediment
This section reports on the data sets contained in the HISTORIC\SED subdirectory: the
NYSDEC 1976-78 surveys, the 1984 NYSDEC Thompson Island Pool Sampling, and the 1989
and 1990 GE sediment sampling efforts. So that each record is explicitly classified in the
database tables, the Yr and Ref fields identify the year the sample was collected and the data
source, respectively. Data sources for the historical sediment component are shown in Table
2-3A. Unless otherwise noted, the data are organized within the main database tables of the
HlSTORIC\SED subdirectory.
2-2
1 MAS! Gradient
-------
1976-78 NYSDEC Sampling
As reported by Tofflemire and Quinn (1979), NYSDEC conducted several sediment
sampling surveys in the Hudson River between 1976 and 1978. Details of the sampling and
analysis procedures for these studies are summarized in NYSDEC Technical Report No. 56
(Tofflemire and Quinn, 1979).
The data provided to TAMS/Gradient by NYSDEC as printed results represent a total
of 1,167 sediment samples, 396 core samples and 771 grab samples, collected during 1976,
1977, and 1978; 1,770 PCB analyses were reported for the 1,167 samples. The overwhelming
majority of samples from the 1976-78 data set correspond to locations in the Upper Hudson
River, i.e., 1,091 of the 1,167 samples. Of the remaining samples, only five samples in this
data set have locations recorded in the Lower Hudson River, and each of these five was from
River Mile 153, just south of the Federal Dam at Troy. One anomalous sample was reported
for River Mile 105.2; however, its northing value, 1,166,970 feet, corresponds to a location
within the Upper Hudson River. A total of 70 samples had no information regarding river mile
or northing-easting coordinates, and therefore could not be considered in subsequent data
evaluation. Figure 2-4 shows the NYSDEC sampling locations.
TAMS/Gradient encountered some difficulty matching the contents of the database with
the data summaries provided in the original data reports. The differences in the overall number
of samples is detailed in the Phase 1 Report.
Aroclors 1016, 1221, and 1254 were identified as the PCB mixtures detected in the 1976-
78 sediment sampling effort. Analytical quantitation limits were not reported in this data set,
and no indication was given regarding whether a sample had detectable or nondetectable
concentrations of PCBs. However, several concentrations (1 ppm, 5 ppm, 10 ppm) occur with
great frequency, suggesting that these concentrations are probable quantitation limits for these
samples.
1984 Thompson Island Pool Sampling
In 1984, NYSDEC undertook an extensive sediment sampling program in the Thompson
Island Pool (Brown et at., 1988); The objective of this study was to characterize areas of
contaminated sediments that would be removed during the Hudson River PCB Reclamation
Demonstration Project, focusing primarily on the 20 hot spots previously identified in the
Thompson Island Pool and other areas with known or suspected high PCB concentrations.
The investigators identified 1,260 sampling locations in the approximately five-mile reach
of the river from Thompson Island Dam north to Rogers Island (See Figure 2-5). Many of these
locations were determined by imposing a 125-foot triangular grid on previously defined hot spots
and on additional areas with isolated PCB concentrations in excess of 50 ppm during the 1983
USEPA survey (NUS, 1984). In addition, sample locations were selected based on known or
suspected sediment depositional areas, as indicated by location in the river and bathymetric
2-3
TAMS/Gradient
-------
measurements. Sample locations in the field were determined electronically using a microwave
locating system.
Samples for the NYSDEC survey were collected by Normandeau Associates, Inc.
between August 24 and November 30, 1984. In addition, 21 cores were collected from
February 1 through 4, 1985; these later samples were collected through ice on the river at
locations that had been inaccessible by boat. Table 2-4 provides a description of these data
along with a comparison to the results reported by Brown et al., 1988. The database compiled
and supplied by NYSDEC to the TAMS/Gradient team contains 2048 records, including
duplicate samples and reanalyses. These data represent 408 individual coring sites and 675 grab
sample sites (including two sites with no coordinates given). The database includes some 24 co-
located resamples representing 23 grabs and one core, with identical site numbers but slightly
different location coordinates. The database also contains an additional 35 grab samples and 25
core samples with duplicate analyses. Of the 35 grab samples, 29 appear to be duplicate
analyses (i.e., field duplicates with the same date and same location), while 6 pairs, taken on
different days, appear to be resamples at an exact duplicate location. All the core duplicate
samples represent duplicate analyses. Although this dataset was supplied by NYSDEC, it is
somewhat larger than the results reported by Brown et al., 1988. Brown et al. reported a total
of 407 cores and 607 grab samples in their analyses. The small difference in the total number
of cores reported apparently represents rejection of positioning data for one core at station 264.
The reason for the larger discrepancy in the number of grab samples reported is unclear.
Samples with field duplicate analyses are labelled with a "D" in the Dup field of the
SAMPLES database table. This "D" indicates that two analyses are available for the particular
sample for PCBs and conventional parameters. In the CONCSED, MASSPEC and
NONCHEM tables, the Dup field is used only to designate the second analysis in a pair of field
duplicates. The first analysis in a duplicate pair will have a blank entry in the Dup field while
the second will have identical GradNo and Section labels but will be labelled "Dl" in the Dup
field. CONCSED contains 53 duplicate pairs for the 1984 data while NONCHEM and
MASSPEC contain 54 duplicate pairs.
As part of the 1984 sediment survey, NYSDOH and Versar, Inc. measured physical and
chemical parameters of the sediments collected in this study. NYSDOH determined lengths of
cores and sections, percent dry solids, dry specific weight (density), and textures (determined
visually). Versar measured percent volatile solids and performed the gas chromatograph
analyses for PCBs.
In this investigation, PCB concentrations were screened using gas chromatography with
a mass spectrometer (GC/MS) and quantitated by gas chromatography with an electron capture
detector (GC/ECD). The GC/MS analyses were used primarily as a screening method to
determine which samples would be quantitated using the more accurate (and more expensive)
GC/ECD analysis. The GC/MS screening classified samples into one of four categories of total
PCB concentrations: less than 10 ppm (< COLD >), 10 to 50 ppm, 50 to 100 ppm, and greater
than 100 ppm (*HOT*). Most samples screened into the higher categories were analyzed further
2-4
T AMS/Gradient
-------
using the GC/ECD method; conversely, many samples that exhibited low PCB concentrations
by GC/MS were not quantitated by GC/ECD. Additional information on the screening levels
can be found in HJSTORIC\SED\NONDETS file.
Versar quantitated PCBs as Aroclors 1242, 1254, and 1260 using the method of Webb
and McCall (1973). Although the data received from NYSDEC contained a "total PCB"
quantification, no mention is made in Brown et al. (1988) of the method used to quantify, or
calculate, this total. Examination of the data received indicates that the total was not simply the
sum of the three Aroclor mixtures quantitated.
The database supplied by NYSDEC contains a total of 926 GC-ECD analyses for PCBs,
slightly less than the 954 reported by Brown et al. as shown in Table 2-4. The database also
contains a record of 1536 samples screened by mass spectrometry. This is greater than the 1125
samples reported by Brown et al., and likely reflects the presence of additional grab samples.
A total of 497 samples were reported as analyzed by both GC/ECD and GC/MS and mass
spectrometry in the database, matching the number reported by Brown et al.
GE 1989 Baseline Studies for the Remnant Deposit Containment Project
As part of the Remnant Deposit Containment Project, General Electric, with USEPA
oversight, conducted baseline pre-remediation sediment monitoring (other related monitoring
efforts are discussed for the affected media). Sediment samples were collected at five locations
in the vicinity of the remnant deposits: one location near Rogers Island; one location far
upstream; one location between the remnant deposits and Bakers Falls; and two downstream
locations near Lock 6 and Waterford. With the exception of samples from the two downstream
locations, PCBs were detected in all samples. The chromatograms were compared against
Aroclor mixtures 1221, 1232, 1016, 1242, 1248, 1254, and 1260; Aroclor mixtures detected in
the samples were reported to be a construction of Aroclors 1242 and 1254. Because these
earlier data were only quantitated on an Aroclor basis and were not validated by GE and its
subcontractors, they are considered by GE to be of lower quality than later data. Subsequent
GE PCB analyses were validated by GE and also provided more analytical detail including, for
example, quantitation of homologue groups. As a result, the 1989 study data were provided
separately from other data files by GE. Maintaining this distinction, the 1989 sample records
are not contained in the main database tables in the HIST0R1C\SED subdirectory. Instead, these
data reside in a table called GE89 in the same HIST0R1C\SED subdirectory.
GE 1990 Sediment Sampling for Bioremediation Investigations
General Electric has been conducting extensive research on biological dechlorination and
degradation processes occurring within the river which may have altered the composition of the
PCB Aroclor patterns within the sediments. In conjunction with these studies, GE has collected
samples from selected areas of the Upper Hudson for more detailed evaluation. General Electric
provided USEPA with preliminary results of their sediment sampling activities during a meeting
on February 28, 1991, and confirmed by a letter dated March 8, 1991 (Claussen, 1991).
2-5
T AMS/Gradient
-------
In this effort, Harza Engineering collected 103 cores from 12 hot spots during 1990 and
reported 275 PCB analyses. From three to eight cores were collected at most locations, with
the exception of GE's "H-7" location where 62 cores on a 12-foot by 12-foot grid were
collected. Samples were analyzed for PCB homologue groups and for five Aroclors, i.e., 1221,
1242, 1254, 1260, and 1268. These results are included in the sediment portion of the historical
database and are identified as being from Harza by the entry in the Agency field of the
GRADNUMS database table.
Lamont-Doherty Geological Observatory Investigation
The Lamont-Doherty Geological Observatory (now called the Lamont-Doherty Earth
Observatory, LDEO), under contracts to several agencies, conducted several field surveys of
PCB levels in the sediments, suspended matter and water column of the Hudson River over the
period 1976 to 1988 (Bopp, 1979; Bopp et al. 1982; Bopp, 1983; Bopp et al., 1985; Bopp et
al., 1988; and Bopp and Simpson, 1989). The Observatory also conducted a study of PCB
sediment to water partitioning under a contract with NYSDEC (Warren et al., 1987). The field
surveys included collection of dozens of cores covering the Hudson River from above Hudson
Falls to the New York City Harbor. Many sections of the cores were analyzed for radionuclides
to establish core chronologies as well as for PCB concentrations, with an emphasis on
homologue- and congener-specific information. Three cores are included in the Reassessment
database under the LDEO directory. In addition, the results of the PCB water-to-sediment
partitioning study are included as well. These tables are distinctly different from the remainder
of the Reassessment database tables. Specifically, these tables exist in Lotus 1-2-3™ format and
contain data and descriptive text. These tables, which are not relational databases, are listed on
Table 2-3.
Other Sources of Sediment Data Not in the Reassessment Database
In August 1983, USEPA conducted a limited study to collect sediment samples from
locations that had been sampled in 1976 to 1978 (NUS, 1984). Over sixty core and grab
samples were collected within a nine-mile stretch of the river south of Rogers Island, including
the Thompson Island Pool. Forty-two samples were collected from within or on the border of
previously determined hot spots.
In addition to PCBs in river sediments, other chemicals, particularly heavy metals, were
measured during the 1976-78 NYSDEC study (Tofflemire and Quinn, 1979), the 1984
Thompson Island Pool study (Brown et al., 1988), and by other investigators. Lead, cadmium,
zinc, chromium, mercury, and other metals were measured.
Relatively few sediment samples have been tested for other organic priority pollutants.
Four sections of two cores collected in 1983 by Dr. Richard Bopp between River Mile 188.5
and 191.1 were submitted to NYSDOH and analyzed for dioxin and dibenzofurans. Six
sediment samples collected in 1987 from three hot spots were analyzed for dioxins,
dibenzofurans, volatile and semi-volatile organics, and pesticides (Brown et al1988). With
2-6
T AM SI Gradient
-------
the exception of dibenzofurans, none of these organic parameters were detected in the 1987
samples.
2.1.2 Fish and Aquatic Biota
The database contains data for approximately 11,000 historical fish samples under the
subdirectory HIST0RIC\F1SH for the period 1973 through 1993. These files contain data for
both the Hudson River proper and tributaries. These Hudson River proper data can be
distinguished from the other data because a river mile identifier has been assigned only to
Hudson River samples; this field is blank for samples from tributaries or ocean water beyond
the Verrazano-Narrows Bridge. Additional data for other aquatic biota (macroinvertebrate and
multiplate data) account for several hundred additional samples. These data are found in the
HISTORIC\MACROINV subdirectory. NYSDOH monitored multiplate samples and chironomid
larvae from 1973 through 1985. A discussion of the specific fish/biota studies from which data
have been extracted for the database is provided below. Table 2-3 lists the data sources.
NYSDEC Fish Sampling
Data exist on concentrations of PCBs in Hudson River fish collected by NYSDEC
between 1970 and 1993. While over 30 species of fish are represented in the data, 75 percent
of the samples are from a half-dozen species including striped bass, largemouth bass, brown
bullhead, pumpkinseed, american shad, and american eel. Approximately two-thirds of the
samples tested were standard fillet samples, with most of the remainder being whole fish. The
type of sample is identified by the Prep field for sample preparation in the database. In the
database, sampling information identifies the species, sex, age, sample weight and length,
whether the samples represent composites or individuals, as well as date and location, i.e., river
mile of sample collection, and data source.
Samples Collected Prior to 1975
While polychlorinated biphenyls are known to have been discharged into the Upper
Hudson River since the 1940s, no testing for PCBs in fish is known to have been undertaken
before 1970. Summary statistics of results for fish samples collected and analyzed for PCBs in
the period 1970 through 1974 are reported by Spagnoli and Skinner (1977); however, the
complete data set for this period are unavailable. These samples include one smallmouth bass
collected at Warrensburg and 146 fish representing 11 species collected below the Troy Dam.
In August 1974, a team from USEPA Region II visited the Fort Edward, NY area and obtained
water, sediment and fish samples from upstream and downstream of the GE discharge in Fort
Edward. Samples collected prior to 1975 can be identified by the entry in the sample year field
(Yr).
2-7
TAMS/Gradient
-------
Samples Collected from 1975 to 1976
NYSDEC undertook more detailed monitoring of PCBs in fish from both the Upper and
Lower Hudson during 1975 and 1976. A total of 440 Hudson River fish samples were analyzed
in this period and results have been provided by NYSDEC. These data have been merged with
the earlier data in the HISTORIC\FISH subdirectory.
The 1975 to 1976 fish collections were made by regional NYSDEC Fish and Wildlife
personnel who were instructed on specific species and sizes of fish desired, location of stations
and time tables for collection. Target species for the Hudson included smallmouth bass,
largemouth bass, brown bullhead, goldfish, white sucker, striped bass and various other
estuarine species. Other species were occasionally obtained as available. The sample species
is identified via the species code in the Species field of the database. Attempts were made to
sample small, medium (minimum legal) and large representatives of each species.
Samples Collected from 1977 through 1993
By 1979, NYSDEC monitoring methods had been refined and standardized. NYSDEC
has provided data covering the period 1977 through 1993 (Sloan, 1994), which include fish and
fish composite analyses. Samples were collected on a regular basis, with the intent of sampling
selected species at predetermined locations within two-week intervals to minimize potential
seasonal effects. Sample collection, preparation, and analytical methods are described in
Armstrong and Sloan (1981), Sloan and Horn (1986), and Sloan et al. (1988). In 1979, a
special project was started to monitor PCB accumulation based on a single year of exposure.
For this project, yearling pumpkinseed were selected due to their abundance and non-migratory
behavior.
Analyses were conducted by several different state laboratories, apparently using the
methodology of Bush and Lo (1973), and reported against standards for Aroclor 1254 and either
Aroclor 1242 or 1016. Aroclor 1221 was not analyzed. The nominal quantitation limit of the
method was 0.01 ppm, although some of the laboratories reported results only as low as 0.1
ppm. NYSDEC determined total PCBs as the sum of Aroclors 1242, 1016, and 1254 for these
data.
NYSDOH Macroinvertebrate Studies
As part of the Hudson River PCB Reclamation Demonstration Project, NYSDOH
conducted biomonitoring studies from 1976 through 1985 using caddisfly larvae, multiplate
samples, and chironomid larvae (Simpson et al., 1986). These studies included long-term
biomonitoring efforts over the entire period, as well as two short-term biological uptake studies
in July and September of 1985. From 1976 through 1985, artificial substrate samplers
(multiplates) were placed at 17 sites along the Hudson River from Hudson Falls to Nyack, New
York (Novak et al., 1988) (See Figure 2-6). These samples were collected over a period of five
weeks occurring during the months of July, August and September and were analyzed for
2-8
TAMSt Gradient
-------
concentrations of Aroclors 1016 and 1254. The resulting PCB concentrations in the multiplate
samples represented a composite of concentrations in sediment, algae, plankton, and various
macroinvertebrates. Invertebrates collected in the multiplate samplers included the following
taxonomic groups: Chironomidae, Oligochataeta, Trichoptera, Ephemeroptera, Amphipoda, and
Elimidae. Chironomid larvae and pupae were the most abundant invertebrate component from
Fort Edward to Saugerties, comprising up to 86 percent of the total macroinvertebrate population
at Fort Miller and Waterford.
From 1978 through 1985, caddisfly larvae were collected by hand-picking individuals
from rocks at five designated sites: Hudson Falls, Fort Edward, Fort Miller, Stillwater, and
Waterford. Caddisfly collections were made in June, July, August and September of each year.
Short-term biomonitoring investigations using the chironomid larvae, Chironomus tentans,
were also performed by NYSDOH during July and September 1985 (Novak et al., 1990). The
monitoring method consisted of placing 25 laboratory-reared chironomid larvae in nylon mesh
envelopes or packets that were exposed to the water column. Envelopes were placed in groups
of ten in steel mesh baskets at the primary collection site and monitored at 0, 1, 2, 4, 8, 12, 24,
48, 72, and 96 hours. Chironomids were placed at four sites, including two at Thompson Island
Pool, one at Bakers Falls and one at Fish Creek, and monitored at 96 hours. Packets of
chironomids exposed to the sediment at a collection site located on the eastern shore of the
Thompson Island Pool were also collected at 96 hours.
The macroinvertebrate data provided in the database were obtained directly from
NYSDOH reports. The locations of the samples are defined by a simple code referring to the
17 sites. These sites are defined in the DOHSITE data table of the HISTORIC\MACROINV
subdirectory. The species monitored as part of these studies were identified in the original
reports with a simple number code from 1 to 9. No documentation was found to define these
codes. These identifier codes are given in the Species field of the SAMPLE data table. The
results of the study which dealt explicitly with caddisfly larvae have an assigned species code
value of 20 in the Species field.
2.2 USGS Surface Water Flow and Water Quality Data
The U.S. Geological Survey (USGS) has maintained numerous surface water monitoring
stations along the Upper Hudson. These stations have been used to monitor flow, suspended
sediment, PCBs, and other water quality parameters. The USGS data, obtained from
WATSTORE and the Albany USGS office, provide the longest and most comprehensive record
of surface water information available for the Upper Hudson. Flow records, suspended sediment
data, and total PCB water column monitoring are discussed below. Table 2-3 lists the
monitoring programs and the associated subdirectories where these data are contained. In
general, the USGS data contained in the Reassessment database were obtained from
WATSTORE, the most recent retrieval being August 1995 (WATSTORE, 1995). As of this
date, flow data were available up to October 1, 1993 and water quality data up to 1994. The
water quality data retrieved from WATSTORE for this database were limited to those parameters
2-9
TAMS/Gradient
-------
important to the characterization of PCB transport. Specifically, this included total suspended
solids, total organic carbon and PCBs. No other water quality data were included in the
Reassessment database.
2.2.1 USGS Flow Records
The USGS has collected river discharge (flow) and water quality data at various points
along the Upper Hudson River as indicated on Figure 2-3. The lengths of record for the daily
flow series at individual locations on the Hudson vary widely, but records are extant from 1907
through the present. Water quality records pertaining to PCBs generally begin in the mid-1970s.
TAMS/Gradient obtained the USGS records of the monitoring stations located on the Hudson
and its major tributaries between Hadley, New York, which is well upstream of Fort Edward,
and Green Island, which is below the confluence with the Mohawk River near Albany, for use
in this investigation.
The majority of the USGS flow monitoring stations on the Upper Hudson have periods
of record beginning in the 1970s, although continuous monitoring is available at Hadley since
1921. Earlier records are available for the Hudson River at Thurman, NY (Station No.
0131800) for 1908 through 1911 and 1919 through 1920, and for the Hudson River at Spier
Falls (No. 01326500) for 1912 through 1923.
While the majority of the USGS flow monitoring data was obtained to examine and
estimate PCB loading, it was also needed to examine flood frequency in the Upper Hudson. In
order to obtain an extended period of record for analysis of flood recurrence in the Upper
Hudson, it was necessary to use the data from a station well upstream of Fort Edward, at the
confluence of the Hudson and Sacandaga Rivers, near Hadley, as shown on Figure 2-3. The
USGS has maintained a monitoring station in this location since July 1921. The Sacandaga
River, a major tributary of the Hudson, enters slightly below Hadley. It has been monitored at
Stewarts Bridge near the confluence since September 1907. Table 2-5 provides a brief
description of the USGS surface water flow monitoring stations that are included in the database,
including the period of record.
It is important to note that the quality of the USGS flow monitoring data varies from
location to location as well as over time. In particular, ice coverage of the river greatly limits
the accuracy of many flow monitoring stations. The users of these data should refer to the
USGS Water Resources Bulletin for a description of each station's flow monitoring data quality.
Of particular concern to the Phase 2 monitoring program were the USGS flow records for
Stillwater and Waterford for 199.3,. Due to construction at these sites, the regular staff gauge
readings were unavailable during the Phase 2 water sampling programs. As a result, the USGS
was forced to estimate the readings at these locations. This delayed the release of this
information for many months. Because of this delay and the anticipated uncertainty of these
data, flows at Stillwater and Waterford were estimated based on NYSDOT Champlain Canal
gauges. The calculated results are discussed briefly in Section 2.5.6 and will be presented in
detail in a subsequent Phase 2 Report.
2-10
TAMS/Gradient
-------
2.2.2 USGS Suspended Sediment Data
Several water quality stations were established on the Upper Hudson in 1969 but
measurements of suspended sediment in the water column did not commence until 1975.
Monitoring has not been continuous nor on a set schedule, and there has been a tendency to
focus on spring flood periods, with little data available for the winter months. A list of water
quality monitoring stations, including the periods of record in the database, is provided in Table
2-6.
2.2.3 Monitoring of PCBs in the Water Column
Regular monitoring of PCBs in the water column in the Upper Hudson was initiated by
the USGS in late 1975 at Waterford, and expanded to other upstream stations in 1977. Most
other sampling programs have been of short duration. The USGS data are, thus, the primary
source of time-series information indicative of trends in water column PCB concentrations for
the Hudson River.
USGS observations of PCB concentrations have been made at the same water quality
stations as suspended sediment measurements (See Table 2-6). Data sets of significant size are
available for Fort Edward, Schuylerville, Stillwater, and Waterford, with a limited record at Fort
Miller. In addition there are data for project background samples collected upstream of Fort
Edward at Glens Falls.
Methods of data collection and analysis are summarized in Turk and Troutman (1981),
and Schroeder and Barnes (1983a). Analyses for total recoverable PCB concentrations were
performed on unaltered samples, and results therefore include the dissolved as well as the
particulate fraction. Dissolved PCB concentrations were determined on samples filtered through
0.45 micron silver oxide filters. However, dissolved concentrations were determined on less
than five percent of the samples.
The concentrations reported were not corrected for incomplete extraction. However,
Schroeder and Barnes contend that extraction efficiency is greater than 80 percent for Hudson
River water because the river is relatively low in suspended sediment and dissolved organic
carbon concentrations. Extraction efficiency may be an issue for periods of high suspended
sediment load.
Although the USGS laboratory reports a theoretical quantitation limit of 0.01 /xg/L
through 1983, the practical quantitation limit was considered to be 0.1 /xg/L because of the small
size of the water samples (Bopp et al1985). Data for this period recorded on the USGS
central database, WATSTORE, contain both values entered as 0 and values coded as < 0.10
/xg/L. Apparently these are both intended to represent non-detects at the 0.1 //g/L quantitation
level, and the inconsistency is unintentional (Rogers, 1991, personal communication). With
water year 1984 the practical quantitation limit was lowered to 0.01 Mg/L. Nevertheless, the
1984 and 1985 data are reported on WATSTORE as if they adhere to the previous quantitation
2-11
TAMSI Gradient
-------
limit of 0.1 fig/L. In 1986, the quantitation limit began to be reported as 0.01 pg/L in
WATSTORE.
2.2.4 Total Organic Carbon (TOC) Data
Some TOC data collected by the USGS have been merged into the database. These data
span the period from July 1974 through September 1979 and represent the total organic carbon
levels from unfiltered or whole water samples.
2.2.5 Sources of Water Column Data Not Contained in Database
Two water column studies are described below: Waterford Treatment Plant Data and
Lamont-Doherty Geological Observatory Study. These data were not provided in an electronic
format and were excluded from the database since they were not needed for the quantitative
evaluations performed during Phase 2.
Waterford Treatment Plant Data
The City of Waterford, NY operates a water works serving a population of approximately
12,000 persons in the towns of Waterford and Halfmoon and the Village of Waterford. This
is the northernmost water treatment facility drawing water from the Hudson downstream of the
Fort Edward area. In 1975, when the USGS began collecting PCB data in the river at
Waterford, they also began collecting data for raw water input and treated water output at the
Waterford treatment plant, in cooperation with the Board of Water Commissioners of the Town
of Waterford and the NYSDEC (Schroeder and Barnes, 1983b). The water for the treatment
plant is drawn from a location 0.5 km upstream of the U.S. Highway 4 bridge, where Hudson
River water samples are taken at Waterford. For this location, data collected in cooperation
with the USGS continue through the end of water year 1983. In addition, data collected
approximately bimonthly for November 1983 through February 1985 and March 1987 through
October 1989 are available from the Waterford Water Works (Metcalf & Eddy, 1990).
Lamont-Doherty Geological Observatory Study of 1983
A detailed study of PCB transport in the Upper Hudson was conducted by personnel of
Lamont-Doherty Geological Observatory in 1983 (Bopp et al., 1985). This involved an
investigation of Spring-Summer 1983 PCB transport in the Upper Hudson, which was a period
of relatively high flows. The Lamont-Doherty study included the collection of data not available
from USGS sampling. This study included 20 large-volume filter samples of suspended matter,
and 15 nine-liter to 20-liter water samples, collected from Troy to Glens Falls. Unlike USGS
monitoring, detailed analysis of both the dissolved and suspended matter PCB fractions of these
samples was undertaken.
2-12
TAMS/Gradient
-------
2.3 GE Data
General Electric has conducted numerous environmental monitoring programs in the
Hudson River (See Table 2-3 and Figures 2-7 through 2-12). Analytical results for work
completed after 1990 from these programs were assembled and an updated version was
transmitted to TAMS/Gradient in August 1995. The discussion below will address only the post-
1990 results since the prior work was discussed in Section 2.1.1 of this chapter. The database
in the GE directory includes analytical results for water, sediment, pore water and biota samples
from the following:
• 1991 Sediment Program
• Temporal Water Column Monitoring Program
• Post-Construction Remnant Deposit Monitoring Program
• Baker's Falls Investigation
• Observation of USEPA Sampling Effort
• Channel Characterization
• Biota Survey
• Highflow Sampling Program
• Archived NYSDEC Fish Samples
• Analysis of Aroclor Standards
GE has provided data for over 1,500 water column samples spanning a period from April
1991 to June 1994. The results include measurements of total PCBs, PCB homologue
distributions and capillary column peak concentrations, as well as some conventional parameters
such as total dissolved solids, total alkalinity, total suspended solids, and water temperature.
Data for over 400 sediment samples are reported, although most represent composited samples
rather than single sediment cores. In addition to total PCBs, homologue distributions and
capillary column peak concentrations, measurements of bulk density, percent moisture, total
organic carbon, and total percent solids are reported for core composites. Sediment samples
exist for the 1991 Sediment Program and for the 1992 Channel Characterization Program.
Results for 86 pore water samples collected during the 1991 Sediment Program are also
contained in the database. Finally, the database includes 75 archived NYSDEC fish samples and
18 biota samples (largely fish samples) from the GE 1992 Food Chain Program (O'Brien and
Gere Engineers, Inc., 1993).
It should be noted that the GE capillary column peak quantitations are similar to but not
identical to the congener-specific analysis used by USEPA/TAMS in the Phase 2 investigations.
The GE data, however, are quantitated based on Aroclor standards and not the individual
congener standards used in Phase 2. This leads to some differences in PCB quantitation between
the two techniques. This issue, as well as others, will be discussed in subsequent Phase 2
reports. A look-up table (designated by its acronym LUT) PCB LUT, is provided in the
database which represents a key relating the capillary peak results to their likely congener
identities.
2-13
T AMS/Gradient
-------
2.4 Staffing Gauge Data
Staff gauge readings were obtained from the NYS Department of Transportation relating
to staff gauges along the portion of the Champlain Canal lying within the Upper Hudson (NYS
Thruway Authority, 1993). The canal is now controlled by the NYS Thruway Authority which
is the current source for these data. These data represent water levels in the Upper Hudson
relative to the NYS barge canal datum. These values can be converted to the Nation Geodetic
Vertical Datum by adding 1.177 feet to the readings. The staff gauge data can be found in
GAUGES in the NYSDOT directory (See Table 2-3). The data are arranged by date and
represent the staff gauge readings from 1977 to 1993. Readings from different staff gauges are
included, representing water levels from Fort Edward (Lock 7) to Waterford (Lock 1). Of
particular note, staff gauge 118 represents the water level above Lock 6, which corresponds to
the southern end of the Thompson Island Pool.
The staff gauge data contained in the database represent the average of two daily readings
collected at each gauge as reported by the NYSDOT. The gauges are not recorded consistently
during flood and canal off-season periods so the data are generally limited to April through
November of each year. These data were obtained to assist in the calculation of Hudson River
flow in 1993 as well as for use in sediment transport modeling. The staff gauge data table
GAUGES contains all available data for the gauges listed for the period 1983 to 1993. Earlier
years were added for the purpose of calibrating flows at Schuylerville, a USGS station with a
limited dataset, i.e., restricted to the period 1977 to 1979.
2.5 RI/FS Phase 2 Sampling Effort
The results of the analytical program for Phase 2 of the Hudson River PCBs
Reassessment RI/FS can be separated into the basic studies conducted by USEPA/TAMS (with
one exception, as noted) as described below and summarized in Tables 2-2 and 2-3.
Water Column Study - Investigation of water column PCB levels, transport and sources
via sequential sampling along transects, collection of flow-averaged composite samples
and collection of daily suspended matter samples.
Water Column PCB Equilibration Study - Examination of dissolved phase to suspended
matter partitioning of PCB congeners.
Confirmatory Sampling Study - Examination of river sediment for the purposes of
interpreting geophysical data.
High-Resolution Sediment Coring Study - Investigation of long-term trends in PCB
transport, release and degradation via an examination of the sediment record.
Ecological Program - Investigation of PCB levels and other parameters in Hudson River
fish, benthic invertebrates and sediments from 20 sites distributed throughout the Hudson.
2-14
T AMSI Gradient
-------
Fish Sampling Study (NOAA) - Analysis of supplementary fish samples collected as part
of the Ecological Program.
High-Flow Suspended Solids Monitoring Study - Collection of suspended matter samples
during the annual spring high flow event in Spring 1994.
Low-Resolution Sediment Coring Program - Investigation of PCB levels in selected hot
spot areas of the Upper Hudson.
TAMS/Gradient procured the services of a number of laboratories to perform analyses
required for the Phase 2 studies. Of the analyses required, only metals are included in the
USEPA Contract Laboratory Program (CLP) Routine Analytical Services (RAS) procurement
process. For non-routine analyses having standard methodologies, laboratory services were
solicited through the USEPA CLP Special Analytical Services (SAS) procurement process.
Analyses with non-standard methods or requiring special attention of project investigators were
performed by laboratories procured directly by TAMS/Gradient, including those associated with
research institutions employed on the project. In some cases, similar analyses were performed
by directly-procured and SAS laboratories for comparison purposes, or to serve different
sampling events, depending on project needs. The laboratories employed for particular analyses
are shown in Table 2-7.
Data from each of the studies have been incorporated into the database. Sediment results
from the confirmatory sampling study and the low resolution sediment coring program reside
in the SEDIMENT subdirectory under PHASE2. Sampling results from the water column study,
the water column PCB equilibration study and the high flow suspended solids monitoring study
are stored in the subdirectory WATER. Results of the high-resolution sediment cores are
contained in the HRCORES subdirectory. Results for the ecological program are in the ECO
subdirectory under PHASE2, and the NOAA results are in the NOAA subdirectory.
In the database design, the sample identifier, which uniquely defines each sample, is
divided into two database fields, i.e., TAMS ID and TAMS Type. This identifier contains the
basic sample description information and can be used to simplify most database queries. A third
field, Species, is required to uniquely identify the ecological biota samples as well as the fish
samples analyzed by NOAA. The sample naming convention for each process is described
below with examples. It is always necessary to use at least two, and sometimes three, fields to
extract the desired physical sample measurement to ensure the correct data are related from the
various databases. Examples to illustrate this point are given in Chapter 3.
A result that is not detected is always reported with at least a "U" in the data qualifier
field for all data. The sample quantitation limit is then reported as the Value for a non-detected
result. Thus, a user must not simply take the mean or maximum, or perform any other statistics
on the concentration in the Value field without first testing for the qualifier and assigning a
scheme for non-detected concentration values.
2-15
TAMS/Gradient
-------
Handling of Sample Duplicates
Reported sample duplicates fall into three groups: laboratory splits, field split samples
and co-located field samples. In all programs except the ecological investigation, sample
duplicates were handled as discussed below. Ecological sample duplicate handling is discussed
in Section 2.5.5. For the field co-locate samples, unless one of the results was rejected during
(jatq validation, the results are averaged and the means are reported in the database tables in
order to obtain the best estimate of the measured properties at the location. Results for field
split samples (i.e., two samples taken from a single homogenized sample volume) were not
averaged. Instead, the first analysis is kept in the main data table and is labeled "FS1" in the
Split field, while the second is placed in an analysis duplicate table under the appropriate
QAjQC subdirectory and is labeled "FS2" in the Split field. Laboratory splits yield a measure
of analytical precision while field splits and samples which are co-located yield additional
information on the local variability of a measured property. Only the first analysis result of a
laboratory split series is retained in the main database table and is labeled "LSI" in the Split
field. The remaining results of a series are stored under the appropriate analysis duplicate table
in the QAQC subdirectory and are labeled "LS2", "LS3\ etc., depending on how many split
analyses were performed. Both field splits and co-located samples are labeled with a "D" in the
TAMS Type data field. The Split field is used to indicate the type of duplicate analysis. For
pairs of co-located samples, both original samples have been moved to a separate table and only
the mean of the results of the co-located samples is contained in the main database tables. These
mean results are labeled with "Avg-FC" in the Split field to denote the composite record.
The analytical values from co-located samples were combined for input to the database
as follows:
• Duplicate detected results
• Duplicate non-detected
results
• Detected and non-detected
result pairs
• Detected and rejected result
pairs
• Non-detected and rejected
result pairs
Combined PCB Results
Mean of results: qualifier left
blank.
Mean of reported detection
limits (quantitation limits);
qualifier left as "U. "
Mean of detected value and
1/2 quantitation limit for non-
detected results (i.e. analyte
is considered detected);
qualifier left blank.
Detected value and its
qualifier are reported.
Reported detection limit is
retained along with "U"
qualifier.
Combined Non-PCB Results
Mean of results: composite
qualifier carried over.
Mean of results; qualifier left as
"U."
Mean of detected value and 1/2
quantitation limit for non-
detected results; detected-value
qualifier carried over.
Detected value and its qualifier
are reported.
Reported detection limit is
retained along with "17"
qualifier.
2-16
TAMS! Gradient
-------
Sample Location Data
Sample locations for the Phase 2 investigation fall into two types, surveyed locations and
estimated locations. Sampling sites for the confirmatory sampling and low-resolution coring
programs were surveyed in place based on on-shore control points. All other coordinate
information, including river mile, represent estimated locations derived from USGS quadrangle
maps and other sources. Surveyed coordinates are contained in the Northing and Easting fields
while estimated coordinates are contained in the Est Northing and Est Easting fields. All
coordinates are referenced to the NYS plane coordinate system.
PCB Congener Results
PCB congener results are reported for the high-resolution coring, water column transect
sampling, flow-averaged water column sampling, ecological sampling and low-resolution coring
programs. The PCB congener analysis consisted of 90 congeners whose identity and quantity
were established by individual congener standards. These are labeled as "target" congeners.
The look-up table CONG_LUT under PHASE2 provides a listing of these congeners. An
additional 37 to 50 congener results are reported based on laboratory-determined retention times
and congener response factors. For most of these congeners, no congener standards were run
at the time of analysis. These congeners are labeled "non-target" in the Phase 2 database.
With regard to Phase 2 PCB congener analysis, the following should be noted. Due to
changes in the chromatographic columns used by the contract laboratory for congener analysis
during the summer of 1993, congeners BZ#4 and BZ110 could not be represented in a limited
number of samples. This affected three flow-averaged water column sampling events, one water
column transect and the sediment analyses performed for the ecological field investigation. In
these instances, the analytical result was reported as a coeluting peak "BZ#4 and BZ#10."
However, due to the need to resolve and quantitate BZ#4 more accurately, this coeluting peak
was split into BZ#4 and BZ110 based on their known individual analytical response factors and
the ratio of their occurrence in the environment. This separation will be discussed in more detail
in the data usability section of the Phase 2 Data Evaluation and Interpretation Report.
Sample Grouping
In the creation of the database, samples within various media were grouped by
appropriate criteria, generally by geographic area, in order to assess general property
characteristics and to establish a treatment procedure for non-detect values. In general, the
recommendation put forth under USEPA (USEPA, 1989) for dealing with non-detects was
applied to the Reassessment database. For nearly all non-PCB analyses, non-detect values were
infrequent and had little effect on the use of the data. For PCB congener data, non-detect results
occurred frequently enough that a systematic scheme was required to handle them consistently.
In all PCB congener tables, two fields labeled Valuel and Value2 are reported. Valuel
field represents the validated data with non-detect levels as reported by the laboratory and
2-17
TAMS/Gradient
-------
confirmed by validation. The Value2 field contains the validated congener detections along with
a modified value for the non-detect results. The non-detect results for a given congener were
assigned a value of zero when non-detects for that specific congener occurred in more than 15
percent of the samples within a sample group. When nondetects represented less than 15 percent
of results for a specific congener in a sample group, the congener was assigned a value of one-
half of the detection limit.
Homologue and Aroclor Sums
Using these results, congener sums were created to represent homologue, total PCB and
Aroclor concentrations. For these sums, target and non-target congener results were combined
as appropriate. However, all sums were created based on the original 90 target congeners plus
the 37 non-target congeners common to all analyses. The additional 13 non-target congeners
were not included in these sums to maintain consistency across all analyses.
To create homologue sums, each congener record in the database is associated with a
homologue group; e.g., BZ#12 is 3,4-dichlorobiphenyl in the dichloro-homologue group. In the
case of multiple congeners eluting together, the homologue group assigned is either the
predominant or least chlorinated one present, e.g., the coeluting congeners BZ#37 and BZ#59
are in the trichloro-homologue group because BZ#37 is a trichloro-homologue and is the least
chlorinated. BZ#59 is a tetrachloro-homologue. The total PCB value represents the sum of the
127 standard PCB congeners. The Aroclor sums represent the sum of only those congeners
found in Aroclor standards run as part of the Phase 2 analytical program. Specifically, only
those congeners present at 0.1 % or more in a given Aroclor mixture are included in the Aroclor
sum. For the Aroclor sums where more than one Aroclor is listed (e.g. Arl016-Arl242), the
sum is constructed by adding together all congeners present in either Aroclor standard. This
sum avoids any "double counting" since each congener is added to the sum only once regardless
of the number of Aroclor mixtures in which it occurs. As noted above, the homologue and
Aroclor sums provided in the Phase 2 data tables are based on the 127 standard congeners and
are listed below:
Parameter Name
Description
Mono
Sum of monochloro-homologue congeners
Di
Sum of dichloro-homologue congeners
Tri
Sum of trichloro-homologue congeners
Tetra
Sum of tetrachloro-homologue congeners
Penta
Sum of pentachloro-homologue congeners
Hexa
Sum of hexachloro-homologue congeners
Hepta
Sum of heptachloro-homologue congeners
2-18
T AiMS/Gradient
-------
Parameter Name
Description
Octa
Sum of octachloro-homologue congeners
Nona
Sum of nonachloro-homologue congeners
Deca
Decachloro-homologue congener
Total PCBs
Sum of all congeners
Aroclor 1016
Congener-based Aroclor 1016
Aroclor 1221
Congener-based Aroclor 1221
Aroclor 1232
Congener-based Aroclor 1232
Aroclor 1242
Congener-based Aroclor 1242
Aroclor 1248
Congener-based Aroclor 1248
Aroclor 1254
Congener-based Aroclor 1254
Aroclor 1260
Congener-based Aroclor 1260 |
Arl016-Arl242
Congener-based composite of Aroclor 1016 and 1242 |j
Arl221-Arl232
Congener-based composite of Aroclor 1221 and 1232 |
Arl016-Arl248-Arl254
Congener-based composite of Aroclor 1016, 1248 B
and 1254 |
Similar to the results for the individual congeners, two values are given for the
homologue, total PCB and Aroclor sums. These sums are included in the Valuel and Value2
fields. The value given for these parameters in the Valuel field represents the sum of the
detected congener concentrations. In creating this sum, non-detect congeners are set equal to
zero. Thus the homologue, total PCB and Aroclor sums given in Valuel cannot be obtained by
simply summing the associated congener values listed in the Valuel field since Valuel contains
both the measured quantities for detected congeners and the quantitation limits for non-detected
congeners. The homologue, total PCB and Aroclor sums given in Value2 represent the sum of
detected and non-detected congeners. In this instance, the non-detected congeners have been
assigned values based on the rules described previously in the section entitled "Sample
Grouping". The summation scheme described above was applied to all PCB congener data
tables in the same manner. Thus, all PCB congener tables contain 2 concentration fields,
Valuel and Value2, and 21 congener summation results (10 homologues, 10 Aroclors and total
PCBs) for each sample analyzed.
2-19
TAMS/Gradient
-------
2.5.1 Water Column Transect, Flow-Averaged Sampling and Suspended Solids Monitoring
Programs
The Phase 2 water column program conducted by TAMS during 1993 was intended to
address several issues concerning riverine PCB contamination, including:
• the sources of PCBs to the Upper Hudson, particularly those in the area of the
Thompson Island Pool;
• the nature of the PCB mixture as it enters the river, e.g., dissolved phase- or
particle phase-dominant;
• seasonal variations in the flux of PCBs in the Upper Hudson;
• the factors influencing PCB transport and water column concentrations, such as
seasonal or flow variations;
• seasonal variations in water column conditions;
• suspended matter versus dissolved phase distributions of PCB congeners and how
closely they approach an equilibrium distribution;
• the use of equilibrium-based assumptions to predict mean PCB transport; and
• the importance of PCB suspended matter to dissolved phase disequilibrium in the
Upper Hudson.
This section provides general comments on the water column samples themselves,
including naming conventions, handling of sample duplicates and locations of sample stations.
A description of each of the sampling programs follows. Figures 2-13A and 2-13B show the
water column sampling locations for the Upper Hudson and Lower Hudson, respectively. Figure
2-14 shows the suspended solids monitoring locations.
General Comments
Water column data on PCB levels were collected during two separate sampling programs:
the transect sampling program and the flow-averaged sampling program. Samples from the
transect program are identified by an initial "T" in the TAMS ID, followed by an "S" for
suspended matter or a "W" for the filtered water, i.e., dissolved phase sample. Flow-averaged
samples are identified by an initial "F," also followed by an "S" or "W" denoting the sample
matrix. The middle three digits refer to the transect or flow-averaged sampling event and the
last four digits refer to the sampling station. For example, sample name TS-001-0008 represents
the suspended matter transect sample from transect 1, station 0008; sample name FW-002-0005
refers to the filtered water sample from flow-averaged event 2 at station 0005.
2-20
T AMS/Gradient
-------
Daily samples collected during flow-averaged sampling events are denoted by
incrementing the middle three digits in the sample identifier, e.g., 101 for day 1 of flow-
averaged sampling event 1, 102 for day 2 of flow-averaged sampling event 1, etc. Composited
samples of the first eight days, either mechanical or mathematical, are designated by a "9," e.g.,
109 for composited flow-averaged event 1, or 209 for composited flow-averaged event 2.
Finally, a "D" or "M" in the TAMS Type field for either a transect sample or a flow-averaged
sample refers to a duplicate sample or matrix spike sample, respectively. A duplicate sample
result is averaged with the primary sample result of the duplicate pair while the matrix spike
sample represents a sample taken at double volume to provide enough mass for an additional
laboratory quality control analysis.
The results for sampling days 1 through 8 can be used as independent, instantaneous
measurements. The measurements for temperature, conductivity, and dissolved oxygen for these
days are included in the database table called NONPCBW. Water column transect and flow-
averaged sampling programs use the same station numbering scheme. The sampling stations and
their descriptions and a listing of the water sampling events and their dates are given in Tables
2-8 and 2-9.
In addition to the PCB sampling programs, two studies were conducted to monitor
suspended solids in the Upper Hudson during 1993 and 1994. During 1993, suspended solids
and weight-loss-on-ignition were determined for samples collected at Waterford (Station 8) five
days per week for April through October. Mechanicville (Station 19) and Lock 2 (Station 26)
were also sampled during portions of this period. These samples are labeled with an initial "SI"
in the TAMS ID for suspended solids monitoring study number 1. The middle three digits refer
to the julian calendar day and the last four digits refer to the station number. For example, Sl-
097-0008 represent the sample collected at Waterford on julian day 97 of 1993, i.e. April 7,
1993.
A second suspended solids study was conducted during 1994. This study obtained data
on total suspended solids, weight-loss-on-ignition and total suspended organic carbon during a
one-month period centered on the annual spring high flow event. These samples were intended
to provide a detailed data set concerning suspended matter transport. In all, 18 stations were
sampled on some or all of 21 different days during this 32-day sampling event. Table 2-8 lists
all of the stations occupied as part of the suspended solids monitoring programs. Samples
collected during this event are indicated by an initial "S2" in the TAMS ID field. The
remaining identifier digits are assembled in the same fashion as the "SI" event. For example,
"S2-090-0007" represents the sample collected at Stillwater (Station 7) on julian day 90 of 1994,
i.e., March 31, 1994.
In addition to the coded sample information contained in the TAMS ID field, other
sample information is contained in the TAMS Type field. Co-located water samples are
indicated by a "D" in this field. True water sample splits were not generated due to the
difficulties in homogenizing the large volumes of water collected in the water column studies and
the concern over loss of PCBs by the homogenization process. Instead, field co-locate samples
2-21
T AMS/Gradient
-------
were collected on an individual basis for each parameter at a given sampling site. That is, if
a field co-locate pair was to be collected at a given sampling site, two sample bottle sets were
collected for TSS analysis, two sample bottle sets were collected for PCB analysis, two sample
bottle sets were collected for DOC analysis, etc. In these pairs, one bottle set would be labelled
with a "D" in the TAMS Type field. Thus, the analytical results for PCBs, TSS, etc., for each
sample in a co-locate pair (e.g., all the results with a given TAMS ID and with TAMS Type
equal to "D") do not represent a matched set. Only the average result for a specific analyte for
a co-locate sample pair should be used in a global fashion to describe conditions at the time of
collection. The individual analyte co-locate pairs provide information on the combined analytical
and sampling precision for the given analyte.
All field co-locate samples for the transect and flow-averaged sampling events have been
reported in the main analytical data tables (e.g. PCBP, PCBW, NONPCBW) as the mean
value of the co-located sample results in the database, e.g., TS-004-0005 and TS-004-0005-D.
The individual original co-locate sample pair results have been removed from the main database
and placed in supplementary tables in the WATER1 QAjQC subdirectory, i.e., NONPCBWD,
PCBWD, PCBPD. The reported average result is indicated by the phrase "Avg-FC" in the
Split field of the analytical data table. In this manner, each individual analyte (e.g. BZ#4, TSS)
is marked to indicate that the reported value is the average of two field co-locate samples.
Samples collected as matrix spike/matrix spike duplicate samples for laboratory quality
assurance are labeled with an "M" in TAMS Type. The results reported in the database are of
the same quality as unmarked samples and can be used in the same fashion.
Sampling Program Descriptions
Each of the Phase 2 water sampling programs is described briefly below. Discussions
on data results and interpretation will be provided in subsequent Phase 2 reports.
Transect Samples
The water column transect samples represent "snapshots" of conditions in the river and
provide useful information on the congener pattern distribution and relationships between
dissolved and suspended phases. These events consist of samples from 12 to 16 Hudson River
proper and tributary stations. Three of the eight transects extend downstream of Federal Dam
at Troy to three locations in the Lower Hudson River. Also, PCB flux, or loading, rates can
be determined with flow and total suspended solids data.
Flow-Averaged Samples
Flow-averaged samples provide information regarding PCB flux on a whole-water basis
by combining the results from the suspended matter and filtered water sample pairs.
Flow-averaged samples were collected from only four main stem Hudson River stations.
2-22
TAMS/Gradient
-------
The flow-averaged samples represent a flow-weighted mean water concentration for a 15-
day period. Samples were collected every other day and composited into a single sample. The
daily volume collected was determined by the flow at the USGS gauging station at Fort Edward,
just above the Thompson Island Pool. By using the compositing technique, the variability
inherent in individual daily samples was minimized and a truer measure of the mean PCB flux
on a whole-water basis, i.e., suspended plus dissolved phase, was obtained.
Suspended Solids Monitoring
These samples were collected to monitor and characterize total suspended solids transport
in the Upper Hudson. Due to the affinity of PCBs for suspended sediment, accurate estimates
of PCB transport are contingent upon accurate suspended solid loads. The high flow suspended
solids monitoring event was intended to characterize suspended solids transport during the annual
maximum flow condition. These studies are important to the accurate modeling of PCB
transport in the Upper Hudson.
Equilibration Study Samples
Equilibration study samples were held for long periods of time prior to filtration to
examine the particulate/water PCB distribution. These samples are designated with the letter
"E" in the fourth position in the TAMS ID. These samples must not be used for any analysis
other than the determination of partition coefficients. These samples were collected during two
separate sampling events (transects 2 and 6) and therefore represent different water column
conditions. Differences between the first equilibration study in February 1993 and the second
equilibration study in August 1993 may be attributed to PCB loads, temperature, dissolved
organic carbon, or other seasonal variations. These PCB samples reside in the PCBWE and
PCBPE tables for water and particulate (suspended matter) samples respectively, under the
PHASE2\WATER\EQUILIB subdirectory.
Miscellaneous Samples
Some sampling events deviated from normal length and frequency of sampling collection
protocols. These samples can be combined with other water samples after applying the
necessary corrections to account for the way in which these samples were collected.
Specifically:
• For the first flow-averaged sampling event, two composites were collected at
Waterford instead of one. The first, TAMS Type = "Al," represents four
every-other-day s&mples collected over the period from April 23 to 30, 1993.
The second represents four every-other-day samples collected over the period
May 1 to 8, 1993. The results can be combined into a single flow-averaged value
on the basis of the sampling day flows for each period. These samples are
labeled FS-109-0008-A1 and FW-107-0008-A1 for the first week and
FS-109-0008-A2 and FW-109-0008-A2 for the second week. During the first
2-23
T MAS>! Gradient
-------
week of the first flow-averaged event, the lock above the Waterford station was
opened at irregular and unpredictable intervals. This caused fluctuations in the
discharge at Waterford and visibly variable suspended matter loads, which were
not detected by the USGS station. During the second eight-day period, the flow
appeared to reach a stable level. Approximately 16 liters of water were collected
for each composite sample.
• Prior to the beginning of the flow-averaged sampling program, four composite
samples were collected at Waterford, representing time-averaged conditions.
Each sample consisted of a composite of 20 one-liter samples collected daily,
Monday through Friday, for a one-month period at Waterford. The composite
samples were filtered to obtain dissolved phase and suspended matter fractions,
as were other water samples, but the composite samples were outside of standard
holding times. These suspended matter and dissolved phase PCB results were
recombined to generate a single whole water result for the sample. These
samples are labeled as FC-709-0008-C1 to FC-709-0008-C3, representing three
one-month composites. Note that no corresponding total suspended solids (TSS)
data are available for these samples. It is important to note that these samples
represent the only temporally-composited samples in the Phase 2 data set and care
must be taken to use them correctly. Because they are distinctly different from
other Phase 2 results, these samples are placed in their own table, PCBFA7, and
have a unique matrix name "wat/fil", indicating that they represent the combined
water and filter result.
• Roughly two weeks after the main transect sampling event in April 1993, three
additional samples were collected at three sampling stations: Fort Edward,
Thompson Island Dam, and Waterford. These samples were not collected in a
timed fashion, as were done with the other transect sampling events. These
samples are labeled TS-008-0004, TS-008-0005, TS-008-0008, and TW-008-0004,
TW-008-0005, TW-008-0008 for the suspended matter and dissolved phase
fractions, respectively. The TSS data for these samples was collected as part of
the on-going flow-averaged sampling so there are no TS-008 specific TSS
samples. The correct TSS values can be obtained by matching the dates of these
samples with those of flow-averaged event number 1.
• An additional set of one-liter water samples collected in the first water column
transect are labeled with "IT" in the first two letters of the TAMS ID. These
samples were not filtered and hence represent a whole water analysis, i.e., a
combination of suspended matter and dissolved phase fractions. As they are not
comparable to the other filtered water samples, they have been moved to a
separate table called PCBTT. Due to the inherent uncertainty in the PCB
analysis resulting from their smaller size, these samples were not used in the
Phase 2 data evaluation.
2-24
T AM S / Gradi ent
-------
Finally, it is important to note that:
• The samples collected at Saratoga Springs (station 0009) are equivalent to field
blanks and should not be used in any data analysis because it was taken as a
background sample.
Conventional Parameters
Results of the weight-loss-on-ignition (WLOI) analysis, a measure of organic matter
content, are reported by RPI for nearly all water column study samples for two temperatures,
375°C and 450°C. The historical database for the Hudson River reports WLOI at 375°C. For
comparability to existing data, the value at 375°C should be used. These data are available for
all transects except the first, and all flow-averaged events. Total suspended sediment (TSS) and
dissolved organic carbon (DOC) data, along with WLOI, are provided in the database table
NONPCBW with duplicate pairs stored in QA-QC NONPCBWD. The TSS, chlorophyll-a, and
DOC data provided by the USEPA SAS laboratory did not meet data quality objectives and have
not been included in the database. Chlorophyll-a data reported by an alternate laboratory for
water column transect samples met data quality objectives and are included in the database.
PCB Congeners
Water samples collected under the Phase 2 program have been filtered into two fractions
for PCB analysis, a suspended matter fraction as well as a dissolved phase fraction representing
both truly dissolved and dissolved organic carbon-bound PCBs. PCB congener data reside in
two main database tables: PCBP for the suspended matter (particulate) fraction and PCBW for
the dissolved phase (filtered water) fraction. In order to construct whole water column
inventories, the results reported for both fractions must be summed. The suspended matter
results are reported on a mass-per-unit-mass basis, ng/kg, and must be multiplied by the
corresponding TSS value for the sample in mg/L (x 1 kg/1000 mg) in order to calculate the
suspended matter PCB concentration on a volume basis in ng/L. It should be noted that the
congener data contained in the PCBP database does not represent the actual reported values.
The original values for filtered samples were reported in ng/filter. These values were converted
to jig/kg by dividing by the sample volume (given in VOLUMES) and the suspended matter
concentration (given in NONPCBW). The formula is as follows:
Suspended.
Matter I
Cone '
Reported
Cone
Sample Total
Volume(L) Suspended
Solids
10 6mg n g
Kg 103ng
2-25
T AMS/Gradient
-------
Generally speaking, water samples should be grouped for analysis according to the region of the
river from which they are derived. The sample groups for analyzing water column PCB
distributions for both transect and flow-averaged samples are shown below.
Water Column and Flow-Averaged Sample Groups for Determining
Frequency of Non-Detected PCB Congeners
Group
Station Number [1]
River Mile Range
Upper River
3, 4, 5, 6, 7, 8, 19
195.8 to 156.6
Lower River Freshwater [2]
14, 15, 16, 17
153 to 77 1
Lower River Saline
none
Background & Tributaries [3,4]
1, 2, 11, 12, 13
Lock 7 [5]
10
potential source
111 Station 9 (Saratoga Springs) was used to assess sampling and laboratory contamination and should not be used in any
sample grouping.
Station 0014 (Troy at Green Island Bridge) was monitored to represent the mixture of the Mohawk (0013) and
Waterford (0008). These Lower Hudson stations were monitored during three of the eight water column transects.
,3' Quantitation of contaminants in these samples is questionable because the levels approach the detection limit. While
there are sources of PCBs in the river upstream of Fenimore Bridge, these samples represent applicable background
conditions for the river downstream of that point.
,4' These stations represent three different watersheds and should generally be considered separately.
[5' The Champlain Canal above Lock 7 represents a potential source to the river, but flow rates through the lock are
negligible; therefore fluxes are expected to be small or negligible.
2.5.2 Confirmatory Sampling Study
Confirmatory sampling results are intended for use with the geophysical investigation of
the Upper Hudson, specifically the side-scan sonar survey. Since the geophysical techniques
recorded physical river bottom properties, specifically reflectivity, there is a need to calibrate
the geophysical signals obtained with a set of analytical measurements. The sediment samples
collected in this study have been analyzed for several parameters useful for mapping sediment
characteristics. Figure 2-15 shows the confirmatory sediment sampling locations.
2-26
T AM S/Gradient
-------
General Comments
Confirmatory sample results are found under the PHASE2\SEDIMENT subdirectory.
Confirmatory samples are designated with a "CC-" or a "CG-" at the beginning of the TAMS
ID specifying a core or grab sample, respectively. The middle three digits indicate the station
number and the last four digits indicate the core depth interval in centimeters. For example,
CC-080-0510 is a sample from a confirmatory core at station 80 collected from the core interval
between 5 and 10 cm. These samples provide information on the spatial distribution of sediment
properties from Bakers Falls to Lock 5. Northing and easting must be used to isolate samples
among the various study areas since the areas were not sampled sequentially. Sample duplicates
were collected, representing laboratory duplicates, field split samples and co-located field
samples. Results of co-located duplicate pair analyses and laboratory duplicates have been
averaged for use in data analysis. Field split samples have not been averaged. Individual
sample analyses used in calculating the average values are found in sample duplicate tables. The
results representing averaged values are indicated by the entry in the Split field within the data
tables. The key to the Split field can be found in the PARAMS glossary. Some confirmatory
samples are labeled with an "X" in the TAMS Type field. These samples represent cores
subjected to X-radiography.
The main river section of consideration for the confirmatory samples extends from
Rogers Island to Lock 5. Samples collected from river zones from Rogers Island to Lock 5
(which includes the Thompson Island Pool) can be considered representative of the river
sediments in this area. These samples can be grouped together to obtain mean properties for this
river section on a spatial basis. The best large-scale spatial interpolation of these values can be
made using the side-scan sonar interpretation maps created as part of the geophysical
investigation in a geographic information system (GIS).
Confirmatory samples collected from the Bakers Falls pool, that is, from above Bakers
Falls near the Fenimore Bridge, do not represent the local characteristics. The river bottom in
the area is mostly bedrock, while the samples were obtained from relatively fine-grain sediments
from a few peripheral areas due to sampling access limitations. The samples are only
representative of the small zones of fine-grained sediments in this area. The zone below Bakers
Falls and above Rogers Island, i.e., the remnant deposit area, has unique sedimentological
characteristics based on sediment samples and the hydrological conditions noted there. The grain
size distributions obtained from the samples in this area may be biased. The physical sample
sizes were too small to ensure a statistically representative data set since this zone contains some
areas with gravel and cobbles which could not be sampled. These samples should reflect the
basic characteristics of the sandy sediments in this zone.
Grain Size Distribution Analysis
In general, the grain size distribution data from the confirmatory sampling program can
be used for qualitative analysis but not quantitative analysis. Due to the relatively small sample
size (i.e., 200 to 500 g samples) and the frequent occurrence of gravel-sized particles, a potential
2-27
T AMS/Gradient
-------
uncertainty exists in the ratio of the gravel fraction to the sand and finer fractions. This matter
will be discussed at length in the data usability section of the Data Evaluation and Interpretation
Report. In the Confirmatory Sampling Program, both the sieve and laser particle analyses were
performed on comparable sample sizes (i.e., 200 to 500g). However, the data user is cautioned
against combining the sieve and laser particle analysis data directly due to possible systematic
differences in the results from the two techniques. The analysis name is included in the
parameter so as to remind the user that the data are derived from two distinct methods (e.g.,
clay % (sieve) and clay % (laser)). Paired sieve and laser particle analyses provide a point of
reference for direct comparison between the measurement techniques. For internal consistency,
TAMS/Gradient recommends using the laser grain size data to characterize the river bed.
Total Carbon/Total Nitrogen and Total Inorganic Carbon
These data can be used to derive a close approximation of the total organic carbon (TOC)
of the sediments by subtracting the total inorganic carbon (TIC) from the total carbon (TC).
These results have been designated in the database as "TOC (calculated)." Rules for the
calculations are given below. The TIC is generally negligible so that TC and TOC (calculated)
were nearly identical. Total nitrogen (TN) can be used with total carbon as an indicator of wood
cellulose (wood chips) in the sediments. A high C to N ratio (C/N) implies high cellulose
content.
TOC Calculation Rules
TC
TIC
TOC (calculated) |
Null
Value
No calculation possible (
Value
Null
Assume TOC = TC
Value
Non-detect
Assume TOC = TC
Non-detect
Non-detect
Assume TOC = non-detect
Value
Value
TC - TIC = TOC
Sediment Description
As part of the confirmatory sample collection process, sediment samples were classified
according to the TAMS field classification procedures. These procedures are based on the
ASTM visual description and identification of soils methodology. The TAMS field procedures
were used to describe the sediment samples on the basis of the ASTM standard soil
classification. In addition, reduction-oxydation potential (redox) was measured for most
samples. The sediment classification and redox data are contained in the SEDDESC table. The
terms used in the sediment descriptions are defined in the PARAMS glossary.
2-28
TAM.S! Gradient
-------
2,5.3 High-Resolution Sediment Coring Study
High-resolution core data can be found in the PHASE2\HRCORES subdirectory. High-
resolution sediment core samples are designated by the initial letters "HR" in the TAMS ID.
The PCB profiles recorded in the high-resolution sediment cores provide an historical record of
water column transport by suspended matter and do not provide a spatial representation of
sediment PCB contamination in the river. The term "high-resolution" refers to the fine slicing
intervals used in subdividing these cores. A listing of core sites follows; Figures 2-16A and 2-
16B show the Upper and Lower coring sites, respectively.
High-Resolution Sediment Cores
River Mile
Location
Core No.
Station ID
202.9
Background - Bishop's
Dock
27
HR-027
197.1
Bakers Falls
28
HR-028
194.IE
Rogers Island East
26
HR-026
194.2W
Rogers Island West
25
HR-025
191.2
Thompson Island Pool
20
HR-020
189.3
Thompson Island Pool
23
HR-023
188.5
Thompson Island Dam
19
HR-019
185.8
Above Lock #5
18
HR-018
(NA)
Batten Kill #2
17
HR-017
177.8
Stillwater Pool
22
HR-022
177.8
Stillwater Pool
21
HR-021
166.3
Above Lock #3
16
HR-016
(NA)
Hoosic #4
24
HR-024
159.0
Below Lock #\
15
HR-015
(NA)
Mohawk
12
HR-012
143.5
Albany Turning Basin
11
HR-011
124.1
Stockport
14
HR-014
99.2
Tivoli Bay
13
HR-013
88.5
Kingston
10
HR-010
59.6
Denning's Point
9
HR-009
2-29
T MAS! Gradient
-------
High-Resoiution Sediment Cores (Cont'd)
River Mile
Location
Core No.
Station ID
54.0
Foundry Cove
8
HR-008
43.2
Lent's Cove
7
HR-007
43.2
Lent's Cove
6
HR-006
25.0
Piermont Marsh
1
HR-001
2.4
Mid-Harbor
4
HR-004
(NA)
Newtown Creek (NC 7)
5
HR-005
-1.9
Upper NY Bay
2
HR-002
-2.2
Upper NY Bay
3
HR-003
High-resolution cores are labeled in a similar manner to the confirmatory cores. The
middle three digits contain the coring location site number. The last four digits in the sample
identifier capture the core depth interval in centimeters. For instance, HR-001-0406 is a sample
from a core at station I (Piermont Marsh) taken from the 4- to 6-cm depth interval.
High-resolution core intervals with field duplicate analyses are indicated by a "D" in the
TAMS Type field. Field duplicate samples were collected from a single core slice but were not
homogenized prior to analysis and thus are considered co-located samples. Duplicate high-
resolution cores, co-located cores, i.e., Nos. 6 and 7 and Nos. 21 and 22, are duplicate core
pairs for the dating analysis. A comparison of these cores will be discussed in the Data
Evaluation and Interpretation Report to be published in the near future. Individual slices of these
cores cannot be compared as field duplicate samples (e.g., HR-006-2024 and HR-007-2024) due
to potential differences in the sedimentation rates between the cores.
As part of the high-resolution sediment core collection process, four cores were collected
at each site. These are labeled P, A, G, X in the TAMS Type field. These four cores were
closely co-located at each coring site. They were necessary because of the limited material for
sample analysis available in an individual core. The "P" or primary core was sliced and
subdivided into 2- to 4-cm layers and used for PCB, TC/TN, TOC and radionuclide analysis.
Thicker layers (i.e., 4-cm layers) were also used to provide material for small volume (2cc) laser
particle analyses. The "A" or archive core was used to provide material for small volume laser
grain size analyses for the 2-cm slice intervals spanning 0-8 cm in the core, as well as to provide
an archive in case additional sediment analyses were needed. In a limited number of cases, the
0- to 2-cm and 2- to 4-cm slices from these cores were analyzed for PCBs and radionuclides.
The "G" or grain size analysis core was used to provide a large volume laser grain size sample,
typically integrating the equivalent of 2 to 4 layers in the "P" core. It was also used to provide
a large sample for PCB congener laboratory quality control. The remaining core, labeled "X"
2-30
TAMS/Gradient
-------
for x-ray was intended for x-ray photography to examine sediment structure; however, x-ray
photography was not performed for high-resolution cores.
Supplemental core tops, i.e., 0- to 2-cm intervals, are available for a number of
locations. These cores were collected prior to the main Phase 2 coring effort as part of the site
selection process. These core tops are assigned core numbers 29 through 35 and are labeled
with a final "A" in the TAMS Type field of the database. In addition, several core tops were
collected in April 1992 from very high deposition zones in the saline Lower Hudson such as boat
basins, and analyzed for PCBs and radionuclides. These samples are identified as cores 36
through 39, also labeled with an "A." For all samples labeled with an "A," it should be noted
that the PCB analyses were performed on dried sediments beyond the standard seven-day holding
time. The table below describes these samples.
Supplemental High-Resolution Core Top Samples
TAMS Sample
ID
LDEO
No.
River Mile
Corresponding Core
(and RM)
Location
HR-029-0002A
2163 A
12
Mohawk #3
HR-029-0002D
2163A
12
Mohawk #3 |
HR-030-0002A
2133 A
99.2
13(99.2)
Tivoli Tsc
HR-031-0002A
2152 A
124
14 (124.1)
Stockport
Sfe
HR-032-0002A
2178 A
159.0
15 (159.0)
159.0
HR-033-0002A
2175 A
17
Batten Kill
HR-034-0002A
2219A
194.2
25 (194.2W) and
26 (194. IE)
Rogers
Island
HR-035-0002A
2220A
194.3
25 (194.2W) and
26 (194. IE)
Rogers
Island
HR-036-0002A
2126A
6.27
Lower
Hudson
Boat Basin
HR-037-0002A
2123A
12.9
Lower
Hudson
Boat Basin
HR-038-0002A
2124 A
13.25
Lower
Hudson
Boat Basin
2-31
1 MAS! Gradient
-------
Supplemental High-Resolution Core Top Samples (Continued)
TAMS Sample
ID
LDEO
No.
River Mile
Corresponding Core
(and RM)
Location
HR-039-0002A
2121A
17.9
Lower
Hudson
Boat Basin
PCB Congener Analysis
Identifiers for high-resolution sediment core samples with associated PCB congener data
contain a "P" in the TAMS Type field with few exceptions. Those samples labeled with a "G"
should not be used since these are quality control samples; these samples represent large core
slice intervals from co-located cores without any radionuclide information. High-resolution
sediment cores should not be grouped collectively into one large data set for data analysis due
to major differences in in-situ conditions, local PCB loadings and variations in sediment
deposition rates. Core samples ending with an "A" with associated PCB results generally
represent core slices from the 0- to 2-cm interval in a supplemental high-resolution core given
in the table above. For all cores in the above table, information on the beryllium-7 and cesium-
137 levels in the core interval is also available. For the supplemental cores collected in the
Upper Hudson, these "A" samples were analyzed for PCBs and radionuclides because the
beryllium-7 levels in the comparable "P" core slice were not detectable.
The PCB congener data include averaged co-located sample pairs identified by the Split
field in the PCBS database table. The original duplicate pair results can be found in the PCBSD
database table.
For the calculation of the Value2 and the homologue, total PCBs and Aroclor sums, the
high-resolution core results were grouped geographically, as previously described in Section 2.5.
The sample grouping used for determining frequency of non-detected PCB congeners is provided
below.
2-32
TAMS I Gradient
-------
High-Resolution Sediment Core Sample Groups for Determining
Frequency of Non-Detected PCB Congeners
Group
Core Numbers
River Mile
Upper River
15, 16, 18, 19, 20, 21, 22,
23, 25, 26, 28, 32, 34, 35
197.3 to 156
Lower River freshwater
10, 11, 13, 14, 30, 31
153 to 60.1
Lower River saline
1, 2, 3, 4, 5, 6, 7, 8, 9,
36, 37, 38, 39
60 to -2 1
Background and tributaries
12, 17, 24, 27, 29, 33
Conventional Parameters
All conventional parameters are stored in the table NONPCBS except for the radionuclide
data which resides in RADNUC. For information regarding total carbon/total nitrogen and total
inorganic carbon refer to the discussion in Section 2.5.2 concerning the confirmatory sampling
program. All high-resolution sediment core grain size analyses were performed using the laser
particle method. However, there were two sample types: small-volume (SV) and large-volume
(LV).
The LV samples provide an accurate, unbiased representation of grain size distribution
(i.e., percent gravel, sand, silt, and clay). It should be noted, however, that these samples
represent 8-cm slices from 0 to 8 cm in depth as noted in the TAMS ID field. These samples
were obtained exclusively from the "G" core. There is one LV sample per core except for core
25. All other high-resolution grain size samples are SV samples and should only be used to
represent differences in the fine-grained fraction (silt, clay and possibly sand) among samples.
These samples have a "P" or an "A" in the TAMS Type field. Core samples for grain size
distribution analysis were obtained from the co-located "A" core for the upper four core slices,
i.e., intervals 0 to 2, 2 to 4, 4 to 6, and 6 to 8 cm, because of sample volume limitations. The
remaining SV samples were collected from the "P" core. Because of the general homogeneity
of sediment in an individual high-resolution core, the grain size distribution results from the "A"
core can be correlated with the other analyses for the corresponding "P" core intervals without
additional correction. Total organic nitrogen data were obtained for a subset of the high-
resolution core samples. All TON samples were obtained from the core intervals below eight
centimeters because of sample volume limitations. The TON values measured by Chemtech do
not correspond well to the total nitrogen values measured by the Lamont-Doherty Earth
Observatory method which may be partially due to the differences in analytical techniques.
Measurements of radionuclides in high-resolution core sediments, including l34Cs, I37Cs,
7Be, and "Co, were provided by Lamont-Doherty Earth Observatory. There were no field co-
2-33
TAMS/Gradient
-------
locates or splits for these samples. These data are reported with the measured value as well as
a counting error representing a one standard deviation error. In general, the reported value must
be greater than two standard deviations to be considered a detection.
2.5.4 Low-Resolution Sediment Coring Program
The low-resolution sediment coring program took place during July and August 1994.
Figures 2-17A through 2-17D show these coring locations.
The results of the low-resolution sediment coring program are contained in the
PHASE2\SEDIMENT subdirectory along with the confirmatory sample results. Both data sets
can be used to characterize the sediments of the Upper Hudson. Samples collected for the low-
resolution coring program are labeled with an initial "LR" or "LH" and generally follow the
other sediment core naming schemes. The "LR" refers to cores collected in the Thompson
Island Pool. The "LH" refers to cores collected in hot spot areas below the Thompson Island
Dam. The middle three digits in the TAMS ID refer to the core location. The first two digits
give the coring site or cluster and the last digit, a letter, refers to the location within the cluster.
For LR samples, the core site refers to Phase 2 coring clusters and has no relationship to any
specific hot spot. For the LH samples, the site number refers to the original NYSDEC hot spot
number (Numbers 25 to 40). There are also several LH sites with numbers greater than 40.
These represent additional sites sampled during the program.
The last four digits of the TAMS ID refer to the sediment sampling depth. However,
due to the extensive length of the low-resolution cores, these digits represent inches, not
centimeters as in the other core identifiers. For example, LR-10D-0001 represents the sample
from the fourth core (D) collected in the Thompson Island Pool at cluster 10 obtained between
0 (00) and 1 inch (01) of depth. LH-25A-0816 represents the sample from the first core
collected at hot spot 25 obtained between 8 and 16 inches of depth.
The letters "D" and "M" are used in the TAMS Type field. "D" signifies a field split
sample. These sample results are located under the PHASE2\SEDIMENT\QA QC subdirectory
in the tables PCBSD, LASERGSD and SIEVEGSD. Field splits are not averaged. The "M"
indicates the sample was collected for laboratory quality assurance in addition to its regular
purpose. These sample results can be used as regular analyses.
It is important to note that the locations for the confirmation and low-resolution core sites
were surveyed in place by licensed surveyors. The coordinates reported for all other programs
represent estimates made from various maps and are of lesser accuracy.
Analytical Results
PCB congener results are reported in PCBS and PCBSD in the PHASE2\SEDIMENT
subdirectory following the same PCB result summation process described for the water column
2-34
1 MAS! Gradient
-------
and high-resolution coring program. The low-resolution coring data were considered to be one
group for the treatment of non-detect results.
As part of the low-resolution coring program, samples were analyzed for PCB congeners,
grain size distribution by both laser particle and sieve techniques, radionuclides and total organic
carbon. Bulk density was determined for the sample by directly weighing a measured volume
in the field. Particle density was determined using the bulk density result and the percent solids
measurement determined on a large fraction of the sample. Like the confirmatory samples, both
grain size and descriptive data are available to characterize the low-resolution core
sediments. Grain size data are available for all low-resolution core tops based on laser particle
analysis. Grain size distributions based on the standard sieve and hydrometer analysis are
available for about 150 samples. Reduction-oxidation (Redox) data are available for some low-
resolution cores. In total, these data will be used to characterize the sediments of the Hudson
as well as to compare current conditions with those measured by previous studies, particularly
the 1984-1985 NYSDEC sediment survey.
2.5.5 Ecological Program
The Ecological Program under Phase 2 included a field investigation which took place
in August and September 1993. The ecological field results are located in the PHASE2\ECO
subdirectory; the sampling stations are shown in Figures 2-18A and 2-18B for the Upper and
Lower Hudson, respectively.
The ecological field investigation involved the collection of fish, benthic invertebrates,
and sediments from 20 sites located throughout the Hudson River (See Table 2-10). Five sites
were within the Thompson Island Pool. At each sampling site various combinations of fish,
benthic invertebrates and sediments were collected, generating up to five co-located samples per
medium per site. Fish and benthic invertebrate samples were classified and sorted by species
prior to analysis. In some cases, benthic invertebrate species were recombined into total benthic
invertebrate samples. Data were obtained for the fish and benthic invertebrate samples defining
the individual and average animal length and weight.
Ecological samples can be identified by an initial "EC" in the TAMS ID. The next digit
refers to the matrix: "F" for fish, "B" for benthic invertebrate, and "S" for sediment. The fourth
and fifth digits define the station number 1 through 20. The last four digits define the co-located
number for the sample. The second identification field, TAMS Type, is used to indicate field
split samples for the benthic invertebrate and sediment samples. No field splits or co-locate
samples were obtained for the fish analysis program. Sediment and benthic invertebrate field
split samples are labeled with a "D." The samples labeled with an "M" are laboratory quality
assurance samples but the data are of equal quality to any other result. Because of the additional
complexity of animal species information, a third field, Species, was added to the ecological
sample identification. In the database tables, the species are represented by a four-letter code.
The key for the species code will be found in the SPECIES data table in the Phase2\ECO
subdirectory. Two examples of the ecological sample ID are given here. EC-F03-0002
2-35
TAMS / Gradient
-------
represents the second co-located sediment sample collected at ecological station 3. EC-B05-0004-
IS represents the fourth co-located benthic invertebrate sample from station 5 consisting of
isopods.
In a limited number of cases, the benthic co-located samples from a given site did not
contain sufficient material to generate a sample. In these cases, two samples were composited.
These are noted in the last four digits of the TAMS ID field whereby the first two digits give
the first co-located sample number and the second two digits give the second co-located sample
number. For example, EC-B12-0203 represents the composite of co-locate numbers 2 and 3
from ecological sampling site 12.
Note that the co-locates for each medium do not match exactly, i.e., co-locate number
1 for sediment must not be matched to co-locate number 1 for benthic invertebrates. Instead, co-
locates for each matrix should be compared as a single unit to co-locates in another matrix for
the same site. In general, due to the inherent difficulties in fish collection, the area represented
by the sediment and benthic invertebrate samples for a given station was smaller than that for
the fish sample.
Analytical Results
PCB congener analyses were performed on fish, benthic invertebrates and sediment
samples. Every station did not, however, have samples from all three matrice. PCB results
were tabulated in Valuel, Value2 and the various sums described in previous sections.
However, due to improvements in the analytical techniques, an additional 13 congeners were
added to the list of reported PCB congeners. These 13 were ignored for the purpose of
generating homologue, total PCB and Aroclor sums so as to maintain consistency across the
entire Phase 2 data set.
In addition to PCB congener analyses, data were obtained on percent lipid content, animal
weight and length for fish samples. Fish samples were analyzed by species. For the benthic
invertebrate samples, percent lipid content and total sample mass weight were measured.
Benthic invertebrate samples were analyzed by species when sufficient individuals were present.
Species composite samples were also run. Sediment analyses included total organic carbon, laser
particle grain size distribution, and metals.
The data pertaining to non-PCB analyses are located in the PHASE2\ECO subdirectory
in the NONPCBS and NONPCBB tables for sediment and biota data, respectively. Specific fish
and benthic invertebrate sample information such as length can be found in the FISH and
BENTHIC database tables. Sample groupings for the purpose of dealing with non-detect results
can be found in the GROUPS data table.
2-36
JAMS/Gradient
-------
2.5.6 Calculated Flow Data
Flow measurements at the USGS stations at Waterford and Stillwater were not available
in 1993 due to construction in these areas during this time period. As a result, flow at these
locations had to be estimated from other available data. The creation of the flow estimates is
documented in the Data Evaluation and Interpretation Report. In general, flows were estimated
based on the reported flow at Fort Edward and the staff gauge readings collected at the locks
of the Upper Hudson. Calculated flow data are contained in the table FLOW93 in the
PHASE2XFLOW subdirectory.
Flows were calculated for January through September 30, 1993 for the Hudson River at
both Stillwater and Waterford. The data table also contains two additional fields indicating the
specific model used to calculate a given day's flow. Several flow calculation models were used
for each station to allow each day's flow to be calculated with all available data for that day.
The details of the models are provided in the Data Evaluation and Interpretation Report.
Since the creation of these flow estimates, the USGS has released its own estimate of
flow at these locations. These estimated flows are included in the database tables under the
USGS subdirectory. However, all flow and transport analyses conducted for 1993 for the
Reassessment utilize the flow estimates contained in FLOW93.
2.6 NOAA Ecological Sampling Program
During the ecological field investigation, additional fish samples were obtained by the
field crew and provided to the National Oceanic and Atmospheric Agency (NOAA). These
samples were intended to supplement the Phase 2 ecological investigation. These samples
represent fish from 10 of the 20 ecological sampling sites.
The NOAA results are in the NOAA subdirectory. Because they were collected during
the Phase 2 investigation, they have been labeled in the same manner as the Ecological Program
samples. In fact, the structures of the sample identification fields (TAMS ID, TAMS Type and
Species) as well as the data table structures themselves are identical to the Phase 2 ecological
data set. The TAMS Type field is labeled with an "N" to indicate that these samples were
analyzed by NOAA.
The samples were analyzed for PCB congeners by the same laboratory and technique
used for the Phase 2 investigation. In this manner, the data are analytically identical to that of
Phase 2. The only analytical difference arises from the data validation. NOAA samples will be
validated to NOAA standards while the Phase 2 data are validated to USEPA standards. This
difference is unlikely to affect the comparability of the data sets. The PCB congener results were
treated identically to that of the Phase 2 data, with Value I, Value2 and the congener sums
generated in the same manner.
2-37
T AMS/Gradient
-------
In addition to PCBs, data were obtained for percent lipid content, animal length, and
weight for the NOAA samples. The percent lipid data are located in the NONPCBB table. In
addition, the animal length and weight data are located in the FISH table.
2.7 Aroclor Standard Analysis
As part of the Phase 2 analytical program, analytical standards representing six Aroclor
mixtures were obtained from ULTRA Scientific of North Kingstown, RI and AccuStandard, Inc.
of New Haven, CT. These standards represented Aroclors 1221, 1232, 1242, 1248, 1254 and
1260. The analyses were performed by the contract laboratory on three separate occasions, once
in September 1992 and twice in April 1994, using the same analytical system as used for the
Phase 2 PCB congener analyses. These results were used to characterize the Aroclors on a
congener-specific basis. This information in turn became the basis for assigning individual
congeners to each Aroclor for the purpose of determining Aroclor concentrations in Phase 2
samples.
The results of the Aroclor standard analyses are contained in the file AROCLSTD under
the PHASE2 directory. The criterion for assigning a congener to an Aroclor was based on mass
percentage. Specifically, if a congener represented 0.1% or more of the mass in a given
Aroclor, it was included in the Aroclor concentration estimate (or sum). The results of applying
this criterion to the Aroclor standard analyses are summarized in the table ASCREEN in the
PHASE2 directory. This table shows the assignments of each congener to the six Aroclor
standards. The table is structured as a matrix of congener number by Aroclor standard. When
the congener is assigned to a specific Aroclor, a value of unity is placed in the corresponding
cell. When a congener is not considered present in the Aroclor standard, the cell is left blank.
2-38
TAMS/Gradient
-------
3. DATABASE USER'S GUIDE
3.1 Assumptions
This guide to using the database assumes a basic knowledge of computer database
management software. Skills needed to navigate the database include the ability to browse
(fatahas« tables, to link multiple tables in a database query, and to apply simple logic in a
datahas* query for extracting the appropriate information. The database was developed in the
PC-based Paradox™ 4.0 database management system but may be used in other relational
database management packages provided they are compatible with the electronic file formats.
Database files are provided on CD-ROM in two formats, the original Paradox™ 4.0 format and
a FoxPro™/DBase 111™ format. Comprehensive documentation of electronic files is provided in
this chapter, including field definitions for database tables and diagrams of database linkages.
Practical examples for common queries and applications of the database are provided in this
chapter.
3.2 Data Dictionaries and Glossaries
Data dictionaries for all database tables are provided in this report. The data dictionaries
are grouped by directory and subdirectory. Each set of directory and/or subdirectory data
dictionaries is preceded by a table listing data dictionaries contained within. The database
contains more than 100 tables; refer to the list of tables given in the table of contents. As this
chapter touches on each of the database components, the reader will be referred to the relevant
data dictionaries. The glossaries which define the terms of the database are contained in the
database itself. (See Figure 2-2 for files coded with an asterisk).
3.3 Using the Data
A theme common to nearly all components of the TAMS/Gradient Hudson River database
is the notion of the one-to-many relationship. Simply put, a one-to-many relationship exists
when a single record or row in one database table links to many records in another database
table. This design suits the nature of monitoring data because often multiple parameters are
associated with a single sampling location. Figure 3-1 shows an example of one-to-many
relationships from the PHASE2\HRCORES subdirectory. In the center is the STATIONS table
where one record representing a single sampling location is linked, not only to many records in
the PCBS table containing the congener results, but also to many records in the NONPCBS
table containing conventional or non-PCB results. Each table is linked by the TAMS ID and
TAMS Type fields. This figure illustrates the basic building block in the database design, and
understanding the approach described will assist the reader in properly applying data analysis
to the database. Specific details inherent to each data set vary among directories and are covered
below.
The remainder of Section 3-3 discusses the individual data directories and the
relationships among the database tables. Each directory is represented in a figure showing these
3-1
T AJASI Gradient
-------
relationships. In these figures, rectangles are used to distinguish reference tables; circles denote
tables which provide sample definitions; diamonds represent tables which contain analytical and
field data The sizes of these shapes are varied to emphasize the main database tables. The
main riatahaiw tables are emphasized in the larger circles and diamonds.
3.3.1 Historical Data
Table 3-1 describes the look-up table HIST_LUT in the HISTORIC directory. The
HIST LUT table is a glossary for the database parameters and fields contained in the databases
of the HISTORIC directory. In addition, Table 3-2 describes the PARAMKEY table in the
HISTORIC directory. The PARAMKEY table provides a parameter key for the GE89 table
under the HISTORIC\SED subdirectory and the CONCFISH table in the HISTORICFISH
subdirectory.
Sediment Data
In the historical sediment subdirectory, there are more than 4,700 samples for the period
1976 through 1990. Figure 3-2 shows how the tables in the HISTORIC\SED subdirectory are
linked. A listing of the database tables follows, and is also provided in Table 3-3. Database
table field definitions are given in Tables 3-4 through 3-16.
Tables in HISTORIC\SED Subdirectory
Table Name
Description j
SAMPLES
Sediment sampling information
NYSDEC/OBG (1976-1978)
NYSDEC/NYSDOH (1984-1985) |
GE/Harza (1990) |
STATIONS
Station number correspondence to GradNo (a unique sample identifier
for database purposes)
GRADNUMS
Core section correspondence to GradNo sample identifier
SECTION
Section number, depths, and correspondence to GradNo sample identifier
REACHES
River reach numbers
CONCSED
PCB Aroclor data - sediment samples
NONCHEM
Non-PCB data • sediment samples I
SOXHDUP
Duplicate PCB Aroclor data using soxhlet extraction
NONDETS
Key to non-detected qualifier codes
REF
Key to references used in building the database
3-2
TAMS/Gradient
-------
Tables In HISTORlC\SED Subdirectory (Continued)
Table Name
Description
TFYTTTBF^
JL JCraAk. 1 VJRJCO
Sediment description key
GES9
Preliminary 1989 GE sediment baseline studies GE/Harza (1989)
MASSP1C
Results for GC/MS performed for sediments collected during 1984-1985
NYSDEC survey of Upper Hudson
As an illustration of the database format, excerpts from the main sediment database tables
are summarized below in four tables. Each of these tables is linked by a unique sample
identification number (GradNo), e.g., 30000, 30016, 30032 and 30208 shown here.
The SAMPLES table contains information including sample date, location (River Mile,
distance from bank, and northing and easting coordinates, where available), sample type (grab
versus core), water depth, surface elevation, and type of sampler used. The table below
provides example records, although precise field names have been expanded from their
abbreviations so that the reader need not refer to the field definitions.
Excerpt from the Sample Information Table (SAMPLES)
QndNo
Type
M/D/YK
River
Mile
Feet from
WettBuk
Northing
(ft)
Simpler
Wmer
Depth
Ek*
<1»
30000
Otab
5/21/77
168.*
330,05
1071755
68369$
100
30016
Core
3/18/77
188.4
100.0
1163740
698970
100
5.8
119.6
30032
Core
3/18/77
183.4
60.0
1140410
669040
100
2.2
102.4
30208
Core
6/«7S
192.5
•
1182860
696330
40
7.0
119.2
Core samples in the SAMPLES table are linked by GradNo with the core section
(SECTION) table, which identifies the length of each core sample section and the depth beneath
the river bottom, i.e., the interval of sample penetration given by the top and bottom of each
section. Only core sample IDs appear in the SECTION table and many sections are associated
3-3
T AMS/Gradient
-------
with a single sampling location. No grab sample IDs appear in the SECTION table because no
depth intervals are associated with them.
Excerpt from the Core Section Table (SECTION)
OndNo
Core Section No.
Bottom of Section (in)
Top of Section (in)
30016
1
1
0
30016
2
2
1
30016
12
12
11 I
30208
1
6
0 I
30208
2
9.5
6 |
30208
3
12
« 1
Most database queries involve linking SAMPLES (and SECTION, for cores) to the main
database table containing the PCB results, CONCSED. Selecting a GradNo from SAMPLES
and SECTION and locating the same GradNo in the CONCSED data table shows either the
Aroclor results for an entire grab sample or section-by-section results for core samples.
Additional information describing analytical measurement methods, that is, extraction method,
are contained in the database as available.
Excerpt from the Chemical Data Table (CONCSED)
OndNo
Parameter
Core Section No.
Extraction Method
Conceantioa (ppm)
30000
Aroclor 1016
shake
1.0
30000
Aroclor 1221
shake
1.0
30000
Aroclor 1234
•hake
1.0
30016
Aroclor 1016
4
soxhlet
6.0 I
30016
Aroclor 1254
12
soxhlet
0.1
30032
Aroclor 1016
5
soxhlet
234.0
30032
Aroclor 1254
5
soxhlet
163.0
3-4 T AMS/Gradient
-------
Finally, non-chemical data, such as sediment texture class and percent volatile versus
total solids, are contained in the NONCHEM table. SAMPLES is linked to NONCHEM
through the GradNo. The same IDs for the example records for the previous tables are shown.
Excerpt from the Non-Chemical Data Table (NONCHEM)
II OndNo
Core Section No.
PlflfllftW
Vttoe |
| 30000
% total Mtidi
78.93
1 30000
* voWk *oWi
0.S5
J 30016
1
kJUuic
GRAVEL
| 30016
4
« tool tottds
83.97
I 30016
4
S voUtik *obd<
2.2 |
;
30016
12
% toUl tottfe
89.23
30032
1
tCXtUR
CL-WC
30032
S
% volatile Mbdi
25.39
The remaining database tables provide reference information for the main database tables.
STATIONS is a two-field table that shows the correspondence between the assigned GradNo
and the original NYSDEC or GE station number. GRADNUMS cross-references the Agency
or investigator who collected the data and is linked back to SAMPLES and REF. Duplicate
PCB measurements made using soxhlet extraction reside in a side table called SOXHDUP. Hie
key to non-detected data qualifier codes is given in NONDETS. REACHES indicates the
upstream and downstream river miles associated with river reach numbers for the Upper Hudson
River. The last table in the HlSTORIC\SED subdirectory, GE89, holds the preliminary 1989
GE baseline studies results separate from the other database tables.
Fish Data
Figure 3-3 shows how the database tables contained in the H1ST0RIC\FISH subdirectory
are linked. Table 3-17 and the table below describe the contents of each database table. Tables
3-18 through 3-25 explain field names and types in more detail. Results for over 10,000
samples collected from 1973 through 1993 are available in three main database tables:
GRADNUMF, SAMPLEF, and CONCFISH. These three tables accommodate most database
queries. GRADNUMF provides the master index to sample IDs (GradNo) and the
corresponding original NYSDEC sample identifiers: laboratory number (Labno) and sample tag
3-5
TAMS/Gradient
-------
identifier (Tagno). SAMPLEF is similar to the SAMPLES table found in the HISTORIC\SED
subdirectory and contains sampling information such as location descriptor, river mile, sampling
date, species and preparation code. If a sample is composed of more than one individual fish,
there will be a number greater than 1 in the Noincomp field (number of fish in composite) and
a record in the COMPOS table connecting sample group weight and length statistics to the
sample record. SAMPLEF is linked to the data table with all the PCB Aroclor and percent lipid
results called CONCFISH through the sample ID (GradNo). The four tables, PARAMKEY,
PREP, SPECCODE, and REF, contain keys to parameter codes, preparation codes, species
codes and references, respectively, used in building the database. Finally, the CORRNUM table
identifies corresponding old and new sample identifiers which have changed for some samples
between the Phase 1 Report and this Report.
Tables in HISTORIC\FISH Subdirectory
Table Name
GRADNUMF
Description |
Master index to GradNo
SAMPLEF
Fish sampling information (location, sex, age )
CORRNUM
Correspondence between old and new GradNo
COMPOS
Sample information for composite samples
| CONCFISH
PCB Aroclor and percent lipid data - fish samples
| PREP
Key to tissue and preparation codes
I SPECCODE
Key to species codes
I REF
Key to references used in building the database
Macroinvertebrate Data
Some macroinvertebrate data are available in the HISTORIC\MACROINV subdirectory.
Figure 3-4 shows the database table relationships. The contents of each table are described
below and in Table 3-26, while Tables 3-27 through 3-33 define the database fields. The
macroinvertebrate sampling information in SAMPLE is linked through the sample ID field,
GradNo, to the CONC table which contains the PCB Aroclor measurements. Species codes,
sample type codes, and the number of individuals per sample are given in SPECCODE,
SAMPREF and NUMINDI, respectively. There are approximately 800 samples but not all
species could be identified based oh the original documentation. DOHSITE contains multiplate
and caddisfly sampling location information.
3-6
JAMS/Gradient
-------
Tables in HISTORIC\MACROINV Subdirectory
Table Name
Description |
SAMPLE
Macroinvertebrate sampling information |
SAMPREF
Key to sample type j
NUMINDI
Number of individuals in samples |
CONC
PCB Aroclor results
OTHER
Additional species included in samples
SFECCODE
Species codes
DOHSITE
Multiple and caddisfly sampling information
3.3.2 Lamont-Doherty Earth Observatory
The LDEO directory contains four seif-descriptive spreadsheet tables which provide
several sediment core results as well as a PCB sediment/water partitioning study.
3.3.3 USGS
The database glossary for field names and parameters contained in the database tables
under FLOW and WQDATA subdirectories is provided in the look-up table USGSJLUT in the
USGS directory (See Table 3-34). A listing of the database tables follows, and is also provided
in Tables 3-35 and 3-37. Database table field definitions are given in Tables 3-36 for
USGS\FLOW and 3-38 and 3-39 for USGS\WQDATA.
Tables in USGSSFLOW Subdirectory
Table Name
Description f
FTEDWD
Mean daily Hudson River flow at Fort Edward, 1976-1993
GREEN
Mean daily Hudson River flow at Green Island, 1946-1993
HADLEY
Mean daily Hudson River flow at Hadley, 1921-1993
CORINTH
Mean daily Hudson River flow below Sacandaga River near Corinth, 1921-1993
SCHU
Mean daily Hudson River flow at Schuylerville, 1977-1979
STILL
Mean daily Hudson River flow at Stillwater. 1977-1993
WATR
Mean daily Hudson River flow at Waterford, 1976-1993
BATK
Mean daily Batten Kill flow at Battenville, 1922-1968
3-7
JAMS) Gradient
-------
Tables in USGS\FLOW Subdirectory (Continued)
| Table Name
Description
1 HOOS
Mean daily Hoosic River flow near Eagle Bridge, 1910-1993 f
1 SACAND
Mean daily Sacandaga River flow at Stewarts Bridge, 1907-1993 |
1 MOHK
Mean daily Mohawk River flow, 1917-1993 [
| USGS7693
Mean daily flow at all above stations, except Battenville, 1976-1993 |
The USGS\FLOW subdirectory includes USGS mean daily flow data in cubic feet per second
collected at various stations.
Tables in USGS\WQDATA Subdirectory
Table Name
Description j
USGSWQ
Water-column PCB, suspended sediment data, and sediment load, in tons/day,
collected by the USGS
TOCDAT
Water-column total organic carbon (TOC) collected by the USGS
The USGS\ WQDATA subdirectory includes water column PCB, total suspended sediment data,
and sediment load in tons/day in USGSWQ and water column total organic carbon data in
TOCDAT.
3.3.4 GE Data
The TAMS/Gradient team received data for over 2,000 samples from GE in several files,
the most recent being GE081895.DBF and CP081895.DBF received in August 1995. The
former file contains all the field sampling information, the homologue distributions, and the total
PCB measurements for all sampling surveys combined. The latter contains the congener
concentrations for all sampling surveys combined. The results have been divided into five main
database tables with one reference table and three glossaries as shown below as well as in Table
3-40 and Figure 3-5. Data dictionaries for tables contained in GE are provided in Tables 3-41
through 3-49.
3-8
TAMS/Gradient
-------
Tables in GE Directory
Table Name
Description
SAMPLE
Sampling information for all GE data contained in this directory
PCB
PCB data for all media
PCBHOMOL
PCB homologue data for all media |
PCBCONG
PCB congener data for all media |
NONPCB
Non-PCB data for all media
SPECCODE
Fish species code
PCBLUT
Congener data glossary
GEPARAMS
Parameter abbreviations glossary
FTELDLUT
Database field glossary H
Sampling information such as sample date, location and medium {e.g., water, sediment
or biota) reside in the table SAMPLE. Samples for all matrices were assembled into a single
SAMPLE table and hence not all the fields pertain to every record. For instance, Age applies
only to biota or fish samples and not to sediment, water or pore water samples. Where a field
does not apply, the entry remains blank or contains or a "0" as a placeholder. The SAMPLE
table is linked to all the PCB and non-PCB results through the NEA_flle identifier. Total PCB
values, qualifiers, and quantitation limits are given in PCB for all media. Homologue
distributions by mole percent and by weight percent are given in PCBHOMOL for all media.
Congener concentrations are given in PCBCONG for all media. It appears that GE reported
non-detected congeners as "0" in PCBCONG. NONPCB holds all conventional parameters,
such as total suspended solids and total organic carbon, with abbreviations explained in
GEPARAMS. A key to the congener peak numbers is provided in PCBLUT which also gives
a corresponding BZ number to relate these results to those being analyzed under the Phase 2
sampling programs.
3.3.5 New York State Department of Transportation
The NYSDOT directory contains the table GAUGES which provides the readings of staff
gauges listed in Table 3-50.
3.3.6 Phase 2 Data
Database glossaries CONG_LUT, FIELDS, PARAMS and QUALIFY in the PHASE2
directory are described in Tables 3-51 to 3-54 and serve as keys to congener, field name
parameter and qualifier definitions, respectively, for tables in the PHASE2 directory. Data
3-9
T AM SI Gradient
-------
dictionaries for AROCLSTD and ASCREEN are presented in Tables 3-55 and 3-56,
respectively.
Water Column Study Data
The PHASE2 \ WATER subdirectory combines the results from the water column transects,
flow-averaged events, and PCB equilibration study under the Phase 2 sampling effort. The
relationships between the main database tables, i.e., GROUPS, STATIONS, PCBW, PCBP,
and NONPCBW, are shown in Figure 3-6. All tables in the subdirectory are listed below and
in Table 3-57, and field definitions are given in Tables 3-58 through 3-64.
Listing of Tables in PHASE2\WATER Subdirectory
(including Tables in PHASE2\WATER\QA_QC and PHASE2\WATER\EQUILIB)
Table Name
Description
STATIONS
Water column transects and flow-averaged events stations
GROUPS
Sample groupings
PCBP
PCB congeners/homologue sums/Aroclor concentrations - particulate samples (jig/Kg)
PCBPD
PCB congeners - particulate duplicate pairs (pg/Kg)
PCBPE
PCB congener - particulate samples - equilibrium study (jig/Kg)
PCBFA7
PCB congeners/homologue sums/Aroclor concentrations • combined particulate and
dissolved samples (ng/1) for flow-averaged event 7 |
PCBW
PCB congeners/homologue sums/Aroclor sums - water samples (ng/L)
PCBWD
PCB congeners - water duplicate pairs (ng/L)
PCB WE
PCB congeners - water (dissolved) samples - equilibration study (ng/L)
PCBWTT
PCB congeners - whole water samples (TT series) (ng/L)
NONPCBW
Non-PCB data - water column samples
NONPCBWD
Non-PCB data • water duplicate sample pairs
FB
Non-PCB data - field blanks
VOLUMES
Sample volumes filtered for PCB analyses
The STATIONS table contains sampling information such as the transect or flow-
averaged event number, station number, sample identifier and type, river mile, and northing and
easting coordinates where known. The sampling stations are associated with distinct zones in
the river identified in GROUPS. STATIONS is linked to the six PCB data tables, i.e., PCBP,
PCBW, PCBPE, PCB WE, PCBFA7 and PCBWTT, through the TAMS ID and TAMS Type
fields. Because congener results from the various efforts are so distinct (e.g., sampling method
3-10
TAMS/Gradient
-------
or matrix), the TAMS/Gradient team felt it necessary to divide the data into separate tables to
prevent mixing of data types.
PCBP and PCBW contain particulate and "dissolved" (i.e., filtered water) PCB congener
data, respectively, for the water column transects and the flow-averaged events. While duplicate
pairs have been removed from the main database tables to PCBPD, for particulate or suspended-
matter data, and PCBWD for dissolved-phase data, composited results following the method
described in Chapter 2 have been returned to the main database tables, i.e., PCBP and PCBW.
The data in PCBP have been reported on a mass per unit mass basis, the same as the Phase 2
sediments. These values were obtained by dividing the reported results (ng/filter) by the volume
filtered and the TSS value for the sample.
The results for the equilibration study are separate from the main database tables;
PCBPE and PCBWE contain the equilibration study results for the particulate and dissolved
fractions, respectively. A few whole-water PCB congener analyses were performed on samples
taken for Transect 1 and the results reside in PCBWTT. Non-PCB measurements such as total
suspended solids (TSS), dissolved organic carbon (DOC), and chlorophyll-a are given in
NONPCBW.
As is the case with the PCB congener data, duplicate pairs have been placed in a
supplementary table NONPCBWD with composited results placed in NONPCBW. Minor tables
in this subdirectory include FB, which contains non-PCB data field blanks, and VOLUMES,
which indicates the volume of water sample filtered for PCB analyses.
Sediment
The method for linking database tables in the PHASE2 \SEDIMENT subdirectory is given
in Figure 3-7. A listing of all tables in the PHASE2 \SEDIMENT subdirectory is given below
and in Table 3-65, while data dictionaries are given in Tables 3-66 through 3-73.
Tables in PHASE2\SEDIMENT Subdirectory
(including Tables in PHASE2\SEDIMEimQA_QQ
Name
Description f
STATIONS
Confirmatory samples and low-resolution core sampling stations
PCBS
PCB congeners/homologue sums - sediment samples (jig/Kg DW) • low-
resolution samples only [
PCBSD
PCB congeners - sediment samples pairs (fig/Kg DW)
NONPCBS
Non-PCB data - sediment samples
3-11
7 AMS/Gradient
-------
Tables in PHASE2\SEDIMENT Subdirectory (Continued)
Name
Description
NONPCBSD
Non-PCB data • duplicate sediment sample pairs
FB
Non-PCB data - field blanks
| SIEVEGS
Grain size distribution data by sieve analysis
SIEVEGSD
Grain size distribution data by sieve analysis - sample duplicates
LASERGS
Grain size distribution data by laser particle analysis J
LASERGSD
Grain size distribution data by laser particle analysis - sample duplicates
RADNUC
Radionuclide data - sediment samples - low-resolution only
RADNUCD
Radionuclide data - sediment samples field splits and laboratory duplicates
LRINFO
Supplemental information for low-resolution core samples only
SEDDESC
Descriptive sediment classifications, density, redox and other field data
As in the PHASE21WATER subdirectory, a STATIONS table establishes the sampling
locations either by river mile or by northing and easting pairs. The core depth interval for each
sample is also indicated in this table. It was not necessary to break PCB congener results into
multiple tables, as was the case for the water column study. PCBS holds all the PCB congener
results including composited duplicate samples as described in Chapter 2. The original duplicate
pairs are retained in PC BSD. PCBS and PCBSD are linked back to STATIONS through the
TAMS ID and TAMS Type. No other PCB tables are included in this directory because only
a single matrix (sediment) was sampled. Note that these tables do not contain results for the
high-resolution coring study, which are given in the PHASE2\HRCORES subdirectory.
The tables NONPCBS and NONPCBSD contain all the non-PCB results including total
carbon, total nitrogen, total inorganic carbon, total organic nitrogen, the C:N ratio, and
summary grain size analyses in sediments. Again, NONPCBSD holds all the duplicate pairs,
while NONPCBS holds composited duplicate results, and FB holds the field blank results.
Radionuclide data generated for these samples required some additional fields not needed for the
other data tables, such as Detector, for detector type, and Sigma, for the standard deviation of
the counting result. RADNUC contains all radionuclide data; RADNUCD contains only
sediment sample duplicate data. These two tables, together with PCBS and PCBSD, contain
only low-resolution sampling information. The remaining tables in this subdirectory contain
information on both low-resolution and confirmatory samples. Detailed laser grain size data
including composited results are contained in LASERGS while sample duplicates are contained
in LASERGSD. SEDDESC provides descriptive sample information based largely on field
observations for both confirmatory and low-resolution coring samples. LRINFO provides
information pertaining to low-resolution coring sites. Specifically, it provides the corresponding
1984 NYSDEC sediment survey station number from Brown, et. al (1988) for the coring sites
3-12
T AMS/Gradient
-------
located in the Thompson Island Pool. It also provides the hot spot number for low resolution
coring sites below the Thompson Island Dam.
Ecological Sampling
The tables contained within the PHASE2\ECO directory are shown in the table below.
The data dictionaries are contained in Tables 3-75 through 3-84. Figure 3-8 illustrates how the
database tables are linked.
Tables in PHASE2\ECO Subdirectory
(including Tables in PHASE2\ECO\QA_QC subdirectory)
Table Name
Description |
STATIONS
Ecological survey stations
COORDS
Coordinates for stations
GROUPS
Sample groupings
BENTHIC
Sample composition information - invertebrates |
FISH
Sample composition information - fish |
PCBFISH
PCB congeners/homologue sum/Aroclor concentrations - fish |
PCBFISHD
PCB congeners - diluted fish analyses |
PCBINV
PCB congeners/homologue sum/Aroclor concentrations - invertebrates
PCBINVD
PCB congeners - invertebrate dup. pairs/dilultion analyses
NONPCBB
Non-PCB data - biota
NONPCBBD
Non-PCB data - biota duplicate pairs
PCBS
PCB congeners/homologue sums/Aroclor concentrations - sediment samples (jig/Kg
DW)
PC BSD
PCB congeners • sediment duplicate pairs (/ig/Kg DW)
NONPCBS
Non-PCB data - sediment samples
NONPCBSD
Non-PCB data - sediment duplicate pairs
LASERGS
Sediment laser grain size data
FB
Non-PCB data - sediment field blanks
SPECIES
Key to species codes
LASERGSD
Sediment laser grain size data - duplicate pairs
3-13
T MAS! Gradient
-------
The STATIONS table, the main database table in the subdirectory, contains sampling
information such as TAMS ED, TAMS Type, Species and location by river mile. COORDS
is linked to STATIONS through the Station field, and contains locations by northing and easting
pairs as well as sample types collected (i.e., sediment, fish, benthic invertebrates). The
GROUPS table, containing stations grouped by location, is linked to STATIONS in the same
way. The LASERGS table contains grain size distribution data based on laser particle analysis
on the ecological samples, and is linked to STATIONS via the TAMS ID and TAMS Type.
LASERGSD, linked to STATIONS in the same fashion, contains information on duplicate
pairs. STATIONS is linked to the PCB data tables FCBS, PCBINV and PCBFISH through
the TAMS ID, TAMS Type and Species fields. The PCB tables, in turn, relate to the field data
tables, i.e., BENTHIC and FISH, through the same fields. The tables PCBSD and PCBINVD,
which contain duplicate pair information, are supplementary. PCBFISHD, also supplementary,
contains results for laboratory duplicate analyses for those samples requiring dilution.
NONPCBS and NONPCBB contain all the non-PCB results for sediment samples and biota
samples, respectively. Again, information about duplicate pairs can be found in NONPCBSD
and NONPCBBD. These are all linked to STATIONS through TAMS ID and TAMS Type
for sediment and TAMS ID, TAMS Type and Species for fish and benthic invertebrate samples.
FB contains field blank data for ecological sampling program.
High-Resolution Cores
Figure 3-9 illustrates how tables in PHASE2\HRCORES are linked. A listing of tables
in this subdirectory is given below and in Table 3-85. Data dictionaries are given in Tables 3-86
through 3-93.
Tables in PHASE2\HRCORES Subdirectory
(including Tables in PHASE2\HRCORES\QA_QC subdirectory)
Table Name
Description
STATIONS
Confirmatory Sampling and High-Resolution Sediment Coring Program sampling
stations
PCBS
PCB congeners/homologue sums/Aroclor sums - sediment samples Oig/Kg DW)
PCBSD
PCB congeners - duplicate sediment sample pairs (jig/YLg DW) |
NONPCBS
Non-PCB data - sediment samples
NONPCBSD
Non-PCB data - duplicate sediment sample pairs
FB
Non-PCB data - field blanks
LASERGS
Laser grain size Phi classes
LASERGSD
Laser grain size Phi classes • duplicate pairs
RADNUC
Radionuclide data - sediment samples
3-14
T AMS/Gradient
-------
Table Name
Description
RADNUCD
Radionuclide data • sediment sample laboratory duplicates
SEDDESC
Redox, density and additional field information
GROUPS
Sample groupings
As in the PHASE21WATER subdirectory, a STATIONS table establishes the sampling
locations either by river mile or by northing and easting pairs. The core depth interval for each
sample is also indicated in this table. In the PHASE21HRCORES subdirectory, sampling
locations in STATIONS are grouped by the identifiers supplied by the table GROUPS. It was
not necessary to break PCB congener results into multiple tables, as was the case for the water
column study. PCBS holds all the PCB congener results including composited duplicate samples
as described in Chapter 2. The original duplicate pairs are retained in PCBSD. PCBS and
PCBSD are linked back to STATIONS through the TAMS ID and TAMS Type. No other
PCB tables are included in this directory because only a single matrix (sediment) was sampled
in the high-resolution coring study.
The tables NONFCBS and NONPCBSD contain all the non-PCB results including total
carbon, total nitrogen, total inorganic carbon, total organic nitrogen, the C:N ratio, and
summary grain size analyses in sediments. Again, NONPCBSD holds all the duplicate pairs,
while NONPCBS holds composited duplicate results, and FB holds the field blank results.
Radionuclide data generated for these samples required some additional fields not needed for the
other data tables, such as Detector, for detector type, and Sigma, for the standard deviation of
the counting result. RADNUC contains all radionuclide data; RADNUCD contains only
sediment sample laboratory duplicate data. Detailed laser grain size data including composited
results are contained in LASERGS while sample duplicates are contained in LASERGSD.
SEDDESC is similar in style to a table bearing the same name in subdirectory
PHASE!\SEDIMENT in that it contains information on redox, sediment density and other
descriptive field information.
FLOW
The PHASE2\FLOW subdirectory contains one table, FLOW93, which includes
calculated 1993 flow data for Stillwater and Waterford. The FLOW93 data dictionary is given
in Table 3-94.
3.3.7 NOAA
Figure 3-10 illustrates how the database tables in the NOAA directory are linked. Table
3-95 and the table below list the database tables contained in the NOAA directory. Tables 3-96
through 3-102 comprise the data dictionaries for the above-mentioned tables. Glossary
definitions can be found in the Phase 2 data glossaries. Groups for NOAA samples are the same
as those for the Phase 2 ecological program and can be found in Pft4S£21£C01GROUPS.
3-15
TAMS/Gradient
-------
Tables in NOAA Directory
(including Tables in NOAA\QA_QC subdirectory)
| Table Name
Description |
STATIONS
Ecological survey stations |
COORDS
Coordinates for stations
FISH
Sample composition information - fish
PCBFISH
PCB congeners/homologue sum/Aroclor concentrations - fish
PCBFISHD
PCB congeners - fish dup pairs/dilution analyses 1
NONPCBB
Non-PCB data - biota
SPECIES
Key to species codes |
The STATIONS table contains sample information such as TAMS ID, TAMS Type and
Species, as well as station number and sample location by river mile. COORDS is linked to
STATIONS through the STATION field and contains sampling locations by northing and
easting pairs. The PCB data tables, PCBFISH and PCBFISHD (containing laboratory duplicate
analyses for those samples requiring dilution), and NONPCBB, the non-PCB results table for
fish (biota) samples are linked to the STATIONS table by TAMS ID, TAMS Type and Species.
The tables FISH and SPECIES are similarly linked and contain field data and species
information, respectively.
3.4 Database Application Examples
This section describes three example queries showing database manipulations of the draft
Phase 2 data. While the examples are most relevant to the Phase 2 data tables, the same general
concept may be applied to other subdirectories and data tables. Field definitions for all data
tables are provided in the data dictionaries located in the Table Section of this report. The
following discussion does not assume a specific database management software package, but
rather relates general procedures for conducting database queries. The reader may need to refer
to software manuals for directions on performing queries for the specific database management
software package being used.
1. Extract Total PCB values and Total Carbon/Total Nitrogen Ratios from High-Resolution
Sediment Coring Data for Correlation Analysis.
This example demonstrates how to extract pairs of Total PCBs and Total Carbon/Total
Nitrogen ratio from the high-resolution sediment core samples for the purpose of calculating
correlation coefficients or performing other data analysis. The box below summarizes the steps
and Figure 3-11 indicates the table links needed to accomplish the database query.
3-16
TAMS/Gradient
-------
1. Move to the appropriate directory (PHASE2\HRCORES).
2. Select from NONPCBS all samples whose carbon to nitrogen ratio (C/N) is greater
than 0.
3. f inlr through the TAMS ID and TAMS Type fields and select all the Total PCBs
records from PCBS. (In this case, VaJue2 has been selected to reflect the
application of USEPA guidance regarding treatment of non-detected congener
results.)
4. Save merged results to a table and export to a statistics program.
Example results are shown below (partial listing):
TANS Sanple ID TAMS Sa«pType C/N - aolar Total PCBs - lig/Kg OW*
HR-001-0002 P
13.60
534.35
HR-001-0204 P
12.60
950.00
HR-001-0406 P
12.50
902.37
HR-001-0608 P
13.30
1037.47
HR-001-0812 P
14.00
974.78
HR-001-1216 P
14.30
1191.13
HR-001-1620 P
15.80
1441.25
HR-001-2024 P
16.00
191.76
HR-001-2428 P
14.90
62.36
HR-OOI-Z832 P
14.40
90.07
HR-001-3236 P
13.70
279.38
HR-001-3640 P
14.00
89.11
HR-001-4044 P
12.60
49.81
* The actual values may be different from those shown here.
The merged results can now be saved to a computer file for input to a statistics program
for determining correlation coefficients.
2. Extract Homologue Sums and Core Depth Intervals for High-Resolution Sediment Core
Number 19 for Graphing a Depth Profile.
This example query extracts homologue sums for sediment samples taken from core
number 19 and pairs the results with core depth intervals for the purpose of generating a
sediment profile. Figure 3-12 shows the table links.
3-17
T AMSI Gradient
-------
1. Move to the appropriate directory (PHASE2\HRCORES).
2. Select from STATIONS all samples from station "HR-019" and link through the
TAMS ID and TAMS Type fields to PCBS.
3. Input the criteria so as to exclude all congener records (those starting with "BZ") and
include homologue sums only. (As above, Value2 has been selected to reflect the
application of USEPA guidance regarding treatment of non-detected congener
results.)
4. Save merged results to a table and display.
Results displayed in a summary format are as follows:
Upper Lower
Depth Depth Mono* Di* Tri* Tetra* Penta* Hex** Hepta* Octa* Nona* Deca*
(cm)
(ca)
0
2
2837.0
6652.9
8146.4
5284.7
2032.7
378.6
128.4
32.2
7.3
0.0
2
4
4152.0
10410.4
10544.0
5070.9
1788.3
400.4
148.1
34.3
6.3
0.0
4
6
7731.0
16086.6
14792.0
6499.0
2145.7
434.9
160.5
0.0
0.0
0.0
6
8
12160.0
27618.2
20753.5
8595.5
2680.0
632.6
222.7
38.3
8.5
0.0
8
12
43480.0
95862.0
48445.0
15893.0
3765.8
675.0
196.9
0.0
0.0
0.0
8
16
115830.0
232219.0
92503.0
23288.7
7349.2
1343.0
286.0
0.0
0.0
0.0
12
16
174150.0
238297.0
99322.7
29249.3
7986.8
823.0
0.0
0.0
0.0
0.0
16
20
616800.0
845330.0
l
00
75873.2
27533.4
4947.0
1589.0
0.0
0.0
0.0
20
24
777750.0
1045244.0
263233.6
82505.9
26362.6
3441.0
1101.0
0.0
0.0
0.0
24
28
185810.0
196751.0
61967.6
24304.9
7443.0
1781.0
165.0
0.0
0.0
0.0
28
32
161340.0
261007.0
75486.4
23170.9
7101.2
3562.8
1423.6
557.9
222.0
0.0
32
36
38080.0
53766.0
26134.6
8872.6
3607.0
1188.0
0.0
0.0
0.0
0.0
36
40
2801.3
5483.9
1589.9
633.8
501.8
126.6
15.0
0.0
0.0
0.0
40
44
7.9
12.6
39.5
18.4
6.4
1.9
.4
0.0
0.0
0.0
44
48
9.5
9.0
31.2
24.0
11.5
1.8
.7
0.0
0.0
0.0
48
52
5.4
7.2
14.6
9.3
4.8
.9
.7
0.0
0.0
0.0
52
56
8.0
7.4
17.9
13.0
7.4
1.5
1.0
0.0
0.0
0.0
56
61
2.1
3.9
15.1
7.5
4.2
.7
.4
0.0
0.0
0.0
* The
actual values
may be different from those shown here.
3. Extract Five PCB Congeners from Water Samples Collected during Water Column
Transect 2 and Link Them to Station River Mile.
Because of the quantity of information and sheer number of congeners, it may be more
suitable to investigate a few at a time. Subsets of congeners are readily extracted from the
database for purposes of data analyses. This example extracts five congeners from a single
transect and associates the results with river mile. Refer to Figure 3-13.
3-18
T AM S / Gradient
-------
1. Move to the appropriate directory {PHASE21 WATER).
2. Select from STATIONS all samples from transect 002 and link through the TAMS
ID and TAMS Type fields to PCBW.
3. Indicate which congeners are to be included in the extracted subset: BZ#1, BZ#12,
BZ#27, BZ141, or BZ184. (As above, Value2 has been selected to reflect the
application of USEPA guidance regarding treatment of non-detected congener
results.)
4. Save merged results to a table and display.
Example results are given below:
Station
River Hile
BZ#1*
BZX12*
BZ#27*
BZ#41*
Bzm*
0001
201
0.00
0.00
0.00
0.00
.01
0002
197
0.00
0.00
0.00
0.00
0.00
0003
196
.17
.12
.10
.02
.02
0004
194
.24
.07
.15
.04
.02
0005
189
11.90
.03
1.32
.08
.07
0006
181
3.73
.02
.57
.10
.10
0007
168
3.51
.02
.55
.10
.07
0008
157
2.91
.02
.61
.08
.07
* The actual values may be different from those shown here.
3-19
TAMS! Gradient
-------
PAGE INTENTIONALLY LEFT BLANK
3-20 TAMS/Gradient
-------
4. REFERENCES
Armstrong, R. W. and R. J. Sloan. 1981. PCB Patterns in Hudson River Fish. I.
Resident/Freshwater Species. NYSDEC, Albany, NY.
Bopp, R.F. 1979. The Geochemistry of Polychlorinated Biphenyls in the Hudson River.
Columbia University, Ph.D. thesis.
Bopp, R.F., H.J. Simpson, C.R. Olsen, R.M. Trier and N. Kostyk, 1982. Chlorinated
Hydrocarbons and Radionuclide Chronologies in Sediments of the Hudson River and Estuary,
New York. Environmental Sci. Technol. 16(10):666 - 676.
Bopp, R.F. 1983. Revised Parameters for Modeling the Transport of PCB Components Across
an Air Water Interface. Journal of Geophysical Research, 88(4).
Bopp, R. F., H. J. Simpson and B. L. Deck. 1985. Release of Polychlorinated Biphenyls from
Contaminated Hudson River Sediments. Final Report to NYSDEC, Albany, NY; Contract No.
NYS C00708.
Bopp, R.F. and H.J. Simpson. 1988. Sources and Trends of Persistent Contaminants in New
York Harbor Complex. Final Report to Hudson River Foundation.
Bopp, R.F. and H.J. Simpson. 1989. Contamination of the Hudson River. The Sediment Record
in Contaminated Marine Sediments - Assessment and Remediation, Committee on
Contaminated Sediments, National Research Council, National Academy Press.
Brown, M.P., M.B. Werner, C.R. Carusone, and M. Klein. 1988. Distribution of PCBs in
the Thompson Island Pool of the Hudson River: Final Report of the Hudson River PCB
Reclamation Demonstration Project Sediment Survey. Division of Water, New York State
Department of Environmental Conservation, Albany, NY.
Bush, B. and F. C. Lo. 1973. Thin-layer chromatography for quantitative polychlorinated
biphenyl analysis. J. Chromatogr., 77:377-388.
Claussen, J.H., General Electric Company. 1991. Letter to Douglas J. Tomchuk (USEPA
Region II), dated March 8, 1991, regarding Hudson River PCBs Site, containing transmittal of
GE 1990 sediment samples from selected locations.
Haggard, J.G., General Electric Company. 1994. Letter to Douglas J. Tomchuk (USEPA
Region II), dated October 10, 1994, regarding Hudson River Remnant Deposits monthly
progress report for September 1994.
4-1
TAMS/Gradient
-------
Harza Engineering. 1990. Ft. Edward Dam PCB Remnant Deposit Containment Environmental
Monitoring Program Baseline Studies, Report of 1989 Results, August-December 1989. Report
to General Electric Company, Fairfield, CT, February 1990.
Limburg, K.E. 1984. PCBs in the Hudson. In the Hudson Review Ecosystem. Springer-
Verlag, NY, pp. 83-130.
Metcalf & Eddy. 1990. Final Report, Waterford Drinking Water Supply Evaluation. (Hudson
River PCB Remnant Site Project - Task 3). Report prepared for NYSDEC, Albany, NY.
Novak, M.A., A.A. Reilly, and S.J. Jackling. 1988. Long-term monitoring of polychlorinated
biphenyls in the Hudson River (New York) using caddisfly larvae and other macroinvertebrates.
Arch. Environ. Contam. Toxicol. 17:699-711.
Novak, M.A., A.A. Reilly, B. Bush, and L. Shane. 1990. In-situ determination of PCB
congener-specific first order absorption/desorption rate using Chironomus teruans larvae (Insecta:
Diptera: Chironomidea). Water Research 24(3): 321-327.
NUS Corporation. 1984. Feasibility Study: Hudson River PCBs Site, New York. Volume I.
Pittsburgh, PA.
NYS Thruway Authority, Office of Canals, 1993, Champlain Canal (Hudson River) Staff Gauge
Readings between Lock 1 and Lock 7, Transmittals to TAMS Consultants from C. Head.
Various dates.
O'Brien and Gere Engineers, Inc. 1993. Data Summary Reports, prepared for General Electric.
O'Brien and Gere Engineers, Inc. 1994. Fort Edward Dam PCB Remnant Containment 1993
Post Construction Monitoring Program, prepared for General Electric.
Rhea. J.R., O'Brien and Gere. 1994. Letter to Edward Garvey (TAMS Consultants, Inc.),
dated March 15, 1994, regarding General Electric Co. Hudson River Project and transmittal of
GE database.
Rhea, J.R., O'Brien and Gere. 1994a. Letter of transmittal from O'Brien and Gere to J.
Haggard of GE, dated December 1, 1994, regarding updated General Electric Hudson River
Database.
Rogers, Bob. 1991. Personal communication to Jonathan Butcher from Bob Rogers, USGS,
Albany, NY.
Schroeder, R. A. and C. R. Barnes. 1983a. Trends in Polychlorinated Biphenyl Concentrations
in Hudson River Water Five Years after Elimination of Point Sources. USGS Water-Resources
Investigations Report 83-4206. USGS, Albany, NY.
4-2
"TAMS! Gradient
-------
Schroeder, R. A. and C. R. Barnes. 1983b. Polychlorinated Biphenyl Concentrations in
Hudson River Water and Treated Drinking Water at Waterford, New York. USGS Water-
Resources Investigations Report 83-4188. USGS, Albany, NY.
Simpson, K.W., M.A. Novak, and A.A. Reilly. 1986. Final Report, Biomonitoring ofPCBs
in the Hudson River. NYSDOH.
Sloan, R. 1994. Letter to D. Thomchuk - USEPA, A. DiBernardo - TAMS, and J. Haggard -
GE, dated July 5, 1994, concerning transmittal of 1992 and 1993 NYSDEC Hudson River
striped bass PCB data.
Sloan, R. J. and E.G. Horn. 1986. Contaminants in Hudson River Striped Bass: 1978-1985.
Technical Report 86-2 (BEP), NYSDEC, Division of Fish and Wildlife, Albany, NY.
Sloan, R.J., B. Young, V. Vecchio, K. McKown, and E. O'Connell. 1988. PCB
Concentrations in the Striped Bass from the Marine District of New York State. Technical
Report 88-1 (BEP), Division of Fish and Wildlife, NYSDEC.
Spagnoli, J.J. and L.C. Skinner. 1977. PCBs in Fish from Selected Waters of New York State.
Pesticides Monitoring Journal, ll(2):69-87.
TAMS Consultants, Inc. and Gradient Corp. 1992. Phase 2A Sampling and Analysis
Plan/Quality Assurance Project Plan Hudson River PCB Reassessment RI/FS.
Tofflemire, T.J. and S.O. Quinn. 1979. PCBs in the Upper Hudson River Mapping and
Sediment Relationships. NYSDEC, Technical Paper No. 56, Albany, NY. 140 pp.
Turk, J.T. and D. E. Troutman. 1981. Polychlorinated Biphenyl Transport in the Hudson River,
New York. USGS Water-Resources Investigations Report 81-9. USGS, Albany, NY.
USEPA and NYSDEC. 1987. Draft Joint Supplement to the Final Environmental Impact
Statement on the Hudson River PCB Reclamation Demonstration Project and Appendices.
USEPA. 1988. Laboratory Data Validation Functional Guidelines for Evaluating Inorganics
Analyses.
USEPA. 1989. Statistical Analysis of Ground-water Monitoring Data at RCRA Facilities -
Interim Final Guidance. EPA/530-SW-89-026. February.
USEPA. 1992. Standard Operating Procedure (SOP) for the Evaluation of Metals Data for the
Contract Laboratory Program (CLP) Inorganics Data Review for Region II (SOP No. HW-2,
Rev. XI).
4-3
T AMS/Gradient
-------
Wagner, L. A. 1980. Drainage Areas of New York Streams by River Basin: A Stream Gazetteer.
USGS Water Resources Investigation, Open File.
Warren, S.D., R.F. Bopp and H.J. Simpson. 1987. Volatilization ofPCBs from Contaminated
Sediments and Water. Final Report to NYSDEC, Albany, NY. Contract NYS COO1263.
WATSTORE, 1995. Retrieval from WATSTORE, USGS database, August 1995, by R. Allen
of USGS-Water Division, Albany, NY.
Webb, R.G. and A.C. McCall. 1973. Quantitative PCB standards for electron capture gas
chromatography. J. Chromatographic Sci., 11: 366-73.
Weston Environmental Consultants. 1978. Migration ofPCBs from Landfills and Dredge Spoil
Sites in the Hudson River Valley, New York — Final Report. Prepared for New York State
Department of Environmental Conservation, Albany, NY.
4-4
T AM Si Gradient
-------
-------
Table 2-1
Studies Relating to PCB Contamination in the Hudson River*
Page 1 of 2
Type of Assessment
Year(s)
Location
Investigators
Sediment Surveys
• 40-Mile Region of the Hudson River
(> 1,000 samples)
1976 - 1978
Fort Edward to
Albany; Some
Lower Hudson
NYSDEC
• Approx. 9-Mile Reach
1983
Thompson Is.
Pool/Other
USEPA
• Approx. 5-Mile Reach (>2,000 samples)
1984
Thompson Is.
Pool
NYSDIC
• Selected Upper & Lower Hudson Areas
(Dated Core Samples)
1974 -1986
Upper and Lower
Hudson
Lamont-Doherty
• Selected Upper Hudson Areas
(Confirmatory Sediment Samples)
1992
Upper Hudson/
Rogers Is. to
Lock 5
USEPA/TAMS
• Selected Upper and Lower Hudson Areas
(28 High-Resolution Sediment Coring
Sites)
1992
Upper and
Lower Hudson
USEPA/TAMS
• Selected Upper and Lower Hudson Areas
(20 Ecological Survey Sediment Samples)
1993
Upper and
Lower Hudson
USEPA/TAMS
• Selected Upper Hudson Areas (Low-
Resolution Sediment Core Samples)
1994
Upper Hudson/
Rogers Island to
Lock 2
USEPA/TAMS
River Flow & Water Quality
• River Flow (Discharge)
1908 - Present
Upper Hudson
Region to
Hadley
USGS
• Water Quality/Suspended Sediment/PCBs
» 1975 -
Present
Hadley to Green
Island
USGS
• Water Levels
1916 - Present
Upper Hudson/
Champlain Canal
NYSDOT
• Dissolved and Particulate Phase PCBs
1983
Upper Hudson
Lamont -
Doherty/NYSDEC
• Dissolved and Particulate Phase PCBs
1993
Upper Hudson
USEPA/TAMS
• Total Suspended Solids
1993 - 1994
Upper Hudson
USEPA/TAMS
Fish/Biota
• Fish Samples Prior to GE Hearings
1970 - 1975
Upper and Lower
Hudson
NYSDEC, USEPA,
NYSDOH
T AMS/Gradient
-------
Table 2-1
Studies Relating to PCB Contamination in the Hudson River"
Page 2 of 2
Type of Assessment
Year(s)
Location
Investigators
Fish/Biota (cont'd)
* Fish Collection/Analysis Program
1975 - Present
Upper and Lower
Hudson
NYSDEC
• Archived Fish Analysis
1978 - 1982
Upper and Lower
Hudson
GE
• Macroinvertebrate
1973 - 1985
Upper and Lower
Hudson
NYSDOH
• Fish and Macroinvertebrate
Collection/Analysis Program
1993
Upper and Lower
Hudson
USEPA/TAMS
Air
• Air Monitoring
Late 1970s -
Early 1980s
Fort Edward and
Dump Sites
NYSDEC/DOH and
Boyce Thompson
Inst.
* Air Monitoring
1986-1987
Fort Edward
Area
NYSDEC
Plant/Crop Uptake
• Tree species/Some Crop and Forage
Plants
Early 1980s
Fort Edward
Area, Dump
Sites, Dam
Tailwater
NYSDEC/Boyce
Thompson Inst,
• Perennial and Crop Plants
1984 - 1985
Hudson
River/Albany
Area
NYSDOH
Groundwater
1977
Dredge Spoils
NYSDEC/Weston
Baseline Remnant Deposit Containment Studies and Current GE Investigations
• Water Column
1989 - Present
Upper Hudson
Locations
GE
• Sediment
1989 - 1994
Upper Hudson
Locations
GE
• Air Monitoring
1989 to Present
Remnant
Deposits Area
and Fort Edward
GE
• Multiplate/Biota
1989
Near Remnant
Deposits
GE
Notes:
'Adapted from Limburg et al. (1986).
TAMS/Gradient
-------
Table 2-2
Data Sets in the Reassessment Database Organized by Matrix
Page 1 of 2
Type of Assessment
Sediment Surveys
Year(s)
Location
Investigators
{SUBDIRECTORY)
• Over 40-Mile Reach (> 1,000
samples)
1976 - 1978
Approx. 5-Mile Reach (>2,000 1984
samples)
Selected Sites (3 Cores) 1977 - 1986
Selected Upper & Lower Hudson 1989 - 1993
Sites
Selected Upper Hudson Areas 1992
(Confirmatory Sediment Samples)
Selected Upper & Lower Hudson 1992
Areas (28 High-Resolution
Sediment Core Sites)
Selected Upper & Lower Hudson 1993
Areas (20 Ecological Survey
Sediment Sites)
Upper Hudson Areas (Low- 1994
Resolution Sediment Core
Samples)
River Flow & Water Quality
River Flow (Discharge) 1908 - 1993
River Flow (Discharge: 1993
Calculated)
Champlain Canal Water Levels 1977 - 1993
PCB/Water/Sediment Partitioning 1986
Water Quality/Suspended * 1975 -
Sediment/PCBs Present
Dissolved & Particulate Phase 1993
PCBs
Total Suspended Solids 1993 - 1994
Water Quality 1989 - 1994
Fort Edward to
Albany; Some Lower
Hudson
Thompson Is. Pool
Upper and Lower
Hudson
Upper Hudson
Locations
Upper Hudson/Bakers
Falls to Lock 5
Upper & Lower
Hudson
Upper & Lower
Hudson
Ft. Edward to Lock 2
Upper Hudson
Region to Hadley
Ft. Edward to
Waterford
Upper Hudson
NA
Hadley to Green
Island
Upper Hudson
Waterford Only
(1993); Upper
Hudson (April 1994)
Upper Hudson
Locations
NYSDEC
(HlSTORIC\SED)
NYSDEC
CHISTORIC\SED)
Lamont-Doherty (LDEO)
GE (GE and
HISTORlC\SED)
USEPA/TAMS
(PHASE2\SED1MENT)
USEPA/TAMS
(PHASE2\HRCORES)
USEPA/TAMS
(PHASE21ECO)
USEPA/TAMS
(PHASE2 \SED1MENT)
USGS (USGS\FLOW)
USEPA/TAMS
(PHASE2 \FLOW)
NYSDOT (NYSDOT)
Lamont-Doherty (LDEO)
USGS (USGS\WQDATA)
USEPA/TAMS
(PHASE2 \ WA TER)
USEPA/TAMS
(PHASE2\WATER)
GE (GE)
TAMS/Gradient
-------
Table 2-2
Data Sets in the Reassessment Database Organized by Matrix
Page 2 of 2
Type of Assessment
Year(s)
Location
Investigators
(SUBDIRECTORY)
Fish/Biota
• Fish Collection/Analysis Program
1976 - 1993
Upper and Lower
Hudson
NYSDEC
CHISTORICWISH)
• Macroinvertebrate
1976 - 1985
Upper and Lower
Hudson
NYSDOH
(HISTORICXMACROINV)
• Archived Fish Analysis
1978 - 1982
Upper Hudson
GE (GE)
• Fish & Macroinvertebrate
Collection/Analysis Program
1993
Upper and Lower
Hudson
TAMS/USEPA
(PHASE2SECO)
• Multipiate/Biota
1989
Near Remnant
Deposits
GE (GE)
• Supplementary Fish Analysis (to
the Ecological Program)
1993
Upper and Lower
Hudson
NOAA (NOAA)
T AMS/ Gradient
-------
Table 2-3
Data Sets in the Reassessment Database Organized by Directory
Page 1 of 3
Data Sets in the HISTORIC Directory of the Interim Database Release
1>pe of Assessment
Year(s)
Location
Investigators
(SUBDIRECTORY)
Sediment Surveys
• 40-Mile Region of the Hudson
River ( > 1,000 samples)
1976 - 1978
Fort Edward to
Albany, Some Lower
Hudson
NYSDEC
(HISTORIC\SED)
• Approx. 5-Mile Reach (>2,000
samples)
1984
Thompson Is, Pool
NYSDEC
(HISTORIC \ SED)
* Sediment - Selected Hudson
River Sites
1989 - 1991
Upper Hudson
Locations
GE (HISTORIC\SED)m
Fish/Biota
• Fish Collection/Analysis
Program
1973 - 1993
Upper and Lower
Hudson
NYSDEC
(HfSTORIC\FISH)
* Macroinvertebrate
1973 - 1985
Upper and Lower
Hudson
NYSDOH
(HISTORIC\MACROIN
V)
fl| GE data can be found in the GE89 as well as the other files in this subdirectory.
Data Sets in the GE Directory
Type of Assessment
Vear(s)
Location
investigators
(SUBDIRECTORY)
Baseline Remnant Deposit Containment Studies and Current GE Investigations
* Suspended Solids/PCBs
1989 - 1994
Upper Hudson
Locations
GE (GE)
• Sediment - Selected Hudson
River Sites
1991 - 1993
Upper Hudson
Locations
GE (GE)
• Multipiate/Biota
1989 -
1992?
Near Remnant
Deposits
GE (GE)
• Archived Fish Samples - Selected
Hudson River Sites
1978-1982
Upper and Lower
Hudson
GE (GE)
TAMS/Gradient
-------
Table 2-3
Data Sets in the Reassessment Database Organized by Directory
Page 2 of 3
Data Sets in the USGS Directory
| Type of Assessment
Year(s)
Location
Investigators
(SUBDIRECTORY)
River Flow <4 Water Quality
• River Flow (Discharge)
1908 - 1993
Upper Hudson Region
to Hadley
USGS (USGS\FLOW)
• Water Quality/Suspended
1 Sedimeot/PCBs
®1975 - 1994
Hadley to Green Island
USGS
(USGS\WQDATA)
Data Sets in the LDEO Directory
Type of Assessment
Year(s)
Location
Investigators
(SUBDIRECTORY)
Sediment Surveys
• Selected Hudson Sites
(3 Cores)
1977 - 1986
Upper and Lower
Hudson
Lamont-Doherty (LDEO)
River Flow <& Water Quality
• PCB Sediment/Water Partitioning
1986
NA
Lamont-Doherty (LDEO)
Data Sets in the NOAA Directory
Type of Assessment
Year(s)
Location
Investigators
(SUBDIRECTORY)
Fish/Biota
• Supplementary Fish Analysis (to
the Phase 2 Ecological Program)
1993
Upper and Lower
Hudson
NOAA (NOAA)
Data Sets in the NYSDOT Directory
Type of Assessment
Year(s)
Location
Investigators
(SUBDIRECTORY)
River Flow & Water Quality
• Champlain Canal Water Levels
1975 - 1993
Upper Hudson
NYSDOT (NYSDOT)
Table 2-3
Data Sets in the Reassessment Database Organized by Directory
TAMS/Gradient
-------
Table 2-3
Data Sets in the Reassessment Database Organized by Directory
Page 3 of 3
Data Sets in the PHASE 2 Directory
Type of Assessment
Year{s)
Location
Investigators
(SUBDIRECTORY)
Sediment Surveys
• Selected Upper Hudson Areas
(Confirmatory Samples)
1992
Upper
Hudson/Bakers Falls
to Lock 5
USEPA/TAMS
(PHASE2\SEDIMENT)
• Selected Upper Hudson Areas
(Low Resolution Coring)
1994
Upper Hudson/Ft.
Edward to Lock 2
USEPA/TAMS
(PHASE2 \ SEDIMENT)
* Selected Upper and Lower
Hudson Sites (28 High
Resolution Sediment Core Sites)
1992
Upper and Lower
Hudson
USEPA/TAMS
(PHASE2\SEDIMENT)
• Selected Ecological Program
Sampling Areas
1993
Upper and Lower
Hudson
USEPA/TAMS
(PHASE2\ECO)
River Flow and Water Quality
• Total Suspended Solids and
Suspended Organic Matter
1993 - April
1994
Waterford (1993)
Upper Hudson (April
1994)
USEPA/TAMS
(PHASE2\WATER)
• Dissolved and Particulate Phase
PCBs
1993
Upper Hudson
USEPA/TAMS
(PHASE2\WATER)
• River Flow (Discharge:
Calculated)
1993
Upper Hudson
USEPA/TAMS
(PHASE2\FLOW)
Fish/Biota
• Fish and Macroinvertebrates
Collection/Analysis Program
1993
Upper and Lower
Hudson
USEPA/TAMS
(PHASE2\ECO)
TAM&/Gradient
-------
Table 2-4
Sediment Sample Inventory From the
1984-1985 NYSDEC Hudson River Survey
Sediment Samples
Hudson River
Reassessment Database
Reported by
Brown et. al, 1988
Grab Samples
Sites
Cores Sites
Grab Samples
Sites
Core Sites
Original Sites
675'"
408
607
407
Co-Located Samples
23
1
Field Relocates
6
Total Sites
704
409121
607
407
Field Duplicates'31
29
25
Total Samples
733
1315HI
607
131214'
Total Sample Records
2048
1919
PCB Analyses
No. of Analyses
No. of Analyses
Grab Samples
Core Samples
All Samples
GC/MS Result only
445
594
1039
628
GC/ECD Result only
14
415
429
457
GC/ECD and GC/MS
Result
274
223
497
497
Total Reported
Analyses
733
1232
1965,S|
1582
|2| Two covca were not nn for PCB uilyib.
|3| Field dqpUctte* ttpreaeai duplicate tan^kj, not dedicate umplinf tile* and therefore are not included to the aite Herniary.
|4| On miaic, three tannic* were from eacfc core.
|S] 13 of the Maples in the Reiitetiam databaac hive no reported PCB result.
-------
Table 2-5
USGS Flow Monitoring Stations
Station
Station No.
River
Mile
Period of
Record in the
Database
Drainage Area
at Station
(mi2)
Comments
Hudson River
Hudson River at
Hadley
01318500
-230
1976-1993
1,664
Hudson River Near
Corinth Below the
Sacandaga River
-225
1921-1993
-2,719
Created by
summing flows
measured at
Hudson River at
Hadley and at
Sacandaga River
near Stewarts
Bridge
Hudson River at
Fort Edward
01327750
194.5
1976-1993
2,817
Hudson River at
Schuylerville
01329650
181
1977-1979
3,440
Hudson River at
Stillwater
01331095
168
1977-1993
3,773
[1]
Hudson River at
Waterford
01335754
160
1976-1993
4,611
[1]
Hudson River at
Green Island
01358000
154
1946-1993
8,090
[2]
Tributaries
Sacandaga River at
Stewarts Bridge
01325000
NA
1907-1993
1,055
Batten Kill at
Battenville
01329500
NA
1922-1968
394
Hoosic River near
Eagle Bridge
01334500
NA
1910-1993
510
Mohawk River
01357500
NA
1917-1993
3,456
[1] Data for these stations during 1993 were qualified as estimated by the USGS. For the Phase2 investigation,
flows at these stations were estimated from Ft. Edward flows and NYSDOT Champlain Canal Water Levels.
See the Phase2/Flow subdirectory for 1993 data for these stations.
[2] Data for this station during 1993 were qualified as estimated by the USGS.
TAltTQ/S3»VT//r*jmi
-------
Table 2-6
USGS Water Quality Monitoring Stations
Station
Station No.
River
Mile
Period of
Record in
the
Database
General
Water
Quality
Period
PCB
Period of
Record
Comments
Corinth
01325420
—218
1973-1990
1973-1990
-
No data 1975-
1985
Glens Falls
01327600
1975-1983
1974-1979
1977-
1983
Intended to
provide
background
levels of PCBs
Rogers Island at
Fort Edward
01327755
194.2
1975-1993
1975-1994
1976-
1994
Samples are
composites of
the east and
west channels
Near Fort Miller
01328730
187
1986-1990
1986-1990
1986-
1989
Schuylerville
01329650
181
1976-1990
1976-1990
1977-
1989
Stillwater
01331095
168
1974-1993
1974-1994
1976-
1994
Waterford
01335770
156.5
1969-1993
1974-1994
1975-
1994
Green Island
153.9
1975-1990
1975-1990
1978-
1985
Intended to
represent
combined
Upper Hudson
and Mohawk
contributions
to Lower
Hudson
TkMSlGradient
-------
Table 2-7
Laboratories Employed in Phase 2 Chemical Analyses
Laboratory"1
Procurement Mode121
Parameters
Aquatec Laboratories, Inc.
Div. Inchcape Testing Services
Colchester, Vermont
(Aquatec)
Direct
PCBs (congener-specific) - all media
TOC (sediments)
TKN (sediments)
Chlorophyll-a (water column)
% Lipids (biota)
Abundance and Diversity (biota)
Lamont-Doherty Earth Observatory
Palisades, New York
(LDEO, formerly LDGO)
Direct
Radionuclides (sediments)
TC/TN (sediments)
TIC (sediments)
Weight Loss on Ignition (sediments)
X-Ray Photography
Rensselaer Polytechnic Institute
Department of Earth and Environmental
Science
Troy, New York
(RPD
Direct
Dissolved Organic Carbon (water column)
Weight Loss on Ignition (water column)
Radionuclides (sediments - assisting LDEO)
Total Suspended Solids (water column)
ATEC Associates, Inc.
Indianapolis, Indiana
(ATEC)
SAS
Grain Size Distribution (sieve - ASTM
method)
GeoSea Consulting, Ltd.
British Columbia, Canada
(GeoSea)
SAS and Direct
Grain Size Distribution (laser particle
method)
Chemtech Consulting Group, Inc.
Englewood, New Jersey
(Chemtech)
SAS
Total Organic Nitrogen (sediments)
Total Organic Carbon (water column)
Total Suspended Solids (water column)
Chlorophyll-a (water column)
RAS
Metals (sediments)
Midwest Laboratories, Inc.
Omaha, Nebraska
(Midwest)
Direct
Grain Size Distribution (sieve - ASTM
method)
Cemeic Corporation
Narragansett, Rhode Island
(Ceimic)
Direct
Total Organic Carbon (water column
suspended matter)
Total Suspended Solids (water column)
Ohio State University
Columbus, Ohio
(OSU)
SAS
Grain Size Distribution (laser particle
method)
Saint John's University
Department of Biology
Jamaica, New York
(SJU)
Direct
Sorting (biota)
B&W Nuclear Environmental Services,
Inc. Nuclear Environmental
Laboratories
Lynchburg, Virginia and Leechburg,
Pennsylvania
(B&W)
Direct
Radionuclides (sediments)
[I] Laboratory abbreviation given in parentheses.
{21 RAS - Routine Analytical Services through the USEPA CLP,
SAS - Special Analytical Services through the USEPA CLP.
Direct - Directly procured by TAMS/Gradient outside the USEPA CLP.
-------
Table 2-8
Water-Column Transect, Flow-Averaged Sampling and Suspended Solids Monitoring Stations
Station
No.
Station
Tn»«
Location
River
MUW
Abbreviation
Alternate Referene*1>l
1
T
Glens Falls
199.5
GF
GF Public Works
2
T.F.S
Fenimore Bridge
197.6
FB
Baker Falls Bridge, Hudson Falls, Bakers Falls
3
T
Remnant Deposits
195.5
RMNTS
Remnant Deposit 2
4
T.F.S
Rt 197
194.6
RT 197
Rogers Island, Fort Edward, USGS WQ Su.
01327755
5
T.F.S
Thompson Island Dam
188.5
TID
Crockers Reef Dam
6
T,S
Schuyletville
181.3
SCHYLER
Rt. 29 Bridge (Below Batten Kill Confluence),
USGS WQ Su. 13229650
7
T,S
Stillwater
168.3
SW
Rt. 67 Bridge (Above Hoosic River
Confluence). USGS WQ Sta. 01331095
8
T.F.S
Waterford
156.5
WTFD
Rt. 4 Bridge at Waterford. USG WQ Sta.
01335770
9
T
Saratoga Springs
NA
SS
Oreoda Spring at Saratoga Park
10
T
Lock 7
193.7
LOCK 7
Canal above Lock 7
11
T,S
Batten Kill
NA
BK
Approximately 1.1 miles upstream from
Confluence (RM 182.1)
12
T,S
Hoosic River
NA
HOOS
Approximately 1.8 miles from Confluence
(RM 167.5)
13
T.S
Mohawk River
NA
MOH
Near USGS WQ Sta. 01357500 approximately
1.8 miles from confluence (RM 156.2)
14
T,S
Green Island Bridge
151.7
GIB
Troy, Green Island Dam, USGS WQ Sta.
01358000
15
T
Coxsackie
125
COS
16
T
Cementon
110
CEM
17
T
Highland
77
HIGH
19
T,S
Mechanicville
165.4
MECH
Mechanicville Public Dock
20
S
Thomson at Lock 5 Bridge
21
S
Coveville (shore)
22
S
Thompson Island Pool above
Snook Kill
23
s
Snook Kill
NA
24
S
Moses Kill
NA
23
s
Thompson Island Pool at
McDonald Dock
26
s
Lock 2
40
s
River Road near Coveville
[1] T - Transect Sampling Station
F ¦ Flow-Averaged Sampling Station
S - Suspended Solidi Monitoring Station
[2] Water-column transect and flow-averaged itation river mile value* are estimated to be accurate to within a quarter mile.
[3] Correspondence to USGS stations is approximate but should be more than sufficient for water-column data analysis. NYSDEC primary
collection site* for fish are River Miles 133 and 17S.
-------
Table 2-9
Water-Column Transect, Flow-Averaged Sampling and Suspended Solids Monitoring Dates
Sampling Event
Sampling Date
Transect 1
January 29 - February 6, 1993
Transect 2
February 19 - February 22, 1993
Transect 3
March 26 - March 31, 1993
Transect 4
April 12 - April 14, 1993
Transect 5
June 24 - June 30, 1993
Transect 6
August 19 - September 1, 1993
Transect 8
April 23, 1993
Flow-Average 1
April 23 - May 8, 1993
Al1"
April 23, 25, 27, 28, 1993
A2<"
May 1, 3, 5, 7, 1993
Flow-Average 2
May 12 - May 27, 1993
Flow-Average 3
June 6 - June 19, 1993
Flow-Ave rage 4
July 6 - July 20, 1993
Flow-Average 5
August 2 - August 17, 1993
Flow-Average 6
September 9 - September 23, 1993
Flow-Average 7
CI121
December 10, 1992 - January 21, 1993
C2'3'
February 5 - February 18, 1993
C3'-1
February 25 - March 25, 1993
C4'-'
April 2 - April 8, 1993
Suspended Solids
Monitoring, Study No. 1
April 5, 1993 - October 24, 1993
High Flow Suspended
Solids Monitoring,
Study No. 2
March 26, 1994 - April 27, 1994
[11 Two samples were taken at the Waterford Station, during this event. Each sample represents
an 8-day sampling period.
12] These samples represent weekly temporal composite samples collected at Waterford during the
time periods listed.
TAMS /Gradient
-------
Table 2-10
Ecological Sampling Stations
STATION NUMBER
RIVER MILE
SAMPLE TYPE
01
A 203.3
SEDIMENT, FISH
B 203.6
FISH
C 204.7
FISH
02
194.1
SEDIMENT, FISH
03
191.5
SEDIMENT, FISH
04
A 190.3
FISH
B 190.0
FISH
C 189.6
SEDIMENT, BENTHIC INVERTEBRATES, FISH
05
189.0
SEDIMENT, BENTHIC INVERTEBRATES
06
188.7
SEDIMENT, BENTHIC INVERTEBRATES
J7
188.5
SEDIMENT. BENTHIC INVERTEBRATES
08
A 169.5
SEDIMENT
B 169.2
FISH
09
159.0
SEDIMENT, FISH
10
143.5
SEDIMENT, FISH
11
A 137.2
SEDIMENT
B 136.7
FISH
12
A 122.7
FISH
B 122.4
SEDIMENT, BENTHIC INVERTEBRATES
13
113.8
SEDIMENT, FISH, BENTHIC INVERTEBRATES
14
100.0
SEDIMENT, FISH, BENTHIC INVERTEBRATES
15
A 89.4
FISH
B 88.9
SEDIMENT, BENTHIC INVERTEBRATES
16
58.7
SEDIMENT, FISH, BENTHIC INVERTEBRATES
17
47.3
SEDIMENT, FISH, BENTHIC INVERTEBRATES
18
25.8
SEDIMENT. FISH, BENTHIC INVERTEBRATES
20
196.9
SEDIMENT. FISH
-------
Table 3-1
Data Dictionary for Table HIST LUT in HISTORIC Directory
Field Name
Paradox
Field Name
FoxPro
Field Type {1]
Description
Fld_Param
P]
A15
Contains all field name and parameters in
HISTORIC Directory
Field Type
field_type
A3
[1]
Matri*
f—1
A30
Sample matrix
Units
12]
A10
Units of result
Description
descriplio
A10Q
Definition of given field name or parameter
Database File
databasef
A50
Database files that contain given field or
parameter
Memo
12)
M
Additional information for certain
fields/parameters
[1] A: character field wits number denoting *ize of field
D: (tele field
N: number field
M: memo Held
[2) Same as Paradox
TAMS/Grudient
-------
Table 3-2
Data Dictionary for Table PARAMKEY in HISTORIC Directory
Field Name
Paradox
Field Name
FoxPro
Field Type [1]
Description
Parameter code
p«rameter_0
A2
Psxaznecer code
Parameter
paismeter_l
A20
Name of parameter
£1] A; dmmetm fiiU widi tuwber
-------
Table 3-3
Tables in HISTORIC\SED Subdirectory
| Table
a^asssaB^aa=s^aass=s=sa=s3BBB
Description
SAMPLES
Sediment sampling information; NYSDEC/OBG (1976 - 1978); NYSDEC/NYSDOH (1984
- 1985); GE/Harza (1990)
STATIONS
NYSDEC or GE station number correspondence to GradNo sample identifier
GRADNUMS
Core section correspondence to GradNo sample identifier
SECTION
Section number, depths, and correspondence to GradNo for sediment cores
REACHES
River reach numbers
CONCSED
PCB Aroclor data - sediment samples
NONCHEM
Non-PCB data - sediment samples
SOXHDUP
Duplicate PCB Aroclor data using soxhlet extraction
NONDETS
Key to non-detection qualifier codes
REF
Key to references used in building the database
TEXTURES
Sediment description key
GE89
Preliminary 1989 GE sediment baseline studies: GE/Harza (1989)
MASSPEC
Results for GMS performed for sediments collected during 1984-1985 NYSDEC survey of
Upper Hudson
TAMS/Gradient
-------
Table 3-4
Data Dictionary for Tables SAMPLES in HISTORIC\SED Subdirectory
Field Name
Paradox
Field Name
FoxPro
Field Type [1]
Description
GradNo
[2]
A5
Unique identifying number
Dup
[2]
A2
Duplicate marker field
Sample Type
«ample_typ
A2
Sample Type (C = Core, G = Grab)
Month
[2]
A2
Sample month
Day
[2]
A2
Sample day
Year
[2]
A4
Sample year
River Mile
[2]
N
Hudson River mile measured from the Battery
Diitance ft
diitancex
N
Distance from shore in feet
Northing ft
northing x
N
NY State Plane northing coordinate
Easting ft
carting f
N
NY State Plane easting coordinate
Sampler
[2]
N
Sampling equipment
Water Depth ft
water_dept
N
Water depth in feet
Elevation ft
elevation*
N
Surface elevation in feet
[1] A: chancier field with number <1—txtt of field
D: dale field
N: niiinbiii field
M: umbo field
[2] Same m Pinion
T^MS! Gradient
-------
Table 3-5
Data Dictionary for Table STATIONS in HISTORIC\SED Subdirectory
Field Name
Paradox
Field Name
FoxPro
Field Type [1]
Description
GradNo
[2]
A5
Unique identifying number
StationNo
[2]
A4
Station identifier for reference to NYSDEC or
GE filet
[1] A: ' ' 1 with aumber lUnming tin af fold
D: *m r«U
N: mmhtr Mi
M: bom Ml
Sum m Itote
TAMS/Gradient
-------
Table 3-6
Data Dictionary for Table GRADNUMS in HISTORIC\SED Subdirectory
Field Name
Paradox
Field Name
FoxPro
Field Type [1]
Description
GradNo
[2]
A5
Unique identifying number
ScctionNo
[2]
N
Core lection number
Identi/icrNo
identifier
A10
Identifier for reference to NYSDEC or GE fllea
Agency
[2]
A10
Agency collecting the data
Ref
12]
N
Reference number identifying tource of data
[1] A: dmmctar fMd with Dumber
-------
Table 3-7
Data Dictionary for Table SECTION in HISTORIC\SED Subdirectory
Field Name
Paradox
Field Name
FoxPro
Field Type [1]
Description
Gi*dNo
[2]
A5
Unique identifying number
SectionNo
[2]
N
Core section number
Upper Depth inches
upper_dept
N
Top of core depth interval in inches
Lower Depth inches
lowerdept
N
Bottom of core depth interval in inches
[1] A: daiadar f»W with number itz* of field
D: fcwfaU
N: niTihir fi«M
M: bmboTmU
[2] Same h hwiw
TAMS/Gradient
-------
Table 3-8
Data Dictionary for Table REACHES in HISTORICISED Subdirectory
| Field Name
Parados
Field Name
FoxPro
[2]
Field Type [1]
Description
Reach
N
Reach number
Lower Rmile
lower_rmil
N
Downatream endpoint river mile
Upper Rmile
upper_rmil
N
Upstream end point river mile
[1] A: dnctor fiaU ¦»—lUwwilbng sin tf fiaU
D: 4a» (mU
N: wW fiaU
M; bmh fWU
T AMSl Gradient
-------
Table 3-9
Data Dictionary for Table CONCSED in HISTORIC\SED Subdirectory
Field Name
Paradox
Field Name
FoxPro
Field Type [1]
Description
GradNo
[2]
A5
Unique identifying number
Dups
[2]
A2
Duplicate marker field
SectionNo
121
N
Core section number
Parameter
[2]
A20
Parameter name (Aroclor)
Extraction Method
extraction
A10
Extraction method code: shaker or soxhlet
Value
[2]
N
Positive numerical result
Det Limit
det_limit
N
Sample quantitation limit reported for non-
detected result
Value and Limit Units
value_and
A3
Units of result or quantitation limit
Det
[2]
A3
Data qualifier (blank means detected; refer to
NONDETS)
II] A: chancier field with number denoting lize of field
D: date field
N: number field
M: memo field
[2] Same a* Paradox
TAMS/ Gradient
-------
Table 3-10
Data Dictionary for Table NONCHEM in HISTORIC\SED Subdirectory
8 Field Name
Paradox
Field Name
FoxPro
Field Type [1]
Description |
GrmdNo
[2]
A3
Unique identifying number
Dup
[2]
A2
Duplicate marker field
ScctionNo
m
N
Core aection number
Parameter
[2]
A20
Parameter name
Value
[2]
N
Numerical result
[1] A: daiacMr field with mimhif <>timliin loe of field
D:*tofiaU
N: - i rrL • •
M: amofM*
[2] Saa* M hnto
T&MS! Gradient
-------
Table 3-11
Data Dictionary for Table SOXHDUP in HISTORIC\SED Subdirectory
Field Name
Paradox
Field Name
FoxPro
Field Type [1]
Description
GradNo
[21
A5
Unique identifying number
SectionNo
[21
N
Core section number
Parameter
[21
A20
Parameter name (Aroclor)
Extraction Method
extraction
A10
Extraction method code: shaker or soxhlet
Value
valueand
N
Positive numerical result
Det Limit
det_limit
N
Sample quantitation limit reported for non-
detected result
Value and Limit Units
valueand
A3
Units of result or detection limit
Det
[2]
A3
Data qualifier (blank means detected; refer
to NONDETS)
(1] A: chancier field with number denoting size of field
D: dale field
N: number field
M: memo field
[2] Same at Paradox
TAMS /Gradient
-------
Table 3-12
Data Dictionary for Table NONDETS in HIST0R1C\SED Subdirectory
Field Name
Paradox
Field Name
FoxPro
Field Type [1]
Description
Det Category
det_catag
A3
Non-detect code
Maw Spec Screen Categ
maaa_specx
A6
Masa ipectro meter (GC/MS) screening category
Mean Concentration,
ppm
mean_conce
N
Mean concentration of the category in ppm
Median Concentration,
ppm
median_con
N
Median concentration of the category in ppm
Comment
[2]
M
Comments
[1] A: cbneKr fwid with number dmcnint %wt of field
D: fete field
N: number field
M: memo field
[2] Some m hndw
T I Gradient
-------
Table 3-13
Data Dictionary for Table REF in HISTORIC\SED Subdirectory
Field Name
Paradox
Field Name
FoxPro
Field Type [1]
Description
Ref
[2]
N
Reference number identifying data source
Description
deacriptio
A40
Descriptor of data lource
[1] A: ctencMr fmU with number liu of fieU
D: fmU
N: water Mi
M: mmo fisU
[2] Sam* M Plrtioi
TAMS/Gmdient
-------
Table 3-14
Data Dictionary for Table TEXTURES in HISTORJC\SED Subdirectory
Field Name
Paradox
Field Name
FoxPro
Field Type [1]
Description
TextureNo
[2]
N
Sediment texture code number
Texture
[2]
A7
Sediment texture code character*
Deacription
deacriptio
A30
Sediment texture deacription
[1] A: In 1,1 p fiM with number (imntrif toe of field
D: drtt ftaU
N: niimbw Mi
M: umbo field
[2] '¦¦¦ at PanUor
TAMS/Gradient
-------
Table 3-15
Data Dictionary for Table GE89 in HISTORIC\SED Subdirectory
Field Name
Paradox
Field Name
FoxPro
Field Type [1]
Description |
GradNo
121
A5
Unique identifying number |
IdentifierNo
identifier
A4
Identifier for reference to NYSDEC or GE files |
Agency
[2]
A10
Agency collecting the data |
Ref
[2]
N6.0
Reference number identifying source of data
Location
[2]
A10
Location defined as per GE documentation
Sample Date
sample dat
D
Sample date
Parameter
[2]
A2
Parameter key as defined in PARAMKEY and
HISTLUT
Det. Lim.-ppb
det limxx
N
Sample quantitation limit reported for non-
detected limit
Det.
detx
A3
ND=non-detect; blank=detect
Concentration-ppm
concent rat
N
Concentration in ppm
[1] A: character field with number denoting lize of field
D: dale field
N: number field
M: memo field
(2] Same a* Paradox
T AMS /Gradient
-------
Table 3-16
Data Dictionary for Table MASSPEC in HIST0R1C\SED Subdirectory
Field Name
Paradox
Field Name
FoxPro
Field Type [1]
Description
GradNo
[2]
A5
Unique identifying number
Dup
[2]
A2
Duplicate marker field
SectionNo
[21
N
Core section number
Mass Spec Screen Categ
massspccx
A6
Mass spectrometer (GCIMS) screening category
(1] A: character field with mi tuber denoting tut of Held
D: date field
N: number field
M: memo field
(2] Same at Paradox
TAMS (Gradient
-------
Table 3-17
Tables in HISTORIC\FISH Subdirectory
Table Name
Description
GRADNUMF
Master index to GradNo
SAMPLEF
Fish sampling information
CORRNUM
Correspondence between old and new GradNo
COMPOS
Sample information for composite samples
CONCFISH
PCB Aroclor and percent lipid data - ftsh samples
PREP
Key to tissue and preparation codes
SPECCODE
Key to species codes
REF
Key to references used in building the database
T AM SI Gradient
-------
Table 3-18
Data Dictionary for Table GRADNUMF in HIST0R1C\FISH Subdirectory
Field Name
Paradox
Field Name
FoxPro
Field Type [1]
Description
GradNo
[2]
A5
Unique identifying number
Labno
12]
All
Laboratory identifier for reference to the NYSDEC
files
Tagno
[2]
A9
Tag identifier for reference to the NYSDEC files
Ref
[2]
A10
Reference number identifying data source
Comment
[2]
M25
Memo field recording alterations to the database and
cross-reference on GradNo assignments
[l| A: chancier field with number denoting size of field
D: date field
N: number field
M: memo field
[2] Same as Paradox
TAMS/Gradient
-------
Table 3-19
Data Dictionary for Table SAMPLEF in HISTORIC\FISH Subdirectory
Field Name
Paradox
Field Name
FoxPro
Field Type [1]
Description
GradNo
[2]
A5
Unique identifying number
Location
[2]
A50
Narrative record of location
Rmile
[2]
N
Hudson River mile measured from the Battery
Yr
[2]
N
Sample year
Mo
[2]
N
Sample month
Dy
[2]
N
Sample day
Spp
[2]
A5
Species code (refer to SPECCODE)
Basin
[2]
A8
Numeric designation of watershed basin
MnLen
t2]
N
Fish length in mm (for composites, this is the
mean length)
MnWgt
[2]
N
Weight in grams (for composites, this is the
mean weight)
Sex
[2]
A1
Fish gender (contains F, M, U, X, and blank)
Age
[2]
A1
Fish age (contains 0-8, F, I, O, U, Y, and * and
not presently positively identified)
Prep
[2]
A3
Fish tissue and preparation codes (refer to PREP)
Noincomp
[2]
N
Number of fish in composites
UTMN
[2]
N
NY Transverse Mercator northing
UTME
12]
N
NY Transverse Mercator easting
Verified
[2]
A2
NSYDEC verification status (T, F, blank)
although meaning of code is not presently clear
[1) A: chancier field with number denoting size of field
D: date field
N: number field
M: memo field
[2] Same a* Paradox
TAMS/Gradient
-------
Table 3-20
Data Dictionary for Table CORRNUM in HISTORIC\FJSH Subdirectory
Field Name
Paradox
Field Name
FoxPro
m
Field Type [1]
Description
Oldno
AS
Old unique identifying number
1 Newno
P]
AS
New unique identifying number
[1] A: cfcuaeMr (Mi with nrnntir Jiwnlin liu of fiaU
D: Mi
N: fiaU
M:
[2J Samtm Himtn
TAMS! Gradient
-------
Table 3-21
Data Dictionary for Table COMPOS in HISTORIC\FISH Subdirectory
| Field Name
| Parados
Field Name
FoxPro
Field Type [1]
Description 1
GradNo
[2]
A5
Unique identifying number
Noincomp
[21
N
Number of individuals in composite
Mnlen
[2]
N
Mean length in composite
Minlen
[2]
N
Minimum length in composite
Maxlen
12]
N
Maximum length in composite
Sdlen
[2]
N
Standard deviation of length
Mnwgt
[2]
N
Mean weight of individuals in composite (g)
Minwgt
[2]
N
Minimum weight in composite
Maxwgt
[2]
N
Maximum weight in composite
Sdwgt
[2]
N
Standard deviation of weight
[1] A: cfaancaar
-------
Table 3-22
Data Dictionary for Table CONCFISH in HISTORIC\FISH Subdirectory
Field Name
Paradox
Field Name
FoxPro
Field Type [1]
Description
GnidNo
[2]
A5
Unique identifying number
Parameter
[2]
A2
Parameter code (refer to PARAM KEY)
Value
[2]
N
Positive numeric result
Det Limit
det_limit
N
Sample detection limit reported for a non-
detected result
Value and Limit Units
value_and
A3
Units of value or detection limit
Det or Qualifier
det_or_qu
A3
Data qualifier
(1) A: character field with number denoting size of field
D: date field
N: number field
M: memo Held
[2] Same at Paradox
T A MS/ClraHient
-------
Table 3-23
Data Dictionary for Table PREP in HISTORIC\FISH Subdirectory
| Field Name
Field Name
Field Type [1]
Description
| Paradox
FoxPro
1 Abbrcv
[2]
A3
Tiuue or preparation code
1 Tiuue Type
tisaue_typ
A30
Type of tissue in sample
(1] A: ihmlii Mi with aumbar (ize of fWld
D: t*f»U
N: aumfc ir fi*U
M: mbo ImU
[2] Sum a* Pifafatc
T AMS/Gradient
-------
Table 3-24
Data Dictionary for Table SPECCODE in HISTORIC\FISH Subdirectory
Field Name
Paradox
Field Name
FoxPro
[2]
Field Type [1]
Description
SPP
A5
Species code
Specie*
[2]
A30
Name of apeciea in (ample
[1] A: chuacMr field wi& number dmnrim lizo of fiald
D: date Mi
N: miabw fi«M
M: BMBofaU
[2] 1«n aa IWafci
T AMS/Gradient
-------
Table 3-25
Data Dictionary for Table REF in HISTORIC\FISH Subdirectory
Field Name
Paradox
Field Name
FoxPro
Field Type [1]
Description
Ref
m
N
Reference number identifying data source
Description
descriptio
A40
Descriptor of data source
(1} A: ekmmMt fUd with rnimtir imntim am of fiaU
D-.imfUi
Hi Hiialir fmii
M: ttaow fvM
[7] Saw m Hmiax
TP^MS! Gradient
-------
Table 3-26
Tables in HISTORJC\MACROINV Subdirectory
Table Name
Description
SAMPLE
Macroinveitebratc lampling information
SAMPREF
Key to umple type
NUMINDI
Number of individual* in sample*
CONC
PCB Aroclor results
OTHER
Additional species included in samples
SPECCODE
Species codes
DOHSITE
Multiple and caddisfly sampling information
TAMS/Gradient
-------
Table 3-27
Data Dictionary for Table SAMPLE in HISTORlC\MACROINV Subdirectory
Field Name
Paradox
Field Name
FoxPro
Field Type [1]
Description
GradNo
[2]
A5
Unique identifying number
Location
[2]
A8
Location descriptor code
Mo
[2]
A2
Sample month
Dy
[2]
A2
Sample day
Yr
[2]
N
Sample year
Rmile
[2]
N
River Mile measured from the Battery
Lab or EHC No
lab_or_ehc
A15
Laboratory identifier for reference to NYSDOH files
Tagno .
12]
A10
Tag identifier for reference to NYSDOH files
Specie*
[2]
N
Species code (refer to SPECCODE)
Sample type
umple_typ
A1
Sample type code (refer to SAMPREF)
Wet wt. (g)
wet wt gx
N
Sample wet weight in g
Diy wt- (g)
diy_wt_gx
N
Sample diy weight in g
Percent lipid
percent_li
N
Percent lipid content
PageNo
[2]
N
Reference page number
[1] A: cfaamctme fioM with Dumber aiz« of Held
D: feu TmU
N: miabw TmM
M: a»raU
[2] Sum a* Pan4ox
T AMS/Gradient
-------
Table 3-28
Data Dictionary for Table SAMPREF in HISTORIC\MACROINV Subdirectory
1 Field Name
Fkradoz
Field Name
FoxPro
Field Type [1]
Description
Sample type
samplejyp
A1 •
Sample type code
Note
m
A80
Explanation
[1] A: tett (Mi «id> mmkm tmrnkf $a» of Mi
Nt mmhv TmU
MbmmM
TAMS/Gradient
-------
Table 3-29
Data Dictionary for Table NUMINDI in HISTORIC\MACROINV Subdirectory
Field Name
Field Name
Field Type [1]
Description
Paradox
FoxPro
j GrmdNo
P]
A5
Unique identifying number
I Number of Individual*
numberof
N
Number of individual! in (ample |
[1] A: flmimi (»U wkh nntliir of fiaU
D: if fmLi
N: mmlmt Mi
Vfc BMMiWU
TAMS/Gradient
-------
Table 3-30
Data Dictionary for Table CONC in HISTORICXMACROINV Subdirectory
Field Name
Paradox
Field Name
FoxPro
Field Type [1]
Description
GradNo
[2]
A5
Unique identifying number
Parameter
[2]
A20
Parameter name (Aroclor)
Value-ppm
value_ppm
N
Positive numerical remit in ppm
Det Limit
det_limit
N
Sample quantitation limit reported for non-
detected reauk
Det
[21
A1
Denote* if laxnple is detected (Y) or non-
detected (N)
(1] A: i hmrmrlm frnli witfc laalur ilwiiT«i| tin rf fieW
D: Mi
N: nirtir TtM
M; wao fmii
[2] Sum m hata
TAMS/Gradient
-------
Table 3-31
Data Dictionary for Table OTHER in HISTORIC\MACROINV Subdirectory
Field Name
Paradox
Field Name
FoxPro
Field Type [1]
Description
GredNo
PI
A5
Unique identifying number
Other ipecie*
other_cpec
N
Other ipeciea number
[1] A: ntawnwr fiaU with aumWr J"in1in| >ix« of IWU
D-.imBM
N: nimbi r fWM
M: mtmo Md
PI ten
TAMS /Gradient
-------
Table 3-32
Data Dictionary for Table SPECCODE in HISTORIC\MACROINV Subdirectory
Field Name
Paradox
Field Name
FoxPro
Field Type [1]
Description
Specie*
[21
N
Specie* code
Specie* Name
speciea_na
A20
Name of specie* in sample
[1] A: cbaracur fiaU with mimtnr imrin* m ai fieU
N: water fWU
M: dw TmU
[35 SwaPnfa
TkMS! Gradient
-------
Table 3-33
Data Dictionary for Table DOHSl I t in HISTORIC\MACROINV Subdirectory
Field Name
Paradox
Field Name
FoxPro
Field Type [1]
Description
Location
[2]
A8
Location descriptor code
Description
descriptio
A40
Description of the macroinvertebnue sampling site
Attachment
[2]
A20
Type of sampling attachment
Dist FtEd
distftcd
N
Distance upstream(-) or downstream (+) from site of
former Fort Edward dam in kilometers, as originally
reported
Calc RM
calc_rm
N
Hudson River mile measured from the Battery, based
on reported distance from former Fort Edward Dam.
Fort Edward Dam taken as River Mile 194.75.
Latitude
[2]
A10
Site latitude coordinate |
Longitude
[2]
A10
Site longitude coordinate U
Memo
[21
M
Additional information concerning some locations I
[1] A: character field wiA number denoting size of Held
D: dale field
N: number field
M: memo field
[2] Sane a* Paradox
-------
Table 3-34
Data Dictionary for Table USGS_LUT in USGS Directory
B Field Name
Paradox
Field Name
Field Name
FoxPro
fieldname
Field Type [1]
Description 1
A30
Luting of all field names in USGS Directoiy
Field Type
field_type
A3
[1]
Description
deacriptio
A100
Definition of given field name
Database File
databaae_f
A50
Database file(*) which contain given Held name |
Memo
PJ
M
Additional information for certain field namea |
[1] A. <&miwax fiaU wfch anmbar 4aa«iaf «u at Mi
ry.imtoi
N: matir Mi
M: aaaofiaU
[2] 3aaa aa faiainT
TAMS/ Gradient
-------
Table 3-35
Tables in USGS\FLOW Subdirectory
Table Name
Description f
FTEDWD
Mean daily Hudson River flow at Port Edward, 1976-1993 |
GREEN
Mean daily Hudaon River flow at Green I*land, 1946-1993 f
HADLEY
Mean daily Hudaon River flow at Had Icy, 1921-1993
CORINTH
Mean daily Hudaon River flow below Sacandaga River near Corinth, 1921-1993
j SCHU
Mean daily Hudaon River flow at Schuylerville, 1977-1979
STILL
Mean daily Hudaon River flow at Stillwater, 1977-1979 f
WATR
Mean daily Hudaon River flow at Wateiford, 1976-1993 |
J BATK
Mean daily Batten Kill flow at Battenville, 1922-1968 f
| HOOS
Mean daily Hooiic River flow near Eagle Bridge, 1910-1993 [
| SACAND
Mean daily Sacandaga River flow at Stewarts Bridge, 1907-1993
1 MOHK
Mean daily Mohawk River flow, 1917-1993
| USGS7693
Mean daily flow at all above atations, except Battenville, 1976-1993
TAMS! Gradient
-------
Table 3-36
Data Dictionary for All Tables in USGSIFLOW Subdirectory
Q Field Name
|| Paradox
Field Name
FoxPro
Field Type [1]
Description
I Year
m
N
Muaurnnei* year
| Month
m
N
Measurement month
1 D*y
m
N
Measurement day
J Fk>w_day
m
N
Sequential numbered day Halting October 1 and
ending September 30
Flow
m
N
Flow nUe
Fk>w_uniU
m
A8
Flow rate units (cubic feet per second)
Station
m
A12
Station name
(1] A: ijaiMIM" Rati *i& mrmtiir ianling at fmU
Ifc im fbM
N: mimb.r Mi
Mt mmm» Mi
[2] Snmm Pnin
TAMSf Gradient
-------
Table 3-37
Tables in USGS\WQDATA Subdirectory
| Table Name
Description
I USGSWQ
Water-column PCB, aucpended sediment data, and sediment load, in tona/day, collected by
the USCS
j TOCDAT
Water-column total organic carbon (TOC) collected by the USGS
TAMS/Gradient
-------
Table 3-38
Data Dictionary for Table USGSWQ in VSGS\WQDATA Subdirectory
Page 1 of 2
Field Name
Paradox
Field Name
FoxPro
Field Type [1]
Description
Station Name
station_na
A15
USGS Station Name
Sample Date
sample_dat
D
Sample date
Year
[2]
N
Sample year
Month
[2]
N
Sample month
Day
[2]
N
Sample day
Hour
[2]
N
Sample hour
Min
[21
N
Sample minute
Inst. Discharge
inst_disc
N
Instantaneous discharge in units of cubic feet
per second (cfs)
Inst Dis Qual
inst_dis_q
N
Instantaneous discharge qualifier
(E = estimated value)
PCB Total
pcb_total
N
Total PCB value (>ig/L)
PCB Dissolved
pcb_dissol
N
Dissolved PCB value (*ig/L)
Suspended Sed
suspended
N
Total suspended sediment value (mg/L)
Key 2
key_2
N
1 indicates Total PCB value is below minimum
detection limit
Key 3
key_3
N
1 indicates Dissolved PCB value is below
minimum detection limit
Fines
12]
N
Percent less than 0.062 mm
Sediment Load
sedimentl
N
Sediment load in tons/day
AroI016
[21
N
Aroclor 1016, in f(g/L
A10IOI6-ND
arol016_nd
N
Aroclor 1016 - non-detect flag
Arol221
[2]
N
Aroclor 1221, in jig/L
Arol221-ND
a«>1016_nd
N
Aroclor 1221 - non-detect flag
Aro 1232
[21
N
Aroclor 1232, in ng/L
Aro 1232-ND
arol232_nd
N
Aroclor 1232 - non-detect flag
Arol242
[2]
N
Aroclor 1242, in ngJL
Aro 1242-ND
arol242_nd
N
Aroclor 1242 - non-detect flag
Aro 1248
[2]
N
Aroclor 1248, in ng/L
Arol248-ND
arol248_nd
N
Aroclor 1248 - non-detect flag
Aro1254
[2]
N
Aroclor 1254, in pg/L
TAMS! Gradient
-------
Table 3-38
Data Dictionary for Table USGSWQ in USGS\WQDATA Subdirectory
Page 2 of 2
1 Field Name
1 Paradox
Field Name
FoxPro
Field Type [1]
Description
1 Arol254-ND
woI254_nd
N
Aiocior 1254- - non-detect flag *
1 Arol260
121
N
Aroclor 1260, in pgfL
J Arol260-ND
«rol260_nd
N
Afoclor 1260 - non-detect flag
[1] A: cbameter field wHh number size of field
O: fkid
N: number field
M: dm mo field
|2| Same m Ruwktit
TAMSfGradient
-------
Table 3-39
Data Dictionary for Table TOCDAT in USGS\WQDATA Subdirectory
a Field Name
1 Pandos
Field Name
FoxPro
Field Type [1]
Description j
| Station Name
nation m
AI5
USGS Sution Name
R Date
12]
D
Sample date
g TOC, mg/L
toc_mg_l
N
Total organic carbon (TOC) in mg/L |
[1J A: ctanwr hi* tmmkm 4mam, inifM
zy.*m Ml
N: wamkmr fbU
y. f^u
iraki SPMHi
[2J 3*a*ai .!%!¦<¦«
TAMS/Gradient
-------
Table 3-40
Tables in GE Directory
| Table Name
Description |
| SAMPLE
Sampling information for all GE data contained in this directory [
H PC®
Total PCB« data for all media
PCBHOMOL
PCB homologue data for all media
PCBCONO
PCB congener data for all media |
NONPCB
Noo-PCB data for all media |
| SPECCODE
Fish species code |
J PCB LUT
Congener data glossary 1
| GEP ARAMS
Panuneter abbreviationa glossary I
J FIELD LUT
Database field glossary I
T &MS! Gradient
-------
Table 3-41
Data Dictionary for Table SAMPLE in GE Directory
Page 1 of 2
| Field Name [1]
Paradox
Field Name
FoxPro
Field Type [2]
Description [3] 1
NEA_file
[41
C12
NEA file identification D
as repotted on the PCB Congener Amount Report; 8
"X" only means sample is a Temporal Water- H
Column Sample analyzed for dissolved PCB* J
ID
w
A12
Unique identifier for environmental sample* |
Media
m
A1
Sample matrix: f=fish, w=water, a=air, b=biota,
p=pore water, 1= sediment, blank was assigned
u= unknown
NEA_Deac
14]
A40
NEA file description as reported on PCB summary
report sheet
NEA_Com
[4]
A40
NEA comment as reported on PCB summary report
sheet
Location
[4]
A10
Sample location
CP- > Location
cp locati
A23
Sample location from CP031194.DBF
CP->Mix_type
A1
Type of mixed peak deconvolution as reported on
the PCB congener amount report
Invest
[4]
A3
Organization that collected the sample
Lab
[4]
A8
Laboratory that performed the analysis
Customer
[4]
A20
Customer identification as reported on the PCB
summary report sheet |
Program
[41
A20
Sampling program
Date_eol
[4}
D
Sample date
Stdpth
[4]
N
Depth of top of sediment core (cm) or composite
water sample (ft)
End_dpth
[4]
N
Depth of bottom of sediment core (cm) or composite
water sample (ft)
Tot_diss
[4]
A1
Denotes total or dissolved (derived from a filtered
water sample) I
1 Deac
[41
A150
Sample description ||
I CP-> Reach
cp reach
A20
Hudson River reach where sediment samples were |
collected |
| CP-> Sampeed
cp sampae
A20
Sediment sample texture and ordinal descriptor [
T AMS/Gradient
-------
Table 3-41
Data Dictionary for Table SAMPLE in GE Directory
Page 2 of 2
Field Name [1]
Paradox
Field Name
FoxPro
Field Type [2]
Description [3]
Northing
[4]
N
1927 NY State Plane northing in ft (estimated for j
Temporal Water Column Sampling Program) J
Hasting
[4]
N
1927 NY state plane easting in it (estimated for
Temporal Water Column Sampling Program)
Elev
[4]
N
River elevation (estimated for Temporal Water
Column Sampling Program)
Miie
[4]
N
River Mile designation (estimated at confluent for
Batten Kill and Hoosic River Temporal Water
Column Sampling locations; estimated for Float
Survey sampling location; estimated at the midpoint
of each of the sampling reaches for the Sediment 1
Survey) ||
Hrcol
14]
N
Sample hour |
Mincol
[4]
N
Sample minute |
GE-> Verified
ge vcrifi
A3
Verified data has been checked for accuracy and II
validated 1
OBG_ID
14]
A8
O'Brien and Gere sample identification for |
parameters: TSS, TDS, SP_COND, TOT_ALK,
TOCF
Wtr_dpth
[4]
N
Water depth at sample location (ft)
Age
[4]
A1
Fish age in years
Len
[4]
N
Fish length in mm
Wgt
[4]
N
Fish weight in g
Sex
[4]
A1
Sex of fish: M=Male, F=Female,
U = Undetermined
Spp
[4]
A4
Fish species (refer to SPECCODE)
Pclpd
[4]
N
Percent lipids
Prep
[4]
A3
Preparation method: F=Fillet, W=Whole fish, n
U=Unknown II
[1] FMdt overtopping betwwea CP031I94.DBP aod OE03U94.DBF are generally from GEQ31194.DBP oaleM ¦pacifically aimofetod with "CP->".
[2] A: cfavaeter field witts number denoting aize of field
D:
-------
Table 3-42
Data Dictionary for Table PCB in GE Directory
Field Name [1]
Paradox
Field Name
FoxPro
Field Type [2]
A12
Description [3] 1
| NEA_file
1*1
NEA file identification |
u reported on the PCB Congener Amount Report;
"X" only meani (ample is a Temporal Water
Column Sample analyzed for dissolved PCBa
ID
[4]
A12
Unique lample identifier for environmental
samples
Method
[4]
A20
Analysis method: Capillary Column, USGS, Webb
fitU '
Mr Itmii
tafmU
CHDU94.DBF mi OBQ31194.DBF art gMirmlly frova CG091194.DBF uaieM •poci/kaiiy i
UMOf f»U
i R. to*. O'BfM 4t Oere EopNea <1994).
! #CP->'
TAkMS/Gradient
-------
Table 3-43
Data Dictionary for Table PCBHOMOL in GE Directory
Field Name [1]
Paradox
Field Name
FoxPro
Field Type [2]
Description [3] t
NEAJile
[4]
A7
NEA file identification aa repotted on the PCB
Congener Amount Report, "X" only mean* (ample
ia a Temporal Water Column Sample Analyzed for
diaaolved PCBa
9m
W
AI2
Unique sample identifier for environmental t
lamp lea |
Parameter
W
A30
Parameter name |
Value
[4]
N
Numerical result |
Unit*
[4]
A20
Unit* of result |]
[1] FiaUi mihwit >x»«i CKI31W.DBF tad OB03UM.DBF ai* family from GB03UM.DBF laka •pacifically amwiartari with *CP->*.
[2J A: chnolw fiaU wilh limbic teotasg oa at (iaU
Or +* Mi
N: iiiBlir fiaM
ttMtbU
pi <1 III I In ii -IIWIi—rin« pmriM ky kmm R. Rhaa. O'lria * 0
-------
Table 3-44
Data Dictionary for Table PCBCONG in GE Directory
Field Name [1]
Paradox
Field Name
FoxPro
Field Type [2]
Description [3]
NEA_file
[4]
A7
NEA file identification as reported on the PCB
Congener Amount Report, "X' only means (ample
is a Temporal Water Column Sample Analyzed for
dissolved PCBs
ID
[4]
A12
Unique sample identifier for environmental samples H
Parameter
[4]
All
Parameter code name |
Value
[4]
N
Numerical result |
Units
[41
A20
Units of result |
[1] Field* overlapping between CPQ3U94.0BF and OE031194.DBF are generally from GE031194.DBF unleea specifically anno* ted wifc "CP->V
[2] A: chancier field wifc number denoting tize of field
D: dale field
N: aumber field
M: memo field
(3] Adapted from documenttlon provided by ham R. Rhea, O'Brien A Oere (1994).
(4] Sum m Paradox
TAMSIGradient
-------
Table 3-45
Data Dictionary for Table NONPCB in GE Directory
Field Name [1]
Paradox
Field Name
FoxPro
Field Type [2]
Description [3] 1
NEAJile
[41
A7
NEA file identification aa repotted on the PCB I
Congener Amount Report, "X" only mean* sample is a Q
Temporal Water Column Sample Analyzed for I
dissolved PCBs |
1 m
[4J
A12
Unique sample identifier for environmental samples ||
| Parameter
[41
A30
Parameter name . |
Value
[41
N
Numerical result U
Units
[41
A20
Units of result §
(1] F»lfc illicit Utmmm CKBU94.DBF mi OB03UM.DBF in gamUy from QB03UM.DBF takm .pecifKmlly aaamtfi w*h "CP->\
A: ckmctor Mi «d> amakar daootin* m of fold
D; f»k
N: »¦>» Mi
M: bmbbTmU
[3] A lipli 1 from dnniu>w«i«i pmiiei by fcmai R. Rha, O'Brito & CT (1994).
[4] Swa hnta
TAMSI Gradient
-------
Table 3-46
Data Dictionary for Table SPECCODE in GE Directory
Field Name
Pandoz
Field Name
FoxPro
Field Type [1]
Description
Spp
CI
AS
Specie* code |
[specie.
[2]
A30
Name of tpecica in aamplet j
[1] A: ffawini (mU «it nnw> ir taiKin uw Mi
D:*»
-------
Table 3-47
Data Dictionary for Table PCB LUT in GE Directory
Field Name
Paradox
Field Name
FoxPro
Field Type [1]
Description
Parameter
[2]
All
Parameter code name from PCBCONG |
NEA Parameter name
nea_parame
A31
Repotted parameter name
Congener 1
congener_l
A45
First congener name or description
Congener 2
congener_2
A39
Second congener name if coelution
Congener 3
congener_3
A35
Third congener name if coelution
Group
[2J
A7
Homoiogue group |
BZ
[2]
A38
Corresponding BZ number
(1] A: character field with number denoting size of field
D: FieW
N: —w***—' field
M: memo field
[2] Same at Paradox
TAMSf Gradient
-------
Table 3-48
Data Dictionary for Table GEPARAMS in GE Directory
| Field Name
field Name
Field Type [1]
Description g
| Paradox
FoxPro
| Parameter
p«mneter_0
A20
Database parameter abbreviation g
parameter_l
A60
Parameter name 1
[1] A: ihnmr wik mvmh.r Mm u* at &U
D:
N: il ¦ f»U
M: wmmtmU
TAMS/Gradient
-------
Table 3-49
Data Dictionary for Table FIELD_LUT in GE Directory
Field Name
Paradox
Field Name
FoxPro
Field Type [1]
Description [
Field Name
field_name
A15
Contains all field names in GE Directory |
Field Type
field_type
A3
m
Description
descriptio
A100
Definition of each field name |
Database File
database_f
A30
Files that contain given field
Memo
[2]
M
Additional information on field names
[1] A: chamcter field with number dimming size of field
D: data field
N: number field
M: memo field
[2] Same ai P&mdox
TAMS/Gradient
-------
Table 3-50
Data Dictionary for Table GAUGES in NYSDOT Directory
Field Name
Paradox
Field Name
FoxPro
Field Type
[1]
Description |
Year
[2]
N
Measurement year |
Month
[2]
N
Measurement month
Day
[2]
N
Measurement day
Wy day
wy_day
N
Water year day
Gauge 119
[2]
N
Reading at staff gauge located below Lock 7 (Fort Edward) [3] Q
Gauge 118
[2]
N
Reading at staff gauge located above Crocker's Reef guard gate H
(Thompson Island Dam) at land cut portion of canal (near Fort I
Miller) [3] \
Gauge 116
[2]
N
Reading at staff gauge located above Lock 6 (near Fort Miller) |
[3]
Gauge 115
[2]
N
Reading at staff gauge located below Lock 6 (near Fort Miller)
[3]
Gauge 114
[21
N
Reading at staff gauge located above Lock 5 (near Schuylerville)
[3]
Gauge 113
[2]
N
Reading at staff gauge located below Lock 5 (near Schuylerville)
[3]
Gauge 109
[2]
N
Reading at staff gauge located above Lock 4 (near Stillwater) [3]
Gauge 108
[2]
N
Reading at staff gauge located below Lock 4 (near Stillwater)
[3J 1
Gauge 106
[2]
N
Reading at staff gauge located above Lock 3 (near |
Mechanicville) [3] j
Gauge 105
[2]
N
Reading at staff gauge located below Lock 3 (near
Mechanicville) [3]
Gauge 104
[2]
N
Reading at staff gauge located above Lock 2 (near
Mechanicville) [3] 1
Gauge 103
[2]
N
Reading at staff gauge located below Lock 2 (near
Mechanicville) [3] j
[1] A: dmmcter fold wife number deoou* tat of fieto
D: (fcto field
N: foid
M: mciPo field
[2] Same at fendox
p] Reading in ft, rebtive to NYS Barge Cam] Datum.
Thi* reeding can be cooverted to NOVD 1929 by rabmctiag 1.177 ft
TP^AS! Gradient
-------
Table 3-51
Data Dictionary for Table CONG_LUT in PHASE2 Directory
Field Name
Paradox
Field Name
FoxPro
Field Type [1]
Description I
BZ No
[2}
A3
Congener number
Parameter
[2]
A25
Contains all PCB parameters in PHASE2 Directory
Homologue
[2]
AIO
Classification based on number of chlorine atoms
Description
descript
A50
Definition of given PCB parameter
Conversion
[2J
All
Correction factor see PHASERFIELDS Jj
Target
[2]
AIO
Yes: target congener (calibrated with standard) |
No: non-target congener 1
No-cal: calibrated non-target congener R
Mix: congener pair coelutes ||
Unit_water
[2]
A8
Units for water samples, in ng/L |
Unit_sed
[2]
A8
Units for sediment samples, in ng/Kg DW ||
Unit_part
[2]
A8
Units for particulate samples, in fig/Kg DW |
Directory
[2J
A45
PHASE2 Subdirectories) that contain given H
parameters ||
Database
[2]
A30
Database files that contain given parameter 8
Comment
[21
A100
Comments ||
(1) A: ciancter field with number denoting toe of fieid
D: fete field
N: number field
M: memo field
[2) Same at Paradox
TAMS/Gradient
-------
Table 3-52
Data Dictionary for Table FIELDS in PHASE2 Directory
Field Name
Paradox
Field Name
FoxPro
Field Type [1]
Description |
J
Field Name
field_nanie
A30
Contains database field names for PHASE2 1
Directory f|
Field Type
field_type
A3
[1]
Description
descriptio
A100
Definition of field name
Database File
databaaef
A100
Files that contain given field name
Memo
[2]
M
Additional information for certain fields |
[1] A: character field with number denoting txze of field
D: fete field
N: number field
M: memo field
[2] Same m fondox
T AMS/Gradient
-------
Table 3-53
Data Dictionary for Table PARAMS in PHASE2 Directory
Field Name
Parados
Field Name
FoxPro
Field Type [1]
Description |
Parameter
12)
A30
Contains every parameter in the PHASE2 Directory |
Matrix
[2]
A12
Sample matrix |
Units
[2]
A15
Units of result
Description
descriptio
A100
Definition of given parameter
Subdirectory
[2]
A30
Lists PHASE2 Subdirectories containing given
parameter
Database
[2]
A 30
Database table within subdirectories where given
parameter can be found
Memo
[2]
M
Additional information for certain parameters
A: character field wife number tarn of field
D: fete field
N: saber field
M: dwom field
Seme m fendox
[I]
[A
TAMS/Gradient
-------
Table 3-54
Data Dictionary for Table QUALIFY in PHASE2 Directory
Field Name
Paradox
Field Name
FoxPro
Field Type [1]
Description j
QA Comment
qa_comment
A5
Specific Quality Assurance qualifier [3] |
Type
[2]
A30
Designates laboratory or data validation qualifier |
Definition
12]
M
Definition of QA Comment |
Parameter Type
Parameter
A20
Parameter type for which qualifier is applicable |
Assigned Qualifier
assigned_q
A5
Simplified reported qualification [3] |
(1) A: character field wife rannSrr deaotiag size of field
D: (kta f»M
N: tumber field
M: memo field
(2) Same m Paradox
(3) QA Comment tpecifiee fee imiou for qualification, e.g., why a vakw is estimated, «feile fee Attifnnl Qualifier designate wbefeer fee vatae * HD-detect
estimated, presumed praeent, or rejected.
TAMS/Gradient
-------
Table 3-55
Data Dictionary for Table AROCLSTD in PHASE2 Directory
Field Name
Paradox
Field Name
FoxPro
Field Type [1]
Description
Lab Sample ID
lab_aample
A10
Laboratory aample identifier
Sample ID
aample_id
A25
Sample identifier |
Date Analyzed
date_analy
D
Data sample was analyzed |
Matrix
PI
A8
Sample matrix
Parameter
[2]
A28
Parameter name
Unite
PI
A10
Unita of result
Value
[2|
N
Numerical result with non-detected values set to
sample detection limit
Qualifier
C2J
A10
Data qualifier
Validated
[2]
A3
Field denoting if results have been validated 1
(Yea/No) f
[1] A: dMCW Ml wife mmb*r Jda of fiaU
D;4m(«U
N: aato fWU
UimmM
n Sua a Hiiiw
TkMSi Gradient
-------
Table 3-56
Data Dictionary for Table ASCREEN in PHASE2 Directory
| Field Name
U Paradox
Field Name
FoxPro
121
Field Type [1]
A28
Description I
| Parameter
Congener H
1 1016
ro
N
Azoclor 1016 [3] f
1 1221
[2]
N
Aroclor 1221 [3]
1232
P]
N
Aroclor 12321 [3]
J 1242
[21
N
Aroclor 1242 [3]
1248
12]
N
Aroclor 1248 [3] |
1254
12]
N
Aroclor 1254 [3] |
1260
12]
N
Aroclor 1260 [3] f
1 1016-1242
1016J242
N
Aroclor* 1016 and 1242 [3] |
1 1221-1232
1221_1232
N
Arocion 1221 and 1232 [3] |
j 1016-1248-1254
1016_1248x
N
Aroclor* 1016, 1248 and 1254 [3] f
[1] A: rhanrMr fiaU with iiilur ilmnim uza of fold
D: St* r»U
N: mimkir fiaM
M: mtma fiaU
ra
PI
Confaaar » i nniillnJ prMat in tha Aroclor or sum of Arocion wb«B naricad with a *1*. Coo|coar M ih»ml «feaa maiksd wrtli a *0*.
TAMS/Gradient
-------
Table 3-57
Tables in PHASE21WATER Subdirectory
Tables in PHASE2 \ WATER
Table Name
Description |
STATIONS
Water column transects and flow-avenged events stations |
GROUPS
Sample groupings |
PCBP
PCB congeners/homologue sums/Aroclor concentrations - particulate samples (fig/Kg) [
PCBFA7
PCB congeners/homologue sums/Aroclor concentrations - combined particulate and 1
dissolved samples (ng/L) for flow-averaged event 7 f
PCBW
PCB congeners/homologue sums/Aroclor concentrations - water samples (ng/L) |
NONPCBW
Non-PCB data • water column samples |
VOLUMES
Sample volumes filtered for PCB analyses R
Tables in PHASE2\ WATER\QAQC
Table Name
Description |
FB
Non-PCB data - field blanks
NONPCBWD
Non-PCB data - water duplicate sample pairs
PCBPD
PCB congeners - particulate duplicate pairs (fig/Kg)
PCBWD
PCB congeners - water duplicate pairs (ng/L)
PCBWTT
PCB congeners - whole water samples
-------
Table 3-58
Data Dictionary for Table STATIONS in PHASES IWA TER Subdirectory
Field Name
hndox
Transect
Field Name
FoxPro
pi
Field Type [1]
Description
A5
Transect or flow-averaged sampling event
number |
Station
P]
A6
Station number |
TAMS ID
tama_id
All
Sample identifier ||
TAMS Type
tam*_type
A3
Sample type [3]
Date Sampled
datc_iampl
D
Date sample was taken
Matrix
[2]
Ati
Sample matrix (WATER, FILTER)
Eat Easting
PI
N
Estimated NY State Plane easting (it)
Eat Northing
PI
N
Estimated NY State Plane northing (ft)
River Mile
river_mile
N
River mile measured from the Battery
Location
PI
A30
Station description
Program
PI
A3
Program abbreviation (TW, TS, TT, FW, TS)
[4]
SAS No.
saa_nox
A18
Sample identifier for laboratory program
| Comment
PI
A120
Sample comment
[1] A: dncar Mi with mtmkm 4m*mi nu of Ml
D:tehll
N: water fiaU
MiwmU
[2] * at hwfa
(3] B: FisW W
C: CnwjMiM
0: D<*{>caM
M: Mnilnai
(4] TS: War 1^1— traaaaet MpaW maMar mmfb
TF;War«lai Basnet «Ma
-------
Table 3-59
Data Dictionary for Table GROUPS in PHASE2 \ WATER Subdirectory
Field Name
Paradox
Field Name
FoxPro
Field Type [1]
Description
Station
CT
A6
Station number
Group
m
A25
Group idertofier
m
A: cWicMr Mli
N: ir fl»M
ra
TAMS/Gradient
-------
Table 3-60
Data Dictionary for Tables PCBP, PCBW, PCBFA7, PCBPE, PCBWE
in PHASE2\WATER Subdirectory
Field Name
Paradox
Field Name
FoxPro
Field Type [1]
Description
TAMS ID
tams_id
All
Sample identifier |
TAMS Type
tamstype
A3
Sample type [2]
Split
[2]
AI0
Field denoting if record represents a composite of
duplicate analyses (Avg-FC - average of field co-
locates); not contained in PCBFA7, PCBPE or
PCBWE.
Matrix
[2]
A8
Sample matrix (WATER, FILTER)
Parameter
[2]
A28
Parameter name
Units
[2]
A10
Units of result |
Value 1
[21
N
Numerical result with non-detected values set to sample
detection limit (3]; in PCBFA7, Vahiel labelled Value
Vaiue2
m
N
Numerical result with non-detected values set to 0 or 1/2
detection limit; not contained in PCBFA7 |
Qualifier
[2]
A5
Data qualifier 1
QA Comment
qa_comment
A10
Quality Assurance comment codes see 1
Pft4S£2\QUALIFY |
Validated j
[21
A3
Field denoting if results have been validated (Yes/No) (j
[1] A: chancier field wHfe number denoting tin of field
O: dale field
N: number field
M: memo field
[2] B: Field blu*
C: Compoeiie
D: Duplicate
M: Mjecelkaeoue
[3] HeooiofiM nan ud Total PCBe vmhtet ropmwt eumn of detected vmlaee only.
TAMSI Gradient
-------
Table 3-61
Data Dictionary for Tables PCBWTT, PCBWD, PCBPD
in PHASE2\WATER Subdirectory
Field Name
Paradox
Field Name
FoxPro
Field Type [1]
Description
TAMS ID
tams_id
All
Sample identifier
TAMS Type
tams_type
A3
Sample type [2]
Split
[3]
A10
Non-blank entry denotes a field split sample
Matrix
[3]
A8
Sample matrix (WATER, FILTER)
Parameter
[3]
A28
Parameter name
Units
[3]
A10
Units of result
Value
[3]
N
Numerical result with non-detected values set to 1
sample detection limit |
Qualifier
[3]
AS
Data qualifier
QA Comment
qa_comment
A10
Quality assurance comment codes see
PHASE2\QU ALIFY
Validated
[3]
A3
Field denoting if results have been validated
(Yes/No)
[1] A: cfaanetor field wife number denoting size of field
D: fete field
N: number field
M: memo field
[2] B: Field bbuk
C: Composite
D: Dupbctie
M: MieceUftneoue
[3] Sum m hnbm
TAMS/Gradient
-------
Table 3-62
Data Dictionary for Tables NONPCBW, NONPCBWD in PHASE21 WATER Subdirectory
Field Name
Paradox
Field Name
FoxPro
Field Type [1]
Description
TAMS ID
tam»_id
All
Sample identifier |
TAMS Type
tam*_type
A3
Sample type [2] |
SAS No.
aaa_nox
A8
Sample identifier for laboratory program
Split
[3]
A10
Field denoting if record represents a composite of
duplicate analyses (Avg-FC - average of field co-
locatea) in NONPCBW; Non-blank entry in
NONPCBWD repreaenu a laboratory duplicate
anlayiis
Laboratory
[3]
A10
Name of laboratory performing analyiia
| SDONo.
»dg_nox
A12
Sample delivery group (for data validation)
Parameter
13]
A30
Parameter name
Unita
[3]
A10
Unita of result
Value
[31
N
Numerical result with non-detected values set to
sample detection limit
Qualifier
[3]
A4
Data qualifier
Validated
[3]
A4
Field denoting if results have been validated
(Yes/No)
[1] A: rham«ar fiali wih ouafcar iii« af fiaM
D: faM
N: ¦— fiaU
M: mmm» ftaU
[2] B: FiaM bWc
C: rmi^wiM
D: IX^iiaaM
M: Manlkama
P] IniaMa
TAMS/Gradient
-------
Table 3-63
Data Dictionary for Table FB in PHASE21WATER Subdirectory
| Field Name
| Paradox
Field Name
FoxPro
Field Type [1]
1 1 1
Description
U TAMSID
tams_id
All
Sample identifier
TAMS Type
tama_type
A3
Sample type [2] 1
SAS No.
faa_nox
AS
Sample identifier for laboratory program
Split
[3]
A10
Non-blank entry denote* a laboratory duplicate or
aplit sample
Laboratory
[3]
A10
Name of laboratory performing analysis
SDG No.
«dg_nox
A12
Sample delivery group (for data validation) |
Parameter
[3]
A 30
Parameter name
Unit*
[3]
A10
Units of result
Value
[3]
N
Numerical result with non-detected values set to
sample detection limit
Qualifier
[3]
A4
Data qualifier
[t] A: il— flaU witt niimtir il«nmi| lia of Mi
D: tes feU
N: nnmbtr fwM
M: BMofnU
[2] B: FmU tU
C: Ciinii
D: Dafliaa
M: MMIbmi
P] Sum a* hiito
T\MS! Gradient
-------
Table 3-64
Data Dictionary for Table VOLUMES in PHASE2\WATER Subdirectory
Field Name
Paradox
Field Name
FoxPro
Field Type [1]
Description 8
TAMSW
121
All
Sample identifier - water (ample |
SampTypeW
[2]
A3
Sample type - water tample [3] |
TAMSP
PI
All
Sample identifier - corresponding filtered (ample |
SampTypeP
[21
A3
Sample type - corresponding filtered (ample [3] §
Volume Filtered
volume_fil
N
Volume filtered |
Unita
12]
A4
Unit* of volume filtered |
[1] A: ctamcOr (Mi with mimhw daMag lit* oi field
D: datt
N: auatir fWM
M: mcM
(21 Fknin
[3] B: FmU Male
C: CumpmiM
D: Diylioatt
M? KfiftwUmMiift
TAMSIGradient
-------
Table 3-65
Tables in PHASE2\SEDIMENT Subdirectory
Tables in PHASE2 \SEDIMENT
i^BaiaBai^^HBBSBB^aBSsaBsss^ssssssssssssssssssas
| Table Name
1 STATIONS
Description |
Confirmatory Sampling and High-Resolution Sediment Coring Program sampling stations |
| PCBS
PCB congenen/homologue sums/Aroclor umi - sediment samples (jig/Kg DW) |
NONPCBS
Non-PCB data - sediment samples
SIEVE GS
ASTM Grain lizc distribution data by (ieve analyaia
LASERGS
Grain size distribution data by laser particle analysis
RADNUC
Radionuclide data - sediment samples |
| LRINFO
Supplemental Low Resolution Sediment Coring Program information |
1 SEDDESC
Descriptive sediment classifications density, redox and other field data H
Tables in PHASE2\SED1
| Table Name
MENT\QAQC
Description f
1 FB
Non-PCB data - field blanks
1 LASERGSD
Grain size distribution data by laser particle analysts - sample duplicates
NONPCBSD
Non-PCB data - duplicate sediment sample pairs
PC BSD
PCB congeners • duplicate sediment sample pairs (jig/Kg DW) |
RADNUCD
Radionuclide data - sediment samples field splits and laboratory duplicates |
SIEVEGSD
ASTM Grain size distribution data by sieve analysis - sample duplicates |
TXMSIGnadient
-------
Table 3-66
Data Dictionary for Table STATIONS in PHASE2\SEDIMENT Subdirectory
| Field Name
Paradox
Field Name
FoxPro
Field Type [1]
Description
Station
[2]
A8
Station number
TAMS ID
tams_id
All
Sample identifier |
TAMS Type
tams_type
A3
Sample type [3] ||
Date Sampled
date_sampl
D
Date sample was taken ||
Time Sampled
time_sampl
A10
Time sample was taken
Lower Depth (cm)
lower_dept
N
Depth of top of sediment slice (cm)
Upper Depth (cm)
upper_dept
N
Depth of bottom of sediment slice (cm)
Easting
[2]
N
NY State Plane easting (ft)
Northing
12]
N
NY State Plane northing (ft) |
Location
[2]
A30
Station description |
Program
[21
A3
Program abbreviation (CC, CG. LR, LH) [4] |
SAS No.
sas_nox
A10
Sample identifier for laboratory program ||
Comment
[2]
A120
Sample comment |
[1] A: cfaamcter Held witb number denoting »ize of field
D: date field
N: number field
M: memo field
[2] Suae m Panwioi
[3] A: Archive cor*
B: Field bkxfc
D: Duplicate core
O: Ortin-fise cere
M: Matrix spike sample or core
P: PCB core
X: X
-------
Table 3-67
Data Dictionary for Table PCBS in PHASE2\SEDIMENT Subdirectory
Field Name
Paradox
Field Name
FoxPro
Field Type [1]
Description |
TAMS ID
tams_id
All
Sample identifier 1
TAMS Type
tams_type
A3
Sample type [2] (
Split
[31
A10
Field denoting if record represents a composite of |
duplicate analyses
-------
Table 3-68
Data Dictionary for Tables PC BSD in PHASE2\SEDIMENT Subdirectory
3" Field Name
Paradox
Field Name
FoxPro
Field Type [1]
Description I
TAMS ID
tams_id
All
Sample identifier
TAMS Type
tams_type
A3
Sample type [2]
Split
[3]
A10
Non-blank entry denotes a laboratory split sample |
Matrix
[3]
A8
Sample matrix (SED) |
Parameter
[3]
A28
Parameter name
UniU
[3]
A10
Units of result
Value
[3]
N
Numerical result with non-detected values set to
sample detection limit
Qualifier
[3]
AS
Data qualifier
QA Comment
qa_comment
A10
Quality Assurance comment code see
P«4J£2\QUALIFY
Validated
[3]
A3
Field denoting if results have been validated
(Yes/No)
Date Sampled
date_iampl
D
Date sample was taken 1
(1) A: character field wtti number of 5eld
D: date field
N: number field
M: memo field
[2] A: Archive core
B: Field bkak
D: Delicate core
O: GntaMOft core
M: Matrix «pike maple or core
P: PCB core
X: X-Riy core
PI Same m fendax
TAMS/Gradient
-------
Table 3-69
Data Dictionary for Tables NONPCBS, NONPCBSD, SIEVEGS, SIEVEGSD, LASERGS,
LASERGSD in PHASE2\SEDIMENT Subdirectory
Field Name
Paradox
TAMS ID
Field Name
FoxPro
tains id
Field Type [1]
Description 1
All
Sample identifier |
TAMS Type
tams_type
A3
Sample type [2] |
SAS No.
sas_nox
A8
Sample identifier for laboratory pro grain J
Split
[3]
A10
Field denoting if record represent* a 1
composite of duplicate analyses (Avg-FC • E
average of field co-locates) in NONPCBS; |
Non-blank entry in NONPCBSD presents a j
laboratory duplicate anlaysis |
Laboratory
[3]
A10
Name of laboratory performing analysis |
SDO No.
sdg_nox
A12
Sample delivery group (for data validation) |
Parameter
[3]
A30
Parameter name |
Units
[3]
A10
Units of result
I Value
[31
N
Numerical result with non-detected values set
to sample detection limit
Qualifier
[31
M
Data qualifier
Validated
[31
A4
Field denoting if results have been validated
(Yea/No) f
[1] A: du« fioU «*h pwmtnr «• of fold
KfctofieU
N: »n i > ¦ fWU
I2J A: Ankin eon
B: FaU kWc
D:
O:
M:
P: PCS eon
X: X-UMf oon
ra
TAMS! Gradient
-------
Table 3-70
Data Dictionary for Table FB in PHASE2\SEDIMENT Subdirectory
| Field Name
Paradox
TAMS ID
Field Name
FoxPro
tamsjd
Field Type [1]
Description
All
Sample identifier
TAMS Type
tarm_type
A3
Sample type [2]
SAS No.
ui nox
A8
Sample identifier for laboratory program
Split
[31
A10
Non-blank entry denote* a laboratory duplicate or
split aample
Laboratory
PI
A10
Name of laboratory performing analysis
SDG No.
»dg_nox
A12
Sample delivery group (for data validation)
Parameter
[3]
A30
Parameter name
Units
[3]
A10
Value
[31
N
Numerical result with non-detected values set to I
sample detection limit |
Qualifier
[31
A3
Data qualifier |
[1] A: rlniMir flaM wMi aumbar tainiK tin of Mi
"¦ M 1 " T
M: bwIW
[2] A: Anhm oara
B: FiaU Unk
D: n^i ati oara
O; Oiaii ail! oara
M: Matrix Mmpta sr oora
P; KB ean
X: X-lajrim
P) Saaa m Paniox
ThMS! Gradient
-------
Table 3-71
Data Dictionary for Tables RADNUC, RADNUCD in PHASE2\SEDIMENT Subdirectory
1 Field Name
| Paradox
Field Name
FoxPro
Field Type [1]
Description
| TAMS ID
tami_id
All
Sample identifier
TAMS Type
tams_type
A3
Sample type [2]
Split
[3]
A4
Non-blank entry denote* a laboratory duplicate or
split tample
Laboratory
[3]
A10
Name of laboratory performing analysis j
SDG No.
sdg_nox
AS
Sample delivery group (for data validation) |
Date Sampled
date_iampl
D
Date sample was taken |
Counting Date
counting_d
D
Date sample was counted
Detector
[3]
All
Detector type
| Parameter
[3]
A30
Parameter name
| Unit*
13]
A10
Units of result
| Sigma
[3]
N
Standard deviation associated with counting result
1 Value
[3]
N
Numerical result with non-detected values set to 1
sample quantitation limit |
Det Limit
det_limit
N
Reported counter detector limit |
Qualifier
[3]
A3
Data qualifier E
Validated
13]
A4
Field denoting if results have been validated E
(Yes/No) |
(1] A: thiUn DM wUt mirnb»r dtoodag at of fold
D:
N: aumWr fWU
(21 1»tIi lyp* CMaforim
A: Ankiw* oon
B: FMUUnfc
D; Di^lirH on
G: OniMai cm
M: Mmb flu nfl> «r can
P; PCB con
X: X-Bqr eon
(3] Sum at Pinto
TAMS/Gradient
-------
Table 3-72
Data Dictionary for Table LRINFO in PHASE2\SEDIMENT Subdirectory
Field Name
Paradox
Field Name
FoxPro
Field Type [1]
Description fl
TAMS ID
tam_id
All
Sample identifier §
TAMS Type
tama_type
A3
Sample type [2] |
NYSDEC No.
ny«dcc_nox
A8
Corresponding 1984 NYSDEC Sediment Survey 1
Station No. (from Brown et. al 1988) |
Hotapot No.
hotspot_nx
A10
NYSDEC Hotapot Number |
[1] A: tear &U wftfc niriir imxMmg tarn ai fmii
Xy.imMi
N: TmU
PJ Tyrm CaMfonM
A: Ankm eon
B: F«U Wt
D; OffieM can
(fc OnMn em
M: Mtfris ip8» ¦¦ipii «r eon
ft PCB eon
X: X-lajr oan
TAMS/Gradient
-------
Table 3-73
Data Dictionary for Table SEDDESC in PHASE2\SEDIMENT Subdirectory
Field Name
Paradox
Field Name
FoxPro
tarn id
Field Type [1]
Description
| TAMS ID
All
Sample identifier
I TAMS Type
tama_type
A3
Sample type [2]
1 Eh
[3J
N
Redox potential in meV
g Temperature
temperatur
N
Temperature of redox measurement in *C fl
| Field Commert
field_comm
A50
Comments from field notes |
Color 1
[3]
A3
Primary sediment coloration noted in field
Color 2
[3]
A3
Secondary sediment coloration noted in field
I Sed_Cl*»_l
13]
A3
TAMS descriptive sediment classification (based on
ASTM method)
Sed_Clas_2
[3]
A3
TAMS descriptive sediment classification (based on
ASTM method)
Sed_Clas_3
[3]
A3
TAMS descriptive sediment classification (based on I
ASTM method) [
J Sed_Cl*s_4
[3]
A3
TAMS descriptive sediment classification (based on
ASTM method)
J Sed_Clas_3
[3]
A7
TAMS descriptive sediment classification (baaed on
ASTM method)
Description
deacriptio
A120
Complete field description of sediment
characteristics
Wet Weight
wctwcight
N
Wet weight of ssmple, in grams
Volume
[31
N
Volume of container, in cc
Bulk Density
bulk_denii
N
Bulk density of sample, in g/cc
| Percent Solid*
percent_«o
N
Measured percent of solids
i Particle Density
particlex
N
Particle density, in g/cc
[1] A: ctMMttr few nhr 4—<*«« m» of Mi
W: naistir fi«M
[2] SMpi* Tn« f^mnrin
A: Aidm em
B: Fi*U bWt
D: Dvfbatm em
O; OoMH em
M: Matrix tfiM tugpW or con
P: FCB cm
X: X-RWf em
[3] Sim a* hate
TAMS/ Gradient
-------
Table 3-74
Tables in PHASE2\EC0 Subdirectory
Tables in PHASE2\ECO
Table Name
Description
STATIONS
Ecological survey stations
COORDS
Coordinates for stations |
GROUPS
Sample groupings |
BENTHIC
Sample composition information - invertebrates
FISH
Sample composition information - fish
PCBFISH
PCB congeners/homologue sums/Aroclor concentrations • fish
PCBINV
PCB congeners/ho mologue sums/Aroclor concentrations - invertebratea
NONPCBB
Non-PCB data - biota |
PCBS
PCB congeners/homologue sums/Aroclor concentrations - sediment samples (ptg/Kg DW)
NONPCBS
Non-PCB data - sediment samples
LASERGS
Sediment laser grain size data
SPECIES
Key to species codes
Tables in PHASE2 \ECO 1QA QC
Table Name
Description |
FB
Non-PCB data - sediment field blanks |
LASERGSD
Sediment laser grain size data - duplicate pairs Q
NONPCBBD
Non-PCB data - biota duplicate pairs |
NONPCBSD
Non-PCB data - sediment duplicate pairs |
PCBFISHD
PCB congeners - fish dilution analyses ||
PCBINVD
PCB congeners - invertebrate dup. pairs/dilution analyses |
PC BSD
PCB congeners- sediment duplicate pain (fig/Kg DW) 8
TAMS/Gradient
-------
Table 3-75
Data Dictionary for Table STATIONS in PHASE2\ECO Subdirectory
I Field Name
J Paradox
Field Name
FoxPro
Field Type [1]
Description
Station
PJ
A8
Station number
TAMSID
tama_id
All
Sample identifier g
TAMS Type
tama_type
A3
Sample type [3]
J Specie*
PI
A4
Species code
| Date Sampled
date_iaznpl
D
Date aample wu taken
Eat Easting
eat_eaatin
N
Eatimated NY State Plane eaating (ft)
Eat Northing
eat_noithi
N
Estimated NY State Plane northing (ft)
River Mile
rivermilc
N
Mile measured from the Battery
Deacription
deacriptio
A26
Station deacription J
Program
[2]
A3
Prognun abbreviation (EC) [4] |
] SASNo.
saa_nox
A8
Sample identifier for laboratory prognun |
\ RASNo.
raa_nox
A8
Second aample identifier for laboratory program |
I Comment
PJ
A120
Sample comment 1
[1] A: rinrttr fiaU with Busbar faooOic ii» at fnU
D:4kWl
N: .untir HM
M: wm» Bali
(Z] Sam* m P—dm
[3] B: FaU bMc
D: Du^ijcM upk
[4] BC: Hnwlofkml aimjr
TAMSf Gradient
-------
Table 3-76
Data Dictionary for Table COORDS in PHASE2\ECO Subdirectory
Field Name
Paradox
Field Name
FoxPro
Field Type [1]
Description
Station
[2]
A16
Station name
Est Easting
est_eastin
N
Estimated NY State Plane easting (ft)
Est Northing
est_northi
N
Estimated NY State Plane northing (ft)
Sample Type
sample_typ
A23
Type of sample taken
Fish Type
fish_typ
A18
Type of fish taken |]
[1] A: dander field with number dnnnting lire of field
D: field
N: nunber field
M: memo field
[2J Sum m
TAMS/Gradient
-------
Table 3-77
Data Dictionary for Table GROUPS in PHASE2\ECO Subdirectory
Field Name
Field Name
Field Type [1]
Description (
| Paradox
FoxPro
p Station
PI
A8
Station number
II Group
ra
A25
Group identifier
[1] A: rtaiirnr fiiU with nunbf dcootiBf liza of field
D: dM Ml
N: natir fi*U
MiMafaU
TAMS/Gradient
-------
Table 3-78
Data Dictionary for Table BENTHIC in PHASE2\ECO Subdirectory
1 Field Name
H Paradox
Field Name
FoxPro
Field Type [1]
Description
1 TAMS ID
tmms_id
All
Sample identifier
| TAMS Type
tams_type
A3
Sample type [2]
Speeiea
[3]
A8
Specie* code
SAS No.
su_nox
A8
Laboratory identifier
Wet Weight (mg)
wet_weight
N
Sample wet weight in mg
Comments
[3]
A160
Sample comment
[1] A: rhimw fWU with water ilmtiig tin of fi*U
D-. ^afWU
N: ouster RM
M: mm fold
[2] B: FmU kU
D; Ih^liiH Map)*
TAMSi Gradient
-------
Table 3-79
Data Dictionary for Table FISH in PHASE2 \ECO Subdirectory
Field Name
Paradox
Field Name
FoxPro
tam* id
Field Type [1]
Description |
TAMS ID
All
Sample identifier |
TAMS Type
tamsjypc
A3
Sample type [2] |
Species
[31
A8
Specie* code |
SAS No.
saa_nox
A8
Laboratory identifier |
No of fish in aample
No_of_fuh
N
Number of fiah in sample* |
LI (mm)
ll_mmx
N
Length in mm of fiah number 1 |
L2 (mm)
12_mmx
N
Length in mm of fish number 2 f
L3 (mm)
13_mmx
N
Length in mm of fish number 3 |
L4 (mm)
14_mmx
N
Length in mm of fish number 4 |
L5 (mm)
13_mmx
N
Length in mm of fish number 5 [
| L6 (mm)
16_mmx
N
Length in mm of fish number 6 [
J L7 (mm)
17_mmx
N
Length in mm of fiah number 7 I
j L8 (mm)
18_mmx
N
Length in mm of fish number 8 I
Length No
[3]
N
Number of fiah used to determine average E
length
Sum
[3]
N
Sum of fish lengths used to determine average
length in mm
Avenge length
average_le
N
Average of lengths in mm
Average weight
average_we
N
Average of weights in mg |
Bulk weight
bulk_weigh
N
Total weight of the fish sample in mg f
[1] A: i^nnnr fmU matir <¦«»» mm at Mi
D: fUU
N: nk« fiaU
M: w TmU
(2) B: FmU bU
D: I>»lirH aopb
TAMS/Gradient
-------
Table 3-80
Data Dictionary for Tables PCBS, PCBINV, PCBFISH in PHASE2\ECO Subdirectory
Field Name
Paradox
Field Name
FoxPro
Field Type [1]
Description
TAMS ID
tams_id
All
Sample identifier
TAMS Type
tams_type
A3
Sample type (2]
Species
13]
A4
Species code (not present in PCBS)
Split
[3]
A10
Field denoting if record represents a composite
of duplicate analyses (Avg-FC - avenge of field
co-locates)
Matrix
[3]
A10
Sample matrix (SED, BIOTA) |
Parameter
[3]
A28
Parameter name j
Units
[3]
A10
Units of result |
Value I
[3]
N
Numerical result with non-detected values set to 1
sample quantitation limit [4] 1
Value2
[3]
N
Numerical result with non-detected values set to B
0 or 1/2 quantitation limit |
Qualifier
[3]
A6
Data qualifier |
QA Comment
qa_comment
A10
Quality Assurance comment code see
/»HAS£2\QUALIFY
Validated
[3]
A3
Field denoting if results have been validated
(Yes/No)
[1] A: the meter field with number denoting itu of field
D:
-------
Table 3-81
Data Dictionary for Tables PCBSD, PCBINVD, PCBFISHD in PHASE2\ECO Subdirectory
Field Name
Paradox
Field Name
FoxPro
Field Type [1]
1
Description
TAMS ID
tam»_id
All
Sample identifier
TAMS Type
tams_type
A3
Sample type [2]
Species
[3]
A4
Contained in PCBINVD and PCBFISHD only
Matrix
[3]
A8-A10
Sample matrix (SED. BIOTA) ||
Parameter
[3J
A28
Parameter name |
Units
[3]
A10
Units of result |
Value
[3]
N
Numerical result with non-detected values set to |
sample quantitation limit; PCBINVD contains It
Valuel and Va)ue2 ||
Qualifier
[3]
A6-A10
Data qualifier |
QA Comment
qa_commenC
A10
Quality Assurance comment code see 1
Pft4S£2\QUALIFY |
Validated
[3]
A3
Field denoting if results have been validated |
(Yes/No) |
[I] A: character Held with number denoting size of field
D: fete field
N: number field
M: memo field
[7\ B; Field bhrk
D: Duplicate ample
[3] Suae m Paradox
TAMS/Gradient
-------
Table 3-82
Data Dictionary for Tables NONPCBB, NONPCBBD, NONPCBS, NONPCBSD, LASERGS,
LASERGSD in PHASE2\ECO Subdirectory
Field Name
Paradox
TAMS ID
Field Name
FoxPro
Field Type [1]
Description |
tams_id
All
Sample identifier |
TAMS Type
tamitypc
A3
Sample type [2]
Specie*
13]
A4
Specie* code (not present in NONPCBS,
NONPCBSD or LASERGS)
SAS No.
sa*_nox
A8
Sample identifier for laboratory program
Split
[3]
A10
Field denoting if record represent* a
compoiite of duplicate analyses (Avg-FC -
average of field co-locates) in NONPCBB
or NONPCBS; non-blank entry in
NONPCBBD or NONPCBSD represents a
laboratory duplicate anlaysi*
Laboratory
[3]
A10
Name of laboratory performing analysis
SDG No.
sdg_nox
A12
Sample delivery group (for data validation)
Parameter
[3]
A30
Parameter name
Unit*
[3]
A10
Units of result
Value
[3]
N
Numerical result with non-detected values
set to sample detection limit
Qualifier
[3]
A4
Data qualifier
Validated
[3]
A4
Field denoting if results have been validated
(Yes/No)
[1] A: "i i fiaM wid> number t sizs of field
D:*MfnU
N: wmitur fuM
M: nmTaU
[2] B: FmU kink
D: Dufbma wnyli
[3] Swahnta
TAMS/Gradient
-------
Table 3-83
Data Dictionary for Table FB in PHASE2/ECO Subdirectory
Field Name
| Paradox
Field Name
FoxPro
tan»_id
Field Type [1]
Description {
| TAMS ID
All
Sample identifier H
TAMS Type
tam*_type
A3
Sample type [2] f
SAS No.
aa*_nox
A8
Sample identifier for laboratory program |
Split
[3]
A10
Non-blank entry denote* a laboratory duplicate
or split (ample
j
Laboratory
[31
A10
Name of laboratory performing analyiii
SDO No.
«dg_nox
A12
Sample delivery group (for data validation)
Parameter
[3]
A30
Parameter name |
Value
[3]
N
Numerical result with non-detected valuea set to
(ample detection limit
| Qualifier
[3]
A4
Data qualifier
(1] A: < ir fi«U
MtawMl
PI B: F«U W
D: Dufli.n can
P] Sw m Pi mint
TAMS {Gradient
-------
Table 3-84
Data Dictionary for Table SPECIES in PHASE21ECO Subdirectory
1 Field Name
Field Name
Field Type
Description
1 Paradox
FoxPro
| Specks
m
AS
Species code
| Definition
m
A20
Definition of species code
(1J As rtiitf tUH vtk m»l»r limiiiin «• Mi
D: fWU
H: aoakar (kU
MawfUl
J2J Jhns^ n
TAMS/Gradient
-------
TABLE 3-85
Tables in PHASE2\HRC0RES Subdirectory
Tables in PHASE2\HRCORES
Table Name
1
Description
STATIONS
Confirmatory Sampling and High-Resolution Sediment Coring Program sampling stations
PCBS
PCB congeners/homologue sums/Aroclor sums - sediment samples (pg/Kg DW)
NONPCBS
Non-PCB data - sediment samples
LASERGS
Laser grain size Phi classes j
RADNUC
Radionuclide data - sediment samples
SEDDESC
Redox, density and additional field information
GROUPS
Sample groupings
Tables in PHASE2\HRCORES\QA_QC
Table Name
Description |
FS
Non-PCB data - field blanks |
LASERGSD
Laser grain size Phi classes • duplicate pairs
NONPCBSD
Non-PCB data - duplicate sediment sample pairs
PC BSD
PCB congeners - duplicate sediment sample pairs 0
-------
TABLE 3-86
Data Dictionary for Table STATIONS in PHASE2\HRCORES Subdirectory
Field Name
Paradox
Field Name
FoxPro
Field Type [1]
Description
Station
[2]
A8
Station number
TAMS ID
tams_id
All
Sample identifier
TAMS SampType
tams_type
A3
Sample type [3]
Date Sampled
date_sampl
D
Date sample was taken
Time Sampled
time_sampl
A10
Time sample was taken
Lower Depth (cm)
lower_dept
N
Depth of top of sediment slice (cm)
Upper Depth (cm)
upper_dept
N
Depth of bottom of sediment slice (cm)
River Mile
river_mile
N
River mile measured from the Battery
Est Easting
[21
N
Estimated NY State Plane easting (it)
Est Northing
[2]
N
Estimated NY State Plane northing (ft)
Location
[2]
A30
Station description
Program
[21
A3
Program abbreviation (HR) [4]
SAS No.
sas_nox
A10
Sample identifier for laboratory program
Comment
[21
A120
Sample comment
(1] A: chancier field with number be noting size of Held
D:
-------
TABLE 3-87
Data Dictionary for Table GROUPS In PHASE2\HRCORES Subdirectory
Field Name
Field Name
Field Type [1]
Description
Paradox
FoxPro
Station
12]
AS
Station number |
Group
[2]
A25
Group identifier [
[l] A: AiiTWr tmU wMk pimhw m* of fiaid
O-.imMi
KaohrM
MaotfaM
I2J hail
TAMS/Gradient
-------
TABLE 3-88
Data Dictionary for Table PCBS in PHASE2\HRCORES Subdirectory
Field Name
Paradox
Field Name
FoxPro
Field Type [1]
Description
TAMS ID
tams_id
All
Sample identifier
TAMS Type
tamstype
A3
Sample type [2]
Split
[3]
A10
Field denoting if record represents a composite of
duplicate analyses (Avg-FC - average of field co-
locates)
Matrix
13]
A8
Sample matrix (SED) |
Parameter
[3]
A28
Parameter name |
Units
[3]
A10
Units of result |
Value 1
[3]
N
Numerical result with non-detected values set to II
sample quantitation limit [4] ||
Value2
[3]
N
Numerical result with non-detected values set to 0 g
or 1/2 quantitation limit |
Qualifier
[3]
A5
Data qualifier f|
QA Comment
qa_comment
A10
Quality Assurance comment code see |
PH/4SE2\QUALIFY |
Validated
[3]
A3
Field denoting if results have been validated 1
(Yes/No) |
(1] A: character field wife dumber denoting itee of field
D:deto field
N: number field
M: maw field
(2] A: Archive core
B: Field bhdt
D: Duplicate core
0: Graia size core
M: Matrix «pike mapie or con
P: PCB core
X: X-Ray oore
(3] Suae m Paradox
(4] Honotogue •uim and Totel PCB* vmKm myiuecm raw of delected value* only.
TAMS/Gradient
-------
Table 3-89
Data Dictionary for Tables PCBSD in PHASE2\HRCORES Subdirectory
Field Name
Paradox
Field Name
FoxPro
Field Type [1]
Description |
1 TAMS ID
tamajd
All
Sample identifier |
| TAMS Type
tams_type
A3
Sample type (2] |
| Split
[3]
A10
Field denoting if record represent* a composite of g
duplicate analyse* (Avg-FC average of field co- 1
locate*) |
| Matrix
[31
A8
Sample matrix (SED) |
] Parameter
[3]
A28
Parameter name
Umti
[3]
A10
Units of result
Value
[3]
N
Numerical result with non-detected values set to 1
sample detection limit
Qualifier
[3]
AS
Data qualifier
Validated
[3]
A3
Field denoting if results have been validated
(Yes/No)
[1] A: cfauacttr fiaM wi& oumbar 11 — *"1 tixe of fleid
D: T»U
N:imufc11
M: bow
(2] A: Arcfem om
B: FmU kU
D: DfiaM cot*
0: Onii liuein
M: kteix MiTipU or eon
P: PCB can
X: X-Rjry eon
PI Sum ¦ P»r*dn«
TAMS/Grodient
-------
Table 3-90
Data Dictionary for Tables NONPCBS, NONPCBSD, LASERGS, LASERGSD in
PHASE2/HRCORES Subdirectory
Field Name
Paradox
Field Name
FoxPro
Field Type [1]
Description
TAMS ID
tama_id
All
Sample identifier |
TAMS Type
tam«_type
A3
Sample type [2] |
SAS No.
«aa_nox
A8
Sample identifier for laboratory program
Split
[3]
A10
Field denoting if record represent! a
composite of duplicate analyses (Avg-FC -
average of Held co-locatea) in NONPCBS;
non-blank entry in NONPCBSD represent* a
laboratory duplicate anlaysis |
Laboratory
[3]
A10
Name of laboratory performing analysis ||
SDG No.
»dg_nox
A12
Sample delivery group (for data validation) J
Parameter
[3]
A30
Parameter name |
Unita
[3]
A10
Units of result ||
Value
[3]
N
Numerical result with non-detected values set 1
to sample detection limit |
Qualifier
[3]
A4
Data qualifier
Validated
13]
A4
Field denoting if results have been validated
(Yes/No)
[1] At cfemcttr Utii niimtir 4aMinf liu of field
N: iwito finM
M: muDO Md
[2] A: ArcWv* oor»
B: FWlkU
D: Di^liiti eon
G: Ormki liza oon
M: Matrix tfia aapb or oat*
P: FCB eon
X: X-Ragr etn
[3] taahnla
T AMS/Gradient
-------
Table 3-91
Data Dictionary for Table FB in PHASE2\HRCORES Subdirectory
1 Field Name
Paradox
Field Name
FoxPro
Field Type [1]
Description
TAMSID
tama_id
All
Sample identifier
TAMS Type
tama_type
A3
Sample type [2]
SAS No.
«ai_nox
A8
Sample identifier for laboratory program
Split
[3]
A10
Non-blank entry denote* a laboratory duplicate or
iplit sample
Laboratory
[3]
A10
1
Name of laboratory performing analyiis
SDQ No.
*dg_nox
A12
Sample delivery group (for data validation)
Parameter
[3]
A30
Parameter name
Unit*
13]
A10
Unit* of result
Value
[3]
N
Numerical reault with non-detected value* set to E
(ample detection limit j
Qualifier
[3]
A3
Data qualifier (
[1] A: rlmmr fmU Mh aumkar Anting mat Mi
thimMi
N: ¦¦rtir Mi
M: mm f»U
[2] A: Aictum ooro
B: FmU fcMc
D: liif oar*
G: Om hh oon
M: KMx aoapk or oor«
P: PCBom
X: X*Rqr oon
[3] fern* m Pmta
TAMS/Gradi
-------
Data Dictionary
Table 3-92
for Tables RADNUC, RADNUCD
in PHASE2\HRCORES Subdirectory
I Field Name
Paradox
Field Name
FoxPro
tams_id
Field Type [1]
Description
TAMS ID
All
Sample identifier
TAMS Type
tamsjype
A3
Sample type [21
Split
[3]
A4
Non-blank entry denote* a laboratory duplicate or H
split sample |
Laboratory
[3]
A10
Name of laboratory performing analysis |
SDG No.
sdg_nox
AS
Sample delivery group (for data validation)
Date Sampled
date_iampl
D
Sample date |
Counting Date
counting_d
D
Date sample was counted |
Detector
[31
All
Detector type |
Parameter
[3]
A30
Parameter name
Unit*
[31
A10
Units of result
Sigma
[31
N
Standard deviation associated with counting result
Value
[31
N
Numerical result with non-detected values set to 1
sample quantitation limit |
Det Limit
det_limit
N
Reported counter detector limit
Qualifier
[31
A3
Data qualifier
Validated
[31
A4
Field denoting if results have been validated
(Yes/No)
[1] A: ihsmm field »iA auaber
-------
Table 3-93
Data Dictionary for Table SEDDESC in PHASE2\HRCORES Subdirectory
Field Name
Paradox
TAMS ID
Field Name
FoxPro
Field Type [1]
Description
tams_id
A13
Sample identifier
TAMS Type
tams_type
A3
Sample type [2]
PH
[3]
N
Measured sediment porewater pH
Eh
[31
N
Sediment porewater redox potential in meV
1 Temperature
temperatur
N
Temperature of redox measurement in *C
Field Comment
fteld_comm
A50
Comments from field notes
Percent Solids
percent_so
N
Percent solids by dry weight
Bulk density (g/cc)
bulk_denii
N
Calculated bulk density in g/cc
Part, density (g/cc)
pait_densi
N
Calculated particle density in g/cc
[1] A: ihmrMr (mU with aumbw ilnmiin tiu o{ Mi
D: *tafiaU
N: umlur r«U
M: mo fl«U
[2] A: Aitkivi oaf*
B: Fwii kUc
D: DoffiaM eon
O: On itu ear*
M: Matrix tfik» wiiili or can
P: PCB can
X: X-Rar con
[3] S« x rute
TAMS/Gradient
-------
Table 3-94
Data Dictionary for Table FLOW93 in PHASE2\FLOW Subdirectory
Field Name
Paradox
Field Name
FoxPro
Field Type [1]
Description
Date
date
D
Measurement date
Fort Edward Meaa. Flow
fort_edwar
N
Repotted USGS flow at Fort Edward in eft
Stillwater Cak. Flow
(till water
N
Calculated flow at Stillwater in cf« [2]
Model-Still water
model_«til
A4
Model uied to calculate flow at Stillwater [2]
Waterfoid Calc. Flow
waterfordx
N
Calculated flow at Waterfoid in cf( [2] |
Model-Waterford
modelwate
A4
Model used to calculate flow at Waterford [2] f
[1] A: ihimr fiald with number ilwm«i| tiza of fwU
D: TmI4
N: turn/ft fiald
M: aaaofiald
(2] Tbaaa Aim wmn aodalkd baaed on the reported flow at Fort Edvard and tfaa Cbaaplaia Canal naff puto data cnrajnrd is W3Z>07\GAUGES.
Thaea nM will to explained is tfaa n>M2 Da)* Evahatfjai aad liunymalion Report.
TP^MS! Gradient
-------
Table 3-95
Tables in NOAA Directory
Tables in NOAA
Table Name
Description |
STATIONS
Ecological Survey stations |
COORDS
Coordinates for stations |
FISH
Sample composition information - fish
PCBFISH
PCB congeners/homologue sum/Aroclor concentrations - fish
NONPCBB
Non-PCB data - biota
SPECIES
Key to species code
Table in NOAA\QA_QC
Table Name
Description |
PCBF1SHD
PCB congeners - fish duplicate pairs/dilution analyses
TAMSI Gradient
-------
Table 3-96
Data Dictionary for Table STATIONS in NOAA Directory
Field Name
Paradox
Field Name
FoxProx
Field Type [1]
Description
Station
[2]
A8
Station number
TAMS ID
tams_id
All
Sample identifier
TAMS Type
tamstype
A4
Sample type [3]
Species
[2]
A4
Species code
Date Sampled
dalesampl
D
Sample date
Est Easting
est_eastin
N
Estimated NY State Plane easting (it)
Est Northing
est_northi
N
Estimated NY State Plane northing (ft)
River Mile
river_mile
N
Mile measured from the Battery g
Description
descriptio
A26
Station description
Program
[2]
A4
Program abbreviation (EC) [4]
SAS No.
sas_nox
AS
Sample identifier for laboratory program
Comment
[2]
A120
Sample comment |
[1] A: chanctor field with number deaotag *iz* of field
D:
-------
Table 3-97
Data Dictionary for Table COORDS in NOAA Directory
Field Name
Paradox
Station
Field Name
FoxPro
Field Type [1]
Description
[2]
A16
Station name
Hat Easting
est_eastin
N
Estimated NY atate plane easting (ft)
Eat Northing
e*t_noithi
N
Estimated NY state plane northing (ft)
Sample Type
•ampletyp
A23
Type of sample taken
Fish Type
fuh_typ
A18
Type of fish taken
[1) A: rh—nMr (WU tridi imaWr Moots* m of fi*U
DiAwfMd
N: ¦»¦>!> GM
M: w f-JJ
[2] Sbm •• Puaiox
T^MS! Gradient
-------
Table 3-98
Data Dictionary for Table FISH in NOAA Directory
Field Name
Paradox
Field Name
FoxPro
Field Type [1]
Description |
TAMS ID
tams_id
All
Sample identifier fl
TAMS Type
tams_type
A3
Sample type [2]
Species
T3]
A8
Species code
SAS No.
sainox
A8
Laboratory identifier
Noincomp
[3]
A3
Number of fish in composite
Length
(3]
N
Length in centimeters
Weight
[31
N
Weight in grams
Sex
[3]
A1
Sex I
[1] A: chancier field with number denoting size of field
O: dele fteM
N: number field
M: memo Held
[2J B: Field bin*
D: Duplicate «mpie
N: NOAA Mmple
[3] Seme u Paradox
TAMS/Grudient
-------
Table 3-99
Data Dictionary for Table PCBFISH in NOAA Directory
Field Name
Paradox
Field Name
FoxPro
Field Type [1]
Description
TAMS ID
tanu_id
All
Sample identifier
TAMS Type
tams_type
A3
Sample type [2]
Species
[3]
A4
Species code
Split
[3]
A10
Field denoting if record represents a composite of
duplicate analyses (Avg-FC - average of field co-
locates)
Matrix
[3]
A8
Sample matrix (SED, BIOTA)
Parameter
[3]
A28
Parameter name
Units
[31
A10
Units of result
Value I
[3]
N
Numerical result with non-detected values set to
sample quantitation limit [4]
Value2
[3]
N
Numerical result with non-detected values set to 0
or 1/2 quantitation limit
Qualifier
[3]
A6
Data qualifier
QA Comment
qa_comment
A10
Quality Assurance comment code see |
/>ft45£2\QUALIFY
Validated
[3]
A4
Field denoting if results have been validated
(Yes/No)
[1] A; character field wife number deooti&f uze of fieM
D: date Held
N: number field
M: memo field
[2] B: Field bkak
O: Duplicate cample
[3] Same m Pumdox
[4] Horaoiofoe cum and Tofel PCBi vaJuet rrpnnm turns of detected v&haee only.
JAMS! Gradient
-------
Table 3-100
Data Dictionary for Table PCBFISHD in NOAA Directory
Field Name
Paradox
Field Name
FoxPro
Field Type [1]
Description
TAMS ID
tarns id
All
Sample identifier
TAMS Type
tamstype
A4
Sample type [2]
Matrix
[3]
A8
Sample matrix (BIOTA)
Parameter
[3]
A28
Parameter name
Units
(3]
A10
Units of result
Species
[3]
A4
Species code; see SPECIES table for definition
of codes
Value
[3]
N
Numerical result with non-detected values set to
sample quantitation limit
Qualifier
[3]
A6
Data qualifier
QA Comment
qa_comment
A10
Quality Assurance comment code see
m4J£2\QUALIFY
[1] A: character field with number deaotiag toe of field
D: field
N: number Held
M: memo Held
[21 B: Field bki*
D: Dtzpticete ample
N: NOAA ample
P) Seme «c fendos
TAMS/Gradient
-------
Table 3-101
Data Dictionary for Tables NONPCBB in NOAA Directory
Field Name
Paradox
TAMSID
Field Name
FoxPro
Field Type [1]
Description
tam»_id
All
Sample identifier
TAMS Type
tama_type
A3
Sample type [2]
Specie*
[3]
A4
Specie* code
SAS No.
sa*_nox
A8
Sample identifier for laboratory program
Split
13]
A10
Field denoting if record repreaent* a composite of
duplicate analyses (Avg-FC - average of field co-
locate*)
Laboratory
[3]
A10
Name of laboratory performing analysis
SDG No.
sdg_nox
A12
Sample delivery group (for data validation)
Parameter
[3]
A 30
Parameter name
Unita
[3]
A4
Units of result
Value
[31
N
Numerical result with non-detected value* set to
sample detection limit
Qualifier
[31
A4
Data qualifier
Validated
[31
A4
Field denoting if results have been validated
(Yes/No)
[1] A: field with number n» of field
D:fetof»U
N: number Mi
M: umbo field
[2] B: Field blnk
D: DuplitH ¦ilflii
N: NOAA MmpJe
[3] Sum m hnta
TkMS! Gradient
-------
Table 3-102
Data Dictionary for Table SPECIES in NOAA Directory
Field Type [1] Description
Field Name
FoxPro
Field Name
Piradox
Definition of ipecie* code
Definition
T AMS/Gradient
-------
FIGURES
-------
Reassessment Database
GE
''Sediment \
Water I
^ Biota )
USGS
HISTORIC
( nysdecA
NYSDOH
V GE )
( FLOW
Discharge]
WQDATA
^ Water ^
Quality
FISH
~PED ^
I Sediment
LDEO
[Sediment |
^ Water I
MACROINV
(Macro- ^
invertebrates
PHASE2
SEDIMENT
Low-Resolution
Coring and
Confirmatory
Sampling
WATER
( Water ^
Column
Studies
V )
\
HRCORES
High-
Resolution
Coring
ECO
Ecological
Investigation
Legend:
NOAA
f Fish |
NYSDOT
f NYS ^
Champlain
Canal Guage
y Data
FLOW
1993 Discharge
USGS - Main Directory
WQDATA -Subdirectory
fNYSDEC ^
NYSDOT
V GE
- Directory contents description
T AMS/Gradient
Figure 2-1
Descriptive Diagram of the Hudson River PCB Reassessment Database
-------
USGS -Subdirectory nunc
BATKJDB -Filename
QA) -Section fa Databaae Report
Reassessment
Database
IDEO 01)
I
BOPP91-8.WX1
BQFPSS4.WK1
BOPP188.WX1
WAXREN.WK1
HISTORIC ai>
. HISr.UJTUB*
PARAMXEYDB
FISH
MACROIXV
SED
C0MP06X®
OONCOB
CONCSEDJ3B
OONCFISaOB
DOHSTTRDB
GES9DB
CORRNUMJDB
NUMHTOLDB
GRADNUMSUB
GRADNUMF.DB
OTHER!®
MASSFBCDB
PREPDB
SAMPLE!®
NONCHEMJDB
REFJ3B
SAMFREPJ3B
NONDHTSDB
SAMPLEFJ3B
SPECCODBX®
REACHES X>B
SPBCCCJDEJ5B
KEF.DB
SAMPLES!®
SECTION!®
SaXHDUPDB
STATIONS J)B
TEXTURES .DB
I
NYSDOT Q.4)
GAUGES.DB
-DBCLAIM/IXr
USGS 02)
-USGSJ.UTDB*
PXOW
BATKDB
OOMNTHJDB
PTEDWDXi
GREEN DB
HADLEYJ7B
HOQ6.JB
MOKKDB
SACANDJDB
SCHUJDB
SITLLDB
USGS7693UB
WATR-DB
I
WQDATA
TOCDATJ3B
USGSWQDB
GE 03)
I
HBLDJ.Uri»'
GBPARAMSJJB*
PCBJJJTX>B"
NONPCB.DB
PCBJ3B
PCBCONGUB
PCBHOMOUDB
SAMFL&DB
SPECGODBUB
NOAA* a«
PHASE 2 OS)
AROCLSTDUB (27)
ASCREEN.DB (2.7)
CONG_LUTX)B*
FIELDS!®*
PAXAMSDB*
QUAUFYJ7B*
COOKDSDB
F1SHDB
NONPCBBJDB
PCXFBHOB
SPBdBSBB
STATIONS!®
QAJ2C
tCSFlSHDJOt
SEDIMENT
WATER
LASERG&DB
LIUNFO.DB
NONPCBSDB
PCBSDB
XADNUCDB
SEDDESCDB
SIEVEG&OB
STATIONS!®
I
QAJQC
FBDB
LASEXGSDDB
NONPCBSDDB
PCBSDX«
RADNUCDUB
SIEVBGSD.Di
GROUPS!®
NONPCBWDB
PCBFA7J3B
PCBPXIB
PCBWDB
STATIONS!®
VOLUMES!®
1
QA^QC
FBJ3B
NONPCBWDDB
PCBPDXJB
PCBWDDB
PCBWTTUB
HRCOSES
GROUPS!®
LASERGSDB
NONPCBSDB
PCBSDB
RADNUCJ3B
I
(MJ2C
PBDB
LASERGSD!®
NONPCBSDDB
PCBSDDB
RAX3NUCDUB
FLOW
FLOW93UB
ECO
3 STATIONS!®
EQiniJB
PCBFEDB
PCBWEJ5B
1. aubdbectoay contain* data from NYSDECNY3DOH and GE.
2. LowReaolutiiaCaringnraltaaranot yatandBabie.
They will be included fa tfalaaubdlnctny whennkaaed.
3. Theie laaolti an not yet available. fl»ey will be included fa the final
4. See the Phaae 2 glnaaailia.
* TSeae file* inynamt the databaae glo«**rie* and provide definition* of
field* and paiameto* contafaed fa the cORMpcnding directorial
Tnirri T*i ¦!»!Mini n[ Tlilil m
BENTH1CDB
axaaxm
FISH!®
GROUPS!®
LASHRGS.DB
NONPCBBUB
NONPCBS.DB
PCBFISH!®
PCBINVJ3B
PCBSUB
spprroPB
STATIONS!®
1
QAJ2C
FBUB
LASEXGSDDB
NONFCBBDJ3B
NONPCBSDJB
PCBPISHDUB
FCBZNVDJ3S
PCTSDDB
TAMSIOradtat
Figure 2-2
Detailed Structure of the Hudson River PCB Reassessment Database
-------
Figure 2-3
USGS Monitoring Sites in
the Upper Hudson
warren county
01325000
Sacmdaga River 01318500
at Stewarts Bridge f-^iMHadley
' / / c"^
220-
01325420 \
Corinth V\
SARATOGA COUNTY
01327755
Rogers Island
I Ct«nt
Ci«OJ
01327750
'ZT'L-AJ/ Ft Edward
Tori Ethrani
01328730
Near Ft MSIer
V
WASHINGTON
COUNTY
,1 /tlo?J2965o/
l y «* 4, Schnyiervm v"~
¦ *«o
r
LEGEND
100
_ OtJJSW
¦ mterford
m 0UIS500
™ Ho*«y
~01J54000
€rmtm hUant
RIVER MILE
WATER QUAUTY/PCB
SURFACE WATER DISCHARGE
BOTH SURFACE WATER DISCHARGE
AND WATER QUALITY/PCS
01331095
Stillwater
SUil*i»i«r
RENSSELAER COUNTY
V>X V
<•* v
ALBANY CO
«*urxortf
_xy 01335754
^^RAiwv* Lock I near Woterford
SOURCES: 1.
Wogrier, 1980
Reassessment Database
'01335770
Woterford
7pof s
01357500
i Mohawk
01358000
Green Island
kmc i mr
TAMS / Gradient
-------
Figure 2-4
NYSDEC 1976-78 Sediment
Sampling Locations
i Glens Falls
200
.Hudfeon Falls
South
Glen^ Falls
Fort Edward
170
echanicWle (/
\o
"j)
160
Waterford
LEGEND
180
Troy
190
RIVER MILE
Cohoes
CORE
GRAB
SCALE IN FEET
SOURCES: t- To(H«n%
-------
Figure 2-5
1984 Thompson Island Pool
Sediment Sampling Locations
LEGEND
190
RIVER MILE
CORE
GRAB
SCALE IN fEET
SOURCES 1. Bto«a «t d . 1988
? Rratiessmctt OalatOM
TAMS / Gradient
-------
7»*
UPPER HUDSON BASIN
.43*
MOHAWK BASIN
. 42*
LOWER HUDSON
BASIN
. 4t«
VER.
UTIC4
MASS.
KINGS"
POUGHKCCrSIE
BCACO
! Float, Hudson Fall*
2 Floac, Ft. Edvaro
3b Buoy 228, Ft. EdwarS
4 Buoy 219, Ft, Ednars
5 Buoy 189, Ft. Miliar
6 Buoy 148, Schuy Itrvillt
7 Buoy 81. Stillwater
8 Buoy 13, Wattrfora
9 Buoy 79, troy
9* Float, Troy
10 Buoy $5, Caatlftoo
11 Suoy 84, Hudaon/Athtns
12 Suoy 39, Saugtrti**
13 Buoy 9, Esopus
Diamond Reef Buoy,
N«w Haaburt
Suoy 19, Fttkskill
'6 Buoy 5, Nyaek
HUDSON RIVER
BASIN
new ro»* arr
Figure 2-6
NYSDOH Macroinvertebrate Sampling Sites, Hudson River, 1978-1985
Source: Novak, et at., 1988
7 AMSI Gradient
-------
Figure 2-7
1990 GE Sediment
Sampling Locations
220
210
«0
«0
in
o>
170
o
LEGEND
100
RIVER UL£
co
CORE
u.
00
SCALE M FECT
SOURCES: 1. O'Brien and Core. 1993.
2. Reassessment Database
TAMS / Gradient
-------
Figure 2-8
1991 GE Sediment
Sampling Locations
220
210
SO
wo
ID
O
170
GO
r*l
LEGEND
100
RIVER MIX
CO
SINGH CORE
GO
ALBANY CO
scms m feet
SOURCES: 1. O'Brien and Gere. 1993.
2. Reassessment Ootobose
TAMS / Gradient
-------
Figure 2-9
1991 GE Water Column
Sampling Locations
220
2*3
SO
o>
170
LEGEND
100
RIVER HUE
oo
STATION
u.
00
ALBANY CO
se*£ m mi
z
SOURCES: 1. O'Brwn and G«re, 1993.
2. Reassessment Database
TAMS / Gradient
-------
Figure 2-10
1992 GE Water Column
Sampling locations
220
2)0
wo-
rn
in
o>
170
CO
LEGEND
too
x
QO
STATION
Troy^
00
AL3AKY CO
schx m mi
SOURCES: 1, O'Brien and Gere. 1991
2. Reassessment Ootobose
TAMS / Gradient
W
-------
Figure 2-11
1993 GE Water Column
Sampling Locations
l Gfena rum
i 200
220
2»
WO
«0
LEGEND
RIVER MUX
100
00
STATION
u.
ALBANY CO
SC«t* m rur
SOURCES: 1. O'Brien and Gere. 1993.
2. Reassessment Database
TAMS / Gradient
-------
Figure 2-12
1994 GE Water Column
Sampling Locations
Fort S4*«rd
220
2»
SO
T70
00
LEGEND
100
RIVER MILE
x
03
STATION
Troy ^
CO
ALBANY CO
scau: m fee?
SOURCES: t. CE. 1994.
2. Reassessment Oatotwse
TAMS / Gradient
U_
-------
f.l« He.; *8 / rumemt: nst-13«d«<» / Oo>« 2-H-9S / »»«r: MC
Figure 2-13A
Phase 2 Water Column Sampling Stations
in the Upper Hudson (1993)
Sufcwn r»u* /
f-f FENIMORE BRIDGE (RM 197.6)
<2? STATION 2
LOCK 7 (RM 193.7}
STATION 10
n«»ra» BUM) MM (KM IM S)
SCHUUERWttf (RM 181.3)
STATION e
GLENS FALLS (RM 199.5)
STATION 1
H#di«y
\ Gi«m f*U*
Glon» Foils
Fort Cdvars
C«rit*h Oam
5c* Foil
Dam
REMNANT DEPOSITS
(RM 195.5)
STATION 3
ROGERS ISLAND
(RM 194.6) - STATION 4
THOMPSON ISLAND 0AM
(RM 188.5) - STATION 5
fWI K1UZH DAM CRM IMS)
BATTEN KILL
STATION 11
KosrmniMMJura mm (m iku)
LEGEND
hujrt«rrjll«
RIVER MILE
WATER-COLUMN
SAMPLING STATION
STILLWATER (RM 168.3) - STATION 7
SUIhfcUr
SriUXHZK DAK (M IHil
HOOSIC RIVER
STATION 12
LOCK 3 MM (RM IMO)
M«ch*oMiHe
o one
wac 2 DAM (RM 1(3 »
IOC* 1 DAM (KM 111 ()
Vat*rfcri!
Tpojr
I
I
/
rCMRAl. DAM (RM IMS)
Cohew
MEGHANICVILLE (RM 165.4) - STATION 19
LOCK 2 (RM 163.5) - STATION 26
MOHAWK RIVER - STATION 13
SOURCE BiewwKMBt OalabOM
m>£>g>24o&8
WATERFORD (RM 156.5) - STATION 8
GREEN ISLAND BRIDGE (RM 151.7) - STATION 14
TAMS / Gradient
-------
fit Ho.: 48 / Fa«nom«: f>C2-l.3b d«q / Dot* 2-13-95 / U»«r MC
Figure 2-13B
Phase 2 Water Column Sampling Stations
in the Lower Hudson (1993)
COXSACKIE (RM 125)
STATION 15
CEMENTON (RM 110)
STATION 16
HIGHLAND (RM 77.0) -
STATION 17
ALBANY
rronua. dam (rm im »)
¦* - ¦ „ GREEN ISLAND
lr y BRIOGE (RM 151.7)
STATION 14
LEGEND
190 RIVER MILE Newark
WATER-COLUMN
SAMPLING STATION
CaUkul
r> Winkle
Brid9«
/
* U Kinaston—Rhin»cliff
Bri
Klnfston
Poufhkeepsie
Newburqh-
Beocon
Bnd9«
B«or Mountain
Bridoe
Toppon Z««
B'idoe
Yonkcrs
G«org* Woshmoto
Br»dge
NEW YORK
CITY
? Thf 0ott«ry
7 3.S 0 7 MIES
SOURCE Dot aft ax
TAMS / Gradient
-------
Figure 2-14
Phase 2 High Flow Suspended Solids Monitoring Stations
(1994)
Hadley
FENIMORE BRIDGE - STATION 2
THOMPSON ISLAND POOL AT
Mcdonald dock - station 25
220
210
MOSES KILL - STATION 24
ROGERS ISLAND - STATION 4
WO
THOMPSON ISLANn POOL ABOVE
SNOOK KILL - S.ATION 22
SNOOK KILL - S1" ,10N 23
THOMPSON BUND DAM (RM IMS)
THOMPSC*' ISLAND DAM -
STATION b
LOCK 5 BRIDGE - STATION 20
DPT WUB> DAM (RM IM.2)
BATTEN KILL - STATION 11
NORTHUMBERLAND DAK (RM 1S3.4)
180
SCHUYLERVIUE - STATION 6
COVEVILLE - STATION 21
LEGEND
RIVER ROAD NEAR COVEVILLE -
STATION 40
190
RIVER MILE
SUSPENDED SOLIDS
SAMPLING STATION
STILLWATER - STATION 7
170
Smur«TOt DAK
MECHANICMLLE - STATION 19
LOCK I CAM (RM 1S» «)
WATERFORD - STATION 8
Troy
O
fTOCRAL DAM (RM 153.9)
MOHAWK RIVER - STATION 13
GREEN ISLAND BRIDGE - STATION 14
SOUfiCt R.0M4MXW! OotabeM
TAMS / Gradient
-------
Figure 2-15
Phase 2 Confirmatory Sediment
Sampling Locations (1992)
Hudson Falls
South
Glens Falls
Fort Edward
LEGEND
RIVER MILE
CORE
GRAB
SCALE IN FEET
XM>Ul MMMtanonl DatabOM
TAMS / Gradient
fiwoozm
-------
Figure 2-16A
Phase 2 High Resolution Coring Sites
in the Upper Hudson (1992)
CORE 27 (RM 202.9)
CORE 28 (RM 197.1)
CORE 26 (RM 194.1E)
220
210
CORE 20 (RM 191.2)
SO
CORE 25 (RM 194.2W)
CORE 23 (RM 189.3)
CORE 19 (RM 183.5)
THOMPSON ISLAND DAM (KM .«.S)
LOCK 8
CORE 1 j (RM 105.8)
PORT XlUXft DAM (RM 1863!
#OmwmZKU&0 DAM CBM 1W.41
LOCK 5
CORE 17 vJATTEN KIU.)
CORE 21 ANO CORE 22
(RM 177.8)
LEGEND
190
HIGH-RESOLUTION
SEDIMENT CORE
SAMPLING LOCATION
TO
LOCK 4
CORE 24 (HOOSC RIVER)
snufftfCft Dam
-------
Figure 2-16B
Phase 2 High Resolution Coring Sites
in the Lower Hudson (1992)
Troy
150
ALBANY
CORE 11 (RM 143.5)
125
CORE 14 (RM 124.1)
Catskill
Rip Vbn Winkle
Bridge
-100
CORE 13 (RM 99.2)
Kinoston-RhinecMf
Bridge
Kingston
CORE 10 (RM 88.5)
LEGEND
Newburgh-
Beocon t
Bridge |
190
RIVER MILE
CORE 9
(RM 59.6)
CORE 8
(RM 54.0)
HIGH-RESOLUTION
SEDIMENT CORE
SAMPLING LOCATION
pr.ii Moor
Bridge
CORE 6 AND
CORE 7
(RM 43.2)
JToppon Zee
[Bridge
CORE 1 (RM 25.0)
¦85-
George Woshmgton
Bridge;
CORE 5 (NEWTOWN CREEK)
CORE 4 (RM 2.4)
CORE 2 (RM -1.9) AND
CORE 3 (RM -2.2)
Newark
NEW YORK
CITY
7 KIXS
The Bottery
SOURCE: Rfowetsment OtfeboM
TAMS / Gradient
-------
Figure 2-17A
Phase 2 Low Resolution Sediment Coring
Locations (1994)
Fort Edward
HOT SPOT 5
HOT SPOT 6
HOT SPOT 7
HOT SPOT 8
HOT SPOT 11
HOT SPOT 10
HOT SPOT
HOT SPOT
HOT SPOT 14
190
HOT SPOT 16
HOT SPOT 15
HOT SPOT 17
HOT SPOT
HOT SPOT
HOT SPOT 20
HOT SPOT 22
HOT SPOT 21
HOT SPOT 23
HOT SPOT 24
HOT SPOT 25\
HOT SPOT 27
LEGEND H0T SP0T 26
190
HOT SPOT 28
CORE
NYSDEC HOT SPOT
HOT SPOT 29
SCAt£ IN F££T
SOURCE OotfltaM
TAMS / Gradient
-------
Figure 2-17B
Phase 2 Low Resolution Sediment Coring
Locations (1994)
HOT SPOT "3U1
HOT SPOT 32
HOT SPOT 31
HOT SPOT 33
HOT SPOT 35
HOT SPOT 34
chuylerville
LEGEND
RIVER MILE
190
CORE
NYSDEC HOT SPOT
SCAL£ IN FEET
TAMS / Grtdient
-------
Figure 2—17C
Phase 2 Low Resolution Sediment Coring
Locations (1994)
LEGEND
190
RIVER MILE
NYSDEC HOT SPOT
170
— HOT SPOT 36
Stillwater
HOT SPOT 36
SCALE IN FEET
TAMS / Gradient
-------
Tilt No.-. 48 / Filename: nC2-17ddwq / Dote 8-15-95 / User: MC
Figure 2-17D
Phase 2 Low Resolution Sediment Coring
Locations (1994)
Mechanic^ille
HOT SPOT 38
LEGEND
190
RIVER MILE
CORE
NYSDEC HOT SPOT
HOT SPOT 39
HOT SPOT 40
Waterford
3000 9000
SCALE IN FEET
SOURCE: R«otmsmrii Oetobo**
&b±. M>i7 —
TAMS / Gradient
-------
Figure 2-18A
Phase 2 Ecological Sampling Sites
in the Upper Hudson (1993)
Ft 111
ECO—STATION 1A (RM 203.3)
ECO—STATION 20 (RM 196.9)
ECO—STATION IB (RM 203.6)
ECO—STATION 1C (RM 204.7)
ECO—STATION 2 (RM 194.1)
220
LOCK 7
- EC0-STAT10N 3 (RM 191.5)
- ECO—STATION 4A (RM 190.3)
ECO—STATION 48 (RM 190.0)
ECO—STATION 4C (RM 189.6)
80
ECO—STATION 5 (RM 189.0]
ECO—STATION 7 (RM 188.5;
ECO—STATION 6 (RM 188.7)
THOMPSON ISLAND
(RM tags)
OHM (im 1M2)
NORTHUMBERLAND DAM (RM 1134)
LOCK 9
LEGEND
190
RIVER MILE
ECOLOGICAL SAMPLING LOCATION
170
ECO-STATION 8A (RM 169.5)
ECO—STATION 8B (RM 169.2)
LOCK 4
TTTLLVATCK DAM (RM 1M-2)
LOCK 3 DAM (RM IM O)
LOCK 2 0AM (RM 103 9)
LOCK 1 0AM
-------
Figure 2-18B
Phase 2 Ecological Sampling Sites
in the
Lower Hudson (1993)
Troy
ALBANY
ECO-STATION 10 (RM 143.5)
ECO—STATION 11A (RM 137.2)
ECO—STATION 11B (RM 136.7)
125
ECO—STATION 12A (RM 122.7]
ECO—STATION 12B (RM 122.4*
ECO-STATION 13 (RM 113.8)
Catsklll
Bridge
ECO—STATION H (RM 100.0)
jston-Rhinecliff
Fridge
Kingston
ECO—STATION ISA (RM 89.4)
ECO-STATION 15B (RM 88.9)
ECO—STATION 16 (RM 58.7)
LEGEND
ECO-STATION 17 (RM 47.3)
Beor Mountoin
Bridge
190
RIVER MILE
ECOLOGICAL SAMPLING
LOCATION
ECO-STATION 18 (RM 25.8)
Yonkers
George Woshington
8 r»dge/
Newark
NEW YORK
CITY
K
SOURCE Rtosstvnfnt Dci«bc*e
TAMS / Gradient
-------
PCBS Table
TAliS 0
TAMS T)p«
Split
UoMk
Pvom*t«r
Units
VoHm 1
Volu* 2
Oudifier
QA Comment
VdktoM
—
HR-001-00002
P
SEP
BZ#8
M9/K9 »
9.25
925
J
CP
Yes
-
HR-OOt-00002
P
seo
82|22
now
809
809
J
G
Y«s
HR-001-00002
P
SCO
BZ|87
OW
6.64
664
J
CHS
T«
—
HR-001-00002
P
SED
B2#180
M9A9 0*
651
651
JN
CST
Yos
STATIONS Table
Station
TAliS 0
TAMS Type
Dote
Sampled
Low
Depth (cm)
Upp«
Depth (cm)
Est. Eosthq
(«)
Est. Northing
(D
River Ule
Locotion
Program
SAS No
Comments
HR-001
HR-001-0002
P
8-2J-92
0
2
6)8700
375750
25
Pwmont Marsh 12
HR
SB06I8
HR-OII
HR-011-0608
P
9-30-92
8
6
654600
952700
143 5
AJbony Turning Bosin
HR
S82143
HR-027
HR-027-I2I6
P
9-JO-92
16
12
676700
1200550
2029
Bock ground -
Bishop's Doc*
HR
SBI206
NONPCBS Table
TAUS 0
TAUS Type
SAS No.
SpKt
Laboratory
SOC. No.
Ptrameter
Units
Vdue
Oualirnr
Validated
HR-001-00002
P
SB0618
LDEO
19
TC
X
234
Yes
HR-001-00002
P
SB06I8
LOEO
19
TN
X
02
J
Y«s
HR-001-00002
P
SB06I8
LDEO
19
C/N
mdw
136
Yts
Figure 3-1
Examples of One-To Many Relationships from
PHASE2 \HRCORES Database Tables
TAMS/ Gradient
-------
STATIONS
GRADNUMS
GE89
SAMPLES
SECTION
CONCSED
MASSPEC
NONCHEM
SOXHDUP
REF
REACHES
NONDETS
PARAMKEY
HIST_LUT
Figure 3-2
Database Tables in HISTORIC \SED Subdirectory
* In HISTORIC directory - contains information
... _ 11 : _ 11_ : _ j: i _
TAMC / t
-------
HIST_LUT
Q
(gradnumf)
^SAMPLEF^
COMPOS
CONCFISH
PARAMKEY
PREP
SPECCODE
Figure 3-3
Database Tables in HISTORIC \FISH Subdirectory
* In HISTORIC directory - contains information
TAMS / Kmr/ionf
-------
HIST_LUT *
SAMPLE
SAMPREF
OTHER
CONC
DOHSITF
Figure 3-4
Database Tables in HISTORIC \MACROINV Subdirectory
* In HISTORIC directory - contains information
«• ••• • j«... .1
TAMS/ Gradient
-------
FIELD _LUT
SAMPLE
SPECCODE
PCBHOMOL
NONPCB
PCB
PCBCONG
PCB_LUT
GEPARAMS
Figure 3-5
Database Tables in GE Directory
-------
QUALIFY
CONGLUT
FIELDS
PARAMS
( GROUPS ]
^STATIONS^
PCBW,
PCBP
pcbwd:
PCBPO
NONPCBW
VOLUMES
NONPCBWD
PCBWE
PCBPE
PCBFA7.
PCBWTT
Figure 3-6
Database Tables in PHASE2 \ WATER Subdirectory
* In PHASE2 directory - reference for information
.11 «;i._ ilu
" Files located in PHASE2\WATER\QA_QC subdirectory
I l.j ni!iono\ uitpM pnimtD XAMS/ CrfSdlGllt
-------
LRINFO
LASERGS
SEIVEGS
RADNUC
LASERGSD
SEIVEGSD
RADNUCD
STATIONS
QUALIFY
PARAMS
CONG_LUT
FIELDS
NONPCBS
PCBS
NONPCBSD
PCBSD
Figure 3-7
Database Tables in PHASE2 \SEDIMENT Subdirectory
In PHASES directory - reference for information
Files located in PHASE2\SEDJMENT\QA_QC subdirectory
TAMS / f2rs»Hif*nt
-------
} } 1
CONG_LUT
QUALIFY
FIELDS
PARAMS
STATIONS
COORDS
GROUPS
FISH,
SPECIES
BENTHIC.
SPECIES
NONPCBS
PCBS
PCBFISH
NONPCBB
PCBINV
LASERGS
NONPCBsS*
nonpcbb6*
LASERGSD
PCBFISHD
PCBINVD
PCBSD
Figure 3-8
Database Tables in PHASE2 \ECO Subdirectory
' in phase? HirprJ.nrv - reference for information ** Files located in PHASE2\ECO\QA_QC subdirectory
TAMS/ Gradient
-------
GROUPS
LASERGS
RADNUC
LASERGSD
RAONUCD
STATIONS
SEDDESC
NONPCBS
PCBS
NONPCBSD
FB
PCBSD
PARAMS
QUALIFY
CONG_LUT
FIELDS
Figure 3-9
Database Tables in PHASE2 \HRCORES Subdirectory
In PHASE2 directory - reference for information ** Files located in PHASE2\HRC0RES\QA_QC subdirectory
" - - - - TAMS/Gradient
-------
CONG_LUT
QUALIFY
FIELDS
PARAMS
STATIONS
GROUPS
COORDS
FISH
NONPCBB
PCBFISH
SPECIES
PCBFISHD
Figure 3-10
Database Tables in NOAA Directory
~ In PHASE2 directory - reference for information ** Files located in N0AA\QA_QC subdirectory
on nil files in this directory *** Files located in PHASE2\FCO subdirectory
-------
r
)
HRCORES\NONPCBS {Partial Listing)
TAMS ID
TAMSType
Parameter
Value
V
%
"C/N"
> n
T
PCBS (Partial LIsNn
~
e<
TAMS ID
TAMS Type
Parameter
Value!
\
Total PCBs
V Include field in answer
I '
.ink tables
TAMS/ Gradient
Figure 3-11
Table Links for Example Database Query 1
-------
A
HRCQRES\STAT1QNS (Partial Listing)
Station
: TAMISID
. tAMS Tfl>«
Lwver Depth (cm)
tipper Depth (tm)
V
V
HR-019
Criieria
TAMS ID
TAMS Type
Parameter
Value2
Not Like BZ
Include field in answer
Link tables TAMS/ Gradient
Figure 3-12
Tabic Links for Example Database Query 2
-------
/
/
/
WATER\STAT1QNS (P»rH»l LMng)
Trtnwct
Sultoa
tAMSli)
TAMS Type
River Mh
V
V
002
Criteria
TAMS ID
TAMS type
Parameter
V«lue2
V
BZ»! or B7*\l or B7.K27 or BZ#41 ot
BZ»M
V Include field in answer
i
Link tables
TAMS/ Gradient
Figure 3-13
Table Links for Example Database Query 3
------- |