6. - 500049 Video Annotation and Reference System : Benthic Annotation Database This page last changed on Feb 21, 2008 by brian. ## Creating an database of benthic-only annotations Copy solstice:VARS to fog:VARS_Benthic Use the DTS Job on Fog: Copy Solstice:VARS to FOG:VARS_Benthic Brian Schlining: I last ran this on 2008-02-21 Check out VARS from Subversion `svn co https://vars.svn.sourceforge.net/svnroot/vars/trunk vars` Build VARS for the vdm database (located on Fog as VARS_Benthic) `mvn clean install -Denvironment=vdm -Dmaven.test.skip=true` Fog is updated every night from the VARS database on Solstice. This is a good database to work with since we can make changes and tests without breaking any production systems. Check out the vdm-tools from subversion `svn co svn+ssh://kahuna.shore.mbari.org/svn/repos/vdm-tools/trunk vdm-tools` Build the project `mvn clean package` The built applications will be in vdm-tools/target/vdm-tools-<VERSION>.zip Extract the zip file somewhere Add a table to the database you're working with
         CREATE TABLE [dbo].[VideoFrameMetadata] (
             [VideoFrameID_FK]	bigint NOT NULL,
             [Altitude]       	float NOT NULL,
             CONSTRAINT [FK_03] PRIMARY KEY([VideoFrameID_FK])
         )
         GO
Find a bathymetry file of the area you want to work with. The tool can read ASCII raster grids or netcdf files. An example netCDF file, `monterey_hrbath.nc`, is checked into Subversion with the project. cd to the `bin` directory where you extracted the zip file (from above) Run `gsh ../scripts/groovy/createbenthosdb1.groovy` For example: `gsh ../scripts/groovy/createbenthosdb1.groovy ../../../src/test/resources/monterey_hrbath.nc` This populates the table VideoFrameEmbargo with ids of all the `VideoFrames` within the grid files area and stores the altitudes. Run `gsh ../scripts/groovy/createbenthosdb5.groovy` This drops all the non-benthic data from the Association, Observation, PhysicalData, CameraData and VideoFrame tables. Brian Schlining: I ran this on 2008-02-21 Verify results. Brian Schlining: ongoing

Document generated by Confluence on Feb 03, 2026 12:59