Each Trawl Assemblage Event record must have a corresponding Station Occupation record Records are matched on StationID, SampleDate, SamplingOrganization, and TrawlNumber. PRIMARY KEY: To ensure no duplicates within the data set the following fields will be used as a primary key to create unique records: StationID SampleDate SamplingOrganization TrawlNumber EXAMPLE StationID SampleDate Gear TrawlNumber OverTime OverLatitude OverLongitude StartTime StartLatitude StartLongitude StartDepth DepthUnits WireOut August 13, 2013 Los Angeles County Sanitation Districts Otter Trawl w. 7.62 meter head rope 1 NAD83 08:42:36 -118.13833 m August 13, 2013 Los Angeles County Sanitation Districts Otter Trawl w. 7.62 meter head rope 1 NAD83 09:35:28 33.64729 m August 13, 2013 Los Angeles County Sanitation Districts Otter Trawl w. 7.62 meter head rope 1 NAD83 10:29:23 -118.20363 m August 13, 2013 Los Angeles County Sanitation Districts Otter Trawl w. 7.62 meter head rope 1 NAD83 12:06:27 -118.10489 m EndTime EndLatitude EndLongitude EndDepth DeckTime DeckLatitude DeckLongitude TrawlFail PTSensor PTSensorManufacturer PTSensorSerialNumber OnBottomTemp OnBottomTime Comments 9 11 49 8.1 :
DepthUnits Text Y 50 . WireOut Integer Y The length of wire out expressed in meters. EndTime Text Y 50 The time the net finish fishing expressed as 24-hour time (hh:mm:ss). EndLatitude Decimal Y Degrees of latitude expressed in decimal degrees to 5 places. EndLongitude Decimal Y Degrees of longitude expressed in decimal degrees to 5 places and as a negative number. EndDepth Decimal Y The at the end of the trawl in meters. DeckTime Text Y 50 The time the net is recovered and on deck expressed as (hh:mm:ss). DeckLatitude Decimal Y Degrees of latitude expressed in decimal degrees to 5 places. DeckLongitude Decimal Y Degrees of longitude expressed in decimal degrees to 5 places and as a negative number. TrawlFailure Text Y 50 Use to report any trawl fails. Default = “None”. From look-up list PTSensor Yes/No Y 3 Is there Pressure Temperature Sensor data associated with this trawl? Default = “Yes”.
TrawlNumber SamplingOrganization Species Anomaly EXAMPLE DATA StationID SampleID Sample Date Sampling Organization Trawl Number Species Abundance Qualifier Anomaly DiversityIndex Exclude Comments B18-0001 17-Jul-18 Los Angeles County Sanitation Districts 1 Pisaster brevispinus None No B18-0001 17-Jul-18 Los Angeles County Sanitation Districts 1 Pisaster brevispinus None No B18-0001 17-Jul-18 Los Angeles County Sanitation Districts 1 Strongylocentrotus fragilis Aliquot 1445 None Examined No B18-0001 17-Jul-18 Los Angeles County Sanitation Districts 1 Strongylocentrotus fragilis None No B18-0001 17-Jul-18 Los Angeles County Sanitation Districts None Yes Specimen may be Virgularia agassizii B18-0001 17-Jul-18 Los Angeles County Sanitation Districts 1 Virgularia agazissizii None No B18-0001 17-Jul-18 Los Angeles County Sanitation Districts Present No DATA STRUCTURE Table 9. Trawl Invertebrate Abundance table structure (primary key fields are indicated with bold text). NAME TYPE REQUIRED SIZE DESCRIPTION StationID Text Y 50 A geographic location as derived from the table of assigned Stations given to each Sampling Organization. SampleID Text N 50 The Sampling Organization field sample identifier. SampleDate Y The date the sample was collected expressed as dd/mmm/yyyy. SamplingOrganization Text Y 255 The name of the organization doing the sampling. From look-up list . TrawlNumber Integer Y The sequential number of the trawl taken at that station. Species Text Y 255 Scientific names of collected invertebrates from lu_InvertSpeciesList. (SCAMIT 12th edition) AbundanceQualifier Text N 255 Any necessary qualifier from . Abundance Integer Y Number of individuals of the species.
Size Parameter Codes: The Gravel2m code is the mass percentage of the sediment sample retained on a 2-mm sieve. If no sediments are retained, the value will be zero. The other parameter codes refer to the frequency percentage of sample in the size range. These data should not be adjusted for material retained on the sieve. Optional parameter codes to describe the statistical properties of the laser analyzer are included and may be reported. Default unit is percent within phi size. EXAMPLE DATA: StationID SampleDate PreparationBatchID AnalysisBatchID AnalysisDate SampleType Matrix Fraction AnalyteName SM March 22, 2018 None December 17, 2013 Reference ERA 540 Sed sediment Total Aluminum AnalysisMethod Units Qualifier Result FieldDuplicate LabReplicate LabSampleID TrueValue MDL RL Lab QACode Comments EPA 6020m ug/g dw none 33927.69922 1 1 8920.00 1 5 City of Los Angeles Environmental Monitoring Division None STRUCTURE: 13. Chemistry Results table structure (primary key fields are indicated with bold text). Field Name Type Required Size Description StationID Text Y 50 A geographic location label as derived from the table of assigned Stations given to each Sampling Organization. SampleDate Date/Time Y The date the sample was collected expressed as dd/mmm/yyyy. BioaccumulationSampleID Text * 50 *Required for tissue samples. Must match the BioaccumulationSampleID in the bioaccumulation organism table. PreparationBatchID Text Y 50 A unique agency identifier for each batch of samples prepared together.
B18-8350 July 3, 2013 CSD005 Sediment Water Interface City of San Mytilus galloprovincialis -88 None B18-8350 July 3, 2013 CSD005 Sediment Water Interface City of San Mytilus galloprovincialis -88 None B18-8350 July 3, 2013 CSD005 Sediment Water Interface City of San Diego Mytilus galloprovincialis -88 None B18-8350 July 3, 2013 CSD005 Sediment Water Interface City of San Diego Mytilus galloprovincialis -88 None Concentration ConcentrationUnits EndPoint LabRep Result ResultUnits QACode SampleTypeCode FieldReplicate Comments -88 Not Recorded Percent 1 53.85 percentage A Grab 1 -88 Not Recorded Percent 2 100.00 percentage A Grab 1 -88 Not Recorded Percent 3 38.46 percentage A Grab 1 -88 Not Recorded Percent 4 60.58 percentage A Grab 1 -88 Not Recorded Percent 5 68.75 percentage A Grab 1 DATA STRUCTURE: Table 15. Toxicity Reults table structure (primary key fields are indicated with bold text). FIELD NAME TYPE REQUIRED SIZE DESCRIPTION StationID Text Y 50 A geographic location as derived from the table of assigned Stations given to each Sampling Organization. ToxBatch Text Y 50 Batch number for batch processed samples. Matrix Text Y 50 The test matrix from . Lab Text Y 50 The analyzing agency code from . Species Text Y 50 Test species from . Dilution Decimal Y The dilution factor expressed as a proportion. Report as –88 for stations with no dilution factor. (For TIE results only) Treatment Text Y 255 Treatment performed on the sample (For TIEs only). “None” for non-TIE samples Concentration Decimal Y Concentration in mg/L. Report as –88 for
Trawl hit unknown obstruction Trawl hit an unknown obstruction, such as the boat stops or crew recognize a bump on the winch/wire. No Doors - No contact with bottom No contact with bottom, the catch is nearly empty with no obvious evidence of mud on the doors from digging into the sediment. No Torn Net Torn Net, parts of the net were torn and animals could potentially escape. No Unusually low catch Unusually low fish and invertebrate abandance was unexpectedly low so cruise leader decides to re-trawl. Yes Improper Deck Time Improper Deck Time, crew did not follow the expected surface time established in the manual for depths < 200m (expect 10 minutes but can be adjusted to pressuse sensor data). No Improper Bottom Time Improper Bottom Time, pressuse sensor indicates bottom contact was less then 8 minutes or greater then 15 minute. No Inadequate trawl track Inadequate trawl track, pressure sensor shows an undulating bottom while fathometer indicates an even bottom (irregular net bottom contact throughout trawl). No High Density Species Incidence 1 min trawl reveals excessive biomass of species (e.g., red crabs) that would preclude 10 min trawl of site Yes Other - Trawl Failure (comment req.) Other - another reason not listed why trawl failed. Yes lu_TrawlQualifier Qualifier Description < less than Aliquot Count base on calculation of Aliquot None None Present Present, not counted lu_DebrisType