View: V_CALCIFICATION_RATE_BY_UNIT
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:36074 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
calculates the calcification rate by unit (by grouping the upper and lower plates together)
Descriptioncalculates the calcification rate by unit (by grouping the upper and lower plates together)
Entity Information
Entity Type
Data View
Data Attribute / Type | Description |
---|---|
REGION_NAME
VARCHAR2 |
One of the five Pacific Island regions CRED surveys |
ISLAND
NVARCHAR2 |
Island or Atoll surveyed |
SITE
NVARCHAR2 |
The 5- to 6-character code for the site surveyed. Combines a 3-letter island code with a site number |
SERIALNUMBER
NUMBER |
CAU Serial Number. A negative is assigned to a serial number in the unusual event that the serial number for a recovered CAU already exists. |
CAU_UNIT
NVARCHAR2 |
CAU Unit Identifier |
CALCIFICATION_RATE_BY_UNIT
NUMBER |
Calcification Rate (measured in grams per centimeter per year) |
LATITUDE
NUMBER |
Site latitude |
LONGITUDE
NUMBER |
Site longitude |
DAYS_IN_WATER
NUMBER |
Number of days in the water |
YEARS_IN_WATER
NUMBER |
Number of years in the water |
DEPLOYMENT_MISSION
VARCHAR2 |
Deployment Mission Identifier |
DEPLOYMENT_DATE
DATE |
Deployment Date |
DEPLOYMENT_YEAR
NUMBER |
Deployment Year |
RECOVERY_MISSION
VARCHAR2 |
Recovery Mission Identifier |
RECOVERY_DATE
DATE |
Recovery Date |
RECOVERY_YEAR
NUMBER |
Recovery Year |
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: | View: V_CALCIFICATION_RATE_BY_UNIT |
---|---|
Short Name: | V_CALCIFICATION_RATE_BY_UNIT |
Status: | Completed |
Abstract: |
calculates the calcification rate by unit (by grouping the upper and lower plates together) |
Notes: |
Loaded by batch 9612, 12-20-2016 21:17 |
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
Name | Type | Description | ||
---|---|---|---|---|
100
|
REGION_NAME | VARCHAR2 | One of the five Pacific Island regions CRED surveys | |
100
|
ISLAND | NVARCHAR2 | Island or Atoll surveyed | |
100
|
SITE | NVARCHAR2 | The 5- to 6-character code for the site surveyed. Combines a 3-letter island code with a site number | |
100
|
SERIALNUMBER | NUMBER | CAU Serial Number. A negative is assigned to a serial number in the unusual event that the serial number for a recovered CAU already exists. | |
100
|
CAU_UNIT | NVARCHAR2 | CAU Unit Identifier | |
100
|
CALCIFICATION_RATE_BY_UNIT | NUMBER | Calcification Rate (measured in grams per centimeter per year) | |
100
|
LATITUDE | NUMBER | Site latitude | |
100
|
LONGITUDE | NUMBER | Site longitude | |
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 | VARCHAR2 | Deployment Mission Identifier | |
100
|
DEPLOYMENT_DATE | DATE | Deployment Date | |
100
|
DEPLOYMENT_YEAR | NUMBER | Deployment Year | |
100
|
RECOVERY_MISSION | VARCHAR2 | Recovery Mission Identifier | |
100
|
RECOVERY_DATE | DATE | Recovery Date | |
100
|
RECOVERY_YEAR | NUMBER | Recovery Year |
Attribute Details
REGION_NAME
Seq. Order: | 1 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
One of the five Pacific Island regions CRED surveys |
General Data Type: | VARCHAR2 |
ISLAND
Seq. Order: | 2 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Island or Atoll surveyed |
General Data Type: | NVARCHAR2 |
SITE
Seq. Order: | 3 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The 5- to 6-character code for the site surveyed. Combines a 3-letter island code with a site number |
General Data Type: | NVARCHAR2 |
SERIALNUMBER
Seq. Order: | 4 |
---|---|
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 recovered CAU already exists. |
General Data Type: | NUMBER |
CAU_UNIT
Seq. Order: | 5 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 273 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
CAU Unit Identifier |
General Data Type: | NVARCHAR2 |
CALCIFICATION_RATE_BY_UNIT
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) |
General Data Type: | NUMBER |
LATITUDE
Seq. Order: | 7 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Site latitude |
General Data Type: | NUMBER |
LONGITUDE
Seq. Order: | 8 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Site longitude |
General Data Type: | NUMBER |
DAYS_IN_WATER
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 |
General Data Type: | NUMBER |
YEARS_IN_WATER
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 |
General Data Type: | NUMBER |
DEPLOYMENT_MISSION
Seq. Order: | 11 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Deployment Mission Identifier |
General Data Type: | VARCHAR2 |
DEPLOYMENT_DATE
Seq. Order: | 12 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Deployment Date |
General Data Type: | DATE |
DEPLOYMENT_YEAR
Seq. Order: | 13 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 28 |
Scale: | 0 |
Status: | Active |
Description: |
Deployment Year |
General Data Type: | NUMBER |
RECOVERY_MISSION
Seq. Order: | 14 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Recovery Mission Identifier |
General Data Type: | VARCHAR2 |
RECOVERY_DATE
Seq. Order: | 15 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Recovery Date |
General Data Type: | DATE |
RECOVERY_YEAR
Seq. Order: | 16 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 28 |
Scale: | 0 |
Status: | Active |
Description: |
Recovery Year |
General Data Type: | NUMBER |
Catalog Details
Catalog Item ID: | 36074 |
---|---|
GUID: | gov.noaa.nmfs.inport:36074 |
Metadata Record Created By: | Annette M DesRochers |
Metadata Record Created: | 2016-12-20 21:17+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2017-03-23 |
Owner Org: | PIFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2017-03-23 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2018-03-23 |