Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NEFSC Metadata Library > Ecosystems & Aquaculture Division (EAD) > Habitat Ecology Branch (HEB) > Coastal Estuarine Linkages >

LnkTrwlSta2

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

Summary

Abstract

Linkages Trawl-Station table

Description

Linkages Trawl-Station table

Entity Information

Entity Type
Data File

Data Attribute / Type Description
key
VARCHAR 		concatenation of Cruise code and Standard Station number
tkey
VARCHAR 		Trawl_concatenation of Cruise code, Standard Station number, tgear, and tow
cr
VARCHAR 		2 characters each for ship, year and consecutive cruise number (for the year)
consta
INTEGER 		consecutive station number for a given cruise
stdsta
INTEGER 		standard,or fixed, station number
tgear
VARCHAR 		Trawl_gear (2meterBeamTrawl or Otter Trawl 16')
Tow
INTEGER 		consecutive tow number for a given cruise
Tsur
INTEGER 		Trawl_consecutive survey number
Tlat
DOUBLE PRECISION 		Trawl_Latitude (ddmm.xx)
Tlng
DOUBLE PRECISION 		Trawl_Longitude (ddmm.xx)
Tdlat
DOUBLE PRECISION 		Trawl_Latitude, decimal-degrees
Tdlng
DOUBLE PRECISION 		Trawl_Longitude, decimal-degrees
Tbtm
DOUBLE PRECISION 		Trawl_bottomdepth
Tdate
DATE 		format mm/dd/yyyy
Ttime
TIME 		format HH:MI:SS AM/PM
Tdatetime
TIMESTAMP 		format mm/dd/yyyy HH24:MI
Tjdate
DOUBLE PRECISION 		Trawl_Julian date, or yearday
mon
INTEGER 		Month (1 to 12)
year
INTEGER 		Year (4-digit)
tdur
DOUBLE PRECISION 		Trawl_duration of tow (min)

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

Linkages Trawl-Station table

Entity Information

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

Linkages Trawl-Station table

Data Attributes

Note: Metadata requirements do not apply to attributes for non-tabular entities.

Attribute Summary

Rubric Score Primary Key? Name Type Description
N/A
 key VARCHAR concatenation of Cruise code and Standard Station number
N/A
 Primary Key tkey VARCHAR Trawl_concatenation of Cruise code, Standard Station number, tgear, and tow
N/A
 cr VARCHAR 2 characters each for ship, year and consecutive cruise number (for the year)
N/A
 consta INTEGER consecutive station number for a given cruise
N/A
 stdsta INTEGER standard,or fixed, station number
N/A
 tgear VARCHAR Trawl_gear (2meterBeamTrawl or Otter Trawl 16')
N/A
 Tow INTEGER consecutive tow number for a given cruise
N/A
 Tsur INTEGER Trawl_consecutive survey number
N/A
 Tlat DOUBLE PRECISION Trawl_Latitude (ddmm.xx)
N/A
 Tlng DOUBLE PRECISION Trawl_Longitude (ddmm.xx)
N/A
 Tdlat DOUBLE PRECISION Trawl_Latitude, decimal-degrees
N/A
 Tdlng DOUBLE PRECISION Trawl_Longitude, decimal-degrees
N/A
 Tbtm DOUBLE PRECISION Trawl_bottomdepth
N/A
 Tdate DATE format mm/dd/yyyy
N/A
 Ttime TIME format HH:MI:SS AM/PM
N/A
 Tdatetime TIMESTAMP format mm/dd/yyyy HH24:MI
N/A
 Tjdate DOUBLE PRECISION Trawl_Julian date, or yearday
N/A
 mon INTEGER Month (1 to 12)
N/A
 year INTEGER Year (4-digit)
N/A
 tdur DOUBLE PRECISION Trawl_duration of tow (min)

Attribute Details

key

CC ID: 372252
Seq. Order: 1
Data Storage Type: VARCHAR
Max Length: 8
Required: Yes
Primary Key: No
Status: Active
Description:

concatenation of Cruise code and Standard Station number
General Data Type: VARCHAR

tkey

CC ID: 372253
Seq. Order: 2
Data Storage Type: VARCHAR
Max Length: 14
Required: Yes
Primary Key: Yes
Status: Active
Description:

Trawl_concatenation of Cruise code, Standard Station number, tgear, and tow
General Data Type: VARCHAR

cr

CC ID: 372254
Seq. Order: 3
Data Storage Type: VARCHAR
Max Length: 6
Required: Yes
Primary Key: No
Status: Active
Description:

2 characters each for ship, year and consecutive cruise number (for the year)
General Data Type: VARCHAR

consta

CC ID: 372255
Seq. Order: 4
Data Storage Type: INTEGER
Max Length: 2
Required: Yes
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

consecutive station number for a given cruise
General Data Type: INTEGER

stdsta

CC ID: 372256
Seq. Order: 5
Data Storage Type: INTEGER
Max Length: 2
Required: Yes
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

standard,or fixed, station number
General Data Type: INTEGER

tgear

CC ID: 372257
Seq. Order: 6
Data Storage Type: VARCHAR
Max Length: 4
Required: Yes
Primary Key: No
Status: Active
Description:

Trawl_gear (2meterBeamTrawl or Otter Trawl 16')
General Data Type: VARCHAR

Tow

CC ID: 372258
Seq. Order: 7
Data Storage Type: INTEGER
Max Length: 2
Required: Yes
Primary Key: No
Precision: 1
Scale: 0
Status: Active
Description:

consecutive tow number for a given cruise
General Data Type: INTEGER

Tsur

CC ID: 372259
Seq. Order: 8
Data Storage Type: INTEGER
Max Length: 2
Required: Yes
Primary Key: No
Precision: 1
Scale: 0
Status: Active
Description:

Trawl_consecutive survey number
General Data Type: INTEGER

Tlat

CC ID: 372260
Seq. Order: 9
Data Storage Type: DOUBLE PRECISION
Max Length: 8
Required: Yes
Primary Key: No
Precision: 6
Scale: 2
Status: Active
Description:

Trawl_Latitude (ddmm.xx)
General Data Type: DOUBLE PRECISION

Tlng

CC ID: 372261
Seq. Order: 10
Data Storage Type: DOUBLE PRECISION
Max Length: 8
Required: Yes
Primary Key: No
Precision: 6
Scale: 2
Status: Active
Description:

Trawl_Longitude (ddmm.xx)
General Data Type: DOUBLE PRECISION

Tdlat

CC ID: 372262
Seq. Order: 11
Data Storage Type: DOUBLE PRECISION
Max Length: 8
Required: Yes
Primary Key: No
Precision: 7
Scale: 5
Status: Active
Description:

Trawl_Latitude, decimal-degrees
General Data Type: DOUBLE PRECISION

Tdlng

CC ID: 372263
Seq. Order: 12
Data Storage Type: DOUBLE PRECISION
Max Length: 8
Required: Yes
Primary Key: No
Precision: 6
Scale: 4
Status: Active
Description:

Trawl_Longitude, decimal-degrees
General Data Type: DOUBLE PRECISION

Tbtm

CC ID: 372264
Seq. Order: 13
Data Storage Type: DOUBLE PRECISION
Max Length: 8
Required: Yes
Primary Key: No
Precision: 3
Scale: 1
Status: Active
Description:

Trawl_bottomdepth
General Data Type: DOUBLE PRECISION

Tdate

CC ID: 372265
Seq. Order: 14
Data Storage Type: DATE
Max Length: 8
Required: Yes
Primary Key: No
Status: Active
Description:

format mm/dd/yyyy
General Data Type: DATE

Ttime

CC ID: 372266
Seq. Order: 15
Data Storage Type: TIME
Max Length: 8
Required: Yes
Primary Key: No
Status: Active
Description:

format HH:MI:SS AM/PM
General Data Type: TIME

Tdatetime

CC ID: 372267
Seq. Order: 16
Data Storage Type: TIMESTAMP
Max Length: 8
Required: Yes
Primary Key: No
Status: Active
Description:

format mm/dd/yyyy HH24:MI
General Data Type: TIMESTAMP

Tjdate

CC ID: 372268
Seq. Order: 17
Data Storage Type: DOUBLE PRECISION
Max Length: 8
Required: Yes
Primary Key: No
Precision: 7
Scale: 4
Status: Active
Description:

Trawl_Julian date, or yearday
General Data Type: DOUBLE PRECISION

mon

CC ID: 372269
Seq. Order: 18
Data Storage Type: INTEGER
Max Length: 2
Required: Yes
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Month (1 to 12)
General Data Type: INTEGER

year

CC ID: 372270
Seq. Order: 19
Data Storage Type: INTEGER
Max Length: 2
Required: Yes
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Year (4-digit)
General Data Type: INTEGER

tdur

CC ID: 372271
Seq. Order: 20
Data Storage Type: DOUBLE PRECISION
Max Length: 8
Required: Yes
Primary Key: No
Precision: 15
Scale: 14
Status: Active
Description:

Trawl_duration of tow (min)
General Data Type: DOUBLE PRECISION

Catalog Details

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