Date: Thu, 5 Jan 2006 22:54:23 -0500 (EST)
From: Cullen H. Blake <cblake@cfa.harvard.edu>
To: Andrew Samuel Friedman <afriedma@cfa.harvard.edu>
Cc: Maryam Modjaz <mmodjaz@cfa.harvard.edu>
Subject: Re: Statistics

Hey Andy,

If you go to the databse you want, select the "Write Your Own Query"
button.

In the box that some up type something like below and hit "Execute Query":

select count(*) from obs where ObjID='SN.5' and IsDone=1

or

select count(*) from obs where Name='sn2005ao' and IsDone=1

You can type any sort of MySQL command in there. I've tried to set up
permissions so that it's difficult to delete or alter things, but be a
little careful when you're first playing around with the MySQL syntax.

-C

 

Date: Thu, 9 Feb 2006 22:38:32 -0500 (EST)
From: Cullen H. Blake <cblake@cfa.harvard.edu>
To: Andrew Samuel Friedman <afriedma@cfa.harvard.edu>
Subject: Re: Number of epochs in database vs. actual total exposure time

Hi Andy,

This syntax below would return only the executed observations. Something
like

select count(*) from obs where Name='sn2005hk' and IsDone=0

would give you the undone observations, and

select count(*) from obs where Name='sn2005hk'

would give you all the requested observations, done or not.

It does look like some time might be missing here. One thing that can
happen is that the observations might be underway and then interrupted by
a pointing tweak. That ends the observation, so the hours added to the
total is not large. Also, if observations are interrupted by a GRB the
same sort of thing happens. So, the total time and IsDone are only meant
to be updated after an observations is complete and the telescope moves on
to something else. You can also see the start and end time of the
observations in the database. It might be clear from looking at those that
some observations were cut short.

-C