Item Identification

Title: 2005_LINEISLAND_HURL_DATABASE
Short Name: 2005_LINEISLAND_HURL_DATABASE
Status: Completed
Abstract:

Excel spreadsheet of extracted data of organisms recorded on video during 2005 HURL cruise.

Entity Information

Entity Type: Data Table
Active Version?: Yes
Description:

Excel spreadsheet of extracted data of organisms recorded on video during 2005 HURL cruise.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
LOCALITY Character General location of dive.
100
DIVE Character Dive number.
100
TAPE Character Tape number.
100
TAPETIMECODE Character Time into tape (hours:minutes:seconds:frames).
100
SCIENTIFICNAME Character Taxonomic name.
100
TAXONRANK Character Taxonomic rank.
100
IDENTIFICATIONREMARKS Character Comments on certainty of identification and/or additional distinguishing charateristics.
100
INDIVIDUALCOUNT Number Number of individuals. Measures are reported with a precision of 3.
100
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
SIZEMEASUREMENT Character Type of size estimate (i.e. total length, carapace width, test diameter, etc.).
100
MEGAHABITAT Character Major landform description (i.e. atoll, bank, conical seamount, guyot, island, ridge seamount, seamount, tablemount).
100
GENERALHABITAT Character Minor landform decription (i.e. canyon, crater, flank, pinnacle, ridge, summit, terrace).
100
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
HABITATCOMMENTS Character Additional descriptions of terrain.
100
SUBSTRATE Character Contact substrate of the organism(s) observed; may be geological or biological.
100
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
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
TEMPERATURE Number Temperature (degrees Celsius) from CTD. Measures are reported with a precision of 8.
100
SALINITY Number Salinity (practical salinity unit) from CTD. Measures are reported with a precision of 8.
100
OXYGEN Number Dissolved oxygen (mg/l) from CTD. Measures are reported with a precision of 9.
100
ASSOCIATEDTAXA Character Taxa upon organism(s) observed.
100
OCCURRENCEREMARKS Character Additional comments about the record.
100
MOVEMENT Character Description of submersible or ROV movement (i.e. descend, cruise, transect, or stationary).
100
OBSERVATIONDATE Date Local date when the video observation was recorded.
100
OBSERVATIONTIME Time Local time when the video observation was recorded.
100
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
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
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
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
DEPTHSOURCE Character Source of depth record (i.e. video overlay or CTD).
100
SPECIMEN Character The identification number for a collected specimen.
100
IMAGEFILEPATH Character Folder and image name of organism(s) observed. Multiple image names of same organism separated by semicolon.
100
PHYLUM Character Phylum of the taxon identified.
100
SUBPHYLUM Character Subphylum of the taxon identified.
100
SUPERCLASS Character Superclass of the taxon identified.
100
CLASS Character Class of the taxon identified.
100
SUBCLASS Character Subclass of the taxon identified.
100
INFRACLASS Character Infraclass of the taxon identified.
100
SUPERORDER Character Superorder of the taxon identified.
100
ORDER Character Order of the taxon identified.
100
SUBORDER Character Suborder of the taxon identified.
100
INFRAORDER Character Infraorder of the taxon identified.
100
SUPERFAMILY Character Superfamily of the taxon identified.
100
FAMILY Character Family of the taxon identified.
100
SUBFAMILY Character Subfamily of the taxon identified.
100
GENUS Character Genus of the taxon identified.
100
SPECIES Character Species of the taxon identified.
100
WORMS_ID Number Aphiaid of scientific name from World Register of Marine Species (WoRMS).
100
SCIENTIFICNAMEAUTHORSHIP Character Author who originally described the taxon.
100
SYNONYMS Character Other scientific names used for the observed taxon (not complete).
100
VESSEL Character Name of vessel used for collecting observation.
100
PI Character Principal Investigator of the project with which the video was collected.
100
PIAFFILIATION Character Affiliation of the Principal Investigator.
100
PURPOSE Character Purpose of the project with which the observation was collected.
100
SAMPLINGEQUIPMENT Character Type of equipment used (i.e. submersible or ROV).
100
VEHICLENAME Character Name of the submersible or ROV used to collected the video observation.
100
SAMPLEID Number The observation identification number of the record in the Video Annotation and Reference System (VARS) database.
100
DATACONTACT Character The name of the individual who is the primary representative of the data.
100
REPOSITORY Character Location where the video is stored.

