70116 RB008AA1_UKUSIZES_V Entity Published / External 8791 Larval Fish Identification from Cruises at Oahu, TC-85-04, TC-85-05, TC-86-02, TC-86-04 Data Set Completed Larval uku measurements. 20230908 - RB008AA2_UKUSIZES_V renamed to RB008AA1_UKUSIZES_V Data Table Yes Larval uku measurements. 1 CAST_ID VARCHAR2 22 No No Active Cruise number and station number concatenated together for easier merging with literature review dataset (see technical memo). VARCHAR2 2 CRUISE_STATION_NET_NUMBER VARCHAR2 22 No No Active Cruise number, station number and net number concatenated together for easier merging with literature review dataset (see technical memo). VARCHAR2 3 LARVA_IDENTIFIER VARCHAR2 22 No No Active 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. VARCHAR2 4 STATION_ALPHA_ID VARCHAR2 22 No No Active 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. VARCHAR2 5 REPLICATE_CODE VARCHAR2 22 No No Active Code for replicate, can either be one or two. VARCHAR2 1; 2 6 CRUISE_NUMBER VARCHAR2 22 No No Active Last two digits of the year of the cruise and two digits incremental number of the cruise for the year. VARCHAR2 7 STATION_NUMBER VARCHAR2 22 No No Active Station number of the trawl operation. VARCHAR2 8 VESSEL_NAME VARCHAR2 22 No No Active 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. VARCHAR2 9 COLLECTION_DEPTH_M_MAX VARCHAR2 22 No No Active Maximum depth, in meters. Units for values are meters. VARCHAR2 meters 10 LENGTH_MM NUMBER 22 No No 2 Active 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. NUMBER millimeters 11 LENGTH_TYPE VARCHAR2 22 No No Active Standard length or total length, noted by SL or TL respectively. VARCHAR2 PARTIAL; SL = STANDARD LENGTH; TL = TOTAL LENGTH 12 SPINE_CODE VARCHAR2 22 No No Active 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). VARCHAR2 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 13 MEASUREMENT_METHOD VARCHAR2 22 No No Active Denotes whether size was measured during effort in 2022 or size value was obtained from the record. VARCHAR2 EVOCAM2; RECORDED; OLYMPUS CAM SCOPE 14 EXPECTED_NUM_UKU_PREV_DATA VARCHAR2 22 No No Active 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. VARCHAR2 15 IDENTIFIED_NUMBER_UKU_IN_CAST VARCHAR2 22 No No Active 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). VARCHAR2 16 ORDER_NUM_ID_LARVA_FOR_CAST VARCHAR2 22 No No Active A consecutive number for each larva from a given trawl/net. VARCHAR2 17 FIRST_RECORD_UKU_FOR_CAST_CODE VARCHAR2 22 No No Active 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. VARCHAR2 0 = NO; 1 = YES 18 SPECIMEN_LOCATION VARCHAR2 22 No No Active Current location of uku specimens. VARCHAR2 19 NOTES VARCHAR2 22 No No Active 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. VARCHAR2 20 SEQUENCE_NUMBER VARCHAR2 22 No No Active A unique consecutive number for each data record. VARCHAR2 21 FROM_FILE VARCHAR2 22 No No Active Name of the file that was the source of the data. VARCHAR2 22 DATE_LOADED DATE 22 No No Active Date when the record was loaded into Oracle or updated. DATE Data Set Credit 2023-03 Person Schmidt, Andrea andrea.schmidt@noaa.gov Contact via email. Point of Contact 2023-08 Person Schemmel, Eva M eva.schemmel@noaa.gov Contact via email. Point of Contact 2023-03 Person Schmidt, Andrea andrea.schmidt@noaa.gov Contact via email. gov.noaa.nmfs.inport:70116 Brent Miyamoto 2023-06-06T21:47:33 Michael Chang 2025-02-13T23:16:52 2025-02-13 Pacific Islands Fisheries Science Center PIFSC 1845 Wasp Blvd. Honolulu HI 96818 USA 808-725-5300 https://www.pifsc.noaa.gov 8:00 a.m. - 4:30 p.m. 1001 Public No 2023-06-07 1 Year 2024-06-07