Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Support Roles
Catalog Details

Summary

Abstract

Larval uku measurements.

Description

Larval uku measurements.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
CAST_ID
VARCHAR2
Cruise number and station number concatenated together for easier merging with literature review dataset (see technical memo).
CRUISE_STATION_NET_NUMBER
VARCHAR2
Cruise number, station number and net number concatenated together for easier merging with literature review dataset (see technical memo).
LARVA_IDENTIFIER
VARCHAR2
Unique identifier for an individual or lot of Aprion virescens. If specimen was from a museum collection the same identifier is used. If specimen is in fact merely a record from the literature a unique identifier was created combining the date of either the survey or the publication, author initials and a unique sequential number to differentiate the specimen from others caught in the same tow.
STATION_ALPHA_ID
VARCHAR2
Identification code for stations that qualitatively describes the station and distance to shore. The first character is either "W" or "L" denoting is station was on the wind ward or leeward side of O'ahu. The second one or two numbers denotes the ship's distance from shore in nautical miles. The next letter is either "D' or "N" denoting if the sample was collected during the day or night. Finally, the last number indicates if the station was the first or second replicate for that particular side, distance from shore and time of day.
REPLICATE_CODE
VARCHAR2
Code for replicate, can either be one or two.
CRUISE_NUMBER
VARCHAR2
Last two digits of the year of the cruise and two digits incremental number of the cruise for the year.
STATION_NUMBER
VARCHAR2
Station number of the trawl operation.
VESSEL_NAME
VARCHAR2
Unique ID for a trawl operation, used as part of the presence/absence analysis in Tech Memo. Concatenated ship name, trawl date, station number and day or night time.
COLLECTION_DEPTH_M_MAX
VARCHAR2
Maximum depth, in meters. Units for values are meters.
LENGTH_MM
NUMBER
Length of larva measured from tip of nose to the caudal end of the vertebrae. Units for values are millimeters. Measures are reported with a precision of 3.
LENGTH_TYPE
VARCHAR2
Standard length or total length, noted by SL or TL respectively.
SPINE_CODE
VARCHAR2
Qualitative measure of dorsal spine presence on uku specimen. 0 denotes no spine present, 1 denotes yes, spine is present but too small to see serrations, 2 denotes yes spine is present and serrations were visible, blank/NA denotes that the larva was processed before spine size was considered).
MEASUREMENT_METHOD
VARCHAR2
Denotes whether size was measured during effort in 2022 or size value was obtained from the record.
EXPECTED_NUM_UKU_PREV_DATA
VARCHAR2
This only applies to replicate one samples from TC8604 and both replicate one and two samples from TC8504. ALS had the counts of uku which had been identified from RB008AA1_V and went back through these samples to locate and measure the lengths of the previously identified uku.
IDENTIFIED_NUMBER_UKU_IN_CAST
VARCHAR2
The number of uku ALS was able to positively identify from a given sample vial (pooled specimens from the same cruise leg, station, net, replicate).
ORDER_NUM_ID_LARVA_FOR_CAST
VARCHAR2
A consecutive number for each larva from a given trawl/net.
FIRST_RECORD_UKU_FOR_CAST_CODE
VARCHAR2
In order to keep track of which tows and depths had been sorted this allowed us to easily filter the dataset to view which tows had and had not been worked on.
SPECIMEN_LOCATION
VARCHAR2
Current location of uku specimens.
NOTES
VARCHAR2
If non-uku individuals were pulled out and identified they also got their own vials and the number and species identifications (where available) are noted here.
SEQUENCE_NUMBER
VARCHAR2
A unique consecutive number for each data record.
FROM_FILE
VARCHAR2
Name of the file that was the source of the data.
DATE_LOADED
DATE
Date when the record was loaded into Oracle or updated.

Child Items

No Child Items for this record.

Contact Information

Point of Contact
Eva M Schemmel
eva.schemmel@noaa.gov

Point of Contact
Andrea Schmidt
andrea.schmidt@noaa.gov

Item Identification

Title: RB008AA1_UKUSIZES_V
Short Name: RB008AA1_UKUSIZES_V
Status: Completed
Abstract:

Larval uku measurements.

Notes:

20230908 - RB008AA2_UKUSIZES_V renamed to RB008AA1_UKUSIZES_V

Entity Information

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

