Metadata Rubric

100%

6 / 6

PIFSC Metadata Library > PIFSC Coral Reef Ecosystem Program (CREP) Metad... > International Programs > Timor Leste > Benthic percent cover derived from analysis of... >

Table: BIA_PERC_COVER_PHOTO_TIMOR

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

Item Identification

Title:	Table: BIA_PERC_COVER_PHOTO_TIMOR
Status:	Completed
Abstract:	Benthic image analysis results

Entity Information

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	GISDAT
Description:	Benthic image analysis results for survey sites

Data Attributes

Attribute Summary

	Name	Type	Description
100	MISSIONID	VARCHAR2	Mission Identifier
100	REGION_NAME	VARCHAR2	One of the five Pacific Island regions CRED surveys
100	ISLAND	NVARCHAR2	Island or Atoll surveyed
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	Site latitude
100	LONGITUDE	NUMBER	Site longitude
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	DATE_	DATE	Date the survey was conducted
100	IMAGE_NAME	VARCHAR2	Image name (SITE_YEAR_REP_PHOTOID)
100	OBS_YEAR	VARCHAR2	Year the survey was conducted
100	REP	VARCHAR2	Letter associated to replicate (A, B, C, or D)
100	PHOTOID	VARCHAR2	Image number along transect
100	ANALYST	VARCHAR2	Initials of the image analyst
100	TIER_1	VARCHAR2	Category classification code of the point on the analyzed image
100	CATEGORY_NAME	VARCHAR2	Category classification name of the point on the analyzed image
100	TIER_2	VARCHAR2	Subcategory classification code of the point on the analyzed image
100	SUBCATEGORY_NAME	VARCHAR2	Subcategory classification name of the point on the analyzed image
100	X_POS	NUMBER	X position of the analyzed point
100	Y_POS	NUMBER	Y position of the analyzed point
100	SECTOR	VARCHAR2	Sectors are defined to subsample large survey areas (i.e., islands or country coastlines). Each sector is treated as an independent survey area. Sectors are similar to districts with a few exceptions.
100	DISTRICT	VARCHAR2	Municipal boundaries defined by the Government of Timor-Leste.
100	HABITAT_CODE	NVARCHAR2	Habitat types are AGR (aggregate reef); MIX (mixed habitats); PAV (pavement); ROB (rock/boulder); RRB (reef rubble); and SCR (sand with scattered coral/rock).
100	POINT_NUMBER	NUMBER	Sequence number of the analyzed point (1-10).
100	BSR	NUMBER	Benthic substrate ratio - calculated as the sum of the percent cover of hard coral (CORAL), soft coral (SC), and CCA divided by the sum of the percent cover of macroalgae (MA) and turf algae (TURF).

Name

Type

Description

100

MISSIONID

VARCHAR2

Mission Identifier

100

REGION_NAME

VARCHAR2

One of the five Pacific Island regions CRED surveys

100

ISLAND

NVARCHAR2

Island or Atoll surveyed

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

Site latitude

100

LONGITUDE

NUMBER

Site longitude

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

DATE_

DATE

Date the survey was conducted

100

IMAGE_NAME

VARCHAR2

Image name (SITE_YEAR_REP_PHOTOID)

100

OBS_YEAR

VARCHAR2

Year the survey was conducted

100

REP

VARCHAR2

Letter associated to replicate (A, B, C, or D)

100

PHOTOID

VARCHAR2

Image number along transect

100

ANALYST

VARCHAR2

Initials of the image analyst

100

TIER_1

VARCHAR2

Category classification code of the point on the analyzed image

100

CATEGORY_NAME

VARCHAR2

Category classification name of the point on the analyzed image

100

TIER_2

VARCHAR2

Subcategory classification code of the point on the analyzed image

100

SUBCATEGORY_NAME

VARCHAR2

Subcategory classification name of the point on the analyzed image

100

X_POS

NUMBER

X position of the analyzed point

100

Y_POS

NUMBER

Y position of the analyzed point

100

SECTOR

VARCHAR2

Sectors are defined to subsample large survey areas (i.e., islands or country coastlines). Each sector is treated as an independent survey area. Sectors are similar to districts with a few exceptions.

100

DISTRICT

VARCHAR2

Municipal boundaries defined by the Government of Timor-Leste.

100

HABITAT_CODE

NVARCHAR2

