Metadata Rubric

100%

6 / 6

PIFSC Metadata Library > PIFSC Coral Reef Ecosystem Program (CREP) Metad... > Ecosystem Monitoring and Assessment > Pacific Reef Assessment and Monitoring Program:... >

View: V0_CORAL_OBS_QUAD

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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Represents the quadrat surveys of coral population parameters of the Marianas Islands, collected by the NOAA Pacific Island Fisheries Science Center's (PIFSC) Coral Reef Ecosystem Division (CRED).

Description

Represents the quadrat surveys of coral population parameters of the Marianas Islands, collected by the NOAA Pacific Island Fisheries Science Center's (PIFSC) Coral Reef Ecosystem Division (CRED).

Entity Type
Data View

Data Attribute / Type	Description
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
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 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
EXCLUDE_FLAG NUMBER	Flag to indicate whether site should be excluded from analysis
SITEVISITID NUMBER	Unique Identifier
DATE_ DATE	Date the survey was conducted
OBS_YEAR NUMBER	Year the survey was conducted
DIVER NVARCHAR2	Initials of diver conducting survey
BELTTRANSECTRUN NUMBER	Primary key for the coral belt transect run
METHODNAME NVARCHAR2	Survey method employed
TRANSECT NUMBER	Transect Number
TRANWIDTH NUMBER	Transect Width (m)
TRANLENGTH NUMBER	Transect Length (m)
MINDEPTH NUMBER	Minimum Depth of the transect (in meters)
MAXDEPTH NUMBER	Maximum Depth of the transect (in meters)
SPECIES NVARCHAR2	Species observed
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 NVARCHAR2	Genus Taxonomic Rank
SCIENTIFIC_NAME VARCHAR2	Scientific Name Taxonomic Rank
RANK VARCHAR2	Rank from WoRMS
APHIAID VARCHAR2	Aphia ID from WoRMS
CORIS_ID NUMBER	CoRIS ID for coral metadata record (Added June 2011)

Data Attribute / Type

Description

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

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

EXCLUDE_FLAG
NUMBER

Flag to indicate whether site should be excluded from analysis

SITEVISITID
NUMBER

Unique Identifier

DATE_
DATE

Date the survey was conducted

OBS_YEAR
NUMBER

Year the survey was conducted

DIVER
NVARCHAR2

Initials of diver conducting survey

BELTTRANSECTRUN
NUMBER

Primary key for the coral belt transect run

METHODNAME
NVARCHAR2

Survey method employed

TRANSECT
NUMBER

Transect Number

TRANWIDTH
NUMBER

Transect Width (m)

TRANLENGTH
NUMBER

Transect Length (m)

MINDEPTH
NUMBER

Minimum Depth of the transect (in meters)

MAXDEPTH
NUMBER

Maximum Depth of the transect (in meters)

SPECIES
NVARCHAR2

Species observed

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
NVARCHAR2

Genus Taxonomic Rank

SCIENTIFIC_NAME
VARCHAR2

Scientific Name Taxonomic Rank

RANK
VARCHAR2

Rank from WoRMS

APHIAID
VARCHAR2

Aphia ID from WoRMS

CORIS_ID
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_QUAD
Short Name:	V0_CORAL_OBS_QUAD
Status:	Completed
Abstract:	Represents the quadrat surveys of coral population parameters of the Marianas Islands, collected by the NOAA Pacific Island Fisheries Science Center's (PIFSC) Coral Reef Ecosystem Division (CRED).
Notes:	Loaded by batch 6093, 05-28-2015 19:50

Entity Type:	Data View
Active Version?:	Yes
Schema Name:	GISDAT
Description:	Represents the quadrat surveys of coral population parameters of the Marianas Islands, collected by the NOAA Pacific Island Fisheries Science Center's (PIFSC) Coral Reef Ecosystem Division (CRED).

Attribute Summary

	Name	Type	Description
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	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	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	EXCLUDE_FLAG	NUMBER	Flag to indicate whether site should be excluded from analysis
100	SITEVISITID	NUMBER	Unique Identifier
100	DATE_	DATE	Date the survey was conducted
100	OBS_YEAR	NUMBER	Year the survey was conducted
100	DIVER	NVARCHAR2	Initials of diver conducting survey
100	BELTTRANSECTRUN	NUMBER	Primary key for the coral belt transect run
100	METHODNAME	NVARCHAR2	Survey method employed
100	TRANSECT	NUMBER	Transect Number
100	TRANWIDTH	NUMBER	Transect Width (m)
100	TRANLENGTH	NUMBER	Transect Length (m)
100	MINDEPTH	NUMBER	Minimum Depth of the transect (in meters)
100	MAXDEPTH	NUMBER	Maximum Depth of the transect (in meters)
100	SPECIES	NVARCHAR2	Species observed
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	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	CORIS_ID	NUMBER	CoRIS ID for coral metadata record (Added June 2011)

