Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Benthic image analysis results for stratified random sites

Description

Benthic image analysis results for stratified random sites

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
ROUNDID
NUMBER
Unique Identifier auto-assigned by database for ROUND record (corresponds to mission, cruise, cruise leg, etc.)
MISSIONID
VARCHAR2
Mission Identifier typically assigned by PIFSC
REGION_NAME
VARCHAR2
One of the five Pacific Island regions ESD surveys: Main Hawaiian islands, Northwestern Hawaiian islands, American Samoa, Marianas, and the Pacific Remote Island Areas.
ISLAND
NVARCHAR2
Island or Atoll surveyed
SITE
NVARCHAR2
The unique identifier/code for the site surveyed. Combines a 3-letter island code with a site number (usually 2-4 digits), separated by a hypen
LATITUDE
NUMBER
Site latitude in decimal degrees
LONGITUDE
NUMBER
Site longitude in decimal degrees
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. Shallow = 0-6m, Mid = 6-18m, Deep = 18-30m.
PERM_SITE
NUMBER
Permanent site flag, yes = -1
CLIMATE_STATION_YN
NUMBER
Climate station flag, yes = -1
MIN_DEPTH
NUMBER
Minimum depth (measured in feet), typically only recorded during 'Benthic' surveys (refer to SURVEY_TYPE)
MAX_DEPTH
NUMBER
Maximum depth (measured in feet), typically only recorded during 'Benthic' surveys (refer to SURVEY_TYPE)
DATE_
DATE
Date the survey was conducted
IMAGE_NAME
VARCHAR2
Image name (SITE_YEAR_REP_PHOTOID)
OBS_YEAR
VARCHAR2
Year the survey was conducted
REP
VARCHAR2
Letter associated to replicate (A, B, C, or D)
PHOTOID
VARCHAR2
Image number along transect
ANALYST
VARCHAR2
Initials of the image analyst
TIER_1
VARCHAR2
Category classification code of the point on the analyzed image
CATEGORY_NAME
VARCHAR2
Category classification name of the point on the analyzed image
TIER_2
VARCHAR2
Subcategory classification code of the point on the analyzed image
SUBCATEGORY_NAME
VARCHAR2
Subcategory classification name of the point on the analyzed image
TIER_3
VARCHAR2
Genera classification code of the point on the analyzed image
GENERA_NAME
VARCHAR2
Genera classification name of the point on the analyzed image
X_POS
NUMBER
X position of the analyzed point
Y_POS
NUMBER
Y position of the analyzed point
SURVEY_TYPE
TEXT
Identifies the ESD team that conducted the survey, typically 'Fish' or 'Benthic' for stratified random surveys, or 'Oceanography' for climate surveys at permanent sites.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (PIFSC) for inquiries on this record.

Item Identification

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

Benthic image analysis results for stratified random sites

Entity Information

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

Benthic image analysis results for stratified random sites

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
ROUNDID NUMBER Unique Identifier auto-assigned by database for ROUND record (corresponds to mission, cruise, cruise leg, etc.)
100
MISSIONID VARCHAR2 Mission Identifier typically assigned by PIFSC
100
REGION_NAME VARCHAR2 One of the five Pacific Island regions ESD surveys: Main Hawaiian islands, Northwestern Hawaiian islands, American Samoa, Marianas, and the Pacific Remote Island Areas.
100
ISLAND NVARCHAR2 Island or Atoll surveyed
100
SITE NVARCHAR2 The unique identifier/code for the site surveyed. Combines a 3-letter island code with a site number (usually 2-4 digits), separated by a hypen
100
LATITUDE NUMBER Site latitude in decimal degrees
100
LONGITUDE NUMBER Site longitude in decimal degrees
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. Shallow = 0-6m, Mid = 6-18m, Deep = 18-30m.
100
PERM_SITE NUMBER Permanent site flag, yes = -1
100
CLIMATE_STATION_YN NUMBER Climate station flag, yes = -1
100
MIN_DEPTH NUMBER Minimum depth (measured in feet), typically only recorded during 'Benthic' surveys (refer to SURVEY_TYPE)
100
MAX_DEPTH NUMBER Maximum depth (measured in feet), typically only recorded during 'Benthic' surveys (refer to SURVEY_TYPE)
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
100
SURVEY_TYPE TEXT Identifies the ESD team that conducted the survey, typically 'Fish' or 'Benthic' for stratified random surveys, or 'Oceanography' for climate surveys at permanent sites.

Attribute Details

ROUNDID

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

Unique Identifier auto-assigned by database for ROUND record (corresponds to mission, cruise, cruise leg, etc.)

MISSIONID

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

Mission Identifier typically assigned by PIFSC

REGION_NAME

CC ID: 370458
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 ESD surveys: Main Hawaiian islands, Northwestern Hawaiian islands, American Samoa, Marianas, and the Pacific Remote Island Areas.

ISLAND

CC ID: 370448
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: 370461
Seq. Order: 5
Data Storage Type: NVARCHAR2
Max Length: 150
Required: No
Primary Key: No
Status: Active
Description:

The unique identifier/code for the site surveyed. Combines a 3-letter island code with a site number (usually 2-4 digits), separated by a hypen

LATITUDE

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

Site latitude in decimal degrees

LONGITUDE

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

Site longitude in decimal degrees

REEF_ZONE

CC ID: 370457
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: 370445
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. Shallow = 0-6m, Mid = 6-18m, Deep = 18-30m.

PERM_SITE

CC ID: 370455
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, yes = -1

CLIMATE_STATION_YN

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

Climate station flag, yes = -1

MIN_DEPTH

CC ID: 370452
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), typically only recorded during 'Benthic' surveys (refer to SURVEY_TYPE)

MAX_DEPTH

CC ID: 370451
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), typically only recorded during 'Benthic' surveys (refer to SURVEY_TYPE)

DATE_

CC ID: 370444
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: 370447
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: 370454
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: 370459
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: 370456
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: 370441
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: 370463
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: 370442
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: 370464
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: 370462
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

TIER_3

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

GENERA_NAME

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

X_POS

CC ID: 370466
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: 370467
Seq. Order: 27
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Y position of the analyzed point

SURVEY_TYPE

CC ID: 780187
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Identifies the ESD team that conducted the survey, typically 'Fish' or 'Benthic' for stratified random surveys, or 'Oceanography' for climate surveys at permanent sites.

Catalog Details

Catalog Item ID: 36161
GUID: gov.noaa.nmfs.inport:36161
Metadata Record Created By: Troy T Kanemura
Metadata Record Created: 2016-12-30 17:29+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2020-08-17
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2020-08-17
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2021-08-17