53177
RI020AA2_CONF_V
RI020AA2_CONF_V
Entity
Published / External
53108
Shrimp Morphometric Log data collected by a commercial fishery vessel in 1984 in Guam
Data Set
Completed
Shrimp Morphometric Log data collected on a commercial fishery vessel - CONFIDENTIAL.
Data Table
Yes
Shrimp Morphometric Log data collected on a commercial fishery vessel - CONFIDENTIAL.
1
DATASET_CODE
VARCHAR2
5
No
No
Active
Source ID Code assigned by the data entry staff.
VARCHAR2
2
VERSION_CODE
VARCHAR2
3
No
No
Active
Code for the format version assigned by the data entry staff.
VARCHAR2
3
VESSEL_CODE
VARCHAR2
3
No
No
Active
Code for the vessel.
VARCHAR2
4
CRUISE_NUMBER
VARCHAR2
4
No
No
Active
Last two digits of the year of the cruise and two-digit incremental number of the cruise for the year.
VARCHAR2
5
YEAR
VARCHAR2
4
No
No
Active
Year of capture.
VARCHAR2
6
MONTH
VARCHAR2
2
No
No
Active
Month of capture.
VARCHAR2
7
DAY
VARCHAR2
2
No
No
Active
Day of capture.
VARCHAR2
8
STATION_NUMBER_FIRST
VARCHAR2
3
No
No
Active
First station number. For AA1 format, there was only one capture station number collected and entered.
VARCHAR2
9
STATION_NUMBER_LAST
VARCHAR2
3
No
No
Active
Last station number.
VARCHAR2
10
LATITUDE_DEGREES
VARCHAR2
2
No
No
Active
Latitude degrees. Units for values are degrees. Data was collected but not entered.
VARCHAR2
degrees
11
LATITUDE_MINUTES
VARCHAR2
4
No
No
1
Active
Latitude minutes, in tenths of a minute. Units for values are minutes. Data was collected but not entered.
VARCHAR2
minutes
12
LATITUDE_DIRECTION
VARCHAR2
1
No
No
Active
Latitude direction. Data was collected but not entered.
VARCHAR2
13
LATITUDE_DD
NUMERIC
41
No
No
38
Active
Computed latitude, in decimal degrees. Positive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40.
NUMERIC
degrees
14
LONGITUDE_DEGREES
VARCHAR2
3
No
No
Active
Longitude degrees. Units for values are degrees. Data was collected but not entered.
VARCHAR2
degrees
15
LONGITUDE_MINUTES
VARCHAR2
4
No
No
1
Active
Longitude minutes, in tenths of a minute. Units for values are minutes. Data was collected but not entered.
VARCHAR2
minutes
16
LONGITUDE_DIRECTION
VARCHAR2
1
No
No
Active
Longitude direction. Data was collected but not entered.
VARCHAR2
17
LONGITUDE_DD
NUMERIC
41
No
No
36
Active
Computed longitude, in decimal degrees. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39.
NUMERIC
degrees
18
BANK_CODE
VARCHAR2
7
No
No
Active
Seven digit bank code.
VARCHAR2
2020100 = GUAM
19
DEPTH_SET
VARCHAR2
4
No
No
Active
Set depth, in fathoms. Units for values are fathoms.
VARCHAR2
fathoms
20
DEPTH_HAUL
VARCHAR2
4
No
No
Active
Haul depth in fathoms. Units for values are fathoms.
VARCHAR2
fathoms
21
DEPTH_MINIMUM
VARCHAR2
3
No
No
Active
Minimum depth, in fathoms. For AA1 format, if only one depth, the same number was entered into DEPTH_MINIMUM and DEPTH_MAXIMUM. Units for values are fathoms.
VARCHAR2
fathoms
22
DEPTH_MAXIMUM
VARCHAR2
3
No
No
Active
Maximum depth, in fathoms. Units for values are fathoms.
VARCHAR2
fathoms
23
LINE_NUMBER
NUMERIC
4
No
No
Active
A consecutive number for each entry on the collection form.
NUMERIC
24
SPECIES_CODE
VARCHAR2
10
No
No
Active
CZM 10-digit species code.
VARCHAR2
6483460301 = HETEROCARPUS ENSIFER;
6483460302 = HETEROCARPUS LAEVIGATUS;
6483460303 = HETEROCARPUS SIBOGAE;
6483460304 = HETEROCARPUS DORSALIS;
6483460305 = HETEROCARPUS LEPIDUS
25
STRING_NUMBER
VARCHAR2
2
No
No
Active
The consecutive number of the string of traps.
VARCHAR2
26
GEAR_CODE
VARCHAR2
2
No
No
Active
Code for the type of gear used.
VARCHAR2
27
TRAP_NUMBER_FIRST
VARCHAR2
2
No
No
Active
First trap number. For AA2 format if only one trap number, the same number was entered into TRAP_NUMBER_FIRST AND TRAP_NUMBER_LAST.
VARCHAR2
28
TRAP_NUMBER_LAST
VARCHAR2
2
No
No
Active
Last trap number.
VARCHAR2
29
CARAPACE_LENGTH
VARCHAR2
6
No
No
2
Active
Carapace length, in hundredths of a millimeter. For AA1 format, data was collected in tens of millimeter and reformated to hundreds of millimeter. During data entry the decimal point was omitted; it has have been inserted into the data. Units for values are millimeters. Measures are reported with a precision of 5.
VARCHAR2
millimeters
30
CARAPACE_WIDTH
VARCHAR2
6
No
No
2
Active
Carapace width, in hundredths of a millimeter. Units for values are millimeters.
VARCHAR2
millimeters
31
TOTAL_LENGTH
NUMERIC
6
No
No
2
Active
Total length, in hundredths of a millimeter. Units for values are millimeters.
NUMERIC
millimeters
32
WEIGHT
VARCHAR2
4
No
No
1
Active
Weight, in tenths of a gram. Units for values are grams.
VARCHAR2
grams
33
SEX_CODE
VARCHAR2
1
No
No
Active
Code for the sex of the species.
VARCHAR2
F = FEMALE;
M = MALE
34
BERRIED_OVA_COLOR_CODE
VARCHAR2
1
No
No
Active
Code for the color of the berried ova.
VARCHAR2
1 = ORANGE;
2 = BROWN;
3 = WHITE;
4 = BLUE;
5 = BERRIED (COLOR NOT RECORDED)
35
MALE_MATURITY_CODE
VARCHAR2
1
No
No
Active
Code for the maturity of the male.
VARCHAR2
36
GILL_PARASITE_CODE
VARCHAR2
1
No
No
Active
Code for the presence of gill parasites.
VARCHAR2
1 = GILL PARASITE PRESENT
37
JOB_NUMBER
VARCHAR2
6
No
No
Active
A consecutive number assigned by the data entry staff to a block of data that is entered and verified. Format DYYNNN, where D is constant, YY is the last two digits of the year and NNN is the consecutive number that starts with 001 at the beginning of each calendar year, e.g., D84371.
VARCHAR2
38
SEQUENCE_NUMBER
VARCHAR2
8
No
No
Active
A consecutive number assigned to each record for a block of data.
VARCHAR2
39
DATE_LOADED
DATE
22
No
No
Active
Date when the record was loaded into Oracle or updated.
DATE
gov.noaa.nmfs.inport:53177
Brent Miyamoto
2018-08-01T18:55:21
SysAdmin InPortAdmin
2022-08-09T17:11:40
2021-01-14
Pacific Islands Fisheries Science Center
PIFSC
1845 Wasp Blvd.
Honolulu
HI
96818
USA
808-725-5300
http://www.pifsc.noaa.gov
8:00 a.m. - 4:30 p.m.
1001
Public
No
2021-01-14
1 Year
2022-01-14