LINE_ISLAND_2005_HURL
Pacific Islands Fisheries Science Center
Entity
(ENT)
| ID: 51136
| Published / External
Created: 2018-01-09
|
Last Modified: 2025-02-13
Data Set (DS) | ID: 8787
ID: 51136
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | LINE_ISLAND_2005_HURL |
---|---|
Short Name | LINE_ISLAND_2005_HURL |
* Status | Completed |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
Oracle table of extracted data of organisms recorded on video during 2005 HURL cruise. |
* 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 Table |
---|---|
Active Version? | N |
Alias | |
Schema Name | |
» Description |
Oracle table of extracted data of organisms recorded on video during 2005 HURL cruise. |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | No | No | GENERAL_LOCALITY | VARCHAR2 | General location of dive. |
100 | No | No | DIVE | VARCHAR2 | Dive number. |
100 | No | No | TAPE | VARCHAR2 | Tape number. |
100 | No | No | TAPETIMECODE | VARCHAR2 | Time into tape (hours:minutes:seconds:frames). |
100 | No | No | SCIENTIFICNAME | VARCHAR2 | Taxonomic name. |
100 | No | No | TAXONRANK | VARCHAR2 | Taxonomic rank. |
100 | No | No | IDENTIFICATIONREMARKS | VARCHAR2 | Comments on certainty of identification and/or additional distinguishing charateristics. |
100 | No | No | INDIVIDUALCOUNT | NUMBER | Number of individuals. Measures are reported with a precision of 3. |
100 | No | No | SIZE_CM | VARCHAR2 | If available, size estimate typically in 5-centimeter bins; larger ranges when individuals of various sizes or too difficult to estimate to the nearest 5 cm; range of values. Units for values are centimeter. |
100 | No | No | SIZE_MEASUREMENT | VARCHAR2 | Type of size estimate (i.e. total length, carapace width, test diameter, etc.). |
100 | No | No | MEGAHABITAT | VARCHAR2 | Major landform description (i.e. atoll, bank, conical seamount, guyot, island, ridge seamount, seamount, tablemount). |
100 | No | No | GENERAL_HABITAT | VARCHAR2 | Minor landform decription (i.e. canyon, crater, flank, pinnacle, ridge, summit, terrace). |
100 | No | No | HABITAT | VARCHAR2 | Substrate types in vicinity with primary type recorded first (sed=sediment; peb=pebble; bou=boulder; bed=bedrock; deadcn=dead cnidarian; deadbi=bivalve shells; mantra=manmade trash; l=limestone; sc=sediment-covered; ri=rippled; po=pockets). |
100 | No | No | HABITAT_COMMENTS | VARCHAR2 | Additional descriptions of terrain. |
100 | No | No | SUBSTRATE | VARCHAR2 | Contact substrate of the organism(s) observed; may be geological or biological. |
100 | No | No | SLOPE_DEGREES | VARCHAR2 | Visual classification of slope as 0-15, 15-45, 45-90, or >90 degrees. Note: Camera angle as well as submersible/ROV orientation make interpretation difficult at times; range of values. Units for values are degrees. |
100 | No | No | RUGOSITY | NUMBER | Visual classification of rugosity from low (1) to high (5). Guidelines are 1=smooth, 2=sand and a few cobbles or small holes, 3=1/3 not smooth, 4=2/3 not smooth, and 5=no smooth area. Note: visual area is not standardized which should be considered in using these rugosity values. Measures are reported with a precision of 1. |
100 | No | No | TEMPERATURE | NUMBER | Temperature (degrees Celsius) from CTD. Measures are reported with a precision of 8. |
100 | No | No | SALINITY | NUMBER | Salinity (practical salinity unit) from CTD. Measures are reported with a precision of 8. |
100 | No | No | OXYGEN | NUMBER | Dissolved oxygen (mg/l) from CTD. Measures are reported with a precision of 9. |
100 | No | No | ASSOCIATEDTAXA | VARCHAR2 | Taxa upon organism(s) observed. |
100 | No | No | OCCURRENCEREMARKS | VARCHAR2 | Additional comments about the record. |
100 | No | No | MOVEMENT | VARCHAR2 | Description of submersible or ROV movement (i.e. descend, cruise, transect, or stationary). |
100 | No | No | OBSERVATIONDATE | DATE | Local date when the video observation was recorded. |
100 | No | No | OBSERVATIONTIME | VARCHAR2 | Local time when the video observation was recorded. |
100 | No | No | LATITUDE | NUMBER | Latitude (decimal degrees) where the video observation was made. Units for values are degrees. Measures are reported with a precision of 10. |
100 | No | No | LONGITUDE | NUMBER | Longitude (decimal degrees) where the video observation was made. Units for values are degrees. Measures are reported with a precision of 12. |
100 | No | No | MINUTES_TO_TRACK_POINT | NUMBER | Time (minutes) between video observation and closest track (latitude and longitude) point. Units for values are minutes. Measures are reported with a precision of 10. |
100 | No | No | DEPTHINMETERS | NUMBER | Depth (meters) of the submersible or ROV at the time of the observation. Units for values are meters. Measures are reported with a precision of 7. |
100 | No | No | DEPTHSOURCE | VARCHAR2 | Source of depth record (i.e. video overlay or CTD). |
100 | No | No | SPECIMEN | VARCHAR2 | The identification number for a collected specimen. |
100 | No | No | IMAGEFILEPATH | VARCHAR2 | Folder and image name of organism(s) observed. Multiple image names of same organism separated by semicolon. |
100 | No | No | TAX_PHYLUM | VARCHAR2 | Phylum of the taxon identified. |
100 | No | No | TAX_SUBPHYLUM | VARCHAR2 | Subphylum of the taxon identified. |
100 | No | No | TAX_SUPERCLASS | VARCHAR2 | Superclass of the taxon identified. |
100 | No | No | TAX_CLASS | VARCHAR2 | Class of the taxon identified. |
100 | No | No | TAX_SUBCLASS | VARCHAR2 | Subclass of the taxon identified. |
100 | No | No | TAX_INFRACLASS | VARCHAR2 | Infraclass of the taxon identified. |
100 | No | No | TAX_SUPERORDER | VARCHAR2 | Superorder of the taxon identified. |
100 | No | No | TAX_ORDER | VARCHAR2 | Order of the taxon identified. |
100 | No | No | TAX_SUBORDER | VARCHAR2 | Suborder of the taxon identified. |
100 | No | No | TAX_INFRAORDER | VARCHAR2 | Infraorder of the taxon identified. |
100 | No | No | TAX_SUPERFAMILY | VARCHAR2 | Superfamily of the taxon identified. |
100 | No | No | TAX_FAMILY | VARCHAR2 | Family of the taxon identified. |
100 | No | No | TAX_SUBFAMILY | VARCHAR2 | Subfamily of the taxon identified. |
100 | No | No | TAX_GENUS | VARCHAR2 | Genus of the taxon identified. |
100 | No | No | TAX_SPECIES | VARCHAR2 | Species of the taxon identified. |
100 | No | No | WORMS_ID | VARCHAR2 | Aphiaid of scientific name from World Register of Marine Species (WoRMS). |
100 | No | No | SCIENTIFICNAMEAUTHORSHIP | VARCHAR2 | Author who originally described the taxon. |
100 | No | No | SYNONYMS | VARCHAR2 | Other scientific names used for the observed taxon (not complete). |
100 | No | No | VESSEL | VARCHAR2 | Name of vessel used for collecting observation. |
100 | No | No | PI | VARCHAR2 | Principal Investigator of the project with which the video was collected. |
100 | No | No | PIAFFILIATION | VARCHAR2 | Affiliation of the Principal Investigator. |
100 | No | No | PURPOSE | VARCHAR2 | Purpose of the project with which the observation was collected. |
100 | No | No | SAMPLINGEQUIPMENT | VARCHAR2 | Type of equipment used (i.e. submersible or ROV). |
100 | No | No | VEHICLENAME | VARCHAR2 | Name of the submersible or ROV used to collected the video observation. |
100 | No | No | SAMPLEID | VARCHAR2 | The observation identification number of the record in the Video Annotation and Reference System (VARS) database. |
100 | No | No | DATACONTACT | VARCHAR2 | The name of the individual who is the primary representative of the data. |
100 | No | No | REPOSITORY | VARCHAR2 | Location where the video is stored. |
Attribute Details
Attribute Name | GENERAL_LOCALITY |
---|---|
Seq. Order | 1 |
Data Storage Type | VARCHAR2 |
Max Length | 13 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
General location of dive. |
General Data Type | VARCHAR2 |
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 | DIVE |
---|---|
Seq. Order | 2 |
Data Storage Type | VARCHAR2 |
Max Length | 6 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Dive number. |
General Data Type | VARCHAR2 |
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 | TAPE |
---|---|
Seq. Order | 3 |
Data Storage Type | VARCHAR2 |
Max Length | 9 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Tape number. |
General Data Type | VARCHAR2 |
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 | TAPETIMECODE |
---|---|
Seq. Order | 4 |
Data Storage Type | VARCHAR2 |
Max Length | 11 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Time into tape (hours:minutes:seconds:frames). |
General Data Type | VARCHAR2 |
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 | SCIENTIFICNAME |
---|---|
Seq. Order | 5 |
Data Storage Type | VARCHAR2 |
Max Length | 29 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Taxonomic name. |
General Data Type | VARCHAR2 |
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 | TAXONRANK |
---|---|
Seq. Order | 6 |
Data Storage Type | VARCHAR2 |
Max Length | 11 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Taxonomic rank. |
General Data Type | VARCHAR2 |
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 | IDENTIFICATIONREMARKS |
---|---|
Seq. Order | 7 |
Data Storage Type | VARCHAR2 |
Max Length | 170 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Comments on certainty of identification and/or additional distinguishing charateristics. |
General Data Type | VARCHAR2 |
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 | INDIVIDUALCOUNT |
---|---|
Seq. Order | 8 |
Data Storage Type | NUMBER |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Number of individuals. Measures are reported with a precision of 3. |
General Data Type | NUMBER |
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 | SIZE_CM |
---|---|
Seq. Order | 9 |
Data Storage Type | VARCHAR2 |
Max Length | 15 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
If available, size estimate typically in 5-centimeter bins; larger ranges when individuals of various sizes or too difficult to estimate to the nearest 5 cm; range of values. Units for values are centimeter. |
General Data Type | VARCHAR2 |
Unit of Measure | centimeter |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SIZE_MEASUREMENT |
---|---|
Seq. Order | 10 |
Data Storage Type | VARCHAR2 |
Max Length | 61 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Type of size estimate (i.e. total length, carapace width, test diameter, etc.). |
General Data Type | VARCHAR2 |
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 | MEGAHABITAT |
---|---|
Seq. Order | 11 |
Data Storage Type | VARCHAR2 |
Max Length | 6 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Major landform description (i.e. atoll, bank, conical seamount, guyot, island, ridge seamount, seamount, tablemount). |
General Data Type | VARCHAR2 |
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 | GENERAL_HABITAT |
---|---|
Seq. Order | 12 |
Data Storage Type | VARCHAR2 |
Max Length | 6 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Minor landform decription (i.e. canyon, crater, flank, pinnacle, ridge, summit, terrace). |
General Data Type | VARCHAR2 |
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 | HABITAT |
---|---|
Seq. Order | 13 |
Data Storage Type | VARCHAR2 |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Substrate types in vicinity with primary type recorded first (sed=sediment; peb=pebble; bou=boulder; bed=bedrock; deadcn=dead cnidarian; deadbi=bivalve shells; mantra=manmade trash; l=limestone; sc=sediment-covered; ri=rippled; po=pockets). |
General Data Type | VARCHAR2 |
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 | HABITAT_COMMENTS |
---|---|
Seq. Order | 14 |
Data Storage Type | VARCHAR2 |
Max Length | 70 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Additional descriptions of terrain. |
General Data Type | VARCHAR2 |
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 | SUBSTRATE |
---|---|
Seq. Order | 15 |
Data Storage Type | VARCHAR2 |
Max Length | 27 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Contact substrate of the organism(s) observed; may be geological or biological. |
General Data Type | VARCHAR2 |
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 | SLOPE_DEGREES |
---|---|
Seq. Order | 16 |
Data Storage Type | VARCHAR2 |
Max Length | 19 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Visual classification of slope as 0-15, 15-45, 45-90, or >90 degrees. Note: Camera angle as well as submersible/ROV orientation make interpretation difficult at times; range of values. Units for values are degrees. |
General Data Type | VARCHAR2 |
Unit of Measure | degrees |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | RUGOSITY |
---|---|
Seq. Order | 17 |
Data Storage Type | NUMBER |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Visual classification of rugosity from low (1) to high (5). Guidelines are 1=smooth, 2=sand and a few cobbles or small holes, 3=1/3 not smooth, 4=2/3 not smooth, and 5=no smooth area. Note: visual area is not standardized which should be considered in using these rugosity values. Measures are reported with a precision of 1. |
General Data Type | NUMBER |
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 | TEMPERATURE |
---|---|
Seq. Order | 18 |
Data Storage Type | NUMBER |
Max Length | 9 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | 6 |
Status | Active |
Description |
Temperature (degrees Celsius) from CTD. Measures are reported with a precision of 8. |
General Data Type | NUMBER |
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 | SALINITY |
---|---|
Seq. Order | 19 |
Data Storage Type | NUMBER |
Max Length | 9 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | 6 |
Status | Active |
Description |
Salinity (practical salinity unit) from CTD. Measures are reported with a precision of 8. |
General Data Type | NUMBER |
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 | OXYGEN |
---|---|
Seq. Order | 20 |
Data Storage Type | NUMBER |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | 8 |
Status | Active |
Description |
Dissolved oxygen (mg/l) from CTD. Measures are reported with a precision of 9. |
General Data Type | NUMBER |
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 | ASSOCIATEDTAXA |
---|---|
Seq. Order | 21 |
Data Storage Type | VARCHAR2 |
Max Length | 63 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Taxa upon organism(s) observed. |
General Data Type | VARCHAR2 |
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 | OCCURRENCEREMARKS |
---|---|
Seq. Order | 22 |
Data Storage Type | VARCHAR2 |
Max Length | 177 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Additional comments about the record. |
General Data Type | VARCHAR2 |
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 | MOVEMENT |
---|---|
Seq. Order | 23 |
Data Storage Type | VARCHAR2 |
Max Length | 13 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Description of submersible or ROV movement (i.e. descend, cruise, transect, or stationary). |
General Data Type | VARCHAR2 |
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 | OBSERVATIONDATE |
---|---|
Seq. Order | 24 |
Data Storage Type | DATE |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Local date when the video observation was recorded. |
General Data Type | DATE |
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 | OBSERVATIONTIME |
---|---|
Seq. Order | 25 |
Data Storage Type | VARCHAR2 |
Max Length | 17 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Local time when the video observation was recorded. |
General Data Type | VARCHAR2 |
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 | LATITUDE |
---|---|
Seq. Order | 26 |
Data Storage Type | NUMBER |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | 8 |
Status | Active |
Description |
Latitude (decimal degrees) where the video observation was made. Units for values are degrees. Measures are reported with a precision of 10. |
General Data Type | NUMBER |
Unit of Measure | degrees |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LONGITUDE |
---|---|
Seq. Order | 27 |
Data Storage Type | NUMBER |
Max Length | 17 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | 8 |
Status | Active |
Description |
Longitude (decimal degrees) where the video observation was made. Units for values are degrees. Measures are reported with a precision of 12. |
General Data Type | NUMBER |
Unit of Measure | degrees |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | MINUTES_TO_TRACK_POINT |
---|---|
Seq. Order | 28 |
Data Storage Type | NUMBER |
Max Length | 11 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | 9 |
Status | Active |
Description |
Time (minutes) between video observation and closest track (latitude and longitude) point. Units for values are minutes. Measures are reported with a precision of 10. |
General Data Type | NUMBER |
Unit of Measure | minutes |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DEPTHINMETERS |
---|---|
Seq. Order | 29 |
Data Storage Type | NUMBER |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | 3 |
Status | Active |
Description |
Depth (meters) of the submersible or ROV at the time of the observation. Units for values are meters. Measures are reported with a precision of 7. |
General Data Type | NUMBER |
Unit of Measure | meters |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DEPTHSOURCE |
---|---|
Seq. Order | 30 |
Data Storage Type | VARCHAR2 |
Max Length | 13 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Source of depth record (i.e. video overlay or CTD). |
General Data Type | VARCHAR2 |
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 | SPECIMEN |
---|---|
Seq. Order | 31 |
Data Storage Type | VARCHAR2 |
Max Length | 14 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The identification number for a collected specimen. |
General Data Type | VARCHAR2 |
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 | IMAGEFILEPATH |
---|---|
Seq. Order | 32 |
Data Storage Type | VARCHAR2 |
Max Length | 128 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Folder and image name of organism(s) observed. Multiple image names of same organism separated by semicolon. |
General Data Type | VARCHAR2 |
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 | TAX_PHYLUM |
---|---|
Seq. Order | 33 |
Data Storage Type | VARCHAR2 |
Max Length | 13 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Phylum of the taxon identified. |
General Data Type | VARCHAR2 |
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 | TAX_SUBPHYLUM |
---|---|
Seq. Order | 34 |
Data Storage Type | VARCHAR2 |
Max Length | 11 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Subphylum of the taxon identified. |
General Data Type | VARCHAR2 |
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 | TAX_SUPERCLASS |
---|---|
Seq. Order | 35 |
Data Storage Type | VARCHAR2 |
Max Length | 14 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Superclass of the taxon identified. |
General Data Type | VARCHAR2 |
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 | TAX_CLASS |
---|---|
Seq. Order | 36 |
Data Storage Type | VARCHAR2 |
Max Length | 14 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Class of the taxon identified. |
General Data Type | VARCHAR2 |
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 | TAX_SUBCLASS |
---|---|
Seq. Order | 37 |
Data Storage Type | VARCHAR2 |
Max Length | 15 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Subclass of the taxon identified. |
General Data Type | VARCHAR2 |
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 | TAX_INFRACLASS |
---|---|
Seq. Order | 38 |
Data Storage Type | VARCHAR2 |
Max Length | 14 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Infraclass of the taxon identified. |
General Data Type | VARCHAR2 |
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 | TAX_SUPERORDER |
---|---|
Seq. Order | 39 |
Data Storage Type | VARCHAR2 |
Max Length | 14 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Superorder of the taxon identified. |
General Data Type | VARCHAR2 |
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 | TAX_ORDER |
---|---|
Seq. Order | 40 |
Data Storage Type | VARCHAR2 |
Max Length | 18 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Order of the taxon identified. |
General Data Type | VARCHAR2 |
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 | TAX_SUBORDER |
---|---|
Seq. Order | 41 |
Data Storage Type | VARCHAR2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Suborder of the taxon identified. |
General Data Type | VARCHAR2 |
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 | TAX_INFRAORDER |
---|---|
Seq. Order | 42 |
Data Storage Type | VARCHAR2 |
Max Length | 9 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Infraorder of the taxon identified. |
General Data Type | VARCHAR2 |
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 | TAX_SUPERFAMILY |
---|---|
Seq. Order | 43 |
Data Storage Type | VARCHAR2 |
Max Length | 25 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Superfamily of the taxon identified. |
General Data Type | VARCHAR2 |
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 | TAX_FAMILY |
---|---|
Seq. Order | 44 |
Data Storage Type | VARCHAR2 |
Max Length | 18 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Family of the taxon identified. |
General Data Type | VARCHAR2 |
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 | TAX_SUBFAMILY |
---|---|
Seq. Order | 45 |
Data Storage Type | VARCHAR2 |
Max Length | 15 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Subfamily of the taxon identified. |
General Data Type | VARCHAR2 |
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 | TAX_GENUS |
---|---|
Seq. Order | 46 |
Data Storage Type | VARCHAR2 |
Max Length | 17 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Genus of the taxon identified. |
General Data Type | VARCHAR2 |
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 | TAX_SPECIES |
---|---|
Seq. Order | 47 |
Data Storage Type | VARCHAR2 |
Max Length | 15 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Species of the taxon identified. |
General Data Type | VARCHAR2 |
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 | WORMS_ID |
---|---|
Seq. Order | 48 |
Data Storage Type | VARCHAR2 |
Max Length | 6 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Aphiaid of scientific name from World Register of Marine Species (WoRMS). |
General Data Type | VARCHAR2 |
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 | SCIENTIFICNAMEAUTHORSHIP |
---|---|
Seq. Order | 49 |
Data Storage Type | VARCHAR2 |
Max Length | 39 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Author who originally described the taxon. |
General Data Type | VARCHAR2 |
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 | SYNONYMS |
---|---|
Seq. Order | 50 |
Data Storage Type | VARCHAR2 |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Other scientific names used for the observed taxon (not complete). |
General Data Type | VARCHAR2 |
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 | VESSEL |
---|---|
Seq. Order | 51 |
Data Storage Type | VARCHAR2 |
Max Length | 21 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Name of vessel used for collecting observation. |
General Data Type | VARCHAR2 |
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 | PI |
---|---|
Seq. Order | 52 |
Data Storage Type | VARCHAR2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Principal Investigator of the project with which the video was collected. |
General Data Type | VARCHAR2 |
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 | PIAFFILIATION |
---|---|
Seq. Order | 53 |
Data Storage Type | VARCHAR2 |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Affiliation of the Principal Investigator. |
General Data Type | VARCHAR2 |
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 | PURPOSE |
---|---|
Seq. Order | 54 |
Data Storage Type | VARCHAR2 |
Max Length | 160 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Purpose of the project with which the observation was collected. |
General Data Type | VARCHAR2 |
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 | SAMPLINGEQUIPMENT |
---|---|
Seq. Order | 55 |
Data Storage Type | VARCHAR2 |
Max Length | 11 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Type of equipment used (i.e. submersible or ROV). |
General Data Type | VARCHAR2 |
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 | VEHICLENAME |
---|---|
Seq. Order | 56 |
Data Storage Type | VARCHAR2 |
Max Length | 14 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Name of the submersible or ROV used to collected the video observation. |
General Data Type | VARCHAR2 |
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 | SAMPLEID |
---|---|
Seq. Order | 57 |
Data Storage Type | VARCHAR2 |
Max Length | 6 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The observation identification number of the record in the Video Annotation and Reference System (VARS) database. |
General Data Type | VARCHAR2 |
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 | DATACONTACT |
---|---|
Seq. Order | 58 |
Data Storage Type | VARCHAR2 |
Max Length | 18 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The name of the individual who is the primary representative of the data. |
General Data Type | VARCHAR2 |
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 | REPOSITORY |
---|---|
Seq. Order | 59 |
Data Storage Type | VARCHAR2 |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Location where the video is stored. |
General Data Type | VARCHAR2 |
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
* » 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 | 51136 |
---|---|
Metadata Record Created By | Brent M Miyamoto |
Metadata Record Created | 2018-01-09 19:56+0000 |
Metadata Record Last Modified By | Michael Chang |
» Metadata Record Last Modified | 2025-02-13 23:14+0000 |
Metadata Record Published | 2025-02-13 |
Owner Org | PIFSC |
Metadata Publication Status | Published Externally |
Do Not Publish? | N |
Metadata Workflow State | Published / External |
Metadata Last Review Date | |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date |
Tags |
---|