All public logs

Combined display of all available logs of MediaWiki. You can narrow down the view by selecting a log type, the username (case-sensitive), or the affected page (also case-sensitive).

18:15, 18 June 2025 Rob talk contribs created page 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...")
17:56, 22 May 2025 User account Merlinbest talk contribs was created by Rob talk contribs and password was sent by email (Giving you the ability to edit the wiki. Once the account is approved I can give you rights.)
00:41, 7 May 2025 Rob talk contribs created page 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...")
23:37, 6 May 2025 Rob talk contribs created page 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...")
23:27, 2 May 2025 Rob talk contribs created page 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.")
16:09, 9 April 2025 Rob talk contribs created page 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''...")
22:53, 1 March 2025 Rob talk contribs created page Label Mapping (Label mapping information.)
22:06, 30 October 2024 Rob talk contribs created page 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...")
20:55, 10 October 2024 Rob talk contribs created page 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...")
00:17, 2 October 2024 Rob talk contribs changed group membership for Maya from (none) to administrator, interface administrator and bureaucrat
00:16, 2 October 2024 Rob talk contribs changed group membership for Bproudfoot from (none) to administrator, interface administrator and bureaucrat
00:16, 2 October 2024 Rob talk contribs changed group membership for GCLYDE from (none) to administrator, interface administrator and bureaucrat
00:15, 2 October 2024 Rob talk contribs changed group membership for GwynTaylor from (none) to administrator, interface administrator and bureaucrat
00:15, 2 October 2024 Rob talk contribs changed group membership for Rob from bureaucrat, interface administrator and administrator to bureaucrat, interface administrator, administrator, bot and suppressor
21:58, 7 December 2023 Rob talk contribs created page Annotation Database Cruise Status (Created page with "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. {| class="wikitable" |+ Caption text |- ! Cruise !! Metadata !! Crew !! Dives !! Transects !! Navigation !! Telemetry !! Water Properties !! Status !! Comments !! Measurements !! Annotations !! Annotation Software |- | PAC2000-031 || Yes || Yes || Yes || N...")
18:44, 5 December 2023 Rob talk contribs created page Standard Timestamp Format (Created page with "Timestamps used in database import scripts and files are always rendered in [https://en.wikipedia.org/wiki/ISO_8601 ISO 8601] format. This creates timestamps in the form, <code>2010-10-21T17:01:22Z</code> for a date with time and <code>2010-10-21</code> for just a date. There are several benefits to this format: * MS Excel won't mangle it; * It sorts correctly; * The fields are unambiguous; * It is easy to parse with Python or R. All timestamps are converted into UTC f...")
18:25, 5 December 2023 Rob talk contribs created page Annotation Database Import for Principal Investigators (Created page with "= Background = TBD")
17:52, 27 November 2023 Rob talk contribs created page Annotation Database Website (Created page with "= Background = The annotation database Website runs on a [https://www.djangoproject.com/ Django] (Python) backend with a [https://vuejs.org/ Vue 3] (JavaScript, CSS, HTML) frontend. == Django == The backend runs on Django with some small modifications to the structure. === Configuration === Rather than a single settings file (the default), the server uses one of four configuration files stored in the <code>settings</code> folder, each of which inherits from a base...")
19:08, 22 November 2023 Rob talk contribs created page Label Tree Files (Created page with "= Background = Label tree files describe labels extracted from annotations in one of the variety of forms that are not Biigle (e.g., CSV files, VideoMiner or Access Databases). They are extracted using the <code>[https://gitlab.com/rskelly/msea-rov-db/-/blob/main/import/importer2/utils/csv_extract_labels.py csv_extract_labels.py]</code> and <code>[https://gitlab.com/rskelly/msea-rov-db/-/blob/main/import/importer2/utils/vm_extract_labels.py vm_extract_labels.py]</code>.")
19:02, 22 November 2023 Rob talk contribs created page Annotation Database Import for Annotators (Created page with "TODO: Label Tree Files.")
00:01, 17 November 2023 Rob talk contribs created page Annotation Database Import App (Created page with "= Background = Data for import is produced by principal investigators, annotators and NDST. As a final step, the importer will combine all of this data into a single importable dataset. There are three steps for this final import process. == Downloading Import Data == The [https://msea.dijital.ca/rov/admin/import_queue database import queue]...")
18:17, 14 November 2023 Rob talk contribs created page Annotation Database APIs (Created page with "There are several [https://en.wikipedia.org/wiki/REST ReST] endpoints for accessing data in the annotation database. These can be provided for users within MSEA, or requested by users outside of MSEA who consume this data. == API Usage == These endpoints are accessed using [https://developer.mozilla.org/en-US/docs/Web/HTTP/Methods HTTP requests] by whatever method, be it an [https://cran.r-project.org/web/packages/request/request.pdf R] or [https://docs.python-request...")
17:41, 14 November 2023 Rob talk contribs moved page Database Entity Documentation to Annotation Database Entity Documentation (More specific title.)
17:40, 14 November 2023 Rob talk contribs moved page Deployment to Annotation Database Deployment (More specific title.)
21:30, 10 November 2023 Rob talk contribs created page Dive Logging App (Created page with "= Overview = The [https://msea.science/Dive-Logging-App/ Dive Logging App] is a [https://www.rstudio.com/products/shiny/ Shiny] app that allows the user to enter cruise, dive and transect metadata, personnel and equipment configuration. The process can appear quite complex, as the intention is to create a relational structure that can be imported into the main database. By following the given process, this information can be entered with a minimum of fuss. The applicat...")
02:06, 10 November 2023 Rob talk contribs created page Tile Server (Created page with "= Mapnik = = mod_tile = = renderd = = Coordinate Reference Systems and Projections = The data stored in the database and in raster form is very precisely referenced using Canada's official coordinate reference system, NAD83(CSRS) and vertical datum, CGVD2013. Some elevations are measured with respect to the local chart datum, and are calculated using a shift grid from CGVD2013 heights. Due to isostatic rebound and plate tectonics, all positions move with respect to...")
01:47, 10 November 2023 Rob talk contribs created page Deployment (Created page with "The database, utilities and website are all stored in the same [https://gitlab.com/rskelly/msea-rov-db git repository], which is checked out on the server machine and deployed using a single script, [https://gitlab.com/rskelly/msea-rov-db/-/blob/main/app/server_config/install.sh install.sh]. The script is run from the command line with no arguments, at which point it will prompt the user to type <code>stage</code> or <code>prod</code>. If the former, the application is...")
00:21, 10 November 2023 Rob talk contribs created page Annotation database user management (Add user management content.)
23:35, 9 November 2023 Rob talk contribs created page MediaWiki:Common.css (Update logo container style.)
22:04, 8 November 2023 Rob talk contribs created page Database Entity Documentation (Created page with "This page contains database entity documentation generated from the production database by the script, [https://gitlab.com/rskelly/msea-rov-db/-/blob/main/model/db_extract_docs.py db_extract_docs.py]. The documentation is arranged into conceptual groupings with the following structure. * Grouping ** Schema *** Table *** Materialized View *** View System and Django tables aren't included. The ID column of each table is also excluded. ...")
21:01, 7 November 2023 Rob talk contribs created page Annotation Database (Progress on database content.)
18:57, 7 November 2023 Rob talk contribs created page Annotation Database Import (Progress on content.)
18:34, 7 November 2023 Rob talk contribs created page Annotation Database User Management (Information about user creation.)

All public logs

Navigation menu