Item Identification

Title: Water Chemistry Entity
Abstract:

Water Chemistry Entity and Attributes

Entity Information

Entity Type: Spreadsheet
Active Version?: Yes
Description:

Water Chemistry Entity and Attributes

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
ShallowCTDID Text Unique ID for CTD Cast
100
RegionCode Text Unique ID for Region
100
Region Text Full Length Region Information
100
Year Double 4 digit Year
100
Cruise Text Cruise ID
100
LocationCode Text 3 Letter Unique Location ID
100
Location Text Full Length Location Information
100
Latitude Double Latitude in decimal degree format
100
Longitude Double Longitude in decimal degree format
100
UTCDateTime Date/Time UTC Date of Cast in format MM/DD/YYYY
100
Sample_Depth_(m) Double Depth Sample was taken in meters
100
Sample_Depth_(ft) Double Depth Sample was taken in feet
100
Duplicate_Sample Yes/No Two samples were taken at this site and depth, Values = "TRUE" - this is a duplicate Sample, "False" - this is not a duplicate sample
100
CHL Sample Status Text Values = "Data Available", "Flagged for Review", and "No Sample"
100
Chl-a (µg/L) Double Analysis value measured in micrograms per liter
100
Pheo (µg/L) Double Analysis value measured in micrograms per liter
100
P:Chl Double Analysis value as a ratio
100
NUT Sample Status Text Values = "Data Available", "Flagged for Review", and "No Sample"
100
PO43- (uM) Double Analysis value
100
SiO2 (uM) Double Analysis value measured in micromoles
100
NO3- (uM) Double Analysis value measured in micromoles
100
NO2- (uM) Double Analysis value measured in micromoles
100
NO3+NO2 (uM) Double Analysis value measured in micromoles
100
DIC Sample Status Text Values = "Data Available", "Flagged for Review", and "No Sample"
100
DIC Double Analysis value measured in micromoles per kilogram
100
TA Double Analysis value measured in micromoles per kilogram
100
SAL Sample Status Text Values = "Data Available", "Flagged for Review", and "No Sample"
100
Salinity_Bottle Double Analysis value as Practical Salinity Units
100
Conductivity_S/m_Calculated Double Value based on water sample evaluation measured in Siemens per meter
100
Salinity_4DICCalc Double Value based on water sample evaluation as Practical Salinity Units
100
Temperature_DegC_4DICCalc Double Most accurate temperature value available used to calculate DIC value, measured in degrees Celsius
100
Pressure_db_4DICCalc Double Most accurate Pressure value available used to calculate DIC value, measured in decibars
100
Associated CTD Data Exists Text Yes=Data Exists, No=Data Does Not Exist
100
Pressure_db Double Pressure value from CTD unit measured in decibars
100
Depth_m Double Depth value from CTD unit measured in meters
100
Temp_DegC Double Temperature value from CTD unit measured in degrees Celsius
100
Cond_S_per_m Double Conductivity value from CTD unit measured in Siemens per meter
100
Saln_PSU Double Salinity value from CTD unit
100
Density_Sigmat Double Density value calculated from CTD unit readings in kilogram/cubic meter units
100
REA_Site Text Climate Station and biological Site name

Attribute Details

ShallowCTDID

CC ID: 383167
Seq. Order: 1
Data Storage Type: Text
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Unique ID for CTD Cast

RegionCode

CC ID: 383160
Seq. Order: 2
Data Storage Type: Text
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Unique ID for Region

Region

CC ID: 383159
Seq. Order: 3
Data Storage Type: Text
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Full Length Region Information

Year

CC ID: 383173
Seq. Order: 4
Data Storage Type: Double
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

4 digit Year

Cruise

CC ID: 383139
Seq. Order: 5
Data Storage Type: Text
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Cruise ID

LocationCode

CC ID: 383147
Seq. Order: 6
Data Storage Type: Text
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

3 Letter Unique Location ID

Location

CC ID: 383146
Seq. Order: 7
Data Storage Type: Text
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Full Length Location Information

Latitude

CC ID: 383145
Seq. Order: 8
Data Storage Type: Double
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Latitude in decimal degree format

Unit of Measure: decimal degree

Longitude

CC ID: 383148
Seq. Order: 9
Data Storage Type: Double
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Longitude in decimal degree format

Unit of Measure: decimal degree

UTCDateTime

CC ID: 383172
Seq. Order: 10
Data Storage Type: Date/Time
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

UTC Date of Cast in format MM/DD/YYYY

Sample_Depth_(m)

CC ID: 383166
Seq. Order: 11
Data Storage Type: Double
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Depth Sample was taken in meters

Unit of Measure: meters

Sample_Depth_(ft)

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

Depth Sample was taken in feet

Unit of Measure: feet

Duplicate_Sample

