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 Gear WireOut OverTime StationID StartTime StartDepth DepthUnits SampleDate OverLatitude StartLatitude TrawlNumber OverLongitude StartLongitude : 11 8.1 August 13, Los Angeles County Sanitation Otter Trawl w. 7.62 meter head 2013 Districts rope 1 NAD83 08:42:36 -118.13833 49 m 9 August 13, Los Angeles County Sanitation Otter Trawl w. 7.62 meter head 2013 Districts rope 1 NAD83 09:35:28 33.64729 m August 13, Los Angeles County Sanitation Otter Trawl w. 7.62 meter head 2013 Districts rope 1 NAD83 10:29:23 -118.20363 m August 13, Los Angeles County Sanitation Otter Trawl w. 7.62 meter head 2013 Districts rope 1 NAD83 12:06:27 -118.10489 m EndTime DeckTime TrawlFail PTSensor EndDepth Comments EndLatitude DeckLatitude EndLongitude DeckLongitude OnBottomTime OnBottomTemp PTSensorManufacturer PTSensorSerialNumber
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 :
B18InformationManagement_June29.docx