****************************************************************************************************
tblDiveEvent
PURPOSE: The dive event table documents all relevant information about each dive survey conducted. The attributes of the dive are described including the geographic position to ensure that each dive meets all of the sampling guidelines. Each successful dive will generate a record containing data used to describe the characteristics of the dive in terms of the latitude, longitude, date, sampling organization and what surveys were conducted at the time of the dive.
TABLE GUIDELINES:
-
The combination of the fields StationID, SampleDate, SamplingOrganization, Replicate, Side and DepthZone 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 tblDiveEvent for submission to the Bight 08 online system.
EXAMPLE DATA:
Table Structure:
tblDiveEvent
Field Name
|
Type
|
Required
|
Size
|
Description
|
StationID
|
Text
|
Y
|
25
|
A geographic location label from the station table.
|
SampleDate
|
Date/Time
|
Y
|
|
The date the sample was collected. Format dd-mmm-yy
|
SamplingOrganization
|
Text
|
Y
|
15
|
From luList01_AgencyCodes.
|
DiveReplicate
|
Integer
|
Y
|
|
Sequential number of each dive.
|
Side
|
Text
|
Y
|
10
|
From luList43_DiveSurveySide.
|
DepthZone
|
Text
|
Y
|
15
|
From luList44_DiveSurveyDepthZone (inner, middle, outer and deep).
|
Heading
|
Integer
|
Y
|
|
Heading direction in compass degrees (0-360).
|
Temperature
|
Decimal
|
N
|
|
The temperature in C to the nearest one decimal place.
|
TemperatureUnits
|
Text
|
*
|
15
|
From luList28_Units. Default = “°C”(celsius)
|
Visibility
|
Integer
|
N
|
|
The visibility to the nearest meter.
|
VisibilityUnits
|
Text
|
*
|
15
|
From LuList28_Units. Default = “m”(meters)
|
Surge
|
Integer
|
N
|
|
The surge of the water.
|
SurgeUnits
|
Text
|
*
|
15
|
From LuList28_Units. Default = “m”(meters)
|
Datum
|
Text
|
Y
|
10
|
The datum on which the latitude and longitude are based. The default = NAD83.
|
Latitude
|
Decimal
|
Y
|
|
Degrees to 5 decimal places .
|
Longitude
|
Decimal
|
Y
|
|
Degrees to 5 decimal places expressed as a negative number.
|
SurveyStartTime
|
Date/Time
|
Y
|
|
The time at the start of the survey expressed in 24 hr time (hh:mm).
|
SurveyStartTimeZone
|
Text
|
Y
|
10
|
The time zone of the arrival time. From luList42_TimeZones.
|
SurveyDepth
|
Decimal
|
Y
|
|
The actual survey depth (expressed in meters to one decimal place).
|
SurveyDepthUnits
|
Text
|
Y
|
15
|
From luList28_Units.Default = “m”(meters)
|
FishAbundance
|
Yes/No
|
Y
|
1
|
Was fish abundance done in this dive event?
|
Swath
|
Yes/No
|
Y
|
1
|
Was swath done in this dive event?
|
UniformPointContact
|
Yes/No
|
Y
|
1
|
Was Uniform Point Contact done in this dive event?
|
Urchins
|
Yes/No
|
Y
|
1
|
Were urchins measured in this dive event?
|
DiveFailCode
|
Text
|
Y
|
15
|
From luList40_EventFailCodes. Default = “None”
|
DistanceToTarget
|
Decimal
|
N
|
|
Distance from target in meters.
|
DiveEventComments
|
Text
|
N
|
100
|
Additional remarks.
|
****************************************************************************************************
tblDiveFishAbundance
PURPOSE: The purpose of the dive fish abundance table is to document the number of individuals in each size class in each species from four replicates within each depth zone. Each record represents the number of fish in a particular size class of a particular species.
Fish are counted and their sizes (total length) estimated to the nearest cm in small fish and the nearest 5cm in larger fish (>15cm).
TABLE GUIDELINES:
-
The combination of the fields StationID, SampleDate, SamplingOrganization, DiveReplicate, DepthZone, Level, Species and SizeClass 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 tblDiveFishAbundance for submission to the Bight 08 online system.
EXAMPLE DATA:
Table Structure:
tblDiveFishAbundance
Field Name
|
Type
|
Required
|
Size
|
Description
|
StationID
|
Text
|
Y
|
25
|
A geographic location label from the station table.
|
SampleDate
|
Date/Time
|
Y
|
|
The date the sample was taken expressed as dd-mmm-yyyy.
|
SamplingOrganization
|
Text
|
Y
|
15
|
From luList01_AgencyCodes.
|
DiveReplicate
|
Integer
|
Y
|
|
The sequential number of the dive taken at the station.
|
DepthZone
|
Text
|
Y
|
15
|
From luList44_DiveSurveyDepthZone (inner, middle, outer and deep).
|
Level
|
Text
|
Y
|
15
|
From luList45_DiveSurveyLevels (benthic, middepth or canopy).
|
Species
|
Text
|
Y
|
50
|
The species being measured from luList46_DiveSurveySpecies.
|
EstimatedLength
|
Integer
|
Y
|
|
The estimated total length class into which the fish falls expressed in cm.
|
EstimatedLengthUnits
|
Text
|
Y
|
15
|
From luList28_Units.Default = “cm” (centimeters)
|
Abundance
|
Integer
|
Y
|
|
The number of fish in the estimated length class.
|
AbundanceQualifier
|
Text
|
N
|
4
|
Any necessary qualifier from luList11_QualifierCodes. Counted or estimated.
|
DiveFishAbunComments
|
Text
|
N
|
100
|
Additional remarks.
|
****************************************************************************************************
tblDiveUniformPointContact
PURPOSE: To estimate the substrate type, substrate relief and benthic organisms. Each record represents the substrate type, substrate relief and benthic organisms at one meter marks within the 30 meter transect.
TABLE GUIDELINES:
-
The combination of the fields StationID, SampleDate, SamplingOrganization, DiveReplicate, Meter, Zone and BenthicReefSpecies 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 tblDiveUniformPointContact for submission to the Bight 08 online system.
EXAMPLE DATA:
Table Structure:
tblDiveUniformPointContact
Field Name
|
Type
|
Required
|
Size
|
Description
|
StationID
|
Text
|
Y
|
25
|
A geographic location label from the station table.
|
SampleDate
|
Date/Time
|
Y
|
|
The date the sample was taken expressed as dd-mmm-yyyy.
|
SamplingOrganization
|
Text
|
Y
|
15
|
From luList01_AgencyCodes.
|
DiveReplicate
|
Integer
|
Y
|
|
The sequential number of the dive taken at the station.
|
Meter
|
Integer
|
Y
|
|
Meter at which the Uniform Point Contact was measured.
|
DepthZone
|
Text
|
Y
|
15
|
From luList44_DiveSurveyDepthZone (inner, middle, outer and deep).
|
BenthicReefSpecies
|
Text
|
Y
|
50
|
The species being measured from luList46_DiveSurveySpecies.
|
Substrate
|
Text
|
Y
|
50
|
Substrate types include bedrock (> 1m), boulder (1m), cobble (< 10cm) or sand
|
Relief
|
Text
|
Y
|
50
|
The maximum relief within a rectangle centered on the point that is 0.5 meter along the tape and 1m wide. Clarify units.
|
UPCComments
|
Text
|
N
|
100
|
Additional remarks.
|
****************************************************************************************************
tblDiveSwath
PURPOSE: To estimate the density of conspicuous, solitary and mobile invertebrates as well as specific macroalgae. Each record represents the segment and species within the 30 meter transect.
TABLE GUIDELINES:
-
The combination of the fields StationID, SampleDate, SamplingOrganization, DiveReplicate, Segment, DepthZone and BenthicReefSpecies 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 tblDiveSwath for submission to the Bight 08 online system.
EXAMPLE DATA:
Table Structure:
tblDiveSwath
Field Name
|
Type
|
Required
|
Size
|
Description
|
StationID
|
Text
|
Y
|
25
|
A geographic location label from the station table.
|
SampleDate
|
Date/Time
|
Y
|
|
The date the sample was taken expressed as dd-mmm-yyyy.
|
SamplingOrganization
|
Text
|
Y
|
15
|
From luList01_AgencyCodes.
|
DiveReplicate
|
Integer
|
Y
|
|
The sequential number of the dive taken at the station.
|
Segment
|
Text
|
Y
|
15
|
Segment in which counts were taken (0-10, 10-20, 20-30)
|
DepthZone
|
Text
|
Y
|
15
|
From luList44_DiveSurveyDpthZone (inner, middle, outer and deep).
|
BenthicReefSpecies
|
Text
|
Y
|
50
|
The species being measured from luList46_DiveSurveySpecies.
|
Abundance
|
Integer
|
Y
|
|
Number of organisms within each species.
|
AbundanceQualifier
|
Text
|
N
|
10
|
Any necessary qualifier from luList11_QualifierCodes.
|
MetersTo30
|
Integer
|
*
|
|
Number of meters in which 30 of a species was found. Abundance is extrapolated after a count of 30. If Abundance = 30 then required.
|
NumberOfStipes
|
Integer
|
*
|
|
Number of stipes per plant at 1m above the substrate. Only applicable to certain species.
|
DiveSwathComments
|
Text
|
N
|
100
|
Additional remarks.
|
****************************************************************************************************
tblDiveUrchins
PURPOSE: The purpose of the dive urchins table is to document the size length frequency of both red and purple sea urchins in each dive survey. Each record represents the number of urchins in a particular size class of a particular species.
Where abundant, 100 red and 100 purple urchins will be collected and their test diameters measured to the nearest centimeter.
TABLE GUIDELINES:
-
The combination of the fields StationID, SampleDate, SamplingOrganization, DepthZone, Species and TestSizeClass 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 tblDiveUrchins for submission to the Bight 08 online system.
EXAMPLE DATA:
Table Structure:
tblDiveUrchins
Field Name
|
Type
|
Required
|
Size
|
Description
|
StationID
|
Text
|
Y
|
25
|
A geographic location label from the station table.
|
SampleDate
|
Date/Time
|
Y
|
|
The date the sample was taken expressed as dd-mmm-yyyy.
|
SamplingOrganization
|
Text
|
Y
|
15
|
From luList01_AgencyCodes.
|
DepthZone
|
Text
|
Y
|
15
|
From luList44_DiveSurveyDepthZone (inner, middle, outer and deep).
|
Species
|
Text
|
Y
|
50
|
The species being measured - Strongylocentrotus purpuratus or Strongylocentrotus franciscanus.
|
TestSizeClass
|
Integer
|
Y
|
|
The size class into which the urchin falls expressed in cm.
|
TestSizeClassUnits
|
Text
|
Y
|
15
|
From luList28_Units.Default = “cm” (centimeters)
|
AbundanceQualifier
|
Text
|
N
|
10
|
Any necessary qualifier from luList11_QualifierCodes.
|
Abundance
|
Integer
|
Y
|
|
The number of urchins in the size class.
|
DiveUrchinComments
|
Text
|
N
|
100
|
Additional remarks.
|
|