Slide Menu
Jump to Section...
Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
PIFSC Metadata Library > PIFSC Fisheries Research and Monitoring Divisio... > Life History Program > Archival > Biodiversity and Habitat Data Extracted from Vi... >

LINE_ISLAND_2005_HURL

Entity (ENT)  |  Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:51136  |  Updated: February 13, 2025  |  Published / External 

Item Identification

Title: LINE_ISLAND_2005_HURL
Short Name: LINE_ISLAND_2005_HURL
Status: Completed
Abstract:

Oracle table of extracted data of organisms recorded on video during 2005 HURL cruise.

Entity Information

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

Oracle table of extracted data of organisms recorded on video during 2005 HURL cruise.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 GENERAL_LOCALITY VARCHAR2 General location of dive.
100
 DIVE VARCHAR2 Dive number.
100
 TAPE VARCHAR2 Tape number.
100
 TAPETIMECODE VARCHAR2 Time into tape (hours:minutes:seconds:frames).
100
 SCIENTIFICNAME VARCHAR2 Taxonomic name.
100
 TAXONRANK VARCHAR2 Taxonomic rank.
100
 IDENTIFICATIONREMARKS VARCHAR2 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 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
 SIZE_MEASUREMENT VARCHAR2 Type of size estimate (i.e. total length, carapace width, test diameter, etc.).
100
 MEGAHABITAT VARCHAR2 Major landform description (i.e. atoll, bank, conical seamount, guyot, island, ridge seamount, seamount, tablemount).
100
 GENERAL_HABITAT VARCHAR2 Minor landform decription (i.e. canyon, crater, flank, pinnacle, ridge, summit, terrace).
100
 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
 HABITAT_COMMENTS VARCHAR2 Additional descriptions of terrain.
100
 SUBSTRATE VARCHAR2 Contact substrate of the organism(s) observed; may be geological or biological.
100
 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
 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 VARCHAR2 Taxa upon organism(s) observed.
100
 OCCURRENCEREMARKS VARCHAR2 Additional comments about the record.
100
 MOVEMENT VARCHAR2 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 VARCHAR2 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
 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
 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
 DEPTHSOURCE VARCHAR2 Source of depth record (i.e. video overlay or CTD).
100
 SPECIMEN VARCHAR2 The identification number for a collected specimen.
100
 IMAGEFILEPATH VARCHAR2 Folder and image name of organism(s) observed. Multiple image names of same organism separated by semicolon.
100
 TAX_PHYLUM VARCHAR2 Phylum of the taxon identified.
100
 TAX_SUBPHYLUM VARCHAR2 Subphylum of the taxon identified.
100
 TAX_SUPERCLASS VARCHAR2 Superclass of the taxon identified.
100
 TAX_CLASS VARCHAR2 Class of the taxon identified.
100
 TAX_SUBCLASS VARCHAR2 Subclass of the taxon identified.
100
 TAX_INFRACLASS VARCHAR2 Infraclass of the taxon identified.
100
 TAX_SUPERORDER VARCHAR2 Superorder of the taxon identified.
100
 TAX_ORDER VARCHAR2 Order of the taxon identified.
100
 TAX_SUBORDER VARCHAR2 Suborder of the taxon identified.
100
 TAX_INFRAORDER VARCHAR2 Infraorder of the taxon identified.
100
 TAX_SUPERFAMILY VARCHAR2 Superfamily of the taxon identified.
100
 TAX_FAMILY VARCHAR2 Family of the taxon identified.
100
 TAX_SUBFAMILY VARCHAR2 Subfamily of the taxon identified.
100
 TAX_GENUS VARCHAR2 Genus of the taxon identified.
100
 TAX_SPECIES VARCHAR2 Species of the taxon identified.
100
 WORMS_ID VARCHAR2 Aphiaid of scientific name from World Register of Marine Species (WoRMS).
100
 SCIENTIFICNAMEAUTHORSHIP VARCHAR2 Author who originally described the taxon.
