Slide Menu
Search Help Show/Hide Menu

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

Rubric Score Primary Key? 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