Name

Type

Description

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

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

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

EXCLUDE_FLAG

NUMBER

Flag to indicate whether site should be excluded from analysis

100

SITEVISITID

NUMBER

Unique Identifier

100

DATE_

DATE

Date the survey was conducted

100

OBS_YEAR

NUMBER

Year the survey was conducted

100

DIVER

NVARCHAR2

Initials of diver conducting survey

100

BELTTRANSECTRUN

NUMBER

Primary key for the coral belt transect run

100

METHODNAME

NVARCHAR2

Survey method employed

100

TRANSECT

NUMBER

Transect Number

100

TRANWIDTH

NUMBER

Transect Width (m)

100

TRANLENGTH

NUMBER

Transect Length (m)

100

MINDEPTH

NUMBER

Minimum Depth of the transect (in meters)

100

MAXDEPTH

NUMBER

Maximum Depth of the transect (in meters)

100

SPECIES

NVARCHAR2

Species observed

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

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

CORIS_ID

NUMBER

CoRIS ID for coral metadata record (Added June 2011)

Attribute Details

MISSIONID

CC ID: 202566

Seq. Order:	1
Data Storage Type:	VARCHAR2
Max Length:	30
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Mission Identifier
General Data Type:	VARCHAR2

REGION

CC ID: 202577

Seq. Order:	2
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: 202588

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
General Data Type:	VARCHAR2

ISLAND

CC ID: 202595

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

SECTOR

CC ID: 202596

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

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

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

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

CC ID: 202600

Seq. Order:	9
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: 202567

Seq. Order:	10
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

EXCLUDE_FLAG

CC ID: 202568

Seq. Order:	11
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: 202569

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

DATE_

CC ID: 202570

Seq. Order:	13
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_YEAR

CC ID: 202571

Seq. Order:	14
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Year the survey was conducted
General Data Type:	NUMBER

DIVER

CC ID: 202572

Seq. Order:	15
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: 202573

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 the coral belt transect run
General Data Type:	NUMBER

METHODNAME

CC ID: 202574

Seq. Order:	17
Data Storage Type:	NVARCHAR2
Max Length:	150
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Survey method employed
General Data Type:	NVARCHAR2

TRANSECT

CC ID: 202575

Seq. Order:	18
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

TRANWIDTH

CC ID: 202576

Seq. Order:	19
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

TRANLENGTH

CC ID: 202578

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

MINDEPTH

CC ID: 202579

Seq. Order:	21
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: 202580

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

SPECIES

CC ID: 202581

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

COLONYLENGTH

CC ID: 202582

Seq. Order:	24
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: 202583

Seq. Order:	25
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: 202584

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

PHYLUM

CC ID: 202585

Seq. Order:	27
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: 202586

Seq. Order:	28
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: 202587

Seq. Order:	29
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: 202589

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

GENUS

CC ID: 202590

Seq. Order:	31
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: 202591

Seq. Order:	32
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: 202592

Seq. Order:	33
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: 202593

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

CORIS_ID

CC ID: 202594

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

Catalog Item ID:	25177
GUID:	gov.noaa.nmfs.inport:25177
Metadata Record Created By:	Annette M DesRochers
Metadata Record Created:	2015-05-28 19:50+0000
Metadata Record Last Modified By:	SysAdmin InPortAdmin
Metadata Record Last Modified:	2022-08-09 17:11+0000
Metadata Record Published:	2017-03-30
Owner Org:	PIFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2017-03-30
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2018-03-30

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

MISSIONID

REGION

REGION_NAME

ISLAND

SECTOR

SITE

LATITUDE

LONGITUDE

REEF_ZONE

DEPTH_BIN

EXCLUDE_FLAG

SITEVISITID

DATE_

OBS_YEAR

DIVER

BELTTRANSECTRUN

METHODNAME

TRANSECT

TRANWIDTH

TRANLENGTH

MINDEPTH

MAXDEPTH

SPECIES

COLONYLENGTH

COLONYWIDTH

TAXONNAME

PHYLUM

CLASS

S_ORDER

FAMILY

GENUS

SCIENTIFIC_NAME

RANK

APHIAID

CORIS_ID

Catalog Details