Changes between Version 2 and Version 3 of BillsSAS39ColorColorPlots

Timestamp:

Aug 14, 2015, 1:31:37 PM (11 years ago)

Author:

bills

Comment:

--

BillsSAS39ColorColorPlots

@@ -9 +9 @@
 IPP psps forced photometry takes the positions of the detections made in the stack photometry and does forced photometry on the single frame warp images. 
 
-I decided to use the "view" !ForcedMeanObjectView which is a join of the tables ObjectThin and ForcedMeanObject. I decided to cut on the qualityFlag requiring that the "good stack" bit be set. In order to keep they query time
+I decided to use the "view" !ForcedMeanObjectView which is a join of the tables !ObjectThin and !ForcedMeanObject. I decided to cut on the qualityFlag requiring that the "good stack" bit be set. In order to keep they query time
 managable I queried a subset of the survey using the projectionID column. This restricted the results to objects in projection cell 1406 (334 < ra < 338 0 < dec < 4)
 
@@ -20 +20 @@
 This yielded 562,311 objects.
 
-The ForcedMeanObjectView only has fluxes.  Since this was my first set of queries in awhile I decided not to convert the fluxes to magnitudes in the query. I simply grabbed the objects and ran the results through
-various iterations of a [http://www.star.bristol.ac.uk/~mbt/stilts/ STILTS] program to convert to magnitudes.at I used this [wiki:forcedFluxToMagsExaample perl script] to facitiate the conversions
+The !ForcedMeanObjectView only has fluxes.  Since this was my first set of queries in awhile I decided not to convert the fluxes to magnitudes in the query. I simply grabbed the objects and ran the results through
+various iterations of a [http://www.star.bristol.ac.uk/~mbt/stilts/ STILTS] program to convert to magnitudes.at I used this [wiki:forcedFluxToMagsExaample perl script] to facitiate the conversions. Adding
+entries like 
+{{{
+8.9-2.5*log10(gFPSFFlux)
+}}}
+ to the list of columns in the query would allow us to avoid the stilts step. However the database is going to be busy and keeping the math done there to a minimum seems like a reasonable thing to do.
+
+