IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Changeset 23581


Ignore:
Timestamp:
Mar 27, 2009, 5:12:32 PM (17 years ago)
Author:
Paul Price
Message:

Set some bounds on data-quality for various operations. QUALITY isn't a boolean value, but integer.

Location:
branches/pap
Files:
12 edited

Legend:

Unmodified
Added
Removed

  • branches/pap/ippTools/share/chiptool_completely_processed_exp.sql

    r23381 r23581  
    3535        COUNT(rawImfile.class_id) = COUNT(chipProcessedImfile.class_id)
    3636        AND SUM(chipProcessedImfile.fault) = 0
     37        AND SUM(chipProcessedImfile.quality > 0) != COUNT(*)
    3738    ) as Foo

  • branches/pap/ippTools/share/difftool_definebyquery.sql

    r20973 r23581  
    3939        warpSkyfile.fault = 0
    4040        AND warpSkyfile.ignored = 0
     41        AND warpSkyfile.quality = 0
    4142    -- warpsToDiff WHERE hook %s
    4243    ) AS warpsToDiff

  • branches/pap/ippTools/share/difftool_definebyquery_part1.sql

    r20973 r23581  
    88    FROM warpRun
    99    JOIN warpSkyfile USING(warp_id)
    10     JOIN fakeRun USING(fake_id) 
    11     JOIN camRun USING(cam_id) 
    12     JOIN chipRun USING (chip_id) 
     10    JOIN fakeRun USING(fake_id)
     11    JOIN camRun USING(cam_id)
     12    JOIN chipRun USING (chip_id)
    1313    JOIN rawExp USING(exp_id)
    1414    LEFT JOIN diffRun USING(exp_id)
    1515
    1616    WHERE
     17        warpSkyfile.fault = 0
    1718        warpSkyfile.ignored = 0
     19        AND warpSkyfile.quality = 0
    1820        -- warp where hook %s
    1921        -- exp where hook %s

  • branches/pap/ippTools/share/flatcorr_completely_processed_chiprun.sql

    r18366 r23581  
    1414        dvodb
    1515    FROM
    16         (SELECT 
     16        (SELECT
    1717            chipRun.*,
    1818            rawImfile.class_id as rawimfile_class_id,
    … …  
    3333            COUNT(rawImfile.class_id) = COUNT(chipProcessedImfile.class_id)
    3434            AND SUM(chipProcessedImfile.fault) = 0
    35         ) as Foo
     35            AND SUM(chipProcessedImfile.quality > 0) != COUNT(*)
     36       ) as Foo
    3637    ) as Bar

  • branches/pap/ippTools/share/flatcorr_pending.sql

    r18366 r23581  
    1 SELECT 
     1SELECT
    22    *
    33FROM
    … …  
    2121HAVING
    2222    COUNT(rawImfile.class_id) = COUNT(chipProcessedImfile.class_id)
    23     AND SUM(chipProcessedImfile.fault) = 0
     23    AND SUM(chipProcessedImfile.fault > 0) = 0
    2424

  • branches/pap/ippTools/share/stacktool_definebyquery_insert_random_part1.sql

    r19258 r23581  
    2929        AND warpSkyfile.fault = 0
    3030        AND warpSkyfile.ignored = 0
     31        AND warpSkyfile.quality = 0
    3132-- Put additional constraints here
    3233-- stacktool_definebyquery_insert_random_part2.sql goes here

  • branches/pap/ippTools/share/stacktool_definebyquery_part1.sql

    r19258 r23581  
    1717        COUNT(warpSkyfile.skycell_id) AS num_warp -- number of warps that can be stacked
    1818    FROM warpRun
    19         JOIN warpSkyfile USING(warp_id)
    20         JOIN fakeRun USING(fake_id)
    21         JOIN camRun USING(cam_id)
    22         JOIN chipRun USING(chip_id)
    23         JOIN rawExp USING(exp_id)
     19    JOIN warpSkyfile USING(warp_id)
     20    JOIN fakeRun USING(fake_id)
     21    JOIN camRun USING(cam_id)
     22    JOIN chipRun USING(chip_id)
     23    JOIN rawExp USING(exp_id)
    2424    WHERE
    2525        warpRun.state = 'full'
    26     AND warpSkyfile.ignored = 0
    27     AND warpSkyfile.fault = 0
     26        AND warpSkyfile.ignored = 0
     27        AND warpSkyfile.fault = 0
     28        AND warpSkyfile.quality = 0
    2829    -- Here should follow the SQL in stacktool_definebyquery_part2.sql,
    2930    -- after any additional WHERE conditions have been added

  • branches/pap/ippTools/share/warptool_finished_run_select.sql

    r23459 r23581  
    1919   HAVING
    2020       COUNT(warpSkyCellMap.warp_id) = COUNT(warpSkyfile.warp_id)
    21        AND SUM(warpSkyfile.fault) = 0
     21       AND SUM(warpSkyfile.fault > 0) = 0
    2222 ) as Foo

  • branches/pap/ippTools/share/warptool_imfile.sql

    r20608 r23581  
    2626    AND camRun.state = 'full'
    2727    AND chipRun.state = 'full'
     28    AND chipProcessedImfile.quality = 0
    2829

  • branches/pap/ippTools/share/warptool_revertwarped_delete.sql

    r20722 r23581  
    66    AND camRun.chip_id = chipRun.chip_id
    77    AND chipRun.exp_id = rawExp.exp_id
    8     AND warpSkyfile.fault != 0
     8    AND (warpSkyfile.fault != 0 OR warpSkyfile.quality != 0)
     9

  • branches/pap/ippTools/share/warptool_revertwarped_update.sql

    r20722 r23581  
    66JOIN rawExp USING(exp_id)
    77SET warpRun.state = 'new'
    8 WHERE warpSkyfile.fault != 0
     8WHERE (warpSkyfile.fault != 0 OR warpSkyfile.quality != 0)

  • branches/pap/ippconfig/recipes/ppStatsFromMetadata.config

    r23580 r23581  
    5050  ENTRY  VAL  ROBUST_MEDIAN       F32  ROBUST_STDEV      -bg_mean_stdev     
    5151  ENTRY  VAL  ROBUST_STDEV        F32  RMS               -bg_stdev           
    52   ENTRY  VAL  QUALITY             BOOL CONSTANT          -quality
     52  ENTRY  VAL  QUALITY             S32  CONSTANT          -quality             # Bad quality flag
    5353END
    5454
    … …  
    169169  ENTRY  VAL  IQ_M2S_L            F32  SAMPLE_MEAN      -iq_m2s_lq           
    170170  ENTRY  VAL  IQ_M2S_U            F32  SAMPLE_MEAN      -iq_m2s_uq           
    171   ENTRY  VAL  QUALITY             BOOL CONSTANT          -quality
     171  ENTRY  VAL  QUALITY             S32  CONSTANT          -quality             # Bad quality flag
    172172END
    173173
    … …  
    255255  ENTRY  VAL  RANGE.YMAX          S32  CONSTANT          -ymax         
    256256  ENTRY  VAL  ACCEPT              BOOL CONSTANT          -accept
    257   ENTRY  VAL  QUALITY             BOOL CONSTANT          -quality
     257  ENTRY  VAL  QUALITY             S32  CONSTANT          -quality             # Bad quality flag
    258258END
    259259
    … …  
    282282  ENTRY  VAL  NUM_SOURCES         S32  SUM               -sources                       
    283283  ENTRY  VAL  GOOD_PIXEL_FRAC     F32  MEAN              -good_frac                     
    284   ENTRY  VAL  QUALITY             BOOL CONSTANT          -quality
     284  ENTRY  VAL  QUALITY             S32  CONSTANT          -quality             # Bad quality flag
    285285END
    286286
    … …  
    305305  ENTRY  VAL  NUM_SOURCES           S32  SUM               -sources       
    306306  ENTRY  VAL  GOOD_PIXEL_FRAC       F32  MEAN              -good_frac     
    307   ENTRY  VAL  QUALITY               BOOL CONSTANT          -quality
     307  ENTRY  VAL  QUALITY               S32  CONSTANT          -quality             # Bad quality flag
    308308END
    309309
Note: See TracChangeset for help on using the changeset viewer.