View: V0_CORAL_OBS_C
Pacific Islands Fisheries Science Center
Entity
(ENT)
| ID: 51109
| Published / External
Created: 2018-01-08
|
Last Modified: 2022-08-09
Parent: Benthic Surveys in Faga'alu, American Samoa: comprehensive assessment of coral demography (adult and juvenile corals) from belt transect surveys in 2013, 2015, and 2020
Data Set (DS) | ID: 25369
Data Set (DS) | ID: 25369
ID: 51109
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
| * » Title | View: V0_CORAL_OBS_C |
|---|---|
| Short Name | V0_CORAL_OBS_C |
| * Status | Completed |
| Creation Date | |
| Revision Date | |
| • Publication Date | |
| * » Abstract |
Coral belt observations (adult) 2013 |
| * Purpose | |
| Notes | |
| Other Citation Details | |
| • Supplemental Information | |
| DOI (Digital Object Identifier) | |
| DOI Registration Authority | |
| DOI Issue Date |
Keywords
Theme Keywords
| Thesaurus | Keyword |
|---|---|
Temporal Keywords
| Thesaurus | Keyword |
|---|---|
* Spatial Keywords
| Thesaurus | Keyword |
|---|---|
Stratum Keywords
| Thesaurus | Keyword |
|---|---|
Instrument Keywords
| Thesaurus | Keyword |
|---|---|
Platform Keywords
| Thesaurus | Keyword |
|---|---|
Physical Location
| • » Organization | |
|---|---|
| • » City | |
| • » State/Province | |
| • Country | |
| • » Location Description |
Entity Information
| Entity Type | Data View |
|---|---|
| Active Version? | Y |
| Alias | |
| Schema Name | GISDAT |
| » Description |
Coral belt observations (adult) 2013 |
| Change Summary |
Data Attributes
Attribute Summary
| Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
|---|---|---|---|---|---|
| 100 | No | No | 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 | No | No | BELTTRANSECTRUN | NUMBER | Primary key for CORAL_BELT_TRANSECTRUN |
| 100 | No | No | CLASS | NVARCHAR2 | Class taxonomic rank |
| 100 | No | No | COLONYID | NUMBER | Colony identifier |
| 100 | No | No | COLONYLENGTH | NUMBER | Colony length (cm) |
| 100 | No | No | COND | NVARCHAR2 | Coral disease code of the observed coral colony |
| 100 | No | No | COND_DESCRIPTION | NVARCHAR2 | Coral disease description of the observed coral colony |
| 100 | No | No | DATE_ | DATE | Date the survey was conducted |
| 100 | No | No | DIVER | NVARCHAR2 | Initials of diver conducting survey |
| 100 | No | No | 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 | No | No | EXTENT | NUMBER | Disease extent (1-100) |
| 100 | No | No | FAMILY | VARCHAR2 | Family taxonomic rank |
| 100 | No | No | GENUS | NVARCHAR2 | Genus Taxonomic Rank |
| 100 | No | No | ISLAND | NVARCHAR2 | Island or atoll surveyed |
| 100 | No | No | LATITUDE | NUMBER | Latitude in decimal degrees, WGS84, for the given site |
| 100 | No | No | LONGITUDE | NUMBER | Longitude in decimal degrees, WGS84 for the given site |
| 100 | No | No | MAXDEPTH | NUMBER | Maximum depth of the transect (ft). Not consistently recorded by divers. |
| 100 | No | No | METHODNAME | NVARCHAR2 | References the coral belt survey method |
| 100 | No | No | MINDEPTH | NUMBER | Minimum depth of the transect (ft). Not consistently recorded by divers. |
| 100 | No | No | OBS_YEAR | NUMBER | Observation year |
| 100 | No | No | OLDDEAD | NUMBER | Percentage of old dead coral |
| 100 | No | No | PHYLUM | VARCHAR2 | Phylum taxonomic rank |
| 100 | No | No | RANK | VARCHAR2 | Rank from WoRMS |
| 100 | No | No | RECENTDEAD | NUMBER | Percentage of recently dead coral |
| 100 | No | No | REEF_ZONE | NVARCHAR2 | The reef zone for the given site (forereef, backreef or lagoon) |
| 100 | No | No | REGION_NAME | VARCHAR2 | One of the five Pacific Island regions CREP surveys |
| 100 | No | No | 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 | No | No | SEGMENT | NVARCHAR2 | Segment number |
| 100 | No | No | SEVERITY | NUMBER | Disease severity (1-5) |
| 100 | No | No | SITE | NVARCHAR2 | The 5- to 6-character code for the site surveyed. Combines a 3-letter island code with a site number |
| 100 | No | No | SITEVISITID | NUMBER | Unique Identifier for SITE_VISIT record |
| 100 | No | No | SPECIES | Unknown | Organism observed (4-letter code). |
| 100 | No | No | S_ORDER | VARCHAR2 | Order taxonomic rank |
| 100 | No | No | TAXONNAME | NVARCHAR2 | Taxonomic name, based on lowest taxon level identified. |
| 100 | No | No | TRANLENGTH | NUMBER | Transect length (m) |
| 100 | No | No | TRANSECT | NUMBER | Transect number |
| 100 | No | No | TRANWIDTH | NUMBER | Transect width (m) |
| 100 | No | No | COLONYWIDTH | NUMBER | Colony width (cm) |
| 100 | No | No | COLONYHEIGHT | NUMBER | colony height (cm) |
| 100 | No | No | MISSIONID | TEXT | Unique identifier for field mission/cruise. |
Attribute Details
| Attribute Name | APHIAID |
|---|---|
| Seq. Order | 1 |
| Data Storage Type | VARCHAR2 |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| 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). |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | BELTTRANSECTRUN |
|---|---|
| Seq. Order | 2 |
| Data Storage Type | NUMBER |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Primary key for CORAL_BELT_TRANSECTRUN |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | No domain defined. |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | CLASS |
|---|---|
| Seq. Order | 4 |
| Data Storage Type | NVARCHAR2 |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Class taxonomic rank |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | COLONYID |
|---|---|
| Seq. Order | 5 |
| Data Storage Type | NUMBER |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Colony identifier |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | No domain defined. |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | COLONYLENGTH |
|---|---|
| Seq. Order | 6 |
| Data Storage Type | NUMBER |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Colony length (cm) |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | No domain defined. |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | COND |
|---|---|
| Seq. Order | 8 |
| Data Storage Type | NVARCHAR2 |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Coral disease code of the observed coral colony |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | COND_DESCRIPTION |
|---|---|
| Seq. Order | |
| Data Storage Type | NVARCHAR2 |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Coral disease description of the observed coral colony |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | DATE_ |
|---|---|
| Seq. Order | |
| Data Storage Type | DATE |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Date the survey was conducted |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | No domain defined. |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | DIVER |
|---|---|
| Seq. Order | |
| Data Storage Type | NVARCHAR2 |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Initials of diver conducting survey |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | No domain defined. |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | EXCLUDE_FLAG |
|---|---|
| Seq. Order | |
| Data Storage Type | Unknown |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| 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. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | No domain defined. |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | EXTENT |
|---|---|
| Seq. Order | |
| Data Storage Type | NUMBER |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Disease extent (1-100) |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | FAMILY |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2 |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Family taxonomic rank |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | GENUS |
|---|---|
| Seq. Order | |
| Data Storage Type | NVARCHAR2 |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Genus Taxonomic Rank |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ISLAND |
|---|---|
| Seq. Order | |
| Data Storage Type | NVARCHAR2 |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Island or atoll surveyed |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | No domain defined. |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LATITUDE |
|---|---|
| Seq. Order | |
| Data Storage Type | NUMBER |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Latitude in decimal degrees, WGS84, for the given site |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | No domain defined. |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LONGITUDE |
|---|---|
| Seq. Order | |
| Data Storage Type | NUMBER |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Longitude in decimal degrees, WGS84 for the given site |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | No domain defined. |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | MAXDEPTH |
|---|---|
| Seq. Order | |
| Data Storage Type | NUMBER |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Maximum depth of the transect (ft). Not consistently recorded by divers. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | No domain defined. |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | METHODNAME |
|---|---|
| Seq. Order | |
| Data Storage Type | NVARCHAR2 |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
References the coral belt survey method |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | No domain defined. |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | MINDEPTH |
|---|---|
| Seq. Order | |
| Data Storage Type | NUMBER |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Minimum depth of the transect (ft). Not consistently recorded by divers. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | No domain defined. |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | OBS_YEAR |
|---|---|
| Seq. Order | |
| Data Storage Type | NUMBER |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Observation year |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | No domain defined. |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | OLDDEAD |
|---|---|
| Seq. Order | |
| Data Storage Type | NUMBER |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Percentage of old dead coral |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | No domain defined. |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | PHYLUM |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2 |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Phylum taxonomic rank |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | RANK |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2 |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Rank from WoRMS |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | RECENTDEAD |
|---|---|
| Seq. Order | |
| Data Storage Type | NUMBER |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Percentage of recently dead coral |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | No domain defined. |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | REEF_ZONE |
|---|---|
| Seq. Order | |
| Data Storage Type | NVARCHAR2 |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
The reef zone for the given site (forereef, backreef or lagoon) |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | No domain defined. |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | REGION_NAME |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2 |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
One of the five Pacific Island regions CREP surveys |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | No domain defined. |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | SCIENTIFIC_NAME |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2 |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| 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. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | SEGMENT |
|---|---|
| Seq. Order | |
| Data Storage Type | NVARCHAR2 |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Segment number |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | No domain defined. |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | SEVERITY |
|---|---|
| Seq. Order | |
| Data Storage Type | NUMBER |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Disease severity (1-5) |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | SITE |
|---|---|
| Seq. Order | |
| Data Storage Type | NVARCHAR2 |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
The 5- to 6-character code for the site surveyed. Combines a 3-letter island code with a site number |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | No domain defined. |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | SITEVISITID |
|---|---|
| Seq. Order | |
| Data Storage Type | NUMBER |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Unique Identifier for SITE_VISIT record |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | No domain defined. |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | SPECIES |
|---|---|
| Seq. Order | |
| Data Storage Type | Unknown |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Organism observed (4-letter code). |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | No domain defined. |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | S_ORDER |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2 |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Order taxonomic rank |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | TAXONNAME |
|---|---|
| Seq. Order | |
| Data Storage Type | NVARCHAR2 |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Taxonomic name, based on lowest taxon level identified. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | TRANLENGTH |
|---|---|
| Seq. Order | |
| Data Storage Type | NUMBER |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Transect length (m) |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | No domain defined. |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | TRANSECT |
|---|---|
| Seq. Order | |
| Data Storage Type | NUMBER |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Transect number |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | No domain defined. |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | TRANWIDTH |
|---|---|
| Seq. Order | |
| Data Storage Type | NUMBER |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Transect width (m) |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | No domain defined. |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | COLONYWIDTH |
|---|---|
| Seq. Order | |
| Data Storage Type | NUMBER |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Colony width (cm) |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | COLONYHEIGHT |
|---|---|
| Seq. Order | |
| Data Storage Type | NUMBER |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
colony height (cm) |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | MISSIONID |
|---|---|
| Seq. Order | |
| Data Storage Type | TEXT |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Unique identifier for field mission/cruise. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | |
|---|---|
| Seq. Order | |
| Data Storage Type | |
| Max Length | |
| Precision | |
| Scale | |
| Required | |
| Primary Key | |
| Status | |
| Description | |
| General Data Type | |
| Case Restriction | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Min Length | |
| Unit of Measure | |
| Display Example | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | |
|---|---|
| Seq. Order | |
| Data Storage Type | |
| Max Length | |
| Precision | |
| Scale | |
| Required | |
| Primary Key | |
| Status | |
| Description | |
| General Data Type | |
| Case Restriction | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Min Length | |
| Unit of Measure | |
| Display Example | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | |
|---|---|
| Seq. Order | |
| Data Storage Type | |
| Max Length | |
| Precision | |
| Scale | |
| Required | |
| Primary Key | |
| Status | |
| Description | |
| General Data Type | |
| Case Restriction | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Min Length | |
| Unit of Measure | |
| Display Example | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
Support Roles
» At least one Distributor Org, one Metadata Contact, one Point of Contact, and one Data Steward should be listed.
| * » Support Role | |
|---|---|
| * » Date Effective From | |
| Date Effective To | |
| * » Contact | |
| * Contact Instructions |
| * » Support Role | |
|---|---|
| * » Date Effective From | |
| Date Effective To | |
| * » Contact | |
| * Contact Instructions |
| * » Support Role | |
|---|---|
| * » Date Effective From | |
| Date Effective To | |
| * » Contact | |
| * Contact Instructions |
Extents
| Currentness Reference |
|---|
Extent Group 1
| Extent Description |
|---|
Extent Group 1 / Geographic Area
| * » W° Bound | |
|---|---|
| * » E° Bound | |
| * » N° Bound | |
| * » S° Bound | |
| * » Description |
Extent Group 1 / Vertical Extent
| EPSG Code | |
|---|---|
| Vertical Minimum | |
| Vertical Maximum |
Extent Group 1 / Time Frame
| * » Time Frame Type | |
|---|---|
| * » Start | |
| End | |
| Alternate Start as of Info | |
| Alternate End as of Info | |
| Description |
Access Information
| * » Security Class | |
|---|---|
| * Security Classification System |
|
| Security Handling Description |
|
| • Data Access Policy |
|
| » Data Access Procedure |
|
| • » Data Access Constraints |
|
| • Data Use Constraints |
|
| Metadata Access Constraints |
|
| Metadata Use Constraints |
|
Distribution Information
| Start Date | |
|---|---|
| End Date | |
| » Download URL | |
| Distributor | |
| File Name | |
| Description | |
| File Date/Time | |
| File Type | |
| FGDC Content Type | |
| File Size | |
| Application Version | |
| Compression | |
| Review Status |
| Start Date | |
|---|---|
| End Date | |
| » Download URL | |
| Distributor | |
| File Name | |
| Description | |
| File Date/Time | |
| File Type | |
| FGDC Content Type | |
| File Size | |
| Application Version | |
| Compression | |
| Review Status |
| Start Date | |
|---|---|
| End Date | |
| » Download URL | |
| Distributor | |
| File Name | |
| Description | |
| File Date/Time | |
| File Type | |
| FGDC Content Type | |
| File Size | |
| Application Version | |
| Compression | |
| Review Status |
Activity Log
| Activity Time | |
|---|---|
| Activity Type | |
| Responsible Party | |
| Description |
| Activity Time | |
|---|---|
| Activity Type | |
| Responsible Party | |
| Description |
| Activity Time | |
|---|---|
| Activity Type | |
| Responsible Party | |
| Description |
Issues
| Issue Date | |
|---|---|
| Author | |
| Issue |
| Issue Date | |
|---|---|
| Author | |
| Issue |
| Issue Date | |
|---|---|
| Author | |
| Issue |
FAQs
| Date | |
|---|---|
| Author | |
| Question | |
| Answer |
Child Items
Rubric scores updated every 15m
| Score | Type | Title |
|---|---|---|
Related Items
| Item Type | Relationship Type | Title |
|---|---|---|
Catalog Details
| Catalog Item ID | 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 Workflow State | Published / External |
| Metadata Last Review Date | 2021-09-01 |
| Metadata Review Frequency | 1 Year |
| Metadata Next Review Date | 2022-09-01 |
| Tags |
|---|