Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
PIFSC Metadata Library > PIFSC Coral Reef Ecosystem Program (CREP) Metad... > National Coral Reef Monitoring Program > Hawaiian Archipelago > National Coral Reef Monitoring Program: Benthic... >

View: V0_TOPOGRAPHIC_COMPLEXITY

Entity (ENT)  |  Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:36102  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Foundational view for benthic complexity and urchin abundance at climate stations

Description

Foundational view for benthic complexity and urchin abundance at climate stations

Entity Information

Entity Type
Data View

Data Attribute / Type Description
ROUNDID
NUMBER 		Unique Identifier for ROUND record
MISSIONID
VARCHAR2 		Mission Identifier
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
LATITUDE
NUMBER 		Site latitude
LONGITUDE
NUMBER 		Site longitude
REEF_ZONE
NVARCHAR2 		The reef zone for the given site (Forereef, Backreef or Lagoon)
DEPTH_BIN
NVARCHAR2 		Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of replicates at this site
SITEVISITID
NUMBER 		Unique identifier for SITE_VISIT record
DATE_
DATE 		Date the survey was conducted
OBS_YEAR
NUMBER 		Year the survey was conducted
TRANSECT
VARCHAR2 		Type of transect (box or line)
PARALLEL_
NUMBER 		Parallel bearing of transect
DOWNSLOPE
NUMBER 		Downslope bearing of transect
SUBSTRATE_HEIGHT_0
NUMBER 		Substrate complexity between 0cm and 20cm elevation
SUBSTRATE_HEIGHT_20
NUMBER 		Substrate complexity between 20cm and 50cm elevation
SUBSTRATE_HEIGHT_50
NUMBER 		Substrate complexity between 50cm and 100cm elevation
SUBSTRATE_HEIGHT_100
NUMBER 		Substrate complexity between 100cm and 150cm elevation
SUBSTRATE_HEIGHT_150
NUMBER 		Substrate complexity over 150cm elevation
MIN_DEPTH
NUMBER 		Minimum slope depth in meters
MAX_DEPTH
NUMBER 		Maximum slope depth in meters
MAX_VERTICAL_RELIEF
NUMBER 		Highest elevation point measured in centimeters
FREE_URCHIN_DACOR
VARCHAR2 		Free Urchin DACOR
BORING_URCHIN_DACOR
VARCHAR2 		Boring Urchin DACOR

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: V0_TOPOGRAPHIC_COMPLEXITY
Short Name: V0_TOPOGRAPHIC_COMPLEXITY
Status: Completed
Abstract:

Foundational view for benthic complexity and urchin abundance at climate stations
Notes:

Loaded by batch 9613, 12-21-2016 21:29

Entity Information

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

Foundational view for benthic complexity and urchin abundance at climate stations

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 ROUNDID NUMBER Unique Identifier for ROUND record
100
 MISSIONID VARCHAR2 Mission Identifier
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
 LATITUDE NUMBER Site latitude
100
 LONGITUDE NUMBER Site longitude
100
 REEF_ZONE NVARCHAR2 The reef zone for the given site (Forereef, Backreef or Lagoon)
100
 DEPTH_BIN NVARCHAR2 Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of replicates at this site
100
 SITEVISITID NUMBER Unique identifier for SITE_VISIT record
100
 DATE_ DATE Date the survey was conducted
100
 OBS_YEAR NUMBER Year the survey was conducted
100
 TRANSECT VARCHAR2 Type of transect (box or line)
100
 PARALLEL_ NUMBER Parallel bearing of transect
100
 DOWNSLOPE NUMBER Downslope bearing of transect
100
 SUBSTRATE_HEIGHT_0 NUMBER Substrate complexity between 0cm and 20cm elevation
100
 SUBSTRATE_HEIGHT_20 NUMBER Substrate complexity between 20cm and 50cm elevation
100
 SUBSTRATE_HEIGHT_50 NUMBER Substrate complexity between 50cm and 100cm elevation
