View: V0_CORAL_OBS_A
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:45799 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Coral belt observations (2002 - 2007)
DescriptionCoral belt observations (2002 - 2007)
Entity Information
Entity Type
Data View
Data Attribute / Type | Description |
---|---|
ROUNDID
NUMBER |
Unique Identifier for MISSION |
MISSIONID
VARCHAR2 |
Mission Identifier |
REGION_NAME
VARCHAR2 |
The name of the region surveyed in the Pacific Islands region: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands. |
ISLAND
NVARCHAR2 |
Name of island or atoll surveyed in the Pacific Islands region (REGION_NAME). |
ISLANDCODE
NVARCHAR2 |
3-letter code for ISLAND. |
SITE
NVARCHAR2 |
The code for the site surveyed at the island or atoll (ISLAND). Combines a 3-letter island code (ISLANDCODE) with a 2-4 digit site number. |
LATITUDE
NUMBER |
Latitude in decimal degrees, WGS84, for the given SITE. |
LONGITUDE
NUMBER |
Longitude in decimal degrees, WGS84 for the given SITE. |
REEF_ZONE
NVARCHAR2 |
The zone for the given SITE (Forereef, Backreef, Protected Slope, Lagoon). |
DEPTH_BIN
NVARCHAR2 |
Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of transect(s) of a given SITE. Shallow: >0-6 m, Mid: >6-18 m, Deep: >18-30 m |
SITEVISITID
NUMBER |
Unique identifier created each time a SITE is surveyed on a DATE_. |
DATE_
DATE |
Local date the survey was conducted. |
OBS_YEAR
NUMBER |
4-digit year the survey was conducted (DATE_). |
DIVER
NVARCHAR2 |
Initials of diver conducting survey |
BELTTRANSECTRUN
NUMBER |
Unique identifier for TRANSECT |
METHODNAME
NVARCHAR2 |
References the coral belt survey method: method A. |
TRANSECT
NUMBER |
Transect number surveyed at a site. During the early, exploratory years, number of transects surveyd at a site varied between 1 and 4, depending on region and specific mission objectives. In the latter survey years typically 2, 25-m transects were deployed at each site. |
TRANWIDTH
NUMBER |
Transect width in meters. Varied between 1 m and 2 m depending on survey year, region, and specific mission objectives. In areas like the Northwestern Hawaiian Islands where coral colony density was low, a 2-m belt was implemented. |
TRANLENGTH
NUMBER |
Transect length in meters. Varied between 8 m and 75 m depending on survey year, region, weather, and specific mission objectives. In the latter survey years typically 2, 25-m transects were deployed at each site. |
TAXONCODE
NVARCHAR2 |
4-letter taxon code for TAXONNAME |
SIZECLASS
TEXT |
Colony size binned into 1 of 7 categories (0-5 cm; 5–10 cm; 10-20 cm; 20-40 cm; 40-80 cm; 80-160 cm; or 160 cm). |
COUNT
NUMBER |
Number of colonies of a specific taxon belonging to a specific size class |
TAXONNAME
NVARCHAR2 |
Scientific name of observed organism to the finest taxonomic resolution that divers can identify a colony to, either to species or genus level identification (see RANK). |
PHYLUM
VARCHAR2 |
Taxonomic classification: Phylum of observed organism (TAXONNAME). |
CLASS
NVARCHAR2 |
Taxonomic classification: Class of observed organism (TAXONNAME). |
S_ORDER
VARCHAR2 |
Taxonomic classification: Order of observed organism (TAXONNAME). |
FAMILY
VARCHAR2 |
Taxonomic classification: Family of observed organism (TAXONNAME). |
GENUS
NVARCHAR2 |
Taxonomic classification: Genus name of observed organism (TAXONNAME). |
SCIENTIFIC_NAME
VARCHAR2 |
Taxonomic classification: the true scientific name (genus and species) of the observed organism (TAXONNAME). If NULL, organism not identified to species taxonomic level (see RANK). |
RANK
VARCHAR2 |
Lowest defined rank in taxonomic hierarchy, from the World Registry of Marine Species (WoRMS) database (Genus or Species) |
APHIAID
VARCHAR2 |
Aphia ID from the World Registry of Marine Species (WoRMS) database. Null if organism not identified to species taxonomic level (see RANK). If value = 0, the species does not exist in WoRMS. |
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: | View: V0_CORAL_OBS_A |
---|---|
Short Name: | V0_CORAL_OBS_A |
Status: | Completed |
Abstract: |
Coral belt observations (2002 - 2007) |
Entity Information
Entity Type: | Data View |
---|---|
Active Version?: | Yes |
Schema Name: | GISDAT |
Description: |
Coral belt observations (2002 - 2007) |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
ROUNDID | NUMBER | Unique Identifier for MISSION | |
100
|
MISSIONID | VARCHAR2 | Mission Identifier | |
100
|
REGION_NAME | VARCHAR2 | The name of the region surveyed in the Pacific Islands region: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands. | |
100
|
ISLAND | NVARCHAR2 | Name of island or atoll surveyed in the Pacific Islands region (REGION_NAME). | |
100
|
ISLANDCODE | NVARCHAR2 | 3-letter code for ISLAND. | |
100
|
SITE | NVARCHAR2 | The code for the site surveyed at the island or atoll (ISLAND). Combines a 3-letter island code (ISLANDCODE) with a 2-4 digit 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 zone for the given SITE (Forereef, Backreef, Protected Slope, Lagoon). | |
100
|
DEPTH_BIN | NVARCHAR2 | Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of transect(s) of a given SITE. Shallow: >0-6 m, Mid: >6-18 m, Deep: >18-30 m | |
100
|
SITEVISITID | NUMBER | Unique identifier created each time a SITE is surveyed on a DATE_. | |
100
|
DATE_ | DATE | Local date the survey was conducted. | |
100
|
OBS_YEAR | NUMBER | 4-digit year the survey was conducted (DATE_). | |
100
|
DIVER | NVARCHAR2 | Initials of diver conducting survey | |
100
|
BELTTRANSECTRUN | NUMBER | Unique identifier for TRANSECT | |
100
|
METHODNAME | NVARCHAR2 | References the coral belt survey method: method A. | |
100
|
TRANSECT | NUMBER | Transect number surveyed at a site. During the early, exploratory years, number of transects surveyd at a site varied between 1 and 4, depending on region and specific mission objectives. In the latter survey years typically 2, 25-m transects were deployed at each site. | |
100
|
TRANWIDTH | NUMBER | Transect width in meters. Varied between 1 m and 2 m depending on survey year, region, and specific mission objectives. In areas like the Northwestern Hawaiian Islands where coral colony density was low, a 2-m belt was implemented. | |
100
|
TRANLENGTH | NUMBER | Transect length in meters. Varied between 8 m and 75 m depending on survey year, region, weather, and specific mission objectives. In the latter survey years typically 2, 25-m transects were deployed at each site. | |
100
|
TAXONCODE | NVARCHAR2 | 4-letter taxon code for TAXONNAME | |
100
|
SIZECLASS | TEXT | Colony size binned into 1 of 7 categories (0-5 cm; 5–10 cm; 10-20 cm; 20-40 cm; 40-80 cm; 80-160 cm; or 160 cm). | |
100
|
COUNT | NUMBER | Number of colonies of a specific taxon belonging to a specific size class | |
100
|
TAXONNAME | NVARCHAR2 | Scientific name of observed organism to the finest taxonomic resolution that divers can identify a colony to, either to species or genus level identification (see RANK). | |
100
|
PHYLUM | VARCHAR2 | Taxonomic classification: Phylum of observed organism (TAXONNAME). | |
100
|
CLASS | NVARCHAR2 | Taxonomic classification: Class of observed organism (TAXONNAME). | |
100
|
S_ORDER | VARCHAR2 | Taxonomic classification: Order of observed organism (TAXONNAME). | |
100
|
FAMILY | VARCHAR2 | Taxonomic classification: Family of observed organism (TAXONNAME). | |
100
|
GENUS | NVARCHAR2 | Taxonomic classification: Genus name of observed organism (TAXONNAME). | |
100
|
SCIENTIFIC_NAME | VARCHAR2 | Taxonomic classification: the true scientific name (genus and species) of the observed organism (TAXONNAME). If NULL, organism not identified to species taxonomic level (see RANK). | |
100
|
RANK | VARCHAR2 | Lowest defined rank in taxonomic hierarchy, from the World Registry of Marine Species (WoRMS) database (Genus or Species) | |
100
|
APHIAID | VARCHAR2 | Aphia ID from the World Registry of Marine Species (WoRMS) database. Null if organism not identified to species taxonomic level (see RANK). If value = 0, the species does not exist in WoRMS. |
Attribute Details
ROUNDID
Seq. Order: | 1 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 28 |
Scale: | 0 |
Status: | Active |
Description: |
Unique Identifier for MISSION |
MISSIONID
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Mission Identifier |
REGION_NAME
Seq. Order: | 4 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The name of the region surveyed in the Pacific Islands region: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands. |
ISLAND
Seq. Order: | 5 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Name of island or atoll surveyed in the Pacific Islands region (REGION_NAME). |
ISLANDCODE
Seq. Order: | 6 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 15 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
3-letter code for ISLAND. |
SITE
Seq. Order: | 7 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
The code for the site surveyed at the island or atoll (ISLAND). Combines a 3-letter island code (ISLANDCODE) with a 2-4 digit site number. |
LATITUDE
Seq. Order: | 8 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Latitude in decimal degrees, WGS84, for the given SITE. |
LONGITUDE
Seq. Order: | 9 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Longitude in decimal degrees, WGS84 for the given SITE. |
REEF_ZONE
Seq. Order: | 11 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The zone for the given SITE (Forereef, Backreef, Protected Slope, Lagoon). |
DEPTH_BIN
Seq. Order: | 12 |
---|---|
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 transect(s) of a given SITE. Shallow: >0-6 m, Mid: >6-18 m, Deep: >18-30 m |
SITEVISITID
Seq. Order: | 14 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Unique identifier created each time a SITE is surveyed on a DATE_. |
DATE_
Seq. Order: | 15 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Local date the survey was conducted. |
OBS_YEAR
Seq. Order: | 18 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
4-digit year the survey was conducted (DATE_). |
DIVER
Seq. Order: | 23 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Initials of diver conducting survey |
BELTTRANSECTRUN
Seq. Order: | 24 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 38 |
Scale: | 0 |
Status: | Active |
Description: |
Unique identifier for TRANSECT |
METHODNAME
Seq. Order: | 25 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
References the coral belt survey method: method A. |
TRANSECT
Seq. Order: | 26 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 38 |
Scale: | 0 |
Status: | Active |
Description: |
Transect number surveyed at a site. During the early, exploratory years, number of transects surveyd at a site varied between 1 and 4, depending on region and specific mission objectives. In the latter survey years typically 2, 25-m transects were deployed at each site. |
TRANWIDTH
Seq. Order: | 28 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Scale: | 8 |
Status: | Active |
Description: |
Transect width in meters. Varied between 1 m and 2 m depending on survey year, region, and specific mission objectives. In areas like the Northwestern Hawaiian Islands where coral colony density was low, a 2-m belt was implemented. |
TRANLENGTH
Seq. Order: | 29 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 28 |
Scale: | 8 |
Status: | Active |
Description: |
Transect length in meters. Varied between 8 m and 75 m depending on survey year, region, weather, and specific mission objectives. In the latter survey years typically 2, 25-m transects were deployed at each site. |
TAXONCODE
Seq. Order: | 32 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
4-letter taxon code for TAXONNAME |
SIZECLASS
Seq. Order: | 34 |
---|---|
Data Storage Type: | TEXT |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Colony size binned into 1 of 7 categories (0-5 cm; 5–10 cm; 10-20 cm; 20-40 cm; 40-80 cm; 80-160 cm; or 160 cm). |
COUNT
Seq. Order: | 35 |
---|---|
Data Storage Type: | NUMBER |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of colonies of a specific taxon belonging to a specific size class |
TAXONNAME
Seq. Order: | 47 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 765 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Scientific name of observed organism to the finest taxonomic resolution that divers can identify a colony to, either to species or genus level identification (see RANK). |
PHYLUM
Seq. Order: | 48 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 255 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Taxonomic classification: Phylum of observed organism (TAXONNAME). |
CLASS
Seq. Order: | 49 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 60 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Taxonomic classification: Class of observed organism (TAXONNAME). |
S_ORDER
Seq. Order: | 50 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 255 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Taxonomic classification: Order of observed organism (TAXONNAME). |
FAMILY
Seq. Order: | 51 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 255 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Taxonomic classification: Family of observed organism (TAXONNAME). |
GENUS
Seq. Order: | 53 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 300 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Taxonomic classification: Genus name of observed organism (TAXONNAME). |
SCIENTIFIC_NAME
Seq. Order: | 54 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 255 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Taxonomic classification: the true scientific name (genus and species) of the observed organism (TAXONNAME). If NULL, organism not identified to species taxonomic level (see RANK). |
RANK
Seq. Order: | 55 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Lowest defined rank in taxonomic hierarchy, from the World Registry of Marine Species (WoRMS) database (Genus or Species) |
APHIAID
Seq. Order: | 56 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Aphia ID from the World Registry of Marine Species (WoRMS) database. Null if organism not identified to species taxonomic level (see RANK). If value = 0, the species does not exist in WoRMS. |
Catalog Details
Catalog Item ID: | 45799 |
---|---|
GUID: | gov.noaa.nmfs.inport:45799 |
Metadata Record Created By: | Troy T Kanemura |
Metadata Record Created: | 2017-04-19 15:28+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2019-05-31 |
Owner Org: | PIFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2019-05-31 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2020-05-31 |