Metadata Rubric

100%

6 / 6

PIFSC Metadata Library > PIFSC Coral Reef Ecosystem Program (CREP) Metad... > Ecosystem Monitoring and Assessment > Benthic Missions > Determining Watershed Management Efficacy in We... >

View: V0_CORAL_OBS_F

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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Coral belt observations (juvenile)

Description

Coral belt observations (juvenile)

Entity Type
Data View

Data Attribute / Type	Description
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
SECTOR VARCHAR2	This field is used by the fish team to represent a different stratification scheme based on fishing pressure and wave exposure around an island (Added Jan. 2012)
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
EXCLUDE_FLAG NUMBER	Flag to indicate whether site should be excluded from analysis
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
HABITAT_CODE VARCHAR2	Habitat code
HABITAT_TYPE VARCHAR2	Habitat type
COMMENTS NVARCHAR2	General observation comments
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
TRANWIDTH NUMBER	Transect Length (m)
TRANLENGTH NUMBER	Transect Width (m)
MINDEPTH NUMBER	Minimum Depth of the transect (in meters)
MAXDEPTH NUMBER	Minimum Depth of the transect (in meters)
COLONYID NUMBER	Colony Identifier
SPECIES NVARCHAR2	Species observed
MORPH_CODE VARCHAR2	4-letter morphology code
MORPHOLOGY VARCHAR2	Definition of morphology code
COLONYLENGTH NUMBER	Colony Length (cm)
COLONYWIDTH NUMBER	Colony Width (cm)
TAXONNAME NVARCHAR2	Taxonomic Name
PHYLUM VARCHAR2	Phylum Taxonomic Rank
CLASS NVARCHAR2	Class Taxonomic Rank
S_ORDER VARCHAR2	Order Taxonomic Rank
FAMILY VARCHAR2	Family Taxonomic Rank
GENUS_CODE NVARCHAR2	4-letter genus code
GENUS NVARCHAR2	Genus Taxonomic Rank
SCIENTIFIC_NAME VARCHAR2	Scientific Name Taxonomic Rank
RANK VARCHAR2	Rank from WoRMS
APHIAID VARCHAR2	Aphia ID from WoRMS
CORAL_CORISID NUMBER	CoRIS ID for coral metadata record (Added June 2011)

Data Attribute / Type

Description

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

SECTOR
VARCHAR2

This field is used by the fish team to represent a different stratification scheme based on fishing pressure and wave exposure around an island (Added Jan. 2012)

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

EXCLUDE_FLAG
NUMBER

Flag to indicate whether site should be excluded from analysis

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

HABITAT_CODE
VARCHAR2

Habitat code

HABITAT_TYPE
VARCHAR2

Habitat type

COMMENTS
NVARCHAR2

General observation comments

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

TRANWIDTH
NUMBER

Transect Length (m)

TRANLENGTH
NUMBER

Transect Width (m)

MINDEPTH
NUMBER

Minimum Depth of the transect (in meters)

MAXDEPTH
NUMBER

Minimum Depth of the transect (in meters)

COLONYID
NUMBER

Colony Identifier

SPECIES
NVARCHAR2

Species observed

MORPH_CODE
VARCHAR2

4-letter morphology code

MORPHOLOGY
VARCHAR2

Definition of morphology code

COLONYLENGTH
NUMBER

Colony Length (cm)

COLONYWIDTH
NUMBER

Colony Width (cm)

TAXONNAME
NVARCHAR2

Taxonomic Name

PHYLUM
VARCHAR2

Phylum Taxonomic Rank

CLASS
NVARCHAR2

Class Taxonomic Rank

S_ORDER
VARCHAR2

Order Taxonomic Rank

FAMILY
VARCHAR2

Family Taxonomic Rank

GENUS_CODE
NVARCHAR2

4-letter genus code

GENUS
NVARCHAR2

Genus Taxonomic Rank

SCIENTIFIC_NAME
VARCHAR2

Scientific Name Taxonomic Rank

RANK
VARCHAR2

Rank from WoRMS

APHIAID
VARCHAR2

Aphia ID from WoRMS

CORAL_CORISID
NUMBER

CoRIS ID for coral metadata record (Added June 2011)

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_F
Short Name:	V0_CORAL_OBS_F
Status:	Completed
Abstract:	Coral belt observations (juvenile)
Notes:	Loaded by batch 7117, 09-23-2015 23:06

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