100
 SUBSTRATE_HEIGHT_100 NUMBER Substrate complexity between 100cm and 150cm elevation
100
 SUBSTRATE_HEIGHT_150 NUMBER Substrate complexity over 150cm elevation
100
 MIN_DEPTH NUMBER Minimum slope depth in meters
100
 MAX_DEPTH NUMBER Maximum slope depth in meters
100
 MAX_VERTICAL_RELIEF NUMBER Highest elevation point measured in centimeters
100
 FREE_URCHIN_DACOR VARCHAR2 Free Urchin DACOR
100
 BORING_URCHIN_DACOR VARCHAR2 Boring Urchin DACOR

Attribute Details

ROUNDID

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

Unique Identifier for ROUND record

MISSIONID

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

Mission Identifier

REGION_NAME

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

One of the five Pacific Island regions CRED surveys

ISLAND

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

Island or Atoll surveyed

SITE

CC ID: 367733
Seq. Order: 5
Data Storage Type: NVARCHAR2
Max Length: 150
Required: Yes
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

LATITUDE

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

Site latitude

LONGITUDE

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

Site longitude

REEF_ZONE

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

The reef zone for the given site (Forereef, Backreef or Lagoon)

DEPTH_BIN

CC ID: 367718
Seq. Order: 9
Data Storage Type: NVARCHAR2
Max Length: 60
Required: No
Primary Key: No
Status: Active
Description:

Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of replicates at this site

SITEVISITID

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

Unique identifier for SITE_VISIT record

DATE_

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

Date the survey was conducted

OBS_YEAR

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

Year the survey was conducted

TRANSECT

CC ID: 367740
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 28
Required: No
Primary Key: No
Status: Active
Description:

Type of transect (box or line)

PARALLEL_

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

Parallel bearing of transect

DOWNSLOPE

CC ID: 367719
Seq. Order: 15
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 26
Scale: 0
Status: Active
Description:

Downslope bearing of transect

SUBSTRATE_HEIGHT_0

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

Substrate complexity between 0cm and 20cm elevation

SUBSTRATE_HEIGHT_20

CC ID: 367738
Seq. Order: 17
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 26
Scale: 0
Status: Active
Description:

Substrate complexity between 20cm and 50cm elevation

SUBSTRATE_HEIGHT_50

CC ID: 367739
Seq. Order: 18
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 26
Scale: 0
Status: Active
Description:

Substrate complexity between 50cm and 100cm elevation

SUBSTRATE_HEIGHT_100

CC ID: 367736
Seq. Order: 19
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 26
Scale: 0
Status: Active
Description:

Substrate complexity between 100cm and 150cm elevation

SUBSTRATE_HEIGHT_150

CC ID: 367737
Seq. Order: 20
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 26
Scale: 0
Status: Active
Description:

Substrate complexity over 150cm elevation

MIN_DEPTH

CC ID: 367726
Seq. Order: 21
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 26
Scale: 0
Status: Active
Description:

Minimum slope depth in meters

MAX_DEPTH

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

Maximum slope depth in meters

MAX_VERTICAL_RELIEF

CC ID: 367725
Seq. Order: 23
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 26
Scale: 0
Status: Active
Description:

Highest elevation point measured in centimeters

FREE_URCHIN_DACOR

CC ID: 367720
Seq. Order: 24
Data Storage Type: VARCHAR2
Max Length: 26
Required: No
Primary Key: No
Status: Active
Description:

Free Urchin DACOR

BORING_URCHIN_DACOR

CC ID: 367716
Seq. Order: 25
Data Storage Type: VARCHAR2
Max Length: 26
Required: No
Primary Key: No
Status: Active
Description:

Boring Urchin DACOR

Catalog Details

Catalog Item ID: 36102
GUID: gov.noaa.nmfs.inport:36102
Metadata Record Created By: Troy T Kanemura
Metadata Record Created: 2016-12-21 21:52+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2017-01-23
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2017-01-23
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2018-01-23