Changeset 32536 for trunk/ippTools/share/magicdstool_todestreak_warp.sql

Timestamp:

Oct 12, 2011, 10:40:30 AM (15 years ago)

Author:

bills

Message:

For warp destreaking check whether the tess_id for the diffs used in the
streak detection stage matches the tess_id of the warp. If not pass the diff_tess_id
to magic_destreak.pl and compute the overlap using dvoImageOverlaps

File:

• trunk/ippTools/share/magicdstool_todestreak_warp.sql (modified) (2 diffs)

trunk/ippTools/share/magicdstool_todestreak_warp.sql

@@ -14 +14 @@
     warpRun.magicked,
     warpSkyfile.skycell_id as component,
+    diffRun.tess_id != warpRun.tess_id AS mismatched_tess,
+    diffRun.tess_id as diff_tess_id,
     warpSkyfile.uri,
     warpSkyfile.path_base,
@@ -27 +29 @@
 JOIN magicMask USING (magic_id)
 JOIN magicRun USING (magic_id)
+JOIN diffRun USING(diff_id)
 JOIN warpRun ON warp_id = stage_id
 JOIN warpSkyfile USING(warp_id)