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 >

LnkHydSta2

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

Summary

Abstract

Linkages Hydro-Station table

Description

Linkages Hydro-Station table

Entity Information

Entity Type
Data File

Data Attribute / Type Description
key
VARCHAR 		concatenation of Cruise code and Standard Station number
cr
VARCHAR 		2 char 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
sur
INTEGER 		consecutive survey number
Hgear
VARCHAR 		Hydro_instrument code, e.g. HL or YSI
Hlat
DOUBLE PRECISION 		Hydro_Latitude (ddmm.xx)
Hlng
DOUBLE PRECISION 		Hydro_Longitude (ddmm.xx)
Hdlat
DOUBLE PRECISION 		Hydro_Latitude, decimal-degrees
Hdlng
DOUBLE PRECISION 		Hydro_Longitude, decimal-degrees
Hbtm
DOUBLE PRECISION 		Hydro_water depth (m)
Hdate
DATE 		Hydro_Date (local) format mm/dd/yyyy
Htime
TIME 		Hydro_Time of cast (local) format HH:MI:SS AM/PM
Hdatetime
TIMESTAMP 		Hydro_Timestamp; Date&Time combined format mm/dd/yyyy HH24:MI
Hjdate
DOUBLE PRECISION 		Hydro_Julian date, or yearday
mon
INTEGER 		Month (1 to 12)
year
INTEGER 		Year (4-digit)
sst
DOUBLE PRECISION 		Sea-surface temperature
sss
DOUBLE PRECISION 		Sea-surface salinity
ssdo
DOUBLE PRECISION 		Sea-surface dissolved-oxygen
bt
DOUBLE PRECISION 		bottom temperature (deepest observation, not necessarily on bottom)
bs
DOUBLE PRECISION 		bottom salinity
bdo
DOUBLE PRECISION 		bottom dissolved-oxygen
bdpt
DOUBLE PRECISION 		Depth (m) of deepest observation

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

Linkages Hydro-Station table

Entity Information

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

Linkages Hydro-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
 Primary Key key VARCHAR concatenation of Cruise code and Standard Station number
N/A
 cr VARCHAR 2 char 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
 sur INTEGER consecutive survey number
N/A
 Hgear VARCHAR Hydro_instrument code, e.g. HL or YSI
N/A
 Hlat DOUBLE PRECISION Hydro_Latitude (ddmm.xx)
N/A
 Hlng DOUBLE PRECISION Hydro_Longitude (ddmm.xx)
N/A
 Hdlat DOUBLE PRECISION Hydro_Latitude, decimal-degrees
N/A
 Hdlng DOUBLE PRECISION Hydro_Longitude, decimal-degrees
N/A
 Hbtm DOUBLE PRECISION Hydro_water depth (m)
N/A
 Hdate DATE Hydro_Date (local) format mm/dd/yyyy
N/A
 Htime TIME Hydro_Time of cast (local) format HH:MI:SS AM/PM
N/A
 Hdatetime TIMESTAMP Hydro_Timestamp; Date&Time combined format mm/dd/yyyy HH24:MI
N/A
 Hjdate DOUBLE PRECISION Hydro_Julian date, or yearday
N/A
 mon INTEGER Month (1 to 12)
N/A
 year INTEGER Year (4-digit)
N/A
 sst DOUBLE PRECISION Sea-surface temperature
N/A
 sss DOUBLE PRECISION Sea-surface salinity
N/A
 ssdo DOUBLE PRECISION Sea-surface dissolved-oxygen
N/A
 bt DOUBLE PRECISION bottom temperature (deepest observation, not necessarily on bottom)
N/A
 bs DOUBLE PRECISION bottom salinity
N/A
 bdo DOUBLE PRECISION bottom dissolved-oxygen
N/A
 bdpt DOUBLE PRECISION Depth (m) of deepest observation

Attribute Details

key

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

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

cr

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

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

consta

CC ID: 372152
Seq. Order: 3
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: 372153
Seq. Order: 4
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

sur

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

consecutive survey number
General Data Type: INTEGER

Hgear

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

Hydro_instrument code, e.g. HL or YSI
General Data Type: VARCHAR

Hlat

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

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

Hlng

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

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

Hdlat

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

Hydro_Latitude, decimal-degrees
General Data Type: DOUBLE PRECISION

Hdlng

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

Hydro_Longitude, decimal-degrees
General Data Type: DOUBLE PRECISION

Hbtm

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

Hydro_water depth (m)
General Data Type: DOUBLE PRECISION

Hdate

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

Hydro_Date (local) format mm/dd/yyyy
General Data Type: DATE

Htime

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

Hydro_Time of cast (local) format HH:MI:SS AM/PM
General Data Type: TIME

Hdatetime

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

Hydro_Timestamp; Date&Time combined format mm/dd/yyyy HH24:MI
General Data Type: TIMESTAMP

Hjdate

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

Hydro_Julian date, or yearday
General Data Type: DOUBLE PRECISION

mon

CC ID: 372165
Seq. Order: 16
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: 372166
Seq. Order: 17
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

sst

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

Sea-surface temperature
General Data Type: DOUBLE PRECISION

sss

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

Sea-surface salinity
General Data Type: DOUBLE PRECISION

ssdo

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

Sea-surface dissolved-oxygen
General Data Type: DOUBLE PRECISION

bt

CC ID: 372170
Seq. Order: 21
Data Storage Type: DOUBLE PRECISION
Max Length: 8
Required: No
Primary Key: No
Precision: 4
Scale: 2
Status: Active
Description:

bottom temperature (deepest observation, not necessarily on bottom)
General Data Type: DOUBLE PRECISION

bs

CC ID: 372171
Seq. Order: 22
Data Storage Type: DOUBLE PRECISION
Max Length: 8
Required: No
Primary Key: No
Precision: 4
Scale: 2
Status: Active
Description:

bottom salinity
General Data Type: DOUBLE PRECISION

bdo

CC ID: 372172
Seq. Order: 23
Data Storage Type: DOUBLE PRECISION
Max Length: 8
Required: No
Primary Key: No
Precision: 3
Scale: 2
Status: Active
Description:

bottom dissolved-oxygen
General Data Type: DOUBLE PRECISION

bdpt

CC ID: 372173
Seq. Order: 24
Data Storage Type: DOUBLE PRECISION
Max Length: 8
Required: No
Primary Key: No
Precision: 5
Scale: 2
Status: Active
Description:

Depth (m) of deepest observation
General Data Type: DOUBLE PRECISION

Catalog Details

Catalog Item ID: 36199
GUID: gov.noaa.nmfs.inport:36199
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2017-01-04 11:39+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