Attribute Summary

	Name	Type	Description
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	SECTOR	VARCHAR2	This field is used by the fish team to represent a different stratification scheme based on fishing pressure and wave exposure around an island (Added Jan. 2012)
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	EXCLUDE_FLAG	NUMBER	Flag to indicate whether site should be excluded from analysis
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	HABITAT_CODE	VARCHAR2	Habitat code
100	HABITAT_TYPE	VARCHAR2	Habitat type
100	COMMENTS	NVARCHAR2	General observation comments
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	TRANWIDTH	NUMBER	Transect Length (m)
100	TRANLENGTH	NUMBER	Transect Width (m)
100	MINDEPTH	NUMBER	Minimum Depth of the transect (in meters)
100	MAXDEPTH	NUMBER	Minimum Depth of the transect (in meters)
100	COLONYID	NUMBER	Colony Identifier
100	SPECIES	NVARCHAR2	Species observed
100	MORPH_CODE	VARCHAR2	4-letter morphology code
100	MORPHOLOGY	VARCHAR2	Definition of morphology code
100	COLONYLENGTH	NUMBER	Colony Length (cm)
100	COLONYWIDTH	NUMBER	Colony Width (cm)
100	TAXONNAME	NVARCHAR2	Taxonomic Name
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_CODE	NVARCHAR2	4-letter genus code
100	GENUS	NVARCHAR2	Genus Taxonomic Rank
100	SCIENTIFIC_NAME	VARCHAR2	Scientific Name Taxonomic Rank
100	RANK	VARCHAR2	Rank from WoRMS
100	APHIAID	VARCHAR2	Aphia ID from WoRMS
100	CORAL_CORISID	NUMBER	CoRIS ID for coral metadata record (Added June 2011)

Name

Type

Description

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

SECTOR

VARCHAR2

This field is used by the fish team to represent a different stratification scheme based on fishing pressure and wave exposure around an island (Added Jan. 2012)

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

EXCLUDE_FLAG

NUMBER

Flag to indicate whether site should be excluded from analysis

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

HABITAT_CODE

VARCHAR2

Habitat code

100

HABITAT_TYPE

VARCHAR2

Habitat type

100

COMMENTS

NVARCHAR2

General observation comments

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

TRANWIDTH

NUMBER

Transect Length (m)

100

TRANLENGTH

NUMBER

Transect Width (m)

100

MINDEPTH

NUMBER

Minimum Depth of the transect (in meters)

100

MAXDEPTH

NUMBER

Minimum Depth of the transect (in meters)

100

COLONYID

NUMBER

Colony Identifier

100

SPECIES

NVARCHAR2

Species observed

100

MORPH_CODE

VARCHAR2

4-letter morphology code

100

MORPHOLOGY

VARCHAR2

Definition of morphology code

100

COLONYLENGTH

NUMBER

Colony Length (cm)

100

COLONYWIDTH

NUMBER

Colony Width (cm)

100

TAXONNAME

NVARCHAR2

Taxonomic Name

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_CODE

NVARCHAR2

4-letter genus code

100

GENUS

NVARCHAR2

Genus Taxonomic Rank

100

SCIENTIFIC_NAME

VARCHAR2

Scientific Name Taxonomic Rank

100

RANK

VARCHAR2

Rank from WoRMS

100

APHIAID

VARCHAR2

Aphia ID from WoRMS

100

CORAL_CORISID

NUMBER

CoRIS ID for coral metadata record (Added June 2011)

Attribute Details

REGION

CC ID: 224690

Seq. Order:	1
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
General Data Type:	VARCHAR2

REGION_NAME

CC ID: 224691

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	30
Required:	No
Primary Key:	No
Status:	Active
Description:	One of the five Pacific Island regions CRED surveys
General Data Type:	VARCHAR2

ISLAND

CC ID: 224692

Seq. Order:	3
Data Storage Type:	NVARCHAR2
Max Length:	150
Required:	No
Primary Key:	No
Status:	Active
Description:	Island or Atoll surveyed
General Data Type:	NVARCHAR2

ISLANDCODE

CC ID: 224693

Seq. Order:	4
Data Storage Type:	NVARCHAR2
Max Length:	15
Required:	No
Primary Key:	No
Status:	Active
Description:	3-letter island code
General Data Type:	NVARCHAR2

SECTOR

CC ID: 224694

Seq. Order:	5
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	This field is used by the fish team to represent a different stratification scheme based on fishing pressure and wave exposure around an island (Added Jan. 2012)
General Data Type:	VARCHAR2

SITE

CC ID: 224695

Seq. Order:	6
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.
General Data Type:	NVARCHAR2

LATITUDE

CC ID: 224696

Seq. Order:	7
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	Latitude in decimal degrees, WGS84, for the given site
General Data Type:	NUMBER

LONGITUDE

CC ID: 224697

Seq. Order:	8
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Longitude in decimal degrees, WGS84 for the given site
General Data Type:	NUMBER