100
 SYNONYMS VARCHAR2 Other scientific names used for the observed taxon (not complete).
100
 VESSEL VARCHAR2 Name of vessel used for collecting observation.
100
 PI VARCHAR2 Principal Investigator of the project with which the video was collected.
100
 PIAFFILIATION VARCHAR2 Affiliation of the Principal Investigator.
100
 PURPOSE VARCHAR2 Purpose of the project with which the observation was collected.
100
 SAMPLINGEQUIPMENT VARCHAR2 Type of equipment used (i.e. submersible or ROV).
100
 VEHICLENAME VARCHAR2 Name of the submersible or ROV used to collected the video observation.
100
 SAMPLEID VARCHAR2 The observation identification number of the record in the Video Annotation and Reference System (VARS) database.
100
 DATACONTACT VARCHAR2 The name of the individual who is the primary representative of the data.
100
 REPOSITORY VARCHAR2 Location where the video is stored.

Attribute Details

GENERAL_LOCALITY

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

General location of dive.
General Data Type: VARCHAR2

DIVE

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

Dive number.
General Data Type: VARCHAR2

TAPE

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

Tape number.
General Data Type: VARCHAR2

TAPETIMECODE

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

Time into tape (hours:minutes:seconds:frames).
General Data Type: VARCHAR2

SCIENTIFICNAME

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

Taxonomic name.
General Data Type: VARCHAR2

TAXONRANK

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

Taxonomic rank.
General Data Type: VARCHAR2

IDENTIFICATIONREMARKS

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

Comments on certainty of identification and/or additional distinguishing charateristics.
General Data Type: VARCHAR2

INDIVIDUALCOUNT

CC ID: 710860
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: 710861
Seq. Order: 9
Data Storage Type: VARCHAR2
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: VARCHAR2
Unit of Measure: centimeter

SIZE_MEASUREMENT

CC ID: 710862
Seq. Order: 10
Data Storage Type: VARCHAR2
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: VARCHAR2

MEGAHABITAT

CC ID: 710863
Seq. Order: 11
Data Storage Type: VARCHAR2
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: VARCHAR2

GENERAL_HABITAT

CC ID: 710864
Seq. Order: 12
Data Storage Type: VARCHAR2
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: VARCHAR2

HABITAT

CC ID: 710865
Seq. Order: 13
Data Storage Type: VARCHAR2
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: VARCHAR2

HABITAT_COMMENTS

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

Additional descriptions of terrain.
General Data Type: VARCHAR2

SUBSTRATE

CC ID: 710867
Seq. Order: 15
Data Storage Type: VARCHAR2
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: VARCHAR2

SLOPE_DEGREES

CC ID: 710868
Seq. Order: 16
Data Storage Type: VARCHAR2
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: VARCHAR2
Unit of Measure: degrees

RUGOSITY

CC ID: 710869
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: 710870
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: 710871
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: 710872
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: 710873
Seq. Order: 21
Data Storage Type: VARCHAR2
Max Length: 63
Required: No
Primary Key: No
Status: Active
Description:

Taxa upon organism(s) observed.
General Data Type: VARCHAR2

OCCURRENCEREMARKS

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

Additional comments about the record.
General Data Type: VARCHAR2

MOVEMENT

CC ID: 710875
Seq. Order: 23
Data Storage Type: VARCHAR2
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: VARCHAR2

OBSERVATIONDATE

CC ID: 710876
Seq. Order: 24
Data Storage Type: DATE
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Local date when the video observation was recorded.
General Data Type: DATE

OBSERVATIONTIME

CC ID: 710877
Seq. Order: 25
Data Storage Type: VARCHAR2
Max Length: 17
Required: No
Primary Key: No
Status: Active
Description:

Local time when the video observation was recorded.
General Data Type: VARCHAR2

LATITUDE

