Annotation Database Cruise Status

From MediaWiki
Revision as of 18:25, 5 January 2024 by Rob (talk | contribs)
Jump to navigation Jump to search

Importing cruises into the database is a multi-step process involving multiple people and many pieces of data. This page keeps track of the cruises and their status with respect to the database and the import process.

Import Status of Cruises
Cruise Status Metadata Crew Dives Transects Navigation Telemetry Water Properties Status Comments Measurements Annotations Annotation Software
PAC2000-031 Imported Yes Yes Yes No Yes Depth No No No No Observations, Habitat VideoMiner
PAC2008-011 Imported Yes Yes Yes No Yes Depth No No No No No
PAC2008-024 Imported Yes Yes Yes Yes Yes Sound Velocity No No Yes No Observations, Habitat Custom Access
PAC2008-057 Imported Yes Yes Yes No Yes Depth No No No No No
PAC2009-013 Imported Yes Yes Yes Yes Yes Depth No Yes No No Observations Informal
PAC2009-024
PAC2009-044
PAC2009-062
PAC2010-009
PAC2010-009
PAC2010-043
PAC2010-009
PAC2010-074
PAC2011-006
PAC2011-062
PAC2011-072
PAC2011-073
PAC2012-008
PAC2012-014
PAC2012-035
PAC2012-043
PAC2012-068
PAC2013-011
PAC2013-062(063)
PAC2013-068
PAC2013-070
PAC2014-037
PAC2014-059
PAC2015-013
PAC2015-048
PAC2015-051
PAC2015-053
PAC2016-026
PAC2016-063
PAC2017-021
PAC2017-030
PAC2017-036
PAC2017-094
PAC2018-007 Imported Yes Yes Yes No Yes Depth No Yes Yes No Observations, Habitat VideoMiner
PAC2018-075 Imported Yes Yes Yes Yes Yes Depth No Yes Yes FOV, Laser Distance Observations, Habitat Custom Access
PAC2019-014
PAC2019-015 Imported Yes Yes Yes Yes Yes Depth, Heading, Altitude, Zoom No Yes No No Observations, Habitat Biigle
PAC2021-035 Imported Yes Yes Yes Yes Yes Heading, Altitude, Zoom Temperature Yes Yes No Observations, Habitat Biigle
PAC2021-036
PAC2021-054
PAC2022-005
PAC2021-036

Notes

PAC2008-024

One of the Access files cannot be opened with current versions of Access. Each of the 5 legs have different protocols.

PAC2018-007

The Access database is based on the standard VideoMiner structure with several pivoted columns containing an abundance level for a single species. These have been pivoted back into the main table structure (as extra rows) and imported in the standard way. The 'NA' value is also converted into empty cells.