Habitat types are AGR (aggregate reef); MIX (mixed habitats); PAV (pavement); ROB (rock/boulder); RRB (reef rubble); and SCR (sand with scattered coral/rock).

100

POINT_NUMBER

NUMBER

Sequence number of the analyzed point (1-10).

100

BSR

NUMBER

Benthic substrate ratio - calculated as the sum of the percent cover of hard coral (CORAL), soft coral (SC), and CCA divided by the sum of the percent cover of macroalgae (MA) and turf algae (TURF).

Attribute Details

MISSIONID

CC ID: 579782

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

REGION_NAME

CC ID: 579787

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

ISLAND

CC ID: 579777

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

SITE

CC ID: 579790

Seq. Order:	5
Data Storage Type:	NVARCHAR2
Max Length:	150
Required:	No
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

CC ID: 579778

Seq. Order:	6
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Scale:	8
Status:	Active
Description:	Site latitude

LONGITUDE

CC ID: 579779

Seq. Order:	7
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	28
Scale:	8
Status:	Active
Description:	Site longitude

REEF_ZONE

CC ID: 579786

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

CC ID: 579774

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

DATE_

CC ID: 579773

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

IMAGE_NAME

CC ID: 579776

Seq. Order:	15
Data Storage Type:	VARCHAR2
Max Length:	4000
Required:	No
Primary Key:	No
Status:	Active
Description:	Image name (SITE_YEAR_REP_PHOTOID)

OBS_YEAR

CC ID: 579783

Seq. Order:	16
Data Storage Type:	VARCHAR2
Max Length:	16
Required:	No
Primary Key:	No
Status:	Active
Description:	Year the survey was conducted

REP

CC ID: 579788

Seq. Order:	17
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Letter associated to replicate (A, B, C, or D)

PHOTOID

CC ID: 579785

Seq. Order:	18
Data Storage Type:	VARCHAR2
Max Length:	4000
Required:	No
Primary Key:	No
Status:	Active
Description:	Image number along transect

ANALYST

CC ID: 579770

Seq. Order:	19
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	Initials of the image analyst

TIER_1

CC ID: 579792

Seq. Order:	20
Data Storage Type:	VARCHAR2
Max Length:	5
Required:	No
Primary Key:	No
Status:	Active
Description:	Category classification code of the point on the analyzed image

CATEGORY_NAME

CC ID: 579771

Seq. Order:	21
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	Category classification name of the point on the analyzed image

TIER_2

CC ID: 579793

Seq. Order:	22
Data Storage Type:	VARCHAR2
Max Length:	5
Required:	No
Primary Key:	No
Status:	Active
Description:	Subcategory classification code of the point on the analyzed image

SUBCATEGORY_NAME

CC ID: 579791

Seq. Order:	23
Data Storage Type:	VARCHAR2
Max Length:	50
Required:	No
Primary Key:	No
Status:	Active
Description:	Subcategory classification name of the point on the analyzed image

X_POS

CC ID: 579795

Seq. Order:	26
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	X position of the analyzed point

Y_POS

CC ID: 579796

Seq. Order:	27
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	Y position of the analyzed point

SECTOR

CC ID: 579820

Data Storage Type:	VARCHAR2
Required:	No
Primary Key:	No
Status:	Active
Description:	Sectors are defined to subsample large survey areas (i.e., islands or country coastlines). Each sector is treated as an independent survey area. Sectors are similar to districts with a few exceptions.

DISTRICT

CC ID: 579821

Data Storage Type:	VARCHAR2
Required:	No
Primary Key:	No
Status:	Active
Description:	Municipal boundaries defined by the Government of Timor-Leste.

HABITAT_CODE

CC ID: 579822

Data Storage Type:	NVARCHAR2
Required:	No
Primary Key:	No
Status:	Active
Description:	Habitat types are AGR (aggregate reef); MIX (mixed habitats); PAV (pavement); ROB (rock/boulder); RRB (reef rubble); and SCR (sand with scattered coral/rock).

POINT_NUMBER

CC ID: 694622

Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	Sequence number of the analyzed point (1-10).

BSR

CC ID: 694623

Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	Benthic substrate ratio - calculated as the sum of the percent cover of hard coral (CORAL), soft coral (SC), and CCA divided by the sum of the percent cover of macroalgae (MA) and turf algae (TURF).

Catalog Details

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