Changeset 27723 for trunk/ippTools/share

Timestamp:

Apr 21, 2010, 3:47:06 PM (16 years ago)

Author:

watersc1

Message:

Have difference images inherit the data_group of the warp that went into them.

Location:

trunk/ippTools/share

Files:

• difftool_definewarpstack_part1.sql (modified) (1 diff)
• difftool_definewarpwarp_select.sql (modified) (1 diff)

trunk/ippTools/share/difftool_definewarpstack_part1.sql

@@ -5 +5 @@
     warpRun.label,
     warpRun.tess_id,
+    warpRun.data_group,
     COUNT(skycell_id) as skycell_count
 FROM warpRun

trunk/ippTools/share/difftool_definewarpwarp_select.sql

@@ -3 +3 @@
     inputWarpRun.tess_id AS tess_id,
     inputRawExp.exp_id AS input_exp_id,
+    inputWarpRun.data_group AS input_data_group,
     -- The following trick pulls out the warp_id that has the smallest distance
     SUBSTRING_INDEX(GROUP_CONCAT(templateWarpRun.warp_id ORDER BY ABS(ASIN(SQRT(POW(SIN(0.5*(inputRawExp.decl - templateRawExp.decl)),2) + COS(inputRawExp.decl) * COS(templateRawExp.decl) * POW(SIN(0.5*(inputRawExp.ra - templateRawExp.ra)),2))))), ',', 1) AS template_warp_id