Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: DWHLC_DATA
Status: Completed
Abstract:

Data table is called DWHLC_DATA. It was created by a query of station and sampling data. Data reflect specific locations, plankton collection information from the survey, as well as lab sorting measurements and values. Any notes or comments relating to sample collections are listed here.

Entity Information

Entity Type: Data Table
Active Version?: Yes
Description:

Data reflect specific locations, plankton collection information from the survey, as well as lab sorting measurements and values. Any notes or comments relating to sample collections are listed here.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key Sample_Number Character Unique sequential code for each sample
100
Station Character Station Number
100
Historical_station_number Character Historical station number
100
Longitude Numeric Sampling Longitude
100
Latitude Numeric Sampling Latitude
100
Sampling_Date Date Sampling Date
100
Sampling_start_time Time Time that the Sampling started
100
Sampling_end_time Time Time That Sampling Ending
100
Day_or_night_Sample Character Indicates whether sampling is done during the day or at night
100
Gear Character Code Indicating Type of Gear Used,
100
mesh_size Numeric Gear mesh size (microns)
100
Sampling_Depth_Range Character Range of Sampling depth. The lower and upper range of the sampling depth are provided in the same fields. The units for each value are in meters
100
Haul Numeric Net Number
100
Flowmeter_Start Numeric Flowmeter Start Measurement
100
Flowmeter_End Numeric Flowmeter End
100
Flowmeter_Difference Numeric Change in Flowmeter_Reading
100
Filtered_Volume Numeric Filtered Volume in cubic meters
100
Displacement_Volume Numeric Displacement volume of plankton sample in mL
100
Wet_Weight numeric Mass of plankton sample in grams
100
Number_Fish_Larvae Numeric Number of fish larvae sorted from sample
100
Number_Eggs_Sorted Numeric Number of eggs sorted from sample
100
Number_ cephalopod_larvae Numeric Number of cephalopod larvae sorted from sample
100
Number_Lobster_larvae Numeric Number of lobster larvae sorted from sample
100
Notes Character Any textual notes corresponding to this sample
100
Region Character Mnemonic Code of Geographic region where sample was collected

Attribute Details

Sample_Number

CC ID: 790483
Seq. Order: 10
Data Storage Type: Character
Required: Yes
Primary Key: Yes
Status: Active
Description:

Unique sequential code for each sample

Station

CC ID: 790484
Seq. Order: 20
Data Storage Type: Character
Max Length: 3
Required: Yes
Primary Key: No
Status: Active
Description:

Station Number

Historical_station_number

CC ID: 790485
Seq. Order: 30
Data Storage Type: Character
Max Length: 5
Required: Yes
Primary Key: No
Status: Active
Description:

Historical station number

Longitude

CC ID: 790486
Seq. Order: 40
Data Storage Type: Numeric
Required: Yes
Primary Key: No
Status: Active
Description:

Sampling Longitude

Validation Rules:

Standard longitude values between -180 and 180

Latitude

CC ID: 790487
Seq. Order: 50
Data Storage Type: Numeric
Max Length: 8
Required: Yes
Primary Key: No
Precision: 2
Status: Active
Description:

Sampling Latitude

Validation Rules:

Standard latitude values between -90 and 90

Sampling_Date

CC ID: 790615
Seq. Order: 70
Data Storage Type: Date
Required: Yes
Primary Key: No
Status: Active
Description:

Sampling Date

Sampling_start_time

CC ID: 790616
Seq. Order: 80
Data Storage Type: Time
Required: Yes
Primary Key: No
Status: Active
Description:

Time that the Sampling started

Sampling_end_time

CC ID: 790617
Seq. Order: 90
Data Storage Type: Time
Required: Yes
Primary Key: No
Status: Active
Description:

Time That Sampling Ending

Day_or_night_Sample

CC ID: 790618
Seq. Order: 100
Data Storage Type: Character
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

Indicates whether sampling is done during the day or at night

Allowed Values: Day=1 Night=0

Gear

