About varspub.mbari.org

Varspub hosts the externally accessible IIS web server, VARS applications and MS SQL Server that hosts the external VARS database.

Embargoed Data

There is a DTS Package, 'Update VARS_External on VARSPUB', on Solstice used to copy annotations out for external use. The embargo SQL is executed in the 'Update Observations_Embargoed' phase.

September 2008

From Nancy Jacobsen-Stout:

This is a new embargo that was recently approved by Marcia for Karen Osborn, Flota and Green bomber.

Brian, the implementation in VARS should include the annotations and properties provided by Susan below. Please remove all of the annotations and images of such annotations from the public query. Flota should have an expiration of December 2008 and all of the green bomber's should have an expiration of December 2009.

From Susan Von Thun:

The worms of interest to Karen Osborn that we were talking about this morning are:
Flota (and it's children flota vitjazi and flota flabelligerida)
fabelligeridae |comment| self| Green bomber (or it maybe audio comment or comment | human|)
Polychaeta |comment| self | Green bomber (or it maybe audio comment or comment | human|)
For that matter, it could be any annelida with the green bomber in a comment

Also, at [~grch]'s request. I've embargoed the Macon dives.

The corresponding SQL is:

SELECT DISTINCT ObservationID_FK 
    FROM Annotations
    WHERE (
        (
            RecordedDate > DATEADD([year], - 2, GETDATE()) OR 
            RecordedDate IS NULL OR
            RecordedDate < CAST('1970-01-02' AS datetime)
        )
        OR (
            Observer = 'sbush' AND
            ConceptName LIKE 'octopoteuthis%'
        )
        OR (
            ConceptName LIKE 'plantoteuthis%' OR
            ConceptName LIKE 'bathyteuthis%' OR
            ConceptName LIKE 'grimalditeuthis%'
        )  
        OR (
            ConceptName = 'Flota' OR
            ConceptName LIKE 'flota %' OR 
            ConceptName LIKE 'flota-%'
        )
        OR (
            LinkValue LIKE '%green bomber%'
        )
        OR (
            RovName = 'Ventana' AND
            DiveNumber IN (50, 217, 218, 248)
        )
        OR (
            RovName = 'Tiburon' AND
            DiveNumber IN (1001, 1029, 1030, 1031, 1032, 1033, 1034)
        )
    )

July 2007

From Nancy Jacobsen-Stout:

I wanted to discuss some clarifications in Stephanie's embargo. I don't think these change the embargo itself, just a matter of implementation.

In testing to make sure her embargoes were not in the Public Query, we discovered that there are about 12-15 occurences of the very rare squid (all genera but Octopoteuthis are rare) that Stephanie is actively working on that are not embargoed.

Some of these do have Steph's username. The reason they show up is that only 'd' (for detail) are being embargoed, but some dives are designated as 'o' (for outline) and there is no way in VARS to change an individual annotation to 'd' even after she has modified/added to it. And we wouldn't want to change an entire dive to 'd' if only a few annotations are done in detail.

Some of those we found do not have Steph's username. When she goes back to review the video and annotations she wouldn't change the concept name if it was already correctly identified by a VL person (or someone else, e.g., at sea or from Robi lab). She might change or add an association (although she might not, if adequately annotated by VL already). The issue is that in VARS, even if an association is added by a new observer, but the concept name isn't changed, the original observer name remains. Nonetheless, she has reviewed these observations and they've become part of this current research.

For these reasons, I wonder if the embargo specification could be changed slightly to exclude all Planctoeuthis, Grimalditeuthis and Bathyteuthis. Again, there are only about 12-15 individuals of these ever seen (mostly Planctoteuthis sp.). All the above holds true for Octopoteuthis too, but that animal is much more common. The alternative to excluding the rare types would be to have Stephanie go back and actually change the concept names (even if already correct) and to keep up with this method for future annotations. There are currently about 230 annotation lines for those 12-15 individuals. This doesn't seem too practical.

The other thing that we realized is that these genus names should be extend to 'children' so observations to species, not just genus, are included.

The corresponding SQL is:

SELECT DISTINCT ObservationID_FK 
    FROM Annotations
    WHERE ((
            RecordedDate > DATEADD([year], - 2, GETDATE()) OR 
            RecordedDate IS NULL OR
            RecordedDate < CAST('1970-01-02' AS datetime)
        )
        OR (
            Observer = 'sbush' AND
            ConceptName LIKE 'octopoteuthis%'
        )
        OR (
            ConceptName LIKE 'plantoteuthis%' OR
            ConceptName LIKE 'bathyteuthis%' OR
            ConceptName LIKE 'grimalditeuthis%'
        )  
    )

June 2007

Brian Schlining I update the embargoed SQL script (which is hosted as a DTS job on Solsice -> 'Update VARS_External on VARSPUB'). The new SQL is:

SELECT DISTINCT ObservationID_FK 
    FROM Annotations
    WHERE ((
            RecordedDate > DATEADD([year], - 2, GETDATE()) OR 
            RecordedDate IS NULL OR
            RecordedDate < CAST('1970-01-02' AS datetime)
        )
        OR (
            Observer = 'sbush' AND (
                ConceptName LIKE 'octopoteuthis%' OR
                ConceptName LIKE 'plantoteuthis%' OR
                ConceptName LIKE 'bathyteuthis%' OR
                ConceptName LIKE 'grimalditeuthis%'
            )
        )  
    )

Data on the external database is a subset of the internal database subjected to some embargo rules. The offical embargoed data page is http://mww.mbari.org/rd/Science/Embargo/embargoes.htm but it is not currently (as of 2007-04-10) up to date. The data is embargoed as follows:

April 2007

Date: April 10, 2007 10:32:30 AM PDT

Until April 2009 Stephanie Bush's (but no other annotators') detailed annotations on Octopoteuthis, Planctoteuthis, Bathyteuthis, and Grimalditeuthis

Until June 2007 Karen Osborn Munnopsidae Within Order Isopoda
Suborder Asellota
Suborder Valvifera
-Family Munnopsidae
Genus Acanthamunnopsis
Subfamily Munnopsinae
Genus Munneurycope
o Genus Munnopsis

Until June 2007 Praya and Apolemia

Until June 2007 Gonatus and Dosidicus

Until June 2007 salps and doliolids

Judith L. Connor, Ph.D.

The corresponding SQL is:

SELECT DISTINCT ObservationID_FK 
    FROM Annotations
    WHERE ((
            RecordedDate > DATEADD([year], - 2, GETDATE()) OR 
            RecordedDate IS NULL OR
            RecordedDate < CAST('1970-01-02' AS datetime)
        )
        OR (
            Observer = 'sbush' AND (
                ConceptName LIKE 'octopoteuthis%' OR
                ConceptName LIKE 'plantoteuthis%' OR
                ConceptName LIKE 'bathyteuthis%' OR
                ConceptName LIKE 'grimalditeuthis%'
            )
        )  
        OR (
            Observer = 'oska' AND (
                ConceptName LIKE 'asellota%' OR
                ConceptName LIKE 'valvifera%' OR
                ConceptName LIKE 'munnopsidae%' OR
                ConceptName LIKE 'acanthamunnopsis%' OR
                ConceptName LIKE 'munnopsinae%' OR
                ConceptName LIKE 'munneurycope%' OR
                ConceptName LIKE 'munnopsis%'
            )
        )
        OR (
            ConceptName LIKE 'praya%' OR
            ConceptName LIKE 'apolemia%' OR
            ConceptName LIKE 'gonatus%' OR
            ConceptName LIKE 'salp%' OR
            ConceptName LIKE 'doliolid%'
        )
    )