Changes between Version 6 and Version 7 of DatabaseBasedAnalysis

Timestamp:

08/03/18 17:24:26 (7 years ago)

Author:

tbretz

Comment:

--

DatabaseBasedAnalysis

@@ -85 +85 @@
    COUNT(*), 
    SUM(TIME_TO_SEC(TIMEDIFF(fRunStop,fRunStart))*fEffectiveOn/3600) AS EffOnTime, 
-   MIN(fZenithDistanceMin) AS ZdMin, 
-   MAX(fZenithDistanceMax) AS ZdMax 
+   MIN(fZenithDistanceMin) AS MinZd, 
+   MAX(fZenithDistanceMax) AS MaxZd,
+   MIN(fR750Cor/fR750Ref)  AS MinQ,
+   MAX(fR750Cor/fR750Ref)  AS MaxQ
 FROM 
    RunInfo 
@@ -99 +101 @@
 The result (in mysql) is
 {{{
-+----------+-------------+-------+-------+
-| COUNT(*) | EffOnTime   | ZdMin | ZdMax |
-+----------+-------------+-------+-------+
-|      435 | 32.53992354 |  6.36 | 67.89 |
-+----------+-------------+-------+-------+
++----------+-------------+-------+-------+---------+---------+
+| COUNT(*) | EffOnTime   | MinZd | MaxZd | MinQ    | MaxQ    |
++----------+-------------+-------+-------+---------+---------+
+|      435 | 32.53992354 |  6.36 | 67.89 | 0.01477 | 1.10584 |
++----------+-------------+-------+-------+---------+---------+
 1 row in set (0.01 sec)
 }}}
 
-So we have 435 data runs from Crab with a total effective observation time of 32.5 hrs in a zenith angle range between 6° and 68°.
+So we have 435 data runs from Crab with a total effective observation time of 32.5 hours in a zenith angle range between 6° and 68° and a bad weather factor between 0.01 (really bad) to 1.1 (extremely good).
+
+Taking only good data by adding {{{AND fR750Cor/fR750Ref>0.9}}} to the WHERE-clause gives us
+{{{
++----------+-------------+-------+-------+---------+---------+
+| COUNT(*) | EffOnTime   | ZdMin | ZdMax | MinQ    | MaxQ    |
++----------+-------------+-------+-------+---------+---------+
+|      328 | 24.58955887 |  6.36 | 67.86 | 0.90084 | 1.10584 |
++----------+-------------+-------+-------+---------+---------+
+1 row in set (0.00 sec)
+}}}
+
+But we also want to restrict ourselves to "good" zenith angles (zenith angles at which there is no significnat efficiency loss). So we add {{{AND fZenithDistanceMax<35}} to the WHERE-clause which yields
+{{{
++----------+-------------+-------+-------+---------+---------+
+| COUNT(*) | EffOnTime   | ZdMin | ZdMax | MinQ    | MaxQ    |
++----------+-------------+-------+-------+---------+---------+
+|      244 | 19.06608557 |  6.36 | 34.90 | 0.90084 | 1.10584 |
++----------+-------------+-------+-------+---------+---------+
+1 row in set (0.00 sec)
+}}}