CC ID: 790619
Seq. Order: 110
Data Storage Type: Character
Required: Yes
Primary Key: No
Status: Active
Description:

Code Indicating Type of Gear Used,

mesh_size

CC ID: 790620
Seq. Order: 120
Data Storage Type: Numeric
Required: Yes
Primary Key: No
Status: Active
Description:

Gear mesh size (microns)

Unit of Measure: microns

Sampling_Depth_Range

CC ID: 790621
Seq. Order: 130
Data Storage Type: Character
Required: No
Primary Key: No
Status: Active
Description:

Range of Sampling depth. The lower and upper range of the sampling depth are provided in the same fields. The units for each value are in meters

Unit of Measure: meters

Haul

CC ID: 790622
Seq. Order: 140
Data Storage Type: Numeric
Required: No
Primary Key: No
Status: Active
Description:

Net Number

Flowmeter_Start

CC ID: 790631
Seq. Order: 150
Data Storage Type: Numeric
Required: No
Primary Key: No
Status: Active
Description:

Flowmeter Start Measurement

Flowmeter_End

CC ID: 790632
Seq. Order: 160
Data Storage Type: Numeric
Required: No
Primary Key: No
Status: Active
Description:

Flowmeter End

Null Value Meaning:

Something happened so that an ending flowmeter reading could not be taken

Flowmeter_Difference

CC ID: 790633
Seq. Order: 170
Data Storage Type: Numeric
Required: No
Primary Key: No
Status: Active
Description:

Change in Flowmeter_Reading

Derivation:

calculated as Flowmeter_end - Flowmeter_start

Filtered_Volume

CC ID: 790634
Seq. Order: 180
Data Storage Type: Numeric
Required: No
Primary Key: No
Status: Active
Description:

Filtered Volume in cubic meters

Displacement_Volume

CC ID: 790630
Seq. Order: 200
Data Storage Type: Numeric
Required: No
Primary Key: No
Status: Active
Description:

Displacement volume of plankton sample in mL

Unit of Measure: mL

Wet_Weight

CC ID: 790629
Seq. Order: 210
Data Storage Type: numeric
Required: No
Primary Key: No
Status: Active
Description:

Mass of plankton sample in grams

Unit of Measure: gm

Number_Fish_Larvae

CC ID: 790628
Seq. Order: 220
Data Storage Type: Numeric
Required: No
Primary Key: No
Status: Active
Description:

Number of fish larvae sorted from sample

Null Value Meaning:

There was no sample from which to take a reading

Number_Eggs_Sorted

CC ID: 790627
Seq. Order: 230
Data Storage Type: Numeric
Required: No
Primary Key: No
Status: Active
Description:

Number of eggs sorted from sample

Number_ cephalopod_larvae

CC ID: 790626
Seq. Order: 240
Data Storage Type: Numeric
Required: No
Primary Key: No
Status: Active
Description:

Number of cephalopod larvae sorted from sample

Number_Lobster_larvae

CC ID: 790625
Seq. Order: 250
Data Storage Type: Numeric
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Number of lobster larvae sorted from sample

Null Value Meaning:

There was no sample from which to take a reading

Notes

CC ID: 790624
Seq. Order: 260
Data Storage Type: Character
Max Length: 200
Required: No
Primary Key: No
Status: Active
Description:

Any textual notes corresponding to this sample

Region

CC ID: 790623
Seq. Order: 270
Data Storage Type: Character
Max Length: 6
Required: Yes
Primary Key: No
Status: Active
Description:

Mnemonic Code of Geographic region where sample was collected

Allowed Values: FLSTR GOM = Gulf Of Mexico CUB =
Derivation:

Function Based upon Latitude and Longitude Reading

Catalog Details

Catalog Item ID: 54357
GUID: gov.noaa.nmfs.inport:54357
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2018-10-22 13:08+0000
Metadata Record Last Modified By: Lee M Weinberger
Metadata Record Last Modified: 2021-10-13 19:08+0000
Metadata Record Published: 2021-10-13
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-10-14