Data Table
Southeast Fisheries Science Center
Entity
(ENT)
| ID: 27932
| Published / External
Created: 2015-10-13
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 30419
ID: 27932
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | Data Table |
---|---|
Short Name | Morphological and meristic data |
* Status | Completed |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract | |
* Purpose | |
Notes | |
Other Citation Details | |
• Supplemental Information | |
DOI (Digital Object Identifier) | |
DOI Registration Authority | |
DOI Issue Date |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
None | abundance |
None | billfish |
None | distribution |
None | morphology |
None | morphometrics |
None | Spearfish |
Temporal Keywords
Thesaurus | Keyword |
---|---|
* Spatial Keywords
Thesaurus | Keyword |
---|---|
None | northwestern Atlantic |
Stratum Keywords
Thesaurus | Keyword |
---|---|
Instrument Keywords
Thesaurus | Keyword |
---|---|
Platform Keywords
Thesaurus | Keyword |
---|---|
Physical Location
• » Organization | |
---|---|
• » City | |
• » State/Province | |
• Country | |
• » Location Description |
Entity Information
Entity Type | |
---|---|
Active Version? | |
Alias | |
Schema Name | |
» Description | |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | No | No | TRIP | VARCHAR2(20 BYTE) | SEFSC Pelegic Observer Program Trip ID number for the trip where this sample/observation was taken |
100 | No | No | carc_tag | VARCHAR2(20 BYTE) | Sample number assigned by observer. Is unique within a trip but not among trips. |
100 | No | No | specimen_number | VARCHAR2(20 BYTE) | Combination of the trip number and carc_tag/specimen number, is a unique value. |
100 | No | No | SPECIES | VARCHAR2(20 BYTE) | SPG=roundscale spearfish-2 ID criteria used. SPG_POT= potential roundscale, only single ID criterion used. |
100 | No | No | haul_number | number | Haul number where this sample/observation was taken |
100 | No | No | HAUL_DATE | date | Date when this sample/observation was taken. |
100 | No | No | Length | number | Lower jaw fork length, in cm, taken as curved measurement along the contour of the body. |
100 | No | No | Sex | VARCHAR2(4 BYTE) | Sex of speciemen, if known. 1=male, 2=female |
100 | No | No | lat_deg | VARCHAR2(4 BYTE) | Degree of latitude of the begin haul location for the haul where this sample/observation was taken |
100 | No | No | lat_min | VARCHAR2(4 BYTE) | Minute of latitude of the begin haul location for the haul where this sample/observation was taken |
100 | No | No | lon_deg | VARCHAR2(4 BYTE) | Degree of longitude of the begin haul location for the haul where this sample/observation was taken |
100 | No | No | lon_min | VARCHAR2(4 BYTE) | Minute of longitude of the begin haul location for the haul where this sample/observation was taken |
100 | No | No | AFA | number | Straight line measurement in cm from the posterior opening of the vent to the anterior origin of the first anal fin |
100 | No | No | AFH | number | Straight line measurement in CM of the height of the first anal fin |
100 | No | No | Relationship | number | =AFA divided by AFH, rounded to one decimal place. |
100 | No | No | AFA_LJFL | number | =AFA divided by lower jaw fork length length |
100 | No | No | DFSC | VARCHAR2(2 BYTE) | First dorsal fin spine count |
100 | No | No | AREA | VARCHAR2(4 BYTE)3 | NMFS HMS Statistical area where this sample/observation was taken |
100 | No | No | NUM_ID_CRITERIA | VARCHAR2(1 BYTE) | Number of ID criteria used to determine species ID. |
100 | No | No | AFA_AFH_METHOD | VARCHAR2(5 BYTE) | Method used to determine the AFA/AFH relationship |
100 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | Length_last_D2_ray | VARCHAR2(4 BYTE) | Measurement in mm, length of second dorsal fin posterior ray |
100 | No | No | Length_last_A2_ray | VARCHAR2(4 BYTE) | Measurement in mm, length of second anal fin posterior ray |
100 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | Dorsal_spines_D1 | VARCHAR2(4 BYTE) | Count of spines on first dorsal fin |
100 | No | No | Dorsal_rays_D1 | VARCHAR2(4 BYTE) | Count of rays on first dorsal fin |
100 | No | No | D1_elements | VARCHAR2(4 BYTE) | Total elements (spines + rays) on first dorsal fin |
100 | No | No | Anal_spines_A1 | VARCHAR2(4 BYTE) | Count of spines on first anal fin |
100 | No | No | Anal_rays_A1 | VARCHAR2(4 BYTE) | Count of rays on first anal fin |
100 | No | No | A1_elements | VARCHAR2(4 BYTE) | Total elements (spines + rays) on first anal fin |
100 | No | No | Pectoral_rays | VARCHAR2(4 BYTE) | Count of rays on pectoral fin |
100 | No | No | Precaudal_vertebrae | VARCHAR2(4 BYTE) | Count of precaudal vertebrae |
100 | No | No | Caudal_vertebrae | VARCHAR2(4 BYTE) | Count of caudal vertebrae |
Attribute Details
Attribute Name | TRIP |
---|---|
Seq. Order | 1 |
Data Storage Type | VARCHAR2(20 BYTE) |
Max Length | 6 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
SEFSC Pelegic Observer Program Trip ID number for the trip where this sample/observation was taken |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | carc_tag |
---|---|
Seq. Order | 2 |
Data Storage Type | VARCHAR2(20 BYTE) |
Max Length | 6 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Sample number assigned by observer. Is unique within a trip but not among trips. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | specimen_number |
---|---|
Seq. Order | 3 |
Data Storage Type | VARCHAR2(20 BYTE) |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Combination of the trip number and carc_tag/specimen number, is a unique value. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SPECIES |
---|---|
Seq. Order | 4 |
Data Storage Type | VARCHAR2(20 BYTE) |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
SPG=roundscale spearfish-2 ID criteria used. SPG_POT= potential roundscale, only single ID criterion used. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | haul_number |
---|---|
Seq. Order | 5 |
Data Storage Type | number |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Haul number where this sample/observation was taken |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | HAUL_DATE |
---|---|
Seq. Order | 6 |
Data Storage Type | date |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date when this sample/observation was taken. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Length |
---|---|
Seq. Order | 7 |
Data Storage Type | number |
Max Length | 5 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Lower jaw fork length, in cm, taken as curved measurement along the contour of the body. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Sex |
---|---|
Seq. Order | 8 |
Data Storage Type | VARCHAR2(4 BYTE) |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Sex of speciemen, if known. 1=male, 2=female |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | lat_deg |
---|---|
Seq. Order | 9 |
Data Storage Type | VARCHAR2(4 BYTE) |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Degree of latitude of the begin haul location for the haul where this sample/observation was taken |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | lat_min |
---|---|
Seq. Order | 9 |
Data Storage Type | VARCHAR2(4 BYTE) |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Minute of latitude of the begin haul location for the haul where this sample/observation was taken |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | lon_deg |
---|---|
Seq. Order | 10 |
Data Storage Type | VARCHAR2(4 BYTE) |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Degree of longitude of the begin haul location for the haul where this sample/observation was taken |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | lon_min |
---|---|
Seq. Order | 12 |
Data Storage Type | VARCHAR2(4 BYTE) |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Minute of longitude of the begin haul location for the haul where this sample/observation was taken |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | AFA |
---|---|
Seq. Order | 13 |
Data Storage Type | number |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Straight line measurement in cm from the posterior opening of the vent to the anterior origin of the first anal fin |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | AFH |
---|---|
Seq. Order | 14 |
Data Storage Type | number |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Straight line measurement in CM of the height of the first anal fin |
General Data Type | |
Unit of Measure | cm |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Relationship |
---|---|
Seq. Order | 15 |
Data Storage Type | number |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
=AFA divided by AFH, rounded to one decimal place. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | AFA_LJFL |
---|---|
Seq. Order | 16 |
Data Storage Type | number |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
=AFA divided by lower jaw fork length length |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DFSC |
---|---|
Seq. Order | 17 |
Data Storage Type | VARCHAR2(2 BYTE) |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
First dorsal fin spine count |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | AREA |
---|---|
Seq. Order | 18 |
Data Storage Type | VARCHAR2(4 BYTE)3 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
NMFS HMS Statistical area where this sample/observation was taken |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NUM_ID_CRITERIA |
---|---|
Seq. Order | 19 |
Data Storage Type | VARCHAR2(1 BYTE) |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Number of ID criteria used to determine species ID. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
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 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | AFA_AFH_METHOD |
---|---|
Seq. Order | 20 |
Data Storage Type | VARCHAR2(5 BYTE) |
Max Length | 5 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Method used to determine the AFA/AFH relationship |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
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 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Body_length_1 |
---|---|
Seq. Order | 21 |
Data Storage Type | number |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Body_girth_2 |
---|---|
Seq. Order | 22 |
Data Storage Type | VARCHAR2(4 BYTE) |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | First_predorsal_length_3 |
---|---|
Seq. Order | 23 |
Data Storage Type | VARCHAR2(4 BYTE) |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Second_predorsal_length_4 |
---|---|
Seq. Order | 24 |
Data Storage Type | VARCHAR2(4 BYTE) |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Prepectoral_length_5 |
---|---|
Seq. Order | 25 |
Data Storage Type | VARCHAR2(4 BYTE) |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Prepelvic_length_6 |
---|---|
Seq. Order | 26 |
Data Storage Type | VARCHAR2(4 BYTE) |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | First_preanal_length_7 |
---|---|
Seq. Order | 27 |
Data Storage Type | VARCHAR2(4 BYTE) |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Second_preanal_length_8 |
---|---|
Seq. Order | 28 |
Data Storage Type | VARCHAR2(4 BYTE) |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Orig_D1_to_orig_P1_9 |
---|---|
Seq. Order | 29 |
Data Storage Type | VARCHAR2(4 BYTE) |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Orig_D1_to_orig_P2_10 |
---|---|
Seq. Order | 30 |
Data Storage Type | VARCHAR2(4 BYTE) |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Orig_D2_to_orig_A2_11 |
---|---|
Seq. Order | 31 |
Data Storage Type | VARCHAR2(4 BYTE) |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Tip_mandible_to_anus |
---|---|
Seq. Order | 32 |
Data Storage Type | VARCHAR2(4 BYTE) |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | mm |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Orig_P2_to_nape_13 |
---|---|
Seq. Order | 33 |
Data Storage Type | VARCHAR2(4 BYTE) |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Greatest_body_depth_14 |
---|---|
Seq. Order | 34 |
Data Storage Type | VARCHAR2(4 BYTE) |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Depth_at_orig_D1_15 |
---|---|
Seq. Order | 35 |
Data Storage Type | VARCHAR2(4 BYTE) |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Depth_at_orig_A1_16 |
---|---|
Seq. Order | 36 |
Data Storage Type | VARCHAR2(4 BYTE) |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Least_depth_cp_17 |
---|---|
Seq. Order | 37 |
Data Storage Type | VARCHAR2(4 BYTE) |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Width_at_P1_base_18 |
---|---|
Seq. Order | 38 |
Data Storage Type | VARCHAR2(4 BYTE) |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Width_at_A1_orig_19 |
---|---|
Seq. Order | 39 |
Data Storage Type | VARCHAR2(4 BYTE) |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Width_at_A2_orig_20 |
---|---|
Seq. Order | 40 |
Data Storage Type | VARCHAR2(4 BYTE) |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Width_cp_front_of_keels |
---|---|
Seq. Order | 41 |
Data Storage Type | VARCHAR2(4 BYTE) |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Length_of_upper_keel_22 |
---|---|
Seq. Order | 42 |
Data Storage Type | VARCHAR2(4 BYTE) |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Length_of_lower_keel_23 |
---|---|
Seq. Order | 43 |
Data Storage Type | VARCHAR2(4 BYTE) |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Head_length_24 |
---|---|
Seq. Order | 44 |
Data Storage Type | VARCHAR2(4 BYTE) |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Snout_length_25 |
---|---|
Seq. Order | 45 |
Data Storage Type | VARCHAR2(4 BYTE) |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Bill_length_26 |
---|---|
Seq. Order | 46 |
Data Storage Type | VARCHAR2(4 BYTE) |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Maxillary_length_28 |
---|---|
Seq. Order | 47 |
Data Storage Type | VARCHAR2(4 BYTE) |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Orbit_diameter_29 |
---|---|
Seq. Order | 48 |
Data Storage Type | VARCHAR2(4 BYTE) |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Depth_of_bill_33 |
---|---|
Seq. Order | 49 |
Data Storage Type | VARCHAR2(4 BYTE) |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Width_of_bill_34 |
---|---|
Seq. Order | 50 |
Data Storage Type | VARCHAR2(4 BYTE) |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Height_D1_39 |
---|---|
Seq. Order | 51 |
Data Storage Type | VARCHAR2(4 BYTE) |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Length_25th_D1_spine_40 |
---|---|
Seq. Order | 52 |
Data Storage Type | VARCHAR2(4 BYTE) |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Height_D2_41 |
---|---|
Seq. Order | 53 |
Data Storage Type | VARCHAR2(4 BYTE) |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Height_A1_42 |
---|---|
Seq. Order | 54 |
Data Storage Type | VARCHAR2(4 BYTE) |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Height_A2_43 |
---|---|
Seq. Order | 55 |
Data Storage Type | VARCHAR2(4 BYTE) |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Length_P1_44 |
---|---|
Seq. Order | 56 |
Data Storage Type | VARCHAR2(4 BYTE) |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Length_P2_45 |
---|---|
Seq. Order | 57 |
Data Storage Type | VARCHAR2(4 BYTE) |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Length_last_D2_ray |
---|---|
Seq. Order | 58 |
Data Storage Type | VARCHAR2(4 BYTE) |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Measurement in mm, length of second dorsal fin posterior ray |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Length_last_A2_ray |
---|---|
Seq. Order | 59 |
Data Storage Type | VARCHAR2(4 BYTE) |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Measurement in mm, length of second anal fin posterior ray |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Orig_D1_to_Orig_D2 |
---|---|
Seq. Order | 60 |
Data Storage Type | VARCHAR2(4 BYTE) |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Measurement in mm, straight line between the origin of the first dorsal fin to the origin of the second dorsal fin. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Anus_posterior_to_orig_A1 |
---|---|
Seq. Order | 61 |
Data Storage Type | VARCHAR2(4 BYTE) |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Straight line measurement in mm from the posterior opening of the vent to the anterior origin of the fisrt anal fin |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Anus_anterior_to_orig_A1 |
---|---|
Seq. Order | 62 |
Data Storage Type | VARCHAR2(4 BYTE) |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Straight line measurement in mm from the anterior opening of the vent to the anterior origin of the fisrt anal fin |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Dorsal_spines_D1 |
---|---|
Seq. Order | 63 |
Data Storage Type | VARCHAR2(4 BYTE) |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Count of spines on first dorsal fin |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Dorsal_rays_D1 |
---|---|
Seq. Order | 64 |
Data Storage Type | VARCHAR2(4 BYTE) |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Count of rays on first dorsal fin |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | D1_elements |
---|---|
Seq. Order | 65 |
Data Storage Type | VARCHAR2(4 BYTE) |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Total elements (spines + rays) on first dorsal fin |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Anal_spines_A1 |
---|---|
Seq. Order | 66 |
Data Storage Type | VARCHAR2(4 BYTE) |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Count of spines on first anal fin |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Anal_rays_A1 |
---|---|
Seq. Order | 67 |
Data Storage Type | VARCHAR2(4 BYTE) |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Count of rays on first anal fin |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | A1_elements |
---|---|
Seq. Order | 68 |
Data Storage Type | VARCHAR2(4 BYTE) |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Total elements (spines + rays) on first anal fin |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Pectoral_rays |
---|---|
Seq. Order | 69 |
Data Storage Type | VARCHAR2(4 BYTE) |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Count of rays on pectoral fin |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Precaudal_vertebrae |
---|---|
Seq. Order | 70 |
Data Storage Type | VARCHAR2(4 BYTE) |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Count of precaudal vertebrae |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Caudal_vertebrae |
---|---|
Seq. Order | 71 |
Data Storage Type | VARCHAR2(4 BYTE) |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Count of caudal vertebrae |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Support Roles
* » Support Role | Data Steward |
---|---|
* » Date Effective From | 2004-07-01 |
Date Effective To | |
Person | Beerkircher, Larry |
Address |
75 Virginia Beach Drive Miami, FL 33149 |
Email Address | lawrence.r.beerkircher@noaa.gov |
Phone | 305-361-4290 |
Fax | |
Mobile | |
URL | |
Business Hours | |
Contact Instructions |
Email best. Office phone is 305-361-4290 |
* » Support Role | Distributor |
---|---|
* » Date Effective From | 2004 |
Date Effective To | |
Person | Beerkircher, Larry |
Address |
75 Virginia Beach Drive Miami, FL 33149 |
Email Address | lawrence.r.beerkircher@noaa.gov |
Phone | 305-361-4290 |
Fax | |
Mobile | |
URL | |
Business Hours | |
Contact Instructions |
* » Support Role | Metadata Contact |
---|---|
* » Date Effective From | 2004 |
Date Effective To | |
Person | Beerkircher, Larry |
Address |
75 Virginia Beach Drive Miami, FL 33149 |
Email Address | lawrence.r.beerkircher@noaa.gov |
Phone | 305-361-4290 |
Fax | |
Mobile | |
URL | |
Business Hours | |
Contact Instructions |
* » Support Role | Originator |
---|---|
* » Date Effective From | 1993 |
Date Effective To | 2004 |
Organization | Southeast Fisheries Science Center (SEFSC) |
Address |
75 Virginia Beach Drive Miami, FL 33149 USA |
Email Address | |
Phone | (305)361-5761 |
Fax | |
Mobile | |
URL | https://www.fisheries.noaa.gov/about/southeast-fisheries-science-center |
Business Hours | 8:00 a.m. - 4:30 p.m. EST |
Contact Instructions |
Dennis Lee initiated data collection. He retired in 2006. |
* » Support Role | Point of Contact |
---|---|
* » Date Effective From | 2004 |
Date Effective To | |
Person | Beerkircher, Larry |
Address |
75 Virginia Beach Drive Miami, FL 33149 |
Email Address | lawrence.r.beerkircher@noaa.gov |
Phone | 305-361-4290 |
Fax | |
Mobile | |
URL | |
Business Hours | |
Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
Extents
Currentness Reference |
---|
Extent Group 1
Extent Description |
---|
Extent Group 1 / Geographic Area
* » W° Bound | |
---|---|
* » E° Bound | |
* » N° Bound | |
* » S° Bound | |
* » Description |
Extent Group 1 / Vertical Extent
EPSG Code | |
---|---|
Vertical Minimum | |
Vertical Maximum |
Extent Group 1 / Time Frame
* » Time Frame Type | |
---|---|
* » Start | |
End | |
Alternate Start as of Info | |
Alternate End as of Info | |
Description |
Access Information
* » Security Class | |
---|---|
* Security Classification System |
|
Security Handling Description |
|
• Data Access Policy |
|
» Data Access Procedure |
|
• » Data Access Constraints |
|
• Data Use Constraints |
|
Metadata Access Constraints |
|
Metadata Use Constraints |
|
Distribution Information
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Activity Log
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Issues
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
FAQs
Date | |
---|---|
Author | |
Question | |
Answer |
Related Items
Item Type | Relationship Type | Title |
---|---|---|
Catalog Details
Catalog Item ID | 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 Workflow State | Published / External |
Metadata Last Review Date | 2021-05-06 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2022-05-06 |
Tags |
---|