Changeset 32536

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

Location:

trunk/ippTools/share

Files:

• magicdstool_todestreak_camera.sql (modified) (1 diff)
• magicdstool_todestreak_chip.sql (modified) (1 diff)
• magicdstool_todestreak_diff.sql (modified) (2 diffs)
• magicdstool_todestreak_raw.sql (modified) (1 diff)
• magicdstool_todestreak_warp.sql (modified) (2 diffs)

trunk/ippTools/share/magicdstool_todestreak_camera.sql

@@ -14 +14 @@
     stage_id,
     'exposure' AS component,
+    0 AS mismatched_tess,
     CAST(NULL AS CHAR(255)) AS uri,
     camProcessedExp.path_base,

trunk/ippTools/share/magicdstool_todestreak_chip.sql

@@ -14 +14 @@
     stage_id,
     class_id AS component,
+    0 AS mismatched_tess,
     chipProcessedImfile.uri,
     chipProcessedImfile.path_base,

trunk/ippTools/share/magicdstool_todestreak_diff.sql

@@ -15 +15 @@
     diffRun.magicked,
     diffSkyfile.skycell_id AS component,
+    0 AS mismatched_tess,
     CAST(NULL AS CHAR(255)) AS uri,
     diffSkyfile.path_base,
@@ -63 +64 @@
     diffRun.magicked,
     diffSkyfile.skycell_id AS component,
+    0 AS mismatched_tess,
     CAST(NULL AS CHAR(255)) AS uri,
     diffSkyfile.path_base,

trunk/ippTools/share/magicdstool_todestreak_raw.sql

@@ -14 +14 @@
     rawExp.magicked,
     class_id as component,
+    0 AS mismatched_tess,
     rawImfile.uri AS uri,
     -- XXX: replace this with rawImfile.path_base once it exists

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)