The information on this page is provided to help viewers to better understand the data download from the SFEI Contaminant Data Download and Display tool, including the type of data available and how data are presented and handled by SFEI. If you have questions or comments, please contact [email protected].

Back to CD3

Table of Contents for CD3 Downloads

Matrix Definitions: provides definitions used to identify the test material and matrix

Qualifier Definitions: provides information that should be considered when interpreting test results.

Data can be downloaded with all qualifiers or with a subset of primary qualifiers.

Results-Cross tab: data provided in a cross tabulated Excel worksheet

Results-Flat file: data provided in a flat file Excel worksheet

Viewing results

A CD3 download is provided as an Excel file, within which are separate worksheets containing the results in cross-tabulated and flat file formats. The flat file format is especially suitable for import into other software platforms, such as Access or SAS, for further analyses. A key to matrix and qualifiers is also included.

All qualifiers or only the "primary" qualifiers may be selected for display in the CD3 download. Primary qualifiers are DO, DOXXX, ND, NR, NRS, NRT, R, and SL. The primary qualifier SL is used to identify a significant toxicity test, for more information on the specific statistical comparison(s) conducted use the "Show All Qualifiers" option.

Information for percent solids, percent moisture, and percent lipids are reported only in the flat file Excel worksheet.

Notes Specific to RMP Data

The results provided by CD3 may differ slightly from those previously reported in the RMP Annual Reports and static data tables, due in part to ongoing updates to the dataset, standardization of the qualifiers reported, changes in the handling of replicate samples, and changes in the method used to sum the dissolved and particulate water fractions.

Missing Data: Measurements vary by year and test material, but typically include a suite of contaminants (metals and organics) and ancillary data. Missing data are either not available (e.g., parameters were not measured in every year), or the data are being reanalyzed and will be made available at a later date. Missing data and changes in target RMP parameters are listed in the RMP Annual Monitoring Results reports.

SSC/TSS: Beginning in 2002, the water quality measurement total suspended solids (TSS) was replaced by the parameter suspended sediment concentration (SSC).
Organic Sums: Organic group sums, for example "Sum of PCBs (SFEI)", are calculated by SFEI based on the target analytes for an analyte group; the exact number and the group constituents may vary over the years.

Metal Data: All metals from 1993 to 2008 are reported as near totals. Beginning in 2009, water and tissue trace metals (Ag, Al, Cd, Cu, Fe, Pb, Mn, Ni, and Zn) are reported as total concentrations. Chemical analyses of sediment samples is generally performed on the <2mm fraction.

MDLs: While every effort is made to obtain the method detection limit (MDL) value from the labs, if none is available, other detection limits may be provided (e.g., instrument detection limit, sample detection...