View: V0_CORAL_OBS_F
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:30777 | Updated: August 9, 2022 | Published / External
Item Identification
| Title: | View: V0_CORAL_OBS_F |
|---|---|
| Short Name: | V0_CORAL_OBS_F |
| Status: | Completed |
| Abstract: |
Coral belt observations (juvenile) |
Entity Information
| Entity Type: | Data View |
|---|---|
| Description: |
Coral belt observations (juvenile) |
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
REGION | Unknown | 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 | Unknown | One of the five Pacific Island regions CRED surveys | |
|
100
|
ISLAND | Unknown | Island or Atoll surveyed | |
|
100
|
ISLANDCODE | Unknown | 3-letter island code | |
|
100
|
SECTOR | Unknown | 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 | Unknown | The 5- to 6-character code for the site surveyed. Combines a 3-letter island code with a site number. | |
|
100
|
LATITUDE | Unknown | Latitude in decimal degrees, WGS84, for the given site | |
|
100
|
LONGITUDE | Unknown | Longitude in decimal degrees, WGS84 for the given site | |
|
100
|
REEF_ZONE_CODE | Unknown | 3-letter reef zone code | |
|
100
|
REEF_ZONE | Unknown | The reef zone for the given site (Forereef, Backreef or Lagoon) | |
|
100
|
DEPTH_BIN | Unknown | Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of replicates at this site | |
|
100
|
DEPTH_CODE | Unknown | Depth zone code | |
|
100
|
EXCLUDE_FLAG | Unknown | Flag to indicate whether site should be excluded from analysis | |
|
100
|
SITEVISITID | Unknown | Unique Identifier for SITE_VISIT record | |
|
100
|
DATE_ | Unknown | Date the survey was conducted | |
|
100
|
OBS_DAY | Unknown | Observation Day | |
|
100
|
OBS_MONTH | Unknown | Observation Month | |
|
100
|
OBS_YEAR | Unknown | Observation Year | |
|
100
|
HABITAT_CODE | Unknown | Habitat code | |
|
100
|
HABITAT_TYPE | Unknown | Habitat type | |
|
100
|
COMMENTS | Unknown | General observation comments | |
|
100
|
DIVER | Unknown | Initials of diver conducting survey | |
|
100
|
BELTTRANSECTRUN | Unknown | Primary key for CORAL_BELT_TRANSECTRUN | |
|
100
|
METHODNAME | Unknown | References the coral belt survey method | |
|
100
|
TRANSECT | Unknown | Transect Number | |
|
100
|
SEGMENT | Unknown | Segment Number | |
|
100
|
TRANWIDTH | Unknown | Transect Length (m) | |
|
100
|
TRANLENGTH | Unknown | Transect Width (m) | |
|
100
|
MINDEPTH | Unknown | Minimum Depth of the transect (in meters) | |
|
100
|
MAXDEPTH | Unknown | Minimum Depth of the transect (in meters) | |
|
100
|
COLONYID | Unknown | Colony Identifier | |
|
100
|
SPECIES | Unknown | Species observed | |
|
100
|
MORPH_CODE | Unknown | 4-letter morphology code | |
|
100
|
MORPHOLOGY | Unknown | Definition of morphology code | |
|
100
|
COLONYLENGTH | Unknown | Colony Length (cm) | |
|
100
|
COLONYWIDTH | Unknown | Colony Width (cm) | |
|
100
|
TAXONNAME | Unknown | Taxonomic Name | |
|
100
|
PHYLUM | Unknown | Phylum Taxonomic Rank | |
|
100
|
CLASS | Unknown | Class Taxonomic Rank | |
|
100
|
S_ORDER | Unknown | Order Taxonomic Rank | |
|
100
|
FAMILY | Unknown | Family Taxonomic Rank | |
|
100
|
GENUS_CODE | Unknown | 4-letter genus code | |
|
100
|
GENUS | Unknown | Genus Taxonomic Rank | |
|
100
|
SCIENTIFIC_NAME | Unknown | Scientific Name Taxonomic Rank | |
|
100
|
RANK | Unknown | Rank from WoRMS | |
|
100
|
APHIAID | Unknown | Aphia ID from WoRMS | |
|
100
|
CORAL_CORISID | Unknown | CoRIS ID for coral metadata record (Added June 2011) |
Attribute Details
REGION
CC ID: 286613
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| 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 |
| Allowed Values: | No domain defined. |
REGION_NAME
CC ID: 286614
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
One of the five Pacific Island regions CRED surveys |
| Allowed Values: | No domain defined. |
ISLAND
CC ID: 286615
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Island or Atoll surveyed |
| Allowed Values: | No domain defined. |
ISLANDCODE
CC ID: 286616
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
3-letter island code |
| Allowed Values: | No domain defined. |
SECTOR
CC ID: 286617
| Data Storage Type: | Unknown |
|---|---|
| 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) |
| Allowed Values: | No domain defined. |
SITE
CC ID: 286618
| Data Storage Type: | Unknown |
|---|---|
| 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. |
LATITUDE
CC ID: 286619
| Data Storage Type: | Unknown |
|---|---|
| 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: 286620
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Longitude in decimal degrees, WGS84 for the given site |
| Allowed Values: | No domain defined. |
REEF_ZONE_CODE
CC ID: 286621
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
3-letter reef zone code |
| Allowed Values: | No domain defined. |
REEF_ZONE
CC ID: 286622
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
The reef zone for the given site (Forereef, Backreef or Lagoon) |
| Allowed Values: | No domain defined. |
DEPTH_BIN
CC ID: 286623
| Data Storage Type: | Unknown |
|---|---|
| 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 |
| Allowed Values: | No domain defined. |
DEPTH_CODE
CC ID: 286624
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Depth zone code |
| Allowed Values: | No domain defined. |
EXCLUDE_FLAG
CC ID: 286625
| 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. |
SITEVISITID
CC ID: 286626
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Unique Identifier for SITE_VISIT record |
| Allowed Values: | No domain defined. |
DATE_
CC ID: 286627
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Date the survey was conducted |
| Allowed Values: | No domain defined. |
OBS_DAY
CC ID: 286628
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Observation Day |
| Allowed Values: | No domain defined. |
OBS_MONTH
CC ID: 286629
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Observation Month |
| Allowed Values: | No domain defined. |
OBS_YEAR
CC ID: 286630
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Observation Year |
| Allowed Values: | No domain defined. |
HABITAT_CODE
CC ID: 286631
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Habitat code |
| Allowed Values: | No domain defined. |
HABITAT_TYPE
CC ID: 286632
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Habitat type |
| Allowed Values: | No domain defined. |
COMMENTS
CC ID: 286633
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
General observation comments |
| Allowed Values: | No domain defined. |
DIVER
CC ID: 286634
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Initials of diver conducting survey |
| Allowed Values: | No domain defined. |
BELTTRANSECTRUN
CC ID: 286635
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Primary key for CORAL_BELT_TRANSECTRUN |
| Allowed Values: | No domain defined. |
METHODNAME
CC ID: 286636
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
References the coral belt survey method |
| Allowed Values: | No domain defined. |
TRANSECT
CC ID: 286637
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Transect Number |
| Allowed Values: | No domain defined. |
SEGMENT
CC ID: 286638
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Segment Number |
| Allowed Values: | No domain defined. |
TRANWIDTH
CC ID: 286639
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Transect Length (m) |
| Allowed Values: | No domain defined. |
TRANLENGTH
CC ID: 286640
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Transect Width (m) |
| Allowed Values: | No domain defined. |
MINDEPTH
CC ID: 286641
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Minimum Depth of the transect (in meters) |
| Allowed Values: | No domain defined. |
MAXDEPTH
CC ID: 286642
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Minimum Depth of the transect (in meters) |
| Allowed Values: | No domain defined. |
COLONYID
CC ID: 286643
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Colony Identifier |
| Allowed Values: | No domain defined. |
SPECIES
CC ID: 286644
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Species observed |
| Allowed Values: | No domain defined. |
MORPH_CODE
CC ID: 286645
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
4-letter morphology code |
| Allowed Values: | No domain defined. |
MORPHOLOGY
CC ID: 286646
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Definition of morphology code |
| Allowed Values: | No domain defined. |
COLONYLENGTH
CC ID: 286647
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Colony Length (cm) |
| Allowed Values: | No domain defined. |
COLONYWIDTH
CC ID: 286648
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Colony Width (cm) |
| Allowed Values: | No domain defined. |
TAXONNAME
CC ID: 286649
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Taxonomic Name |
| Allowed Values: | No domain defined. |
PHYLUM
CC ID: 286650
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Phylum Taxonomic Rank |
| Allowed Values: | No domain defined. |
CLASS
CC ID: 286651
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Class Taxonomic Rank |
| Allowed Values: | No domain defined. |
S_ORDER
CC ID: 286652
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Order Taxonomic Rank |
| Allowed Values: | No domain defined. |
FAMILY
CC ID: 286653
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Family Taxonomic Rank |
| Allowed Values: | No domain defined. |
GENUS_CODE
CC ID: 286654
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
4-letter genus code |
| Allowed Values: | No domain defined. |
GENUS
CC ID: 286655
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Genus Taxonomic Rank |
| Allowed Values: | No domain defined. |
SCIENTIFIC_NAME
CC ID: 286656
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Scientific Name Taxonomic Rank |
| Allowed Values: | No domain defined. |
RANK
CC ID: 286657
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Rank from WoRMS |
| Allowed Values: | No domain defined. |
APHIAID
CC ID: 286658
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Aphia ID from WoRMS |
| Allowed Values: | No domain defined. |
CORAL_CORISID
CC ID: 286659
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
CoRIS ID for coral metadata record (Added June 2011) |
| Allowed Values: | No domain defined. |
Catalog Details
| Catalog Item ID: | 30777 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:30777 |
| Metadata Record Created By: | Annette M DesRochers |
| Metadata Record Created: | 2016-02-16 20:10+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 |