Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NEFSC Metadata Library > Population and Ecosystems Monitoring and Analys... > Population Biology Branch > Enhanced Biological Sampling Data >

TRIP_DATA

Entity (ENT)  |  Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:35896  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

This table has the vessel operations data for the fishing efforts that specimens were obtained from Study Fleet vessels. Data comes from FVTR.CRPP_VERS_EFFORT, NERS.GTE_EFFORTS, and is linked via NERS.SF_BIOSAMP_REQUEST_SAMPLES.

Description

This table has the vessel operations data for the fishing efforts that specimens were obtained from Study Fleet vessels. Data comes from FVTR.CRPP_VERS_EFFORT, NERS.GTE_EFFORTS, and is linked via NERS.SF_BIOSAMP_REQUEST_SAMPLES.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
FISH_ID_CODE
VARCHAR2 		Unique code for each sampled fish. Assigned and dependent on FISH_ORGANISM.FISH_ID_CODE
TRIP_IDENTIFIER_BARCODE
VARCHAR2 		Unique identifier that identifies the specific request number the fish came from and the final container (cooler or tote) for the fish from a specified tow. It is a concatenation of the SBR_REQUEST_ID and TOTE_ID columns with an underscore between. It is used to join the catch data from NERS and FVTR by matching to those 2 columns in NERS.SF_BIOSAMP_REQUEST_SAMPLES.
SPECIES_ITIS
VARCHAR2 		Integrated Taxonomic Information System Code; support table VERS.SFLT_SPECIES_CODES
START_SET_DATE_GMT
DATE 		Datetime (UTC) when the gear is first placed in the water at the start of the fishing effort
START_SET_LAT
NUMBER 		Latitude where the gear is first placed in the water at the start of the fishing effort (ddmm.mmmm)
START_SET_LON
NUMBER 		Longitude where the gear is first placed in the water at the start of the fishing effort (dddmm.mmmm)
END_SET_DATE_GMT
DATE 		Datetime (UTC) when setting of the gear has stopped and the gear begins to fish
END_SET_LAT
NUMBER 		Latitude where the setting of the gear has stopped and the gear begins to fish (ddmm.mmmm)
END_SET_LON
NUMBER 		Longitude where the setting of the gear has stopped and the gear begins to fish (dddmm.mmmm)
START_HAUL_DATE_GMT
DATE 		Datetime (UTC) when fishing stops and hauling the gear starts
START_HAUL_LAT
NUMBER 		Latitude where fishing stops and hauling the gear starts (ddmm.mmmm)
START_HAUL_LON
NUMBER 		Longitude where fishing stops and hauling the gear starts (dddmm.mmmm)
END_HAUL_DATE_GMT
DATE 		Datetime (UTC) when the gear has been completely hauled and is back aboard the vessel
END_HAUL_LAT
NUMBER 		Latitude where the gear has been completely hauled and is back aboard the vessel (ddmm.mmmm)
END_HAUL_LON
NUMBER 		Longitude where the gear has been completely hauled and is back aboard the vessel (dddmm.mmmm)
DEPTH
NUMBER 		Fishing depth of the gear
DEPTH_UOM
VARCHAR2 		Unit of measure for DEPTH
TEMP
NUMBER 		Not used
FA_AREA_CODE
VARCHAR2 		ACCSP area or waterbody code. Same code as the AREA in the CFDBS AREA table.
FA_SUB_AREA_CODE
VARCHAR2 		ACCSP sub area or waterbody code. Same code as the NEMAREA code in the CFDBS AREA table.
SBR_REQUEST_ID
VARCHAR2 		Unique biosample request identification number
LINK
VARCHAR2 		Identifier for joining data with NERS and FVTR. Same as TRIP_IDENTIFIER_BARCODE.
FVTR_TRIP_ID
NUMBER 		Unique trip identifier generated in FLDRS software
ELB_EFFORT_NUM
VARCHAR2 		Unique effort identifier within a trip
TRIP_ID
NUMBER 		Unique trip identifier generated in FLDRS software
EFFORT_NUM
VARCHAR2 		Unique effort identifier within a trip
CALC_DUR_HR
DATE 		Duration of the effort in hours
CALC_DIST_NM
NUMBER 		Total distance towed in nautical miles
MIN_TEMP_C
NUMBER 		Min temperature in Celsius
MEAN_TEMP_C
NUMBER 		Mean temperature in Celsius
MAX_TEMP_C
NUMBER 		Max temperature in Celsius
MIN_DPTH_M
NUMBER 		Min depth in meters
MEAN_DPTH_M
NUMBER 		Mean depth in meters
MAX_DPTH_M
NUMBER 		Max depth in meters
MIN_SPD_NMPH
NUMBER 		Min vessel speed in nautical miles per hour
MEAN_SPD_NMPH
NUMBER 		Mean vessel speed in nautical miles per hour
MAX_SPD_NMPH
NUMBER 		Max vessel speed in nautical miles per hour
GTE_CODE
VARCHAR2 		GTE codes (A unique identifier of a data quality issue) for the effort; supporting table NERS.GTE_CODES
GEAR_CODE
VARCHAR2 		Concatenation of ACCSP and VTR gear codes used to map gears between the two data sets

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (NEFSC) for inquiries on this record.

