Monterey Bay Aquarium Research Institute
Video Annotation and Reference System (VARS)
VARS Query User Guide

This guide is in three sections. This page is the Results section. Here are links to the other two sections:

Managing VARS Query results

Using MBARI data

Please see the MBARI Data Use Policy for information regarding data quality and use of data for research and publication.

Data table (Data tab)

Search results will automatically be entered into a table and displayed in a separate window on the desktop. The Data tab displays a table of the return information. Because the table is very wide, it is shown below in two sections.

datatable

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Sorting

Items in a column can be sorted by clicking on the column title. First click sorts in ascending order (upward pointing arrow), second click sorts in descending order (downward arrow), and third click restores the original results order.

Rearranging columns

To rearrange columns horizontally, click and hold at the top of a column, then drag it to the desired position.

Saving VARS Query Results

Save

Query results can be saved in a text file. To save the results, select the Save button on the Query Results window and a Save As dialog box appears. The data table is formatted as tab-delimited text. Save the file to your desired location, being certain to name the file with the .txt extension. You can then import the .txt file into common spreadsheet and statistics applications for further data analysis.

Save Images

Query results can be saved as a Google KML file for use in Google Earth and other geospatial visualization or mapping applications. Save the file to your desired location, being certain to name the file with the .kml extension.

Save Images

Images are listed in the table as web URLs. Double-click an entry to preview the image in a new window. Save the image from the window, using File > Save.

To save all the images from a query, click the Save Images button. In the dialog box, enter the path to the directory where the images will be stored. Images will automatically be saved in a folder hierarchy as follows: ROV name/Stills/Year/Year-day.

Query tab

The Query tab shows the database against which the Query was run and the SQL code used to execute the Query.

sql

Last updated: Apr. 21, 2015