Search Help Show/Hide Menu
Summary
Item Identification
Keywords
Data Attributes
Support Roles
Child Items
Catalog Details

Summary

Entity Information

Data Attribute / Type Description
TRIP
VARCHAR2(20 BYTE)
SEFSC Pelegic Observer Program Trip ID number for the trip where this sample/observation was taken
carc_tag
VARCHAR2(20 BYTE)
Sample number assigned by observer. Is unique within a trip but not among trips.
specimen_number
VARCHAR2(20 BYTE)
Combination of the trip number and carc_tag/specimen number, is a unique value.
SPECIES
VARCHAR2(20 BYTE)
SPG=roundscale spearfish-2 ID criteria used. SPG_POT= potential roundscale, only single ID criterion used.
haul_number
number
Haul number where this sample/observation was taken
HAUL_DATE
date
Date when this sample/observation was taken.
Length
number
Lower jaw fork length, in cm, taken as curved measurement along the contour of the body.
Sex
VARCHAR2(4 BYTE)
Sex of speciemen, if known. 1=male, 2=female
lat_deg
VARCHAR2(4 BYTE)
Degree of latitude of the begin haul location for the haul where this sample/observation was taken
lat_min
VARCHAR2(4 BYTE)
Minute of latitude of the begin haul location for the haul where this sample/observation was taken
lon_deg
VARCHAR2(4 BYTE)
Degree of longitude of the begin haul location for the haul where this sample/observation was taken
lon_min
VARCHAR2(4 BYTE)
Minute of longitude of the begin haul location for the haul where this sample/observation was taken
AFA
number
Straight line measurement in cm from the posterior opening of the vent to the anterior origin of the first anal fin
AFH
number
Straight line measurement in CM of the height of the first anal fin
Relationship
number
=AFA divided by AFH, rounded to one decimal place.
AFA_LJFL
number
=AFA divided by lower jaw fork length length
DFSC
VARCHAR2(2 BYTE)
First dorsal fin spine count
AREA
VARCHAR2(4 BYTE)3
NMFS HMS Statistical area where this sample/observation was taken
NUM_ID_CRITERIA
VARCHAR2(1 BYTE)
Number of ID criteria used to determine species ID.
AFA_AFH_METHOD
VARCHAR2(5 BYTE)
Method used to determine the AFA/AFH relationship
Body_length_1
number
Measurement in mm; see reference measurement number 1 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
Body_girth_2
VARCHAR2(4 BYTE)
Measurement in mm; see reference measurement number 2 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
First_predorsal_length_3
VARCHAR2(4 BYTE)
Measurement in mm; see reference measurement number 3 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
Second_predorsal_length_4
VARCHAR2(4 BYTE)
Measurement in mm; see reference measurement number 4 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
Prepectoral_length_5
VARCHAR2(4 BYTE)
Measurement in mm; see reference measurement number 5 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
Prepelvic_length_6
VARCHAR2(4 BYTE)
Measurement in mm; see reference measurement number 6 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
First_preanal_length_7
VARCHAR2(4 BYTE)
Measurement in mm; see reference measurement number 7 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
Second_preanal_length_8
VARCHAR2(4 BYTE)
Measurement in mm; see reference measurement number 8 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
Orig_D1_to_orig_P1_9
VARCHAR2(4 BYTE)
Measurement in mm; see reference measurement number 9 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
Orig_D1_to_orig_P2_10
VARCHAR2(4 BYTE)
Measurement in mm; see reference measurement number 10 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
Orig_D2_to_orig_A2_11
VARCHAR2(4 BYTE)
Measurement in mm; see reference measurement number 11 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
Tip_mandible_to_anus
VARCHAR2(4 BYTE)
Measurement in mm; see reference measurement number for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
Orig_P2_to_nape_13
VARCHAR2(4 BYTE)
Measurement in mm; see reference measurement number 13 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
Greatest_body_depth_14
VARCHAR2(4 BYTE)
Measurement in mm; see reference measurement number 14 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
Depth_at_orig_D1_15
VARCHAR2(4 BYTE)
Measurement in mm; see reference measurement number 15 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
Depth_at_orig_A1_16
VARCHAR2(4 BYTE)
Measurement in mm; see reference measurement number 16 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
Least_depth_cp_17
VARCHAR2(4 BYTE)
Measurement in mm; see reference measurement number 17 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
Width_at_P1_base_18
VARCHAR2(4 BYTE)
Measurement in mm; see reference measurement number 18 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
Width_at_A1_orig_19
VARCHAR2(4 BYTE)
Measurement in mm; see reference measurement number 19 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
Width_at_A2_orig_20
VARCHAR2(4 BYTE)
Measurement in mm; see reference measurement number 20 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
Width_cp_front_of_keels
VARCHAR2(4 BYTE)
Measurement in mm; see reference measurement number for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
Length_of_upper_keel_22
VARCHAR2(4 BYTE)
Measurement in mm; see reference measurement number 22 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
Length_of_lower_keel_23
VARCHAR2(4 BYTE)
Measurement in mm; see reference measurement number 23 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
Head_length_24
VARCHAR2(4 BYTE)
Measurement in mm; see reference measurement number 24 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
Snout_length_25
VARCHAR2(4 BYTE)
Measurement in mm; see reference measurement number 25 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
Bill_length_26
VARCHAR2(4 BYTE)
Measurement in mm; see reference measurement number 26 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
Maxillary_length_28
VARCHAR2(4 BYTE)
Measurement in mm; see reference measurement number 28 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
Orbit_diameter_29
VARCHAR2(4 BYTE)
Measurement in mm; see reference measurement number 29 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
Depth_of_bill_33
VARCHAR2(4 BYTE)
Measurement in mm; see reference measurement number 33 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
Width_of_bill_34
VARCHAR2(4 BYTE)
Measurement in mm; see reference measurement number for 34 details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
Height_D1_39
VARCHAR2(4 BYTE)
Measurement in mm; see reference measurement number 39 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
Length_25th_D1_spine_40
VARCHAR2(4 BYTE)
Measurement in mm; see reference measurement number 40 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
Height_D2_41
VARCHAR2(4 BYTE)
Measurement in mm; see reference measurement number 41 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
Height_A1_42
VARCHAR2(4 BYTE)
Measurement in mm; see reference measurement number 42 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
Height_A2_43
VARCHAR2(4 BYTE)
Measurement in mm; see reference measurement number 43 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
Length_P1_44
VARCHAR2(4 BYTE)
Measurement in mm; see reference measurement number 44 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
Length_P2_45
VARCHAR2(4 BYTE)
Measurement in mm; see reference measurement number 45 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
Length_last_D2_ray
VARCHAR2(4 BYTE)
Measurement in mm, length of second dorsal fin posterior ray
Length_last_A2_ray
VARCHAR2(4 BYTE)
Measurement in mm, length of second anal fin posterior ray
Orig_D1_to_Orig_D2
VARCHAR2(4 BYTE)
Measurement in mm, straight line between the origin of the first dorsal fin to the origin of the second dorsal fin.
Anus_posterior_to_orig_A1
VARCHAR2(4 BYTE)
Straight line measurement in mm from the posterior opening of the vent to the anterior origin of the fisrt anal fin
Anus_anterior_to_orig_A1
VARCHAR2(4 BYTE)
Straight line measurement in mm from the anterior opening of the vent to the anterior origin of the fisrt anal fin
Dorsal_spines_D1
VARCHAR2(4 BYTE)
Count of spines on first dorsal fin
Dorsal_rays_D1
VARCHAR2(4 BYTE)
Count of rays on first dorsal fin
D1_elements
VARCHAR2(4 BYTE)
Total elements (spines + rays) on first dorsal fin
Anal_spines_A1
VARCHAR2(4 BYTE)
Count of spines on first anal fin
Anal_rays_A1
VARCHAR2(4 BYTE)
Count of rays on first anal fin
A1_elements
VARCHAR2(4 BYTE)
Total elements (spines + rays) on first anal fin
Pectoral_rays
VARCHAR2(4 BYTE)
Count of rays on pectoral fin
Precaudal_vertebrae
VARCHAR2(4 BYTE)
Count of precaudal vertebrae
Caudal_vertebrae
VARCHAR2(4 BYTE)
Count of caudal vertebrae