CC ID: 383144
Seq. Order: 13
Data Storage Type: Yes/No
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Two samples were taken at this site and depth, Values = "TRUE" - this is a duplicate Sample, "False" - this is not a duplicate sample

CHL Sample Status

CC ID: 383135
Seq. Order: 14
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Values = "Data Available", "Flagged for Review", and "No Sample"

Chl-a (µg/L)

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

Analysis value measured in micrograms per liter

Unit of Measure: µg/L

Pheo (µg/L)

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

Analysis value measured in micrograms per liter

Unit of Measure: µg/L

P:Chl

CC ID: 383153
Seq. Order: 17
Data Storage Type: Double
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Analysis value as a ratio

Unit of Measure: ratio

NUT Sample Status

CC ID: 383152
Seq. Order: 18
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Values = "Data Available", "Flagged for Review", and "No Sample"

PO43- (uM)

CC ID: 383154
Seq. Order: 19
Data Storage Type: Double
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Analysis value

Unit of Measure: uM

SiO2 (uM)

CC ID: 383168
Seq. Order: 20
Data Storage Type: Double
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Analysis value measured in micromoles

Unit of Measure: uM

NO3- (uM)

CC ID: 383151
Seq. Order: 21
Data Storage Type: Double
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Analysis value measured in micromoles

Unit of Measure: uM

NO2- (uM)

CC ID: 383149
Seq. Order: 22
Data Storage Type: Double
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Analysis value measured in micromoles

Unit of Measure: uM

NO3+NO2 (uM)

CC ID: 383150
Seq. Order: 23
Data Storage Type: Double
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Analysis value measured in micromoles

Unit of Measure: uM

DIC Sample Status

CC ID: 383141
Seq. Order: 24
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Values = "Data Available", "Flagged for Review", and "No Sample"

DIC

CC ID: 383140
Seq. Order: 25
Data Storage Type: Double
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Analysis value measured in micromoles per kilogram

Unit of Measure: umol/kg

TA

CC ID: 383169
Seq. Order: 26
Data Storage Type: Double
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Analysis value measured in micromoles per kilogram

Unit of Measure: umol/kg

SAL Sample Status

CC ID: 383161
Seq. Order: 27
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Values = "Data Available", "Flagged for Review", and "No Sample"

Salinity_Bottle

CC ID: 383163
Seq. Order: 28
Data Storage Type: Double
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Analysis value as Practical Salinity Units

Unit of Measure: PSU

Conductivity_S/m_Calculated

CC ID: 383138
Seq. Order: 29
Data Storage Type: Double
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Value based on water sample evaluation measured in Siemens per meter

Unit of Measure: Siemens/m

Salinity_4DICCalc

CC ID: 383162
Seq. Order: 30
Data Storage Type: Double
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Value based on water sample evaluation as Practical Salinity Units

Unit of Measure: PSU

Temperature_DegC_4DICCalc

CC ID: 383171
Seq. Order: 31
Data Storage Type: Double
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Most accurate temperature value available used to calculate DIC value, measured in degrees Celsius

Unit of Measure: degree C

Pressure_db_4DICCalc

CC ID: 383157
Seq. Order: 32
Data Storage Type: Double
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Most accurate Pressure value available used to calculate DIC value, measured in decibars

Unit of Measure: decibars

Associated CTD Data Exists

CC ID: 383134
Seq. Order: 33
Data Storage Type: Text
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Yes=Data Exists, No=Data Does Not Exist

Pressure_db

CC ID: 383156
Seq. Order: 34
Data Storage Type: Double
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Pressure value from CTD unit measured in decibars

Unit of Measure: decibars

Depth_m

CC ID: 383143
Seq. Order: 35
Data Storage Type: Double
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Depth value from CTD unit measured in meters

Unit of Measure: meters

Temp_DegC

CC ID: 383170
Seq. Order: 36
Data Storage Type: Double
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Temperature value from CTD unit measured in degrees Celsius

Unit of Measure: degree C

Cond_S_per_m

CC ID: 383137
Seq. Order: 37
Data Storage Type: Double
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Conductivity value from CTD unit measured in Siemens per meter

Unit of Measure: Seimens/m

Saln_PSU

CC ID: 383164
Seq. Order: 38
Data Storage Type: Double
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Salinity value from CTD unit

Unit of Measure: PSU

Density_Sigmat

CC ID: 383142
Seq. Order: 39
Data Storage Type: Double
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Density value calculated from CTD unit readings in kilogram/cubic meter units

Unit of Measure: kg/m3

REA_Site

CC ID: 383158
Seq. Order: 40
Data Storage Type: Text
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Climate Station and biological Site name

Catalog Details

Catalog Item ID: 36874
Metadata Record Created By: Troy T Kanemura
Metadata Record Created: 2017-02-22 17:12+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2019-06-04 13:14+0000
Metadata Record Published: 2018-11-30
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2019-12-01