27932
Data Table
Morphological and meristic data
Entity
Published / External
30419
ROUNDSCALE SPEARFISH general morphometric data
Data Set
Completed
Theme
Spearfish
Theme
abundance
Theme
billfish
Theme
distribution
Theme
morphology
Theme
morphometrics
Spatial
northwestern Atlantic
1
TRIP
VARCHAR2(20 BYTE)
6
No
No
Active
SEFSC Pelegic Observer Program Trip ID number for the trip where this sample/observation was taken
2
carc_tag
VARCHAR2(20 BYTE)
6
No
No
Active
Sample number assigned by observer. Is unique within a trip but not among trips.
3
specimen_number
VARCHAR2(20 BYTE)
8
No
No
Active
Combination of the trip number and carc_tag/specimen number, is a unique value.
4
SPECIES
VARCHAR2(20 BYTE)
7
No
No
Active
SPG=roundscale spearfish-2 ID criteria used.
SPG_POT= potential roundscale, only single ID criterion used.
5
haul_number
number
2
No
No
Active
Haul number where this sample/observation was taken
6
HAUL_DATE
date
10
No
No
Active
Date when this sample/observation was taken.
7
Length
number
5
No
No
Active
Lower jaw fork length, in cm, taken as curved measurement along the contour of the body.
8
Sex
VARCHAR2(4 BYTE)
3
No
No
Active
Sex of speciemen, if known. 1=male, 2=female
9
lat_deg
VARCHAR2(4 BYTE)
4
No
No
Active
Degree of latitude of the begin haul location for the haul where this sample/observation was taken
9
lat_min
VARCHAR2(4 BYTE)
4
No
No
Active
Minute of latitude of the begin haul location for the haul where this sample/observation was taken
10
lon_deg
VARCHAR2(4 BYTE)
4
No
No
Active
Degree of longitude of the begin haul location for the haul where this sample/observation was taken
12
lon_min
VARCHAR2(4 BYTE)
4
No
No
Active
Minute of longitude of the begin haul location for the haul where this sample/observation was taken
13
AFA
number
4
No
No
Active
Straight line measurement in cm from the posterior opening of the vent to the anterior origin of the first anal fin
14
AFH
number
4
No
No
Active
Straight line measurement in CM of the height of the first anal fin
cm
15
Relationship
number
4
No
No
Active
=AFA divided by AFH, rounded to one decimal place.
16
AFA_LJFL
number
4
No
No
Active
=AFA divided by lower jaw fork length length
17
DFSC
VARCHAR2(2 BYTE)
2
No
No
Active
First dorsal fin spine count
18
AREA
VARCHAR2(4 BYTE)3
3
No
No
Active
NMFS HMS Statistical area where this sample/observation was taken
19
NUM_ID_CRITERIA
VARCHAR2(1 BYTE)
1
No
No
Active
Number of ID criteria used to determine species ID.
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
20
AFA_AFH_METHOD
VARCHAR2(5 BYTE)
5
No
No
Active
Method used to determine the AFA/AFH relationship
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
21
Body_length_1
number
4
No
No
Active
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.
22
Body_girth_2
VARCHAR2(4 BYTE)
4
No
No
Active
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.
23
First_predorsal_length_3
VARCHAR2(4 BYTE)
4
No
No
Active
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.
24
Second_predorsal_length_4
VARCHAR2(4 BYTE)
4
No
No
Active
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.
25
Prepectoral_length_5
VARCHAR2(4 BYTE)
4
No
No
Active
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.
26
Prepelvic_length_6
VARCHAR2(4 BYTE)
4
No
No
Active
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.
27
First_preanal_length_7
VARCHAR2(4 BYTE)
4
No
No
Active
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.
28
Second_preanal_length_8
VARCHAR2(4 BYTE)
4
No
No
Active
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.
29
Orig_D1_to_orig_P1_9
VARCHAR2(4 BYTE)
4
No
No
Active
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.
30
Orig_D1_to_orig_P2_10
VARCHAR2(4 BYTE)
4
No
No
Active
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.
31
Orig_D2_to_orig_A2_11
VARCHAR2(4 BYTE)
4
No
No
Active
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.
32
Tip_mandible_to_anus
VARCHAR2(4 BYTE)
4
No
No
Active
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.
mm
33
Orig_P2_to_nape_13
VARCHAR2(4 BYTE)
4
No
No
Active
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.
34
Greatest_body_depth_14
VARCHAR2(4 BYTE)
4
No
No
Active
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.
35
Depth_at_orig_D1_15
VARCHAR2(4 BYTE)
4
No
No
Active
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.
36
Depth_at_orig_A1_16
VARCHAR2(4 BYTE)
4
No
No
Active
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.
37
Least_depth_cp_17
VARCHAR2(4 BYTE)
4
No
No
Active
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.
38
Width_at_P1_base_18
VARCHAR2(4 BYTE)
4
No
No
Active
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.
39
Width_at_A1_orig_19
VARCHAR2(4 BYTE)
4
No
No
Active
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.
40
Width_at_A2_orig_20
VARCHAR2(4 BYTE)
4
No
No
Active
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.
41
Width_cp_front_of_keels
VARCHAR2(4 BYTE)
4
No
No
Active
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.
42
Length_of_upper_keel_22
VARCHAR2(4 BYTE)
4
No
No
Active
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.
43
Length_of_lower_keel_23
VARCHAR2(4 BYTE)
4
No
No
Active
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.
44
Head_length_24
VARCHAR2(4 BYTE)
4
No
No
Active
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.
45
Snout_length_25
VARCHAR2(4 BYTE)
4
No
No
Active
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.
46
Bill_length_26
VARCHAR2(4 BYTE)
4
No
No
Active
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.
47
Maxillary_length_28
VARCHAR2(4 BYTE)
4
No
No
Active
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.
48
Orbit_diameter_29
VARCHAR2(4 BYTE)
4
No
No
Active
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.
49
Depth_of_bill_33
VARCHAR2(4 BYTE)
4
No
No
Active
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.
50
Width_of_bill_34
VARCHAR2(4 BYTE)
4
No
No
Active
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.
51
Height_D1_39
VARCHAR2(4 BYTE)
4
No
No
Active
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.
52
Length_25th_D1_spine_40
VARCHAR2(4 BYTE)
4
No
No
Active
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.
53
Height_D2_41
VARCHAR2(4 BYTE)
4
No
No
Active
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.
54
Height_A1_42
VARCHAR2(4 BYTE)
4
No
No
Active
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.
55
Height_A2_43
VARCHAR2(4 BYTE)
4
No
No
Active
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.
56
Length_P1_44
VARCHAR2(4 BYTE)
4
No
No
Active
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.
57
Length_P2_45
VARCHAR2(4 BYTE)
4
No
No
Active
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.
58
Length_last_D2_ray
VARCHAR2(4 BYTE)
4
No
No
Active
Measurement in mm, length of second dorsal fin posterior ray
59
Length_last_A2_ray
VARCHAR2(4 BYTE)
4
No
No
Active
Measurement in mm, length of second anal fin posterior ray
60
Orig_D1_to_Orig_D2
VARCHAR2(4 BYTE)
4
No
No
Active
Measurement in mm, straight line between the origin of the first dorsal fin to the origin of the second dorsal fin.
61
Anus_posterior_to_orig_A1
VARCHAR2(4 BYTE)
4
No
No
Active
Straight line measurement in mm from the posterior opening of the vent to the anterior origin of the fisrt anal fin
62
Anus_anterior_to_orig_A1
VARCHAR2(4 BYTE)
4
No
No
Active
Straight line measurement in mm from the anterior opening of the vent to the anterior origin of the fisrt anal fin
63
Dorsal_spines_D1
VARCHAR2(4 BYTE)
4
No
No
Active
Count of spines on first dorsal fin
64
Dorsal_rays_D1
VARCHAR2(4 BYTE)
4
No
No
Active
Count of rays on first dorsal fin
65
D1_elements
VARCHAR2(4 BYTE)
4
No
No
Active
Total elements (spines + rays) on first dorsal fin
66
Anal_spines_A1
VARCHAR2(4 BYTE)
4
No
No
Active
Count of spines on first anal fin
67
Anal_rays_A1
VARCHAR2(4 BYTE)
4
No
No
Active
Count of rays on first anal fin
68
A1_elements
VARCHAR2(4 BYTE)
4
No
No
Active
Total elements (spines + rays) on first anal fin
69
Pectoral_rays
VARCHAR2(4 BYTE)
4
No
No
Active
Count of rays on pectoral fin
70
Precaudal_vertebrae
VARCHAR2(4 BYTE)
4
No
No
Active
Count of precaudal vertebrae
71
Caudal_vertebrae
VARCHAR2(4 BYTE)
4
No
No
Active
Count of caudal vertebrae
Data Steward
2004-07-01
Person
Beerkircher, Larry
lawrence.r.beerkircher@noaa.gov
75 Virginia Beach Drive
Miami
FL
33149
305-361-4290
Email best. Office phone is 305-361-4290
Distributor
2004
Person
Beerkircher, Larry
lawrence.r.beerkircher@noaa.gov
75 Virginia Beach Drive
Miami
FL
33149
305-361-4290
Metadata Contact
2004
Person
Beerkircher, Larry
lawrence.r.beerkircher@noaa.gov
75 Virginia Beach Drive
Miami
FL
33149
305-361-4290
Originator
1993
2004
Organization
Southeast Fisheries Science Center
SEFSC
75 Virginia Beach Drive
Miami
FL
33149
USA
(305)361-5761
https://www.fisheries.noaa.gov/about/southeast-fisheries-science-center
About SEFSC
Online Resource
8:00 a.m. - 4:30 p.m. EST
Dennis Lee initiated data collection. He retired in 2006.
Point of Contact
2004
Person
Beerkircher, Larry
lawrence.r.beerkircher@noaa.gov
75 Virginia Beach Drive
Miami
FL
33149
305-361-4290
33246
Procedure
Data Table
gov.noaa.nmfs.inport:27932
Larry Beerkircher
2015-10-13T08:45:54
SysAdmin InPortAdmin
2022-08-09T17:11:13
2021-05-06
Southeast Fisheries Science Center
SEFSC
75 Virginia Beach Drive
Miami
FL
33149
USA
(305)361-5761
www.sefsc.noaa.gov
8:00 a.m. - 4:30 p.m. EST
1001
Public
No
2021-05-06
1 Year
2022-05-06