CC ID: 710878
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: 710879
Seq. Order: 27
Data Storage Type: NUMBER
Max Length: 17
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

MINUTES_TO_TRACK_POINT

CC ID: 710880
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

DEPTHINMETERS

CC ID: 710881
Seq. Order: 29
Data Storage Type: NUMBER
Max Length: 8
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: 710882
Seq. Order: 30
Data Storage Type: VARCHAR2
Max Length: 13
Required: No
Primary Key: No
Status: Active
Description:

Source of depth record (i.e. video overlay or CTD).
General Data Type: VARCHAR2

SPECIMEN

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

The identification number for a collected specimen.
General Data Type: VARCHAR2

IMAGEFILEPATH

CC ID: 710884
Seq. Order: 32
Data Storage Type: VARCHAR2
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: VARCHAR2

TAX_PHYLUM

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

Phylum of the taxon identified.
General Data Type: VARCHAR2

TAX_SUBPHYLUM

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

Subphylum of the taxon identified.
General Data Type: VARCHAR2

TAX_SUPERCLASS

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

Superclass of the taxon identified.
General Data Type: VARCHAR2

TAX_CLASS

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

Class of the taxon identified.
General Data Type: VARCHAR2

TAX_SUBCLASS

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

Subclass of the taxon identified.
General Data Type: VARCHAR2

TAX_INFRACLASS

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

Infraclass of the taxon identified.
General Data Type: VARCHAR2

TAX_SUPERORDER

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

Superorder of the taxon identified.
General Data Type: VARCHAR2

TAX_ORDER

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

Order of the taxon identified.
General Data Type: VARCHAR2

TAX_SUBORDER

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

Suborder of the taxon identified.
General Data Type: VARCHAR2

TAX_INFRAORDER

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

Infraorder of the taxon identified.
General Data Type: VARCHAR2

TAX_SUPERFAMILY

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

Superfamily of the taxon identified.
General Data Type: VARCHAR2

TAX_FAMILY

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

Family of the taxon identified.
General Data Type: VARCHAR2

TAX_SUBFAMILY

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

Subfamily of the taxon identified.
General Data Type: VARCHAR2

TAX_GENUS

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

Genus of the taxon identified.
General Data Type: VARCHAR2

TAX_SPECIES

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

Species of the taxon identified.
General Data Type: VARCHAR2

WORMS_ID

CC ID: 710900
Seq. Order: 48
Data Storage Type: VARCHAR2
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: VARCHAR2

SCIENTIFICNAMEAUTHORSHIP

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

Author who originally described the taxon.
General Data Type: VARCHAR2

SYNONYMS

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

Other scientific names used for the observed taxon (not complete).
General Data Type: VARCHAR2

VESSEL

CC ID: 710903
Seq. Order: 51
Data Storage Type: VARCHAR2
Max Length: 21
Required: No
Primary Key: No
Status: Active
Description:

Name of vessel used for collecting observation.
General Data Type: VARCHAR2

PI

CC ID: 710904
Seq. Order: 52
Data Storage Type: VARCHAR2
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: VARCHAR2

PIAFFILIATION

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

Affiliation of the Principal Investigator.
General Data Type: VARCHAR2

PURPOSE

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

Purpose of the project with which the observation was collected.
General Data Type: VARCHAR2

SAMPLINGEQUIPMENT

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

Type of equipment used (i.e. submersible or ROV).
General Data Type: VARCHAR2

VEHICLENAME

CC ID: 710908
Seq. Order: 56
Data Storage Type: VARCHAR2
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: VARCHAR2

SAMPLEID

CC ID: 710909
Seq. Order: 57
Data Storage Type: VARCHAR2
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: VARCHAR2

DATACONTACT

CC ID: 710910
Seq. Order: 58
Data Storage Type: VARCHAR2
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: VARCHAR2

REPOSITORY

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

Location where the video is stored.
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 51136
GUID: gov.noaa.nmfs.inport: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 Review Frequency: 1 Year