Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > POPULATION & ECOSYSTEMS MONITORING DIV > Other Protected Resources Projects > Early Life History > Potential impacts of the Loop Current on Downst... > Potential impacts of the Loop Current on Downst... >

DWHLC_DATA

Entity (ENT)  |  Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:54357  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

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.

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.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
Sample_Number
Character 		Unique sequential code for each sample
Station
Character 		Station Number
Historical_station_number
Character 		Historical station number
Longitude
Numeric 		Sampling Longitude
Latitude
Numeric 		Sampling Latitude
Sampling_Date
Date 		Sampling Date
Sampling_start_time
Time 		Time that the Sampling started
Sampling_end_time
Time 		Time That Sampling Ending
Day_or_night_Sample
Character 		Indicates whether sampling is done during the day or at night
Gear
Character 		Code Indicating Type of Gear Used,
mesh_size
Numeric 		Gear mesh size (microns)
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
Haul
Numeric 		Net Number
Flowmeter_Start
Numeric 		Flowmeter Start Measurement
Flowmeter_End
Numeric 		Flowmeter End
Flowmeter_Difference
Numeric 		Change in Flowmeter_Reading
Filtered_Volume
Numeric 		Filtered Volume in cubic meters
Displacement_Volume
Numeric 		Displacement volume of plankton sample in mL
Wet_Weight
numeric 		Mass of plankton sample in grams
Number_Fish_Larvae
Numeric 		Number of fish larvae sorted from sample
Number_Eggs_Sorted
Numeric 		Number of eggs sorted from sample
Number_ cephalopod_larvae
Numeric 		Number of cephalopod larvae sorted from sample
Number_Lobster_larvae
Numeric 		Number of lobster larvae sorted from sample
Notes
Character 		Any textual notes corresponding to this sample
Region
Character 		Mnemonic Code of Geographic region where sample was collected

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (SEFSC) for inquiries on this record.

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: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2022-04-27
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2022-04-27
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2023-04-27