View: V0_TOPOGRAPHIC_COMPLEXITY
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:36103 | 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
CC ID: 367757
| 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: 367752
| Seq. Order: | 2 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 30 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Mission Identifier |
REGION_NAME
CC ID: 367756
| 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
CC ID: 367746
| Seq. Order: | 4 |
|---|---|
| Data Storage Type: | NVARCHAR2 |
| Max Length: | 150 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Island or Atoll surveyed |
SITE
CC ID: 367758
| 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
CC ID: 367747
| Seq. Order: | 6 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 38 |
| Status: | Active |
| Description: |
Site latitude |
LONGITUDE
CC ID: 367748
| Seq. Order: | 7 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Site longitude |
REEF_ZONE
CC ID: 367755
| 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
CC ID: 367743
| 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
CC ID: 367759
| 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_
CC ID: 367742
| 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
CC ID: 367753
| 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
CC ID: 367765
| 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_
CC ID: 367754
| 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: 367744
| 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
CC ID: 367760
| 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
CC ID: 367763
| 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
CC ID: 367764
| 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
CC ID: 367761
| 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
CC ID: 367762
| 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
CC ID: 367751
| 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
CC ID: 367749
| 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
CC ID: 367750
| 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
CC ID: 367745
| Seq. Order: | 24 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 26 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Free Urchin DACOR |
BORING_URCHIN_DACOR
CC ID: 367741
| 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: | 36103 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:36103 |
| 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-10-18 |
| Owner Org: | PIFSC |
| Metadata Publication Status: | Published Externally |
| Do Not Publish?: | N |
| Metadata Last Review Date: | 2017-10-18 |
| Metadata Review Frequency: | 1 Year |
| Metadata Next Review Date: | 2018-10-18 |