The table below provides a CD3 data dictionary. The first two columns list the map download and data download fields, respectively. A value of NA indicates the field does not appear in the download.
Note: In the map download, each file will contain a subset of these columns depending on the test material selected. In the data download, all columns appear independent of the test material. If you have any questions, contact SFEI’s Data Services Team at [email protected].
Direct Download Field Name | Mapped Field Name | Definition |
---|---|---|
AgencyCode | sampleagency | Organization or agency that collected the sample. |
AlphaLevel | alphalevel | Predetermined statistical acceptance level that is not calculated, but is chosen by the laboratory when running the statistical method. |
AnalysisDate | analysisdate | Date the sample was processed on the analytical instrument. |
AnalyteCode | NA | Code representing the analyte or parameter. |
AnalyteGroup | analytegroup | General classification of analyte. |
AnalyteName | analyte | Analyte or parameter for which the analysis is conducted and result is reported. |
AnalyteSubgroup | analytesubgroup | Sub-classification of analyte. Note: Not all analytes have an associated sub-group. |
BatchVerificationCode | batchverification | Unique code, assigned by the QA Officer, referencing the verification of the batch. |
baysegment_name | NA | Name of San Francisco Bay segment where sample was collected. |
bValue | bvalue | Threshold for unacceptable toxicity or the Regulatory Management Decision (RMD) associated with hypothesis testing between the control and sample (for the EPA TST method). |
CalculatedValue | calculatedvalue | Statistic calculated from associated statistical method. |
CalcValueType | calcvaluetype | Type of statistical calculation, for example Probability or T value. |
CollectionDepth | collectiondepth | Depth or penetration from the surface in the water or sediment column, at which the sample was collected. |
CollectionDeviceName | collectiondevice | Collection device used to collect the sample. A collectiondevice of 'multiple values' indicates more than one unique collectiondevice value is reflected in the data. |
CollectionMethodCode | collectionmethod | General method of collection. A collectionmethod of 'multiple values' indicates more than one unique collectionmethod value is reflected in the data. |
CollectionReplicate | collectionreplicate | Used to distinguish between replicates created at a single collection in the field. |
CollectionTime | collectiontime | Time when the first sample of a sampling event at a specific station was collected in the field. Note: If using Excel, reformat column to time format to remove default date (1970-01-01) placed before time value. |
CommonName | commonname | Common name of organism. |
ComplianceCode | compliancecode | Code referencing the compliance with the associated Quality Assurance Project Plan (QAPP). |
CompositeID | compositeid | Unique identifier supplied by the compositing agency to identify the composited tissue parts. |
CompositeReplicate | compositereplicate | Used to distinguish between replicates of composited tissue parts. |
CompositeTissuePrep | compositetissueprep | Preparation or preservation method performed on the tissue sample prior to analysis. |
CompositeType | compositetype | Type of tissue composite. |
county_name | NA | Name of county where sample was collected. Some discrepancies may exist since the county is determined by a spatial intersect using target lat/longs. |
CriticalValue | criticalvalue | Derived critical value based on sample size and alpha value of the statistical test. The critical value is compared to the calculated value in the associated statistical test. |
DataUseNotes | datausenotes | Information relevant to using data for analysis. |
Datum | datum | Associated model of the Earth from which reference points are used to calculate position measurements. |
DigestExtractDate | digestextractdate | Date the digestion or extraction was started. |
DigestExtractMethod | digestextractmethod | Digestion or extraction method performed on the sample prior to analysis. |
DilFactor | dilution_df | Factor by which a sample was diluted and is reported as a whole number. It is equal to the final volume divided by the initial volume of solution, or DF = Vf ÷ Vi. If no dilution was performed, the value is '1'. |
EvalThreshold | evalthreshold | Programmatic level that is used to identify that an environmental sample is biologically significantly different from its associated control sample and is recorded as a percentage (evalthreshold is compared to the percenteffect field). |
ExpectedValue | expectedvalue | Concentration of the analyte in a reference standard, laboratory control sample or matrix spike sample or the value expected to obtain from analysis of the QC Sample. This consists of the native sample result concentration plus the spike amount. For surrogate samples, the expected value should be 100, representing 100%. |
FractionCode | NA | Code representing the specific analyte descriptor. |
FractionName | fraction | Specific descriptor of the analyte, such as Dissolved, Particulate, or Total. |
GrabSize | NA | Size of the grab used to collect the sample. |
huc10_name | NA | Name of hydrologic unit code (HUC) where sample was collected. Discrepancies may exist since the HUC 10 name is determined by a spatial intersect using target lat/longs. |
huc12_name | NA | Name of hydrologic unit code (HUC) where sample was collected. Discrepancies may exist since the HUC 12 name is determined by a spatial intersect using target lat/longs. |
huc8_name | NA | Name of hydrologic unit code (HUC) where sample was collected. Discrepancies may exist since the HUC 8 name is determined by a spatial intersect using target lat/longs. |
LabAgencyCode | labagency | Organization, agency or laboratory that performed the analysis on the sample. |
LabBatch | batch | Unique lab batch that represents a group of samples processed together. The batch groups all environmental samples with their supporting QC samples. |
LabBatchComments | batchcomments | Comments related to the lab batch as a whole, including any irregularities in sample processing. |
LabSampleID | labsampleid | Lab specific identification for an analyzed sample. |
LabSubmissionCode | labsubmissioncode | Batch qualifier code assigned to the lab batch as a whole by the analyzing laboratory. It references the quality of the data in the lab batch. |
Latitude | latitude | Latitude for the sample site in decimal degrees. |
LifeStage | NA | Stage of life of the organism, e.g., adult, juvenile, larva. |
LocationCode | locationcode | Physical location in the waterbody where the sample was collected. A locationcode of 'multiple values' indicates more than one unique locationcode value is reflected in the data. |
Longitude | longitude | Longitude for the sample site in decimal degrees. |
MatrixCode | NA | Code representing the sample matrix. |
MatrixName | matrix | Matrix of the sample. |
MDL | mdl | Method detection limit is the lowest possible detection limit associated with a given method and analyte. |
Mean | mean | Average result calculated from all replicates of a single sample. |
MethodName | method | Analysis method used by the laboratory to analyze the sample. |
MSD | msd | Minimum significant difference (MSD) is a measurement that can be produced for each statistical comparison performed between sample and control, or among multiple concentrations of a sample and control. It represents the smallest significant difference from the control and is unique for each statistical comparison. |
NA | sumtype | Number of congeners included in the pcbsum (e.g., PCB40, PCB208 or PCB209). |
NA | metadataurl | Url for metadata information. |
NA | pcbsum | Calculated sum of PCBs. This value may differ from sums of the results of the individual congeners due to variations in data processing methods. |
NA | datedownloaded | Date data were downloaded. |
NumberFishPerComp | numberfishpercomp | Number of fish composited in the tissue composite. |
OrganismAgeAtTestStart | organismageatteststart | Age or age range (e.g., 7 days or 7-10 days) of the test organisms at the beginning of the test. |
OrganismGroup | NA | Organism group of the sample, e.g., Fish, Bivalves, Crustacean, Mammal, or Bird. |
ParentProjectCode | NA | Code representing the parent project. |
ParentProjectName | parentproject | Parent project associated with the sample; used to help group multiple projects. |
PercentEffect | percenteffect | Percent difference between the mean of the endpoint and the mean of the control's associated endpoint; ((Mean Control Response − Mean Sample Response) / Mean Control Response) * 100. |
PositionWaterColumn | positionwatercolumn | Position in water column where sample was taken. |
PrepPreservationDate | preppreservationdate | Date the preparation or preservation was started. |
PrepPreservationName | preppreservation | Preparation or preservation method performed on the samples prior to analysis. |
ProgramCode | NA | Code representing the program. |
ProgramName | program | Program that is associated with the sample. |
ProjectCode | NA | Code representing the project. |
ProjectName | project | Project that is associated with the sample. |
ProtocolCode | protocol | Sampling protocol used to collect the sample, including the set of methods, methodology, and/or specifications. |
QACode | qacode | Code(s) applied to the result to describe any special conditions, situations, or outliers that occurred during or prior to the analysis to achieve the result. |
RefToxBatch | reftoxbatch | Reference toxicity batch identifier run with this batch of samples. |
regional_board | NA | Number of Regional Water Quality Control Board where sample was collected. Some discrepancies may exist since the Regional Water Board is determined by a spatial intersect using target lat/longs. |
RepCount | repcount | Total number of sample replicates analyzed for the associated toxpoint in the toxicity test (equals the number of lab replicates used to calculate the mean result). |
ResQualCode | resultqualcode | Code used to qualify the analytical result of the sample. |
Result | result | Final numeric result of a given analyte (may be blank if an appropriate resultqualcode is provided). |
ResultComments | NA | Holds any comments related to the lab result or analysis of the sample. |
ResultReplicate | resultreplicate | Used to distinguish between replicates created in the laboratory. |
ResultRowID | resultrowid | Unique identifier for result record. |
RL | rl | Reporting limit for the sample analyzed, as determined by the laboratory. |
SampleDate | sampledate | Date the sample was collected in the field. Note: If using Excel, reformat column to date format to remove default time (00:00:00) placed after the date. |
SampleID | NA | Unique identifier supplied by the organization directing the sampling or sampling agency, used to track the sample throughout the sampling and analysis processes. |
SampleTypeCode | sampletype | Type of sample collected or analyzed. |
SampleYear | NA | Year sample was collected in the field. |
SieveSize | NA | Size of the sieve used to collect the sample. |
SigEffectCode | sigeffectcode | Indicates whether the sample result is significantly different from the control and can include whether or not it is greater or less than the evaluation threshold. |
sm_geom | NA | Physical shape of the station. |
SourceRDC | sourcerdc | Acronym of Regional Data Center that uploaded the data. |
Species | species | Scientific name of organism. For benthic data, this field may include higher taxonomic levels. |
StationCode | stationcode | Code representing the station name and site that is unique within a study design. |
StationName | stationname | Name of the sampling station. |
StatMethod | statmethod | Statistical test or method used to calculate the probability of whether a test is significant or not; used to determine whether the sample replicates are significantly different from the control. |
StdDev | stddev | Standard deviation calculated from all the applicable replicates from a single sample. |
SubmittingAgencyCode | submittingagency | Organization or agency that is responsible for submission of the data to the database. This agency may be different from the lab agency if the analytical data were subcontracted to another agency. |
TestMaterial | NA | Category of results (e.g., sediment chemistry, tissue, water toxicity). |
TimePoint | timepoint | Point in time during the test at which the measurement was recorded for water quality measurements, or the day on which the end points were taken. |
TissueCode | NA | Code representing the tissue part analyzed. |
TissueName | tissuename | Tissue part used in the composite and analysis. |
TLAvg.mm | tlavglengthmm | Average length of the organisms in the tissue composite, measured in millimeters from the most forward point of the head, with mouth closed, to the farthest tip of the tail. |
TLMax.mm | tlmaxmm | Maximum length of the organisms in the tissue composite, measured in millimeters from the most forward point of the head, with mouth closed, to the farthest tip of the tail. |
TLMin.mm | tlminmm | Minimum length of the organisms in the tissue composite, measured in millimeters from the most forward point of the head, with mouth closed, to the farthest tip of the tail. |
ToxBatchStartDate | toxbatchstartdate | Date the toxicity test began. |
ToxPointMethod | toxpointmethod | General method used in obtaining or calculating the result. |
ToxPointSummaryRowID | NA | Unique identifier for toxicity result record. |
ToxResultQACode | toxresultqacode | Code(s) applied to the result to describe any special conditions, situations, or outliers that occurred during or prior to the analysis to achieve the result. |
ToxTestDurCode | toxtestdurcode | Duration of the toxicity test as a number including the associated units. |
Treatment | treatment | Any treatment performed on the sample, such as a pH adjustment. |
TreatmentConcentration | treatmentconcentration | Adjusted final concentration or value of the analyte applied to the toxicity sample, expressed as a number. |
UnitCollectionDepth | unitcollectiondepth | Units used for the collection depth. |
UnitGrabSize | NA | Units used for the grab sample. |
UnitName | unitname | Units in which the chemistry result is measured or expressed. |
UnitTreatment | unittreatment | Units used in the treatment. |
WBTypeName | waterbodytype | Type of waterbody of the station. |
WeightAvg.g | weightavgg | Average weight of the tissue parts used in the composite measured in grams. |
WQSource | wqsource | Differentiates between water quality measurements taken in the overlying water or interstitial water (pore water). |