Child Items

Type Title
Procedure Data Table

Contact Information

Point of Contact
Larry Beerkircher
lawrence.r.beerkircher@noaa.gov
305-361-4290

Metadata Contact
Larry Beerkircher
lawrence.r.beerkircher@noaa.gov
305-361-4290

Item Identification

Title: Data Table
Short Name: Morphological and meristic data
Status: Completed

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None abundance
None billfish
None distribution
None morphology
None morphometrics
None Spearfish

Spatial Keywords

Thesaurus Keyword
UNCONTROLLED
None northwestern Atlantic

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
TRIP VARCHAR2(20 BYTE) SEFSC Pelegic Observer Program Trip ID number for the trip where this sample/observation was taken
100
carc_tag VARCHAR2(20 BYTE) Sample number assigned by observer. Is unique within a trip but not among trips.
100
specimen_number VARCHAR2(20 BYTE) Combination of the trip number and carc_tag/specimen number, is a unique value.
100
SPECIES VARCHAR2(20 BYTE) SPG=roundscale spearfish-2 ID criteria used. SPG_POT= potential roundscale, only single ID criterion used.
100
haul_number number Haul number where this sample/observation was taken
100
HAUL_DATE date Date when this sample/observation was taken.
100
Length number Lower jaw fork length, in cm, taken as curved measurement along the contour of the body.
100
Sex VARCHAR2(4 BYTE) Sex of speciemen, if known. 1=male, 2=female
100
lat_deg VARCHAR2(4 BYTE) Degree of latitude of the begin haul location for the haul where this sample/observation was taken
100
lat_min VARCHAR2(4 BYTE) Minute of latitude of the begin haul location for the haul where this sample/observation was taken
100
lon_deg VARCHAR2(4 BYTE) Degree of longitude of the begin haul location for the haul where this sample/observation was taken
100
lon_min VARCHAR2(4 BYTE) Minute of longitude of the begin haul location for the haul where this sample/observation was taken
100
AFA number Straight line measurement in cm from the posterior opening of the vent to the anterior origin of the first anal fin
100
AFH number Straight line measurement in CM of the height of the first anal fin
100
Relationship number =AFA divided by AFH, rounded to one decimal place.
100
AFA_LJFL number =AFA divided by lower jaw fork length length
100
DFSC VARCHAR2(2 BYTE) First dorsal fin spine count
100
AREA VARCHAR2(4 BYTE)3 NMFS HMS Statistical area where this sample/observation was taken
100
NUM_ID_CRITERIA VARCHAR2(1 BYTE) Number of ID criteria used to determine species ID.
100
AFA_AFH_METHOD VARCHAR2(5 BYTE) Method used to determine the AFA/AFH relationship
100
Body_length_1 number Measurement in mm; see reference measurement number 1 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
100
Body_girth_2 VARCHAR2(4 BYTE) Measurement in mm; see reference measurement number 2 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
100
First_predorsal_length_3 VARCHAR2(4 BYTE) Measurement in mm; see reference measurement number 3 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
100
Second_predorsal_length_4 VARCHAR2(4 BYTE) Measurement in mm; see reference measurement number 4 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
100
Prepectoral_length_5 VARCHAR2(4 BYTE) Measurement in mm; see reference measurement number 5 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
100
Prepelvic_length_6 VARCHAR2(4 BYTE) Measurement in mm; see reference measurement number 6 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
100
First_preanal_length_7 VARCHAR2(4 BYTE) Measurement in mm; see reference measurement number 7 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
100
Second_preanal_length_8 VARCHAR2(4 BYTE) Measurement in mm; see reference measurement number 8 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
100
Orig_D1_to_orig_P1_9 VARCHAR2(4 BYTE) Measurement in mm; see reference measurement number 9 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
100
Orig_D1_to_orig_P2_10 VARCHAR2(4 BYTE) Measurement in mm; see reference measurement number 10 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
100
Orig_D2_to_orig_A2_11 VARCHAR2(4 BYTE) Measurement in mm; see reference measurement number 11 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
100
Tip_mandible_to_anus VARCHAR2(4 BYTE) Measurement in mm; see reference measurement number for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
100
Orig_P2_to_nape_13 VARCHAR2(4 BYTE) Measurement in mm; see reference measurement number 13 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
100
Greatest_body_depth_14 VARCHAR2(4 BYTE) Measurement in mm; see reference measurement number 14 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
100
Depth_at_orig_D1_15 VARCHAR2(4 BYTE) Measurement in mm; see reference measurement number 15 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
100
Depth_at_orig_A1_16 VARCHAR2(4 BYTE) Measurement in mm; see reference measurement number 16 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
100
Least_depth_cp_17 VARCHAR2(4 BYTE) Measurement in mm; see reference measurement number 17 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
100
Width_at_P1_base_18 VARCHAR2(4 BYTE) Measurement in mm; see reference measurement number 18 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
100
Width_at_A1_orig_19 VARCHAR2(4 BYTE) Measurement in mm; see reference measurement number 19 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
100
Width_at_A2_orig_20 VARCHAR2(4 BYTE) Measurement in mm; see reference measurement number 20 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
100
Width_cp_front_of_keels VARCHAR2(4 BYTE) Measurement in mm; see reference measurement number for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
100
Length_of_upper_keel_22 VARCHAR2(4 BYTE) Measurement in mm; see reference measurement number 22 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
100
Length_of_lower_keel_23 VARCHAR2(4 BYTE) Measurement in mm; see reference measurement number 23 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
100
Head_length_24 VARCHAR2(4 BYTE) Measurement in mm; see reference measurement number 24 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
100
Snout_length_25 VARCHAR2(4 BYTE) Measurement in mm; see reference measurement number 25 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
100
Bill_length_26 VARCHAR2(4 BYTE) Measurement in mm; see reference measurement number 26 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
100
Maxillary_length_28 VARCHAR2(4 BYTE) Measurement in mm; see reference measurement number 28 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
100
Orbit_diameter_29 VARCHAR2(4 BYTE) Measurement in mm; see reference measurement number 29 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
100
Depth_of_bill_33 VARCHAR2(4 BYTE) Measurement in mm; see reference measurement number 33 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
100
Width_of_bill_34 VARCHAR2(4 BYTE) Measurement in mm; see reference measurement number for 34 details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
100
Height_D1_39 VARCHAR2(4 BYTE) Measurement in mm; see reference measurement number 39 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
100
Length_25th_D1_spine_40 VARCHAR2(4 BYTE) Measurement in mm; see reference measurement number 40 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
100
Height_D2_41 VARCHAR2(4 BYTE) Measurement in mm; see reference measurement number 41 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
100
Height_A1_42 VARCHAR2(4 BYTE) Measurement in mm; see reference measurement number 42 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
100
Height_A2_43 VARCHAR2(4 BYTE) Measurement in mm; see reference measurement number 43 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
100
Length_P1_44 VARCHAR2(4 BYTE) Measurement in mm; see reference measurement number 44 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
100
Length_P2_45 VARCHAR2(4 BYTE) Measurement in mm; see reference measurement number 45 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.
100
Length_last_D2_ray VARCHAR2(4 BYTE) Measurement in mm, length of second dorsal fin posterior ray
100
Length_last_A2_ray VARCHAR2(4 BYTE) Measurement in mm, length of second anal fin posterior ray
100
Orig_D1_to_Orig_D2 VARCHAR2(4 BYTE) Measurement in mm, straight line between the origin of the first dorsal fin to the origin of the second dorsal fin.
100
Anus_posterior_to_orig_A1 VARCHAR2(4 BYTE) Straight line measurement in mm from the posterior opening of the vent to the anterior origin of the fisrt anal fin
100
Anus_anterior_to_orig_A1 VARCHAR2(4 BYTE) Straight line measurement in mm from the anterior opening of the vent to the anterior origin of the fisrt anal fin
100
Dorsal_spines_D1 VARCHAR2(4 BYTE) Count of spines on first dorsal fin
100
Dorsal_rays_D1 VARCHAR2(4 BYTE) Count of rays on first dorsal fin
100
D1_elements VARCHAR2(4 BYTE) Total elements (spines + rays) on first dorsal fin
100
Anal_spines_A1 VARCHAR2(4 BYTE) Count of spines on first anal fin
100
Anal_rays_A1 VARCHAR2(4 BYTE) Count of rays on first anal fin
100
A1_elements VARCHAR2(4 BYTE) Total elements (spines + rays) on first anal fin
100
Pectoral_rays VARCHAR2(4 BYTE) Count of rays on pectoral fin
100
Precaudal_vertebrae VARCHAR2(4 BYTE) Count of precaudal vertebrae
100
Caudal_vertebrae VARCHAR2(4 BYTE) Count of caudal vertebrae

