Metadata Rubric

100%

6 / 6

PIFSC Metadata Library > PIFSC Coral Reef Ecosystem Program (CREP) Metad... > Ecosystem Monitoring and Assessment > Hawaii Disease Project > Environmental Monitoring of Coral Bleaching and... >

View: V0_CORAL_OBS_A

Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:47679 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Coral belt observations

Description

Coral belt observations

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).

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).

No Child Items for this record.

No contact information is available for this record.

Please contact the owner organization (PIFSC) for inquiries on this record.

Title:	View: V0_CORAL_OBS_A
Short Name:	V0_CORAL_OBS_A
Status:	Completed
Abstract:	Coral belt observations

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

Attribute Summary

	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).

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 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

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

ROUNDID

MISSIONID

REGION

REGION_NAME

ISLAND

ISLANDCODE

SITE

LATITUDE

LONGITUDE

SITEVISITID

DATE_

OBS_YEAR

DIVER

BELTTRANSECTRUN

METHODNAME

TRANSECT

TRANWIDTH

TRANLENGTH

TAXONCODE

SIZECLASS

COUNT

TAXONNAME

PHYLUM

CLASS

S_ORDER

FAMILY

GENUS

SCIENTIFIC_NAME

RANK

APHIAID

Catalog Details