Water Chemistry Entity
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:36874 | Updated: August 9, 2022 | Published / External
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
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
Seq. Order: | 1 |
---|---|
Data Storage Type: | Text |
Max Length: | 255 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Unique ID for CTD Cast |
RegionCode
Seq. Order: | 2 |
---|---|
Data Storage Type: | Text |
Max Length: | 255 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Unique ID for Region |
Region
Seq. Order: | 3 |
---|---|
Data Storage Type: | Text |
Max Length: | 255 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Full Length Region Information |
Year
Seq. Order: | 4 |
---|---|
Data Storage Type: | Double |
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
4 digit Year |
Cruise
Seq. Order: | 5 |
---|---|
Data Storage Type: | Text |
Max Length: | 255 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Cruise ID |
LocationCode
Seq. Order: | 6 |
---|---|
Data Storage Type: | Text |
Max Length: | 255 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
3 Letter Unique Location ID |
Location
Seq. Order: | 7 |
---|---|
Data Storage Type: | Text |
Max Length: | 255 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Full Length Location Information |
Latitude
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
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
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)
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)
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
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
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)
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)
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
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
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)
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)
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)
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)
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)
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |