Editing Features


Today I’m going to talk about editing and Q/A features. Some of these have been in Mysticetus for a while; others are very new. As Mysticetus expands into new arenas (multi-vessel tracking, etc.) new features are necessary to handle everything.


So reports aren’t technically a “Q/A” feature -but they are invaluable at pointing out subtle data entry issues. If you mis-entered a species or an observers name, or a distance wasn’t available for the Sightings Detail report (last week) – the reports will show that up instantly. The first thing to do when editing Mysticetus data is run some reports and see what looks wacko.

Right-Click Menus

Almost all the editing features in Mysticetus are accessed by right clicking on data, either the row header, the column header or a data cell itself.

Right clicking on a row header presents the option to insert a new row, or remove the row(s) selected:

Right clicking on the top of any column will pop up the following menu:

From this menu, you can tell Mysticetus to do one of three things:

  • Recalculate all the formulas in this column. This is useful if you’ve edited data and some formulas haven’t percolated all the way through the system yet.
  • Delete all rows containing (or not containing) some value. Mysticetus helpfully lists out the various values of this field for you to choose from. For example, if you wanted to only look at Harbor Porpoise sightings, you could choose to delete all rows that don’t contain Harbor Porpoise in the Species field.

If you click at the top of a Time field, an additional menu option, Change Time Zone is presented.

If you choose this option, Mysticetus will ask you which time zone you’d like for this field and apply it to all the items in the field:

Note that this does NOT change the underlying time data. It simply recalculates the time by applying the selected timezone. If you recorded a sighting at 13:33 in Pacific Time and then change to Alaska time, it will display as 12:33.

If you right click at the top of a Geo Position field (such as the GPS Position field shown below), the option to “Apply Track Position” will be shown. This option will scan the GPS track and apply the trackline position to all Geo Position fields appropriately (based on timestamp). This is a very useful feature if you are, for example, reconstructing a trackline from a backup GPS (say, you imported a GPX file from a handheld GPS).

If you click on an individual Geo Position field, it will give you a few options:

  • Apply Track Position. Like the previous editing option, but this only applies the track position to this single row.
  • Edit Position allows you to do some finely detailed editing of the Geo Position. A Geo Position field records (behind the scenes) altitude, heading and speed at the time the position was recorded. This is how you edit those fields.
  • Show position on Map does exactly that – it centers the map on the Geo Position.

Another useful editing tool is the Track trimming menu. Right click on a track on the map and you can delete the map either before or after where you clicked:


This is useful to splice together multiple tracklines into a single track.

These are just some of the editing and Q/A features in Mysticetus – there are even more advanced ones but they aren’t quite as simple as the ones listed here.

I hope everyone enjoyed their summer and are looking forward to winter.



Leave a Reply

Your email address will not be published. Required fields are marked *

one × 2 =