Changes between Version 11 and Version 12 of DatabaseBasedAnalysis/Examples

Timestamp:

08/15/18 10:34:51 (7 years ago)

Author:

tbretz

Comment:

--

DatabaseBasedAnalysis/Examples

@@ -1 +1 @@
 [[TOC]]
 
+
+== Good weather Crab data ==
+
+You want to create a file with good weather data with zenith distance smaller than 35° of Crab of the season 2017/18. The file should contain most of the image parameters with no cuts applied so that you can optimize cuts.
+
+{{{#!spoiler
+{{{#!sql
+SELECT
+   Events.MeanX,
+   Events.MeanY,
+   Events.Width,
+   Events.Length,
+   Events.CosDelta,
+   Events.SinDelta,
+   Events.M3Long,
+   Events.SlopeLong,
+   Events.Leakage1,
+   Events.NumIslands,
+   Events.NumUsedPixels,
+   Events.Size,
+   Events.SlopeSpread,
+   Events.SlopeSpreadWeighted,
+   Events.TimeSpread,
+   Events.TimeSpreadWeighted,
+   Position.X,
+   Position.Y
+FROM
+   Events
+LEFT JOIN Position USING (FileId, EvtNumber)
+LEFT JOIN RunInfo  USING (FileId)
+WHERE
+   fSourceKey=5
+AND
+   fRunTypeKey=1
+AND
+   FileId BETWEEN 170600000 AND 180500000
+AND
+   fZenithDistanceMax<35
+AND
+   fR750Cor>0.9*fR750Ref
+}}}
+}}}
 
 == Optimize Area-cut ==