Attribute Details

TRIP

CC ID: 232085
Seq. Order: 1
Data Storage Type: VARCHAR2(20 BYTE)
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

SEFSC Pelegic Observer Program Trip ID number for the trip where this sample/observation was taken

carc_tag

CC ID: 232086
Seq. Order: 2
Data Storage Type: VARCHAR2(20 BYTE)
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

Sample number assigned by observer. Is unique within a trip but not among trips.

specimen_number

CC ID: 232114
Seq. Order: 3
Data Storage Type: VARCHAR2(20 BYTE)
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Combination of the trip number and carc_tag/specimen number, is a unique value.

SPECIES

CC ID: 232115
Seq. Order: 4
Data Storage Type: VARCHAR2(20 BYTE)
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

SPG=roundscale spearfish-2 ID criteria used.

SPG_POT= potential roundscale, only single ID criterion used.

haul_number

CC ID: 232116
Seq. Order: 5
Data Storage Type: number
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Haul number where this sample/observation was taken

HAUL_DATE

CC ID: 232117
Seq. Order: 6
Data Storage Type: date
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Date when this sample/observation was taken.

Length

CC ID: 232118
Seq. Order: 7
Data Storage Type: number
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Lower jaw fork length, in cm, taken as curved measurement along the contour of the body.