Item Identification

Title: TRIP_DATA
Short Name: TRIP_DATA
Status: Completed
Abstract:

This table has the vessel operations data for the fishing efforts that specimens were obtained from Study Fleet vessels. Data comes from FVTR.CRPP_VERS_EFFORT, NERS.GTE_EFFORTS, and is linked via NERS.SF_BIOSAMP_REQUEST_SAMPLES.

Entity Information

Entity Type: Data Table
Active Version?: Yes
Description:

This table has the vessel operations data for the fishing efforts that specimens were obtained from Study Fleet vessels. Data comes from FVTR.CRPP_VERS_EFFORT, NERS.GTE_EFFORTS, and is linked via NERS.SF_BIOSAMP_REQUEST_SAMPLES.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 FISH_ID_CODE VARCHAR2 Unique code for each sampled fish. Assigned and dependent on FISH_ORGANISM.FISH_ID_CODE
100
 TRIP_IDENTIFIER_BARCODE VARCHAR2 Unique identifier that identifies the specific request number the fish came from and the final container (cooler or tote) for the fish from a specified tow. It is a concatenation of the SBR_REQUEST_ID and TOTE_ID columns with an underscore between. It is used to join the catch data from NERS and FVTR by matching to those 2 columns in NERS.SF_BIOSAMP_REQUEST_SAMPLES.
100
 SPECIES_ITIS VARCHAR2 Integrated Taxonomic Information System Code; support table VERS.SFLT_SPECIES_CODES
100
 START_SET_DATE_GMT DATE Datetime (UTC) when the gear is first placed in the water at the start of the fishing effort
100
 START_SET_LAT NUMBER Latitude where the gear is first placed in the water at the start of the fishing effort (ddmm.mmmm)
100
 START_SET_LON NUMBER Longitude where the gear is first placed in the water at the start of the fishing effort (dddmm.mmmm)
100
 END_SET_DATE_GMT DATE Datetime (UTC) when setting of the gear has stopped and the gear begins to fish
100
 END_SET_LAT NUMBER Latitude where the setting of the gear has stopped and the gear begins to fish (ddmm.mmmm)
100
 END_SET_LON NUMBER Longitude where the setting of the gear has stopped and the gear begins to fish (dddmm.mmmm)
100
 START_HAUL_DATE_GMT DATE Datetime (UTC) when fishing stops and hauling the gear starts
100
 START_HAUL_LAT NUMBER Latitude where fishing stops and hauling the gear starts (ddmm.mmmm)
100
 START_HAUL_LON NUMBER Longitude where fishing stops and hauling the gear starts (dddmm.mmmm)
100
 END_HAUL_DATE_GMT DATE Datetime (UTC) when the gear has been completely hauled and is back aboard the vessel
100
 END_HAUL_LAT NUMBER Latitude where the gear has been completely hauled and is back aboard the vessel (ddmm.mmmm)
100
 END_HAUL_LON NUMBER Longitude where the gear has been completely hauled and is back aboard the vessel (dddmm.mmmm)
100
 DEPTH NUMBER Fishing depth of the gear
100
 DEPTH_UOM VARCHAR2 Unit of measure for DEPTH
100
 TEMP NUMBER Not used
100
 FA_AREA_CODE VARCHAR2 ACCSP area or waterbody code. Same code as the AREA in the CFDBS AREA table.
100
 FA_SUB_AREA_CODE VARCHAR2 ACCSP sub area or waterbody code. Same code as the NEMAREA code in the CFDBS AREA table.
100
 SBR_REQUEST_ID VARCHAR2 Unique biosample request identification number
100
 LINK VARCHAR2 Identifier for joining data with NERS and FVTR. Same as TRIP_IDENTIFIER_BARCODE.
100
 FVTR_TRIP_ID NUMBER Unique trip identifier generated in FLDRS software
100
 ELB_EFFORT_NUM VARCHAR2 Unique effort identifier within a trip
100
 TRIP_ID NUMBER Unique trip identifier generated in FLDRS software
100
 EFFORT_NUM VARCHAR2 Unique effort identifier within a trip
100
 CALC_DUR_HR DATE Duration of the effort in hours
100
 CALC_DIST_NM NUMBER Total distance towed in nautical miles
