Changeset 37201

Timestamp:

Aug 7, 2014, 6:29:46 AM (12 years ago)

Author:

eugene

Message:

StackApFlx* is correctly in Jy

Location:

branches/eam_branches/ipp-20140717/ippToPsps

Files:

• jython/stackbatch.py (modified) (4 diffs)
• pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxFull.txt (modified) (1 diff)
• pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxFullC1.txt (modified) (1 diff)
• pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxFullC2.txt (modified) (1 diff)

branches/eam_branches/ipp-20140717/ippToPsps/jython/stackbatch.py

@@ -381 +381 @@
 
         # if we are going to add a key, do it here so it is useful
-        # self.scratchDb.createIndex(tablename, "objID") 
+        self.scratchDb.createIndex(tablename, "objID") 
 
         self.logger.infoPair("inserting filter dependent cmf items into", tablename)
@@ -684 +684 @@
 
         # if we are going to add a key, do it here so it is useful
-        # self.scratchDb.createIndex(tablename, "objID") 
+        self.scratchDb.createIndex(tablename, "objID") 
 
         for filter in self.filters:
@@ -705 +705 @@
 
         # if we are going to add a key, do it here so it is useful
-        # self.scratchDb.createIndex(tablename, "objID") 
+        self.scratchDb.createIndex(tablename, "objID") 
 
         for filter in self.filters:
@@ -825 +825 @@
             sqlLine.group(field + "Std",       field + "Std" + " * POW(10, 3.56 - 0.4* b.zp)")
         sql = sqlLine.makeEquals("WHERE a.objID = b.objID AND a." + filter + "ippDetectID = b.ippDetectID")
+        self.logger.infoPair("sql",sql)
+        self.scratchDb.execute(sql)
 
     '''

branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxFull.txt

@@ -52 +52 @@
 gflxR10Std       - cmf : APER_FLUX_STDEV_10  ** does not exist in cmf
 gflxR10Fill      - cmf : APER_FILL_10        ** does not exist in cmf
-
-**** NOTE : these are in instrumental flux units not Jy so far...
-

branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxFullC1.txt

@@ -52 +52 @@
 gc1flxR10Std     - cmf : APER_FLUX_STDEV_10  ** does not exist in cmf
 gc1flxR10Fill    - cmf : APER_FILL_10        ** does not exist in cmf
-
-**** NOTE : these are in instrumental flux units not Jy so far...
-

branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxFullC2.txt

@@ -52 +52 @@
 gc2flxR10Std     - cmf : APER_FLUX_STDEV_10  ** does not exist in cmf
 gc2flxR10Fill    - cmf : APER_FILL_10        ** does not exist in cmf
-
-**** NOTE : these are in instrumental flux units not Jy so far...
-