Sex

CC ID: 232119
Seq. Order: 8
Data Storage Type: VARCHAR2(4 BYTE)
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Sex of speciemen, if known. 1=male, 2=female

lat_deg

CC ID: 232120
Seq. Order: 9
Data Storage Type: VARCHAR2(4 BYTE)
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Degree of latitude of the begin haul location for the haul where this sample/observation was taken

lat_min

CC ID: 232121
Seq. Order: 9
Data Storage Type: VARCHAR2(4 BYTE)
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Minute of latitude of the begin haul location for the haul where this sample/observation was taken

lon_deg

CC ID: 232123
Seq. Order: 10
Data Storage Type: VARCHAR2(4 BYTE)
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Degree of longitude of the begin haul location for the haul where this sample/observation was taken

lon_min

CC ID: 232124
Seq. Order: 12
Data Storage Type: VARCHAR2(4 BYTE)
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Minute of longitude of the begin haul location for the haul where this sample/observation was taken

AFA

CC ID: 232125
Seq. Order: 13
Data Storage Type: number
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Straight line measurement in cm from the posterior opening of the vent to the anterior origin of the first anal fin

AFH

CC ID: 232126
Seq. Order: 14
Data Storage Type: number
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Straight line measurement in CM of the height of the first anal fin

Unit of Measure: cm

