Item Identification

Title: Table: MV_BIA_PERC_COVER_PHOTO_CLI_RW
Short Name: MV_BIA_PERC_COVER_PHOTO_CLI_RW
Status: Completed
Abstract:

Benthic image analysis results for permanent sites / climate stations

Notes:

Loaded by batch 9615, 12-23-2016 19:41

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: GISDAT
Description:

Benthic image analysis results for permanent sites / climate stations

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
ROUNDID NUMBER Unique Identifier for ROUND record
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
PERM_SITE NUMBER Permanent site flag
100
CLIMATE_STATION_YN NUMBER Climate station flag
100
MIN_DEPTH NUMBER Minimum depth (measured in feet)
100
MAX_DEPTH NUMBER Maximum depth (measured in feet)
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
TIER_3 VARCHAR2 Genera classification code of the point on the analyzed image
100
GENERA_NAME VARCHAR2 Genera 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

Attribute Details

ROUNDID

CC ID: 368030
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 28
Scale: 0
Status: Active
Description:

Unique Identifier for ROUND record

General Data Type: NUMBER

MISSIONID

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

Mission Identifier

General Data Type: VARCHAR2

REGION_NAME

CC ID: 368032
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: 368033
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

SITE

CC ID: 368034
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

General Data Type: NVARCHAR2

LATITUDE

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

Site latitude

General Data Type: NUMBER

LONGITUDE

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

Site longitude

General Data Type: NUMBER

REEF_ZONE

CC ID: 368037
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)

General Data Type: NVARCHAR2

DEPTH_BIN

CC ID: 368038
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

General Data Type: NVARCHAR2

PERM_SITE

CC ID: 368039
Seq. Order: 10
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

Permanent site flag

General Data Type: NUMBER

CLIMATE_STATION_YN

CC ID: 368040
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Climate station flag

General Data Type: NUMBER

MIN_DEPTH

CC ID: 368041
Seq. Order: 12
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 8
Status: Active
Description:

Minimum depth (measured in feet)

General Data Type: NUMBER

MAX_DEPTH

CC ID: 368042
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 28
Scale: 8
Status: Active
Description:

Maximum depth (measured in feet)

General Data Type: NUMBER

DATE_

CC ID: 368043
Seq. Order: 14
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

Date the survey was conducted

General Data Type: DATE

IMAGE_NAME

CC ID: 368044
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

Image name (SITE_YEAR_REP_PHOTOID)

General Data Type: VARCHAR2

OBS_YEAR

CC ID: 368045
Seq. Order: 16
Data Storage Type: VARCHAR2
Max Length: 16
Required: No
Primary Key: No
Status: Active
Description:

Year the survey was conducted

General Data Type: VARCHAR2

REP

CC ID: 368046
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)

General Data Type: VARCHAR2

PHOTOID

CC ID: 368047
Seq. Order: 18
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

Image number along transect

General Data Type: VARCHAR2

ANALYST

CC ID: 368048
Seq. Order: 19
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Initials of the image analyst

General Data Type: VARCHAR2

TIER_1

CC ID: 368049
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

General Data Type: VARCHAR2

CATEGORY_NAME

CC ID: 368050
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

General Data Type: VARCHAR2

TIER_2

CC ID: 368051
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

General Data Type: VARCHAR2

SUBCATEGORY_NAME

CC ID: 368052
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

General Data Type: VARCHAR2

TIER_3

CC ID: 368053
Seq. Order: 24
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Genera classification code of the point on the analyzed image

General Data Type: VARCHAR2

GENERA_NAME

CC ID: 368054
Seq. Order: 25
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Genera classification name of the point on the analyzed image

General Data Type: VARCHAR2

X_POS

CC ID: 368055
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

General Data Type: NUMBER

Y_POS

CC ID: 368056
Seq. Order: 27
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Y position of the analyzed point

General Data Type: NUMBER

Catalog Details

Catalog Item ID: 36118
Metadata Record Created By: Annette M DesRochers
Metadata Record Created: 2016-12-23 19:41+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2019-06-04 13:14+0000
Metadata Record Published: 2017-01-06
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2018-01-07