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