V0_CORAL_OBS_D
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:51110 | Updated: August 9, 2022 | Published / External
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
CC ID: 710512
| 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
CC ID: 710513
| 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: 710514
| Data Storage Type: | NVARCHAR2 |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Class taxonomic rank |
COLONYID
CC ID: 710516
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Colony identifier |
| Allowed Values: | No domain defined. |
COND
CC ID: 710519
| Data Storage Type: | NVARCHAR2 |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Coral disease code of the observed coral colony |
COND_DESCRIPTION
CC ID: 710520
| Data Storage Type: | NVARCHAR2 |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Coral disease description of the observed coral colony |
DATE_
CC ID: 710521
| 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: 710523
| 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: 710524
| 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
CC ID: 710526
| Data Storage Type: | VARCHAR2 |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Family taxonomic rank |
GENUS
CC ID: 710527
| Data Storage Type: | NVARCHAR2 |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Genus Taxonomic Rank |
ISLAND
CC ID: 710528
| Data Storage Type: | NVARCHAR2 |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Island or atoll surveyed |
| Allowed Values: | No domain defined. |
LATITUDE
CC ID: 710530
| 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: 710531
| 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: 710532
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Maximum depth of the transect (ft) |
| Allowed Values: | No domain defined. |
METHODNAME
CC ID: 710533
| 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: 710534
| 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
CC ID: 710535
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Observation year |
| Allowed Values: | No domain defined. |
PHYLUM
CC ID: 710537
| Data Storage Type: | VARCHAR2 |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Phylum taxonomic rank |
RANK
CC ID: 710538
| Data Storage Type: | VARCHAR2 |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Rank from WoRMS (World Register of Marine Species). |
REEF_ZONE
CC ID: 710540
| 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: 710542
| 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: 710543
| 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
CC ID: 710545
| Data Storage Type: | NVARCHAR2 |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Segment number |
| Allowed Values: | No domain defined. |
SITE
CC ID: 710547
| 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: 710548
| 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: 710549
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Species observed |
| Allowed Values: | No domain defined. |
S_ORDER
CC ID: 710550
| Data Storage Type: | VARCHAR2 |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Order taxonomic rank |
TAXONNAME
CC ID: 710551
| Data Storage Type: | NVARCHAR2 |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Taxonomic name to lowest level identified |
TRANLENGTH
CC ID: 710552
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Transect width (m) |
| Allowed Values: | No domain defined. |
TRANSECT
CC ID: 710553
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Transect number |
| Allowed Values: | No domain defined. |
TRANWIDTH
CC ID: 710554
| 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 |