100
 MIN_TEMP_C NUMBER Min temperature in Celsius
100
 MEAN_TEMP_C NUMBER Mean temperature in Celsius
100
 MAX_TEMP_C NUMBER Max temperature in Celsius
100
 MIN_DPTH_M NUMBER Min depth in meters
100
 MEAN_DPTH_M NUMBER Mean depth in meters
100
 MAX_DPTH_M NUMBER Max depth in meters
100
 MIN_SPD_NMPH NUMBER Min vessel speed in nautical miles per hour
100
 MEAN_SPD_NMPH NUMBER Mean vessel speed in nautical miles per hour
100
 MAX_SPD_NMPH NUMBER Max vessel speed in nautical miles per hour
100
 GTE_CODE VARCHAR2 GTE codes (A unique identifier of a data quality issue) for the effort; supporting table NERS.GTE_CODES
100
 GEAR_CODE VARCHAR2 Concatenation of ACCSP and VTR gear codes used to map gears between the two data sets

Attribute Details

FISH_ID_CODE

CC ID: 362262
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 20
Required: Yes
Primary Key: No
Status: Active
Description:

Unique code for each sampled fish. Assigned and dependent on FISH_ORGANISM.FISH_ID_CODE
General Data Type: VARCHAR2

TRIP_IDENTIFIER_BARCODE

CC ID: 362263
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Unique identifier that identifies the specific request number the fish came from and the final container (cooler or tote) for the fish from a specified tow. It is a concatenation of the SBR_REQUEST_ID and TOTE_ID columns with an underscore between. It is used to join the catch data from NERS and FVTR by matching to those 2 columns in NERS.SF_BIOSAMP_REQUEST_SAMPLES.
General Data Type: VARCHAR2

SPECIES_ITIS

CC ID: 362264
Seq. Order: 50
Data Storage Type: VARCHAR2
Max Length: 11
Required: Yes
Primary Key: No
Status: Active
Description:

Integrated Taxonomic Information System Code; support table VERS.SFLT_SPECIES_CODES
General Data Type: VARCHAR2

START_SET_DATE_GMT

CC ID: 362265
Seq. Order: 51
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Datetime (UTC) when the gear is first placed in the water at the start of the fishing effort
General Data Type: DATE

START_SET_LAT

CC ID: 362266
Seq. Order: 52
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 11
Scale: 6
Status: Active
Description:

Latitude where the gear is first placed in the water at the start of the fishing effort (ddmm.mmmm)
General Data Type: NUMBER

START_SET_LON

CC ID: 362267
Seq. Order: 53
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 11
Scale: 6
Status: Active
Description:

Longitude where the gear is first placed in the water at the start of the fishing effort (dddmm.mmmm)
General Data Type: NUMBER

END_SET_DATE_GMT

CC ID: 362268
Seq. Order: 54
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Datetime (UTC) when setting of the gear has stopped and the gear begins to fish
General Data Type: DATE

END_SET_LAT

CC ID: 362269
Seq. Order: 55
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 6
Status: Active
Description:

Latitude where the setting of the gear has stopped and the gear begins to fish (ddmm.mmmm)
General Data Type: NUMBER

END_SET_LON

CC ID: 362270
Seq. Order: 56
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 11
Scale: 6
Status: Active
Description:

Longitude where the setting of the gear has stopped and the gear begins to fish (dddmm.mmmm)
General Data Type: NUMBER

START_HAUL_DATE_GMT

CC ID: 362271
Seq. Order: 57
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Datetime (UTC) when fishing stops and hauling the gear starts
General Data Type: DATE

START_HAUL_LAT

CC ID: 362272
Seq. Order: 58
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 6
Status: Active
Description:

Latitude where fishing stops and hauling the gear starts (ddmm.mmmm)
General Data Type: NUMBER

START_HAUL_LON

CC ID: 362273
Seq. Order: 59
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 11
Scale: 6
Status: Active
Description:

Longitude where fishing stops and hauling the gear starts (dddmm.mmmm)
General Data Type: NUMBER

END_HAUL_DATE_GMT

CC ID: 362274
Seq. Order: 60
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Datetime (UTC) when the gear has been completely hauled and is back aboard the vessel
General Data Type: DATE

END_HAUL_LAT

CC ID: 362275
Seq. Order: 61
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 6
Status: Active
Description:

Latitude where the gear has been completely hauled and is back aboard the vessel (ddmm.mmmm)
General Data Type: NUMBER

END_HAUL_LON

CC ID: 362276
Seq. Order: 62
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 11
Scale: 6
Status: Active
Description:

Longitude where the gear has been completely hauled and is back aboard the vessel (dddmm.mmmm)
General Data Type: NUMBER

DEPTH

CC ID: 362277
Seq. Order: 63
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Fishing depth of the gear
General Data Type: NUMBER

DEPTH_UOM

CC ID: 362278
Seq. Order: 64
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Unit of measure for DEPTH
General Data Type: VARCHAR2

TEMP

CC ID: 362279
Seq. Order: 65
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 2
Status: Active
Description:

Not used
General Data Type: NUMBER

FA_AREA_CODE

CC ID: 362280
Seq. Order: 66
Data Storage Type: VARCHAR2
Max Length: 3
Required: Yes
Primary Key: No
Status: Active
Description:

ACCSP area or waterbody code. Same code as the AREA in the CFDBS AREA table.
General Data Type: VARCHAR2

FA_SUB_AREA_CODE

CC ID: 362281
Seq. Order: 67
Data Storage Type: VARCHAR2
Max Length: 5
Required: Yes
Primary Key: No
Status: Active
Description:

ACCSP sub area or waterbody code. Same code as the NEMAREA code in the CFDBS AREA table.
General Data Type: VARCHAR2

SBR_REQUEST_ID

CC ID: 362282
Seq. Order: 68
Data Storage Type: VARCHAR2
Max Length: 15
Required: Yes
Primary Key: No
Status: Active
Description:

Unique biosample request identification number
General Data Type: VARCHAR2

LINK

CC ID: 362283
Seq. Order: 69
Data Storage Type: VARCHAR2
Max Length: 21
Required: No
Primary Key: No
Status: Active
Description:

Identifier for joining data with NERS and FVTR. Same as TRIP_IDENTIFIER_BARCODE.
General Data Type: VARCHAR2

FVTR_TRIP_ID

CC ID: 362284
Seq. Order: 70
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 14
Scale: 0
Status: Active
Description:

Unique trip identifier generated in FLDRS software
General Data Type: NUMBER

ELB_EFFORT_NUM

CC ID: 362285
Seq. Order: 71
Data Storage Type: VARCHAR2
Max Length: 5
Required: Yes
Primary Key: No
Status: Active
Description:

Unique effort identifier within a trip
General Data Type: VARCHAR2

TRIP_ID

CC ID: 362286
Seq. Order: 72
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Unique trip identifier generated in FLDRS software
General Data Type: NUMBER

EFFORT_NUM

CC ID: 362287
Seq. Order: 73
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Unique effort identifier within a trip
General Data Type: VARCHAR2

CALC_DUR_HR

CC ID: 362288
Seq. Order: 74
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Duration of the effort in hours
General Data Type: DATE

CALC_DIST_NM

CC ID: 362289
Seq. Order: 75
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 2
Status: Active
Description:

Total distance towed in nautical miles
General Data Type: NUMBER

MIN_TEMP_C

CC ID: 362290
Seq. Order: 76
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 2
Status: Active
Description:

Min temperature in Celsius
General Data Type: NUMBER

MEAN_TEMP_C

CC ID: 362291
Seq. Order: 77
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 2
Status: Active
Description:

Mean temperature in Celsius
General Data Type: NUMBER

MAX_TEMP_C

CC ID: 362292
Seq. Order: 78
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 2
Status: Active
Description:

Max temperature in Celsius
General Data Type: NUMBER

MIN_DPTH_M

CC ID: 362293
Seq. Order: 79
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 2
Status: Active
Description:

Min depth in meters
General Data Type: NUMBER

MEAN_DPTH_M

CC ID: 362294
Seq. Order: 80
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 2
Status: Active
Description:

Mean depth in meters
General Data Type: NUMBER

MAX_DPTH_M

CC ID: 362295
Seq. Order: 81
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 2
Status: Active
Description:

Max depth in meters
General Data Type: NUMBER

MIN_SPD_NMPH

CC ID: 362296
Seq. Order: 82
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 2
Status: Active
Description:

Min vessel speed in nautical miles per hour
General Data Type: NUMBER

MEAN_SPD_NMPH

CC ID: 362297
Seq. Order: 83
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 2
Status: Active
Description:

Mean vessel speed in nautical miles per hour
General Data Type: NUMBER

MAX_SPD_NMPH

CC ID: 362298
Seq. Order: 84
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 2
Status: Active
Description:

Max vessel speed in nautical miles per hour
General Data Type: NUMBER

GTE_CODE

CC ID: 362299
Seq. Order: 85
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

GTE codes (A unique identifier of a data quality issue) for the effort; supporting table NERS.GTE_CODES
General Data Type: VARCHAR2

GEAR_CODE

CC ID: 362300
Seq. Order: 86
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

Concatenation of ACCSP and VTR gear codes used to map gears between the two data sets
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 35896
GUID: gov.noaa.nmfs.inport:35896
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-12-07 13:28+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-12-07
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-12-07
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-12-07