REEF_ZONE_CODE

CC ID: 224698

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	Yes
Primary Key:	No
Status:	Active
Description:	3-letter reef zone code
General Data Type:	VARCHAR2

REEF_ZONE

CC ID: 224699

Seq. Order:	10
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)
General Data Type:	NVARCHAR2

DEPTH_BIN

CC ID: 224700

Seq. Order:	11
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
General Data Type:	NVARCHAR2

DEPTH_CODE

CC ID: 224701

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Depth zone code
General Data Type:	VARCHAR2

EXCLUDE_FLAG

CC ID: 224702

Seq. Order:	13
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	Flag to indicate whether site should be excluded from analysis
General Data Type:	NUMBER

SITEVISITID

CC ID: 224703

Seq. Order:	14
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	38
Status:	Active
Description:	Unique Identifier for SITE_VISIT record
General Data Type:	NUMBER

DATE_

CC ID: 224704

Seq. Order:	15
Data Storage Type:	DATE
Max Length:	7
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Date the survey was conducted
General Data Type:	DATE

OBS_DAY

CC ID: 224705

Seq. Order:	16
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Observation Day
General Data Type:	NUMBER

OBS_MONTH

CC ID: 224706

Seq. Order:	17
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	Observation Month
General Data Type:	NUMBER

OBS_YEAR

CC ID: 224707

Seq. Order:	18
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Observation Year
General Data Type:	NUMBER

HABITAT_CODE

CC ID: 224708

Seq. Order:	19
Data Storage Type:	VARCHAR2
Max Length:	50
Required:	No
Primary Key:	No
Status:	Active
Description:	Habitat code
General Data Type:	VARCHAR2

HABITAT_TYPE

CC ID: 224709

Seq. Order:	20
Data Storage Type:	VARCHAR2
Max Length:	30
Required:	No
Primary Key:	No
Status:	Active
Description:	Habitat type
General Data Type:	VARCHAR2

COMMENTS

CC ID: 224710

Seq. Order:	21
Data Storage Type:	NVARCHAR2
Max Length:	750
Required:	No
Primary Key:	No
Status:	Active
Description:	General observation comments
General Data Type:	NVARCHAR2

DIVER

CC ID: 224711

Seq. Order:	22
Data Storage Type:	NVARCHAR2
Max Length:	150
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Initials of diver conducting survey
General Data Type:	NVARCHAR2

BELTTRANSECTRUN

CC ID: 224712

Seq. Order:	23
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	28
Scale:	0
Status:	Active
Description:	Primary key for CORAL_BELT_TRANSECTRUN
General Data Type:	NUMBER

METHODNAME

CC ID: 224713

Seq. Order:	24
Data Storage Type:	NVARCHAR2
Max Length:	150
Required:	Yes
Primary Key:	No
Status:	Active
Description:	References the coral belt survey method
General Data Type:	NVARCHAR2

TRANSECT

CC ID: 224714

Seq. Order:	25
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	38
Scale:	0
Status:	Active
Description:	Transect Number
General Data Type:	NUMBER

SEGMENT

CC ID: 224715

Seq. Order:	26
Data Storage Type:	NVARCHAR2
Max Length:	150
Required:	No
Primary Key:	No
Status:	Active
Description:	Segment Number
General Data Type:	NVARCHAR2

TRANWIDTH

CC ID: 224716

Seq. Order:	27
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Scale:	8
Status:	Active
Description:	Transect Length (m)
General Data Type:	NUMBER

TRANLENGTH

CC ID: 224717

Seq. Order:	28
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	28
Scale:	8
Status:	Active
Description:	Transect Width (m)
General Data Type:	NUMBER

MINDEPTH

CC ID: 224718

Seq. Order:	29
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	28
Scale:	0
Status:	Active
Description:	Minimum Depth of the transect (in meters)
General Data Type:	NUMBER

MAXDEPTH

CC ID: 224719

Seq. Order:	30
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	28
Scale:	0
Status:	Active
Description:	Minimum Depth of the transect (in meters)
General Data Type:	NUMBER

COLONYID

CC ID: 224720

Seq. Order:	31
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	28
Scale:	0
Status:	Active
Description:	Colony Identifier
General Data Type:	NUMBER

SPECIES

CC ID: 224721

Seq. Order:	32
Data Storage Type:	NVARCHAR2
Max Length:	150
Required:	No
Primary Key:	No
Status:	Active
Description:	Species observed
General Data Type:	NVARCHAR2

MORPH_CODE

CC ID: 224722

Seq. Order:	33
Data Storage Type:	VARCHAR2
Max Length:	5
Required:	No
Primary Key:	No
Status:	Active
Description:	4-letter morphology code
General Data Type:	VARCHAR2

