ESD_NCRMP_DS_2022_MARIAN_SUMMARY_DataDictionary
Pacific Islands Fisheries Science Center
Entity
(ENT)
| ID: 55421
| Published / External
Created: 2019-01-31
|
Last Modified: 2025-03-11
Parent: National Coral Reef Monitoring Program: Diel seawater carbonate chemistry observations from a suite of instrumentation deployed at coral reef sites in the Mariana Archipelago in...
Data Set (DS) | ID: 54927
Data Set (DS) | ID: 54927
ID: 55421
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
| * » Title | ESD_NCRMP_DS_2022_MARIAN_SUMMARY_DataDictionary |
|---|---|
| Short Name | ESD_NCRMP_DS_2022_MARIAN_SUMMARY_DataDictionary |
| * Status | Completed |
| Creation Date | |
| Revision Date | |
| • Publication Date | |
| * » Abstract |
Metadata entity and attributes for diel surveys. Includes information for each site where diel surveys were conducted in that particular region and year as well as notes for instruments deployed. |
| * Purpose | |
| Notes | |
| Other Citation Details | |
| • Supplemental Information | |
| DOI (Digital Object Identifier) | |
| DOI Registration Authority | |
| DOI Issue Date |
Keywords
Theme Keywords
| Thesaurus | Keyword |
|---|---|
Temporal Keywords
| Thesaurus | Keyword |
|---|---|
* Spatial Keywords
| Thesaurus | Keyword |
|---|---|
Stratum Keywords
| Thesaurus | Keyword |
|---|---|
Instrument Keywords
| Thesaurus | Keyword |
|---|---|
Platform Keywords
| Thesaurus | Keyword |
|---|---|
Physical Location
| • » Organization | |
|---|---|
| • » City | |
| • » State/Province | |
| • Country | |
| • » Location Description |
Entity Information
| Entity Type | Spreadsheet |
|---|---|
| Active Version? | Y |
| Alias | |
| Schema Name | |
| » Description |
Metadata entities and attributes for diel surveys. Includes the summary details for the deployment of each diel suite, by DSUITEID. At different sites different instruments may have been deployed, or there may have been a failure in an instrument. |
| Change Summary |
In 2021, a unique identifier for diel suite deployments was included as DSUITEID to improve data structure across data tables. Other columns were renamed or added to improve data management efficiency. |
Data Attributes
Attribute Summary
| Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
|---|---|---|---|---|---|
| 100 | No | No | DSUITEID | NUMERIC | Unique identifier for each Diel Suite deployed. |
| 100 | No | No | REGION | TEXT | The name of the region where the CTD cast was conducted in the Pacific Islands region: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands. |
| 100 | No | No | REGIONCODE | TEXT | Code for the region surveyed in the Pacific Islands region: American Samoa (SAMOA), Pacific Remote Island Areas (PRIA), Mariana Archipelago (MARIAN), main Hawaiian Islands (MHI), Northwestern Hawaiian Islands (NWHI). |
| 100 | No | No | YEAR | NUMERIC | Year diel suite was deployed. |
| 100 | No | No | CRUISE_ID | TEXT | A single designation that applies to all the rounds associated with a given mission/cruise. |
| 100 | No | No | EXPOCODE | TEXT | Defined as the Ship ICES code + departure date formatted as YYYYMMDD. |
| 100 | No | No | MISSION_CODE | TEXT | More descriptive name of cruise/mission. |
| 100 | No | No | LOCATION | TEXT | Name of island or atoll where the sample was collected in the Pacific Islands region (REGION). |
| 100 | No | No | LOCATIONCODE | TEXT | 3-Letter unique code for LOCATION. |
| 100 | No | No | OCC_SITEID | TEXT | A 3-dimensional identifier for the fixed site location (LATITUDE and LONGITUDE) and depth. Includes "OCC" prefix, a 3-letter location code (derived from LOCATION), and a 3-digit site number. |
| 100 | No | No | ASSOC_REA_SITE | TEXT | An identifier for the ecological site at the island or atoll (LOCATION) associated with the diel survey. Combines a 3-letter island code (derived from LOCATIONCODE) with a 2-4 digit site number. |
| 100 | No | No | LATITUDE | NUMERIC | Latitude in decimal degrees, WGS84, for the given site. |
| 100 | No | No | LONGITUDE | NUMERIC | Longitude in decimal degrees, WGS84, for the given site. |
| 100 | No | No | SITE_DEPTH_M | NUMERIC | Depth of sensor deployment site in meters. |
| 100 | No | No | VALIDDATASTART | DATE | Time and Date of earliest vaild data record. |
| 100 | No | No | VALIDDATAEND | DATE | Time and Date of latest vaild data record. |
| 100 | No | No | DEPLOY_SITEVISITID | NUMERIC | Unique Identifier for Deployment SITE_VISIT record. |
| 100 | No | No | RETRIEVE_SITEVISITID | NUMERIC | Unique Identifier for Retrieval SITE_VISIT record. |
| 100 | No | No | ADCP_YN | TEXT | Flag to indicate if ADCP data is available for a SiteID (yes or no). |
| 100 | No | No | CTD_YN | TEXT | Flag to indicate if CTD data is available for a SiteID (yes or no). |
| 100 | No | No | OXYGEN_YN | TEXT | Flag to indicate if DO data is available for a SiteID (yes or no). |
| 100 | No | No | PAR_YN | TEXT | Flag to indicate if PAR datais available for a SiteID (yes or no). |
| 100 | No | No | PH_YN | TEXT | Flag to indicate if pH data from the SeaFET is available for a SiteID (yes or no). |
| 100 | No | No | WATERSAMPLE_YN | TEXT | Flag to indicate if carbonate chemistry data from water samples is available for a SiteID (yes or no). |
| 100 | No | No | TCM_YN | TEXT | Flag to indicate if tilt current meter data is available for a SiteID (yes or no). |
| 100 | No | No | ADCP_SAMPLEINTERVAL_SEC | NUMERIC | Sample interval for ADCP data. NULL if no data. |
| 100 | No | No | CTD_SAMPLEINTERVAL_SEC | NUMERIC | Sample interval for CTD data. NULL if no data. |
| 100 | No | No | OXYGEN_SAMPLEINTERVAL_SEC | NUMERIC | Sample interval for DO data. NULL if no data. |
| 100 | No | No | PAR_SAMPLEINTERVAL_SEC | NUMERIC | Sample interval for PAR data. NULL if no data. |
| 100 | No | No | PH_SAMPLEINTERVAL_SEC | NUMERIC | Sample interval for pH data. NULL if no data. |
| 100 | No | No | WATERSAMPLE_SAMPLEINTERVAL_SEC | NUMERIC | Sample interval for water sample data. NULL if no data. |
| 100 | No | No | TCM_SAMPLEINTERVAL_SEC | NUMERIC | Sample interval for TCM data. NULL if no data. |
| 100 | No | No | NOTES | TEXT | Comments about the diel survey conducted at the SiteID provided by OCC team that may be useful to the data user. |
Attribute Details
| Attribute Name | DSUITEID |
|---|---|
| Seq. Order | 1 |
| Data Storage Type | NUMERIC |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Unique identifier for each Diel Suite deployed. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | REGION |
|---|---|
| Seq. Order | 2 |
| Data Storage Type | TEXT |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
The name of the region where the CTD cast was conducted in the Pacific Islands region: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | REGIONCODE |
|---|---|
| Seq. Order | 3 |
| Data Storage Type | TEXT |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Code for the region surveyed in the Pacific Islands region: American Samoa (SAMOA), Pacific Remote Island Areas (PRIA), Mariana Archipelago (MARIAN), main Hawaiian Islands (MHI), Northwestern Hawaiian Islands (NWHI). |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | YEAR |
|---|---|
| Seq. Order | 4 |
| Data Storage Type | NUMERIC |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Year diel suite was deployed. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | CRUISE_ID |
|---|---|
| Seq. Order | 5 |
| Data Storage Type | TEXT |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
A single designation that applies to all the rounds associated with a given mission/cruise. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | EXPOCODE |
|---|---|
| Seq. Order | 6 |
| Data Storage Type | TEXT |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Defined as the Ship ICES code + departure date formatted as YYYYMMDD. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | MISSION_CODE |
|---|---|
| Seq. Order | 7 |
| Data Storage Type | TEXT |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
More descriptive name of cruise/mission. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LOCATION |
|---|---|
| Seq. Order | 8 |
| Data Storage Type | TEXT |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Name of island or atoll where the sample was collected in the Pacific Islands region (REGION). |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LOCATIONCODE |
|---|---|
| Seq. Order | 9 |
| Data Storage Type | TEXT |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
3-Letter unique code for LOCATION. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | OCC_SITEID |
|---|---|
| Seq. Order | 10 |
| Data Storage Type | TEXT |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
A 3-dimensional identifier for the fixed site location (LATITUDE and LONGITUDE) and depth. Includes "OCC" prefix, a 3-letter location code (derived from LOCATION), and a 3-digit site number. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ASSOC_REA_SITE |
|---|---|
| Seq. Order | 11 |
| Data Storage Type | TEXT |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
An identifier for the ecological site at the island or atoll (LOCATION) associated with the diel survey. Combines a 3-letter island code (derived from LOCATIONCODE) with a 2-4 digit site number. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LATITUDE |
|---|---|
| Seq. Order | 12 |
| Data Storage Type | NUMERIC |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Latitude in decimal degrees, WGS84, for the given site. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LONGITUDE |
|---|---|
| Seq. Order | 13 |
| Data Storage Type | NUMERIC |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Longitude in decimal degrees, WGS84, for the given site. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | SITE_DEPTH_M |
|---|---|
| Seq. Order | 14 |
| Data Storage Type | NUMERIC |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Depth of sensor deployment site in meters. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | VALIDDATASTART |
|---|---|
| Seq. Order | 15 |
| Data Storage Type | DATE |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Time and Date of earliest vaild data record. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | VALIDDATAEND |
|---|---|
| Seq. Order | 16 |
| Data Storage Type | DATE |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Time and Date of latest vaild data record. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | DEPLOY_SITEVISITID |
|---|---|
| Seq. Order | 17 |
| Data Storage Type | NUMERIC |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Unique Identifier for Deployment SITE_VISIT record. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | RETRIEVE_SITEVISITID |
|---|---|
| Seq. Order | 18 |
| Data Storage Type | NUMERIC |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Unique Identifier for Retrieval SITE_VISIT record. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ADCP_YN |
|---|---|
| Seq. Order | 19 |
| Data Storage Type | TEXT |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Flag to indicate if ADCP data is available for a SiteID (yes or no). |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | CTD_YN |
|---|---|
| Seq. Order | 20 |
| Data Storage Type | TEXT |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Flag to indicate if CTD data is available for a SiteID (yes or no). |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | OXYGEN_YN |
|---|---|
| Seq. Order | 21 |
| Data Storage Type | TEXT |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Flag to indicate if DO data is available for a SiteID (yes or no). |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | PAR_YN |
|---|---|
| Seq. Order | 22 |
| Data Storage Type | TEXT |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Flag to indicate if PAR datais available for a SiteID (yes or no). |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | PH_YN |
|---|---|
| Seq. Order | 23 |
| Data Storage Type | TEXT |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Flag to indicate if pH data from the SeaFET is available for a SiteID (yes or no). |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | WATERSAMPLE_YN |
|---|---|
| Seq. Order | 24 |
| Data Storage Type | TEXT |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Flag to indicate if carbonate chemistry data from water samples is available for a SiteID (yes or no). |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | TCM_YN |
|---|---|
| Seq. Order | 25 |
| Data Storage Type | TEXT |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Flag to indicate if tilt current meter data is available for a SiteID (yes or no). |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ADCP_SAMPLEINTERVAL_SEC |
|---|---|
| Seq. Order | 26 |
| Data Storage Type | NUMERIC |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Sample interval for ADCP data. NULL if no data. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | CTD_SAMPLEINTERVAL_SEC |
|---|---|
| Seq. Order | 27 |
| Data Storage Type | NUMERIC |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Sample interval for CTD data. NULL if no data. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | OXYGEN_SAMPLEINTERVAL_SEC |
|---|---|
| Seq. Order | 28 |
| Data Storage Type | NUMERIC |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Sample interval for DO data. NULL if no data. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | PAR_SAMPLEINTERVAL_SEC |
|---|---|
| Seq. Order | 29 |
| Data Storage Type | NUMERIC |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Sample interval for PAR data. NULL if no data. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | PH_SAMPLEINTERVAL_SEC |
|---|---|
| Seq. Order | 30 |
| Data Storage Type | NUMERIC |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Sample interval for pH data. NULL if no data. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | WATERSAMPLE_SAMPLEINTERVAL_SEC |
|---|---|
| Seq. Order | 31 |
| Data Storage Type | NUMERIC |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Sample interval for water sample data. NULL if no data. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | TCM_SAMPLEINTERVAL_SEC |
|---|---|
| Seq. Order | 32 |
| Data Storage Type | NUMERIC |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Sample interval for TCM data. NULL if no data. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | NOTES |
|---|---|
| Seq. Order | 33 |
| Data Storage Type | TEXT |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Comments about the diel survey conducted at the SiteID provided by OCC team that may be useful to the data user. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | |
|---|---|
| Seq. Order | |
| Data Storage Type | |
| Max Length | |
| Precision | |
| Scale | |
| Required | |
| Primary Key | |
| Status | |
| Description | |
| General Data Type | |
| Case Restriction | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Min Length | |
| Unit of Measure | |
| Display Example | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | |
|---|---|
| Seq. Order | |
| Data Storage Type | |
| Max Length | |
| Precision | |
| Scale | |
| Required | |
| Primary Key | |
| Status | |
| Description | |
| General Data Type | |
| Case Restriction | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Min Length | |
| Unit of Measure | |
| Display Example | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | |
|---|---|
| Seq. Order | |
| Data Storage Type | |
| Max Length | |
| Precision | |
| Scale | |
| Required | |
| Primary Key | |
| Status | |
| Description | |
| General Data Type | |
| Case Restriction | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Min Length | |
| Unit of Measure | |
| Display Example | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
Support Roles
» At least one Distributor Org, one Metadata Contact, one Point of Contact, and one Data Steward should be listed.
| * » Support Role | |
|---|---|
| * » Date Effective From | |
| Date Effective To | |
| * » Contact | |
| * Contact Instructions |
| * » Support Role | |
|---|---|
| * » Date Effective From | |
| Date Effective To | |
| * » Contact | |
| * Contact Instructions |
| * » Support Role | |
|---|---|
| * » Date Effective From | |
| Date Effective To | |
| * » Contact | |
| * Contact Instructions |
Extents
| Currentness Reference |
|---|
Extent Group 1
| Extent Description |
|---|
Extent Group 1 / Geographic Area
| * » W° Bound | |
|---|---|
| * » E° Bound | |
| * » N° Bound | |
| * » S° Bound | |
| * » Description |
Extent Group 1 / Vertical Extent
| EPSG Code | |
|---|---|
| Vertical Minimum | |
| Vertical Maximum |
Extent Group 1 / Time Frame
| * » Time Frame Type | |
|---|---|
| * » Start | |
| End | |
| Alternate Start as of Info | |
| Alternate End as of Info | |
| Description |
Access Information
| * » Security Class | |
|---|---|
| * Security Classification System |
|
| Security Handling Description |
|
| • Data Access Policy |
|
| » Data Access Procedure |
|
| • » Data Access Constraints |
|
| • Data Use Constraints |
|
| Metadata Access Constraints |
|
| Metadata Use Constraints |
|
Distribution Information
| Start Date | |
|---|---|
| End Date | |
| » Download URL | |
| Distributor | |
| File Name | |
| Description | |
| File Date/Time | |
| File Type | |
| FGDC Content Type | |
| File Size | |
| Application Version | |
| Compression | |
| Review Status |
| Start Date | |
|---|---|
| End Date | |
| » Download URL | |
| Distributor | |
| File Name | |
| Description | |
| File Date/Time | |
| File Type | |
| FGDC Content Type | |
| File Size | |
| Application Version | |
| Compression | |
| Review Status |
| Start Date | |
|---|---|
| End Date | |
| » Download URL | |
| Distributor | |
| File Name | |
| Description | |
| File Date/Time | |
| File Type | |
| FGDC Content Type | |
| File Size | |
| Application Version | |
| Compression | |
| Review Status |
Activity Log
| Activity Time | |
|---|---|
| Activity Type | |
| Responsible Party | |
| Description |
| Activity Time | |
|---|---|
| Activity Type | |
| Responsible Party | |
| Description |
| Activity Time | |
|---|---|
| Activity Type | |
| Responsible Party | |
| Description |
Issues
| Issue Date | |
|---|---|
| Author | |
| Issue |
| Issue Date | |
|---|---|
| Author | |
| Issue |
| Issue Date | |
|---|---|
| Author | |
| Issue |
FAQs
| Date | |
|---|---|
| Author | |
| Question | |
| Answer |
Child Items
Rubric scores updated every 15m
| Score | Type | Title |
|---|---|---|
Related Items
| Item Type | Relationship Type | Title |
|---|---|---|
Catalog Details
| Catalog Item ID | 55421 |
|---|---|
| Metadata Record Created By | Annette M DesRochers |
| Metadata Record Created | 2019-01-31 21:17+0000 |
| Metadata Record Last Modified By | Lori H Luers |
| » Metadata Record Last Modified | 2025-03-11 17:14+0000 |
| Metadata Record Published | 2025-03-11 |
| Owner Org | PIFSC |
| Metadata Publication Status | Published Externally |
| Do Not Publish? | N |
| Metadata Workflow State | Published / External |
| Metadata Last Review Date | 2021-08-06 |
| Metadata Review Frequency | 1 Year |
| Metadata Next Review Date | 2022-08-06 |
| Tags |
|---|