View: V0_TOPOGRAPHIC_COMPLEXITY
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:36101 | Updated: August 9, 2022 | Published / External
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
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
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
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
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
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
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
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
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
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
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
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_
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
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
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_
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
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
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
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
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
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
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
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
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
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
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
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 |