Changes between Version 16 and Version 17 of DatabaseBasedAnalysis

Timestamp:

08/04/18 16:24:17 (7 years ago)

Author:

tbretz

Comment:

--

DatabaseBasedAnalysis

@@ -281 +281 @@
 == Data retrieval ==
 
-The events themselves are stored in a table named '''Events'''
+The events themselves are stored in a table named '''Events'''. The position of the source in camera coordinates is stored in '''Position''. To get them, you can run the following query
+
+{{{
+SELECT
+   Events.*,
+   Position.X,
+   Position.Y
+FROM RunInfo
+LEFT JOIN Events   USING (FileId)
+LEFT JOIN Position USING (FileId, EvtNumber)
+WHERE 
+   fSourceKey=5 
+AND 
+   fRunTypeKey=1 
+AND 
+   FileId BETWEEN 131101000 AND 131107000
+AND 
+   fZenithDistanceMax<35
+AND 
+   fR750Ref/fR750Cor>0.9
+}}}
+
+or with the list you wrote before
+
+{{{
+SELECT
+   Events.*,
+   Position.X,
+   Position.Y
+LEFT JOIN Events   USING (FileId)
+LEFT JOIN Position USING (FileId, EvtNumber)
+WHERE 
+   FileId IN ($MyList)
+}}}
+
+using {{{--list.MyList=Crab.txt}}} as command-line option to rootifysql. Both queries are similar in execution time.
+
+
+
 
 Some statistics: