View: V0_TOPOGRAPHIC_COMPLEXITY
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:36102 | 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 |
Notes: |
Loaded by batch 9613, 12-21-2016 21:29 |
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 | One of the five Pacific Island regions CRED surveys | |
100
|
ISLAND | NVARCHAR2 | Island or Atoll surveyed | |
100
|
SITE | NVARCHAR2 | The 5- to 6-character code for the site surveyed. Combines a 3-letter island code with a site number | |
100
|
LATITUDE | NUMBER | Site latitude | |
100
|
LONGITUDE | NUMBER | Site longitude | |
100
|
REEF_ZONE | NVARCHAR2 | The reef zone for the given site (Forereef, Backreef or Lagoon) | |
100
|
DEPTH_BIN | NVARCHAR2 | Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of replicates at this site | |
100
|
SITEVISITID | NUMBER | Unique identifier for SITE_VISIT record | |
100
|
DATE_ | DATE | Date the survey was conducted | |
100
|
OBS_YEAR | NUMBER | Year the survey was conducted | |
100
|
TRANSECT | VARCHAR2 | Type of transect (box or line) | |
100
|
PARALLEL_ | NUMBER | Parallel bearing of transect | |
100
|
DOWNSLOPE | NUMBER | Downslope bearing of transect | |
100
|
SUBSTRATE_HEIGHT_0 | NUMBER | Substrate complexity between 0cm and 20cm elevation | |
100
|
SUBSTRATE_HEIGHT_20 | NUMBER | Substrate complexity between 20cm and 50cm elevation | |
100
|
SUBSTRATE_HEIGHT_50 | NUMBER | Substrate complexity between 50cm and 100cm elevation | |
100
|
SUBSTRATE_HEIGHT_100 | NUMBER | Substrate complexity between 100cm and 150cm elevation | |
100
|
SUBSTRATE_HEIGHT_150 | NUMBER | Substrate complexity over 150cm elevation | |
100
|
MIN_DEPTH | NUMBER | Minimum slope depth in meters | |
100
|
MAX_DEPTH | NUMBER | Maximum slope depth in meters | |
100
|
MAX_VERTICAL_RELIEF | NUMBER | Highest elevation point measured in centimeters | |
100
|
FREE_URCHIN_DACOR | VARCHAR2 | Free Urchin DACOR | |
100
|
BORING_URCHIN_DACOR | VARCHAR2 | Boring Urchin DACOR |
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: |
One of the five Pacific Island regions CRED surveys |
ISLAND
Seq. Order: | 4 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Island or Atoll surveyed |
SITE
Seq. Order: | 5 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
The 5- to 6-character code for the site surveyed. Combines a 3-letter island code with a site number |
LATITUDE
Seq. Order: | 6 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Site latitude |
LONGITUDE
Seq. Order: | 7 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Site longitude |
REEF_ZONE
Seq. Order: | 8 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The reef zone for the given site (Forereef, Backreef or 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 replicates at this site |
SITEVISITID
Seq. Order: | 10 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Unique identifier for SITE_VISIT record |
DATE_
Seq. Order: | 11 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
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: |
Year the survey was conducted |
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) |
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 |
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: |
Substrate complexity between 0cm and 20cm elevation |
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: |
Substrate complexity between 20cm and 50cm elevation |
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: |
Substrate complexity between 50cm and 100cm elevation |
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: |
Substrate complexity between 100cm and 150cm elevation |
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: |
Substrate complexity over 150cm elevation |
MIN_DEPTH
Seq. Order: | 21 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 26 |
Scale: | 0 |
Status: | Active |
Description: |
Minimum slope depth in meters |
MAX_DEPTH
Seq. Order: | 22 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 26 |
Scale: | 0 |
Status: | Active |
Description: |
Maximum slope depth in meters |
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: |
Highest elevation point measured 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 DACOR |
BORING_URCHIN_DACOR
Seq. Order: | 25 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 26 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Boring Urchin DACOR |
Catalog Details
Catalog Item ID: | 36102 |
---|---|
GUID: | gov.noaa.nmfs.inport:36102 |
Metadata Record Created By: | Troy T Kanemura |
Metadata Record Created: | 2016-12-21 21:52+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2017-01-23 |
Owner Org: | PIFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2017-01-23 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2018-01-23 |