Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Calculates the calcification rate by unit (by grouping the upper and lower plates together), and is reported in the V_NCEI_OCC_CAU Dataview.

Description

Calcification Accretion Unit Entity. Calculates the calcification rate by unit (by grouping the upper and lower plates together)

Entity Information

Entity Type
Data View

Data Attribute / Type Description
REGION
TEXT
Code for REGION
REGION_NAME
TEXT
The name of the region where the CAUs were deployed and recovered in the Atlantic Islands region.
LOCATION
TEXT
Name of island or atoll where the CAUs were deployed and recovered in the Atlantic Islands region (REGION).
REA_SITEID
TEXT
An identifier for the ecological site at the island or atoll (LOCATION) associated with the CAU deployment and recovery. Combines a 3-letter island code (derived from LOCATION) with a 2-4 digit site number.
OCC_SITEID
TEXT
An identifier for the fixed climate site where CAU units were deployed and recovered. An OCC_SITEID is a 3-dimensional identifier that describes a location (LATITUDE and LONGITUDE) and depth of a fixed NCRMP climate site and includes "OCC" prefix, a 3-letter location code (derived from LOCATION), and a 3-digit site number.
DATASTATUSID
NUMBER
Data quality control flag for calcification rate data generated during the laboratory analysis procedure. 0=good data, 1=best estimate values inserted due to blank entries, 2=plate or filters were only weighed once, 3=difference between filter or plate weights were not <0.1g difference, 4=missing filter paper or paper tray start weights, 5=difference between filter or plate weights were between -0.15 and 0.15, 6=difference between filter or plate weights were between -0.2 and 0.2, 7=data is only available for one of the two plates (upper or lower).
SERIALNUMBER
NUMBER
CAU Serial Number. A negative is assigned to a serial number in the unusual event that the serial number for a CAU is repeated.
CAU_UNIT
TEXT
An identifier for the CAU unit at the island or atolls specific site of deployment and recovery (LOCATION). Includes site identifier (REA_SITEID) and the serial number (SERIALNUMBER).
CALCIFICATION_RATE_BY_UNIT
NUMBER
Calcification Rate (measured in grams per centimeter per year).
LATITUDE
NUMBER
Latitude in decimal degrees, WGS84, for the CAU deployment and recovery site.
LONGITUDE
NUMBER
Longitude in decimal degrees, WGS84, for the CAU deployment and recovery site.
DAYS_IN_WATER
NUMBER
Number of days in the water.
YEARS_IN_WATER
NUMBER
Number of years in the water.
DEPLOYMENT_MISSION
TEXT
Deployment Mission Identifier.
DEPLOYMENT_DATE
DATE
Date (local) the CAU unit was deployed (m/dd/yyyy).
DEPLOYMENT_YEAR
NUMBER
Deployment Year (yyyy).
RECOVERY_MISSION
TEXT
Recovery Mission Identifier.
RECOVERY_DATE
DATE
Date (local) the CAU unit was recovered (m/dd/yyyy).
RECOVERY_YEAR
NUMBER
Recovery Year (yyyy).

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: Calcification Accretion Unit Entity
Short Name: CAU Entity
Status: Completed
Abstract:

Calculates the calcification rate by unit (by grouping the upper and lower plates together), and is reported in the V_NCEI_OCC_CAU Dataview.

Entity Information

Entity Type: Data View
Active Version?: Yes
Schema Name: GISDAT
Description:

Calcification Accretion Unit Entity. Calculates the calcification rate by unit (by grouping the upper and lower plates together)

Change Summary:

As of 2018 these are the active / relevant fields:

REGION, REGION_NAME, LOCATION, REA_SITEID, OCC_SITEID, DATASTATUSID, SERIALNUMBER, CAU_UNIT, CALCIFICATION_RATE_BY_UNIT, LATITUDE, LONGITUDE, DAYS_IN_WATER, YEARS_IN_WATER, DEPLOYMENT_MISSION, DEPLOYMENT_DATE, DEPLOYMENT_YEAR, RECOVERY_MISSION, RECOVERY_DATE, RECOVERY_YEAR

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
REGION TEXT Code for REGION
100
REGION_NAME TEXT The name of the region where the CAUs were deployed and recovered in the Atlantic Islands region.
100
LOCATION TEXT Name of island or atoll where the CAUs were deployed and recovered in the Atlantic Islands region (REGION).
100
REA_SITEID TEXT An identifier for the ecological site at the island or atoll (LOCATION) associated with the CAU deployment and recovery. Combines a 3-letter island code (derived from LOCATION) with a 2-4 digit site number.
100
OCC_SITEID TEXT An identifier for the fixed climate site where CAU units were deployed and recovered. An OCC_SITEID is a 3-dimensional identifier that describes a location (LATITUDE and LONGITUDE) and depth of a fixed NCRMP climate site and includes "OCC" prefix, a 3-letter location code (derived from LOCATION), and a 3-digit site number.
100
DATASTATUSID NUMBER Data quality control flag for calcification rate data generated during the laboratory analysis procedure. 0=good data, 1=best estimate values inserted due to blank entries, 2=plate or filters were only weighed once, 3=difference between filter or plate weights were not <0.1g difference, 4=missing filter paper or paper tray start weights, 5=difference between filter or plate weights were between -0.15 and 0.15, 6=difference between filter or plate weights were between -0.2 and 0.2, 7=data is only available for one of the two plates (upper or lower).
100
SERIALNUMBER NUMBER CAU Serial Number. A negative is assigned to a serial number in the unusual event that the serial number for a CAU is repeated.
100
CAU_UNIT TEXT An identifier for the CAU unit at the island or atolls specific site of deployment and recovery (LOCATION). Includes site identifier (REA_SITEID) and the serial number (SERIALNUMBER).
100
CALCIFICATION_RATE_BY_UNIT NUMBER Calcification Rate (measured in grams per centimeter per year).
100
LATITUDE NUMBER Latitude in decimal degrees, WGS84, for the CAU deployment and recovery site.
100
LONGITUDE NUMBER Longitude in decimal degrees, WGS84, for the CAU deployment and recovery site.
100
DAYS_IN_WATER NUMBER Number of days in the water.
100
YEARS_IN_WATER NUMBER Number of years in the water.
100
DEPLOYMENT_MISSION TEXT Deployment Mission Identifier.
100
DEPLOYMENT_DATE DATE Date (local) the CAU unit was deployed (m/dd/yyyy).
100
DEPLOYMENT_YEAR NUMBER Deployment Year (yyyy).
100
RECOVERY_MISSION TEXT Recovery Mission Identifier.
100
RECOVERY_DATE DATE Date (local) the CAU unit was recovered (m/dd/yyyy).
100
RECOVERY_YEAR NUMBER Recovery Year (yyyy).

