Maintenance Notice: Tuesday May 21 @ 12pm-1:30pm Eastern. InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 5.3.6. Downtime Schedule Tuesday, May 21, 2024 12:00pm - 1:30pm Eastern / 9:00am - 10:30am Pacific / 6:00am - 8:30am Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: h...
View All
Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Coral belt observations

Description

Coral belt observations

Entity Information

Entity Type
Data View

Data Attribute / Type Description
ROUNDID
NUMBER
Unique numeric id for mission
MISSIONID
VARCHAR2
Unique text id for mission
REGION
VARCHAR2
Region code representing one of the five Pacific Island regions surveyed by the Coral Reef Ecosystem Program
REGION_NAME
VARCHAR2
One of the five Pacific Island regions surveyed by the Coral Reef Ecosystem Program (Main Hawaiian Islands)
ISLAND
NVARCHAR2
Island or atoll surveyed (Oahu, Maui, Hawaii)
ISLANDCODE
NVARCHAR2
3-letter island code (OAH, MAI, HAW)
SITE
NVARCHAR2
The code for the site surveyed. Combines a 3-letter island code 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
SITEVISITID
NUMBER
Unique Identifier for SITE_VISIT record (unique for site and date)
DATE_
DATE
Date the survey was conducted
OBS_YEAR
NUMBER
Year the survey was conducted
DIVER
NVARCHAR2
Initials of diver that conducted the survey
BELTTRANSECTRUN
NUMBER
Primary key for CORAL_BELT_TRANSECTRUN
METHODNAME
NVARCHAR2
References the coral belt survey method (coral belt method A)
TRANSECT
NUMBER
Transect Number (1 or 2)
TRANWIDTH
NUMBER
Transect Width (1 m)
TRANLENGTH
NUMBER
Transect Length (12 m)
TAXONCODE
NVARCHAR2
Organism observed (4-letter code)
SIZECLASS
NVARCHAR2
Uneven size-class bins (0-5 cm, 5-10 cm, 10-20 cm, 20-40 cm, 40-80 cm, 80-160 cm, and >160 cm)
COUNT
NUMBER
Number of coral colonies (1-229)
TAXONNAME
NVARCHAR2
Taxonomic name to lowest level identified
PHYLUM
VARCHAR2
Phylum Taxonomic Rank
CLASS
NVARCHAR2
Class Taxonomic Rank
S_ORDER
VARCHAR2
Order Taxonomic Rank
FAMILY
VARCHAR2
Family Taxonomic Rank
GENUS
NVARCHAR2
Genus Taxonomic Rank
SCIENTIFIC_NAME
VARCHAR2
Species Taxonomic Rank. Only populated if organism identified to species (see RANK).
RANK
VARCHAR2
Rank from WoRMS (World Register of Marine Species).
APHIAID
VARCHAR2
Aphia ID from WoRMS. Only populated if organism identified to species (see RANK).

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_A
Short Name: V0_CORAL_OBS_A
Status: Completed
Abstract:

Coral belt observations

Entity Information

Entity Type: Data View
Active Version?: Yes
Schema Name: GISDAT
Description:

Coral belt observations

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
ROUNDID NUMBER Unique numeric id for mission
100
MISSIONID VARCHAR2 Unique text id for mission
100
REGION VARCHAR2 Region code representing one of the five Pacific Island regions surveyed by the Coral Reef Ecosystem Program
100
REGION_NAME VARCHAR2 One of the five Pacific Island regions surveyed by the Coral Reef Ecosystem Program (Main Hawaiian Islands)
100
ISLAND NVARCHAR2 Island or atoll surveyed (Oahu, Maui, Hawaii)
100
ISLANDCODE NVARCHAR2 3-letter island code (OAH, MAI, HAW)
100
SITE NVARCHAR2 The code for the site surveyed. Combines a 3-letter island code 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
SITEVISITID NUMBER Unique Identifier for SITE_VISIT record (unique for site and date)
100
DATE_ DATE Date the survey was conducted
100
OBS_YEAR NUMBER Year the survey was conducted
100
DIVER NVARCHAR2 Initials of diver that conducted the survey
100
BELTTRANSECTRUN NUMBER Primary key for CORAL_BELT_TRANSECTRUN
100
METHODNAME NVARCHAR2 References the coral belt survey method (coral belt method A)
100
TRANSECT NUMBER Transect Number (1 or 2)
100
TRANWIDTH NUMBER Transect Width (1 m)
100
TRANLENGTH NUMBER Transect Length (12 m)
100
TAXONCODE NVARCHAR2 Organism observed (4-letter code)
100
SIZECLASS NVARCHAR2 Uneven size-class bins (0-5 cm, 5-10 cm, 10-20 cm, 20-40 cm, 40-80 cm, 80-160 cm, and >160 cm)
100
COUNT NUMBER Number of coral colonies (1-229)
100
TAXONNAME NVARCHAR2 Taxonomic name to lowest level identified
100
PHYLUM VARCHAR2 Phylum Taxonomic Rank
100
CLASS NVARCHAR2 Class Taxonomic Rank
100
S_ORDER VARCHAR2 Order Taxonomic Rank
100
FAMILY VARCHAR2 Family Taxonomic Rank
100
GENUS NVARCHAR2 Genus Taxonomic Rank
100
SCIENTIFIC_NAME VARCHAR2 Species Taxonomic Rank. Only populated if organism identified to species (see RANK).
100
RANK VARCHAR2 Rank from WoRMS (World Register of Marine Species).
100
APHIAID VARCHAR2 Aphia ID from WoRMS. Only populated if organism identified to species (see RANK).