Relationship

CC ID: 232127
Seq. Order: 15
Data Storage Type: number
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

=AFA divided by AFH, rounded to one decimal place.

AFA_LJFL

CC ID: 232160
Seq. Order: 16
Data Storage Type: number
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

=AFA divided by lower jaw fork length length

DFSC

CC ID: 232546
Seq. Order: 17
Data Storage Type: VARCHAR2(2 BYTE)
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

First dorsal fin spine count

AREA

CC ID: 232548
Seq. Order: 18
Data Storage Type: VARCHAR2(4 BYTE)3
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

NMFS HMS Statistical area where this sample/observation was taken

NUM_ID_CRITERIA

CC ID: 232549
Seq. Order: 19
Data Storage Type: VARCHAR2(1 BYTE)
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Number of ID criteria used to determine species ID.

Allowed Values: 1= only one identification criterion was used (either scale morphology or AFA/AFH relationship). 2= both scale morphology and AFA/AFH relationship used to determine species ID

AFA_AFH_METHOD

CC ID: 232550
Seq. Order: 20
Data Storage Type: VARCHAR2(5 BYTE)
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Method used to determine the AFA/AFH relationship

Allowed Values: IMAGE=analysis done from image OBS=measured on board a vessel by an observer with a tape measure LAB=measured in the lab using a caliper

