View: V0_CORAL_OBS_E_PRESENCE 2013-2016
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:36181 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Coral belt observations (presence)
DescriptionCoral belt observations (presence)
Entity Information
Entity Type
Data View
Data Attribute / Type | Description |
---|---|
ROUNDID
NUMBER |
Unique Identifier for ROUND record |
MISSIONID
VARCHAR2 |
Mission Identifier |
REGION
VARCHAR2 |
Region Code for the LIST_OF_REGIONS record, this is used by other tables to join on the LIST_OF_REGIONS table |
REGION_NAME
VARCHAR2 |
One of the five Pacific Island regions CRED surveys |
ISLAND
NVARCHAR2 |
Island or Atoll surveyed |
ISLANDCODE
NVARCHAR2 |
3-letter island code |
SITE
NVARCHAR2 |
The 5- to 6-character code for the site surveyed. Combines a 3-letter island code with a 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_CODE
VARCHAR2 |
3-letter reef zone code |
REEF_ZONE
NVARCHAR2 |
The reef zone for the given site (Forereef, Backreef or Lagoon) |
DEPTH_BIN
NVARCHAR2 |
Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of replicates at this site |
DEPTH_CODE
VARCHAR2 |
Depth zone code |
SITEVISITID
NUMBER |
Unique Identifier for SITE_VISIT record |
DATE_
DATE |
Date the survey was conducted |
OBS_DAY
NUMBER |
Observation Day |
OBS_MONTH
NUMBER |
Observation Month |
OBS_YEAR
NUMBER |
Observation Year |
SITE_MIN_DEPTH
NUMBER |
Minimum site depth (ft) |
SITE_MAX_DEPTH
NUMBER |
Maximum site depth (ft) |
HABITAT_CODE
VARCHAR2 |
Habitat code |
HABITAT_TYPE
VARCHAR2 |
Habitat type |
DIVER
NVARCHAR2 |
Initials of diver conducting survey |
BELTTRANSECTRUN
NUMBER |
Primary key for CORAL_BELT_TRANSECTRUN |
METHODNAME
NVARCHAR2 |
References the coral belt survey method |
TRANSECT
NUMBER |
Transect Number |
SEGMENT
NVARCHAR2 |
Segment Number |
SEGWIDTH
NUMBER |
Segment Length (m) |
SEGLENGTH
NUMBER |
Segment Width (m) |
CLADIELLA_YN
NUMBER |
Flag to indicate presence of cladiella on transect (Added Sept. 2014) |
DENDRONEPHTHYA_YN
NUMBER |
Flag to indicate presence of dendronephthya on transect (Added Sept. 2014) |
LOBOPHYTUM_YN
NUMBER |
Flag to indicate presence of lobophytum on transect (Added Sept. 2014) |
PACHYCLAVULARIA_YN
NUMBER |
Flag to indicate presence of pachyclavularia on transect (Added Sept. 2014) |
SARCOPHYTON_YN
NUMBER |
Flag to indicate presence of sarcophyton on transect (Added Sept. 2014) |
SINULARIA_YN
NUMBER |
Flag to indicate presence of sinularia on transect (Added Sept. 2014) |
STEREONEPHTHYA_YN
NUMBER |
Flag to indicate presence of stereonephthya on transect (Added Sept. 2014) |
WIRECORAL_YN
NUMBER |
Flag to indicate presence of wire coral on transect (Added Sept. 2014) |
PALYTHOA_YN
NUMBER |
Flag to indicate presence of palythoa on transect (Added Sept. 2014) |
PROTOPALYTHOA_YN
NUMBER |
Flag to indicate presence of protopalythoa on transect (Added Sept. 2014) |
ZOANTHUS_YN
NUMBER |
Flag to indicate presence of zoanthus on transect (Added Sept. 2014) |
NO_SURVEY_YN
NUMBER |
Flag to indicate transect was not surveyed (Added Sept. 2014) |
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_CORAL_OBS_E_PRESENCE 2013-2016 |
---|---|
Short Name: | V0_CORAL_OBS_E_PRESENCE 2013-2016 |
Status: | Completed |
Abstract: |
Coral belt observations (presence) |
Notes: |
Loaded by batch 9632, 12-31-2016 00:51 |
Entity Information
Entity Type: | Data View |
---|---|
Active Version?: | Yes |
Schema Name: | GISDAT |
Description: |
Coral belt observations (presence) |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
ROUNDID | NUMBER | Unique Identifier for ROUND record | |
100
|
MISSIONID | VARCHAR2 | Mission Identifier | |
100
|
REGION | VARCHAR2 | Region Code for the LIST_OF_REGIONS record, this is used by other tables to join on the LIST_OF_REGIONS table | |
100
|
REGION_NAME | VARCHAR2 | One of the five Pacific Island regions CRED surveys | |
100
|
ISLAND | NVARCHAR2 | Island or Atoll surveyed | |
100
|
ISLANDCODE | NVARCHAR2 | 3-letter island code | |
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 | Latitude in decimal degrees, WGS84, for the given site | |
100
|
LONGITUDE | NUMBER | Longitude in decimal degrees, WGS84 for the given site | |
100
|
REEF_ZONE_CODE | VARCHAR2 | 3-letter reef zone code | |
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
|
DEPTH_CODE | VARCHAR2 | Depth zone code | |
100
|
SITEVISITID | NUMBER | Unique Identifier for SITE_VISIT record | |
100
|
DATE_ | DATE | Date the survey was conducted | |
100
|
OBS_DAY | NUMBER | Observation Day | |
100
|
OBS_MONTH | NUMBER | Observation Month | |
100
|
OBS_YEAR | NUMBER | Observation Year | |
100
|
SITE_MIN_DEPTH | NUMBER | Minimum site depth (ft) | |
100
|
SITE_MAX_DEPTH | NUMBER | Maximum site depth (ft) | |
100
|
HABITAT_CODE | VARCHAR2 | Habitat code | |
100
|
HABITAT_TYPE | VARCHAR2 | Habitat type | |
100
|
DIVER | NVARCHAR2 | Initials of diver conducting survey | |
100
|
BELTTRANSECTRUN | NUMBER | Primary key for CORAL_BELT_TRANSECTRUN | |
100
|
METHODNAME | NVARCHAR2 | References the coral belt survey method | |
100
|
TRANSECT | NUMBER | Transect Number | |
100
|
SEGMENT | NVARCHAR2 | Segment Number | |
100
|
SEGWIDTH | NUMBER | Segment Length (m) | |
100
|
SEGLENGTH | NUMBER | Segment Width (m) | |
100
|
CLADIELLA_YN | NUMBER | Flag to indicate presence of cladiella on transect (Added Sept. 2014) | |
100
|
DENDRONEPHTHYA_YN | NUMBER | Flag to indicate presence of dendronephthya on transect (Added Sept. 2014) | |
100
|
LOBOPHYTUM_YN | NUMBER | Flag to indicate presence of lobophytum on transect (Added Sept. 2014) | |
100
|
PACHYCLAVULARIA_YN | NUMBER | Flag to indicate presence of pachyclavularia on transect (Added Sept. 2014) | |
100
|
SARCOPHYTON_YN | NUMBER | Flag to indicate presence of sarcophyton on transect (Added Sept. 2014) | |
100
|
SINULARIA_YN | NUMBER | Flag to indicate presence of sinularia on transect (Added Sept. 2014) | |
100
|
STEREONEPHTHYA_YN | NUMBER | Flag to indicate presence of stereonephthya on transect (Added Sept. 2014) | |
100
|
WIRECORAL_YN | NUMBER | Flag to indicate presence of wire coral on transect (Added Sept. 2014) | |
100
|
PALYTHOA_YN | NUMBER | Flag to indicate presence of palythoa on transect (Added Sept. 2014) | |
100
|
PROTOPALYTHOA_YN | NUMBER | Flag to indicate presence of protopalythoa on transect (Added Sept. 2014) | |
100
|
ZOANTHUS_YN | NUMBER | Flag to indicate presence of zoanthus on transect (Added Sept. 2014) | |
100
|
NO_SURVEY_YN | NUMBER | Flag to indicate transect was not surveyed (Added Sept. 2014) |
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
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Region Code for the LIST_OF_REGIONS record, this is used by other tables to join on the LIST_OF_REGIONS table |
REGION_NAME
Seq. Order: | 4 |
---|---|
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: | 5 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Island or Atoll surveyed |
ISLANDCODE
Seq. Order: | 6 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 15 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
3-letter island code |
SITE
Seq. Order: | 7 |
---|---|
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: | 8 |
---|---|
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: | 9 |
---|---|
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_CODE
Seq. Order: | 10 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
3-letter reef zone code |
REEF_ZONE
Seq. Order: | 11 |
---|---|
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: | 12 |
---|---|
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 |
DEPTH_CODE
Seq. Order: | 13 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Depth zone code |
SITEVISITID
Seq. Order: | 14 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Unique Identifier for SITE_VISIT record |
DATE_
Seq. Order: | 15 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Date the survey was conducted |
OBS_DAY
Seq. Order: | 16 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Observation Day |
OBS_MONTH
Seq. Order: | 17 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Observation Month |
OBS_YEAR
Seq. Order: | 18 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Observation Year |
SITE_MIN_DEPTH
Seq. Order: | 19 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 0 |
Status: | Active |
Description: |
Minimum site depth (ft) |
SITE_MAX_DEPTH
Seq. Order: | 20 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 0 |
Status: | Active |
Description: |
Maximum site depth (ft) |
HABITAT_CODE
Seq. Order: | 21 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Habitat code |
HABITAT_TYPE
Seq. Order: | 22 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Habitat type |
DIVER
Seq. Order: | 23 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Initials of diver conducting survey |
BELTTRANSECTRUN
Seq. Order: | 24 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 38 |
Scale: | 0 |
Status: | Active |
Description: |
Primary key for CORAL_BELT_TRANSECTRUN |
METHODNAME
Seq. Order: | 25 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
References the coral belt survey method |
TRANSECT
Seq. Order: | 26 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 38 |
Scale: | 0 |
Status: | Active |
Description: |
Transect Number |
SEGMENT
Seq. Order: | 27 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Segment Number |
SEGWIDTH
Seq. Order: | 28 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Scale: | 8 |
Status: | Active |
Description: |
Segment Length (m) |
SEGLENGTH
Seq. Order: | 29 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 28 |
Scale: | 8 |
Status: | Active |
Description: |
Segment Width (m) |
CLADIELLA_YN
Seq. Order: | 30 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Flag to indicate presence of cladiella on transect (Added Sept. 2014) |
DENDRONEPHTHYA_YN
Seq. Order: | 31 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Flag to indicate presence of dendronephthya on transect (Added Sept. 2014) |
LOBOPHYTUM_YN
Seq. Order: | 32 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Flag to indicate presence of lobophytum on transect (Added Sept. 2014) |
PACHYCLAVULARIA_YN
Seq. Order: | 33 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Flag to indicate presence of pachyclavularia on transect (Added Sept. 2014) |
SARCOPHYTON_YN
Seq. Order: | 34 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Flag to indicate presence of sarcophyton on transect (Added Sept. 2014) |
SINULARIA_YN
Seq. Order: | 35 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Flag to indicate presence of sinularia on transect (Added Sept. 2014) |
STEREONEPHTHYA_YN
Seq. Order: | 36 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Flag to indicate presence of stereonephthya on transect (Added Sept. 2014) |
WIRECORAL_YN
Seq. Order: | 37 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Flag to indicate presence of wire coral on transect (Added Sept. 2014) |
PALYTHOA_YN
Seq. Order: | 38 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Flag to indicate presence of palythoa on transect (Added Sept. 2014) |
PROTOPALYTHOA_YN
Seq. Order: | 39 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Flag to indicate presence of protopalythoa on transect (Added Sept. 2014) |
ZOANTHUS_YN
Seq. Order: | 40 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Flag to indicate presence of zoanthus on transect (Added Sept. 2014) |
NO_SURVEY_YN
Seq. Order: | 41 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Flag to indicate transect was not surveyed (Added Sept. 2014) |
Catalog Details
Catalog Item ID: | 36181 |
---|---|
GUID: | gov.noaa.nmfs.inport:36181 |
Metadata Record Created By: | Troy T Kanemura |
Metadata Record Created: | 2016-12-31 00:52+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2017-06-21 |
Owner Org: | PIFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2017-06-21 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2018-06-21 |