Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
PIFSC Metadata Library > PIFSC Coral Reef Ecosystem Program (CREP) Metad... > Ecosystem Monitoring and Assessment > Pacific Reef Assessment and Monitoring Program:... >

Water Chemistry Entity

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

Summary

Abstract

Water Chemistry Entity and Attributes

Description

Water Chemistry Entity and Attributes

Entity Information

Entity Type
Spreadsheet

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

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (PIFSC) for inquiries on this record.

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
GUID: gov.noaa.nmfs.inport: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: 2022-08-09 17:11+0000
Metadata Record Published: 2018-11-30
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2018-11-30
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2019-11-30