MORPHOLOGY

CC ID: 224723

Seq. Order:	34
Data Storage Type:	VARCHAR2
Max Length:	50
Required:	No
Primary Key:	No
Status:	Active
Description:	Definition of morphology code
General Data Type:	VARCHAR2

COLONYLENGTH

CC ID: 224724

Seq. Order:	35
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Scale:	8
Status:	Active
Description:	Colony Length (cm)
General Data Type:	NUMBER

COLONYWIDTH

CC ID: 224725

Seq. Order:	36
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	28
Scale:	8
Status:	Active
Description:	Colony Width (cm)
General Data Type:	NUMBER

TAXONNAME

CC ID: 224726

Seq. Order:	37
Data Storage Type:	NVARCHAR2
Max Length:	765
Required:	No
Primary Key:	No
Status:	Active
Description:	Taxonomic Name
General Data Type:	NVARCHAR2

PHYLUM

CC ID: 224727

Seq. Order:	38
Data Storage Type:	VARCHAR2
Max Length:	255
Required:	No
Primary Key:	No
Status:	Active
Description:	Phylum Taxonomic Rank
General Data Type:	VARCHAR2

CLASS

CC ID: 224728

Seq. Order:	39
Data Storage Type:	NVARCHAR2
Max Length:	60
Required:	No
Primary Key:	No
Status:	Active
Description:	Class Taxonomic Rank
General Data Type:	NVARCHAR2

S_ORDER

CC ID: 224729

Seq. Order:	40
Data Storage Type:	VARCHAR2
Max Length:	255
Required:	No
Primary Key:	No
Status:	Active
Description:	Order Taxonomic Rank
General Data Type:	VARCHAR2

FAMILY

CC ID: 224730

Seq. Order:	41
Data Storage Type:	VARCHAR2
Max Length:	255
Required:	No
Primary Key:	No
Status:	Active
Description:	Family Taxonomic Rank
General Data Type:	VARCHAR2

GENUS_CODE

CC ID: 224731

Seq. Order:	42
Data Storage Type:	NVARCHAR2
Max Length:	12
Required:	No
Primary Key:	No
Status:	Active
Description:	4-letter genus code
General Data Type:	NVARCHAR2

GENUS

CC ID: 224732

Seq. Order:	43
Data Storage Type:	NVARCHAR2
Max Length:	300
Required:	No
Primary Key:	No
Status:	Active
Description:	Genus Taxonomic Rank
General Data Type:	NVARCHAR2

SCIENTIFIC_NAME

CC ID: 224733

Seq. Order:	44
Data Storage Type:	VARCHAR2
Max Length:	255
Required:	No
Primary Key:	No
Status:	Active
Description:	Scientific Name Taxonomic Rank
General Data Type:	VARCHAR2

RANK

CC ID: 224734

Seq. Order:	45
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	Rank from WoRMS
General Data Type:	VARCHAR2

APHIAID

CC ID: 224735

Seq. Order:	46
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	Aphia ID from WoRMS
General Data Type:	VARCHAR2

CORAL_CORISID

CC ID: 224736

Seq. Order:	47
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	CoRIS ID for coral metadata record (Added June 2011)
General Data Type:	NUMBER

Catalog Item ID:	27439
GUID:	gov.noaa.nmfs.inport:27439
Metadata Record Created By:	Annette M DesRochers
Metadata Record Created:	2015-09-23 23:06+0000
Metadata Record Last Modified By:	SysAdmin InPortAdmin
Metadata Record Last Modified:	2022-08-09 17:11+0000
Metadata Record Published:	2020-04-03
Owner Org:	PIFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2020-04-03
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2021-04-03

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

REGION

REGION_NAME

ISLAND

ISLANDCODE

SECTOR

SITE

LATITUDE

LONGITUDE

REEF_ZONE_CODE

REEF_ZONE

DEPTH_BIN

DEPTH_CODE

EXCLUDE_FLAG

SITEVISITID

DATE_

OBS_DAY

OBS_MONTH

OBS_YEAR

HABITAT_CODE

HABITAT_TYPE

COMMENTS

DIVER

BELTTRANSECTRUN

METHODNAME

TRANSECT

SEGMENT

TRANWIDTH

TRANLENGTH

MINDEPTH

MAXDEPTH

COLONYID

SPECIES

MORPH_CODE

MORPHOLOGY

COLONYLENGTH

COLONYWIDTH

TAXONNAME

PHYLUM

CLASS

S_ORDER

FAMILY

GENUS_CODE

GENUS

SCIENTIFIC_NAME

RANK

APHIAID

CORAL_CORISID

Catalog Details