Attribute Details

LOCALITY

CC ID: 710794
Seq. Order: 1
Data Storage Type: Character
Max Length: 13
Required: No
Primary Key: No
Status: Active
Description:

General location of dive.

General Data Type: Character

DIVE

CC ID: 710795
Seq. Order: 2
Data Storage Type: Character
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

Dive number.

General Data Type: Character

TAPE

CC ID: 710796
Seq. Order: 3
Data Storage Type: Character
Max Length: 9
Required: No
Primary Key: No
Status: Active
Description:

Tape number.

General Data Type: Character

TAPETIMECODE

CC ID: 710797
Seq. Order: 4
Data Storage Type: Character
Max Length: 11
Required: No
Primary Key: No
Status: Active
Description:

Time into tape (hours:minutes:seconds:frames).

General Data Type: Character

SCIENTIFICNAME

CC ID: 710798
Seq. Order: 5
Data Storage Type: Character
Max Length: 29
Required: No
Primary Key: No
Status: Active
Description:

Taxonomic name.

General Data Type: Character

TAXONRANK

CC ID: 710799
Seq. Order: 6
Data Storage Type: Character
Max Length: 11
Required: No
Primary Key: No
Status: Active
Description:

Taxonomic rank.

General Data Type: Character

IDENTIFICATIONREMARKS

CC ID: 710800
Seq. Order: 7
Data Storage Type: Character
Max Length: 170
Required: No
Primary Key: No
Status: Active
Description:

Comments on certainty of identification and/or additional distinguishing charateristics.

General Data Type: Character

INDIVIDUALCOUNT

CC ID: 710801
Seq. Order: 8
Data Storage Type: Number
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Number of individuals. Measures are reported with a precision of 3.

General Data Type: Number

SIZE_CM

CC ID: 710802
Seq. Order: 9
Data Storage Type: Character
Max Length: 15
Required: No
Primary Key: No
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

SIZEMEASUREMENT

CC ID: 710803
Seq. Order: 10
Data Storage Type: Character
Max Length: 61
Required: No
Primary Key: No
Status: Active
Description:

Type of size estimate (i.e. total length, carapace width, test diameter, etc.).

General Data Type: Character

MEGAHABITAT

CC ID: 710804
Seq. Order: 11
Data Storage Type: Character
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

Major landform description (i.e. atoll, bank, conical seamount, guyot, island, ridge seamount, seamount, tablemount).

General Data Type: Character

GENERALHABITAT

CC ID: 710805
Seq. Order: 12
Data Storage Type: Character
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

Minor landform decription (i.e. canyon, crater, flank, pinnacle, ridge, summit, terrace).

General Data Type: Character

HABITAT

CC ID: 710806
Seq. Order: 13
Data Storage Type: Character
Max Length: 40
Required: No
Primary Key: No
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

HABITATCOMMENTS

CC ID: 710807
Seq. Order: 14
Data Storage Type: Character
Max Length: 70
Required: No
Primary Key: No
Status: Active
Description:

Additional descriptions of terrain.

General Data Type: Character

SUBSTRATE

CC ID: 710808
Seq. Order: 15
Data Storage Type: Character
Max Length: 27
Required: No
Primary Key: No
Status: Active
Description:

Contact substrate of the organism(s) observed; may be geological or biological.

General Data Type: Character

SLOPE_DEGREES

CC ID: 710809
Seq. Order: 16
Data Storage Type: Character
Max Length: 19
Required: No
Primary Key: No
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

RUGOSITY

CC ID: 710810
Seq. Order: 17
Data Storage Type: Number
Max Length: 1
Required: No
Primary Key: No
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

TEMPERATURE

CC ID: 710811
Seq. Order: 18
Data Storage Type: Number
Max Length: 9
Required: No
Primary Key: No
Scale: 6
Status: Active
Description:

Temperature (degrees Celsius) from CTD. Measures are reported with a precision of 8.

General Data Type: Number

SALINITY

CC ID: 710812
Seq. Order: 19
Data Storage Type: Number
Max Length: 9
Required: No
Primary Key: No
Scale: 6
Status: Active
Description:

Salinity (practical salinity unit) from CTD. Measures are reported with a precision of 8.

General Data Type: Number

OXYGEN

CC ID: 710813
Seq. Order: 20
Data Storage Type: Number
Max Length: 10
Required: No
Primary Key: No
Scale: 8
Status: Active
Description:

