Slide Menu
InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 5.2.3. Downtime Schedule Tuesday, November 29, 2022 12:00pm - 1:30pm Eastern / 10:00am - 11:30pm Pacific / 7:00am - 8:30pm Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: https://www.fisheries.noaa.gov/inportserve/waf What's...
View All
Search Help Show/Hide Menu

Item Identification

Title: View: V0_CORAL_OBS_C
Short Name: V0_CORAL_OBS_C
Status: Completed
Abstract:

Coral belt observations (adult) 2013

Entity Information

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

Coral belt observations (adult) 2013

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
APHIAID VARCHAR2 Aphia ID is the unique identifier of WoRMS (World Register of Marine Species, http://www.marinespecies.org/). Typcially populated only if observation is identified to SPECIES (see RANK).
100
BELTTRANSECTRUN NUMBER Primary key for CORAL_BELT_TRANSECTRUN
100
CLASS NVARCHAR2 Class taxonomic rank
100
COLONYID NUMBER Colony identifier
100
COLONYLENGTH NUMBER Colony length (cm)
100
COND NVARCHAR2 Coral disease code of the observed coral colony
100
COND_DESCRIPTION NVARCHAR2 Coral disease description of the observed coral colony
100
DATE_ DATE Date the survey was conducted
100
DIVER NVARCHAR2 Initials of diver conducting survey
100
EXCLUDE_FLAG Unknown Flag to indicate whether site should be excluded from analysis (-1 = exclude). Usually indicates that surveys not considered part of RAMP/NCRMP, and are therefore typically excluded from RAMP/NCRMP-specific analyses conducted by the NOAA Coral Reef Ecosystem Program.
100
EXTENT NUMBER Disease extent (1-100)
100
FAMILY VARCHAR2 Family taxonomic rank
100
GENUS NVARCHAR2 Genus Taxonomic Rank
100
ISLAND NVARCHAR2 Island or atoll surveyed
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
MAXDEPTH NUMBER Maximum depth of the transect (ft). Not consistently recorded by divers.
100
METHODNAME NVARCHAR2 References the coral belt survey method
100
MINDEPTH NUMBER Minimum depth of the transect (ft). Not consistently recorded by divers.
100
OBS_YEAR NUMBER Observation year
100
OLDDEAD NUMBER Percentage of old dead coral
100
PHYLUM VARCHAR2 Phylum taxonomic rank
100
RANK VARCHAR2 Rank from WoRMS
100
RECENTDEAD NUMBER Percentage of recently dead coral
100
REEF_ZONE NVARCHAR2 The reef zone for the given site (forereef, backreef or lagoon)
100
REGION_NAME VARCHAR2 One of the five Pacific Island regions CREP surveys
100
SCIENTIFIC_NAME VARCHAR2 Scientific name taxonomic rank. Populated only if observation is identified to SPECIES. Refer to RANK for the taxonomic level to which the observation has been identified. Refer to TAXONNAME for the name of the organism to the lowest level it was identified (family, genus, species, etc.). Some corals are difficult to identify to species in the field, so it is not uncommon for the observation to be identified to genus, and therefore for this field to be blank.
100
SEGMENT NVARCHAR2 Segment number
100
SEVERITY NUMBER Disease severity (1-5)
100
SITE NVARCHAR2 The 5- to 6-character code for the site surveyed. Combines a 3-letter island code with a site number
100
SITEVISITID NUMBER Unique Identifier for SITE_VISIT record
100
SPECIES Unknown Organism observed (4-letter code).
100
S_ORDER VARCHAR2 Order taxonomic rank
100
TAXONNAME NVARCHAR2 Taxonomic name, based on lowest taxon level identified.
100
TRANLENGTH NUMBER Transect length (m)
100
TRANSECT NUMBER Transect number
100
TRANWIDTH NUMBER Transect width (m)
100
COLONYWIDTH NUMBER Colony width (cm)
100
COLONYHEIGHT NUMBER colony height (cm)
100
MISSIONID TEXT Unique identifier for field mission/cruise.

Attribute Details

APHIAID

CC ID: 710351
Seq. Order: 1
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Aphia ID is the unique identifier of WoRMS (World Register of Marine Species, http://www.marinespecies.org/). Typcially populated only if observation is identified to SPECIES (see RANK).

BELTTRANSECTRUN

CC ID: 710352
Seq. Order: 2
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Primary key for CORAL_BELT_TRANSECTRUN

Allowed Values: No domain defined.

CLASS

CC ID: 710354
Seq. Order: 4
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Class taxonomic rank

COLONYID

CC ID: 710355
Seq. Order: 5
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Colony identifier

Allowed Values: No domain defined.

COLONYLENGTH

CC ID: 710356
Seq. Order: 6
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Colony length (cm)

Allowed Values: No domain defined.

COND

CC ID: 710358
Seq. Order: 8
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Coral disease code of the observed coral colony

COND_DESCRIPTION

CC ID: 710359
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Coral disease description of the observed coral colony

DATE_

CC ID: 710360
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

Date the survey was conducted

Allowed Values: No domain defined.

DIVER

CC ID: 710364
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Initials of diver conducting survey

Allowed Values: No domain defined.

EXCLUDE_FLAG

CC ID: 710365
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Flag to indicate whether site should be excluded from analysis (-1 = exclude). Usually indicates that surveys not considered part of RAMP/NCRMP, and are therefore typically excluded from RAMP/NCRMP-specific analyses conducted by the NOAA Coral Reef Ecosystem Program.

Allowed Values: No domain defined.

EXTENT

CC ID: 710366
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Disease extent (1-100)

FAMILY

CC ID: 710367
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Family taxonomic rank

GENUS

CC ID: 710368
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Genus Taxonomic Rank

ISLAND

CC ID: 710372
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Island or atoll surveyed

Allowed Values: No domain defined.

LATITUDE

CC ID: 710374
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Latitude in decimal degrees, WGS84, for the given site

Allowed Values: No domain defined.

LONGITUDE

CC ID: 710376
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Longitude in decimal degrees, WGS84 for the given site

Allowed Values: No domain defined.

MAXDEPTH

CC ID: 710377
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Maximum depth of the transect (ft). Not consistently recorded by divers.

Allowed Values: No domain defined.

METHODNAME

CC ID: 710378
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

References the coral belt survey method

Allowed Values: No domain defined.

MINDEPTH

CC ID: 710379
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Minimum depth of the transect (ft). Not consistently recorded by divers.

Allowed Values: No domain defined.

OBS_YEAR

CC ID: 710385
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Observation year

Allowed Values: No domain defined.

OLDDEAD

CC ID: 710386
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Percentage of old dead coral

Allowed Values: No domain defined.

PHYLUM

CC ID: 710389
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Phylum taxonomic rank

RANK

CC ID: 710391
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Rank from WoRMS

RECENTDEAD

CC ID: 710392
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Percentage of recently dead coral

Allowed Values: No domain defined.

REEF_ZONE

CC ID: 710398
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

The reef zone for the given site (forereef, backreef or lagoon)

Allowed Values: No domain defined.

REGION_NAME

CC ID: 710401
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

One of the five Pacific Island regions CREP surveys

Allowed Values: No domain defined.

SCIENTIFIC_NAME

CC ID: 710403
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Scientific name taxonomic rank. Populated only if observation is identified to SPECIES. Refer to RANK for the taxonomic level to which the observation has been identified. Refer to TAXONNAME for the name of the organism to the lowest level it was identified (family, genus, species, etc.). Some corals are difficult to identify to species in the field, so it is not uncommon for the observation to be identified to genus, and therefore for this field to be blank.

SEGMENT

CC ID: 710405
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Segment number

Allowed Values: No domain defined.

SEVERITY

CC ID: 710406
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Disease severity (1-5)

SITE

CC ID: 710408
Data Storage Type: NVARCHAR2
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

Allowed Values: No domain defined.

SITEVISITID

CC ID: 710409
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Unique Identifier for SITE_VISIT record

Allowed Values: No domain defined.

SPECIES

CC ID: 710412
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Organism observed (4-letter code).

Allowed Values: No domain defined.

S_ORDER

CC ID: 710414
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Order taxonomic rank

TAXONNAME

CC ID: 710415
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Taxonomic name, based on lowest taxon level identified.

TRANLENGTH

CC ID: 710416
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Transect length (m)

Allowed Values: No domain defined.

TRANSECT

CC ID: 710417
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Transect number

Allowed Values: No domain defined.

TRANWIDTH

CC ID: 710418
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Transect width (m)

Allowed Values: No domain defined.

COLONYWIDTH

CC ID: 710503
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Colony width (cm)

COLONYHEIGHT

CC ID: 710504
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

colony height (cm)

MISSIONID

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

Unique identifier for field mission/cruise.

Catalog Details

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