TrawlNumber SamplingOrganization Species Anomaly EXAMPLE DATA Sample Sampling Trawl Abundance DiversityIndex StationID SampleID Species Anomaly Comments Date Organization Number Qualifier Exclude Los Angeles County Pisaster B18-0001 17-Jul-18 Sanitation Districts 1 brevispinus None No Los Angeles County Pisaster B18-0001 17-Jul-18 Sanitation Districts 1 brevispinus None No Los Angeles County Strongylocentrotus None B18-0001 17-Jul-18 Sanitation Districts 1 fragilis Aliquot 1445 Examined No Los Angeles County Strongylocentrotus B18-0001 17-Jul-18 Sanitation Districts 1 fragilis None No Los Angeles County Specimen may be B18-0001 17-Jul-18 Sanitation Districts None Yes Virgularia agassizii Los Angeles County Virgularia B18-0001 17-Jul-18 Sanitation Districts 1 agazissizii None No Los Angeles County B18-0001 17-Jul-18 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 50 A geographic location as derived Y from the table of assigned Stations given to each Sampling Organization. SampleID Text 50 The Sampling Organization field N sample identifier. SampleDate The date the sample was collected Y 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. Scientific names of collected Species Text Y 255 invertebrates from lu_InvertSpeciesList. (SCAMIT 12th edition) AbundanceQualifier Text N 255 Any necessary qualifier from . Abundance Integer Y Number of individuals of the species.
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.
B18InformationManagement_June29.docx