Search Help Show/Hide Menu
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: 367782
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: 367777
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 30
Required: Yes
Primary Key: No
Status: Active
Description:

Mission identifier.

REGION_NAME

CC ID: 367781
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.

ISLAND

CC ID: 367771
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).

SITE

CC ID: 367783
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.

LATITUDE

CC ID: 367772
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.

LONGITUDE

CC ID: 367773
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.

REEF_ZONE

CC ID: 367780
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).

DEPTH_BIN

CC ID: 367768
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

SITEVISITID

CC ID: 367784
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_.

DATE_

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

Local date the survey was conducted.

OBS_YEAR

CC ID: 367778
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_).

TRANSECT

CC ID: 367790
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.

PARALLEL_

CC ID: 367779
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: 367769
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.

SUBSTRATE_HEIGHT_0

CC ID: 367785
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.

SUBSTRATE_HEIGHT_20

CC ID: 367788
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.

SUBSTRATE_HEIGHT_50

CC ID: 367789
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.

SUBSTRATE_HEIGHT_100

CC ID: 367786
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.

SUBSTRATE_HEIGHT_150

CC ID: 367787
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.

MIN_DEPTH

CC ID: 367776
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.

MAX_DEPTH

CC ID: 367774
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.

MAX_VERTICAL_RELIEF

CC ID: 367775
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.

FREE_URCHIN_DACOR

CC ID: 367770
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.

BORING_URCHIN_DACOR

CC ID: 367766
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.

Catalog Details

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