Changeset 20031 for trunk/Mars/hawc/processing/find-calibration-files.sql

Timestamp:

01/07/21 14:38:53 (4 years ago)

Author:

tbretz

Message:

Included telescope id and the create query to the raw data extraction.

File:

• trunk/Mars/hawc/processing/find-calibration-files.sql (modified) (3 diffs)

trunk/Mars/hawc/processing/find-calibration-files.sql

@@ -8 +8 @@
       SELECT
          -- NIGHT and RUNID of the data file
-         R1.NIGHT AS NIGHT,
-         R1.RUNID AS RUNID,
+         R1.Telescope AS Telescope,
+         R1.NIGHT     AS NIGHT,
+         R1.RUNID     AS RUNID,
          -- NIGHT and RUNID of the DRS file
-         R2.NIGHT AS DrsNight,
-         R2.RUNID AS DrsRunID,
+         R2.NIGHT     AS DrsNight,
+         R2.RUNID     AS DrsRunID,
          -- Time difference between the two
          LEAST(
@@ -40 +41 @@
          DoNotUse ON (R2.NIGHT=DoNotUse.NIGHT AND R2.RUNID=DoNotUse.RUNID)
       WHERE
+         -- Of course claibration must be from the same telescope
+         R1.Telescope=R2.Telescope
+      AND
          -- Select all combinations that have a data file in R1 and a drs file (at step 1) in R2
-         ISNULL(R1.DRSSTEP) AND R2.DRSSTEP=1 
+         ISNULL(R1.DRSSTEP) AND R2.DRSSTEP=1
       AND 
          -- Only DRS files with 100 events and the correct ROI are considered
@@ -51 +55 @@
       -- AND ABS(UNIX_TIMESTAMP(R2.`DATE-OBS`)-UNIX_TIMESTAMP(R1.`DATE-OBS`))<78*3600
       ORDER BY
-     R1.NIGHT, R1.RUNID, DeltaT
+         R1.Telescope,
+         R1.NIGHT,
+         R1.RUNID,
+         DeltaT
     )
     SELECT
+       Telescope,
        NIGHT,
        RUNID,