2005_LINEISLAND_HURL_DATABASE

Pacific Islands Fisheries Science Center
Entity (ENT) | ID: 51135 | Published / External
Created: 2018-01-09 | Last Modified: 2025-02-13

Parent: Biodiversity and Habitat Data Extracted from Video Files Recorded at Jarvis, Kingman, and Palmyra During July 2005 HURL Cruise
Data Set (DS) | ID: 8787

ID: 51135
Entity (ENT)

* Discovery
• First Pass
» Metadata Rubric

Item Identification

* » Title	2005_LINEISLAND_HURL_DATABASE
Short Name	2005_LINEISLAND_HURL_DATABASE
* Status	Completed
Creation Date
Revision Date
• Publication Date
* » Abstract	Excel spreadsheet 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?	Y
Alias
Schema Name
» Description	Excel spreadsheet 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	LOCALITY	Character	General location of dive.
100	No	No	DIVE	Character	Dive number.
100	No	No	TAPE	Character	Tape number.
100	No	No	TAPETIMECODE	Character	Time into tape (hours:minutes:seconds:frames).
100	No	No	SCIENTIFICNAME	Character	Taxonomic name.
100	No	No	TAXONRANK	Character	Taxonomic rank.
100	No	No	IDENTIFICATIONREMARKS	Character	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	Character	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	SIZEMEASUREMENT	Character	Type of size estimate (i.e. total length, carapace width, test diameter, etc.).
100	No	No	MEGAHABITAT	Character	Major landform description (i.e. atoll, bank, conical seamount, guyot, island, ridge seamount, seamount, tablemount).
100	No	No	GENERALHABITAT	Character	Minor landform decription (i.e. canyon, crater, flank, pinnacle, ridge, summit, terrace).
100	No	No	HABITAT	Character	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	HABITATCOMMENTS	Character	Additional descriptions of terrain.
100	No	No	SUBSTRATE	Character	Contact substrate of the organism(s) observed; may be geological or biological.
100	No	No	SLOPE_DEGREES	Character	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	Character	Taxa upon organism(s) observed.
100	No	No	OCCURRENCEREMARKS	Character	Additional comments about the record.
100	No	No	MOVEMENT	Character	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	Time	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	TIMETOTRACKPOINT_MIN	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	DEPTH_METERS	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	Character	Source of depth record (i.e. video overlay or CTD).
100	No	No	SPECIMEN	Character	The identification number for a collected specimen.
100	No	No	IMAGEFILEPATH	Character	Folder and image name of organism(s) observed. Multiple image names of same organism separated by semicolon.
100	No	No	PHYLUM	Character	Phylum of the taxon identified.
100	No	No	SUBPHYLUM	Character	Subphylum of the taxon identified.
100	No	No	SUPERCLASS	Character	Superclass of the taxon identified.
100	No	No	CLASS	Character	Class of the taxon identified.
100	No	No	SUBCLASS	Character	Subclass of the taxon identified.
100	No	No	INFRACLASS	Character	Infraclass of the taxon identified.
100	No	No	SUPERORDER	Character	Superorder of the taxon identified.
100	No	No	ORDER	Character	Order of the taxon identified.
100	No	No	SUBORDER	Character	Suborder of the taxon identified.
100	No	No	INFRAORDER	Character	Infraorder of the taxon identified.
100	No	No	SUPERFAMILY	Character	Superfamily of the taxon identified.
100	No	No	FAMILY	Character	Family of the taxon identified.
100	No	No	SUBFAMILY	Character	Subfamily of the taxon identified.
100	No	No	GENUS	Character	Genus of the taxon identified.
100	No	No	SPECIES	Character	Species of the taxon identified.
100	No	No	WORMS_ID	Number	Aphiaid of scientific name from World Register of Marine Species (WoRMS).
100	No	No	SCIENTIFICNAMEAUTHORSHIP	Character	Author who originally described the taxon.
100	No	No	SYNONYMS	Character	Other scientific names used for the observed taxon (not complete).
100	No	No	VESSEL	Character	Name of vessel used for collecting observation.
100	No	No	PI	Character	Principal Investigator of the project with which the video was collected.
100	No	No	PIAFFILIATION	Character	Affiliation of the Principal Investigator.
100	No	No	PURPOSE	Character	Purpose of the project with which the observation was collected.
100	No	No	SAMPLINGEQUIPMENT	Character	Type of equipment used (i.e. submersible or ROV).
100	No	No	VEHICLENAME	Character	Name of the submersible or ROV used to collected the video observation.
100	No	No	SAMPLEID	Number	The observation identification number of the record in the Video Annotation and Reference System (VARS) database.
100	No	No	DATACONTACT	Character	The name of the individual who is the primary representative of the data.
100	No	No	REPOSITORY	Character	Location where the video is stored.

