V0_CORAL_OBS_D
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:51110 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Coral belt observations (v D) 2012
DescriptionCoral belt observations (v D) 2012
Entity Information
Entity Type
Data View
Data Attribute / Type | Description |
---|---|
APHIAID
VARCHAR2 |
Aphia ID from WoRMS. Only populated if organism identified to species (see RANK). |
BELTTRANSECTRUN
NUMBER |
Primary key for CORAL_BELT_TRANSECTRUN |
CLASS
NVARCHAR2 |
Class taxonomic rank |
COLONYID
NUMBER |
Colony identifier |
COND
NVARCHAR2 |
Coral disease code of the observed coral colony |
COND_DESCRIPTION
NVARCHAR2 |
Coral disease description of the observed coral colony |
DATE_
DATE |
Date the survey was conducted |
DIVER
NVARCHAR2 |
Initials of diver conducting survey |
EXCLUDE_FLAG
Unknown |
Flag to indicate whether site should be excluded from analysis |
FAMILY
VARCHAR2 |
Family taxonomic rank |
GENUS
NVARCHAR2 |
Genus Taxonomic Rank |
ISLAND
NVARCHAR2 |
Island or atoll surveyed |
LATITUDE
NUMBER |
Latitude in decimal degrees, WGS84, for the given site |
LONGITUDE
NUMBER |
Longitude in decimal degrees, WGS84 for the given site |
MAXDEPTH
NUMBER |
Maximum depth of the transect (ft) |
METHODNAME
NVARCHAR2 |
References the coral belt survey method |
MINDEPTH
NUMBER |
Minimum depth of the transect (ft) |
OBS_YEAR
NUMBER |
Observation year |
PHYLUM
VARCHAR2 |
Phylum taxonomic rank |
RANK
VARCHAR2 |
Rank from WoRMS (World Register of Marine Species). |
REEF_ZONE
NVARCHAR2 |
The reef zone for the given site (forereef, backreef or lagoon) |
REGION_NAME
VARCHAR2 |
One of the five Pacific Island regions CREP surveys |
SCIENTIFIC_NAME
VARCHAR2 |
Species Taxonomic Rank. Only populated if organism identified to species (see RANK). |
SEGMENT
NVARCHAR2 |
Segment number |
SITE
NVARCHAR2 |
The 5- to 6-character code for the site surveyed. Combines a 3-letter island code with a site number |
SITEVISITID
NUMBER |
Unique Identifier for SITE_VISIT record |
SPECIES
Unknown |
Species observed |
S_ORDER
VARCHAR2 |
Order taxonomic rank |
TAXONNAME
NVARCHAR2 |
Taxonomic name to lowest level identified |
TRANLENGTH
NUMBER |
Transect width (m) |
TRANSECT
NUMBER |
Transect number |
TRANWIDTH
NUMBER |
Transect length (m) |
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: | V0_CORAL_OBS_D |
---|---|
Status: | Completed |
Abstract: |
Coral belt observations (v D) 2012 |
Entity Information
Entity Type: | Data View |
---|---|
Active Version?: | Yes |
Schema Name: | GISDAT |
Description: |
Coral belt observations (v D) 2012 |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
APHIAID | VARCHAR2 | Aphia ID from WoRMS. Only populated if organism 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
|
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 | |
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) | |
100
|
METHODNAME | NVARCHAR2 | References the coral belt survey method | |
100
|
MINDEPTH | NUMBER | Minimum depth of the transect (ft) | |
100
|
OBS_YEAR | NUMBER | Observation year | |
100
|
PHYLUM | VARCHAR2 | Phylum taxonomic rank | |
100
|
RANK | VARCHAR2 | Rank from WoRMS (World Register of Marine Species). | |
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 | Species Taxonomic Rank. Only populated if organism identified to species (see RANK). | |
100
|
SEGMENT | NVARCHAR2 | Segment number | |
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 | Species observed | |
100
|
S_ORDER | VARCHAR2 | Order taxonomic rank | |
100
|
TAXONNAME | NVARCHAR2 | Taxonomic name to lowest level identified | |
100
|
TRANLENGTH | NUMBER | Transect width (m) | |
100
|
TRANSECT | NUMBER | Transect number | |
100
|
TRANWIDTH | NUMBER | Transect length (m) |
Attribute Details
APHIAID
Data Storage Type: | VARCHAR2 |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Aphia ID from WoRMS. Only populated if organism identified to species (see RANK). |
BELTTRANSECTRUN
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Primary key for CORAL_BELT_TRANSECTRUN |
Allowed Values: | No domain defined. |
CLASS
Data Storage Type: | NVARCHAR2 |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Class taxonomic rank |
COLONYID
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Colony identifier |
Allowed Values: | No domain defined. |
COND
Data Storage Type: | NVARCHAR2 |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Coral disease code of the observed coral colony |
COND_DESCRIPTION
Data Storage Type: | NVARCHAR2 |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Coral disease description of the observed coral colony |
DATE_
Data Storage Type: | DATE |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date the survey was conducted |
Allowed Values: | No domain defined. |
DIVER
Data Storage Type: | NVARCHAR2 |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Initials of diver conducting survey |
Allowed Values: | No domain defined. |
EXCLUDE_FLAG
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Flag to indicate whether site should be excluded from analysis |
Allowed Values: | No domain defined. |
FAMILY
Data Storage Type: | VARCHAR2 |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Family taxonomic rank |
GENUS
Data Storage Type: | NVARCHAR2 |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Genus Taxonomic Rank |
ISLAND
Data Storage Type: | NVARCHAR2 |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Island or atoll surveyed |
Allowed Values: | No domain defined. |
LATITUDE
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
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
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Maximum depth of the transect (ft) |
Allowed Values: | No domain defined. |
METHODNAME
Data Storage Type: | NVARCHAR2 |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
References the coral belt survey method |
Allowed Values: | No domain defined. |
MINDEPTH
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Minimum depth of the transect (ft) |
Allowed Values: | No domain defined. |
OBS_YEAR
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Observation year |
Allowed Values: | No domain defined. |
PHYLUM
Data Storage Type: | VARCHAR2 |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Phylum taxonomic rank |
RANK
Data Storage Type: | VARCHAR2 |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Rank from WoRMS (World Register of Marine Species). |
REEF_ZONE
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
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
Data Storage Type: | VARCHAR2 |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Species Taxonomic Rank. Only populated if organism identified to species (see RANK). |
SEGMENT
Data Storage Type: | NVARCHAR2 |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Segment number |
Allowed Values: | No domain defined. |
SITE
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
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Unique Identifier for SITE_VISIT record |
Allowed Values: | No domain defined. |
SPECIES
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Species observed |
Allowed Values: | No domain defined. |
S_ORDER
Data Storage Type: | VARCHAR2 |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Order taxonomic rank |
TAXONNAME
Data Storage Type: | NVARCHAR2 |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Taxonomic name to lowest level identified |
TRANLENGTH
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Transect width (m) |
Allowed Values: | No domain defined. |
TRANSECT
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Transect number |
Allowed Values: | No domain defined. |
TRANWIDTH
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Transect length (m) |
Allowed Values: | No domain defined. |
Catalog Details
Catalog Item ID: | 51110 |
---|---|
GUID: | gov.noaa.nmfs.inport:51110 |
Metadata Record Created By: | Annette M DesRochers |
Metadata Record Created: | 2018-01-08 20:21+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2020-01-13 |
Owner Org: | PIFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2020-01-13 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2021-01-13 |