Attribute Details

ROUNDID

CC ID: 595796
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 28
Scale: 0
Status: Active
Description:

Unique numeric id for mission

MISSIONID

CC ID: 595776
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 30
Required: Yes
Primary Key: No
Status: Active
Description:

Unique text id for mission

REGION

CC ID: 595794
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 20
Required: Yes
Primary Key: No
Status: Active
Description:

Region code representing one of the five Pacific Island regions surveyed by the Coral Reef Ecosystem Program

REGION_NAME

CC ID: 595795
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 surveyed by the Coral Reef Ecosystem Program (Main Hawaiian Islands)

ISLAND

CC ID: 595771
Seq. Order: 5
Data Storage Type: NVARCHAR2
Max Length: 150
Required: No
Primary Key: No
Status: Active
Description:

Island or atoll surveyed (Oahu, Maui, Hawaii)

ISLANDCODE

CC ID: 595772
Seq. Order: 6
Data Storage Type: NVARCHAR2
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

3-letter island code (OAH, MAI, HAW)

SITE

CC ID: 595802
Seq. Order: 7
Data Storage Type: NVARCHAR2
Max Length: 150
Required: Yes
Primary Key: No
Status: Active
Description:

The code for the site surveyed. Combines a 3-letter island code with a 2-4 digit site number

LATITUDE

CC ID: 595773
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

CC ID: 595774
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

SITEVISITID

CC ID: 595803
Seq. Order: 12
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Status: Active
Description:

Unique Identifier for SITE_VISIT record (unique for site and date)

DATE_

CC ID: 595761
Seq. Order: 13
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

Date the survey was conducted

OBS_YEAR

CC ID: 595782
Seq. Order: 14
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Year the survey was conducted

DIVER

CC ID: 595764
Seq. Order: 15
Data Storage Type: NVARCHAR2
Max Length: 150
Required: Yes
Primary Key: No
Status: Active
Description:

Initials of diver that conducted the survey

BELTTRANSECTRUN

CC ID: 595755
Seq. Order: 16
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

CC ID: 595775
Seq. Order: 17
Data Storage Type: NVARCHAR2
Max Length: 150
Required: Yes
Primary Key: No
Status: Active
Description:

References the coral belt survey method (coral belt method A)

TRANSECT

CC ID: 595809
Seq. Order: 18
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Scale: 0
Status: Active
Description:

Transect Number (1 or 2)

TRANWIDTH

CC ID: 700206
Seq. Order: 19
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Transect Width (1 m)

TRANLENGTH

CC ID: 700207
Seq. Order: 20
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Transect Length (12 m)

TAXONCODE

CC ID: 595807
Seq. Order: 23
Data Storage Type: NVARCHAR2
Max Length: 150
Required: No
Primary Key: No
Status: Active
Description:

Organism observed (4-letter code)

SIZECLASS

CC ID: 700209
Seq. Order: 24
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Uneven size-class bins (0-5 cm, 5-10 cm, 10-20 cm, 20-40 cm, 40-80 cm, 80-160 cm, and >160 cm)

COUNT

CC ID: 700210
Seq. Order: 25
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Number of coral colonies (1-229)

TAXONNAME

CC ID: 595808
Seq. Order: 26
Data Storage Type: NVARCHAR2
Max Length: 765
Required: No
Primary Key: No
Status: Active
Description:

Taxonomic name to lowest level identified

PHYLUM

CC ID: 595784
Seq. Order: 27
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Phylum Taxonomic Rank

CLASS

CC ID: 595756
Seq. Order: 28
Data Storage Type: NVARCHAR2
Max Length: 60
Required: No
Primary Key: No
Status: Active
Description:

Class Taxonomic Rank

S_ORDER

CC ID: 595806
Seq. Order: 29
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Order Taxonomic Rank

FAMILY

CC ID: 595766
Seq. Order: 30
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Family Taxonomic Rank

GENUS

CC ID: 595767
Seq. Order: 31
Data Storage Type: NVARCHAR2
Max Length: 300
Required: No
Primary Key: No
Status: Active
Description:

Genus Taxonomic Rank

SCIENTIFIC_NAME

CC ID: 595797
Seq. Order: 32
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Species Taxonomic Rank. Only populated if organism identified to species (see RANK).

RANK

CC ID: 595785
Seq. Order: 33
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Rank from WoRMS (World Register of Marine Species).

APHIAID

CC ID: 595754
Seq. Order: 34
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Aphia ID from WoRMS. Only populated if organism identified to species (see RANK).

Catalog Details

Catalog Item ID: 47679
GUID: gov.noaa.nmfs.inport:47679
Metadata Record Created By: Troy T Kanemura
Metadata Record Created: 2017-10-27 21:40+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2017-12-22
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2017-12-22
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2018-12-22