Body_length_1

CC ID: 232551
Seq. Order: 21
Data Storage Type: number
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Measurement in mm; see reference measurement number 1 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.

Body_girth_2

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

Measurement in mm; see reference measurement number 2 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.

First_predorsal_length_3

CC ID: 232553
Seq. Order: 23
Data Storage Type: VARCHAR2(4 BYTE)
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Measurement in mm; see reference measurement number 3 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.

Second_predorsal_length_4

CC ID: 232555
Seq. Order: 24
Data Storage Type: VARCHAR2(4 BYTE)
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Measurement in mm; see reference measurement number 4 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.

Prepectoral_length_5

CC ID: 232556
Seq. Order: 25
Data Storage Type: VARCHAR2(4 BYTE)
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Measurement in mm; see reference measurement number 5 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.

Prepelvic_length_6

CC ID: 232557
Seq. Order: 26
Data Storage Type: VARCHAR2(4 BYTE)
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Measurement in mm; see reference measurement number 6 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.

First_preanal_length_7

CC ID: 232558
Seq. Order: 27
Data Storage Type: VARCHAR2(4 BYTE)
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Measurement in mm; see reference measurement number 7 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.

Second_preanal_length_8

CC ID: 232559
Seq. Order: 28
Data Storage Type: VARCHAR2(4 BYTE)
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Measurement in mm; see reference measurement number 8 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.

Orig_D1_to_orig_P1_9

CC ID: 232560
Seq. Order: 29
Data Storage Type: VARCHAR2(4 BYTE)
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Measurement in mm; see reference measurement number 9 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.

Orig_D1_to_orig_P2_10

CC ID: 232561
Seq. Order: 30
Data Storage Type: VARCHAR2(4 BYTE)
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Measurement in mm; see reference measurement number 10 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.

Orig_D2_to_orig_A2_11

CC ID: 232562
Seq. Order: 31
Data Storage Type: VARCHAR2(4 BYTE)
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Measurement in mm; see reference measurement number 11 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.

Tip_mandible_to_anus

CC ID: 232563
Seq. Order: 32
Data Storage Type: VARCHAR2(4 BYTE)
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Measurement in mm; see reference measurement number for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.

Unit of Measure: mm

Orig_P2_to_nape_13

CC ID: 232564
Seq. Order: 33
Data Storage Type: VARCHAR2(4 BYTE)
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Measurement in mm; see reference measurement number 13 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.

Greatest_body_depth_14

CC ID: 232565
Seq. Order: 34
Data Storage Type: VARCHAR2(4 BYTE)
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Measurement in mm; see reference measurement number 14 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.

Depth_at_orig_D1_15

CC ID: 232566
Seq. Order: 35
Data Storage Type: VARCHAR2(4 BYTE)
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Measurement in mm; see reference measurement number 15 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.

Depth_at_orig_A1_16

CC ID: 232567
Seq. Order: 36
Data Storage Type: VARCHAR2(4 BYTE)
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Measurement in mm; see reference measurement number 16 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.

Least_depth_cp_17

CC ID: 234745
Seq. Order: 37
Data Storage Type: VARCHAR2(4 BYTE)
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Measurement in mm; see reference measurement number 17 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.

Width_at_P1_base_18

CC ID: 234746
Seq. Order: 38
Data Storage Type: VARCHAR2(4 BYTE)
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Measurement in mm; see reference measurement number 18 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.

