Slide Menu
Search Help Show/Hide Menu

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