Attribute Details

REGION

CC ID: 1179680
Seq. Order: 1
Data Storage Type: TEXT
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Code for REGION

REGION_NAME

CC ID: 1179681
Seq. Order: 2
Data Storage Type: TEXT
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

The name of the region where the CAUs were deployed and recovered in the Atlantic Islands region.

LOCATION

CC ID: 1179673
Seq. Order: 3
Data Storage Type: TEXT
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Name of island or atoll where the CAUs were deployed and recovered in the Atlantic Islands region (REGION).

REA_SITEID

CC ID: 1179676
Seq. Order: 4
Data Storage Type: TEXT
Max Length: 50
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

An identifier for the ecological site at the island or atoll (LOCATION) associated with the CAU deployment and recovery. Combines a 3-letter island code (derived from LOCATION) with a 2-4 digit site number.

OCC_SITEID

CC ID: 1179675
Seq. Order: 5
Data Storage Type: TEXT
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

An identifier for the fixed climate site where CAU units were deployed and recovered. An OCC_SITEID is a 3-dimensional identifier that describes a location (LATITUDE and LONGITUDE) and depth of a fixed NCRMP climate site and includes "OCC" prefix, a 3-letter location code (derived from LOCATION), and a 3-digit site number.

DATASTATUSID

CC ID: 1179667
Seq. Order: 6
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Data quality control flag for calcification rate data generated during the laboratory analysis procedure. 0=good data, 1=best estimate values inserted due to blank entries, 2=plate or filters were only weighed once, 3=difference between filter or plate weights were not <0.1g difference, 4=missing filter paper or paper tray start weights, 5=difference between filter or plate weights were between -0.15 and 0.15, 6=difference between filter or plate weights were between -0.2 and 0.2, 7=data is only available for one of the two plates (upper or lower).

SERIALNUMBER

CC ID: 1179682
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

CAU Serial Number. A negative is assigned to a serial number in the unusual event that the serial number for a CAU is repeated.

CAU_UNIT

CC ID: 1179666
Seq. Order: 8
Data Storage Type: TEXT
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

An identifier for the CAU unit at the island or atolls specific site of deployment and recovery (LOCATION). Includes site identifier (REA_SITEID) and the serial number (SERIALNUMBER).

CALCIFICATION_RATE_BY_UNIT

CC ID: 1179665
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Calcification Rate (measured in grams per centimeter per year).

LATITUDE

CC ID: 1179672
Seq. Order: 10
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Latitude in decimal degrees, WGS84, for the CAU deployment and recovery site.

LONGITUDE

CC ID: 1179674
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Longitude in decimal degrees, WGS84, for the CAU deployment and recovery site.

DAYS_IN_WATER

CC ID: 1179668
Seq. Order: 12
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Number of days in the water.

YEARS_IN_WATER

CC ID: 1179683
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 0
Status: Active
Description:

Number of years in the water.

DEPLOYMENT_MISSION

CC ID: 1179670
Seq. Order: 14
Data Storage Type: TEXT
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Deployment Mission Identifier.

DEPLOYMENT_DATE

CC ID: 1179669
Seq. Order: 15
Data Storage Type: DATE
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Date (local) the CAU unit was deployed (m/dd/yyyy).

DEPLOYMENT_YEAR

CC ID: 1179671
Seq. Order: 16
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 0
Status: Active
Description:

Deployment Year (yyyy).

RECOVERY_MISSION

CC ID: 1179678
Seq. Order: 17
Data Storage Type: TEXT
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Recovery Mission Identifier.

RECOVERY_DATE

CC ID: 1179677
Seq. Order: 18
Data Storage Type: DATE
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Date (local) the CAU unit was recovered (m/dd/yyyy).

RECOVERY_YEAR

CC ID: 1179679
Seq. Order: 19
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Recovery Year (yyyy).

Catalog Details

Catalog Item ID: 67619
GUID: gov.noaa.nmfs.inport:67619
Metadata Record Created By: Michael W Akridge
Metadata Record Created: 2022-08-04 22:35+0000
Metadata Record Last Modified By: Lori H Luers
Metadata Record Last Modified: 2022-10-20 01:25+0000
Metadata Record Published: 2022-10-20
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Review Frequency: 1 Year