Changes between Version 2 and Version 3 of SAS9DataIntegrity
- Timestamp:
- Oct 3, 2012, 9:03:59 PM (14 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
SAS9DataIntegrity
v2 v3 27 27 == PSPS Integrity Checks == 28 28 29 Step 1. Make mydbs of distinct ippobjid for each of st, ob, p2 for that ra/dec range :29 Step 1. Make mydbs of distinct ippobjid for each of st, ob, p2 for that ra/dec range. I prefer this way because then you can do simple joins on the resulting tables without worrying about distincts and ra/dec ranges for all. 30 30 31 31 Objects: note that we want to avoid the -999 objects that come from stacks and detections but aren't filled by the object batches (they are placeholders of a sort, but they aren't useful for this, and that's another thing to investigate. i want objects filled by object batches). however I do both because I'm curious … … 38 38 }}} 39 39 40 detections and stacks are straightforward 40 Detections and stacks are straightforward 41 41 42 {{{ 42 43 SELECT distinct ippobjid INTO mydb.SAS9st FROM stackdetectionfull WHERE (ra >= 333 and ra <= 335 and dec >= -1 and dec <=1)
