Metadata Rubric

67%

4 / 6

SEFSC Metadata Library > Fisheries Statistics Division > Fisheries Sampling Branch > Roundscale Spearfish (Tetrapturus georgii) morp... > ROUNDSCALE SPEARFISH general morphometric data >

Data Table

Entity (ENT) | Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:27932 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Keywords

Data Attributes

Support Roles

Child Items

Catalog Details

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

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)

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

Type	Title
Procedure	Data Table

Type

Title

Procedure

Data Table

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

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

Theme Keywords

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

Thesaurus

Keyword

UNCONTROLLED

None

abundance

None

billfish

None

distribution

None

morphology

None

morphometrics

None

Spearfish

Spatial Keywords

Thesaurus	Keyword
UNCONTROLLED
None	northwestern Atlantic

Thesaurus

Keyword

UNCONTROLLED

None

northwestern Atlantic

Attribute Summary

	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

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

100

Body_girth_2

VARCHAR2(4 BYTE)

100

First_predorsal_length_3

VARCHAR2(4 BYTE)

100

Second_predorsal_length_4

VARCHAR2(4 BYTE)

100

Prepectoral_length_5

VARCHAR2(4 BYTE)

100

Prepelvic_length_6

VARCHAR2(4 BYTE)

100

First_preanal_length_7

VARCHAR2(4 BYTE)

100

Second_preanal_length_8

VARCHAR2(4 BYTE)

100

Orig_D1_to_orig_P1_9

VARCHAR2(4 BYTE)

100

Orig_D1_to_orig_P2_10

VARCHAR2(4 BYTE)

100

Orig_D2_to_orig_A2_11

VARCHAR2(4 BYTE)

100

Tip_mandible_to_anus

VARCHAR2(4 BYTE)

100

Orig_P2_to_nape_13

VARCHAR2(4 BYTE)

100

Greatest_body_depth_14

VARCHAR2(4 BYTE)

100

Depth_at_orig_D1_15

VARCHAR2(4 BYTE)

100

Depth_at_orig_A1_16

VARCHAR2(4 BYTE)

100

Least_depth_cp_17

VARCHAR2(4 BYTE)

100

Width_at_P1_base_18

VARCHAR2(4 BYTE)

100

Width_at_A1_orig_19

VARCHAR2(4 BYTE)

100

Width_at_A2_orig_20

VARCHAR2(4 BYTE)

100

Width_cp_front_of_keels

VARCHAR2(4 BYTE)

100

Length_of_upper_keel_22

VARCHAR2(4 BYTE)

100

Length_of_lower_keel_23

VARCHAR2(4 BYTE)

100

Head_length_24

VARCHAR2(4 BYTE)

100

Snout_length_25

VARCHAR2(4 BYTE)

100

Bill_length_26

VARCHAR2(4 BYTE)

100

Maxillary_length_28

VARCHAR2(4 BYTE)

100

Orbit_diameter_29

VARCHAR2(4 BYTE)

100

Depth_of_bill_33

VARCHAR2(4 BYTE)

100

Width_of_bill_34

VARCHAR2(4 BYTE)

100

Height_D1_39

VARCHAR2(4 BYTE)

100

Length_25th_D1_spine_40

VARCHAR2(4 BYTE)

100

Height_D2_41

VARCHAR2(4 BYTE)

100

Height_A1_42

VARCHAR2(4 BYTE)

100

Height_A2_43

VARCHAR2(4 BYTE)

100

Length_P1_44

VARCHAR2(4 BYTE)

100

Length_P2_45

VARCHAR2(4 BYTE)

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

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

Rubric scores updated every 15m

Type

Title

Procedure

Data Table

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

Summary

Entity Information

Child Items

Contact Information

Item Identification

Keywords

Theme Keywords

Spatial Keywords

Data Attributes

Attribute Summary

Attribute Details

TRIP

carc_tag

specimen_number

SPECIES

haul_number

HAUL_DATE

Length

Sex

lat_deg

lat_min

lon_deg

lon_min

AFA

AFH

Relationship

AFA_LJFL

DFSC

AREA

NUM_ID_CRITERIA

AFA_AFH_METHOD

Body_length_1

Body_girth_2

First_predorsal_length_3

Second_predorsal_length_4

Prepectoral_length_5

Prepelvic_length_6

First_preanal_length_7

Second_preanal_length_8

Orig_D1_to_orig_P1_9

Orig_D1_to_orig_P2_10

Orig_D2_to_orig_A2_11

Tip_mandible_to_anus

Orig_P2_to_nape_13

Greatest_body_depth_14

Depth_at_orig_D1_15

Depth_at_orig_A1_16

Least_depth_cp_17

Width_at_P1_base_18

Width_at_A1_orig_19

Width_at_A2_orig_20

Width_cp_front_of_keels

Length_of_upper_keel_22

Length_of_lower_keel_23

Head_length_24

Snout_length_25

Bill_length_26

Maxillary_length_28

Orbit_diameter_29

Depth_of_bill_33

Width_of_bill_34

Height_D1_39

Length_25th_D1_spine_40

Height_D2_41

Height_A1_42

Height_A2_43

Length_P1_44

Length_P2_45

Length_last_D2_ray

Length_last_A2_ray

Orig_D1_to_Orig_D2

Anus_posterior_to_orig_A1

Anus_anterior_to_orig_A1

Dorsal_spines_D1

Dorsal_rays_D1

D1_elements

Anal_spines_A1

Anal_rays_A1

A1_elements

Pectoral_rays