Southern California Bight 2008 Regional Monitoring Survey

tblToxicityBatchInformation

PURPOSE: This table is used to record information specific to each test batch processed in the laboratory and is used as supporting documentation for the Toxicity Test data. Each record represents specific information common to a group of samples processed at the same time and is pertinent to all replicates processed. This is QA/QC data needed to document the test results.

• 
  Each record will be unique based on a combination of the fields QABatch, LabCode and TestDuration.
  
• 
  This file can be named at the discretion of the user; however the excel sheet tab must be named tblToxicityBatchInformation for submission to the Bight’08 online system.
  

EXAMPLE DATA:

****************************************************************************************************

tblToxicityResults

PURPOSE: The Toxicity Results table carries data relevant to sediment or water toxicity tests and their replicates. Each record represents the results of an individual replicate for an individual species processed in a batch of replicates.

• 
  Each record will be unique based on a combination of the fields StationID, SampleType, QABatch, LabCode, Species, Dilution, Concentration and LabRep.
  
• 
  This file can be named at the discretion of the user; however the excel sheet tab must be named tblToxicityResults for submission to the Bight’08 online system.
  

EXAMPLE DATA:

tblToxicityWQ

PURPOSE: This table is used to document water quality during the course of a toxicity test. Each record represents a measurement of an individual water quality parameter at a specific time interval during the course of the test batch.

• 
  Each record will be unique based on a combination of the fields StationID, QABatch, Matrix, Dilution, Concentration, TimePoint, Parameter, LabRep, and LabCode.
  
• 
  This file can be named at the discretion of the user; however the excel sheet tab must be named tblToxicityWQ for submission to the Bight’08 online system.
  

EXAMPLE DATA:

****************************************************************************************************

tblToxicitySummaryResults

PURPOSE: This table is used to document the final determination of toxicity for each station. This table has been added to make the results easier to interpret by the final end users of the data set. SCCWRP will generate this table after all other toxicity data has been submitted.

• 
  Each record will be unique based on a combination of the fields StationID, Species, and LabCode.
  

EXAMPLE DATA:

****************************************************************************************************

tblTrawlAssemblageEvent

There are four positions recorded during a trawl; net over, net on the bottom, end of trawl, and net on deck. The first and last positions are recorded for Quality Assurance purposes. The time is recorded for each of these positions. The latitude and longitude are recorded for all of the positions in terms of decimal degrees.

TABLE GUIDELINES:

• 
  The combination of StationID, SampleDate, SamplingOrganization, and TrawlNumber ensure that each record in the table will be unique.
  
• 
  This file can be named at the discretion of the user; however the excel sheet tab must be named tblTrawlAssemblageEvent for submission to the Bight’08 online system.
  

Table Structure:

tblArchivalDataTag

TABLE GUIDELINES:

• 
  Each record will be unique based on a combination of the fields StationID, SamplingOrganization, TrawlNumber, SampleDate and Time.
  
• 
  This file can be named at the discretion of the user; however the excel sheet tab must be named tblArchiveDataTag for submission to the Bight 08 online system.
  

Table Structure:

tblTrawlDebris

TABLE GUIDELINES:

• 
  The combination of StationID, SampleDate, TrawlNumber, SamplingOrganization and DebrisType ensures that each record in the table will be unique.
  
• 
  This file can be named at the discretion of the user; however the excel sheet tab must be named tblTrawlDebris for submission to the Bight‘08 online system.
  

Table Structure:

tblTrawlFishAbundance

Each fish is measured individually and examined for anomalies. In the event that anomalies are found in combination, use the codes for anomaly combinations from luList 22_TrawlFishAnomalyCodes.

TABLE GUIDELINES:

• 
  The combination of the fields StationID, SampleDate, SamplingOrganization, TrawlNumber, Species, SizeClass, and Anomaly will ensure that each record is unique in the table.
  
• 
  This file can be named at the discretion of the user; however the excel sheet tab must be named tblTrawlFishAbundance for submission to the Bight’08 online system.
  

Table Structure:

tblTrawlFishBiomass

The biomass will be recorded to a single decimal place. The “units” field default value is kg and is carried to document the units used in this survey for historical purposes. If a species group weighs less than 0.1 kg it will recorded as < 0.1 kg and be retained and weighed with other species groups that fall into this weight category. A single record will be entered with the species name “CompositeWt” for each station that had at least two species groups weighing less than 0.1 kg. This is essential for computing a total biomass of fish for the trawl.

TABLE GUIDELINES:

• 
  The combination of the fields StationID, SampleDate, SamplingOrganization, TrawlNumber, and Species will ensure that each record is unique in the table.
  
• 
  This file can be named at the discretion of the user; however the excel sheet tab must be named tblTrawlFishBiomass for submission to the Bight’08 online system.
  

Table Structure:

tblTrawlInvertebrateAbundance

The qualifier field may carry an “A” indicating that the abundance was estimated by aliquot. In the case of certain species like urchins, where very large numbers of individuals may be encountered, a number (100 or 200 for example) may be weighed and the total haul number estimated from the total weight.

TABLE GUIDELINES:

• 
  The combination of the fields StationID, SampleDate, SamplingOrganization, TrawlNumber, Species, and Anomaly will ensure that each record is unique in the table.
  
• 
  This file can be named at the discretion of the user; however the excel sheet tab must be named tblTrawlInvertebrateAbundance for submission to the Bight’08 online system.
  

Table Structure:

tblTrawlInvertebrateBiomass

As with the fish biomass, the biomass of megabenthic invertebrates will be recorded to a single decimal place. The “units” field default value is kg and is carried to document the units used in this survey for historical purposes. If a species group weighs less than 0.1 kg it will recorded as < 0.1 kg and be retained and weighed with other species groups that fall into this weight category. A single record will be entered with the species name “CompositeWt” for each station that had at least two species groups weighing less than 0.1 kg. This is essential for computing a total biomass of megabenthic invertebrates for the trawl.

TABLE GUIDELINES:

• 
  The combination of the fields StationID, SampleDate, SamplingOrganization, TrawlNumber, and Species will ensure that each record in unique in the table.
  
• 
  This file can be named at the discretion of the user; however the excel sheet tab must be named tblTrawlInvertebrateBiomass for submission to the Bight’08 online system.
  

Table Structure: