Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Data recorded from GPS receiver during each trip conducted using FLDRS

Description

Data recorded from GPS receiver during each trip conducted using FLDRS

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
TRIP_ID
NUMBER
Unique trip identifier generated in FLDRS software
DATETIME_GMT
DATE
Date and time in Greenwich Mean Time
LATITUDE
NUMBER
Latitude in decimal degrees
LONGITUDE
NUMBER
Longitude in decimal degrees
SPEED_KNOTS
NUMBER
Speed in knots
COURSE_TRUE
NUMBER
Course direction
FIX
NUMBER
Availablility of satellite fix; yes=1 no=0
SAT_AVAIL
NUMBER
Number of satellites
BOT_DEPTH_M
NUMBER
Bottom depth in meters
EVENT_TYPE
VARCHAR2
Event type indicating effort number and start of haul or end of set or haul

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: Table: GPS_POLL_DATA
Short Name: GPS_POLL_DATA
Status: Completed
Abstract:

Data recorded from GPS receiver during each trip conducted using FLDRS

Notes:

Loaded by batch 9249, 09-01-2016 13:11

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: NERS
Description:

Data recorded from GPS receiver during each trip conducted using FLDRS

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key TRIP_ID NUMBER Unique trip identifier generated in FLDRS software
100
Primary Key DATETIME_GMT DATE Date and time in Greenwich Mean Time
100
LATITUDE NUMBER Latitude in decimal degrees
100
LONGITUDE NUMBER Longitude in decimal degrees
100
SPEED_KNOTS NUMBER Speed in knots
100
COURSE_TRUE NUMBER Course direction
100
FIX NUMBER Availablility of satellite fix; yes=1 no=0
100
SAT_AVAIL NUMBER Number of satellites
100
BOT_DEPTH_M NUMBER Bottom depth in meters
100
EVENT_TYPE VARCHAR2 Event type indicating effort number and start of haul or end of set or haul

Attribute Details

TRIP_ID

CC ID: 347790
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 14
Scale: 0
Status: Active
Description:

Unique trip identifier generated in FLDRS software

General Data Type: NUMBER

DATETIME_GMT

CC ID: 347792
Seq. Order: 2
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: Yes
Status: Active
Description:

Date and time in Greenwich Mean Time

General Data Type: DATE

LATITUDE

CC ID: 347793
Seq. Order: 3
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 12
Scale: 6
Status: Active
Description:

Latitude in decimal degrees

General Data Type: NUMBER

LONGITUDE

CC ID: 347794
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 12
Scale: 6
Status: Active
Description:

Longitude in decimal degrees

General Data Type: NUMBER

SPEED_KNOTS

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

Speed in knots

General Data Type: NUMBER

COURSE_TRUE

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

Course direction

General Data Type: NUMBER

FIX

CC ID: 347797
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Availablility of satellite fix; yes=1 no=0

General Data Type: NUMBER

SAT_AVAIL

CC ID: 347798
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Number of satellites

General Data Type: NUMBER

BOT_DEPTH_M

CC ID: 347799
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 1
Status: Active
Description:

Bottom depth in meters

General Data Type: NUMBER

EVENT_TYPE

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

Event type indicating effort number and start of haul or end of set or haul

General Data Type: VARCHAR2

Catalog Details

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