Skip to content

Adding Platform to PlatformLookup

Revision History

  • Rev1 01-Jun-2021

Preliminaries

This doc describes how to create a new platform in the EXPD PlatformLookup table. We use 'self-discipline' to create unique id's that will be used as a 'foreign key'. These keys need to be kept the same for both expd and ssds databases.

Note

If you are trying to add a non-mbari ship to support minirov expeditions, please see: https://docs.mbari.org/internal/se-ie-doc/systems/expedition-database/expeditions-non-mbari-ships/

Get the Platform ID

First check if some form of the platform exists in expd using Aquadata Studio or equivalent.

select * from platformlookup

Warning

Only create new platform if it doesn’t already exist!!

If you truly need a new platform you must first create a new entry in SSDS by using the ssds web page at:

http://new-ssds.mbari.org/ssds/newDevice.jsp

You get to make-up a unique 4-5 character ‘shortname’ (it should be something easy to remember because you and other will likely use it often over the next 30+ years).

Then use the new SSDS DeviceId and your 'shortname' to create a new entry in the Expd PlatformLookup table using the query above and Aquadata Studio in 'edit mode'.