Width_at_A1_orig_19

CC ID: 234747
Seq. Order: 39
Data Storage Type: VARCHAR2(4 BYTE)
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Measurement in mm; see reference measurement number 19 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.

Width_at_A2_orig_20

CC ID: 234748
Seq. Order: 40
Data Storage Type: VARCHAR2(4 BYTE)
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Measurement in mm; see reference measurement number 20 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.

Width_cp_front_of_keels

CC ID: 234749
Seq. Order: 41
Data Storage Type: VARCHAR2(4 BYTE)
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Measurement in mm; see reference measurement number for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.

Length_of_upper_keel_22

CC ID: 234750
Seq. Order: 42
Data Storage Type: VARCHAR2(4 BYTE)
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Measurement in mm; see reference measurement number 22 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.

Length_of_lower_keel_23

CC ID: 234751
Seq. Order: 43
Data Storage Type: VARCHAR2(4 BYTE)
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Measurement in mm; see reference measurement number 23 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.

Head_length_24

CC ID: 234752
Seq. Order: 44
Data Storage Type: VARCHAR2(4 BYTE)
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Measurement in mm; see reference measurement number 24 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.

Snout_length_25

CC ID: 234753
Seq. Order: 45
Data Storage Type: VARCHAR2(4 BYTE)
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Measurement in mm; see reference measurement number 25 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.

Bill_length_26

CC ID: 234754
Seq. Order: 46
Data Storage Type: VARCHAR2(4 BYTE)
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Measurement in mm; see reference measurement number 26 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.

Maxillary_length_28

CC ID: 234755
Seq. Order: 47
Data Storage Type: VARCHAR2(4 BYTE)
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Measurement in mm; see reference measurement number 28 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.

Orbit_diameter_29

CC ID: 234756
Seq. Order: 48
Data Storage Type: VARCHAR2(4 BYTE)
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Measurement in mm; see reference measurement number 29 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.

Depth_of_bill_33

CC ID: 234757
Seq. Order: 49
Data Storage Type: VARCHAR2(4 BYTE)
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Measurement in mm; see reference measurement number 33 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.

Width_of_bill_34

CC ID: 234758
Seq. Order: 50
Data Storage Type: VARCHAR2(4 BYTE)
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Measurement in mm; see reference measurement number for 34 details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.

Height_D1_39

CC ID: 234759
Seq. Order: 51
Data Storage Type: VARCHAR2(4 BYTE)
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Measurement in mm; see reference measurement number 39 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.

Length_25th_D1_spine_40

CC ID: 234760
Seq. Order: 52
Data Storage Type: VARCHAR2(4 BYTE)
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Measurement in mm; see reference measurement number 40 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.

Height_D2_41

CC ID: 234761
Seq. Order: 53
Data Storage Type: VARCHAR2(4 BYTE)
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Measurement in mm; see reference measurement number 41 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.

Height_A1_42

CC ID: 234762
Seq. Order: 54
Data Storage Type: VARCHAR2(4 BYTE)
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Measurement in mm; see reference measurement number 42 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.

Height_A2_43

CC ID: 234763
Seq. Order: 55
Data Storage Type: VARCHAR2(4 BYTE)
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Measurement in mm; see reference measurement number 43 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.

Length_P1_44

CC ID: 234764
Seq. Order: 56
Data Storage Type: VARCHAR2(4 BYTE)
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Measurement in mm; see reference measurement number 44 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.

Length_P2_45

CC ID: 234765
Seq. Order: 57
Data Storage Type: VARCHAR2(4 BYTE)
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Measurement in mm; see reference measurement number 45 for details: Rivas, L.R. (1956) Definitions and methods of measuring and counting in the billfishes (Istiophoridae, Xiphidae). Bull. Mar. Sci. Gulf. Caribb. 6: 18-27.

Length_last_D2_ray

CC ID: 234766
Seq. Order: 58
Data Storage Type: VARCHAR2(4 BYTE)
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Measurement in mm, length of second dorsal fin posterior ray

Length_last_A2_ray

