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

Rubric Score Primary Key? 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
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: 2019-06-04 13:14+0000
Metadata Record Published: 2017-11-20
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2018-11-21