Index: /trunk/ippToPsps/config/ippToPspsDbSchema.sql =================================================================== --- /trunk/ippToPsps/config/ippToPspsDbSchema.sql (revision 36814) +++ /trunk/ippToPsps/config/ippToPspsDbSchema.sql (revision 36815) @@ -278,2 +278,19 @@ -- Dump completed on 2012-04-10 6:00:59 + + +DROP TABLE IF EXISTS `dvodb`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `dvodb` ( + `dvo_db` varchar(30) default NULL, + `batch_type` varchar(10) default NULL, + `stage_id` bigint(20) unsigned default NULL, + `ra_center` float default NULL, + `dec_center` float default NULL, + `uniq_key` varchar(30) default NULL, + UNIQUE KEY `uniq_key` (`uniq_key`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + + Index: /trunk/ippToPsps/config/parse_vot.pl =================================================================== --- /trunk/ippToPsps/config/parse_vot.pl (revision 36814) +++ /trunk/ippToPsps/config/parse_vot.pl (revision 36815) @@ -3,6 +3,6 @@ # this thing will just parse the votables and print out in 'ken schema style' -#$wiki=1; -$csv = 1; +$wiki=1; +#$csv = 1; $infield = 0; $intable = 0; Index: /trunk/ippToPsps/jython/Makefile.am =================================================================== --- /trunk/ippToPsps/jython/Makefile.am (revision 36814) +++ /trunk/ippToPsps/jython/Makefile.am (revision 36815) @@ -22,4 +22,5 @@ gpc1db.py \ initbatch.py \ + insert.dvodb.info.py \ ipptopspsdb.py \ ipptopsps.py \ Index: /trunk/ippToPsps/jython/insert.dvodb.info.py =================================================================== --- /trunk/ippToPsps/jython/insert.dvodb.info.py (revision 36815) +++ /trunk/ippToPsps/jython/insert.dvodb.info.py (revision 36815) @@ -0,0 +1,150 @@ +#!/usr/bin/env jython + +# +# The main loading program for ippToPsps. See usage below. +# + +import time +import sys +import os +import math +import logging.config + +from ipptopsps import IppToPsps +from gpc1db import Gpc1Db +from datastore import Datastore +from dvoobjects import DvoObjects +from batch import Batch +from scratchdb import ScratchDb + +''' +Queue class +''' +class Queue(IppToPsps): + + ''' + Constructor + ''' + def __init__(self, argv): + super(Queue, self).__init__(argv) + + # print "inited ipptopsps" + + # create various objects + self.gpc1Db = Gpc1Db(self.logger, self.config) + # print "connect to gpc1" + + self.datastore = Datastore(self.logger, self.skychunk, self.ippToPspsDb) + + print "made datastore" + + # connect to scratch database + self.scratchDb = ScratchDb(self.logger, self.config) + + print "connect to scratchdb" + + try: + print "why doesn't this work" + self.dvoObjects = DvoObjects(self.logger, self.config, self.skychunk, self.ippToPspsDb, self.scratchDb) + except: + self.exitProgram("Unable to create instance of DvoObject") + raise + + print "got objects" + + self.skychunk.printAll() + + if len(argv) > 2: self.parsePollTimeArg(sys.argv[2]) + + ''' + Main processing loop. + Tiled area is defined in 'skychunk' and looks for available stage_ids for each tile and writes them to ippToPsps database ready for processing + by one or more loading clients that may be running on any host + ''' + def run(self): + print "here" + # this outer while loop simply waits a few minutes then starts queuing again (as more stuff may appear in DVO over time) + while True: + + # self.ippToPspsDb.removeAllBoxes() + print "remove boxes" + # queue up batches that are processed but not loaded to datastore + for batchType in self.skychunk.batchTypes: + self.logger.infoPair("BatchType",batchType) + #self.logger.infoTitle("Previous failed datastore loads") + #self.publishAnyUnpublishedBatches(batchType) + + # get totals for whole area to check if there is anything to do + processedIDs = self.ippToPspsDb.getProcessedIDs(batchType) + print "got processed ids" + consistantlyFailedIDs = self.ippToPspsDb.getConsistentlyFailedIDs(batchType) + print "got here" + # for object batches, get full list of stuff from Dvo + # XXX : need to fix 'dvo.setSkyArea' or this may not return the full list for a parallel dvo + #for object-like batches, info comes from dvo + if (batchType == "OB" or batchType =="DO" or batchType =="FO"): + self.dvoObjects.setSkyArea( + self.skychunk.minRa, + self.skychunk.maxRa, + self.skychunk.minDec, + self.skychunk.maxDec) + rows = self.dvoObjects.allPopulatedRegionInfo + self.dvoObjects.printSummary() + + # for other batches, info comes from gpc1 database + else: + rows = self.gpc1Db.getItemsInThisDVODbForThisStage( + self.skychunk.dvoLabel, + batchType, + self.skychunk.minRa, + self.skychunk.maxRa, + self.skychunk.minDec, + self.skychunk.maxDec, + self.skychunk.trange_start, + self.skychunk.trange_end) + + # EAM TEST I/O + self.logger.infoPair("received rows from db:", len(rows)) + + # first report total stuff + allIDs = [] + for row in rows: + try: allIDs.append(row[0]) + except: pass + + ids = list(set(allIDs) - set(processedIDs) - set(consistantlyFailedIDs)) + self.logger.infoPair("All unprocessed items", "%d" % len(ids)) + + # now trim full list down to only pending stuff + pending = [[], [], []] + for row in rows: + try: + findId = row[0] + except: continue + if findId in allIDs: pending.append([row[0], row[1], row[2]]) + + # store all items in temp table + self.logger.infoPair("Inserting all pending items into", "ippToPsps database") + self.ippToPspsDb.storeAllItemsInDvodb(pending, self.skychunk.dvoLabel, batchType) + + self.logger.info("+-------------+-------------+-------------+-------------+") + + self.checkClientStatus() + if not self.waitForPollTime(): break + + ''' + Overrides base-class version + ''' + def printUsage(self): + super(Queue, self).printUsage("[]") + + +''' +Start of program. +''' +try: + queue = Queue(sys.argv) + queue.run() + queue.exitProgram("completed") +except: pass + Index: /trunk/ippToPsps/jython/ipptopspsdb.py =================================================================== --- /trunk/ippToPsps/jython/ipptopspsdb.py (revision 36814) +++ /trunk/ippToPsps/jython/ipptopspsdb.py (revision 36815) @@ -1651,4 +1651,32 @@ # self.logger.infoPair("Items written to alt Db", "%d" % count) + + ''' + Creates a temporary table and shoves it full of stage_ids and ra/dec coords + ''' + def storeAllItemsInDvodb(self, rows, dvo_db, batchType): + + #try: + # self.execute("DROP TABLE all_pending") + #except: + # pass + + #self.execute("CREATE TEMPORARY TABLE all_pending (stage_id bigint(20), ra_bore float, dec_bore float)") + for row in rows: + + try: + uniq = dvo_db + "."+ batchType + "." + str(row[0]) + sql = "INSERT INTO dvodb (dvo_db, batch_type, stage_id, ra_center, dec_center, uniq_key) \ + VALUES ( '" + dvo_db + "', '" + batchType + "'," + str(row[0]) + "," + str(row[1]) + " \ + , " + str(row[2]) + ", '"+uniq+"' ) " + print "sql 1: ", sql + self.execute(sql) + except: continue + + #count = self.getRowCount("all_pending") + #self.logger.infoPair("Items written to Db", "%d" % count) + + + ''' Gets all items in the all_pending temporary table within the bounds of this box Index: /trunk/ippToPsps/jython/odm.py =================================================================== --- /trunk/ippToPsps/jython/odm.py (revision 36814) +++ /trunk/ippToPsps/jython/odm.py (revision 36815) @@ -31,5 +31,5 @@ tempFile = tempfile.NamedTemporaryFile(mode='w+b') - + self.logger.infoPair("checkOdmStatus.pl -b " + batch + " -f " + tempFile.name, "") p = Popen("checkOdmStatus.pl -b " + batch + " -f " + tempFile.name, shell=True, Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/Notes_on_Schema10.txt =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/Notes_on_Schema10.txt (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/Notes_on_Schema10.txt (revision 36815) @@ -0,0 +1,132 @@ +Notes on Schema Version 9 + + +Proposed Image Products and PSPS Tables and Views + +IMAGE PRODUCTS + +Survey | Description | Image Products Saved + +3pi | 3pi | 3pi warps, 3pi stacks +CNP | Celestial North Pole (3pi)| CNP warps, stacks +SS | ecliptic w band data | w warps, w stack +MDD | Medium Deep Deep | MD warps, deep stacks +MDT | Medium Deep Template | template stacks +MDN | Medium Deep Nightly Stack | nightly stacks +MDN | Medium Deep Off Year | off year template stacks +M31 | M31 | M31 warps, M31 stacks, template +STS | STS | STS warps, STS template - best iq stack + + +Survey | Description | Image Products NOT Saved, but analyzed for difference detections and discarded + +3pi | difference |3pi warps - stack +CNP | difference |CNP warps - stack +SS | difference image | w warps - stack +MDD | difference image | MD warps - off year template stacks +MDO | difference image | MDN stacks - off year template stacks +M31 | difference image | M31 warps - stack +STS | difference image | STS warps - template + + + +PSPS TABLES + + +Fundamental IPP Data Products Origin + +Detection detections found in detrended images +ObjectThin positonal and flag data, no fluxes +MeanObject extracted Mean properties as determined from individual Detections. +StackObject Stack Detections in all filters, with forced upperlimits, separate rows for primary, secondary, best stack detections (80% time only primary) +StackApFlx all filters in one table, unconvolved and convolved apertures (up to 6 , 8, 10(?) pixels in all bands) +StackModelFit all filters in one table. Models of high signal to noise objects in low density regions. +DiffDet difference detections found in difference image = image - template +DiffObject associations of Difference Detections +ForcedWarpMeasure forced measurements on each warp in all filters at the position of an object found in a stack. Includes StackApFlx-like table +ForcedMeanObject like MeanObject, but using the Forced Mean Measurements to form the Mean. + +w band TBD + + +Derived Data Product Tables + +pcsPhotoZ populated from PCS +pcsPhotoZProbability populated from PCS +pcsStarGalQSOSep populated from PCS +pcsStellarParams populated from PCS +mopsMovingObject populated from MOPS database +ppmObj proper motion and parallax populated from IPP +tcsClassification populated from transient server database +galExtinction populated from Dust team +stargal populated from various algorithms, combos of ipp parameters, fits to population as function of magnitude, or Support Vector Machine +GoodObject selected and populated post-facto +StarGalaxySep selected and populated post-facto + + +Observational Metadata and System MetaData Tables + +CameraConfig +DetectionFlags +DiffMeta +Filter +FitModel +ForcedWarpMeta +FrameMeta +ImageFlags +ImageMeta add psf 3nd and 4th moments +Mask +MovingObjectToDet +MovingObjectToDiffDet +MovingObjToObject +ObjectFilterFlags flag info not in current schema but in PSI interface... +ObjectInfoFlags +ObjectQualityFlags +PhotoCal +ProjectionCell +ProcessingVersion +SkyCell +StackDetectionFlags +StackMeta +StackToImage +StackType +Survey +TelescopeConfig +fitModel +pcsGalaxyModel +pcsPhotoZRecipe +pcsSGSepRecipe +pcsStarModel +pcsStellarParamsRecipe + + + +PSPS VIEWS - examples + +ObjectMean = ObjectThin join MeanObject +ObjectStack = ObjectThin join StackObject +ObjectApFlx = ObjectThin join StackApFlx +ObjectModel = ObjectThin join StackModelFit +ObjectStackAll = ObjectThin join StackObject and StackAp and StackModelFit +ObjectForcedMean = ObjectThin join ForcedMeanObject +ObjectPrimary = ObjectThin join StackObject join StackApFlx where primaryDection is true +ObjectBest = ObjectThin join StackObject join StackApFlx where bestDetection is true + + +PSPS Indicies + +DetectionID +ObjectID +BatchID +StackTypeID +MovingObjID +DiffObjID +RandomID between 1 and 2^16 = 4,294,967,296 so you pick how many random objects you want , + i.e 10,000 pick randomid < 10,000 and if indexed, this will be very fast. +RandomStackID between 1 and 2^16 = 4,294,967,296 so you pick how many random objects you want , + i.e 10,000 pick randomid < 10,000 and if indexed, this will be very fast. + + + + + Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/Notes_on_Schema11.txt =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/Notes_on_Schema11.txt (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/Notes_on_Schema11.txt (revision 36815) @@ -0,0 +1,132 @@ +Notes on Schema Version 9 + + +Proposed Image Products and PSPS Tables and Views + +IMAGE PRODUCTS + +Survey | Description | Image Products Saved + +3pi | 3pi | 3pi warps, 3pi stacks +CNP | Celestial North Pole (3pi)| CNP warps, stacks +SS | ecliptic w band data | w warps, w stack +MDD | Medium Deep Deep | MD warps, deep stacks +MDT | Medium Deep Template | template stacks +MDN | Medium Deep Nightly Stack | nightly stacks +MDN | Medium Deep Off Year | off year template stacks +M31 | M31 | M31 warps, M31 stacks, template +STS | STS | STS warps, STS template - best iq stack + + +Survey | Description | Image Products NOT Saved, but analyzed for difference detections and discarded + +3pi | difference |3pi warps - stack +CNP | difference |CNP warps - stack +SS | difference image | w warps - stack +MDD | difference image | MD warps - off year template stacks +MDO | difference image | MDN stacks - off year template stacks +M31 | difference image | M31 warps - stack +STS | difference image | STS warps - template + + + +PSPS TABLES + + +Fundamental IPP Data Products Origin + +Detection detections found in detrended images +ObjectThin positonal and flag data, no fluxes +MeanObject extracted Mean properties as determined from individual Detections. +StackObject Stack Detections in all filters, with forced upperlimits, separate rows for primary, secondary, best stack detections (80% time only primary) +StackApFlx all filters in one table, unconvolved and convolved apertures (up to 6 , 8, 10(?) pixels in all bands) +StackModelFit all filters in one table. Models of high signal to noise objects in low density regions. +DiffDet difference detections found in difference image = image - template +DiffObject associations of Difference Detections +ForcedWarpMeasure forced measurements on each warp in all filters at the position of an object found in a stack. Includes StackApFlx-like table +ForcedMeanObject like MeanObject, but using the Forced Mean Measurements to form the Mean. + +w band TBD + + +Derived Data Product Tables + +pcsPhotoZ populated from PCS +pcsPhotoZProbability populated from PCS +pcsStarGalQSOSep populated from PCS +pcsStellarParams populated from PCS +mopsMovingObject populated from MOPS database +ppmObj proper motion and parallax populated from IPP +tcsClassification populated from transient server database +galExtinction populated from Dust team +stargal populated from various algorithms, combos of ipp parameters, fits to population as function of magnitude, or Support Vector Machine +GoodObject selected and populated post-facto +StarGalaxySep selected and populated post-facto + + +Observational Metadata and System MetaData Tables + +CameraConfig +DetectionFlags +DiffMeta +Filter +FitModel +ForcedWarpMeta +FrameMeta +ImageFlags +ImageMeta add psf 3nd and 4th moments +Mask +MovingObjectToDet +MovingObjectToDiffDet +MovingObjToObject +ObjectFilterFlags flag info not in current schema but in PSI interface... +ObjectInfoFlags +ObjectQualityFlags +PhotoCal +ProjectionCell +ProcessingVersion +SkyCell +StackDetectionFlags +StackMeta +StackToImage +StackType +Survey +TelescopeConfig +fitModel +pcsGalaxyModel +pcsPhotoZRecipe +pcsSGSepRecipe +pcsStarModel +pcsStellarParamsRecipe + + + +PSPS VIEWS - examples + +ObjectMean = ObjectThin join MeanObject +ObjectStack = ObjectThin join StackObject +ObjectApFlx = ObjectThin join StackApFlx +ObjectModel = ObjectThin join StackModelFit +ObjectStackAll = ObjectThin join StackObject and StackAp and StackModelFit +ObjectForcedMean = ObjectThin join ForcedMeanObject +ObjectPrimary = ObjectThin join StackObject join StackApFlx where primaryDection is true +ObjectBest = ObjectThin join StackObject join StackApFlx where bestDetection is true + + +PSPS Indicies + +DetectionID +ObjectID +BatchID +StackTypeID +MovingObjID +DiffObjID +RandomID between 1 and 2^16 = 4,294,967,296 so you pick how many random objects you want , + i.e 10,000 pick randomid < 10,000 and if indexed, this will be very fast. +RandomStackID between 1 and 2^16 = 4,294,967,296 so you pick how many random objects you want , + i.e 10,000 pick randomid < 10,000 and if indexed, this will be very fast. + + + + + Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/Notes_on_Schema12.txt =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/Notes_on_Schema12.txt (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/Notes_on_Schema12.txt (revision 36815) @@ -0,0 +1,2 @@ +Heather cleaned up the column names and types to make them consistent. + Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/Notes_on_Schema13.txt =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/Notes_on_Schema13.txt (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/Notes_on_Schema13.txt (revision 36815) @@ -0,0 +1,8 @@ +changes by EAM: +* added lensing terms to ForcedWarpMeasurement & ForcedMeanObject +* removed fluxPeak and momentRH generally +* changed psfWidMajor,Minor to psfMajorFWHM,psfMinorFWHM +* added psfCore (k term in psf model : 1 / (1 + kz + k^1.667) +* fixed stack flux & mag names +* set units for moments to be in arcsec everywhere. + Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Derived_Data_Product_Tables/GoodObject =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Derived_Data_Product_Tables/GoodObject (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Derived_Data_Product_Tables/GoodObject (revision 36815) @@ -0,0 +1,4 @@ +objName string VAR 8 NA IAU Name constructed from objID postion PS1.x JHHMMSS.SS+/-DDMMSS.S where x is leading number of procesing version +objID dimensionless BIGINT 8 NA ODM object identifier index +ippObjID dimensionless BIGINT 8 NA IPP object number +goodObjectID dimensionless BIGINT 8 NA index for post-facto "good objects" subset from ObjID Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Derived_Data_Product_Tables/StarGalaxySep =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Derived_Data_Product_Tables/StarGalaxySep (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Derived_Data_Product_Tables/StarGalaxySep (revision 36815) @@ -0,0 +1,9 @@ +objName string VAR 8 NA IAU Name constructed from objID postion PS1.x JHHMMSS.SS+/-DDMMSS.S where x is leading number of procesing version +objID dimensionless BIGINT 8 NA ODM object identifier index +ippObjID dimensionless BIGINT 8 NA IPP object number +sgbinarySep1 dimensionless TINYINT 2 255 binary flag for star galaxy separator - technique 1 +sgbinarySep2 dimensionless TINYINT 2 255 binary flag for star galaxy separator - technique 2 +sgbinarySep3 dimensionless TINYINT 2 255 binary flag for star galaxy separator - technique 3 +sgSep1 dimensionless REAL 4 -999 probility of star/galaxy technique 1 +sgSep2 dimensionless REAL 4 -999 probility of star/galaxy technique 2 +sgSep3 dimensionless REAL 4 -999 probility of star/galaxy technique 3 Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Derived_Data_Product_Tables/galExtinction =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Derived_Data_Product_Tables/galExtinction (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Derived_Data_Product_Tables/galExtinction (revision 36815) @@ -0,0 +1,28 @@ +galExtinction +Name Unit Data Type Size Default Value Description + +objID dimensionless BIGINT 8 NA ODM object identifier index +ippObjID dimensionless BIGINT 8 NA IPP object number + +From Doug and Eddie ? + +E(B-V) + +gGalext +rGalext +iGalext +zGalext +yGalext +wGalext +probability vector + +stellar parameters +Teff +g_surf +[Fe/H] + + + + + + Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Derived_Data_Product_Tables/mopsMovingObject =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Derived_Data_Product_Tables/mopsMovingObject (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Derived_Data_Product_Tables/mopsMovingObject (revision 36815) @@ -0,0 +1,28 @@ +Name Unit Data Type Size Default Value Description + +MovingObjName dimensionless STRING x -999 MPC Name +MovingObjType dimensionless STRING x -999 Type of moving object (NEO, PHA, COMET, ...) +MovingObjID dimensionless BIGINT 8 -999 Moving Object identifier +OrbEpoch date DATE -999 The epoch of osculation of the orbital elements. +Moid au REAL 4 -999 Minimum orbit intersection distance +OrbM dimensionles REAL 4 -999 Mean anomaly at the epoch. +OrbT date DATE -999 Date of perihelion passage. +ORBn deg/day REAL 4 -999 Mean daily motion (in degrees/day). +ORBa AU REAL 4 -999 Semimajor axis (in AU). +ORBz 1/AU REAL 4 -999 Reciprocal semimajor axis (in 1/AU). +ORBq AU REAL 4 -999 Perihelion distance (in AU). +ORBe dimensionless REAL 4 -999 Orbital eccentricity. +OrbP years REAL 4 -999 Orbital period (in years). +OrbPeri degrees REAL 4 -999 The J2000.0 argument of perihelion (in degrees). +OrbNode degrees REAL 4 -999 The J2000.0 longitude of the ascending node (in degrees). +OrbIncl degrees REAL 4 -999 The J2000.0 inclination (in degrees). +P1 dimensionless REAL 4 -999 P1 first component of P vector +P2 dimensionless REAL 4 -999 P2 second component of P vector +P3 dimensionless REAL 4 -999 P3 third component of P vector +Q1 dimensionless REAL 4 -999 Q1 first component of Q vector +Q2 dimensionless REAL 4 -999 Q2 second component of Q vector +Q3 dimensionless REAL 4 -999 Q3 third component of Q vector +U dimensionless REAL 4 -999 Uncertainty parameter. +H dimensionless REAL 4 -999 Absolute visual magnitude. A table converting H to a diameter is available. +G dimensionless REAL 4 -999 Slope parameter. + Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Derived_Data_Product_Tables/pcsPhotoZ =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Derived_Data_Product_Tables/pcsPhotoZ (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Derived_Data_Product_Tables/pcsPhotoZ (revision 36815) @@ -0,0 +1,21 @@ +pcsPhotoZ +Name Unit Data Type Size Default Value Description + +objID BIGINT 8 NA ODM object identifier index +ippObjID BIGINT 8 NA IPP object number +pcsPhotoZRecipeID INT 4 -999 Recipe of the photoZ calculation +galExt REAL 4 -999 Galactic extinction E(B-V) used for photoz determination (derived from Schlegel Maps) +photoz_1 REAL 4 -999 PhotoZ for best fitting template +photozErr_1 REAL 4 -999 Estimated error for this tempalte +chi2_1 REAL 4 -999 Chi^2 for this template +modelID_1 INT 4 -999 Identifier for the template for this recipe +photoz_2 REAL 4 -999 PhotoZ for second template +photozErr_2 REAL 4 -999 Estimated error for this tempalte +chi2_2 REAL 4 -999 Chi^2 for this template +modelID_2 INT 4 -999 Identifier for the template for this recipe +flags_gtfit INT 4 -999 warning flags (e.g. missing band(s), unreliable galExt value etc.), TBD +av REAL 4 -999 determined extinction +chi2 REAL 4 -999 chi2 for the best fitting stellar template +modelID INT 4 -999 modelID of the best fitting stellar template +flags_stfit INT 4 -999 warning flags from stellar template fitting +starGalQSOSep INT 4 -999 0: Object is a star (chi2 Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Derived_Data_Product_Tables/pcsPhotoZProbabiity =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Derived_Data_Product_Tables/pcsPhotoZProbabiity (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Derived_Data_Product_Tables/pcsPhotoZProbabiity (revision 36815) @@ -0,0 +1,37 @@ +PhotoZProbability +Name Unit Data Type Size Default Value Description + +objID dimensionless BIGINT 8 NA ODM object identifier index +ippObjID dimensionless BIGINT 8 NA IPP object number +pcsPhotoZRecipeID dimensionless INT 4 -999 recipe for the photoz determination +modelID dimensionless INT 4 -999 modelID of the template +sp1 dimensionless REAL 4 -999 spline params 1 +sp2 dimensionless REAL 4 -999 spline params 2 +sp3 dimensionless REAL 4 -999 spline params 3 +sp4 dimensionless REAL 4 -999 spline params 4 +sp5 dimensionless REAL 4 -999 spline params 5 +sp6 dimensionless REAL 4 -999 spline params 6 +sp7 dimensionless REAL 4 -999 spline params 7 +sp8 dimensionless REAL 4 -999 spline params 8 +sp9 dimensionless REAL 4 -999 spline params 9 +sp10 dimensionless REAL 4 -999 spline params 10 +sp11 dimensionless REAL 4 -999 spline params 11 +sp12 dimensionless REAL 4 -999 spline params 12 +sp13 dimensionless REAL 4 -999 spline params 13 +sp14 dimensionless REAL 4 -999 spline params 14 +sp15 dimensionless REAL 4 -999 spline params 15 +sp16 dimensionless REAL 4 -999 spline params 16 +sp17 dimensionless REAL 4 -999 spline params 17 +sp18 dimensionless REAL 4 -999 spline params 18 +sp19 dimensionless REAL 4 -999 spline params 19 +sp20 dimensionless REAL 4 -999 spline params 20 +sp21 dimensionless REAL 4 -999 spline params 21 +sp22 dimensionless REAL 4 -999 spline params 22 +sp23 dimensionless REAL 4 -999 spline params 23 +sp24 dimensionless REAL 4 -999 spline params 24 +sp25 dimensionless REAL 4 -999 spline params 25 +sp26 dimensionless REAL 4 -999 spline params 26 +sp27 dimensionless REAL 4 -999 spline params 27 +sp28 dimensionless REAL 4 -999 spline params 28 +sp29 dimensionless REAL 4 -999 spline params 29 +sp30 dimensionless REAL 4 -999 spline params 30 Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Derived_Data_Product_Tables/pcsStarGalQSOSep =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Derived_Data_Product_Tables/pcsStarGalQSOSep (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Derived_Data_Product_Tables/pcsStarGalQSOSep (revision 36815) @@ -0,0 +1,10 @@ +pcsStarGalQSOSep +Name Unit Data Type Size Default Value Description + +objID dimensionless BIGINT 8 NA ODM object identifier index +ippObjID dimensionless BIGINT 8 NA IPP object number +pcsSGSepRecipeIDdimensionless INT 4 NA recipe for the star/galaxy/quasar separation +probStar percentage FLOAT 8 -999 probability object is a star +probGalaxy percentage FLOAT 8 -999 probability object is a galaxy +probQuasar percentage FLOAT 8 -999 probability object is a quasar +flags dimensionless INT 4 -999 flags Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Derived_Data_Product_Tables/pcsStellarParams =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Derived_Data_Product_Tables/pcsStellarParams (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Derived_Data_Product_Tables/pcsStellarParams (revision 36815) @@ -0,0 +1,11 @@ +pcsStellarParams s +Name Unit Data Type Size Default Value Description + +objID dimensionless BIGINT 8 NA ODM object identifier index +ippObjID dimensionless BIGINT 8 NA IPP object number +pcsStellarParamsRecipeID dimensionless INT 4 -999 recipe for the star/galaxy/quasar separation +Teff dimensionless REAL 4 -999 N/A +A0 dimensionless REAL 4 -999 N/A +Fe_H dimensionless REAL 4 -999 N/A +flags dimensionless INT 4 -999 flags + Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Derived_Data_Product_Tables/ppmObj =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Derived_Data_Product_Tables/ppmObj (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Derived_Data_Product_Tables/ppmObj (revision 36815) @@ -0,0 +1,25 @@ +PPM +Description: Proper motions and parallax associated with defined objects. + +Name Unit Data Type Size Default Value Description +objID BIGINT 8 NA ODM object identifier +ippObjID BIGINT 8 NA IPP object identifier index +ppmID BIGINT 8 NA ppm object identifier ( ppmToObject metatable?) +meanEpoch FLOAT 8 -999 mean epoch of observations in Mean Julian Days +elapseTime REAL 4 -999 Elapsed time of astrometric observations +muRa REAL 4 -999 proper motion in RA +muRaErr REAL 4 -999 error in proper motion in RA +muDec REAL 4 -999 proper motion in DEC +muDecErr REAL 4 -999 error in proper motion in Dec +mu REAL 4 -999 total proper motion +muErr REAL 4 -999 error in total proper motion +theta REAL 4 -999 angle of parallax vector from N in degrees +plx REAL 4 -999 total parallax +plxErr REAL 4 -999 error in total parallax +nAstro SMALLINT 2 -999 number of measures in astrometric fit +rmsRA REAL 4 -999 rms of astrometric error in RA +rmsDec REAL 4 -999 rms of astrometric error in Dec +wiggle TINYINT 1 255 flag/pointer to astrometric orbit + + + Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Derived_Data_Product_Tables/stargal =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Derived_Data_Product_Tables/stargal (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Derived_Data_Product_Tables/stargal (revision 36815) @@ -0,0 +1,17 @@ + + +Name Unit Data Type Size Default Value Description + +objID dimensionless BIGINT 8 NA ODM object identifier index +ippObjID dimensionless BIGINT 8 NA IPP object number +StarProb1 fraction FLOAT 8 -999 fractional probability object is a star, Recipe 1 +GalProb1 fraction FLOAT 8 -999 fractional probability object is a galaxy, Recipe 1 +StarProb2 fraction FLOAT 8 -999 fractional probability object is a star, Recipe 2 +GalProb2 fraction FLOAT 8 -999 fractional probability object is a galaxy, Recipe 2 +StarProb3 fraction FLOAT 8 -999 fractional probability object is a star, Recipe 3 +GalProb3 fraction FLOAT 8 -999 fractional probability object is a galaxy, Recipe 3 + + +comment - may come from different combinations of ipp parameters, model fit as function of magnitude, +or Support Vector Machine result. + Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Derived_Data_Product_Tables/tcsClassification =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Derived_Data_Product_Tables/tcsClassification (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Derived_Data_Product_Tables/tcsClassification (revision 36815) @@ -0,0 +1,16 @@ +galExtinction +Name Unit Data Type Size Default Value Description + +objID dimensionless BIGINT 8 NA ODM object identifier index +ippObjID dimensionless BIGINT 8 NA IPP object number +diffobjID dimensionless BIGINT 8 NA IPP object number + +From Stephen and Ken? + +TransientName eg. PS1-10jh +transientClass TDE +ATEL -999 Astronomical Telegram number + + + + Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/Detection =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/Detection (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/Detection (revision 36815) @@ -0,0 +1,59 @@ +objID dimensionless BIGINT 8 NA ODM object identifier +gcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier +detectID dimensionless BIGINT 8 NA ODM detection identifier +ippObjID dimensionless BIGINT 8 NA detection id generated by IPP +ippDetectID dimensionless BIGINT 8 NA detection id generated by IPP +filterID dimensionless TINYINT 1 NA filter ID: g=1, r=2, i=3, z=4, y=5, w=6, ... +surveyID dimensionless TINYINT 1 NA survey flag identifier +imageID dimensionless BIGINT 8 NA image id hash of frame identifier & OTA/CCD number +randomDetID dimensionless BIGINT 8 NA random detection Id +dvoRegionID dimensionless REAL 4 -999 identifier to dvo spatial region +obsTime MeanJulianDays FLOAT 8 -999 Time of mid observation in Mean Julian Days +xPos raw pixels REAL 4 -999 measured x on CCD from PSF fit +yPos raw pixels REAL 4 -999 measured y on CCD from PSF fit +xPosErr raw pixels REAL 4 -999 estimated error in x +yPosErr raw pixels REAL 4 -999 estimated error in y +pltScale arcsec/pix REAL 4 -999 plate scale at this location (from DVO) +posAngle degrees REAL 4 -999 position angle (sky-to-chip) at this location (from DVO) +------------------------------------------------------ Note - next 8 lines came from previous DetCalib table +ra degrees FLOAT 8 NA Right Ascension +dec degrees FLOAT 8 NA Declination +raErr arcsec REAL 4 NA Right Ascension error +decErr arcsec REAL 4 NA Declination error +zp magnitude REAL 4 0 zeropoint (only thing needed to convert adu/sec to AB mag), note no zpErr +telluricExt magnitude REAL 4 NA estimated extinction due to non-photometric conditions +expTime seconds REAL 4 -999 exposure time (informational) +airMass dimensionless REAL 4 0 airmass (informational) +------------------------------------------------------ +psfFlux adu/seconds REAL 4 -999 PSF instrumental flux (in analog-to-digital units/sec) or adu/sec +psfFluxErr adu/seconds REAL 4 -999 estimated error in flux +psfMajorFWHM arcsec REAL 4 -999 model PSF width in major axis +psfMinorFWHM arcsec REAL 4 -999 model PSF width in minor axis +psfTheta degrees REAL 4 -999 model PSF orientation angle degrees East of North +psfCore dimensionless REAL 4 -999 model PSF core parameter [k in (1 + kz + z^1.66)] +psfQf dimensionless REAL 4 -999 PSF coverage factor +psfQfPerfect dimensionless REAL 4 -999 PSF-weighted fraction of pixels totally unmasked +psfChiSq dimensionless REAL 4 -999 reduced-chisq of the psf model fit. (ndof?, npix?) +psfLikelihood dimensionless REAL 4 -999 PSF likelihood +momentXX arcsec^2 REAL 4 -999 moment XX +momentXY arcsec^2 REAL 4 -999 moment XY +momentYY arcsec^2 REAL 4 -999 momeny YY +momentR1 arcsec REAL 4 -999 first radial moment +momentRH arcsec REAL 4 -999 half light radius +momentM3C arcsec^n REAL 4 -999 3rd moment sin(theta) +momentM3S arcsec^n REAL 4 -999 3rd moment cos(theta) +momentM4C arcsec^n REAL 4 -999 4th moment sin(theta) +momentM4S arcsec^n REAL 4 -999 4th moment cos(theta) +apFlux adu/seconds REAL 4 -999 Aperture flux +apFluxErr adu/seconds REAL 4 -999 Aperture flux error +apFillF dimensionless REAL 4 -999 Aperture fill factor +kronFlux adu/seconds REAL 4 -999 Kron flux +kronFluxErr adu/seconds REAL 4 -999 Kron flux error +kronRad arcsec REAL 4 -999 Kron radius +kronRadErr arcsec REAL 4 -999 Kron radius error +sky adu/sec/pixel REAL 4 -999 PSF sky level at source +skyErr adu/sec/pixel REAL 4 -999 estimated error in sky +infoFlag dimensionless BIGINT 8 -999 flag indicating provenance information +dataRelease dimensionless TINYINT 1 NA Data release when this detection was originally taken. Recalibrations do not affect this value. +-- +-- [231 bytes/det] Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/DiffDetObject =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/DiffDetObject (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/DiffDetObject (revision 36815) @@ -0,0 +1,34 @@ + +diffObjName string VAR 8 NA IAU Name constructed from objID postion PS1.x JHHMMSS.SS+/-DDMMSS.S x procesing version +diffObjID dimensionless BIGINT 8 NA ODM object identifier index +diffgcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier +ippObjID dimensionless BIGINT 8 NA IPP object number +surveyID dimensionless TINYINT 1 255 Survey ID +skyCellID dimensionless REAL 4 -999 single float giving PrimaryCell.SkyCell identifier +htmID dimensionless BIGINT 8 NA HTM index +zoneID dimensionless INT 4 NA Zone index +randomID dimensionless BIGINT 8 0 Random integer between 0 and 2^32 = 4,394,967,296 remaining ramdom integer 0 +batchID dimensionless BIGINT 8 -999 +dvoRegionID dimensionless REAL 4 -999 identifier to dvo spatial region +objInfoFlag dimensionless BIGINT 8 -999 flag indicating odd properties +qualityFlag dimensionless TINYINT 1 0 subset of objInfoFlag - flags related to goodness of object +consistencyFlag dimensionless SMALLINT2 0 Value computed from associated detections, it is originally given by IPP and should agree with the ODM validation +ra degrees FLOAT 8 NA Right Ascension +dec degrees FLOAT 8 NA Declination +raErr arcsec REAL 4 0.0 Right Ascension error +decErr arcsec REAL 4 0.0 Declination error +cx dimensionless FLOAT 8 NA Cartesian x +cy dimensionless FLOAT 8 NA Cartesian y +cz dimensionless FLOAT 8 NA Cartesian z +lambda degrees FLOAT 8 -999 ecliptic longitude +beta degrees FLOAT 8 -999 ecliptic latitude +l degrees FLOAT 8 -999 galactic longitude +b degrees FLOAT 8 -999 galactic latitude +qfPerfect dimensionless REAL 4 -999 qfPerfect +dataRelease dimensionless TINYINT 1 NA Data release Version of this table +nDetections dimensionless SMALLINT2 -999 total number of detection measurements in all filters +ng dimensionless SMALLINT2 -999 number of detections in g filter +nr dimensionless SMALLINT2 -999 number of detections in g filter +ni dimensionless SMALLINT2 -999 number of detections in g filter +nz dimensionless SMALLINT2 -999 number of detections in g filter +ny dimensionless SMALLINT2 -999 number of detections in g filter Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/DiffDetection =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/DiffDetection (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/DiffDetection (revision 36815) @@ -0,0 +1,69 @@ +diffObjID dimensionless BIGINT 8 NA diff object identifier +diffgcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier +diffDetID dimensionless BIGINT 8 NA diff detection identifier +diffDetMetaID dimensionless BIGINT 8 NA diff detection meta identifier +ippDetectID dimensionless BIGINT 8 NA ipp detection id generated by IPP +ippObjID dimensionless BIGINT 8 NA ipp object id generated by IPP +filterID dimensionless TINYINT 1 NA filter ID: g=1, r=2, i=3, z=4, y=5, w=6, ... +surveyID dimensionless TINYINT 1 NA survey flag identifierr +randomDiffID dimensionless BIGINT 8 NA random diff id +skyCellID dimensionless REAL 4 -999 single float giving PrimaryCell.SkyCell identifier +dvoRegionID dimensionless REAL 4 -999 identifier to dvo spatial region +obsTime MeanJulianDays FLOAT 8 -999 Time of mid observation of positive detection in Mean Julian Days of positive detection +xPos pixels REAL 4 -999 measured x on diff image sky cell PSF fit +yPos pixels REAL 4 -999 measured y on diff image sky cell from PSF fit +xPosErr pixels REAL 4 -999 estimated error in x +yPosErr pixels REAL 4 -999 estimated error in y +pltScale arcsec/pix REAL 4 -999 plate scale at this location (from DVO) +posAngle degrees REAL 4 -999 position angle (sky-to-chip) at this location (from DVO) +---------------------------------------------------- next 8 came from old DiffDetCalib, zp derived from cpt tables of BOTH images +ra degrees FLOAT 8 NA Right Ascension +dec degrees FLOAT 8 NA Declination +raErr arcsec REAL 4 NA Right Ascension error -> posErr because RA,Dec same? +decErr arcsec REAL 4 NA Declination error +zp magnitude REAL 4 0 zeropoint (all that is needed to convert adu/sec to AB mag), no zpErr +telluricExt magnitude REAL 4 NA estimated extinction due to non-photometric conditions +expTime seconds REAL 4 -999 exposure time (informational) +airMass dimensionless REAL 4 0 airmass (informational) +----------------------------------------------------- attributes of positive detection +psfFlux adu/seconds REAL 4 -999 PSF instrumental flux (in analog-to-digital units/sec) or adu/sec +psfFluxErr adu/seconds REAL 4 -999 estimated error in flux +psfMajorFWHM arcsec REAL 4 -999 model PSF width in major axis +psfMinorFWHM arcsec REAL 4 -999 model PSF width in minor axis +psfTheta degrees REAL 4 -999 model PSF orientation angle degrees East of North +psfCore dimensionless REAL 4 -999 model PSF core parameter [k in (1 + kz + z^1.66)] +psfQf dimensionless REAL 4 -999 PSF coverage factor +psfQfPerfect dimensionless REAL 4 -999 PSF-weighted fraction of pixels totally unmasked +psfChiSq dimensionless REAL 4 -999 reduced-chisq of the psf model fit. (ndof?, npix?) +psfLikelihood dimensionless REAL 4 -999 PSF likelihood +momentXX arcsec^2 REAL 4 -999 moment XX +momentXY arcsec^2 REAL 4 -999 moment XY +momentYY arcsec^2 REAL 4 -999 momeny YY +momentR1 arcsec REAL 4 -999 first radial moment +momentRH arcsec REAL 4 -999 half light radius +momentM3C arcsec^3 REAL 4 -999 3rd moment sin(theta) +momentM3S arcsec^3 REAL 4 -999 3rd moment cos(theta) +momentM4C arcsec^4 REAL 4 -999 4th moment sin(theta) +momentM4S arcsec^4 REAL 4 -999 4th moment cos(theta) +apFlux adu/seconds REAL 4 -999 Aperture flux +apFluxErr adu/seconds REAL 4 -999 Aperture flux error +apFillF dimensionless REAL 4 -999 Aperture fill factor +kronFlux adu/seconds REAL 4 -999 Kron flux +kronFluxErr adu/seconds REAL 4 -999 Kron flux error +kronRad raw pixels REAL 4 -999 Kron radius +kronRadErr raw pixels REAL 4 -999 Kron radius error +------------------------------------------------------- from diff image cmf/smf files +diffNPos dimensionless REAL 4 -999 npix > 3sigma +diffFRatio dimensionless REAL 4 -999 fPos/(fPos +fNeg) +diffNBad dimensionless REAL 4 -999 nPos/(nPos+nNeg) +diffNMask dimensionless REAL 4 -999 nPos/(nPos + nMask) +diffNAll dimensionless REAL 4 -999 nPos/(nPos + nMask + nNeg) +diffPdist arcsec REAL 4 -999 distance to positive match source +diffNdist arcsec REAL 4 -999 distance to negative match source +diffPSN dimensionless REAL 4 -999 signal to noise of pos match source +diffNSN dimensionless REAL 4 -999 signal to noise of neg match source +------------------------------------------------------- +sky adu/sec/pixel REAL 4 -999 PSF sky level at source +skyErr adu/sec/pixel REAL 4 -999 estimated error in sky +infoFlag dimensionless BIGINT 8 -999 flag indicating provenance information +dataRelease dimensionless TINYINT 1 NA Data release when this detection was originally taken. Recalibrations do not affect this value. Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedMeanObject =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedMeanObject (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedMeanObject (revision 36815) @@ -0,0 +1,62 @@ +objID dimensionless BIGINT 8 NA ODM object identifier index +gcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier +ippObjID dimensionless BIGINT 8 NA IPP object identifier +nDetections dimensionless SMALLINT 2 -999 total number of detection measurements in all filters +batchID dimensionless BIGINT 8 NA batch id +----------------------------------------------------- replicate to bottom for each filter +gStackID INT 4 stack image id (how to carry through IPP + DVO) +gnTotal dimensionless SMALLINT 2 -999 number of detections in g filter +gnIncPSFMag dimensionless SMALLINT 2 -999 number of detections included in robust psf mean in g filter +gnIncKronMag dimensionless SMALLINT 2 -999 number of detections included in robust mean of Kron mag in g filter +gnIncApMag dimensionless SMALLINT 2 -999 number of detections included in robust mean of Ap mag in g filter +gnIncR5 dimensionless SMALLINT 2 -999 number of detections included in robust mean of ApFlx 5 in g filter +gnIncR6 dimensionless SMALLINT 2 -999 number of detections included in robust mean of ApFlx 6 in g filter +------------------------------------------------------- one of the above also corresponds to the moments +gPSFMag AB magnitude REAL 4 -999 robust mean g psf AB magnitude (sigma clipping or MAP or go to 5 or 7 number sumary? 1/12 is ~9th percentile +gPSFMagErr AB magnitude REAL 4 -999 estimated error of g psf AB magnitude mean (individual errors added in quadrature) +gPSFMagStd dimensionless REAL 4 -999 standard deviation of measurements included in the robust mean +gKronMag AB magnitude REAL 4 -999 mean g kron AB magnitude +gKronMagErr AB magnitude REAL 4 -999 estimated error of g kron AB magnitude mean +gKronMagStd dimensionless REAL 4 -999 standard deviation of measurements included in the robust mean +gApMag AB magnitude REAL 4 -999 mean g kron AB magnitude +gApMagErr AB magnitude REAL 4 -999 estimated error of g kron AB magnitude mean +gApMagStd dimensionless REAL 4 -999 standard deviation of measurements included in the robust mean +------------------------------------------------------ +gFmeanflxR5 adu/seconds REAL 4 -999 Flux inside r = 5 in g unconvolved stack +gFmeanflxR5Err adu/seconds REAL 4 -999 estimated error is flxR5 +gFmeanflxR5Std adu/seconds REAL 4 -999 estimated standard deviation in flxR5 +gFmeanflxR5Fill dimensionless REAL 4 -999 estimated filling factor at R5 +gFmeanflxR6 adu/seconds REAL 4 -999 Flux inside r = 6 in g unconvolved stack +gFmeanflxR6Err adu/seconds REAL 4 -999 estimated error is flxR6 +gFmeanflxR6Std adu/seconds REAL 4 -999 estimated standard deviation in flxR6 +gFmeanflxR6Fill dimensionless REAL 4 -999 estimated filling factor at R6 +gFlags dimensionless BIGINT 8 NA flags for g forced +------------------------------------------------------ +gLensObjSmearX11 arcsec^-2 REAL 4 -999 per-object smear polarizability X11 term +gLensObjSmearX12 arcsec^-2 REAL 4 -999 per-object smear polarizability X12 term +gLensObjSmearX22 arcsec^-2 REAL 4 -999 per-object smear polarizability X22 term +gLensObjSmearE1 arcsec^-2 REAL 4 -999 per-object smear polarizability E1 term +gLensObjSmearE2 arcsec^-2 REAL 4 -999 per-object smear polarizability E2 term +gLensObjShearX11 dimensionless REAL 4 -999 per-object shear polarizability X11 term +gLensObjShearX12 dimensionless REAL 4 -999 per-object shear polarizability X12 term +gLensObjShearX22 dimensionless REAL 4 -999 per-object shear polarizability X22 term +gLensObjShearE1 dimensionless REAL 4 -999 per-object shear polarizability E1 term +gLensObjShearE2 dimensionless REAL 4 -999 per-object shear polarizability E2 term +gLensPSFSmearX11 arcsec^-2 REAL 4 -999 psf model smear polarizability X11 term +gLensPSFSmearX12 arcsec^-2 REAL 4 -999 psf model smear polarizability X12 term +gLensPSFSmearX22 arcsec^-2 REAL 4 -999 psf model smear polarizability X22 term +gLensPSFSmearE1 arcsec^-2 REAL 4 -999 psf model smear polarizability E1 term +gLensPSFSmearE2 arcsec^-2 REAL 4 -999 psf model smear polarizability E2 term +gLensPSFShearX11 dimensionless REAL 4 -999 psf model shear polarizability X11 term +gLensPSFShearX12 dimensionless REAL 4 -999 psf model shear polarizability X12 term +gLensPSFShearX22 dimensionless REAL 4 -999 psf model shear polarizability X22 term +gLensPSFShearE1 dimensionless REAL 4 -999 psf model shear polarizability E1 term +gLensPSFShearE2 dimensionless REAL 4 -999 psf model shear polarizability E2 term +------------------------------------------------------ +gGamma arcsec^2 REAL 4 -999 second moment (Mxx + Myy) +gE1 dimensionless REAL 4 -999 polarization, KSB-corrected (Mxx - Myy) / (Mxx + Myy) +gE2 dimensionless REAL 4 -999 polarization, KSB-corrected 2Mxy / (Mxx + Myy) + +-- duplicated for other filters +-- [184 byte/obj/filter + 22 byte/obj] + Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpMeasurement =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpMeasurement (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpMeasurement (revision 36815) @@ -0,0 +1,82 @@ +objID dimensionless BIGINT 8 NA ODM object identifier +gcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier +detectID dimensionless BIGINT 8 NA ODM detection identifier +ippObjID dimensionless BIGINT 8 NA ippobject id generated by IPP +ippDetectID dimensionless BIGINT 8 NA detection id generated by IPP +filterID dimensionless TINYINT 1 NA filter ID: g=1, r=2, i=3, z=4, y=5, w=6, ... +surveyID dimensionless TINYINT 1 NA survey flag identifier +forcedWarpID dimensionless BIGINT 8 NA IPP warp_id +randomWarpID dimensionless BIGINT 8 NA Random warp_id +skyCellID dimensionless REAL 4 -999 single float giving PrimaryCell.SkyCell identifier +dvoRegionID dimensionless REAL 4 -999 identifier to dvo spatial region +obsTime MeanJulianDays FLOAT 8 -999 Time of mid observation in Mean Julian Days +------------------------------------------------------ +zp magnitude REAL 4 0 zeropoint (only thing needed to convert adu/sec to AB mag), note no zpErr +telluricExt magnitude REAL 4 NA estimated extinction due to non-photometric conditions +expTime seconds REAL 4 -999 exposure time (informational) +airMass dimensionless REAL 4 0 airmass (informational) +------------------------------------------------------ +psfFlux adu/seconds REAL 4 -999 PSF instrumental flux (in analog-to-digital units/sec) or adu/sec +psfFluxErr adu/seconds REAL 4 -999 estimated error in flux +psfMajorFWHM arcsec REAL 4 -999 model PSF width in major axis +psfMinorFWHM arcsec REAL 4 -999 model PSF width in minor axis +psfTheta degrees REAL 4 -999 model PSF orientation angle degrees East of North +psfCore dimensionless REAL 4 -999 model PSF core parameter [k in (1 + kz + z^1.66)] +psfQf dimensionless REAL 4 -999 PSF coverage factor +psfQfPerfect dimensionless REAL 4 -999 PSF-weighted fraction of pixels totally unmasked +psfChiSq dimensionless REAL 4 -999 reduced-chisq of the psf model fit. (ndof?, npix?) +psfLikelihood dimensionless REAL 4 -999 PSF likelihood +momentXX arcsec^2 REAL 4 -999 moment XX +momentXY arcsec^2 REAL 4 -999 moment XY +momentYY arcsec^2 REAL 4 -999 momeny YY +momentR1 arcsec^1 REAL 4 -999 first radial moment +momentRH arcsec REAL 4 -999 to be half light radius +momentM3C arcsec^3 REAL 4 -999 3rd moment sin(theta) +momentM3S arcsec^3 REAL 4 -999 3rd moment cos(theta) +momentM4C arcsec^4 REAL 4 -999 4th moment sin(theta) +momentM4S arcsec^4 REAL 4 -999 4th moment cos(theta) + +lensObjSmearX11 arcsec^-2 REAL 4 -999 per-object smear polarizability X11 term +lensObjSmearX12 arcsec^-2 REAL 4 -999 per-object smear polarizability X12 term +lensObjSmearX22 arcsec^-2 REAL 4 -999 per-object smear polarizability X22 term +lensObjSmearE1 arcsec^-2 REAL 4 -999 per-object smear polarizability E1 term +lensObjSmearE2 arcsec^-2 REAL 4 -999 per-object smear polarizability E2 term +lensObjShearX11 dimensionless REAL 4 -999 per-object shear polarizability X11 term +lensObjShearX12 dimensionless REAL 4 -999 per-object shear polarizability X12 term +lensObjShearX22 dimensionless REAL 4 -999 per-object shear polarizability X22 term +lensObjShearE1 dimensionless REAL 4 -999 per-object shear polarizability E1 term +lensObjShearE2 dimensionless REAL 4 -999 per-object shear polarizability E2 term +lensPSFSmearX11 arcsec^-2 REAL 4 -999 psf model smear polarizability X11 term +lensPSFSmearX12 arcsec^-2 REAL 4 -999 psf model smear polarizability X12 term +lensPSFSmearX22 arcsec^-2 REAL 4 -999 psf model smear polarizability X22 term +lensPSFSmearE1 arcsec^-2 REAL 4 -999 psf model smear polarizability E1 term +lensPSFSmearE2 arcsec^-2 REAL 4 -999 psf model smear polarizability E2 term +lensPSFShearX11 dimensionless REAL 4 -999 psf model shear polarizability X11 term +lensPSFShearX12 dimensionless REAL 4 -999 psf model shear polarizability X12 term +lensPSFShearX22 dimensionless REAL 4 -999 psf model shear polarizability X22 term +lensPSFShearE1 dimensionless REAL 4 -999 psf model shear polarizability E1 term +lensPSFShearE2 dimensionless REAL 4 -999 psf model shear polarizability E2 term + +apFlux adu/seconds REAL 4 -999 Aperture flux +apFluxErr adu/seconds REAL 4 -999 Aperture flux error +apFillF dimensionless REAL 4 -999 Aperture fill factor +kronFlux adu/seconds REAL 4 -999 Kron flux +kronFluxErr adu/seconds REAL 4 -999 Kron flux error +kronRad arcsec REAL 4 -999 Kron radius +kronRadErr arcsed REAL 4 -999 Kron radius error +------------------------------------------------------ +flxR5 adu/seconds REAL 4 -999 Flux inside r = 5 +flxR5Err adu/seconds REAL 4 -999 estimated error is flxR5 +flxR5Std adu/seconds REAL 4 -999 estimated standard deviation in flxR5 +flxR5Fill dimensionless REAL 4 -999 estimated filling factor at R5 +flxR6 adu/seconds REAL 4 -999 Flux inside r = 6 +flxR6Err adu/seconds REAL 4 -999 estimated error is flxR6 +flxR6Std adu/seconds REAL 4 -999 estimated standard deviation in flxR6 +flxR6Fill dimensionless REAL 4 -999 estimated filling factor at R6 +------------------------------------------------------ +sky adu/sec/pixel REAL 4 -999 PSF sky level at source +skyErr adu/sec/pixel REAL 4 -999 estimated error in sky +infoFlag dimensionless BIGINT 8 -999 flag indicating provenance information +dataRelease dimensionless TINYINT 1 NA Data release when this detection was originally taken. Recalibrations do not affect this value. + +-- [295 byte/det] Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/MeanObject =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/MeanObject (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/MeanObject (revision 36815) @@ -0,0 +1,27 @@ + +-- The "best available" measurements refer first to those objects with qfPerfect > 0.85 and good flags, +-- but descends down a "waterfall logic" in ipp so that there exists a mean mag for less than ideal objects. The logic is given in Magnier etal 2013. + +objID dimensionless BIGINT 8 NA ODM object identifier index +gcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier +gQfPerfect dimensionless REAL 4 -999 maximum psf qfPerfect from best available g band detections +gMeanPSFMag AB magnitude REAL 4 -999 mean g psf AB magnitude from best available measurements (best available as current defined by ipp "waterfall logic" +gMeanPSFMagErr AB magnitude REAL 4 -999 estimated error of best availalbe g-band psf AB magnitudes (individual errors added in quadrature) +gnIncPSFMag dimensionless SMALLINT2 -999 number of best available detections included in mean psfMag +gMeanPSFMagStd dimensioless REAL 4 -999 standard deviation of best available measurements - compared with MeanErr this is one measure of true variability +gMinPSFMag AB magnitude REAL 4 -999 minimum best available PSFMag - min and max are given for PSFMag as they may indicate variability. +gMaxPSFMag AB magnitude REAL 4 -999 maximum best available PSFMag + +gMeanKronMag AB magnitude REAL 4 -999 mean g kron AB magnitude from best available measurements +gMeanKronMagErr AB magnitude REAL 4 -999 estimated error of mean g kron AB magnitude +gnIncKronMag dimensionless SMALLINT2 -999 number of best available detections included mean Kron mag +gMeanKronMagStd dimensioless REAL 4 -999 standard deviation of best available measurements + +gMeanApMag AB magnitude REAL 4 -999 mean g kron AB magnitude from best available measurements +gMeanApMagErr AB magnitude REAL 4 -999 estimated error of g kron AB magnitude mean +gnIncApMag dimensionless SMALLINT2 -999 number of detections included in best available mean of Kron mag in g filter +gMeanApMagStd dimensioless REAL 4 -999 standard deviation of best available measurements +gFlags dimensionless BIGINT 8 NA flags for g mean +-- duplicate for other filters + +[62 byte/obj/filter + 8 byte/filter] Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ObjectThin =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ObjectThin (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ObjectThin (revision 36815) @@ -0,0 +1,51 @@ + +objName string VAR 8 NA IAU Name constructed from objID postion PS1.x JHHMMSS.SS+/-DDMMSS.S where x is leading number of procesing version +objID dimensionless BIGINT 8 NA ODM object identifier index +gcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier +ippObjID dimensionless BIGINT 8 NA IPP object number +surveyID dimensionless TINYINT 1 255 Survey ID +skyCellID dimensionless REAL 4 -999 single float giving PrimaryCell.SkyCell identifier +htmID dimensionless BIGINT 8 NA HTM index +zoneID dimensionless INT 4 NA Zone index +randomID dimensionless BIGINT 8 0 Random integer between 0 and 2^32 = 4,394,967,296 remaining ramdom integer 0 +batchID dimensionless BIGINT 8 -999 batch id +dvoRegionID dimensionless REAL 4 -999 identifier of dvo spatial region - dvo cat id +dataRelease dimensionless TINYINT 1 NA Data release Version of this table +objInfoFlag dimensionless BIGINT 8 -999 flag indicating odd properties +qualityFlag dimensionless TINYINT 1 0 subset of objInfoFlag - flags related to goodness of object +consistencyFlag dimensionless SMALLINT 2 0 Value computed from associated detections, it is originally given by IPP and should agree with the ODM validation +raStack degrees FLOAT 8 -999 Right Ascension - best weighted RA across filters from stack WHENEVER an object is detected in the stack +decStack degrees FLOAT 8 -999 Declination - best weighted Dec across filters from stack WHENEVER an object is detected in the stack +raStackErr arcsec REAL 4 -999 Error in stack Right Ascension, note will have a systematic floor, and is not necessary the best ra,dec for all objects +decStackErr arcsec REAL 4 -999 Error in stack Declination, note will have a systematic floor, and is not necessarily the best ra,dec for all objects +raMean degrees FLOAT 8 -999 Right Ascension from the Mean of RA from individual detections if it exists. This is for information only +decMean degrees FLOAT 8 -999 Declination from the Mean of Dec from individual detections if it exists This is for information only. +raMeanErr arcsec REAL 4 -999 Combination of the measurement Errors in the Right Ascension from the mean detections if they exist +decMeanErr arcsec REAL 4 -999 Combination of the measurement Errors in the Declination measurements if they exist +raMeanStd arcsec Real 4 -999 standard deviation of Right Ascension measurements in detections if they exist +decMeanStd arcsec REAL 4 -999 standard deviation of the Declination measurements if they exist +-------------------------------------------------------------------------------------------------------- +-- Note: the following three sets of coordinate systems are based on stack if it exists, and mean if it does not. +-- This means cone or box searches work on the stack and consistent with Primary and Best stack detection. +-- For objects without a stack postion, (moving, transient, or false dectection) a cone search may be incomplete for +-- an object within less than 1 arc sec of the boundary edge. But science cases here will want to work from Detection +-- Table anyway, or can vary cone search by 1'' radius to check for incompleteness. +cx dimensionless FLOAT 8 NA Cartesian x from Stack RA,Dec WHENEVER a stack detection exists, and Mean RA, Dec (mean of one?) when it doesn't +cy dimensionless FLOAT 8 NA Cartesian y from Stack RA,Dec WHENEVER a stack detection exists, and mean RA, Dec (mean of one?) when it doesn't +cz dimensionless FLOAT 8 NA Cartesian z from Stack RA,Dec WHENEVER a stack detection exists, ditto +lambda degrees FLOAT 8 -999 ecliptic longitude from Stack RA,Dec WHENEVER A STACK MEASURMENT EXISTS and Mean RA,Dec (mean of one?) otherwise +beta degrees FLOAT 8 -999 ecliptic latitude ditto +l degrees FLOAT 8 -999 galactic longitude ditto +b degrees FLOAT 8 -999 galactic latitude ditto +--------------------------------------------------------------------------------- +nStackObjectRows dimensionless SMALLINT 2 -999 number of independent StackObjectRows this object has. +-- zero if not detected in the Stack, 1 if there is a primary, 2 or more if it is in an overlap region +nStackDetections dimensionless TINYINT 2 255 which filter bands it is detected in (not forced) or if it was masked in a band. +nDetections dimensionless SMALLINT 2 -999 total number of detection measurements in all filters +ng dimensionless SMALLINT 2 -999 number of detections in individual g filter exposures +nr dimensionless SMALLINT 2 -999 number of detections in individual r filter exposures +ni dimensionless SMALLINT 2 -999 number of detections in individual i filter exposures +nz dimensionless SMALLINT 2 -999 number of detections in individual z filter exposures +ny dimensionless SMALLINT 2 -999 number of detections in individual y filter exposures + +[197 byte/obj] Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlx =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlx (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlx (revision 36815) @@ -0,0 +1,60 @@ + +objID dimensionless BIGINT 8 NA ODM object identifier +gcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier +surveyID dimensionless TINYINT 1 0 stack type identifier +skyCellID dimensionless REAL 4 -999 single float giving PrimaryCell.SkyCell identifier +randomStackObjID dimensionless BIGINT 8 NA random stack id +stackDetectRowID dimensionless BIGINT 8 NA identifies which of up to 5 possible stackdetctions this Row refers to: Primary, up to 3 Secondary, 1 best +primaryDetection dimensionless TINYINT 1 255 identifies if this row is a primary stack detection. True about 80% of time. +bestDetection dimensionless TINYINT 1 255 identifies if this row is a best detection or not. Also set if only a primary detection exists. +-- the Primary Dectection, 0 to 3 possible secondary dectections, and the "best" per filter. +dvoRegionID dimensionless REAL 4 -999 identifier to dvo spatial region +dataRelease dimensionless TINYINT 1 NA Data release when this table was loaded. +------------------------------------------------------- replicate to end for each filter g,r,i,z,y +gstackDetectID dimensionless BIGINT 8 NA ODM detection identifier +gstackMetaID dimensionless BIGINT 8 NA stack identifier +gippObjID dimensionless BIGINT 8 NA ipp object identifier +gippDetectID dimensionless BIGINT 8 NA stack identifier +--------------------------------------------------------unconvolved +gflxR3 adu/seconds REAL 4 -999 Flux inside r = 3 +gflxR3Err adu/seconds REAL 4 -999 estimated error is flxR3 +gflxR3Std adu/seconds REAL 4 -999 estimated standard deviation in flxR3 +gflxR3Fill dimensionless REAL 4 -999 estimated filling factor at R3 +gflxR4 adu/seconds REAL 4 -999 Flux inside r = 4 +gflxR4Err adu/seconds REAL 4 -999 estimated error is flxR4 +gflxR4Std adu/seconds REAL 4 -999 estimated standard deviation in flxR4 +gflxR4Fill dimensionless REAL 4 -999 estimated filling factor at R4 +gflxR5 adu/seconds REAL 4 -999 Flux inside r = 5 +gflxR5Err adu/seconds REAL 4 -999 estimated error is flxR5 +gflxR5Std adu/seconds REAL 4 -999 estimated standard deviation in flxR5 +gflxR5Fill dimensionless REAL 4 -999 estimated filling factor at R5 +---------------------------------------------------- convolved across all bands to 6 or 8 pixels +gc1flxR3 adu/seconds REAL 4 -999 Flux inside r = 3 +gc1flxR3Err adu/seconds REAL 4 -999 estimated error is c1flxR3 +gc1flxR3Std adu/seconds REAL 4 -999 estimated standard deviation in c1flxR3 +gc1flxR3Fill dimensionless REAL 4 -999 estimated filling factor at R3 +gc1flxR4 adu/seconds REAL 4 -999 Flux inside r = 4 +gc1flxR4Err adu/seconds REAL 4 -999 estimated error is c1flxR4 +gc1flxR4Std adu/seconds REAL 4 -999 estimated standard deviation in c1flxR4 +gc1flxR4Fill dimensionless REAL 4 -999 estimated filling factor at R4 +gc1flxR5 adu/seconds REAL 4 -999 Flux inside r = 5 +gc1flxR5Err adu/seconds REAL 4 -999 estimated error is c1flxR5 +gc1flxR5Std adu/seconds REAL 4 -999 estimated standard deviation in c1flxR5 +gc1flxR5Fill dimensionless REAL 4 -999 estimated filling factor at R5 +---------------------------------------------------- convolved across all bands to 6 or 8 pixels +gc2flxR3 adu/seconds REAL 4 -999 Flux inside r = 3 +gc2flxR3Err adu/seconds REAL 4 -999 estimated error in c2flxR3 +gc2flxR3Std adu/seconds REAL 4 -999 estimated standard deviation in c2flxR3 +gc2flxR3Fill dimensionless REAL 4 -999 estimated filling factor at R3 +gc2flxR4 adu/seconds REAL 4 -999 Flux inside r = 4 +gc2flxR4Err adu/seconds REAL 4 -999 estimated error in c2flxR4 +gc2flxR4Std adu/seconds REAL 4 -999 estimated standard deviation in c2flxR4 +gc2flxR4Fill dimensionless REAL 4 -999 estimated filling factor at R4 +gc2flxR5 adu/seconds REAL 4 -999 Flux inside r = 5 +gc2flxR5Err adu/seconds REAL 4 -999 estimated error in c2flxR5 +gc2flxR5Std adu/seconds REAL 4 -999 estimated standard deviation in c2flxR5 +gc2flxR5Fill dimensionless REAL 4 -999 estimated filling factor at R5 + +-- repeat for other filters with appropriate leading prefex. +-- [168 byte/filter/obj + 44 byte/obj] + Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFit =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFit (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFit (revision 36815) @@ -0,0 +1,204 @@ + +objID dimensionless BIGINT 8 NA ODM object identifier +gcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier +surveyID dimensionless TINYINT 1 NA survey flag identifier +skyCellID dimensionless REAL 4 -999 single float giving PrimaryCell.SkyCell identifier +randomStackObjID dimensionless BIGINT 8 NA random stack id +stackDetectRowID dimensionless BIGINT 8 NA identifies which of up to 5 possible stackdetctions this Row refers to: Primary, up to 3 Secondary, 1 best +primaryDetection dimensionless TINYINT 1 255 identifies if this row is a primary stack detection. True about 80% of time. +bestDetection dimensionless TINYINT 1 255 identifies if this row is a best detection or not. Also set if only a primary detection exists. +-- the Primary Dectection, 0 to 3 possible secondary dectections, and the "best" per filter. +dvoRegionID dimensionless REAL 4 -999 identifier to dvo spatial region +dataRelease dimensionless TINYINT 1 NA Data release when this table was loaded +-------------------------------------------------------- replicate below for all filters (grizy) +glogC dimensionless REAL 4 -999 concentration index +glogA dimensionless REAL 4 -999 asymmetry index +gclump dimensionless REAL 4 -999 clumpiness factor +-------------------------------------------------------- replicate below for all filters (grizy) +gstackDetectID dimensionless BIGINT 8 NA ODM detection identifier +gstackMetaID dimensionless BIGINT 8 NA stack identifier +gippObjID dimensionless BIGINT 8 NA ipp object identifier +gippDetectID dimensionless BIGINT 8 NA ipp detect identifier +gdeVRadius arcsec REAL 4 -999 deVaucouleurs radius +gdeVRadiusErr arcsec REAL 4 -999 estimated error in deVaucouleurs radius +gdeVFlux adu/seconds REAL 4 -999 deVaucouleurs flux +gdeVFluxErr adu/seconds REAL 4 -999 estimated error in deVaucouleurs flux +gdeVAb dimensionless REAL 4 -999 deVaucoulerus axis ratio +gdeVAbErr dimensionless REAL 4 -999 estimated error in deVaucoulerus axis ratio +gdeVPhi degrees REAL 4 -999 estmated phi of deVaucouleurs axis. Degrees East of North. +gdeVPhiErr degrees REAL 4 -999 estmated error of phi of deVaucouleurs axis +graDeVOff arcsec REAL 4 -999 Offset in RA of deVaucouleurs fit from PSF RA +gdecDeVOff arcsec REAL 4 -999 Offset in DEC of deVaucouleurs fit from PSF DEC +graDeVOffErr arcsec REAL 4 -999 estimated error in ra offset +gdecDeVOffErr arcsec REAL 4 -999 estimated error in dec offset +gdeVCf dimensionless REAL 4 -999 deVaucouleurs fit coverage factor +gdeVLikelihood dimensionless REAL 4 -999 deVaucouleurs fit likelihood factor +---------------------------------------------------------------------------------------- +gexpRadius arcsec REAL 4 -999 Exponential fit radius +gexpRadiusErr arcsec REAL 4 -999 estimated error in Exponential fit radius +gexpFlux adu/seconds REAL 4 -999 Exponential fit flux +gexpFluxErr adu/seconds REAL 4 -999 estimated error in expFlux +gexpAb dimensionless REAL 4 -999 Exponential fit axis ratio +gexpAbErr dimensionless REAL 4 -999 estimated error in Exponential fit axis ratio +gexpPhi degrees REAL 4 -999 estmated phi of Exponential axis +gexpPhiErr degrees REAL 4 -999 estmated error of phi of Exponential axis +graExpOff dimensionless REAL 4 -999 Offset in RA of Exponential fit from PSF RA +gdecExpOff dimensionless REAL 4 -999 Offset in DEC of Exponential fit from PSF DEC +graExpOffErr dimensionless REAL 4 -999 estimated error in raExpOff +gdecExpOffErr dimensionless REAL 4 -999 estimated error in decExpOff +gexpCf dimensionless REAL 4 -999 Exponential fit coverage factor +gexpLikelihood dimensionless REAL 4 -999 Exponential fit likelihood factor +--------------------------------------------------------------------------------------- +gserRadius arcsec REAL 4 -999 Sersic radius +gserRadiusErr arcsed REAL 4 -999 estimated error in Sersic radius +gserFlux adu/seconds REAL 4 -999 Sersic Flux +gserFluxErr adu/seconds REAL 4 -999 estimated error in serFlux +gserAb dimensionless REAL 4 -999 Sersic axis ratio +gserAbErr dimensionlessn REAL 4 -999 estimated error in Sersic axis ratio +gserNu dimensionlessn REAL 4 -999 Sersic index +gserNuErr diemensionless REAL 4 -999 estimated error in Sersic index +gserPhi degrees REAL 4 -999 estmated phi of Sersic axis +gserPhiErr degrees REAL 4 -999 estmated error of phi of Sersic axis +graSerOff dimensionless REAL 4 -999 Offset in RA of Sersic fit from PSF RA +gdecSerOff dimensionless REAL 4 -999 Offset in DEC of Sersic fit from PSF DEC +graSerOffErr dimensionless REAL 4 -999 estimated error in raSerOff +gdecSerOffErr dimensionless REAL 4 -999 estimated error in decSerOff +gserCf dimensionless REAL 4 -999 Sersic fit coverage factor +gserLikelihood dimensionless REAL 4 -999 Sersic fit likelihood factor +--------------------------------------------------------------------------------------- +gpetRadius pixels REAL 4 -999 Petrosian radius +gpetRadiusErr pixels REAL 4 -999 estimated error inPetrosian radius +gpetFlux adu/sec REAL 4 -999 Petrosian Flux +gpetFluxErr adu/sec REAL 4 -999 estimated error in petFlux +gpetR50 pixels REAL 4 -999 Petrosian radius at 50% light +gpetR50Err pixels REAL 4 -999 estimated error inPetrosian radius at 50% light +gpetR90 pixels REAL 4 -999 Petrosian radius at 90% light +gpetR90Err pixels REAL 4 -999 estimated error in Petrosian radius at 90% light +gpetCf dimensionless REAL 4 -999 Petrosian fit coverage factor +--------------------------------------------------------unconvolved +gflxR1 adu/seconds REAL 4 -999 Flux inside r = 1 +gflxR1Err adu/seconds REAL 4 -999 estimated error is flxR1 +gflxR1Std adu/seconds REAL 4 -999 estimated standard deviation in flxR1 +gflxR1Fill dimensionless REAL 4 -999 estimated filling factor at R1 +gflxR2 adu/seconds REAL 4 -999 Flux inside r = 2 +gflxR2Err adu/seconds REAL 4 -999 estimated error is flxR2 +gflxR2Std adu/seconds REAL 4 -999 estimated standard deviation in flxR2 +gflxR2Fill dimensionless REAL 4 -999 estimated filling factor at R1 +gflxR3 adu/seconds REAL 4 -999 Flux inside r = 3 +gflxR3Err adu/seconds REAL 4 -999 estimated error is flxR3 +gflxR3Std adu/seconds REAL 4 -999 estimated standard deviation in flxR3 +gflxR3Fill dimensionless REAL 4 -999 estimated filling factor at R3 +gflxR4 adu/seconds REAL 4 -999 Flux inside r = 4 +gflxR4Err adu/seconds REAL 4 -999 estimated error is flxR4 +gflxR4Std adu/seconds REAL 4 -999 estimated standard deviation in flxR4 +gflxR4Fill dimensionless REAL 4 -999 estimated filling factor at R4 +gflxR5 adu/seconds REAL 4 -999 Flux inside r = 5 +gflxR5Err adu/seconds REAL 4 -999 estimated error is flxR5 +gflxR5Std adu/seconds REAL 4 -999 estimated standard deviation in flxR5 +gflxR5Fill dimensionless REAL 4 -999 estimated filling factor at R5 +gflxR6 adu/seconds REAL 4 -999 Flux inside r = 6 +gflxR6Err adu/seconds REAL 4 -999 estimated error is flxR6 +gflxR6Std adu/seconds REAL 4 -999 estimated standard deviation in flxR6 +gflxR6Fill dimensionless REAL 4 -999 estimated filling factor at R6 +gflxR7 adu/seconds REAL 4 -999 Flux inside r = 7 +gflxR7Err adu/seconds REAL 4 -999 estimated error is flxR7 +gflxR7Std adu/seconds REAL 4 -999 estimated standard deviation in flxR7 +gflxR7Fill dimensionless REAL 4 -999 estimated filling factor at R7 +gflxR8 adu/seconds REAL 4 -999 Flux inside r = 8 +gflxR8Err adu/seconds REAL 4 -999 estimated error is flxR8 +gflxR8Std adu/seconds REAL 4 -999 estimated standard deviation in flxR8 +gflxR8Fill dimensionless REAL 4 -999 estimated filling factor at R8 +gflxR9 adu/seconds REAL 4 -999 Flux inside r = 9 +gflxR9Err adu/seconds REAL 4 -999 estimated error is flxR9 +gflxR9Std adu/seconds REAL 4 -999 estimated standard deviation in flxR9 +gflxR9Fill dimensionless REAL 4 -999 estimated filling factor at R9 +gflxR10 adu/seconds REAL 4 -999 Flux inside r = 10 +gflxR10Err adu/seconds REAL 4 -999 estimated error is flxR10 +gflxR10Std adu/seconds REAL 4 -999 estimated standard deviation in flxR10 +gflxR10Fill dimensionless REAL 4 -999 estimated filling factor at R10 +---------------------------------------------------- convolved across all bands to 6 or 8 pixels +gc1flxR1 adu/seconds REAL 4 -999 Flux inside r = 1 +gc1flxR1Err adu/seconds REAL 4 -999 estimated error is c1flxR1 +gc1flxR1Std adu/seconds REAL 4 -999 estimated standard deviation in c1flxR1 +gc1flxR1Fill dimensionless REAL 4 -999 estimated filling factor at R1 +gc1flxR2 adu/seconds REAL 4 -999 Flux inside r = 2 +gc1flxR2Err adu/seconds REAL 4 -999 estimated error is c1flxR2 +gc1flxR2Std adu/seconds REAL 4 -999 estimated standard deviation in c1flxR2 +gc1flxR2Fill dimensionless REAL 4 -999 estimated filling factor at R1 +gc1flxR3 adu/seconds REAL 4 -999 Flux inside r = 3 +gc1flxR3Err adu/seconds REAL 4 -999 estimated error is c1flxR3 +gc1flxR3Std adu/seconds REAL 4 -999 estimated standard deviation in c1flxR3 +gc1flxR3Fill dimensionless REAL 4 -999 estimated filling factor at R3 +gc1flxR4 adu/seconds REAL 4 -999 Flux inside r = 4 +gc1flxR4Err adu/seconds REAL 4 -999 estimated error is c1flxR4 +gc1flxR4Std adu/seconds REAL 4 -999 estimated standard deviation in c1flxR4 +gc1flxR4Fill dimensionless REAL 4 -999 estimated filling factor at R4 +gc1flxR5 adu/seconds REAL 4 -999 Flux inside r = 5 +gc1flxR5Err adu/seconds REAL 4 -999 estimated error is c1flxR5 +gc1flxR5Std adu/seconds REAL 4 -999 estimated standard deviation in c1flxR5 +gc1flxR5Fill dimensionless REAL 4 -999 estimated filling factor at R5 +gc1flxR6 adu/seconds REAL 4 -999 Flux inside r = 6 +gc1flxR6Err adu/seconds REAL 4 -999 estimated error is c1flxR6 +gc1flxR6Std adu/seconds REAL 4 -999 estimated standard deviation in c1flxR6 +gc1flxR6Fill dimensionless REAL 4 -999 estimated filling factor at R6 +gc1flxR7 adu/seconds REAL 4 -999 Flux inside r = 7 +gc1flxR7Err adu/seconds REAL 4 -999 estimated error is c1flxR7 +gc1flxR7Std adu/seconds REAL 4 -999 estimated standard deviation in c1flxR7 +gc1flxR7Fill dimensionless REAL 4 -999 estimated filling factor at R7 +gc1flxR8 adu/seconds REAL 4 -999 Flux inside r = 8 +gc1flxR8Err adu/seconds REAL 4 -999 estimated error is c1flxR8 +gc1flxR8Std adu/seconds REAL 4 -999 estimated standard deviation in c1flxR8 +gc1flxR8Fill dimensionless REAL 4 -999 estimated filling factor at R8 +gc1flxR9 adu/seconds REAL 4 -999 Flux inside r = 9 +gc1flxR9Err adu/seconds REAL 4 -999 estimated error is c1flxR9 +gc1flxR9Std adu/seconds REAL 4 -999 estimated standard deviation in c1flxR9 +gc1flxR9Fill dimensionless REAL 4 -999 estimated filling factor at R9 +gc1flxR10 adu/seconds REAL 4 -999 Flux inside r = 10 +gc1flxR10Err adu/seconds REAL 4 -999 estimated error is c1flxR10 +gc1flxR10Std adu/seconds REAL 4 -999 estimated standard deviation in c1flxR10 +gc1flxR10Fill dimensionless REAL 4 -999 estimated filling factor at R10 +gc2flxR1 adu/seconds REAL 4 -999 Flux inside r = 1 +gc2flxR1Err adu/seconds REAL 4 -999 estimated error is c2flxR1 +gc2flxR1Std adu/seconds REAL 4 -999 estimated standard deviation in c2flxR1 +gc2flxR1Fill dimensionless REAL 4 -999 estimated filling factor at R1 +gc2flxR2 adu/seconds REAL 4 -999 Flux inside r = 2 +gc2flxR2Err adu/seconds REAL 4 -999 estimated error is c2flxR2 +gc2flxR2Std adu/seconds REAL 4 -999 estimated standard deviation in c2flxR2 +gc2flxR2Fill dimensionless REAL 4 -999 estimated filling factor at R1 +gc2flxR3 adu/seconds REAL 4 -999 Flux inside r = 3 +gc2flxR3Err adu/seconds REAL 4 -999 estimated error is c2flxR3 +gc2flxR3Std adu/seconds REAL 4 -999 estimated standard deviation in c2flxR3 +gc2flxR3Fill dimensionless REAL 4 -999 estimated filling factor at R3 +gc2flxR4 adu/seconds REAL 4 -999 Flux inside r = 4 +gc2flxR4Err adu/seconds REAL 4 -999 estimated error is c2flxR4 +gc2flxR4Std adu/seconds REAL 4 -999 estimated standard deviation in c2flxR4 +gc2flxR4Fill dimensionless REAL 4 -999 estimated filling factor at R4 +gc2flxR5 adu/seconds REAL 4 -999 Flux inside r = 5 +gc2flxR5Err adu/seconds REAL 4 -999 estimated error is c2flxR5 +gc2flxR5Std adu/seconds REAL 4 -999 estimated standard deviation in c2flxR5 +gc2flxR5Fill dimensionless REAL 4 -999 estimated filling factor at R5 +gc2flxR6 adu/seconds REAL 4 -999 Flux inside r = 6 +gc2flxR6Err adu/seconds REAL 4 -999 estimated error is c2flxR6 +gc2flxR6Std adu/seconds REAL 4 -999 estimated standard deviation in c2flxR6 +gc2flxR6Fill dimensionless REAL 4 -999 estimated filling factor at R6 +gc2flxR7 adu/seconds REAL 4 -999 Flux inside r = 7 +gc2flxR7Err adu/seconds REAL 4 -999 estimated error is c2flxR7 +gc2flxR7Std adu/seconds REAL 4 -999 estimated standard deviation in c2flxR7 +gc2flxR7Fill dimensionless REAL 4 -999 estimated filling factor at R7 +gc2flxR8 adu/seconds REAL 4 -999 Flux inside r = 8 +gc2flxR8Err adu/seconds REAL 4 -999 estimated error is c2flxR8 +gc2flxR8Std adu/seconds REAL 4 -999 estimated standard deviation in c2flxR8 +gc2flxR8Fill dimensionless REAL 4 -999 estimated filling factor at R8 +gc2flxR9 adu/seconds REAL 4 -999 Flux inside r = 9 +gc2flxR9Err adu/seconds REAL 4 -999 estimated error is c2flxR9 +gc2flxR9Std adu/seconds REAL 4 -999 estimated standard deviation in c2flxR9 +gc2flxR9Fill dimensionless REAL 4 -999 estimated filling factor at R9 +gc2flxR10 adu/seconds REAL 4 -999 Flux inside r = 10 +gc2flxR10Err adu/seconds REAL 4 -999 estimated error is c2flxR10 +gc2flxR10Std adu/seconds REAL 4 -999 estimated standard deviation in c2flxR10 +gc2flxR10Fill dimensionless REAL 4 -999 estimated filling factor at R10 + +-- repeat for other filters with appropriate leading prefex. + +-- [728 byte/filter/obj + 44 byte/obj] + Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObject =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObject (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObject (revision 36815) @@ -0,0 +1,63 @@ + +objID dimensionless BIGINT 8 NA ODM object identifier +gcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier +surveyID dimensionless TINYINT 1 NA survey flag identifier +skyCellID dimensionless REAL 4 -999 single float giving PrimaryCell.SkyCell identifier +randomStackObjID dimensionless BIGINT 8 NA random stack id +stackDetectRowID dimensionless BIGINT 8 NA identifies which of up to 5 possible stackdetctions this Row refers to: Primary, up to 3 Secondary, 1 best +primaryDetection dimensionless TINYINT 1 255 identifies if this row is a primary stack detection. True about 80% of time. +bestDetection dimensionless TINYINT 1 255 identifies if this row is a best detection or not. Also set if only a primary detection exists. + the Primary Dectection, 0 to 3 possible secondary dectections, and the "best" per filter. +dvoRegionID dimensionless REAL 4 -999 identifier to dvo spatial region +dataRelease dimensionless TINYINT 1 NA Data release when this detection was originally taken. +------------------------------------------------------------------------------------------ +-- attributes for all stack detections in all filters (these are currently forced anyway) +-- Replicate the section below for each filter, changing the prefex ("g" in this example) +------------------------------------------------------------------------------------------ +gippObjID dimensionless BIGINT 8 NA object ID generated by IPP +gippDetectID dimensionless BIGINT 8 NA detection ID generated by IPP +gstackDetectID dimensionless BIGINT 8 NA ODM detection identifier +gstackMetaID dimensionless BIGINT 8 NA stack identifier +gxPos arcsec REAL 4 -999 measured x in sky Cell from PSF fit +gyPos arcsec REAL 4 -999 measured y in sky Cell from PSF fit +gxPosErr arcsec REAL 4 -999 estimated error in x +gyPosErr arcsec REAL 4 -999 estimated error in y +gra degrees FLOAT 8 NA Right Ascension +gdec degrees FLOAT 8 NA Declination +graErr arcsec REAL 4 NA Right Ascension error +gdecErr arcsec REAL 4 NA Declination error (same as RA error - need?) +gzp magnitude REAL 4 0 zeropoint , no error given +gexpTime seconds REAL 4 -999 total exposure time (informational) +gpsfMajorFWHM arcsec REAL 4 -999 PSF width in major axis +gpsfMinorFWHM arcsec REAL 4 -999 PSF width in minor axis +gpsfTheta degrees REAL 4 -999 PSF orientation angle. Degrees East of North. +gpsfCore dimensionless REAL 4 -999 PSF core parameter [k in (1 + kz + z^1.66)] +gpsfLikelihood dimensionless REAL 4 -999 PSF likelihood +gpsfQf dimensionless REAL 4 -999 PSF coverage factor +gpsfQfPerfect dimensionless REAL 4 -999 PSF-weighted fraction of arcsec totally unmasked +gpsfChiSq dimensionless REAL 4 -999 PSF-weighted fraction of arcsec to. +gmomentXX arcsec^2 REAL 4 -999 moment XX +gmomentXY arcsec^2 REAL 4 -999 moment XY +gmomentYY arcsec^2 REAL 4 -999 moment YY +gmomentR1 arcsec REAL 4 -999 moment R1 +gmomentRH arcsec REAL 4 -999 moment RH - or half light radius +gPSFFlux adu/sec REAL 4 -999 g psf flux from stack +gPSFFluxErr adu/sec REAL 4 -999 estimated error of g psf flux from stack +gApFlux adu/seconds REAL 4 -999 Aperture magnitude +gApFluxErr adu/seconds REAL 4 -999 Aperture magnitude error +gApFillFac dimensionless REAL 4 -999 Aperture fill factor - ~ redundant with psfQF, keep? +gKronFlux adu/seconds REAL 4 -999 Kron flux +gKronFluxErr adu/seconds REAL 4 -999 Kron flux error +gKronRad arcsec REAL 4 -999 Kron radius +gPSFMag AB magnitude REAL 4 -999 g psf AB magnitude from stack +gPSFMagErr AB magnitude REAL 4 -999 estimated error of g psf AB magnitude from stack +gApMag AB magnitude REAL 4 -999 g Aperture AB magnitude from stack +gApMagErr AB magnitude REAL 4 -999 estimated error of g Ap Mag AB magnitude from stack +gKronMag AB magnitude REAL 4 -999 g kron AB magnitude from stack +gKronMagErr AB magnitude REAL 4 -999 estimated error of g kron AB magnitude from stack +gsky adu/secs/arcsec REAL 4 -999 PSF sky level at source (adu) +gskyErr adu/secs/arcsec REAL 4 -999 estimated error in sky +ginfoFlag dimensionless BIGINT 8 -999 indicator of strange propeties +gnFrames dimensionless INT 4 -999 Number of frames contributing to source + +-- [220 byte/filter/obj + 44 byte/obj] Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/CameraConfig =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/CameraConfig (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/CameraConfig (revision 36815) @@ -0,0 +1,12 @@ +CameraConfig +Description: Camera configuration + +Name Unit DataType Size Default ValueDescription + +cameraID dimensionless SMALLINT 2 -999 camera identifier (i.e. GPC1, ISP) +cameraConfigID dimensionless SMALLINT 2 -999 camera configuration +endDate dimensionless REAL 4 -999 ending date of this configuration in MJD +configDetails string VARCHAR(MAX) 8000 0x00 NA text/table giving the details of the camera configuration + NEED TO CHANGE and pass camera x from raw data file + + Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/DetectionFlags =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/DetectionFlags (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/DetectionFlags (revision 36815) @@ -0,0 +1,10 @@ +DetectionFlags + +Description: Flags used to interpret the information flag provided +with each detection (infoFlag in 'Detection' table) + +Name Unit Data Type Size Default Value Description + +name VARCHAR(32) 32 NA Name of flag +value BIGINT 8 NA Flag value +description VARCHAR(2000) 2000 NA Description of the flag Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/DiffMeta =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/DiffMeta (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/DiffMeta (revision 36815) @@ -0,0 +1,26 @@ +diffMetaID dimensionless BIGINT 8 NA diff identifier +batchID dimensionless BIGINT 8 NA batch identifier +surveyID dimensionless TINYINT 1 NA survey flag identifier +filterID dimensionless TINYINT 1 NA filter id +diffTypeID dimensionless TINYINT 1 0 diff type identifier +posImageID dimensionless BIGINT 8 NA positive image identifier +negImageID dimensionless BIGINT 8 NA negative image identifier +skyCellID dimensionless REAL 4 NA skycell region identifier +photoCalID dimensionless INT 4 NA photometry code +magSat dimensionless REAL 4 -999 saturation magnitude level +analVer dimensionless SMALLINT 2 -999 analysis version index +expTime seconds REAL 4 -999 exposure time of positive image +ctype1 alphanumeric VARCHAR(MAX) 8000 name of astrometric projection in RA +ctype2 alphanumeric VARCHAR(MAX) 8000 name of astrometric projection in DEC +crval1 degrees FLOAT 8 -999 RA corresponding to reference pixel +crval2 degrees FLOAT 8 -999 DEC corresponding to reference pixel +crpix1 dimensionless FLOAT 8 -999 reference pixel value for RA +crpix2 dimensionless FLOAT 8 -999 reference pixel value for DEC +cdelt1 deg/pixel FLOAT 8 -999 scale factor for RA +cdelt2 deg/pixel FLOAT 8 -999 scale factor for DEC +pc001001 dimensionless FLOAT 8 -999 elements of rotation/Dcale matrix +pc001002 dimensionless FLOAT 8 -999 elements of rotation/Dcale matrix +pc002001 dimensionless FLOAT 8 -999 elements of rotation/Dcale matrix +pc002002 dimensionless FLOAT 8 -999 elements of rotation/Dcale matrix +calibModNum dimensionless SMALLINT 2 NA calibration modification number +dataRelease dimensionless TINYINT 1 NA Data release Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/DiffToImage =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/DiffToImage (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/DiffToImage (revision 36815) @@ -0,0 +1,2 @@ +diffMetaID BIGINT 8 NA diff identifier +imageID BIGINT 8 NA hashed exposure-ccdID identifier Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/Filter =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/Filter (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/Filter (revision 36815) @@ -0,0 +1,3 @@ +FilterID dimensionless TINYNT 1 NA filter ID: g=1, r=2, i=3, z=4, y=5, w=6, ... +filterType VARCHAR(2) 2 NA filter name: g,r,i,z,y, etc. +filterSpec VARCHAR(MAX) 8000 0x00 No comment Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/FitModel =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/FitModel (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/FitModel (revision 36815) @@ -0,0 +1,42 @@ +fitModelID SMALLINT 2 NA indentifier of alternate model fit +name VARCHAR(30) 30 model name +description VARCHAR(MAX) 8000 string describing the model +param1 VARCHAR(MAX) 8000 description of model parameter 1 +param2 VARCHAR(MAX) 8000 description of model parameter 2 +param3 VARCHAR(MAX) 8000 description of model parameter 3 +param4 VARCHAR(MAX) 8000 description of model parameter 4 +param5 VARCHAR(MAX) 8000 description of model parameter 5 +param6 VARCHAR(MAX) 8000 description of model parameter 6 +param7 VARCHAR(MAX) 8000 description of model parameter 7 +param8 VARCHAR(MAX) 8000 description of model parameter 8 +param9 VARCHAR(MAX) 8000 description of model parameter 9 +param10 VARCHAR(MAX) 8000 description of model parameter 10 +param11 VARCHAR(MAX) 8000 description of model parameter 11 +param12 VARCHAR(MAX) 8000 description of model parameter 12 +param13 VARCHAR(MAX) 8000 description of model parameter 13 +param14 VARCHAR(MAX) 8000 description of model parameter 14 +param15 VARCHAR(MAX) 8000 description of model parameter 15 +param16 VARCHAR(MAX) 8000 description of model parameter 16 +param17 VARCHAR(MAX) 8000 description of model parameter 17 +param18 VARCHAR(MAX) 8000 description of model parameter 18 +param19 VARCHAR(MAX) 8000 description of model parameter 19 +param20 VARCHAR(MAX) 8000 description of model parameter 20 +param21 VARCHAR(MAX) 8000 description of model parameter 21 +param22 VARCHAR(MAX) 8000 description of model parameter 22 +param23 VARCHAR(MAX) 8000 description of model parameter 23 +param24 VARCHAR(MAX) 8000 description of model parameter 24 +param25 VARCHAR(MAX) 8000 description of model parameter 25 +param26 VARCHAR(MAX) 8000 description of model parameter 26 +param27 VARCHAR(MAX) 8000 description of model parameter 27 +param28 VARCHAR(MAX) 8000 description of model parameter 28 +param29 VARCHAR(MAX) 8000 description of model parameter 29 +param30 VARCHAR(MAX) 8000 description of model parameter 30 +param31 VARCHAR(MAX) 8000 description of model parameter 31 +param32 VARCHAR(MAX) 8000 description of model parameter 32 +param33 VARCHAR(MAX) 8000 description of model parameter 33 +param34 VARCHAR(MAX) 8000 description of model parameter 34 +param35 VARCHAR(MAX) 8000 description of model parameter 35 +param36 VARCHAR(MAX) 8000 description of model parameter 36 +param37 VARCHAR(MAX) 8000 description of model parameter 37 +param38 VARCHAR(MAX) 8000 description of model parameter 38 +param39 VARCHAR(MAX) 8000 description of model parameter 39 Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/ForcedWarpMeta =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/ForcedWarpMeta (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/ForcedWarpMeta (revision 36815) @@ -0,0 +1,33 @@ +forcedWarpID dimensionless BIGINT 8 NA stack identifier +batchID dimensionless BIGINT 8 NA batch identifier +surveyID dimensionless TINYINT 1 NA survey flag identifier +filterID dimensionless TINYINT 1 NA fnilutemr eidriecnatl ifidier +skyCellID dimensionless REAL 4 NA skycell region identifier +photoCalID dimensionless INT 4 NA photometry code +magSat dimensionless REAL 4 -999 saturation magnitude level +analVer dimensionless SMALLINT 2 -999 analysis version index +expTime seconds REAL 4 -999 exposure time +completMag magnitudes REAL 4 -999 95% completion level in mag +astroScat dimensionless REAL 4 -999 astrometric scatter for chip +photoScat dimensionless REAL 4 -999 photometric scatter for chip +nAstroRef dimensionless INT 4 -999 number of astrometric reference sources +nPhoRef dimensionless INT 4 -999 number of photometric reference sources +psfModelID dimensionless VARCHAR(MAX) 8000 PSF model identifier +psfFwhm_mean arcsec FLOAT 8 -999 mean PSF FWHM in the stack +psfFwhm_max arcsec FLOAT 8 -999 maximum PSF FWHM in the stack +photoZero magnitudes REAL 4 -999 local derived photometric zero point +photoColor magnitudes REAL 4 -999 local derived photometric color term +ctype1 alphanumeric VARCHAR(MAX) 8000 name of astrometric projection in RA +ctype2 alphanumeric VARCHAR(MAX) 8000 name of astrometric projection in DEC +crval1 degrees FLOAT 8 -999 RA corresponding to reference pixel +crval2 degrees FLOAT 8 -999 DEC corresponding to reference pixel +crpix1 dimensionless FLOAT 8 -999 reference pixel value for RA +crpix2 dimensionless FLOAT 8 -999 reference pixel value for DEC +cdelt1 deg/pixel FLOAT 8 -999 scale factor for RA +cdelt2 deg/pixel FLOAT 8 -999 scale factor for DEC +pc001001 dimensionless FLOAT 8 -999 elements of rotation/Dcale matrix +pc001002 dimensionless FLOAT 8 -999 elements of rotation/Dcale matrix +pc002001 dimensionless FLOAT 8 -999 elements of rotation/Dcale matrix +pc002002 dimensionless FLOAT 8 -999 elements of rotation/Dcale matrix +calibModNum dimensionless SMALLINT 2 NA calibration modification number +dataRelease dimensionless TINYINT 1 NA Data release Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/ForcedWarpToImage =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/ForcedWarpToImage (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/ForcedWarpToImage (revision 36815) @@ -0,0 +1,2 @@ +forcedWarpID BIGINT 8 NA forced warp identifier +imageID BIGINT 8 NA hashed exposure-ccdID identifier Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/FrameMeta =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/FrameMeta (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/FrameMeta (revision 36815) @@ -0,0 +1,49 @@ +frameID dimensionless INT 4 NA unique exposure/frame identifier. +frameName dimensionless VARCHAR(32) 32 NA frame name provided by camera software +surveyID dimensionless TINYINT 1 NA survey flag identifier +filterID dimensionless TINYINT 1 NA filter identifier +cameraID dimensionless SMALLINT 2 NA camera identifier +cameraConfigID dimensionless SMALLINT 2 NA camera configuration identifier +telescopeID dimensionless SMALLINT 2 NA telescope identifier +analysisVer alphanumeric VARCHAR(MAX) 8000 IPP software analysis release +p1Recip alphanumeric VARCHAR(MAX) 8000 IPP phase 1 MD5 Checksum +p2Recip alphanumeric VARCHAR(MAX) 8000 IPP phase 2 MD5 Checksum +p3Recip alphanumeric VARCHAR(MAX) 8000 IPP phase 3 MD5 Checksum +nOTA alphanumeric SMALLINT 2 -999 number of valid OTA/CCD images in this exposure +photoScat magnitude REAL 4 -999 global photometric scatter +numPhotoRef dimensionless INT 4 -999 number of photometric reference sources +expStart days FLOAT 8 -999 exposure start time in MJD +expTime seconds REAL 4 -999 exposure time +airmass dimensionless REAL 4 -999 airmass at mid-exposure +raBore degrees FLOAT 8 -999 RA of telescope boresight +decBore degrees FLOAT 8 -999 DEC of telescope boresight +ctype1 alphanumeric VARCHAR(MAX) 8000 name of astrometric projection in RA +ctype2 VARCHAR(MAX) 8000 name of astrometric projection in DEC +crval1 degrees FLOAT 8 -999 RA corresponding to reference pixel +crval2 degrees FLOAT 8 -999 DEC corresponding to reference pixel +crpix1 pc001001 FLOAT 8 -999 reference pixel value for RA +crpix2 dimensionless FLOAT 8 -999 reference pixel value for DEC +cdelt1 degrees/pixel FLOAT 8 -999 scale factor for RA +cdelt2 degrees/pixel FLOAT 8 -999 scale factor for DEC +pc001001 dimensionless FLOAT 8 -999 elements of rotation/Dcale matrix +pc001002 dimensionless FLOAT 8 -999 elements of rotation/Dcale matrix +pc002001 dimensionless FLOAT 8 -999 elements of rotation/Dcale matrix +pc002002 dimensionless FLOAT 8 -999 elements of rotation/Dcale matrix +polyOrder dimensionless TINYINT 1 255 polynomial order of astrometry fit +pca1x3y0 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit +pca1x2y1 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit +pca1x1y2 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit +pca1x0y3 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit +pca1x2y0 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit +pca1x1y1 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit +pca1x0y2 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit +pca2x3y0 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit +pca2x2y1 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit +pca2x1y2 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit +pca2x0y3 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit +pca2x2y0 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit +pca2x1y1 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit +pca2x0y2 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit +calibModNum dimensionless SMALLINT 2 NA calibration modification number +batchID dimensionless BIGINT 8 NA batch ID +dataRelease dimensionless TINYINT 1 NA Data release Version of this table Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/ImageFlags =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/ImageFlags (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/ImageFlags (revision 36815) @@ -0,0 +1,3 @@ +name VARCHAR(32) 32 NA Name of flag +value BIGINT 8 NA Flag value +description VARCHAR(2000) 2000 Description of the flag Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/ImageMeta =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/ImageMeta (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/ImageMeta (revision 36815) @@ -0,0 +1,74 @@ +imageID dimensionless BIGINT 8 NA unique ID for each image, hashed from frameID and ccdID +frameID dimensionless INT 4 NA frame identifier, also known as exposure number +ccdID dimensionless SMALLINT 2 NA ccd cell identifier in the focal plane +photoCalID dimensionless INT 4 NA photometry reduction code identifier +filterID dimensionless TINYINT 1 NA filter ID +bias ADU REAL 4 -999 detector bias level +biasScat ADU REAL 4 -999 scatter in bias level +sky ADU/pixel REAL 4 -999 mean sky level +skyScat ADU/pixel REAL 4 -999 scatter in mean sky level +nDetect dimensionless INT 4 -999 number of detections on CCD +magSat magnitude REAL 4 -999 saturation magnitude level +completMag magnitude REAL 4 -999 95% completion level in mag +astroScat arcsec REAL 4 -999 astrometric scatter for chip +photoScat magitude REAL 4 -999 photometric scatter for chip +numAstroRef dimensionless INT 4 -999 number of astrometric reference sources +numPhotoRef dimensionless INT 4 -999 number of photometric reference sources +nx pixels SMALLINT 2 -999 chip dimension in x +ny pixels SMALLINT 2 -999 chip dimension in y +psfModelID dimensionless INT 4 -999 PSF model identifier +psfFwhm arcsec REAL 4 -999 model psf full width at half maximum at chip center +psfWidMajor arcsec REAL 4 -999 model PSF parameters at chip center +psfWidMinor arcsec REAL 4 -999 model PSF parameters at chip center +psfTheta degrees REAL 4 -999 model PSF parameters at chip center +momentXX pixels REAL 4 -999 moment XX +momentXY pixels REAL 4 -999 moment XY +momentYY pixels REAL 4 -999 moment YY +momentM3C pixels squared REAL 4 -999 moment M3C +momentM3S pixels squared REAL 4 -999 moment M3S +momentM4C pixels squared REAL 4 -999 moment M4C +momentM4S pixels squared REAL 4 -999 moment M4S +momentR1 pixels REAL 4 -999 moment R1 +momentRH sqrt pixels REAL 4 -999 moment RH +apResid magnitide REAL 4 -999 corrected aperture residual +dapResid magnitide REAL 4 -999 scatter of aperture corrections +detectorID alphanumeric VARCHAR(32) 32 identifier for actual CCD chip +qaFlags dimensionless BIGINT 8 -999 Q/A flags for this OTA +detrend1 alphanumeric VARCHAR(MAX) 8000 identifier of detrend image 1 +detrend2 alphanumeric VARCHAR(MAX) 8000 identifier of detrend image 2 +detrend3 alphanumeric VARCHAR(MAX) 8000 identifier of detrend image 3 +detrend4 alphanumeric VARCHAR(MAX) 8000 identifier of detrend image 4 +detrend5 alphanumeric VARCHAR(MAX) 8000 identifier of detrend image 5 +detrend6 alphanumeric VARCHAR(MAX) 8000 identifier of detrend image 6 +detrend7 alphanumeric VARCHAR(MAX) 8000 identifier of detrend image 7 +detrend8 alphanumeric VARCHAR(MAX) 8000 identifier of detrend image 8 +photoZero magnitude REAL 4 -999 local derived photometric zero point +ctype1 alphanumeric VARCHAR(MAX) 8000 name of astrometric projection in RA +ctype2 alphanumeric VARCHAR(MAX) 8000 name of astrometric projection in DEC +crval1 degrees FLOAT 8 -999 RA corresponding to reference pixel +crval2 degrees FLOAT 8 -999 DEC corresponding to reference pixel +crpix1 pixels FLOAT 8 -999 reference pixel value for RA +crpix2 pixels FLOAT 8 -999 reference pixel value for DEC +cdelt1 degrees/pixel FLOAT 8 -999 scale factor for RA +cdelt2 degrees/pixel FLOAT 8 -999 scale factor for DEC +pc001001 unknown FLOAT 8 -999 elements of rotation/Dcale matrix +pc001002 unknown FLOAT 8 -999 elements of rotation/Dcale matrix +pc002001 unknown FLOAT 8 -999 elements of rotation/Dcale matrix +pc002002 unknown FLOAT 8 -999 elements of rotation/Dcale matrix +polyOrder dimensionless TINYINT 1 255 polynomial order of astrometry fit +pca1x3y0 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit +pca1x2y1 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit +pca1x1y2 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit +pca1x0y3 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit +pca1x2y0 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit +pca1x1y1 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit +pca1x0y2 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit +pca2x3y0 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit +pca2x2y1 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit +pca2x1y2 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit +pca2x0y3 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit +pca2x2y0 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit +pca2x1y1 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit +pca2x0y2 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit +calibModNum dimensionless SMALLINT 2 NA calibration modification number +dataRelease dimensionless TINYINT 1 NA Data release Version of this table Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/Mask =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/Mask (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/Mask (revision 36815) @@ -0,0 +1,9 @@ +maskID BIGINT 8 NA mask identifier +partitionKey BIGINT 8 NA fget(mask_center_ra, mask_center_dec, zoneH) +frameID INT 4 NA reference to the P2FrameMeta table where the mask is defined +imageID BIGINT 8 NA reference to the P2FrameMeta table where the mask is +ra FLOAT 8 NA rdae finin ethde center +dec FLOAT 8 NA dec in the center +radius FLOAT 8 NA No comment +maskString VARCHAR(MAX) 8000 string representation fo the mask region +maskBinary VARBINARY(MAX) 8000 0x Binary object managed by the spatial library Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/MovingObjToDet =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/MovingObjToDet (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/MovingObjToDet (revision 36815) @@ -0,0 +1,2 @@ +MovingObjID BIGINT 8 NA Moving Object identifier +DetectionID BIGINT 8 NA detection identifier Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/MovingObjToDiffDet =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/MovingObjToDiffDet (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/MovingObjToDiffDet (revision 36815) @@ -0,0 +1,2 @@ +MovingObjID BIGINT 8 NA Moving Object identifier +DiffDetID BIGINT 8 NA difference image detection identifier Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/MovingObjToObject =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/MovingObjToObject (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/MovingObjToObject (revision 36815) @@ -0,0 +1,2 @@ +MovingObjID BIGINT 8 NA Moving Object identifier +ObjID BIGINT 8 NA Object identifier Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/ObjectFilterFlags =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/ObjectFilterFlags (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/ObjectFilterFlags (revision 36815) @@ -0,0 +1,3 @@ +name dimensionless VARCHAR(32) 32 Name of flag +value dimensionless BIGINT 8 NA Flag value +description dimensionless VARCHAR(2000) 2000 Description of the flag Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/ObjectInfoFlags =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/ObjectInfoFlags (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/ObjectInfoFlags (revision 36815) @@ -0,0 +1,3 @@ +name dimensionless VARCHAR(32) 32 Name of flag +value dimensionless BIGINT 8 NA Flag value +description dimensionless VARCHAR(2000) 2000 Description of the flag Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/ObjectQualityFlags =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/ObjectQualityFlags (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/ObjectQualityFlags (revision 36815) @@ -0,0 +1,3 @@ +name dimensionless VARCHAR(32) 32 Name of flag +value dimensionless BIGINT 8 NA Flag value +description dimensionless VARCHAR(2000) 2000 Description of the flag Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/PhotoCal =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/PhotoCal (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/PhotoCal (revision 36815) @@ -0,0 +1,11 @@ +photoCalID INT 4 NA numerical code for this reduction +filterID TINYINT 1 NA filter id +photoCodeDesc VARCHAR(MAX) 8000 Photometry reduction code name +AB REAL 4 1.0 AB magnitude +zeropoint REAL 4 -999 photometric zero point (excluding long term variation) +extinction REAL 4 -999 photometric extinction term (excluding long term variation) +colorterm REAL 4 -999 photometric color term (excluding long term variation) +colorExtn REAL 4 -999 photometric color dependent extinction (excluding long term variation) +orphanCalColor REAL 4 -999 color adopted for magnitude calculation +orphanCalColorErr REAL 4 -999 error in calibrating color +startDate day REAL 4 NA starting date of this configuration in MJD Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/ProjectionCell =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/ProjectionCell (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/ProjectionCell (revision 36815) @@ -0,0 +1,22 @@ +projectionCellID INT 4 NA projection cell unique identifier +partitionKey BIGINT 8 NA fGetPanObjID(crval1,crval2) +primaryCellRegionID BIGINT 8 NA reference to the primary cell region definition in the Region table +projectionCellRegionID BIGINT 8 NA reference to the projectio cell region definition in the +ctype1 VARCHAR(MAX) 8000 NA nRaemgieo no ft aabsltero)metric projection in RA +ctype2 VARCHAR(MAX) 8000 NA name of astrometric projection in DEC +crval1 deg FLOAT 8 NA RA corresponding to reference pixel +crval2 deg FLOAT 8 NA DEC corresponding to reference pixel +crpix1 FLOAT 8 NA reference pixel value for RA +crpix2 FLOAT 8 NA reference pixel value for DEC +pc001001 FLOAT 8 NA elements of rotation/Dcale matrix +pc001002 FLOAT 8 NA elements of rotation/Dcale matrix +pc002001 FLOAT 8 NA elements of rotation/Dcale matrix +pc002002 FLOAT 8 NA elements of rotation/Dcale matrix +raNEcornerPC degrees FLOAT 8 -999 ra of NE corner +decNEcornerPC degrees FLOAT 8 -999 dec of NE corner +raNWcornerPC degrees FLOAT 8 -999 ra of NE corner +decNWcornerPC degrees FLOAT 8 -999 dec of NE corner +raSEcornerPC degrees FLOAT 8 -999 ra of NE corner +decSEcornerPC degrees FLOAT 8 -999 dec of NE corner +raSWcornerPC degrees FLOAT 8 -999 ra of NE corner +decSWcornerPC degrees FLOAT 8 -999 dec of NE corner Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/PsConstant =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/PsConstant (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/PsConstant (revision 36815) @@ -0,0 +1,4 @@ +name VARCHAR(32) 32 NA constant's name +value FLOAT 8 NA constant's value +unit VARCHAR(32) 32 unit of constant +description VARCHAR(2000) 2000 description of the constant Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/Region =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/Region (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/Region (revision 36815) @@ -0,0 +1,7 @@ +regionID dimensionless BIGINT 8 NA Unique Region identifier +id dimensionless BIGINT 8 NA Custom Identifier +type string VARCHAR(16) 16 NA Region type +comment string VARCHAR(MAX) 8000 Comment +area sqdeg? FLOAT 8 0 Area covered by the region +region dimensionless Binary VARBINARY(MAX) 8000 0x Binary object managed by the spatial library + Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/RegionPatch =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/RegionPatch (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/RegionPatch (revision 36815) @@ -0,0 +1,15 @@ +Unit Data Type Size Default Value Description +regionid BIGINT 8 NA No comment +convexid BIGINT 8 NA No comment +patchid INT 4 NA No comment +type (16) NA No comment +radius FLOAT 8 0 No comment +ra degree FLOAT 8 0 Right Ascension +dec FLOAT 8 0 No comment +x FLOAT 8 0 No comment +y FLOAT 8 0 No comment +z FLOAT 8 0 No comment +c FLOAT 8 0 No comment +htmid BIGINT 8 0 No comment +area FLOAT 8 0 No comment +convexString (MAX) No comment Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/SkyCell =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/SkyCell (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/SkyCell (revision 36815) @@ -0,0 +1,12 @@ +skyCellID dimensionless I INT 4 NA indentifier of the sky cell +projectionCellID INT 4 -999 indentifier of the projection cell +partitionKey BIGINT 8 -999 fgetPANobjID(skyCell_center_ra, skyCell_center_dec, zHeight) +regionID BIGINT 8 -999 region identifier in the Region table +raNEcorner degrees FLOAT 8 -999 ra of NE corner +decNEcorner degrees FLOAT 8 -999 dec of NE corner +raNWcorner degrees FLOAT 8 -999 ra of NE corner +decNWcorner degrees FLOAT 8 -999 dec of NE corner +raSEcorner degrees FLOAT 8 -999 ra of NE corner +decSEcorner degrees FLOAT 8 -999 dec of NE corner +raSWcorner degrees FLOAT 8 -999 ra of NE corner +decSWcorner degrees FLOAT 8 -999 dec of NE corner Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/StackDetectionFlags =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/StackDetectionFlags (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/StackDetectionFlags (revision 36815) @@ -0,0 +1,3 @@ +Name dimensionless VARCHAR(32) 32 Name of flag +value dimensionless BIGINT 8 NA Flag value +description dimensionless VARCHAR(2000) 2000 Description of the flag Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/StackMeta =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/StackMeta (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/StackMeta (revision 36815) @@ -0,0 +1,35 @@ +stackMetaID dimensionless BIGINT 8 NA stack identifier +batchID dimensionless BIGINT 8 NA batch identifier +surveyID dimensionless TINYINT 1 NA survey flag identifier +filterID dimensionless TINYINT 1 NA fnilutemr eidriecnatl ifidier +stackTypeID dimensionless TINYINT 1 0 stack type identifier +skyCellID dimensionless REAL 4 NA skycell region identifier +photoCalID dimensionless INT 4 NA photometry code +magSat dimensionless REAL 4 -999 saturation magnitude level +analVer dimensionless SMALLINT 2 -999 analysis version index +expTime seconds REAL 4 -999 exposure time +nP2Images dimensionless SMALLINT 2 -999 number of P2 images contributing to this cell +completMag magnitudes REAL 4 -999 95% completion level in mag +astroScat dimensionless REAL 4 -999 astrometric scatter for chip +photoScat dimensionless REAL 4 -999 photometric scatter for chip +nAstroRef dimensionless INT 4 -999 number of astrometric reference sources +nPhoRef dimensionless INT 4 -999 number of photometric reference sources +psfModelID dimensionless VARCHAR(MAX) 8000 PSF model identifier +psfFwhm_mean arcsec FLOAT 8 -999 mean PSF FWHM in the stack +psfFwhm_max arcsec FLOAT 8 -999 maximum PSF FWHM in the stack +photoZero magnitudes REAL 4 -999 local derived photometric zero point +photoColor magnitudes REAL 4 -999 local derived photometric color term +ctype1 alphanumeric VARCHAR(MAX) 8000 name of astrometric projection in RA +ctype2 alphanumeric VARCHAR(MAX) 8000 name of astrometric projection in DEC +crval1 degrees FLOAT 8 -999 RA corresponding to reference pixel +crval2 degrees FLOAT 8 -999 DEC corresponding to reference pixel +crpix1 dimensionless FLOAT 8 -999 reference pixel value for RA +crpix2 dimensionless FLOAT 8 -999 reference pixel value for DEC +cdelt1 deg/pixel FLOAT 8 -999 scale factor for RA +cdelt2 deg/pixel FLOAT 8 -999 scale factor for DEC +pc001001 dimensionless FLOAT 8 -999 elements of rotation/Dcale matrix +pc001002 dimensionless FLOAT 8 -999 elements of rotation/Dcale matrix +pc002001 dimensionless FLOAT 8 -999 elements of rotation/Dcale matrix +pc002002 dimensionless FLOAT 8 -999 elements of rotation/Dcale matrix +calibModNum dimensionless SMALLINT 2 NA calibration modification number +dataRelease dimensionless TINYINT 1 NA Data release Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/StackToImage =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/StackToImage (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/StackToImage (revision 36815) @@ -0,0 +1,2 @@ +stackMetaID BIGINT 8 NA stack identifier +imageID BIGINT 8 NA hashed exposure-ccdID identifier Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/StackType =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/StackType (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/StackType (revision 36815) @@ -0,0 +1,3 @@ +stackTypeID TINYINT 1 -999 stack type identifier +name VARCHAR(20) 20 stack type name +description VARCHAR(MAX) 8000 stack type description Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/Survey =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/Survey (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/Survey (revision 36815) @@ -0,0 +1,4 @@ +SurveyID TINYINT 1 NA index of survey type +name VARCHAR(6) 6 survey name +description VARCHAR(MAX) 8000 +survey description Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/TelescopeConfig =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/TelescopeConfig (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/TelescopeConfig (revision 36815) @@ -0,0 +1,16 @@ +TelescopeConfig +Description: Telescope configuration + +Name Unit DataType Size Default ValueDescription + +TelescopeID dimensionless SMALLINT 2 -999 Telescope identifier (i.e. PS1, ISP) +TeleConfigID dimensionless SMALLINT 2 -999 Telescope Configuration ID +MountModel string 8 NA Mount Model Name +MirrorModel string 8 NA Mirror Model Name +Observera string 8 NA Observers Name +endDate MeanJulianDays FLOAT 8 -999 ending date of this configuration in MJD +configDetails string VARCHAR(MAX) 8000 0x00 NA text/table giving the details of the telescope configuration + + + + Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/pcsGalaxyModel =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/pcsGalaxyModel (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/pcsGalaxyModel (revision 36815) @@ -0,0 +1,3 @@ +galaxyModelID dimensionless INT 4 NA modelID +description dimensionless VARCHAR(128) 128 model description, spectral type etc. +priors dimensionless VARCHAR(128) 128 priors applied to this model, may also split into 7 columns Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/pcsPhotoZRecipe =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/pcsPhotoZRecipe (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/pcsPhotoZRecipe (revision 36815) @@ -0,0 +1,2 @@ +photozRecipeID dimensionless TINYINT 1 -999 recipe index +description dimensionless VARCHAR(MAX) 8000 string\ describing\ the\ recipe Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/pcsSGSepRecipe =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/pcsSGSepRecipe (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/pcsSGSepRecipe (revision 36815) @@ -0,0 +1,2 @@ +sgSepRecipeID dimensionless INT 4 NA Star/Galaxy Seperator Recuipe ID +description dimensionless VARCHAR(128) 128 Description Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/pcsStarModel =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/pcsStarModel (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/pcsStarModel (revision 36815) @@ -0,0 +1,2 @@ +starModelID dimensionless INT 4 -999 modelID +description dimensionless VARCHAR(128) 128 model description, spectral type etc Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/pcsStellarParamsRecipe =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/pcsStellarParamsRecipe (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/MetaData_Tables/pcsStellarParamsRecipe (revision 36815) @@ -0,0 +1,3 @@ +stellarParamsRecipeID dimensionless INT 4 NA Na +description dimensionless VARCHAR(128) 128 Description:wq + Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_VIEWS/README =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_VIEWS/README (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_VIEWS/README (revision 36815) @@ -0,0 +1,5 @@ +See Notes_on_Schema 03.txt +for what tables are combined into what views. +Once there is concensus on tables, then will combine tables to make views. Meanwhile can concatente yourself from Notes. + + Index: /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_VIEWS/Views =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_VIEWS/Views (revision 36815) +++ /trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_VIEWS/Views (revision 36815) @@ -0,0 +1,17 @@ + +PSPS VIEWS - examples + +ObjectMean = ObjectThin join MeanObject +ObjectStack = ObjectThin join StackObject +ObjectApFlx = ObjectThin join StackApFlx +ObjectModel = ObjectThin join StackModelFit +ObjectStackAll = ObjectThin join StackObject and StackAp and StackModelFit +ObjectForcedMean = ObjectThin join ForcedMeanObject +ObjectPrimary = ObjectThin join StackObject join StackApFlx where primaryDection is true +ObjectBest = ObjectThin join StackObject join StackApFlx where bestDetection is true + + + + + +