View: V0_TOPOGRAPHIC_COMPLEXITY
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:36104 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Foundational view for benthic complexity and urchin abundance at climate stations
DescriptionFoundational 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
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. |
MISSIONID
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Mission identifier. |
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. |
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). |
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. |
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. |
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. |
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). |
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 |
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_. |
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. |
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_). |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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 |