CC ID: 234767
Seq. Order: 59
Data Storage Type: VARCHAR2(4 BYTE)
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Measurement in mm, length of second anal fin posterior ray

Orig_D1_to_Orig_D2

CC ID: 234768
Seq. Order: 60
Data Storage Type: VARCHAR2(4 BYTE)
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Measurement in mm, straight line between the origin of the first dorsal fin to the origin of the second dorsal fin.

Anus_posterior_to_orig_A1

CC ID: 234769
Seq. Order: 61
Data Storage Type: VARCHAR2(4 BYTE)
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Straight line measurement in mm from the posterior opening of the vent to the anterior origin of the fisrt anal fin

Anus_anterior_to_orig_A1

CC ID: 234770
Seq. Order: 62
Data Storage Type: VARCHAR2(4 BYTE)
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Straight line measurement in mm from the anterior opening of the vent to the anterior origin of the fisrt anal fin

Dorsal_spines_D1

CC ID: 234771
Seq. Order: 63
Data Storage Type: VARCHAR2(4 BYTE)
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Count of spines on first dorsal fin

Dorsal_rays_D1

CC ID: 234772
Seq. Order: 64
Data Storage Type: VARCHAR2(4 BYTE)
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Count of rays on first dorsal fin

D1_elements

CC ID: 234773
Seq. Order: 65
Data Storage Type: VARCHAR2(4 BYTE)
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Total elements (spines + rays) on first dorsal fin

Anal_spines_A1

CC ID: 234774
Seq. Order: 66
Data Storage Type: VARCHAR2(4 BYTE)
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Count of spines on first anal fin

Anal_rays_A1

CC ID: 234775
Seq. Order: 67
Data Storage Type: VARCHAR2(4 BYTE)
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Count of rays on first anal fin

A1_elements

CC ID: 234776
Seq. Order: 68
Data Storage Type: VARCHAR2(4 BYTE)
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Total elements (spines + rays) on first anal fin

Pectoral_rays

CC ID: 234777
Seq. Order: 69
Data Storage Type: VARCHAR2(4 BYTE)
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Count of rays on pectoral fin

Precaudal_vertebrae

CC ID: 234778
Seq. Order: 70
Data Storage Type: VARCHAR2(4 BYTE)
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Count of precaudal vertebrae

Caudal_vertebrae

CC ID: 234779
Seq. Order: 71
Data Storage Type: VARCHAR2(4 BYTE)
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Count of caudal vertebrae

Support Roles

Data Steward

CC ID: 262117
Date Effective From: 2004-07-01
Date Effective To:
Contact (Person): Beerkircher, Larry
Address: 75 Virginia Beach Drive
Miami, FL 33149
Email Address: lawrence.r.beerkircher@noaa.gov
Phone: 305-361-4290
Contact Instructions:

Email best. Office phone is 305-361-4290

Distributor

CC ID: 262120
Date Effective From: 2004
Date Effective To:
Contact (Person): Beerkircher, Larry
Address: 75 Virginia Beach Drive
Miami, FL 33149
Email Address: lawrence.r.beerkircher@noaa.gov
Phone: 305-361-4290

Metadata Contact

CC ID: 262118
Date Effective From: 2004
Date Effective To:
Contact (Person): Beerkircher, Larry
Address: 75 Virginia Beach Drive
Miami, FL 33149
Email Address: lawrence.r.beerkircher@noaa.gov
Phone: 305-361-4290

Point of Contact

CC ID: 262119
Date Effective From: 2004
Date Effective To:
Contact (Person): Beerkircher, Larry
Address: 75 Virginia Beach Drive
Miami, FL 33149
Email Address: lawrence.r.beerkircher@noaa.gov
Phone: 305-361-4290
View Historical Support Roles

Child Items

Rubric scores updated every 15m

Rubric Score Type Title
Procedure Data Table

Catalog Details

Catalog Item ID: 27932
GUID: gov.noaa.nmfs.inport:27932
Metadata Record Created By: Larry Beerkircher
Metadata Record Created: 2015-10-13 08:45+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-05-06
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-05-06