Slide Menu
System Maintenance Notice, Monday, December 5, 2022 @ 1pm-5pm Eastern. The Operations Team will be performing system maintenance. During this scheduled downtime, InPort will not be available.
View All
Search Help Show/Hide Menu

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 Coral Triangle.
100
LOCATION TEXT Name of island or atoll where the CAUs were deployed and recovered in the Coral Triangle (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 (mm/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 (mm/dd/yyyy).
100
RECOVERY_YEAR NUMBER Recovery Year (yyyy).

Attribute Details

REGION

CC ID: 700601
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: 700559
Seq. Order: 2
Data Storage Type: TEXT
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

The name of the region where the CAUs were deployed and recovered in the Coral Triangle.

LOCATION

CC ID: 700567
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 Coral Triangle (REGION).

REA_SITEID

CC ID: 700566
Seq. Order: 4
Data Storage Type: TEXT
Max Length: 30
Required: No
Primary Key: No
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: 700554
Seq. Order: 5
Data Storage Type: TEXT
Max Length: 50
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: 700553
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: 700560
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: 700561
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: 700555
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: 700568
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: 700557
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: 700556
Seq. Order: 12
Data Storage Type: NUMBER
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Number of days in the water.

YEARS_IN_WATER

CC ID: 700558
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 7
Required: No
Primary Key: No
Scale: 0
Status: Active
Description:

Number of years in the water.

DEPLOYMENT_MISSION

CC ID: 700563
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: 700562
Seq. Order: 15
Data Storage Type: DATE
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

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

DEPLOYMENT_YEAR

CC ID: 700564
Seq. Order: 16
Data Storage Type: NUMBER
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Deployment Year (yyyy).

RECOVERY_MISSION

CC ID: 700602
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: 700603
Seq. Order: 18
Data Storage Type: DATE
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

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

RECOVERY_YEAR

CC ID: 700604
Seq. Order: 19
Data Storage Type: NUMBER
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Recovery Year (yyyy).

Catalog Details

Catalog Item ID: 50523
GUID: gov.noaa.nmfs.inport:50523
Metadata Record Created By: Annette M DesRochers
Metadata Record Created: 2017-12-01 17:41+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2022-08-03
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2022-08-03
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2023-08-03