Larval uku measurements.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
CAST_ID VARCHAR2 Cruise number and station number concatenated together for easier merging with literature review dataset (see technical memo).
100
CRUISE_STATION_NET_NUMBER VARCHAR2 Cruise number, station number and net number concatenated together for easier merging with literature review dataset (see technical memo).
100
LARVA_IDENTIFIER VARCHAR2 Unique identifier for an individual or lot of Aprion virescens. If specimen was from a museum collection the same identifier is used. If specimen is in fact merely a record from the literature a unique identifier was created combining the date of either the survey or the publication, author initials and a unique sequential number to differentiate the specimen from others caught in the same tow.
100
STATION_ALPHA_ID VARCHAR2 Identification code for stations that qualitatively describes the station and distance to shore. The first character is either "W" or "L" denoting is station was on the wind ward or leeward side of O'ahu. The second one or two numbers denotes the ship's distance from shore in nautical miles. The next letter is either "D' or "N" denoting if the sample was collected during the day or night. Finally, the last number indicates if the station was the first or second replicate for that particular side, distance from shore and time of day.
100
REPLICATE_CODE VARCHAR2 Code for replicate, can either be one or two.
100
CRUISE_NUMBER VARCHAR2 Last two digits of the year of the cruise and two digits incremental number of the cruise for the year.
100
STATION_NUMBER VARCHAR2 Station number of the trawl operation.
100
VESSEL_NAME VARCHAR2 Unique ID for a trawl operation, used as part of the presence/absence analysis in Tech Memo. Concatenated ship name, trawl date, station number and day or night time.
100
COLLECTION_DEPTH_M_MAX VARCHAR2 Maximum depth, in meters. Units for values are meters.
100
LENGTH_MM NUMBER Length of larva measured from tip of nose to the caudal end of the vertebrae. Units for values are millimeters. Measures are reported with a precision of 3.
100
LENGTH_TYPE VARCHAR2 Standard length or total length, noted by SL or TL respectively.
100
SPINE_CODE VARCHAR2 Qualitative measure of dorsal spine presence on uku specimen. 0 denotes no spine present, 1 denotes yes, spine is present but too small to see serrations, 2 denotes yes spine is present and serrations were visible, blank/NA denotes that the larva was processed before spine size was considered).
100
MEASUREMENT_METHOD VARCHAR2 Denotes whether size was measured during effort in 2022 or size value was obtained from the record.
100
EXPECTED_NUM_UKU_PREV_DATA VARCHAR2 This only applies to replicate one samples from TC8604 and both replicate one and two samples from TC8504. ALS had the counts of uku which had been identified from RB008AA1_V and went back through these samples to locate and measure the lengths of the previously identified uku.
100
IDENTIFIED_NUMBER_UKU_IN_CAST VARCHAR2 The number of uku ALS was able to positively identify from a given sample vial (pooled specimens from the same cruise leg, station, net, replicate).
100
ORDER_NUM_ID_LARVA_FOR_CAST VARCHAR2 A consecutive number for each larva from a given trawl/net.
100
FIRST_RECORD_UKU_FOR_CAST_CODE VARCHAR2 In order to keep track of which tows and depths had been sorted this allowed us to easily filter the dataset to view which tows had and had not been worked on.
100
SPECIMEN_LOCATION VARCHAR2 Current location of uku specimens.
100
NOTES VARCHAR2 If non-uku individuals were pulled out and identified they also got their own vials and the number and species identifications (where available) are noted here.
100
SEQUENCE_NUMBER VARCHAR2 A unique consecutive number for each data record.
100
FROM_FILE VARCHAR2 Name of the file that was the source of the data.
100
DATE_LOADED DATE Date when the record was loaded into Oracle or updated.

Attribute Details

CAST_ID

CC ID: 1255765
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Cruise number and station number concatenated together for easier merging with literature review dataset (see technical memo).

General Data Type: VARCHAR2

CRUISE_STATION_NET_NUMBER

CC ID: 1255766
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Cruise number, station number and net number concatenated together for easier merging with literature review dataset (see technical memo).

General Data Type: VARCHAR2

LARVA_IDENTIFIER

CC ID: 1255767
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Unique identifier for an individual or lot of Aprion virescens. If specimen was from a museum collection the same identifier is used. If specimen is in fact merely a record from the literature a unique identifier was created combining the date of either the survey or the publication, author initials and a unique sequential number to differentiate the specimen from others caught in the same tow.

General Data Type: VARCHAR2

STATION_ALPHA_ID

CC ID: 1255768
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Identification code for stations that qualitatively describes the station and distance to shore. The first character is either "W" or "L" denoting is station was on the wind ward or leeward side of O'ahu. The second one or two numbers denotes the ship's distance from shore in nautical miles. The next letter is either "D' or "N" denoting if the sample was collected during the day or night. Finally, the last number indicates if the station was the first or second replicate for that particular side, distance from shore and time of day.

General Data Type: VARCHAR2

REPLICATE_CODE

CC ID: 1255769
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Code for replicate, can either be one or two.

General Data Type: VARCHAR2
Allowed Values: 1; 2

CRUISE_NUMBER

CC ID: 1255770
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Last two digits of the year of the cruise and two digits incremental number of the cruise for the year.

General Data Type: VARCHAR2

STATION_NUMBER

CC ID: 1255771
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Station number of the trawl operation.

General Data Type: VARCHAR2

VESSEL_NAME

CC ID: 1255772
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Unique ID for a trawl operation, used as part of the presence/absence analysis in Tech Memo. Concatenated ship name, trawl date, station number and day or night time.

General Data Type: VARCHAR2

