Southern California Bight 2008 Regional Monitoring Survey

səhifə	7/30
tarix	24.06.2016
ölçüsü	3.16 Mb.

1 2 3 4 5 6 7 8 9 10 ... 30

b. Coastal Ecology

The Coastal Ecology project has three main objectives: 1) Estimate the extent and magnitude of ecological change in the SCB, 2) Determine the trends in extent and magnitude of ecological change in the SCB, and 3) Determine the mass balance of pollutants that currently reside within the SCB. To answer these questions, a probability based design was selected in order to apply statistical analyses to these questions. The tables in this project are intended to support those analyses by providing data at the replicate level and including QA/QC data within the tables themselves.

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

tblSedimentGrabEvent

PURPOSE: The sediment grab event table documents all relevant information about each grab sample collected. The attributes of the grab are described including the geographic position to ensure that each grab met all of the sampling guidelines. Each successful grab will generate a record containing data used to describe the characteristics of the sediment collected in terms of the latitude, longitude, date, time, color, composition, odor, penetration, the presence or absence of shell hash, and the usage for the individual grab.

TABLE GUIDELINES:

The combination of the fields StationID, SampleDate, SampleTime, GrabEventNumber, and SamplingOrganization ensure unique values for each record in the table.
This file can be named at the discretion of the user; however the excel sheet tab must be named tblSedimentGrabEvent for submission to the Bight’08 online system.

EXAMPLE DATA:

Table Structure:

tblSedimentGrabEvent

Field Name	Type	Required	Size	Description
StationID	Text	Y	25	A geographic location label from the station table.
SampleDepth	Double	Y		The sample depth expressed in meters
SampleDepthUnits	Text	Y	15	From luList28_Units.Default = “m”(meters)
SampleDate	Date/Time	Y		The date the sample was collected. Format dd-mmm-yyyy
SampleTime	Date/Time	Y		The time the sample was collected expressed as 24 hour time (hh:mm).
SampleTimeZone	Text	Y	10	The time zone of the arrival time. From luList42_TimeZoneCodes.
GrabEventNumber	Integer	Y		Sequential number of each grab
SamplingOrganization	Text	Y	15	From luList01_AgencyCodes.
GearCode	Text	Y	25	From luList03_EquipmentCodes.
Latitude	Decimal	Y		Degrees to 5 decimal places (NAD83).
Longitude	Decimal	Y		Degrees to 5 decimal places (NAD83) expressed as a negative number.
Datum	Text	Y	10	The datum on which the latitude and longitude are based. The default = NAD83.
Penetration	Integer	Y		Penetration of the grab into the sediment expressed in cm.
PenetrationUnits	Text	Y	15	From luList28_Units. The default value is cm.
Color	Text	Y	20	Color of the sediment from luList18_SedimentColors. The default is “Olive Green”
Composition	Text	Y	20	Composition of the sediment from luList06_SedimentCompositionCodes.
Odor	Text	Y	30	Odor of the sediment from luList07_OdorCodes.
BenthicInfauna	Yes/No	Y	1	Was this grab used for collecting Benthic Infauna?
SedimentChemistry	Yes/No	Y	1	Was this grab used for testing Sediment Chemistry?
Toxicity	Yes/No	Y	1	Was this grab used for testing Toxicity?
GrainSize	Yes/No	Y	1	Was this grab used for testing Grain Size?
DistanceToTarget	Decimal	N		Distance from target location in meters
GrabFailCode	Text	Y	25	From luList40_EventFailCodes. Default = “None”
Comments	Text	N	100	Additional remarks relative to the grab.

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

1 2 3 4 5 6 7 8 9 10 ... 30