Item Identification

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 Information

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

Data Attributes

Attribute Summary

Rubric Score Primary Key? 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 Details

Catalog Item ID: 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: 2019-06-04 13:14+0000
Metadata Record Published: 2017-03-30
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2018-03-31