RP005AA1_V
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:70000 | Updated: May 24, 2023 | Published / External
Item Identification
| Title: | RP005AA1_V |
|---|---|
| Short Name: | RP005AA1_V |
| Status: | Completed |
| Abstract: |
Gill net fishing data collected during research cruises in 1981, 1982 and 1983. |
Entity Information
| Entity Type: | Data Table |
|---|---|
| Active Version?: | Yes |
| Description: |
Gillnet data collected during research cruises in 1981, 1982 and 1983. |
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
DATASET_CODE | VARCHAR2 | Source ID Code assigned by the data entry staff. | |
|
100
|
VERSION_CODE | VARCHAR2 | Code for the format version assigned by the data entry staff. | |
|
100
|
VESSEL_CODE | VARCHAR2 | Code for the vessel. | |
|
100
|
CRUISE_NUMBER | VARCHAR2 | Last two digits of the year of the cruise and two digits incremental number of the cruise for the year, e.g., 8101. | |
|
100
|
STATION_NUMBER | VARCHAR2 | Station number of the gill net operation. | |
|
100
|
YEAR | VARCHAR2 | Year. | |
|
100
|
MONTH | VARCHAR2 | Month. | |
|
100
|
DAY | VARCHAR2 | Day. | |
|
100
|
LATITUDE_DEGREES | VARCHAR2 | Latitude degrees. Units for values are degrees. | |
|
100
|
LATITUDE_MINUTES | VARCHAR2 | Latitude minutes. Units for values are minutes. | |
|
100
|
LATITUDE_DIRECTION | VARCHAR2 | Latitude direction. | |
|
100
|
LATITUDE_DD | NUMBER | Computed latitude, in decimal degrees, of the sampling site. Postive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40. | |
|
100
|
LONGITUDE_DEGREES | VARCHAR2 | Longitude degrees. Units for values are degrees. | |
|
100
|
LONGITUDE_MINUTES | VARCHAR2 | Longitude minutes. Units for values are minutes. | |
|
100
|
LONGITUDE_DIRECTION | VARCHAR2 | Longitude direction. | |
|
100
|
LONGITUDE_DD | NUMBER | Computed longitude, in decimal degrees, of the sampling site. Postive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39. | |
|
100
|
SEA_SURFACE_TEMPERATURE | VARCHAR2 | Surface temperature, in tenths of a degree Celsius. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are degrees Celsius. Measures are reported with a precision of 3. | |
|
100
|
NUMBER_SHACKLES | VARCHAR2 | Number of shackles. | |
|
100
|
SET_BEGIN_TIME | VARCHAR2 | Set Begin Time. | |
|
100
|
SET_END_TIME | VARCHAR2 | Set End Time. | |
|
100
|
HAUL_BEGIN_TIME | VARCHAR2 | Haul Begin Time. | |
|
100
|
HAUL_END_TIME | VARCHAR2 | Haul End Time. | |
|
100
|
MESH | VARCHAR2 | Mesh. | |
|
100
|
WEIGHT | VARCHAR2 | Weight, in grams. Units for values are grams. | |
|
100
|
LENGTH | VARCHAR2 | Length, in millimeters. Units for values are millimeters. | |
|
100
|
SPECIES_CODE | VARCHAR2 | 10-digit CZM species code. | |
|
100
|
JOB_NUMBER | VARCHAR2 | 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., D83000. | |
|
100
|
SEQUENCE_NUMBER | VARCHAR2 | A consecutive number assigned to each record for a block of data. | |
|
100
|
DATE_LOADED | DATE | Date when the record was loaded into Oracle or updated. |
Attribute Details
DATASET_CODE
CC ID: 1236937
| Seq. Order: | 1 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 5 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Source ID Code assigned by the data entry staff. |
| General Data Type: | VARCHAR2 |
VERSION_CODE
CC ID: 1236938
| Seq. Order: | 2 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Code for the format version assigned by the data entry staff. |
| General Data Type: | VARCHAR2 |
VESSEL_CODE
CC ID: 1236939
| Seq. Order: | 3 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Code for the vessel. |
| General Data Type: | VARCHAR2 |
CRUISE_NUMBER
CC ID: 1236940
| Seq. Order: | 4 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Last two digits of the year of the cruise and two digits incremental number of the cruise for the year, e.g., 8101. |
| General Data Type: | VARCHAR2 |
STATION_NUMBER
CC ID: 1236941
| Seq. Order: | 5 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Station number of the gill net operation. |
| General Data Type: | VARCHAR2 |
YEAR
CC ID: 1236942
| Seq. Order: | 6 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Year. |
| General Data Type: | VARCHAR2 |
MONTH
CC ID: 1236943
| Seq. Order: | 7 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Month. |
| General Data Type: | VARCHAR2 |
DAY
CC ID: 1236944
| Seq. Order: | 8 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Day. |
| General Data Type: | VARCHAR2 |
LATITUDE_DEGREES
CC ID: 1236945
| Seq. Order: | 9 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Latitude degrees. Units for values are degrees. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | degrees |
LATITUDE_MINUTES
CC ID: 1236946
| Seq. Order: | 10 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Latitude minutes. Units for values are minutes. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | minutes |
LATITUDE_DIRECTION
CC ID: 1236947
| Seq. Order: | 11 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Latitude direction. |
| General Data Type: | VARCHAR2 |
LATITUDE_DD
CC ID: 1236948
| Seq. Order: | 12 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 41 |
| Required: | No |
| Primary Key: | No |
| Scale: | 38 |
| Status: | Active |
| Description: |
Computed latitude, in decimal degrees, of the sampling site. Postive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40. |
| General Data Type: | NUMBER |
| Unit of Measure: | degrees |
LONGITUDE_DEGREES
CC ID: 1236949
| Seq. Order: | 13 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Longitude degrees. Units for values are degrees. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | degrees |
LONGITUDE_MINUTES
CC ID: 1236950
| Seq. Order: | 14 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Longitude minutes. Units for values are minutes. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | minutes |
LONGITUDE_DIRECTION
CC ID: 1236951
| Seq. Order: | 15 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Longitude direction. |
| General Data Type: | VARCHAR2 |
LONGITUDE_DD
CC ID: 1236952
| Seq. Order: | 16 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 41 |
| Required: | No |
| Primary Key: | No |
| Scale: | 36 |
| Status: | Active |
| Description: |
Computed longitude, in decimal degrees, of the sampling site. Postive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39. |
| General Data Type: | NUMBER |
| Unit of Measure: | degrees |
SEA_SURFACE_TEMPERATURE
CC ID: 1236953
| Seq. Order: | 17 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Scale: | 1 |
| Status: | Active |
| Description: |
Surface temperature, in tenths of a degree Celsius. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are degrees Celsius. Measures are reported with a precision of 3. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | degrees Celsius |
NUMBER_SHACKLES
CC ID: 1236954
| Seq. Order: | 18 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of shackles. |
| General Data Type: | VARCHAR2 |
SET_BEGIN_TIME
CC ID: 1236955
| Seq. Order: | 19 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Set Begin Time. |
| General Data Type: | VARCHAR2 |
SET_END_TIME
CC ID: 1236956
| Seq. Order: | 20 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Set End Time. |
| General Data Type: | VARCHAR2 |
HAUL_BEGIN_TIME
CC ID: 1236957
| Seq. Order: | 21 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Haul Begin Time. |
| General Data Type: | VARCHAR2 |
HAUL_END_TIME
CC ID: 1236958
| Seq. Order: | 22 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Haul End Time. |
| General Data Type: | VARCHAR2 |
MESH
CC ID: 1236959
| Seq. Order: | 23 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Mesh. |
| General Data Type: | VARCHAR2 |
WEIGHT
CC ID: 1236960
| Seq. Order: | 24 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Weight, in grams. Units for values are grams. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | grams |
LENGTH
CC ID: 1236961
| Seq. Order: | 25 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 5 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Length, in millimeters. Units for values are millimeters. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | millimeters |
SPECIES_CODE
CC ID: 1236962
| Seq. Order: | 26 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
10-digit CZM species code. |
| General Data Type: | VARCHAR2 |
JOB_NUMBER
CC ID: 1236963
| Seq. Order: | 27 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 6 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
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., D83000. |
| General Data Type: | VARCHAR2 |
SEQUENCE_NUMBER
CC ID: 1236964
| Seq. Order: | 28 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
A consecutive number assigned to each record for a block of data. |
| General Data Type: | VARCHAR2 |
DATE_LOADED
CC ID: 1236965
| Seq. Order: | 29 |
|---|---|
| Data Storage Type: | DATE |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Date when the record was loaded into Oracle or updated. |
| General Data Type: | DATE |
Catalog Details
| Catalog Item ID: | 70000 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:70000 |
| Metadata Record Created By: | Brent M Miyamoto |
| Metadata Record Created: | 2023-05-24 20:21+0000 |
| Metadata Record Last Modified By: | Brent M Miyamoto |
| Metadata Record Last Modified: | 2023-05-24 20:48+0000 |
| Metadata Record Published: | 2023-05-24 |
| Owner Org: | PIFSC |
| Metadata Publication Status: | Published Externally |
| Do Not Publish?: | N |
| Metadata Last Review Date: | 2023-05-24 |
| Metadata Review Frequency: | 1 Year |
| Metadata Next Review Date: | 2024-05-24 |