Item Identification

Title: View: V_CALCIFICATION_RATE_TIMOR
Short Name: View: V_CALCIFICATION_RATE_TIMOR
Status: Completed
Abstract:

calculates the calcification rate by unit (by grouping the upper and lower plates together)

Entity Information

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

calculates the calcification rate by unit (by grouping the upper and lower plates together)

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
ISLAND NVARCHAR2 Island or Atoll surveyed (Timor-Leste)
100
SITE NVARCHAR2 The 6-character code for the site surveyed. Combines a 3-letter island code with a 2-digit site number separated by a hyphen.
100
SERIALNUMBER NUMBER CAU Serial Number (343 to 898)
100
CAU_UNIT NVARCHAR2 CAU Unit Identifier (SITE & SERIAL NUMBER, separated by a hyphen)
100
CALCIFICATION_RATE_BY_UNIT NUMBER Calcification rate, measured in grams per centimeter per year (0.031-0.116)
100
LATITUDE NUMBER Site latitude (-8.85329 to -8.22441)
100
LONGITUDE NUMBER Site longitude (125.01327 to 127.31222)
100
DAYS_IN_WATER NUMBER Number of days in the water (693 to 724)
100
YEARS_IN_WATER NUMBER Number of years in the water (1.9-1.98)
100
DEPLOYMENT_MISSION VARCHAR2 Deployment Mission Identifier (SB1215)
100
DEPLOYMENT_DATE DATE Deployment Date in mm/dd/yyyy format (Oct 15-25, 2012)
100
DEPLOYMENT_YEAR NUMBER Deployment Year in yyyy format (2012)
100
RECOVERY_MISSION VARCHAR2 Recovery Mission Identifier (MP1419)
100
RECOVERY_DATE DATE Recovery Date in mm/dd/yyyy format (Sept 16 to Oct 9 2014)
100
RECOVERY_YEAR NUMBER Recovery Year in yyyy format (2014)
100
REGION VARCHAR2 Name of the region in the Pacific CREP surveys (Coral Triangle)
100
DISTRICT TEXT Name of district in Timor-Leste nearest where CREP deployed the CAU
100
MEAN NUMERIC Mean calcification rate for the site, measured in grams per centimeter per year
100
STD_DEV NUMERIC Standard deviation of the mean calcification rate for the site
100
STD_ERR NUMERIC Standard error of the mean calcification rate for the site

Attribute Details

ISLAND

CC ID: 700559
Seq. Order: 2
Data Storage Type: NVARCHAR2
Max Length: 150
Required: No
Primary Key: No
Status: Active
Description:

Island or Atoll surveyed (Timor-Leste)

SITE

CC ID: 700567
Seq. Order: 3
Data Storage Type: NVARCHAR2
Max Length: 150
Required: No
Primary Key: No
Status: Active
Description:

The 6-character code for the site surveyed. Combines a 3-letter island code with a 2-digit site number separated by a hyphen.

SERIALNUMBER

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

CAU Serial Number (343 to 898)

CAU_UNIT

CC ID: 700554
Seq. Order: 5
Data Storage Type: NVARCHAR2
Max Length: 273
Required: No
Primary Key: No
Status: Active
Description:

CAU Unit Identifier (SITE & SERIAL NUMBER, separated by a hyphen)

CALCIFICATION_RATE_BY_UNIT

CC ID: 700553
Seq. Order: 6
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 (0.031-0.116)

LATITUDE

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

Site latitude (-8.85329 to -8.22441)

LONGITUDE

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

Site longitude (125.01327 to 127.31222)

DAYS_IN_WATER

CC ID: 700555
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Scale: 0
Status: Active
Description:

Number of days in the water (693 to 724)

YEARS_IN_WATER

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

Number of years in the water (1.9-1.98)

DEPLOYMENT_MISSION

CC ID: 700557
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 30
Required: Yes
Primary Key: No
Status: Active
Description:

Deployment Mission Identifier (SB1215)

DEPLOYMENT_DATE

CC ID: 700556
Seq. Order: 12
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

Deployment Date in mm/dd/yyyy format (Oct 15-25, 2012)

DEPLOYMENT_YEAR

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

Deployment Year in yyyy format (2012)

RECOVERY_MISSION

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

Recovery Mission Identifier (MP1419)

RECOVERY_DATE

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

Recovery Date in mm/dd/yyyy format (Sept 16 to Oct 9 2014)

RECOVERY_YEAR

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

Recovery Year in yyyy format (2014)

REGION

CC ID: 700569
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Name of the region in the Pacific CREP surveys (Coral Triangle)

DISTRICT

CC ID: 700601
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Name of district in Timor-Leste nearest where CREP deployed the CAU

MEAN

CC ID: 700602
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Mean calcification rate for the site, measured in grams per centimeter per year

STD_DEV

CC ID: 700603
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Standard deviation of the mean calcification rate for the site

STD_ERR

CC ID: 700604
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Standard error of the mean calcification rate for the site

Catalog Details

Catalog Item ID: 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: 2019-06-04 13:14+0000
Metadata Record Published: 2018-01-16
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2019-01-17