User contributions for Rob

18:1818:18, 18 June 2025 diff hist +204‎ Cache Tables ‎No edit summary current
18:1518:15, 18 June 2025 diff hist +1,271‎ N Cache Tables ‎ Created page with "There are several cached tables in the schema <cache>cache</cache> used by the website, and made available for reporting: {| class="wikitable" |+ Cache Tables |- ! Table Name !! Description |- | cruise_stats || Counts of various entities assigned to a cruise: events, measurements, positions, etc. |- | cruise_track || Geographic track lines tracing all dives during a cruise. Not very useful due to dives being widely dispersed. |- | dive_track|| Geographic track lines tra..."

00:4100:41, 7 May 2025 diff hist +5,419‎ N Import Data ‎ Created page with "Cruise data are imported through a [https://msea.science/rov/administration/rov/cruise_import single form] on the [https://msea.science/rov/ annotation website]. The form is hierarchical and allows the importer to progressively add nested entities starting with the cruise itself. There are four important sections of the form, '''Cruise Metadata''', '''Import''', '''Data Replacement''' and '''Bulk Data Upload'''. = Cruise Metadata = The form begins with a panel for ins..." current

23:3823:38, 6 May 2025 diff hist −3,674‎ Annotation Database Import ‎No edit summary current
23:3723:37, 6 May 2025 diff hist +2,931‎ N Preparation of Import Data ‎ Created page with "Data to be loaded into the database must be cleaned and prepared. There are several types of data that can be imported: # Metadata. # Streams. ## 3D Positions. ## 2D Positions. ## Measurements. # Annotations. # Comments. # Statuses. === Metadata === Metadata are the single type of data that cannot be automatically imported from files, but must be input into the import form manually. The entities that can accept metadata are, * Cruises. * Dives. * Tra..." current

23:2823:28, 2 May 2025 diff hist −1‎ Importing ‎No edit summary current
23:2723:27, 2 May 2025 diff hist +133‎ N Importing ‎ Created page with "This page will be about using the [https://msea.science/rov/administration/rov/cruise%20import survey import form] to import surveys."
22:5222:52, 2 May 2025 diff hist +60‎ Label Mapping ‎ →‎Generic Labels current
22:5222:52, 2 May 2025 diff hist +805‎ Label Mapping ‎ →‎Generic Labels
22:4322:43, 2 May 2025 diff hist +163‎ Main Page ‎ →‎Submersible Video/Photo Annotation Database

16:0916:09, 9 April 2025 diff hist +646‎ N Standard Units ‎ Created page with "= Standard Units = These are the standard units used in the database. Data should be converted during ingestion. For each property, the bolded unit is the correct one. ===== Conductivity ===== * mho/cm * '''mScm (mS/cm)''' * uScm ==== Specific Conductivity ==== * Scm * uScm ==== Dissolved Oxygen ==== * umol/kg * '''ml/L''' ==== Oxygen Concentration ==== Same as above? * ml/L * mg/L ==== Oxygen Saturation ==== * ml/L * mg/L * % ==== Pressure ==== * '''dbar''..." current
16:0516:05, 9 April 2025 diff hist +38‎ Main Page ‎ →‎Submersible Video/Photo Annotation Database

22:5322:53, 1 March 2025 diff hist +6,870‎ N Label Mapping ‎ Label mapping information.

22:0722:07, 30 October 2024 diff hist −33‎ Linking to SeaTube ‎ →‎Linking to SeaTube Videos current
22:0622:06, 30 October 2024 diff hist +1,537‎ N Linking to SeaTube ‎ Created page with "== Linking to SeaTube Videos == SeaTube hosts video streams and data from dives conducted by Fisheries and Oceans and other marine science organisations. Each dive in the annotation database, and each timestamped observation and measurement, can be linked to a precise time in a video stream on SeaTube. SeaTube dive IDs can be added to each dive record by setting the SeaTube ID field during import or updating it afterwards. SeaTube dives are linked from the cruises pa..."
21:5421:54, 30 October 2024 diff hist −60‎ Main Page ‎ →‎Submersible Video/Photo Annotation Database

20:5520:55, 10 October 2024 diff hist +5,398‎ N Annotation Database Import Checklist ‎ Created page with "There are many pieces of data that go together to make a complete import package. Some cruises will not have all of this data available, and some will be complete. Some types of data are dependent on others. == Cruise Metadata == These are items that relate specifically to the cruise itself. # Name - the unique name of the cruise, usually something like PAC2023-031. # Leg - a cruise can have more than one "leg" or segment, numbered from 1. # Start and end date. # Obj..." current
20:1920:19, 10 October 2024 diff hist +73‎ Main Page ‎ →‎Submersible Video/Photo Annotation Database