DWHLC_DATA
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:54357 | Updated: August 9, 2022 | Published / External
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
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
|
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 |