Attribute Details

Attribute Name	LOCALITY
Seq. Order	1
Data Storage Type	Character
Max Length	13
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	General location of dive.
General Data Type	Character
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	Character
Max Length	6
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Dive number.
General Data Type	Character
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	Character
Max Length	9
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Tape number.
General Data Type	Character
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	Character
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	Character
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	Character
Max Length	29
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Taxonomic name.
General Data Type	Character
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	Character
Max Length	11
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Taxonomic rank.
General Data Type	Character
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	Character
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	Character
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	Character
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	Character
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	SIZEMEASUREMENT
Seq. Order	10
Data Storage Type	Character
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	Character
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	Character
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	Character
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	GENERALHABITAT
Seq. Order	12
Data Storage Type	Character
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	Character
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	Character
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	Character
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	HABITATCOMMENTS
Seq. Order	14
Data Storage Type	Character
Max Length	70
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Additional descriptions of terrain.
General Data Type	Character
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	Character
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	Character
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	Character
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	Character
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	Character
Max Length	63
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Taxa upon organism(s) observed.
General Data Type	Character
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	Character
Max Length	177
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Additional comments about the record.
General Data Type	Character
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	Character
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	Character
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	9
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	Time
Max Length	8
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Local time when the video observation was recorded.
General Data Type	Time
Unit of Measure
Case Restriction
Display Example
Format Mask	HH24:MM:SS
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	13
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	TIMETOTRACKPOINT_MIN
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	DEPTH_METERS
Seq. Order	29
Data Storage Type	Number
Max Length	9
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	Character
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	Character
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	Character
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	Character
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	Character
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	Character
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	PHYLUM
Seq. Order	33
Data Storage Type	Character
Max Length	13
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Phylum of the taxon identified.
General Data Type	Character
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	SUBPHYLUM
Seq. Order	34
Data Storage Type	Character
Max Length	11
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Subphylum of the taxon identified.
General Data Type	Character
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	SUPERCLASS
Seq. Order	35
Data Storage Type	Character
Max Length	14
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Superclass of the taxon identified.
General Data Type	Character
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	CLASS
Seq. Order	36
Data Storage Type	Character
Max Length	14
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Class of the taxon identified.
General Data Type	Character
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	SUBCLASS
Seq. Order	37
Data Storage Type	Character
Max Length	15
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Subclass of the taxon identified.
General Data Type	Character
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	INFRACLASS
Seq. Order	38
Data Storage Type	Character
Max Length	14
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Infraclass of the taxon identified.
General Data Type	Character
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	SUPERORDER
Seq. Order	39
Data Storage Type	Character
Max Length	14
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Superorder of the taxon identified.
General Data Type	Character
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	ORDER
Seq. Order	40
Data Storage Type	Character
Max Length	18
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Order of the taxon identified.
General Data Type	Character
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	SUBORDER
Seq. Order	41
Data Storage Type	Character
Max Length	16
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Suborder of the taxon identified.
General Data Type	Character
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	INFRAORDER
Seq. Order	42
Data Storage Type	Character
Max Length	9
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Infraorder of the taxon identified.
General Data Type	Character
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	SUPERFAMILY
Seq. Order	43
Data Storage Type	Character
Max Length	25
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Superfamily of the taxon identified.
General Data Type	Character
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	44
Data Storage Type	Character
Max Length	18
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Family of the taxon identified.
General Data Type	Character
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	SUBFAMILY
Seq. Order	45
Data Storage Type	Character
Max Length	15
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Subfamily of the taxon identified.
General Data Type	Character
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	46
Data Storage Type	Character
Max Length	17
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Genus of the taxon identified.
General Data Type	Character
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	SPECIES
Seq. Order	47
Data Storage Type	Character
Max Length	15
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Species of the taxon identified.
General Data Type	Character
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	Number
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	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	SCIENTIFICNAMEAUTHORSHIP
Seq. Order	49
Data Storage Type	Character
Max Length	39
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Author who originally described the taxon.
General Data Type	Character
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	Character
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	Character
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	Character
Max Length	19
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Name of vessel used for collecting observation.
General Data Type	Character
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	Character
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	Character
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	Character
Max Length	40
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Affiliation of the Principal Investigator.
General Data Type	Character
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	Character
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	Character
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	Character
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	Character
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	Character
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	Character
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	Number
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	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	DATACONTACT
Seq. Order	58
Data Storage Type	Character
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	Character
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	Character
Max Length	20
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Location where the video is stored.
General Data Type	Character
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	51135
Metadata Record Created By	Brent M Miyamoto
Metadata Record Created	2018-01-09 19:55+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	2019-07-23
Metadata Review Frequency	1 Year
Metadata Next Review Date	2020-07-23

Tags