Dissolved oxygen (mg/l) from CTD. Measures are reported with a precision of 9.

General Data Type: Number

ASSOCIATEDTAXA

CC ID: 710814
Seq. Order: 21
Data Storage Type: Character
Max Length: 63
Required: No
Primary Key: No
Status: Active
Description:

Taxa upon organism(s) observed.

General Data Type: Character

OCCURRENCEREMARKS

CC ID: 710815
Seq. Order: 22
Data Storage Type: Character
Max Length: 177
Required: No
Primary Key: No
Status: Active
Description:

Additional comments about the record.

General Data Type: Character

MOVEMENT

CC ID: 710816
Seq. Order: 23
Data Storage Type: Character
Max Length: 13
Required: No
Primary Key: No
Status: Active
Description:

Description of submersible or ROV movement (i.e. descend, cruise, transect, or stationary).

General Data Type: Character

OBSERVATIONDATE

CC ID: 710817
Seq. Order: 24
Data Storage Type: Date
Max Length: 9
Required: No
Primary Key: No
Status: Active
Description:

Local date when the video observation was recorded.

General Data Type: Date

OBSERVATIONTIME

CC ID: 710818
Seq. Order: 25
Data Storage Type: Time
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Local time when the video observation was recorded.

General Data Type: Time
Format Mask: HH24:MM:SS

LATITUDE

CC ID: 710819
Seq. Order: 26
Data Storage Type: Number
Max Length: 12
Required: No
Primary Key: No
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

LONGITUDE

CC ID: 710820
Seq. Order: 27
Data Storage Type: Number
Max Length: 13
Required: No
Primary Key: No
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

TIMETOTRACKPOINT_MIN

CC ID: 710821
Seq. Order: 28
Data Storage Type: Number
Max Length: 11
Required: No
Primary Key: No
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

DEPTH_METERS

CC ID: 710822
Seq. Order: 29
Data Storage Type: Number
Max Length: 9
Required: No
Primary Key: No
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

DEPTHSOURCE

CC ID: 710823
Seq. Order: 30
Data Storage Type: Character
Max Length: 13
Required: No
Primary Key: No
Status: Active
Description:

Source of depth record (i.e. video overlay or CTD).

General Data Type: Character

SPECIMEN

CC ID: 710824
Seq. Order: 31
Data Storage Type: Character
Max Length: 14
Required: No
Primary Key: No
Status: Active
Description:

The identification number for a collected specimen.

General Data Type: Character

IMAGEFILEPATH

CC ID: 710825
Seq. Order: 32
Data Storage Type: Character
Max Length: 128
Required: No
Primary Key: No
Status: Active
Description:

Folder and image name of organism(s) observed. Multiple image names of same organism separated by semicolon.

General Data Type: Character

PHYLUM

CC ID: 710826
Seq. Order: 33
Data Storage Type: Character
Max Length: 13
Required: No
Primary Key: No
Status: Active
Description:

Phylum of the taxon identified.

General Data Type: Character

SUBPHYLUM

CC ID: 710827
Seq. Order: 34
Data Storage Type: Character
Max Length: 11
Required: No
Primary Key: No
Status: Active
Description:

Subphylum of the taxon identified.

General Data Type: Character

SUPERCLASS

CC ID: 710828
Seq. Order: 35
Data Storage Type: Character
Max Length: 14
Required: No
Primary Key: No
Status: Active
Description:

Superclass of the taxon identified.

General Data Type: Character

CLASS

CC ID: 710829
Seq. Order: 36
Data Storage Type: Character
Max Length: 14
Required: No
Primary Key: No
Status: Active
Description:

Class of the taxon identified.

General Data Type: Character

SUBCLASS

CC ID: 710830
Seq. Order: 37
Data Storage Type: Character
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

Subclass of the taxon identified.

General Data Type: Character

INFRACLASS

CC ID: 710831
Seq. Order: 38
Data Storage Type: Character
Max Length: 14
Required: No
Primary Key: No
Status: Active
Description:

Infraclass of the taxon identified.

General Data Type: Character

SUPERORDER

CC ID: 710832
Seq. Order: 39
Data Storage Type: Character
Max Length: 14
Required: No
Primary Key: No
Status: Active
Description:

Superorder of the taxon identified.

General Data Type: Character