COLLECTION_DEPTH_M_MAX

CC ID: 1255773
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Maximum depth, in meters. Units for values are meters.

General Data Type: VARCHAR2
Unit of Measure: meters

LENGTH_MM

CC ID: 1255774
Seq. Order: 10
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Scale: 2
Status: Active
Description:

Length of larva measured from tip of nose to the caudal end of the vertebrae. Units for values are millimeters. Measures are reported with a precision of 3.

General Data Type: NUMBER
Unit of Measure: millimeters

LENGTH_TYPE

CC ID: 1255775
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Standard length or total length, noted by SL or TL respectively.

General Data Type: VARCHAR2
Allowed Values: PARTIAL; SL = STANDARD LENGTH; TL = TOTAL LENGTH

SPINE_CODE

CC ID: 1255776
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Qualitative measure of dorsal spine presence on uku specimen. 0 denotes no spine present, 1 denotes yes, spine is present but too small to see serrations, 2 denotes yes spine is present and serrations were visible, blank/NA denotes that the larva was processed before spine size was considered).

General Data Type: VARCHAR2
Allowed Values: 0 = NO SPINE PRESENT; 1 = SPINE PRESENT BUT TOO SMALL TO SEE SERRATIONS; 2 = SPINE PRESENT AND SERRATIONS WERE VISIBLE; NULL = THE LARVA WAS PROCESSED BEFORE SPINE SIZE WAS CONSIDERED

MEASUREMENT_METHOD

CC ID: 1255777
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Denotes whether size was measured during effort in 2022 or size value was obtained from the record.

General Data Type: VARCHAR2
Allowed Values: EVOCAM2; RECORDED; OLYMPUS CAM SCOPE

EXPECTED_NUM_UKU_PREV_DATA

CC ID: 1255778
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

This only applies to replicate one samples from TC8604 and both replicate one and two samples from TC8504. ALS had the counts of uku which had been identified from RB008AA1_V and went back through these samples to locate and measure the lengths of the previously identified uku.

General Data Type: VARCHAR2

IDENTIFIED_NUMBER_UKU_IN_CAST

CC ID: 1255779
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

The number of uku ALS was able to positively identify from a given sample vial (pooled specimens from the same cruise leg, station, net, replicate).

General Data Type: VARCHAR2

ORDER_NUM_ID_LARVA_FOR_CAST

CC ID: 1255780
Seq. Order: 16
Data Storage Type: VARCHAR2
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

A consecutive number for each larva from a given trawl/net.

General Data Type: VARCHAR2

FIRST_RECORD_UKU_FOR_CAST_CODE

CC ID: 1255781
Seq. Order: 17
Data Storage Type: VARCHAR2
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

In order to keep track of which tows and depths had been sorted this allowed us to easily filter the dataset to view which tows had and had not been worked on.

General Data Type: VARCHAR2
Default Value: 0 = NO; 1 = YES

SPECIMEN_LOCATION

CC ID: 1255782
Seq. Order: 18
Data Storage Type: VARCHAR2
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Current location of uku specimens.

General Data Type: VARCHAR2

NOTES

CC ID: 1255783
Seq. Order: 19
Data Storage Type: VARCHAR2
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

If non-uku individuals were pulled out and identified they also got their own vials and the number and species identifications (where available) are noted here.

General Data Type: VARCHAR2

SEQUENCE_NUMBER

CC ID: 1255784
Seq. Order: 20
Data Storage Type: VARCHAR2
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

A unique consecutive number for each data record.

General Data Type: VARCHAR2

FROM_FILE

CC ID: 1255785
Seq. Order: 21
Data Storage Type: VARCHAR2
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Name of the file that was the source of the data.

General Data Type: VARCHAR2

DATE_LOADED

CC ID: 1255786
Seq. Order: 22
Data Storage Type: DATE
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Date when the record was loaded into Oracle or updated.

General Data Type: DATE

Support Roles

Data Set Credit

CC ID: 1256316
Date Effective From: 2023-03
Date Effective To:
Contact (Person): Schmidt, Andrea
Email Address: andrea.schmidt@noaa.gov
Contact Instructions:

Contact via email.

Point of Contact

CC ID: 1268663
Date Effective From: 2023-08
Date Effective To:
Contact (Person): Schemmel, Eva M
Email Address: eva.schemmel@noaa.gov
Contact Instructions:

Contact via email.

Point of Contact

CC ID: 1268662
Date Effective From: 2023-03
Date Effective To:
Contact (Person): Schmidt, Andrea
Email Address: andrea.schmidt@noaa.gov
Contact Instructions:

Contact via email.

Catalog Details

Catalog Item ID: 70116
GUID: gov.noaa.nmfs.inport:70116
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2023-06-06 21:47+0000
Metadata Record Last Modified By: Brent M Miyamoto
Metadata Record Last Modified: 2023-09-09 05:32+0000
Metadata Record Published: 2023-06-14
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2023-06-07
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2024-06-07