|   | 21 | e.g. | 
          
          
            |   | 22 |  | 
          
          
            |   | 23 | ./rootifysql -C rootifysql.eth.rc /home/dorner/FACT.analysis/spectrum/ontime-vs-zd.sql --list.FileID=/home/dorner/FACT.analysis/spectrum/dataset.txt /home/dorner/FACT.analysis/spectrum/ontime-vs-zd.root | 
          
          
            |   | 24 |  | 
          
          
            |   | 25 | with  | 
          
          
            |   | 26 |  | 
          
          
            |   | 27 | dorner@LaMouette:~/FACT.analysis/spectrum$ cat ontime-vs-zd.sql  | 
          
          
            |   | 28 | SELECT | 
          
          
            |   | 29 |   TIME_TO_SEC(TIMEDIFF(fRunStop,fRunStart))*fEffectiveOn as ontime, | 
          
          
            |   | 30 |   fZenithDistanceMean as zd | 
          
          
            |   | 31 | FROM | 
          
          
            |   | 32 |   RunInfo | 
          
          
            |   | 33 |  WHERE | 
          
          
            |   | 34 |   FileID IN ($FileID | 
          
          
            |   | 35 |  | 
          
          
            |   | 36 | then  | 
          
          
            |   | 37 |  | 
          
          
            |   | 38 | root [0] TChain c("Result") | 
          
          
            |   | 39 | root [1] c.Add("/home/dorner/FACT.analysis/spectrum/ontime-vs-zd.root"); | 
          
          
            |   | 40 | root [2] c.Draw("zd>>dis(90,0,90)", "ontime"); | 
          
          
            |   | 41 |  | 
          
          
            |   | 42 |  | 
          
          
            |   | 43 | == step 3 | 
          
          
            |   | 44 |  | 
          
          
            |   | 45 |  | 
          
          
            |   | 46 |  | 
          
          
            |   | 47 | = room for improvement | 
          
          
            |   | 48 |  | 
          
          
            |   | 49 | * get zd-distribution events-wise |