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 > American Samoa > National Coral Reef Monitoring Program: Benthic... >

View: V0_TOPOGRAPHIC_COMPLEXITY

Entity (ENT)  |  Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:36101  |  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 		The name of the region surveyed in the Pacific Islands region: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands.
ISLAND
NVARCHAR2 		Name of island or atoll surveyed in the Pacific Islands region (REGION_NAME).
SITE
NVARCHAR2 		The code for the site surveyed at the island or atoll (ISLAND). Combines a 3-letter island code (ISLANDCODE) with a 2-4 digit site number.
LATITUDE
NUMBER 		Latitude in decimal degrees, WGS84, for the given SITE.
LONGITUDE
NUMBER 		Longitude in decimal degrees, WGS84 for the given SITE.
REEF_ZONE
NVARCHAR2 		The zone for the given SITE (Forereef, Backreef, Protected Slope, Lagoon).
DEPTH_BIN
NVARCHAR2 		Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of a given SITE. Shallow: >0-6 m, Mid: >6-18 m, Deep: >18-30 m
SITEVISITID
NUMBER 		Unique identifier created each time a SITE is surveyed on a DATE_.
DATE_
DATE 		Local date the survey was conducted.
OBS_YEAR
NUMBER 		4-digit year the survey was conducted (DATE_).
TRANSECT
VARCHAR2 		Type of transect (box or line). Deprecated as of 2017 surveys.
PARALLEL_
NUMBER 		Parallel bearing of transect.
DOWNSLOPE
NUMBER 		Downslope bearing of transect. Climate sites set up in 'alongshore' lines (usually a result of suitable benthic substrate availability) will not have a down slope heading.
SUBSTRATE_HEIGHT_0
NUMBER 		Frequency (0-30) is tallied if the maximum height of the tallest reef structure measured within a 0.5 square meter area on either side of each meter along a 15-m transect is between 0-20 cm elevation. Total frequency for all 5 substrate height bins should equal 30.
SUBSTRATE_HEIGHT_20
NUMBER 		Frequency (0-30) is tallied if the maximum height of the tallest reef structure measured within a 0.5 square meter area on either side of each meter along a 15-m transect is between 20-50 cm elevation. Total frequency for all 5 substrate height bins should equal 30.
SUBSTRATE_HEIGHT_50
NUMBER 		Frequency (0-30) is tallied if the maximum height of the tallest reef structure measured within a 0.5 square meter area on either side of each meter along a 15-m transect is between 50-100 cm elevation. Total frequency for all 5 substrate height bins should equal 30.
SUBSTRATE_HEIGHT_100
NUMBER 		Frequency (0-30) is tallied if the maximum height of the tallest reef structure measured within a 0.5 square meter area on either side of each meter along a 15-m transect is between 100-150 cm elevation. Total frequency for all 5 substrate height bins should equal 30.
SUBSTRATE_HEIGHT_150
NUMBER 		Frequency (0-30) is tallied if the maximum height of the tallest reef structure measured within a 0.5 square meter area on either side of each meter along a 15-m transect is >150 cm elevation. Total frequency for all 5 substrate height bins should equal 30.
MIN_DEPTH
NUMBER 		Shallowest point in the NCRMP climate station (SITE) in feet.
MAX_DEPTH
NUMBER 		Deepest point in the NCRMP climate station (SITE) in feet.
MAX_VERTICAL_RELIEF
NUMBER 		Height of tallest reef structure present within the NCRMP climate station (SITE) in centimeters.
FREE_URCHIN_DACOR
VARCHAR2 		Free urchin abundance within the NCRMP climate station (SITE), estimated by DACOR, an abundance code based on visual estimation: dominant (D), abundant (A), common (C), occasional (O), and rare (R). DACOR categories are quantified as: D: 101-999; A: 51-100; C: 21-50; O: 6-20; R: 0-5.
BORING_URCHIN_DACOR
VARCHAR2 		Boring urchin abundance within the NCRMP climate station (SITE), estimated by DACOR, an abundance code based on visual estimation: dominant (D), abundant (A), common (C), occasional (O), and rare (R). DACOR categories are quantified as: D: 501-999; A: 251-500; C: 101-250; O: 26-100; R: 0-25.

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

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 The name of the region surveyed in the Pacific Islands region: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands.
100
 ISLAND NVARCHAR2 Name of island or atoll surveyed in the Pacific Islands region (REGION_NAME).
100
 SITE NVARCHAR2 The code for the site surveyed at the island or atoll (ISLAND). Combines a 3-letter island code (ISLANDCODE) with a 2-4 digit site number.
100
 LATITUDE NUMBER Latitude in decimal degrees, WGS84, for the given SITE.
100
 LONGITUDE NUMBER Longitude in decimal degrees, WGS84 for the given SITE.
100
 REEF_ZONE NVARCHAR2 The zone for the given SITE (Forereef, Backreef, Protected Slope, Lagoon).
100
 DEPTH_BIN NVARCHAR2 Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of a given SITE. Shallow: >0-6 m, Mid: >6-18 m, Deep: >18-30 m
100
 SITEVISITID NUMBER Unique identifier created each time a SITE is surveyed on a DATE_.
100
 DATE_ DATE Local date the survey was conducted.
100
 OBS_YEAR NUMBER 4-digit year the survey was conducted (DATE_).
100
 TRANSECT VARCHAR2 Type of transect (box or line). Deprecated as of 2017 surveys.
100
 PARALLEL_ NUMBER Parallel bearing of transect.
100
 DOWNSLOPE NUMBER Downslope bearing of transect. Climate sites set up in 'alongshore' lines (usually a result of suitable benthic substrate availability) will not have a down slope heading.
100
 SUBSTRATE_HEIGHT_0 NUMBER Frequency (0-30) is tallied if the maximum height of the tallest reef structure measured within a 0.5 square meter area on either side of each meter along a 15-m transect is between 0-20 cm elevation. Total frequency for all 5 substrate height bins should equal 30.
100
 SUBSTRATE_HEIGHT_20 NUMBER Frequency (0-30) is tallied if the maximum height of the tallest reef structure measured within a 0.5 square meter area on either side of each meter along a 15-m transect is between 20-50 cm elevation. Total frequency for all 5 substrate height bins should equal 30.
100
 SUBSTRATE_HEIGHT_50 NUMBER Frequency (0-30) is tallied if the maximum height of the tallest reef structure measured within a 0.5 square meter area on either side of each meter along a 15-m transect is between 50-100 cm elevation. Total frequency for all 5 substrate height bins should equal 30.
100
 SUBSTRATE_HEIGHT_100 NUMBER Frequency (0-30) is tallied if the maximum height of the tallest reef structure measured within a 0.5 square meter area on either side of each meter along a 15-m transect is between 100-150 cm elevation. Total frequency for all 5 substrate height bins should equal 30.
100
 SUBSTRATE_HEIGHT_150 NUMBER Frequency (0-30) is tallied if the maximum height of the tallest reef structure measured within a 0.5 square meter area on either side of each meter along a 15-m transect is >150 cm elevation. Total frequency for all 5 substrate height bins should equal 30.
100
 MIN_DEPTH NUMBER Shallowest point in the NCRMP climate station (SITE) in feet.
100
 MAX_DEPTH NUMBER Deepest point in the NCRMP climate station (SITE) in feet.
100
 MAX_VERTICAL_RELIEF NUMBER Height of tallest reef structure present within the NCRMP climate station (SITE) in centimeters.
100
 FREE_URCHIN_DACOR VARCHAR2 Free urchin abundance within the NCRMP climate station (SITE), estimated by DACOR, an abundance code based on visual estimation: dominant (D), abundant (A), common (C), occasional (O), and rare (R). DACOR categories are quantified as: D: 101-999; A: 51-100; C: 21-50; O: 6-20; R: 0-5.
100
 BORING_URCHIN_DACOR VARCHAR2 Boring urchin abundance within the NCRMP climate station (SITE), estimated by DACOR, an abundance code based on visual estimation: dominant (D), abundant (A), common (C), occasional (O), and rare (R). DACOR categories are quantified as: D: 501-999; A: 251-500; C: 101-250; O: 26-100; R: 0-25.

Attribute Details

ROUNDID

CC ID: 367691
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.
General Data Type: NUMBER

MISSIONID

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

Mission identifier.
General Data Type: VARCHAR2

REGION_NAME

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

The name of the region surveyed in the Pacific Islands region: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands.
General Data Type: VARCHAR2

ISLAND

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

Name of island or atoll surveyed in the Pacific Islands region (REGION_NAME).
General Data Type: NVARCHAR2

SITE

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

The code for the site surveyed at the island or atoll (ISLAND). Combines a 3-letter island code (ISLANDCODE) with a 2-4 digit site number.
General Data Type: NVARCHAR2

LATITUDE

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

Latitude in decimal degrees, WGS84, for the given SITE.
General Data Type: NUMBER

LONGITUDE

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

Longitude in decimal degrees, WGS84 for the given SITE.
General Data Type: NUMBER

REEF_ZONE

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

The zone for the given SITE (Forereef, Backreef, Protected Slope, Lagoon).
General Data Type: NVARCHAR2

DEPTH_BIN

CC ID: 367699
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 a given SITE. Shallow: >0-6 m, Mid: >6-18 m, Deep: >18-30 m
General Data Type: NVARCHAR2

SITEVISITID

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

Unique identifier created each time a SITE is surveyed on a DATE_.
General Data Type: NUMBER

DATE_

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

Local date the survey was conducted.
General Data Type: DATE

OBS_YEAR

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

4-digit year the survey was conducted (DATE_).
General Data Type: NUMBER

TRANSECT

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

Type of transect (box or line). Deprecated as of 2017 surveys.
General Data Type: VARCHAR2

PARALLEL_

CC ID: 367704
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.
General Data Type: NUMBER

DOWNSLOPE

CC ID: 367705
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. Climate sites set up in 'alongshore' lines (usually a result of suitable benthic substrate availability) will not have a down slope heading.
General Data Type: NUMBER

SUBSTRATE_HEIGHT_0

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

Frequency (0-30) is tallied if the maximum height of the tallest reef structure measured within a 0.5 square meter area on either side of each meter along a 15-m transect is between 0-20 cm elevation. Total frequency for all 5 substrate height bins should equal 30.
General Data Type: NUMBER

SUBSTRATE_HEIGHT_20

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

Frequency (0-30) is tallied if the maximum height of the tallest reef structure measured within a 0.5 square meter area on either side of each meter along a 15-m transect is between 20-50 cm elevation. Total frequency for all 5 substrate height bins should equal 30.
General Data Type: NUMBER

SUBSTRATE_HEIGHT_50

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

Frequency (0-30) is tallied if the maximum height of the tallest reef structure measured within a 0.5 square meter area on either side of each meter along a 15-m transect is between 50-100 cm elevation. Total frequency for all 5 substrate height bins should equal 30.
General Data Type: NUMBER

SUBSTRATE_HEIGHT_100

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

Frequency (0-30) is tallied if the maximum height of the tallest reef structure measured within a 0.5 square meter area on either side of each meter along a 15-m transect is between 100-150 cm elevation. Total frequency for all 5 substrate height bins should equal 30.
General Data Type: NUMBER

SUBSTRATE_HEIGHT_150

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

Frequency (0-30) is tallied if the maximum height of the tallest reef structure measured within a 0.5 square meter area on either side of each meter along a 15-m transect is >150 cm elevation. Total frequency for all 5 substrate height bins should equal 30.
General Data Type: NUMBER

MIN_DEPTH

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

Shallowest point in the NCRMP climate station (SITE) in feet.
General Data Type: NUMBER

MAX_DEPTH

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

Deepest point in the NCRMP climate station (SITE) in feet.
General Data Type: NUMBER

MAX_VERTICAL_RELIEF

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

Height of tallest reef structure present within the NCRMP climate station (SITE) in centimeters.
General Data Type: NUMBER

FREE_URCHIN_DACOR

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

Free urchin abundance within the NCRMP climate station (SITE), estimated by DACOR, an abundance code based on visual estimation: dominant (D), abundant (A), common (C), occasional (O), and rare (R). DACOR categories are quantified as:

D: 101-999;

A: 51-100;

C: 21-50;

O: 6-20;

R: 0-5.
General Data Type: VARCHAR2

BORING_URCHIN_DACOR

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

Boring urchin abundance within the NCRMP climate station (SITE), estimated by DACOR, an abundance code based on visual estimation: dominant (D), abundant (A), common (C), occasional (O), and rare (R). DACOR categories are quantified as:

D: 501-999;

A: 251-500;

C: 101-250;

O: 26-100;

R: 0-25.
General Data Type: VARCHAR2

Catalog Details

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