ORDER

CC ID: 710833
Seq. Order: 40
Data Storage Type: Character
Max Length: 18
Required: No
Primary Key: No
Status: Active
Description:

Order of the taxon identified.

General Data Type: Character

SUBORDER

CC ID: 710834
Seq. Order: 41
Data Storage Type: Character
Max Length: 16
Required: No
Primary Key: No
Status: Active
Description:

Suborder of the taxon identified.

General Data Type: Character

INFRAORDER

CC ID: 710835
Seq. Order: 42
Data Storage Type: Character
Max Length: 9
Required: No
Primary Key: No
Status: Active
Description:

Infraorder of the taxon identified.

General Data Type: Character

SUPERFAMILY

CC ID: 710836
Seq. Order: 43
Data Storage Type: Character
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

Superfamily of the taxon identified.

General Data Type: Character

FAMILY

CC ID: 710837
Seq. Order: 44
Data Storage Type: Character
Max Length: 18
Required: No
Primary Key: No
Status: Active
Description:

Family of the taxon identified.

General Data Type: Character

SUBFAMILY

CC ID: 710838
Seq. Order: 45
Data Storage Type: Character
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

Subfamily of the taxon identified.

General Data Type: Character

GENUS

CC ID: 710839
Seq. Order: 46
Data Storage Type: Character
Max Length: 17
Required: No
Primary Key: No
Status: Active
Description:

Genus of the taxon identified.

General Data Type: Character

SPECIES

CC ID: 710840
Seq. Order: 47
Data Storage Type: Character
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

Species of the taxon identified.

General Data Type: Character

WORMS_ID

CC ID: 710841
Seq. Order: 48
Data Storage Type: Number
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

Aphiaid of scientific name from World Register of Marine Species (WoRMS).

General Data Type: Number

SCIENTIFICNAMEAUTHORSHIP

CC ID: 710842
Seq. Order: 49
Data Storage Type: Character
Max Length: 39
Required: No
Primary Key: No
Status: Active
Description:

Author who originally described the taxon.

General Data Type: Character

SYNONYMS

CC ID: 710843
Seq. Order: 50
Data Storage Type: Character
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Other scientific names used for the observed taxon (not complete).

General Data Type: Character

VESSEL

CC ID: 710844
Seq. Order: 51
Data Storage Type: Character
Max Length: 19
Required: No
Primary Key: No
Status: Active
Description:

Name of vessel used for collecting observation.

General Data Type: Character

PI

CC ID: 710845
Seq. Order: 52
Data Storage Type: Character
Max Length: 16
Required: No
Primary Key: No
Status: Active
Description:

Principal Investigator of the project with which the video was collected.

General Data Type: Character

PIAFFILIATION

CC ID: 710846
Seq. Order: 53
Data Storage Type: Character
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Affiliation of the Principal Investigator.

General Data Type: Character

PURPOSE

CC ID: 710847
Seq. Order: 54
Data Storage Type: Character
Max Length: 160
Required: No
Primary Key: No
Status: Active
Description:

Purpose of the project with which the observation was collected.

General Data Type: Character

SAMPLINGEQUIPMENT

CC ID: 710848
Seq. Order: 55
Data Storage Type: Character
Max Length: 11
Required: No
Primary Key: No
Status: Active
Description:

Type of equipment used (i.e. submersible or ROV).

General Data Type: Character

VEHICLENAME

CC ID: 710849
Seq. Order: 56
Data Storage Type: Character
Max Length: 14
Required: No
Primary Key: No
Status: Active
Description:

Name of the submersible or ROV used to collected the video observation.

General Data Type: Character

SAMPLEID

CC ID: 710850
Seq. Order: 57
Data Storage Type: Number
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

The observation identification number of the record in the Video Annotation and Reference System (VARS) database.

General Data Type: Number

DATACONTACT

CC ID: 710851
Seq. Order: 58
Data Storage Type: Character
Max Length: 18
Required: No
Primary Key: No
Status: Active
Description:

The name of the individual who is the primary representative of the data.

General Data Type: Character

REPOSITORY

CC ID: 710852
Seq. Order: 59
Data Storage Type: Character
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Location where the video is stored.

General Data Type: Character

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: SysAdmin InPortAdmin
Metadata Record Last Modified: 2019-06-04 13:14+0000
Metadata Record Published: 2019-07-23
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2020-07-23