Index: /trunk/ippToPsps/pspsschema/SchemaNew20.0/Notes_on_Schema10.txt =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/Notes_on_Schema10.txt (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/Notes_on_Schema10.txt (revision 38088) @@ -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/SchemaNew20.0/Notes_on_Schema11.txt =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/Notes_on_Schema11.txt (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/Notes_on_Schema11.txt (revision 38088) @@ -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/SchemaNew20.0/Notes_on_Schema12.txt =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/Notes_on_Schema12.txt (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/Notes_on_Schema12.txt (revision 38088) @@ -0,0 +1,2 @@ +Heather cleaned up the column names and types to make them consistent. + Index: /trunk/ippToPsps/pspsschema/SchemaNew20.0/Notes_on_Schema13.txt =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/Notes_on_Schema13.txt (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/Notes_on_Schema13.txt (revision 38088) @@ -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/SchemaNew20.0/PSPS_TABLES/Derived_Data_Product_Tables/GoodObject =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Derived_Data_Product_Tables/GoodObject (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Derived_Data_Product_Tables/GoodObject (revision 38088) @@ -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/SchemaNew20.0/PSPS_TABLES/Derived_Data_Product_Tables/StarGalaxySep =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Derived_Data_Product_Tables/StarGalaxySep (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Derived_Data_Product_Tables/StarGalaxySep (revision 38088) @@ -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/SchemaNew20.0/PSPS_TABLES/Derived_Data_Product_Tables/galExtinction =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Derived_Data_Product_Tables/galExtinction (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Derived_Data_Product_Tables/galExtinction (revision 38088) @@ -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/SchemaNew20.0/PSPS_TABLES/Derived_Data_Product_Tables/mopsMovingObject =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Derived_Data_Product_Tables/mopsMovingObject (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Derived_Data_Product_Tables/mopsMovingObject (revision 38088) @@ -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/SchemaNew20.0/PSPS_TABLES/Derived_Data_Product_Tables/pcsPhotoZ =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Derived_Data_Product_Tables/pcsPhotoZ (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Derived_Data_Product_Tables/pcsPhotoZ (revision 38088) @@ -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/SchemaNew20.0/PSPS_TABLES/Derived_Data_Product_Tables/pcsPhotoZProbabiity =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Derived_Data_Product_Tables/pcsPhotoZProbabiity (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Derived_Data_Product_Tables/pcsPhotoZProbabiity (revision 38088) @@ -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/SchemaNew20.0/PSPS_TABLES/Derived_Data_Product_Tables/pcsStarGalQSOSep =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Derived_Data_Product_Tables/pcsStarGalQSOSep (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Derived_Data_Product_Tables/pcsStarGalQSOSep (revision 38088) @@ -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/SchemaNew20.0/PSPS_TABLES/Derived_Data_Product_Tables/pcsStellarParams =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Derived_Data_Product_Tables/pcsStellarParams (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Derived_Data_Product_Tables/pcsStellarParams (revision 38088) @@ -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/SchemaNew20.0/PSPS_TABLES/Derived_Data_Product_Tables/ppmObj =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Derived_Data_Product_Tables/ppmObj (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Derived_Data_Product_Tables/ppmObj (revision 38088) @@ -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/SchemaNew20.0/PSPS_TABLES/Derived_Data_Product_Tables/tcsClassification =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Derived_Data_Product_Tables/tcsClassification (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Derived_Data_Product_Tables/tcsClassification (revision 38088) @@ -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/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/Detection =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/Detection (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/Detection (revision 38088) @@ -0,0 +1,65 @@ +objID dimensionless BIGINT 8 NA ODM object identifier +uniquePspsP2id dimensionless BIGINT 8 NA unique identifier for psps based on batch_id, OTA, and counter (per detection) +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 INT 4 0 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 +extNSigma dimensionless REAL 4 -999 measure of extendedness +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 +apRadius arcsec REAL 4 -999 Aperture radius +kronFlux adu/seconds REAL 4 -999 Kron flux +kronFluxErr adu/seconds REAL 4 -999 Kron flux error +kronRad arcsec REAL 4 -999 Kron radius +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 INT 4 -999 flag indicating provenance information +infoFlag2 dimensionless INT 4 -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] + +### do we want apRadius? +### relevant code spots: +### config/tables.P2.vot, detectionbatch.py:315 Index: /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/Detection.txt =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/Detection.txt (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/Detection.txt (revision 38088) @@ -0,0 +1,59 @@ + +objID + dvo = average.extID [calculated in addstar] +uniquePspsP2id + ipptopsps : combination of batch_id, ota, and counter +detectID + dvo = measure.extID [calculated in addstar] +ippObjID + dvo = average.objID + (average.catID << 32) [NOTE: this is a change in definition] +ippDetectID + smf:IPP_IDET +filterID + ipptopsps : internal, lookup from filter (grizy) +surveyID + ipptopsps : internal, from survey name +imageID - ipptopsps : expID x y (*** is this right???) (smf:IMAGEID / gpc1.chipRun.chip_image_id)_ +randomDetID + ipptopsps : RANDOM from sql +dvoRegionID + dvo:average.catID +obsTime + smf:MJD-OBS + 0.5 EXPTIME / 84600 +xPos + smf:X_PSF +yPos + smf:Y_PSF +xPosErr + smf:X_PSF_SIG +yPosErr + smf:Y_PSF_SIG +pltScale + smf:PLTSCALE (negative -> sky parity) +posAngle + smf:POSANGLE +--------------- +ra + dvo:measure.ra +dec + dvo:measure.dec +raErr + smf:X_PSF_SIG * abs(PLTSCALE) +decErr + smf:Y_PSF_SIG * abs(PLTSCALE) +extNSigma + smf:EXT_NSIGMA +zp + dvo / dvopsps : zp +telluricExt + dvo / dvopsps : zp - zpNominal (dvopsps) +expTime + dvo:measure.dt [converted to seconds] +airMass + dvo:measure.airmass +--------------- +psfFlux + smf:PSF_INST_FLUX / EXPTIME +psfFluxErr + smf:PSF_INST_FLUX_SIG / EXPTIME +psfMajorFWHM + smf:PSF_FWHM_MAJ +psfMinorFWHM + smf:PSF_FWHM_MIN +psfTheta + smf:PSF_THETA +psfCore + smf:PSF_CORE +psfQf + smf:PSF_QF +psfQfPerfect + smf:PSF_QF_PERFECT +psfChiSq + smf:PSF_CHISQ +psfLikelihood + smf:EXT_NSIGMA +momentXX + smf:MOMENTS_XX +momentXY + smf:MOMENTS_XY +momentYY + smf:MOMENTS_YY +momentR1 + smf:MOMENTS_R1 +momentRH + smf:MOMENTS_RH +momentM3C + smf:MOMENTS_M3C +momentM3S + smf:MOMENTS_M3S +momentM4C + smf:MOMENTS_M4C +momentM4S + smf:MOMENTS_M4S +apFlux + smf:AP_FLUX +apFluxErr + smf:AP_FLUX_SIG +apFillF + smf:AP_NPIX / (pi * (AP_MAG_RADIUS - 0.5)^2) +kronFlux + smf:KRON_FLUX +kronFluxErr + smf:KRON_FLUX_ERR +kronRad + smf:2.5*MOMENTS_R1 +sky + smf:SKY / exptime +skyErr + smf:SKY_SIGMA / exptime +infoFlag + smf:FLAGS +infoFlag2 + smf:FLAGS2 | (dvo.measure.flags << 13) +dataRelease + ippToPsps : user input (skychunk.dataRelease) Index: /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/DiffDetObject =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/DiffDetObject (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/DiffDetObject (revision 38088) @@ -0,0 +1,38 @@ + +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 +uniquePspsDOid dimentionless BIGINT 8 NA unique id provided by ipptopsps, based on batch_Id + counter +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 INT 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 (DROP) +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 +gQfPerfect dimensionless REAL 4 -999 qfPerfect for g filter +rQfPerfect dimensionless REAL 4 -999 qfPerfect for r filter +iQfPerfect dimensionless REAL 4 -999 qfPerfect for i filter +zQfPerfect dimensionless REAL 4 -999 qfPerfect for z filter +yQfPerfect dimensionless REAL 4 -999 qfPerfect for y filter +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/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/DiffDetObject.txt =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/DiffDetObject.txt (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/DiffDetObject.txt (revision 38088) @@ -0,0 +1,38 @@ + +diffObjName = ipptopsps +diffObjID = dvo:cpt.extID +uniquePspsDOid = ipptopsps +ippObjID = dvo:cpt.objID | cpt.catID <<32 +surveyID = ipptopsps +skyCellID = smf header ?? how does this work for objects +htmID = PSPS +zoneID = PSPS +randomID = ipptopsps +batchID = ipptopsps +dvoRegionID = dvo:cpt:catID +objInfoFlag = dvo:cpt.flags +qualityFlag = dvo:cpt.flags >> 24 & 0xff (needed??) +consistencyFlag = ? +ra = dvo:cpt.RA_MEAN +dec = dvo:cpt.DEC_MEAN +raErr = dvo:cpt.RA_ERR +decErr = dvo:cpt.DEC_ERR +cx = PSPS +cy = PSPS +cz = PSPS +lambda = PSPS +beta = PSPS +l = PSPS +b = PSPS +gQfPerfect = dvo:secfilt.PSF_QF_PERF_MAX +rQfPerfect = dvo:secfilt.PSF_QF_PERF_MAX +iQfPerfect = dvo:secfilt.PSF_QF_PERF_MAX +zQfPerfect = dvo:secfilt.PSF_QF_PERF_MAX +yQfPerfect = dvo:secfilt.PSF_QF_PERF_MAX +dataRelease = ipptopsps +nDetections = ipptopsps:sum of ng+nr+ni+nz+ny +ng = dvo:secfilt.nwarp +nr = dvo:secfilt.nwarp +ni = dvo:secfilt.nwarp +nz = dvo:secfilt.nwarp +ny = dvo:secfilt.nwarp Index: /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/DiffDetection =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/DiffDetection (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/DiffDetection (revision 38088) @@ -0,0 +1,70 @@ + +diffObjID dimensionless BIGINT 8 NA diff object identifier +uniquePspsDFid dimensionless BIGINT 8 NA unique psps id (combination of batch_id, and counter) provided by ipptopsps +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 INT 4 0 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 +------------------------------------------------------- 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 INT 4 -999 flag indicating provenance information +infoFlag2 dimensionless INT 4 -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/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/DiffDetection.txt =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/DiffDetection.txt (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/DiffDetection.txt (revision 38088) @@ -0,0 +1,71 @@ + +diffObjID = dvo / addstar +uniquePspsDFid = ipptopsps +diffDetID = dvo / addstar +diffDetMetaID = dvo / addstar +ippDetectID = dvo / addstar +ippObjID = dvo / addstar +filterID = smf / ipptopsps +surveyID = ipptopsps +randomDiffID = ipptopsps +skyCellID = smf header +dvoRegionID = dvo / catID +obsTime = smf +xPos = smf +yPos = smf +xPosErr = smf +yPosErr = smf +pltScale = smf +posAngle = smf +---------------- = +ra = dvo / relastro? [allow / require relastro recalibration?] +dec = dvo / relastro? +raErr = dvo / relastro? +decErr = dvo / relastro? +zp = dvo / relphot +telluricExt = (zp - zpNominal) dvopsps +expTime = smf +airMass = smf +---------------- = +psfFlux = smf +psfFluxErr = smf +psfMajorFWHM = [PSF_MAJOR is Sxx parameter, NOT FWHM] [ADD PSF_MAJ_FWHM to smf, keep PSF_MAJOR] +psfMinorFWHM = [PSF_MAJOR is Sxx parameter, NOT FWHM] [ditto] +psfTheta = smf +psfCore = [XXX : not currently written out!!] +psfQf = smf +psfQfPerfect = smf +psfChiSq = smf +psfLikelihood = ipptopsps +momentXX = smf +momentXY = smf +momentYY = smf +momentR1 = smf +momentRH = smf [XXX : MOMENTS_RH is NOT half-light radius] +momentM3C = smf +momentM3S = smf +momentM4C = smf +momentM4S = smf +apFlux = smf [PS1_DV2 or later] +apFluxErr = smf [PS1_DV2 or later] +apFillF = [XXX : not currently calculated] +kronFlux = smf +kronFluxErr = smf +kronRad = (2.5*R1) +---------------- = +diffNPos = smf +diffFRatio = smf +diffNBad = smf +diffNMask = smf +diffNAll = smf +diffPdist = smf +diffNdist = smf +diffPSN = smf +diffNSN = smf +---------------- = +sky = smf +skyErr = smf +infoFlag = smf +infoFlag2 = smf +dataRelease = ipptopsps + Index: /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedMeanLensing =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedMeanLensing (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedMeanLensing (revision 38088) @@ -0,0 +1,32 @@ + +objID dimensionless BIGINT 8 NA ODM object identifier index +uniquePspsFOid dimensionless BIGINT 8 NA unique id supplied by ipptopsps +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 dimensionless INT 4 stack image id (how to carry through IPP + DVO) +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 + +-- duplicated for other filters +-- [184 byte/obj/filter + 22 byte/obj] + Index: /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedMeanLensing.txt =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedMeanLensing.txt (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedMeanLensing.txt (revision 38088) @@ -0,0 +1,37 @@ + +objID = cpt.extID +uniquePspsFOid = ipptopsps +ippObjID = cpt.objID | cpt.catID << 32 +nDetections = sql sum of cps.NCODE (xnTotal) +batchID = ipptopsps +---------------- = +gStackID = ipptopsps / gpc1 db +gLensObjSmearX11 = cpy.X11_SM_OBJ +gLensObjSmearX12 = cpy.X12_SM_OBJ +gLensObjSmearX22 = cpy.X22_SM_OBJ +gLensObjSmearE1 = cpy.E1_SM_OBJ +gLensObjSmearE2 = cpy.E2_SM_OBJ +gLensObjShearX11 = cpy.X11_SH_OBJ +gLensObjShearX12 = cpy.X12_SH_OBJ +gLensObjShearX22 = cpy.X22_SH_OBJ +gLensObjShearE1 = cpy.E1_SH_OBJ +gLensObjShearE2 = cpy.E2_SH_OBJ +gLensPSFSmearX11 = cpy.X11_SM_PSF +gLensPSFSmearX12 = cpy.X12_SM_PSF +gLensPSFSmearX22 = cpy.X22_SM_PSF +gLensPSFSmearE1 = cpy.E1_SM_PSF +gLensPSFSmearE2 = cpy.E2_SM_PSF +gLensPSFShearX11 = cpy.X11_SH_PSF +gLensPSFShearX12 = cpy.X12_SH_PSF +gLensPSFShearX22 = cpy.X22_SH_PSF +gLensPSFShearE1 = cpy.E1_SH_PSF +gLensPSFShearE2 = cpy.E2_SH_PSF + +[NOTES: + + * PSF Flux, Kron Flux, Ap Flux stats are all + calculated from values in the existing Measure table + + * R5 & R6 ap flux values & lensing parameters need + a new table + Index: /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedMeanObject =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedMeanObject (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedMeanObject (revision 38088) @@ -0,0 +1,42 @@ + +objID dimensionless BIGINT 8 NA ODM object identifier index +uniquePspsFOid dimensionless BIGINT 8 NA unique id supplied by ipptopsps +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 dimensionless INT 4 stack image id (how to carry through IPP + DVO) +gnTotal dimensionless SMALLINT 2 -999 number of detections in g filter +gnIncPSFFlux dimensionless SMALLINT 2 -999 number of detections included in robust psf mean in g filter +gnIncKronFlux dimensionless SMALLINT 2 -999 number of detections included in robust mean of Kron flux in g filter +gnIncApFlux dimensionless SMALLINT 2 -999 number of detections included in robust mean of Ap flux 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 +gPSFFlux adu/seconds 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 +gPSFFluxErr adu/seconds REAL 4 -999 estimated error of g psf AB magnitude mean (individual errors added in quadrature) +gPSFFluxStd dimensionless REAL 4 -999 standard deviation of measurements included in the robust mean +gKronFlux adu/seconds REAL 4 -999 mean g kron AB magnitude +gKronFluxErr adu/seconds REAL 4 -999 estimated error of g kron AB magnitude mean +gKronFluxStd dimensionless REAL 4 -999 standard deviation of measurements included in the robust mean +gApFlux adu/seconds REAL 4 -999 mean g kron AB magnitude +gApFluxErr adu/seconds REAL 4 -999 estimated error of g kron AB magnitude mean +gApFluxStd 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 +------------------------------------------------------ +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/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedMeanObject.txt =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedMeanObject.txt (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedMeanObject.txt (revision 38088) @@ -0,0 +1,47 @@ + +objID = cpt.extID +uniquePspsFOid = ipptopsps +ippObjID = cpt.objID | cpt.catID << 32 +nDetections = sql sum of cps.NCODE (xnTotal) +batchID = ipptopsps +---------------- = +gStackID = ipptopsps / gpc1 db +gnTotal = cps.NWARP +gnIncPSFFlux = cps.NUSED_WRP +gnIncKronFlux = cps.NUSED_KRON_WRP +gnIncApFlux = cps.NUSED_AP_WRP +gnIncR5 = cpy.NMEAS +gnIncR6 = cpy.NMEAS +---------------- = +gPSFFlux = cps.FLUX_PSF_WRP +gPSFFluxErr = cps.FLUX_PSF_WRP_ERR +gPSFFluxStd = cps.FLUX_PSF_WRP_STD +gKronFlux = cps.FLUX_KRON_WRP +gKronFluxErr = cps.FLUX_KRON_WRP_ERR +gKronFluxStd = cps.FLUX_KRON_WRP_STD +gApFlux = cps.FLUX_AP_WRP +gApFluxErr = cps.FLUX_AP_WRP_ERR +gApFluxStd = cps.FLUX_AP_WRP_STD +---------------- = +gFmeanflxR5 = cpy.FLUX_AP_R5 +gFmeanflxR5Err = cpy.FLUX_ERR_AP_R5 +gFmeanflxR5Std = cpy.FLUX_STD_AP_R5 +gFmeanflxR5Fill = cpy.FLUX_FIL_AP_R5 +gFmeanflxR6 = cpy.FLUX_AP_R6 +gFmeanflxR6Err = cpy.FLUX_ERR_AP_R6 +gFmeanflxR6Std = cpy.FLUX_STD_AP_R6 +gFmeanflxR6Fill = cpy.FLUX_FIL_AP_R6 +gFlags = cps.FLAGS +---------------- = +gGamma = cpy.GAMMA +gE1 = cpy.E1 +gE2 = cpy.E2 + +[NOTES: + + * PSF Flux, Kron Flux, Ap Flux stats are all + calculated from values in the existing Measure table + + * R5 & R6 ap flux values & lensing parameters need + a new table + Index: /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpExtended =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpExtended (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpExtended (revision 38088) @@ -0,0 +1,26 @@ + +objID dimensionless BIGINT 8 NA ODM object identifier +uniquePspsFWid dimentionless BIGINT 8 NA unique id supplied by ipptopsps +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 INT 4 -999 identifier to dvo spatial region +obsTime MeanJulianDays FLOAT 8 -999 Time of mid observation in Mean Julian Days +------------------------------------------------------ +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 +------------------------------------------------------ + +-- [295 byte/det] +-- this table is only for non-Galatic-plane data Index: /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpExtended.txt =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpExtended.txt (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpExtended.txt (revision 38088) @@ -0,0 +1,23 @@ + +objID = cpt.extID +uniquePspsFWid = ipptopsps +detectID = cpm.extID (???) +ippObjID = cpt.obj_ID | cpx.cat_ID << 32 +ippDetectID = cmf.IPP_IDET +filterID = ipptopsps / gpc1 +surveyID = ipptopsps +forcedWarpID = ipptopsps / gpc1 +randomWarpID = ipptopsps +skyCellID = ipptopsps / gpc1 +dvoRegionID = ipptopsps / gpc1 +obsTime = cmf +---------------- = +flxR5 = cmf.FLX_AP_R5 +flxR5Err = cmf.FLX_ERR_AP_R5 +flxR5Std = cmf.FLX_STD_AP_R5 +flxR5Fill = cmf.FLX_FIL_AP_R5 +flxR6 = cmf.FLX_AP_R6 +flxR6Err = cmf.FLX_ERR_AP_R6 +flxR6Std = cmf.FLX_STD_AP_R6 +flxR6Fill = cmf.FLX_FIL_AP_R6 +---------------- = Index: /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpLensing =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpLensing (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpLensing (revision 38088) @@ -0,0 +1,38 @@ + +objID dimensionless BIGINT 8 NA ODM object identifier +uniquePspsFWid dimentionless BIGINT 8 NA unique id supplied by ipptopsps +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 INT 4 -999 identifier to dvo spatial region +obsTime MeanJulianDays FLOAT 8 -999 Time of mid observation in Mean Julian Days +------------------------------------------------------ +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 +------------------------------------------------------ + +-- [295 byte/det] +-- this table is only for non-Galatic-plane data Index: /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpLensing.txt =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpLensing.txt (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpLensing.txt (revision 38088) @@ -0,0 +1,35 @@ + +objID = cpt.extID +uniquePspsFWid = ipptopsps +detectID = cpm.extID (???) +ippObjID = cpt.obj_ID | cpx.cat_ID << 32 +ippDetectID = cmf.IPP_IDET +filterID = ipptopsps / gpc1 +surveyID = ipptopsps +forcedWarpID = ipptopsps / gpc1 +randomWarpID = ipptopsps +skyCellID = ipptopsps / gpc1 +dvoRegionID = ipptopsps / gpc1 +obsTime = cmf +---------------- = +lensObjSmearX11 = cmf.X11_SM_OBJ +lensObjSmearX12 = cmf.X12_SM_OBJ +lensObjSmearX22 = cmf.X22_SM_OBJ +lensObjSmearE1 = cmf.E1_SM_OBJ +lensObjSmearE2 = cmf.E2_SM_OBJ +lensObjShearX11 = cmf.X11_SH_OBJ +lensObjShearX12 = cmf.X12_SH_OBJ +lensObjShearX22 = cmf.X22_SH_OBJ +lensObjShearE1 = cmf.E1_SH_OBJ +lensObjShearE2 = cmf.E2_SH_OBJ +lensPSFSmearX11 = cmf.X11_SM_PSF +lensPSFSmearX12 = cmf.X12_SM_PSF +lensPSFSmearX22 = cmf.X22_SM_PSF +lensPSFSmearE1 = cmf.E1_SM_PSF +lensPSFSmearE2 = cmf.E2_SM_PSF +lensPSFShearX11 = cmf.X11_SH_PSF +lensPSFShearX12 = cmf.X12_SH_PSF +lensPSFShearX22 = cmf.X22_SH_PSF +lensPSFShearE1 = cmf.E1_SH_PSF +lensPSFShearE2 = cmf.E2_SH_PSF +---------------- = Index: /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpMeasurement =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpMeasurement (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpMeasurement (revision 38088) @@ -0,0 +1,53 @@ + +objID dimensionless BIGINT 8 NA ODM object identifier +uniquePspsFWid dimensionless BIGINT 8 NA unique identifier provided by ipptopsps +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 INT 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 (DROP) +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 arcsec REAL 4 -999 Kron radius +------------------------------------------------------ +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 +infoFlag2 dimensionless BIGINT 8 -999 FLAG2 | flags << 13 +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/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpMeasurement.txt =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpMeasurement.txt (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpMeasurement.txt (revision 38088) @@ -0,0 +1,51 @@ + +objID = cpt.extID (???) +uniquePspsFWid = ipptopsps +detectID = cpm.extID (???) +ippObjID = cpt.obj_id | cpt.cat_id << 32 +ippDetectID = smf:IPP_IDET +filterID = ipptopsps /gpc1 +surveyID = ipptopsps +forcedWarpID = ipptopsps / gpc1 +randomWarpID = ipptopsps +skyCellID = ipptopsps / gpc1 +dvoRegionID = ipptopsps / gpc1 +obsTime = smf +---------------- = +zp = dvopsps zp +telluricExt = dvopsps (zp - zpNominal) +expTime = smf +airMass = smf +---------------- = +psfFlux = smf:PSF_INST_FLUX / EXPTIME +psfFluxErr = smf:PSF_INST_FLUX_SIG / EXPTIME +psfMajorFWHM = smf:PSF_FWHM_MAJ +psfMinorFWHM = smf:PSF_FWHM_MIN +psfTheta = smf:PSF_THETA +psfCore = smf:PSF_CORE +psfQf = smf:PSF_QF +psfQfPerfect = smf:PSF_QF_PERFECT +psfChiSq = smf:PSF_CHISQ +psfLikelihood = smf:NEXT_NSIGMA +momentXX = smf:MOMENTS_XX +momentXY = smf:MOMENTS_XY +momentYY = smf:MOMENTS_YY +momentR1 = smf:MOMENTS_R1 +momentRH = smf:MOMENTS_RH +momentM3C = smf:MOMENTS_M3C +momentM3S = smf:MOMENTS_M3S +momentM4C = smf:MOMENTS_M4C +momentM4S = smf:MOMENTS_M4S + = +apFlux = smf:AP_FLUX +apFluxErr = smf:AP_FLUX_SIG +apFillF = smf:AP_NPIX / (pi * (AP_MAG_RADIUS - 0.5)^2) +kronFlux = smf:KRON_FLUX +kronFluxErr = smf:KRON_FLUX_ERR +kronRad = smf:2.5*MOMENTS_R1 +---------------- = +sky = smf:SKY / exptime +skyErr = smf:SKY_SIGMA / exptime +infoFlag = smf:FLAGS +infoFlag2 = smf:FLAGS2 | (dvo.measure.flags << 13) +dataRelease = ipptopsps Index: /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/MeanObject =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/MeanObject (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/MeanObject (revision 38088) @@ -0,0 +1,28 @@ + +-- 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 +uniquePspsOBid dimensionless BIGINT 8 NA unique identifier provided by ipptopsps +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) +gMeanPSFMagStd dimensioless REAL 4 -999 standard deviation of best available measurements - compared with MeanErr this is one measure of true variability +gMeanPSFMagMin AB_magnitude REAL 4 -999 minimum best available PSFMag - min and max are given for PSFMag as they may indicate variability. +gMeanPSFMagMax AB_magnitude REAL 4 -999 maximum best available PSFMag +gMeanPSFMagNpt dimensionless SMALLINT 2 -999 number of best available detections included in mean 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 +gMeanKronMagStd dimensionless REAL 4 -999 standard deviation of best available measurements +gMeanKronMagNpt dimensionless SMALLINT 2 -999 number of best available detections included mean Kron mag + +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 +gMeanApMagStd dimensioless REAL 4 -999 standard deviation of best available measurements +gMeanApMagNpt dimensionless SMALLINT 2 -999 number of detections included in best available mean of Kron mag in g filter + +gFlags dimensionless INT 4 0 flags for g mean [XXX secfilt.flags is 4byte] +-- duplicate for other filters + +[62 byte/obj/filter + 8 byte/filter] Index: /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/MeanObject.txt =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/MeanObject.txt (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/MeanObject.txt (revision 38088) @@ -0,0 +1,24 @@ + +*** I've checked that these are plausible, not exact + +objID + dvo / addstar +uniquePspsOBid = ipptopsps +gQfPerfect + dvo / relphot / secfilt.psfQfMax +gMeanPSFMag + dvo / relphot / secfilt.M +gMeanPSFMagErr + dvo / relphot / secfilt.dM +gMeanPSFMagStd + dvo / relphot / secfilt.Mstdev +gMeanPSFMagMin + dvo / relphot / secfilt.Min +gMeanPSFMagMax + dvo / relphot / secfilt.Max +gMeanPSFMagNpt + dvo / relphot / secfilt.Nused + +gMeanKronMag + dvo / relphot / secfilt.Mkron +gMeanKronMagErr + dvo / relphot / secfilt.dMkron +gMeanKronMagStd + dvo / relphot / secfilt.sMkron +gMeanKronMagNpt + dvo / relphot / secfilt.NusedKron + +gMeanApMag + dvo / relphot / secfilt.Map +gMeanApMagErr + dvo / relphot / secfilt.dMap +gMeanApMagStd + dvo / relphot / secfilt.sMap +gMeanApMagNpt + dvo / relphot / secfilt.NusedAp + +gFlags + dvo / relphot / secfilt.flags Index: /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ObjectThin =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ObjectThin (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ObjectThin (revision 38088) @@ -0,0 +1,52 @@ + +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 +uniquePspsOBid dimensionless BIGINT 8 NA unique identifier provided by ipptopsps +ippObjID dimensionless BIGINT 8 NA IPP object number +surveyID dimensionless TINYINT 1 255 Survey ID +htmID dimensionless BIGINT 8 NA HTM index +zoneID dimensionless INT 4 NA Zone index +tessID dimensionless TINYINT 1 -1 ID mapping to tessellation names (eg, RINGS.V3, MD01.V3, etc) +projectionID dimensionless SMALLINT 2 -999 valid values 0 - < 10000 +skyCellID dimensionless TINYINT 1 255 valid values 0 - 143 (12x12 grid) +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 INT 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 (DROP) +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 +posMeanChisq dimensionless REAL 4 -999 chisq of mean position +-------------------------------------------------------------------------------------------------------- +-- 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/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ObjectThin.txt =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ObjectThin.txt (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ObjectThin.txt (revision 38088) @@ -0,0 +1,50 @@ + +objName - ipptopsps : move to dvopsps? +objID + dvo:average.extID +uniquePspsOBid = ipptopsps +ippObjID + dvo:(average.objID | average.catID << 32) +surveyID + ipptopsps : internal, from survey name +htmID - PSPS +zoneID - PSPS +tessID + average.tessID +projectionID + average.projectionID +skycellID + average.skycellID +randomID + ipptopsps : RANDOM from sql +batchID + ipptopsps : internal +dvoRegionID + dvo:average.catID +dataRelease + ipptopsps : user input (skychunk.dataRelease) +objInfoFlag + dvo:average.flags +qualityFlag - (dvo:average.flags >> 24) & 0xFF *** correct?? +consistencyFlag - *** hard-wired in ipptopsps to 0 +raStack + dvo:average.Rstk *** not calculated? +decStack + dvo:average.Dstk *** not calculated? +raStackErr + dvo:average.dRstk *** not calculated? +decStackErr + dvo:average.dDstk *** not calculated? +raMean + dvo:average.R +decMean + dvo:average.D +raMeanErr + dvo:average.dR +decMeanErr + dvo:average.dD +posMeanChisq + dvo:average.ChiSqAve +----------------- +-- +-- +-- +-- +-- +cx - PSPS +cy - PSPS +cz - PSPS +lambda - PSPS +beta - PSPS +l - PSPS +b - PSPS +----------------- +nStackObjectRows - do in dvopsps +-- +nStackDetections - sum of secfilt.NstackDet (sum in sql) +nDetections + ipptopsps:Sum of ng+nr in sql +ng + dvo:secfilt.ncode ** check that this is right +nr + dvo:secfilt.ncode ** check that this is right +ni + dvo:secfilt.ncode ** check that this is right +nz + dvo:secfilt.ncode ** check that this is right +ny + dvo:secfilt.ncode ** check that this is right Index: /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlx =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlx (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlx (revision 38088) @@ -0,0 +1,56 @@ + +objID dimensionless BIGINT 8 NA ODM object identifier +uniquePspsSTid dimensionless BIGINT 8 NA unique identifier provided by ipptopsps +ippObjID dimensionless BIGINT 8 NA ipp object 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. +------------------------------------------------------- replicate to end for each filter g,r,i,z,y +gippDetectID dimensionless BIGINT 8 NA stack identifier +gstackDetectID dimensionless BIGINT 8 NA ODM detection identifier +gstackMetaID dimensionless BIGINT 8 NA stack identifier +--------------------------------------------------------unconvolved +gflxR3 Jy REAL 4 -999 Flux inside r = 3 +gflxR3Err Jy REAL 4 -999 estimated error is flxR3 +gflxR3Std Jy REAL 4 -999 estimated standard deviation in flxR3 +gflxR3Fill dimensionless REAL 4 -999 estimated filling factor at R3 +gflxR4 Jy REAL 4 -999 Flux inside r = 4 +gflxR4Err Jy REAL 4 -999 estimated error is flxR4 +gflxR4Std Jy REAL 4 -999 estimated standard deviation in flxR4 +gflxR4Fill dimensionless REAL 4 -999 estimated filling factor at R4 +gflxR5 Jy REAL 4 -999 Flux inside r = 5 +gflxR5Err Jy REAL 4 -999 estimated error is flxR5 +gflxR5Std Jy 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 +gc6flxR3 Jy REAL 4 -999 Flux inside r = 3 +gc6flxR3Err Jy REAL 4 -999 estimated error is c1flxR3 +gc6flxR3Std Jy REAL 4 -999 estimated standard deviation in c1flxR3 +gc6flxR3Fill dimensionless REAL 4 -999 estimated filling factor at R3 +gc6flxR4 Jy REAL 4 -999 Flux inside r = 4 +gc6flxR4Err Jy REAL 4 -999 estimated error is c1flxR4 +gc6flxR4Std Jy REAL 4 -999 estimated standard deviation in c1flxR4 +gc6flxR4Fill dimensionless REAL 4 -999 estimated filling factor at R4 +gc6flxR5 Jy REAL 4 -999 Flux inside r = 5 +gc6flxR5Err Jy REAL 4 -999 estimated error is c1flxR5 +gc6flxR5Std Jy REAL 4 -999 estimated standard deviation in c1flxR5 +gc6flxR5Fill dimensionless REAL 4 -999 estimated filling factor at R5 +---------------------------------------------------- convolved across all bands to 6 or 8 pixels +gc8flxR3 Jy REAL 4 -999 Flux inside r = 3 +gc8flxR3Err Jy REAL 4 -999 estimated error in c2flxR3 +gc8flxR3Std Jy REAL 4 -999 estimated standard deviation in c2flxR3 +gc8flxR3Fill dimensionless REAL 4 -999 estimated filling factor at R3 +gc8flxR4 Jy REAL 4 -999 Flux inside r = 4 +gc8flxR4Err Jy REAL 4 -999 estimated error in c2flxR4 +gc8flxR4Std Jy REAL 4 -999 estimated standard deviation in c2flxR4 +gc8flxR4Fill dimensionless REAL 4 -999 estimated filling factor at R4 +gc8flxR5 Jy REAL 4 -999 Flux inside r = 5 +gc8flxR5Err Jy REAL 4 -999 estimated error in c2flxR5 +gc8flxR5Std Jy REAL 4 -999 estimated standard deviation in c2flxR5 +gc8flxR5Fill 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/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlx.txt =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlx.txt (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlx.txt (revision 38088) @@ -0,0 +1,52 @@ + +objID + from StackObjectThin +uniquePspsSTid = ipptopsps +ippObjID + from StackObjectThin +randomStackObjID + from StackObjectThin +stackDetectRowID - PSPS +primaryDetection - from StackObjectThin NOT YET TESTED +bestDetection - from StackObjectThin CANNOT BE SET until after PV3 +-- +---------------- +gippDetectID + from StackObjectThin +gstackDetectID + from StackObjectThin +gstackMetaID + from StackObjectThin +---------------- +gflxR3 + cmf : APER_FLUX_3 +gflxR3Err + cmf : APER_FLUX_ERR_3 +gflxR3Std - cmf : APER_FLUX_STDEV_3 : ** badly defined in cmf +gflxR3Fill + cmf : APER_FILL_3 +gflxR4 + cmf : APER_FLUX_4 +gflxR4Err + cmf : APER_FLUX_ERR_4 +gflxR4Std - cmf : APER_FLUX_STDEV_4 : ** badly defined in cmf +gflxR4Fill + cmf : APER_FILL_4 +gflxR5 + cmf : APER_FLUX_5 +gflxR5Err + cmf : APER_FLUX_ERR_5 +gflxR5Std - cmf : APER_FLUX_STDEV_5 : ** badly defined in cmf +gflxR5Fill + cmf : APER_FILL_5 +---------------- +gc6flxR3 + cmf : APER_FLUX_3 +gc6flxR3Err + cmf : APER_FLUX_ERR_3 +gc6flxR3Std - cmf : APER_FLUX_STDEV_3 : ** badly defined in cmf +gc6flxR3Fill + cmf : APER_FILL_3 +gc6flxR4 + cmf : APER_FLUX_4 +gc6flxR4Err + cmf : APER_FLUX_ERR_4 +gc6flxR4Std - cmf : APER_FLUX_STDEV_4 : ** badly defined in cmf +gc6flxR4Fill + cmf : APER_FILL_4 +gc6flxR5 + cmf : APER_FLUX_5 +gc6flxR5Err + cmf : APER_FLUX_ERR_5 +gc6flxR5Std - cmf : APER_FLUX_STDEV_5 : ** badly defined in cmf +gc6flxR5Fill + cmf : APER_FILL_5 +---------------- +gc8flxR3 + cmf : APER_FLUX_3 +gc8flxR3Err + cmf : APER_FLUX_ERR_3 +gc8flxR3Std - cmf : APER_FLUX_STDEV_3 : ** badly defined in cmf +gc8flxR3Fill + cmf : APER_FILL_3 +gc8flxR4 + cmf : APER_FLUX_4 +gc8flxR4Err + cmf : APER_FLUX_ERR_4 +gc8flxR4Std - cmf : APER_FLUX_STDEV_4 : ** badly defined in cmf +gc8flxR4Fill + cmf : APER_FILL_4 +gc8flxR5 + cmf : APER_FLUX_5 +gc8flxR5Err + cmf : APER_FLUX_ERR_5 +gc8flxR5Std - cmf : APER_FLUX_STDEV_5 : ** badly defined in cmf +gc8flxR5Fill + cmf : APER_FILL_5 Index: /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxExGalCon6 =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxExGalCon6 (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxExGalCon6 (revision 38088) @@ -0,0 +1,52 @@ + +objID dimensionless BIGINT 8 NA ODM object identifier +uniquePspsSTid dimensionless BIGINT 8 NA unique identifier provided by ipptopsps +ippObjID dimensionless BIGINT 8 NA object ID generated by IPP +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. +-------------------------------------------------------- replicate below for all filters (grizy) +gippDetectID dimensionless BIGINT 8 NA ipp detect identifier +gstackDetectID dimensionless BIGINT 8 NA ODM detection identifier +gstackMetaID dimensionless BIGINT 8 NA stack identifier +---------------------------------------------------------------------------------------- +gc6flxR1 Jy REAL 4 -999 Flux inside r = 1 +gc6flxR1Err Jy REAL 4 -999 estimated error is c1flxR1 +gc6flxR1Std Jy REAL 4 -999 estimated standard deviation in c1flxR1 +gc6flxR1Fill dimensionless REAL 4 -999 estimated filling factor at R1 +gc6flxR2 Jy REAL 4 -999 Flux inside r = 2 +gc6flxR2Err Jy REAL 4 -999 estimated error is c1flxR2 +gc6flxR2Std Jy REAL 4 -999 estimated standard deviation in c1flxR2 +gc6flxR2Fill dimensionless REAL 4 -999 estimated filling factor at R1 +gc6flxR3 Jy REAL 4 -999 Flux inside r = 3 +gc6flxR3Err Jy REAL 4 -999 estimated error is c1flxR3 +gc6flxR3Std Jy REAL 4 -999 estimated standard deviation in c1flxR3 +gc6flxR3Fill dimensionless REAL 4 -999 estimated filling factor at R3 +gc6flxR4 Jy REAL 4 -999 Flux inside r = 4 +gc6flxR4Err Jy REAL 4 -999 estimated error is c1flxR4 +gc6flxR4Std Jy REAL 4 -999 estimated standard deviation in c1flxR4 +gc6flxR4Fill dimensionless REAL 4 -999 estimated filling factor at R4 +gc6flxR5 Jy REAL 4 -999 Flux inside r = 5 +gc6flxR5Err Jy REAL 4 -999 estimated error is c1flxR5 +gc6flxR5Std Jy REAL 4 -999 estimated standard deviation in c1flxR5 +gc6flxR5Fill dimensionless REAL 4 -999 estimated filling factor at R5 +gc6flxR6 Jy REAL 4 -999 Flux inside r = 6 +gc6flxR6Err Jy REAL 4 -999 estimated error is c1flxR6 +gc6flxR6Std Jy REAL 4 -999 estimated standard deviation in c1flxR6 +gc6flxR6Fill dimensionless REAL 4 -999 estimated filling factor at R6 +gc6flxR7 Jy REAL 4 -999 Flux inside r = 7 +gc6flxR7Err Jy REAL 4 -999 estimated error is c1flxR7 +gc6flxR7Std Jy REAL 4 -999 estimated standard deviation in c1flxR7 +gc6flxR7Fill dimensionless REAL 4 -999 estimated filling factor at R7 +gc6flxR8 Jy REAL 4 -999 Flux inside r = 8 +gc6flxR8Err Jy REAL 4 -999 estimated error is c1flxR8 +gc6flxR8Std Jy REAL 4 -999 estimated standard deviation in c1flxR8 +gc6flxR8Fill dimensionless REAL 4 -999 estimated filling factor at R8 +gc6flxR9 Jy REAL 4 -999 Flux inside r = 9 +gc6flxR9Err Jy REAL 4 -999 estimated error is c1flxR9 +gc6flxR9Std Jy REAL 4 -999 estimated standard deviation in c1flxR9 +gc6flxR9Fill dimensionless REAL 4 -999 estimated filling factor at R9 + + Index: /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxExGalCon6.txt =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxExGalCon6.txt (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxExGalCon6.txt (revision 38088) @@ -0,0 +1,51 @@ + +objID + from StackObjectThin +uniquePspsSTid = ipptopsps +ippObjID + from StackObjectThin +randomStackObjID + from StackObjectThin +stackDetectRowID - PSPS +primaryDetection - from StackObjectThin NOT YET TESTED +bestDetection - from StackObjectThin CANNOT BE SET until after PV3 +-- +---------------- +gippDetectID + from StackObjectThin +gstackDetectID + from StackObjectThin +gstackMetaID + from StackObjectThin +---------------- +gc6flxR1 + cmf : APER_FLUX_1 +gc6flxR1Err + cmf : APER_FLUX_ERR_1 +gc6flxR1Std - cmf : APER_FLUX_STDEV_1 : ** badly defined in cmf +gc6flxR1Fill + cmf : APER_FILL_1 +gc6flxR2 + cmf : APER_FLUX_2 +gc6flxR2Err + cmf : APER_FLUX_ERR_2 +gc6flxR2Std - cmf : APER_FLUX_STDEV_2 : ** badly defined in cmf +gc6flxR2Fill + cmf : APER_FILL_2 +gc6flxR3 + cmf : APER_FLUX_3 +gc6flxR3Err + cmf : APER_FLUX_ERR_3 +gc6flxR3Std - cmf : APER_FLUX_STDEV_3 : ** badly defined in cmf +gc6flxR3Fill + cmf : APER_FILL_3 +gc6flxR4 + cmf : APER_FLUX_4 +gc6flxR4Err + cmf : APER_FLUX_ERR_4 +gc6flxR4Std - cmf : APER_FLUX_STDEV_4 : ** badly defined in cmf +gc6flxR4Fill + cmf : APER_FILL_4 +gc6flxR5 + cmf : APER_FLUX_5 +gc6flxR5Err + cmf : APER_FLUX_ERR_5 +gc6flxR5Std - cmf : APER_FLUX_STDEV_5 : ** badly defined in cmf +gc6flxR5Fill + cmf : APER_FILL_5 +gc6flxR6 + cmf : APER_FLUX_6 +gc6flxR6Err + cmf : APER_FLUX_ERR_6 +gc6flxR6Std - cmf : APER_FLUX_STDEV_6 : ** badly defined in cmf +gc6flxR6Fill + cmf : APER_FILL_6 +gc6flxR7 + cmf : APER_FLUX_7 +gc6flxR7Err + cmf : APER_FLUX_ERR_7 +gc6flxR7Std - cmf : APER_FLUX_STDEV_7 : ** badly defined in cmf +gc6flxR7Fill + cmf : APER_FILL_7 +gc6flxR8 + cmf : APER_FLUX_8 +gc6flxR8Err + cmf : APER_FLUX_ERR_8 +gc6flxR8Std - cmf : APER_FLUX_STDEV_8 : ** badly defined in cmf +gc6flxR8Fill + cmf : APER_FILL_8 +gc6flxR9 + cmf : APER_FLUX_9 +gc6flxR9Err + cmf : APER_FLUX_ERR_9 +gc6flxR9Std - cmf : APER_FLUX_STDEV_9 : ** badly defined in cmf +gc6flxR9Fill + cmf : APER_FILL_9 + Index: /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxExGalCon8 =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxExGalCon8 (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxExGalCon8 (revision 38088) @@ -0,0 +1,52 @@ + +objID dimensionless BIGINT 8 NA ODM object identifier +uniquePspsSTid dimensionless BIGINT 8 NA unique identifier provided by ipptopsps +ippObjID dimensionless BIGINT 8 NA object ID generated by IPP +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. +-------------------------------------------------------- replicate below for all filters (grizy) +gippDetectID dimensionless BIGINT 8 NA ipp detect identifier +gstackDetectID dimensionless BIGINT 8 NA ODM detection identifier +gstackMetaID dimensionless BIGINT 8 NA stack identifier +---------------------------------------------------------------------------------------- +gc8flxR1 Jy REAL 4 -999 Flux inside r = 1 +gc8flxR1Err Jy REAL 4 -999 estimated error is c2flxR1 +gc8flxR1Std Jy REAL 4 -999 estimated standard deviation in c2flxR1 +gc8flxR1Fill dimensionless REAL 4 -999 estimated filling factor at R1 +gc8flxR2 Jy REAL 4 -999 Flux inside r = 2 +gc8flxR2Err Jy REAL 4 -999 estimated error is c2flxR2 +gc8flxR2Std Jy REAL 4 -999 estimated standard deviation in c2flxR2 +gc8flxR2Fill dimensionless REAL 4 -999 estimated filling factor at R1 +gc8flxR3 Jy REAL 4 -999 Flux inside r = 3 +gc8flxR3Err Jy REAL 4 -999 estimated error is c2flxR3 +gc8flxR3Std Jy REAL 4 -999 estimated standard deviation in c2flxR3 +gc8flxR3Fill dimensionless REAL 4 -999 estimated filling factor at R3 +gc8flxR4 Jy REAL 4 -999 Flux inside r = 4 +gc8flxR4Err Jy REAL 4 -999 estimated error is c2flxR4 +gc8flxR4Std Jy REAL 4 -999 estimated standard deviation in c2flxR4 +gc8flxR4Fill dimensionless REAL 4 -999 estimated filling factor at R4 +gc8flxR5 Jy REAL 4 -999 Flux inside r = 5 +gc8flxR5Err Jy REAL 4 -999 estimated error is c2flxR5 +gc8flxR5Std Jy REAL 4 -999 estimated standard deviation in c2flxR5 +gc8flxR5Fill dimensionless REAL 4 -999 estimated filling factor at R5 +gc8flxR6 Jy REAL 4 -999 Flux inside r = 6 +gc8flxR6Err Jy REAL 4 -999 estimated error is c2flxR6 +gc8flxR6Std Jy REAL 4 -999 estimated standard deviation in c2flxR6 +gc8flxR6Fill dimensionless REAL 4 -999 estimated filling factor at R6 +gc8flxR7 Jy REAL 4 -999 Flux inside r = 7 +gc8flxR7Err Jy REAL 4 -999 estimated error is c2flxR7 +gc8flxR7Std Jy REAL 4 -999 estimated standard deviation in c2flxR7 +gc8flxR7Fill dimensionless REAL 4 -999 estimated filling factor at R7 +gc8flxR8 Jy REAL 4 -999 Flux inside r = 8 +gc8flxR8Err Jy REAL 4 -999 estimated error is c2flxR8 +gc8flxR8Std Jy REAL 4 -999 estimated standard deviation in c2flxR8 +gc8flxR8Fill dimensionless REAL 4 -999 estimated filling factor at R8 +gc8flxR9 Jy REAL 4 -999 Flux inside r = 9 +gc8flxR9Err Jy REAL 4 -999 estimated error is c2flxR9 +gc8flxR9Std Jy REAL 4 -999 estimated standard deviation in c2flxR9 +gc8flxR9Fill dimensionless REAL 4 -999 estimated filling factor at R9 + +-- repeat for other filters with appropriate leading prefex. Index: /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxExGalCon8.txt =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxExGalCon8.txt (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxExGalCon8.txt (revision 38088) @@ -0,0 +1,51 @@ + +objID + from StackObjectThin +uniquePspsSTid = ipptopsps +ippObjID + from StackObjectThin +randomStackObjID + from StackObjectThin +stackDetectRowID - PSPS +primaryDetection - from StackObjectThin NOT YET TESTED +bestDetection - from StackObjectThin CANNOT BE SET until after PV3 +-- +---------------- +gippDetectID + from StackObjectThin +gstackDetectID + from StackObjectThin +gstackMetaID + from StackObjectThin +---------------- +gc8flxR1 + cmf : APER_FLUX_1 +gc8flxR1Err + cmf : APER_FLUX_ERR_1 +gc8flxR1Std - cmf : APER_FLUX_STDEV_1 : ** badly defined in cmf +gc8flxR1Fill + cmf : APER_FILL_1 +gc8flxR2 + cmf : APER_FLUX_2 +gc8flxR2Err + cmf : APER_FLUX_ERR_2 +gc8flxR2Std - cmf : APER_FLUX_STDEV_2 : ** badly defined in cmf +gc8flxR2Fill + cmf : APER_FILL_2 +gc8flxR3 + cmf : APER_FLUX_3 +gc8flxR3Err + cmf : APER_FLUX_ERR_3 +gc8flxR3Std - cmf : APER_FLUX_STDEV_3 : ** badly defined in cmf +gc8flxR3Fill + cmf : APER_FILL_3 +gc8flxR4 + cmf : APER_FLUX_4 +gc8flxR4Err + cmf : APER_FLUX_ERR_4 +gc8flxR4Std - cmf : APER_FLUX_STDEV_4 : ** badly defined in cmf +gc8flxR4Fill + cmf : APER_FILL_4 +gc8flxR5 + cmf : APER_FLUX_5 +gc8flxR5Err + cmf : APER_FLUX_ERR_5 +gc8flxR5Std - cmf : APER_FLUX_STDEV_5 : ** badly defined in cmf +gc8flxR5Fill + cmf : APER_FILL_5 +gc8flxR6 + cmf : APER_FLUX_6 +gc8flxR6Err + cmf : APER_FLUX_ERR_6 +gc8flxR6Std - cmf : APER_FLUX_STDEV_6 : ** badly defined in cmf +gc8flxR6Fill + cmf : APER_FILL_6 +gc8flxR7 + cmf : APER_FLUX_7 +gc8flxR7Err + cmf : APER_FLUX_ERR_7 +gc8flxR7Std - cmf : APER_FLUX_STDEV_7 : ** badly defined in cmf +gc8flxR7Fill + cmf : APER_FILL_7 +gc8flxR8 + cmf : APER_FLUX_8 +gc8flxR8Err + cmf : APER_FLUX_ERR_8 +gc8flxR8Std - cmf : APER_FLUX_STDEV_8 : ** badly defined in cmf +gc8flxR8Fill + cmf : APER_FILL_8 +gc8flxR9 + cmf : APER_FLUX_9 +gc8flxR9Err + cmf : APER_FLUX_ERR_9 +gc8flxR9Std - cmf : APER_FLUX_STDEV_9 : ** badly defined in cmf +gc8flxR9Fill + cmf : APER_FILL_9 + Index: /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxExGalUnc =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxExGalUnc (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxExGalUnc (revision 38088) @@ -0,0 +1,50 @@ + +objID dimensionless BIGINT 8 NA ODM object identifier +uniquePspsSTid dimensionless BIGINT 8 NA unique identifier provided by ipptopsps +ippObjID dimensionless BIGINT 8 NA object ID generated by IPP +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. +-------------------------------------------------------- replicate below for all filters (grizy) +gippDetectID dimensionless BIGINT 8 NA ipp detect identifier +gstackDetectID dimensionless BIGINT 8 NA ODM detection identifier +gstackMetaID dimensionless BIGINT 8 NA stack identifier +---------------------------------------------------------------------------------------- +gflxR1 Jy REAL 4 -999 Flux inside r = 1 +gflxR1Err Jy REAL 4 -999 estimated error is flxR1 +gflxR1Std Jy REAL 4 -999 estimated standard deviation in flxR1 +gflxR1Fill dimensionless REAL 4 -999 estimated filling factor at R1 +gflxR2 Jy REAL 4 -999 Flux inside r = 2 +gflxR2Err Jy REAL 4 -999 estimated error is flxR2 +gflxR2Std Jy REAL 4 -999 estimated standard deviation in flxR2 +gflxR2Fill dimensionless REAL 4 -999 estimated filling factor at R1 +gflxR3 Jy REAL 4 -999 Flux inside r = 3 +gflxR3Err Jy REAL 4 -999 estimated error is flxR3 +gflxR3Std Jy REAL 4 -999 estimated standard deviation in flxR3 +gflxR3Fill dimensionless REAL 4 -999 estimated filling factor at R3 +gflxR4 Jy REAL 4 -999 Flux inside r = 4 +gflxR4Err Jy REAL 4 -999 estimated error is flxR4 +gflxR4Std Jy REAL 4 -999 estimated standard deviation in flxR4 +gflxR4Fill dimensionless REAL 4 -999 estimated filling factor at R4 +gflxR5 Jy REAL 4 -999 Flux inside r = 5 +gflxR5Err Jy REAL 4 -999 estimated error is flxR5 +gflxR5Std Jy REAL 4 -999 estimated standard deviation in flxR5 +gflxR5Fill dimensionless REAL 4 -999 estimated filling factor at R5 +gflxR6 Jy REAL 4 -999 Flux inside r = 6 +gflxR6Err Jy REAL 4 -999 estimated error is flxR6 +gflxR6Std Jy REAL 4 -999 estimated standard deviation in flxR6 +gflxR6Fill dimensionless REAL 4 -999 estimated filling factor at R6 +gflxR7 Jy REAL 4 -999 Flux inside r = 7 +gflxR7Err Jy REAL 4 -999 estimated error is flxR7 +gflxR7Std Jy REAL 4 -999 estimated standard deviation in flxR7 +gflxR7Fill dimensionless REAL 4 -999 estimated filling factor at R7 +gflxR8 Jy REAL 4 -999 Flux inside r = 8 +gflxR8Err Jy REAL 4 -999 estimated error is flxR8 +gflxR8Std Jy REAL 4 -999 estimated standard deviation in flxR8 +gflxR8Fill dimensionless REAL 4 -999 estimated filling factor at R8 +gflxR9 Jy REAL 4 -999 Flux inside r = 9 +gflxR9Err Jy REAL 4 -999 estimated error is flxR9 +gflxR9Std Jy REAL 4 -999 estimated standard deviation in flxR9 +gflxR9Fill dimensionless REAL 4 -999 estimated filling factor at R9 Index: /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxExGalUnc.txt =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxExGalUnc.txt (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxExGalUnc.txt (revision 38088) @@ -0,0 +1,51 @@ + +objID + from StackObjectThin +uniquePspsSTid = ipptopsps +ippObjID + from StackObjectThin +randomStackObjID + from StackObjectThin +stackDetectRowID - PSPS +primaryDetection - from StackObjectThin NOT YET TESTED +bestDetection - from StackObjectThin CANNOT BE SET until after PV3 +-- +---------------- +gippDetectID + from StackObjectThin +gstackDetectID + from StackObjectThin +gstackMetaID + from StackObjectThin +---------------- +gflxR1 + cmf : APER_FLUX_1 +gflxR1Err + cmf : APER_FLUX_ERR_1 +gflxR1Std - cmf : APER_FLUX_STDEV_1 : ** badly defined in cmf +gflxR1Fill + cmf : APER_FILL_1 +gflxR2 + cmf : APER_FLUX_2 +gflxR2Err + cmf : APER_FLUX_ERR_2 +gflxR2Std - cmf : APER_FLUX_STDEV_2 : ** badly defined in cmf +gflxR2Fill + cmf : APER_FILL_2 +gflxR3 + cmf : APER_FLUX_3 +gflxR3Err + cmf : APER_FLUX_ERR_3 +gflxR3Std - cmf : APER_FLUX_STDEV_3 : ** badly defined in cmf +gflxR3Fill + cmf : APER_FILL_3 +gflxR4 + cmf : APER_FLUX_4 +gflxR4Err + cmf : APER_FLUX_ERR_4 +gflxR4Std - cmf : APER_FLUX_STDEV_4 : ** badly defined in cmf +gflxR4Fill + cmf : APER_FILL_4 +gflxR5 + cmf : APER_FLUX_5 +gflxR5Err + cmf : APER_FLUX_ERR_5 +gflxR5Std - cmf : APER_FLUX_STDEV_5 : ** badly defined in cmf +gflxR5Fill + cmf : APER_FILL_5 +gflxR6 + cmf : APER_FLUX_6 +gflxR6Err + cmf : APER_FLUX_ERR_6 +gflxR6Std - cmf : APER_FLUX_STDEV_6 : ** badly defined in cmf +gflxR6Fill + cmf : APER_FILL_6 +gflxR7 + cmf : APER_FLUX_7 +gflxR7Err + cmf : APER_FLUX_ERR_7 +gflxR7Std - cmf : APER_FLUX_STDEV_7 : ** badly defined in cmf +gflxR7Fill + cmf : APER_FILL_7 +gflxR8 + cmf : APER_FLUX_8 +gflxR8Err + cmf : APER_FLUX_ERR_8 +gflxR8Std - cmf : APER_FLUX_STDEV_8 : ** badly defined in cmf +gflxR8Fill + cmf : APER_FILL_8 +gflxR9 + cmf : APER_FLUX_9 +gflxR9Err + cmf : APER_FLUX_ERR_9 +gflxR9Std - cmf : APER_FLUX_STDEV_9 : ** badly defined in cmf +gflxR9Fill + cmf : APER_FILL_9 + Index: /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitDeV =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitDeV (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitDeV (revision 38088) @@ -0,0 +1,28 @@ + +objID dimensionless BIGINT 8 NA ODM object identifier +uniquePspsSTid dimensionless BIGINT 8 NA unique identifier provided by ipptopsps +ippObjID dimensionless BIGINT 8 NA object ID generated by IPP +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. +-------------------------------------------------------- replicate below for all filters (grizy) +gippDetectID dimensionless BIGINT 8 NA ipp detect identifier +gstackDetectID dimensionless BIGINT 8 NA ODM detection identifier +gstackMetaID dimensionless BIGINT 8 NA stack identifier +---------------------------------------------------------------------------------------- +gDeVRadius arcsec REAL 4 -999 DeVaucouleurs radius +gDeVRadiusErr arcsec REAL 4 -999 estimated error in DeVaucouleurs radius +gDeVMag AB_mag REAL 4 -999 DeVaucouleurs flux +gDeVMagErr AB_mag 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 +gDevChisq Index: /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitDeV.txt =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitDeV.txt (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitDeV.txt (revision 38088) @@ -0,0 +1,29 @@ + +objID + from StackObjectThin +uniquePspsSTid = ipptopsps +ippObjID + from StackObjectThin +randomStackObjID + from StackObjectThin +stackDetectRowID - PSPS +primaryDetection - from StackObjectThin NOT YET TESTED +bestDetection - from StackObjectThin CANNOT BE SET until after PV3 +-- +---------------- +gippDetectID + from StackObjectThin +gstackDetectID + from StackObjectThin +gstackMetaID + from StackObjectThin +---------------- +gDeVRadius + cmf : EXT_WIDTH_MAJ +gDeVRadiusErr - cmf : EXT_WIDTH_MAJ_SIG ** NULL in cmf +gDeVMag + cmf : EXT_INST_MAG + 2.5log(exptime) + dvo.zp +gDeVMagErr + cmf : EXT_INST_MAG_SIG ** seems kind of small in CMF +gDeVAb + cmf : EXT_WIDTH_MAJ/EXT_WIDTH_MIN ** should this be Minor / Major? +gDeVAbErr - cmf : EXT_WIDTH_MIN_ERR +gDeVPhi + cmf : EXT_THETA +gDeVPhiErr - cmf : EXT_THETA_ERR +gDeVRa + cmf : use X_EXT and X_PSF, PLTSCALE to offset StackObjectThin.gra +gDeVDec + cmf : use Y_EXT and Y_PSF, PLTSCALE to offset StackObjectThin.gdec +gDeVRaErr + cmf : X_EXT_SIG * PLTSCALE +gDeVDecErr + cmf : Y_EXT_SIG * PLTSCALE +gDeVCf - ** I do not have a source for this in the CMF +gDeVChisq - cmf : EXT_CHISQ / EXT_NDOF +-- gDeVLikelihood - ** replace with chisq? Index: /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitExp =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitExp (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitExp (revision 38088) @@ -0,0 +1,29 @@ + +objID dimensionless BIGINT 8 NA ODM object identifier +uniquePspsSTid dimensionless BIGINT 8 NA unique identifier provided by ipptopsps +ippObjID dimensionless BIGINT 8 NA object ID generated by IPP +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. +------------------------------------------------------- replicate below for all filters (grizy) +gippDetectID dimensionless BIGINT 8 NA ipp detect identifier +gstackDetectID dimensionless BIGINT 8 NA ODM detection identifier +gstackMetaID dimensionless BIGINT 8 NA stack identifier +---------------------------------------------------------------------------------------- +gExpRadius arcsec REAL 4 -999 Exponential fit radius +gExpRadiusErr arcsec REAL 4 -999 estimated error in Exponential fit radius +gExpMag AB_mag REAL 4 -999 Exponential fit flux +gExpMagErr AB_mag REAL 4 -999 estimated error in expFlux +gExpAb dimensionless REAL 4 -999 Exponential fit axis ratio (minor / major) +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 +gExpRa degrees DOUBLE 8 -999 RA of Exponential fit +gExpDec degrees DOUBLE 8 -999 DEC of Exponential fit +gExpRaErr arcsec REAL 4 -999 estimated error in RA +gExpDecErr arcsec REAL 4 -999 estimated error in DEC +gExpCf dimensionless REAL 4 -999 Exponential fit coverage factor +gExpChisq dimensionless REAL 4 -999 Exponential fit chi square +-- gExpLikelihood dimensionless REAL 4 -999 Exponential fit likelihood factor Index: /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitExp.txt =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitExp.txt (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitExp.txt (revision 38088) @@ -0,0 +1,28 @@ + +objID + from StackObjectThin +uniquePspsSTid = ipptopsps +ippObjID + from StackObjectThin +randomStackObjID + from StackObjectThin +stackDetectRowID - PSPS +primaryDetection - from StackObjectThin NOT YET TESTED +bestDetection - from StackObjectThin CANNOT BE SET until after PV3 +-- +---------------- +gippDetectID + from StackObjectThin +gstackDetectID + from StackObjectThin +gstackMetaID + from StackObjectThin +---------------- +gExpRadius + cmf : EXT_WIDTH_MAJ +gExpRadiusErr - cmf : EXT_WIDTH_MAJ_SIG ** NULL in cmf +gExpMag + cmf : EXT_INST_MAG + 2.5log(exptime) + dvo.zp +gExpMagErr + cmf : EXT_INST_MAG_SIG ** seems kind of small in CMF +gExpAb + cmf : EXT_WIDTH_MIN/EXT_WIDTH_MAJ +gExpAbErr - cmf : EXT_WIDTH_MIN_ERR +gExpPhi + cmf : EXT_THETA ** in radians, not degrees (fixed, check) +gExpPhiErr - cmf : EXT_THETA_ERR +gExpRa + cmf : use X_EXT and X_PSF, PLTSCALE to offset StackObjectThin.gra +gExpDec + cmf : use Y_EXT and Y_PSF, PLTSCALE to offset StackObjectThin.gdec +gExpRaErr + cmf : X_EXT_SIG * PLTSCALE +gExpDecErr + cmf : Y_EXT_SIG * PLTSCALE +gExpCf - ** I do not have a source for this in the CMF +gExpChisq - cmf : EXT_CHISQ / EXT_NDOF Index: /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitExtra =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitExtra (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitExtra (revision 38088) @@ -0,0 +1,22 @@ + +objID dimensionless BIGINT 8 NA ODM object identifier +uniquePspsSTid dimensionless BIGINT 8 NA unique ipptopsps id +ippObjID dimensionless BIGINT 8 NA object ID generated by IPP +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. +-------------------------------------------------------- replicate below for all filters (grizy) +gippDetectID dimensionless BIGINT 8 NA ipp detect identifier +gstackDetectID dimensionless BIGINT 8 NA ODM detection identifier +gstackMetaID dimensionless BIGINT 8 NA stack identifier +-------------------------------------------------------- +gS2 dimensionless REAL 4 -999 (un)smoothness (Cheng 2012, Simard 2002) +glogRT dimensionless REAL 4 -999 total residual (from ellipcally symmetric model) +glogRA dimensionless REAL 4 -999 asymmetric residual (from ellipcally symmetric model) +glogC dimensionless REAL 4 -999 concentration index (Petrosian R_50 / R_90) +glogA dimensionless REAL 4 -999 log of asymmetry index (Gyory & Bell 2010) +gbumpy dimensionless REAL 4 -999 Blakeslee bumpiness +ghalfLightRad arcsec REAL 4 -999 half-light radius +-------------------------------------------------------- replicate below for all filters (grizy) Index: /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitSer =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitSer (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitSer (revision 38088) @@ -0,0 +1,31 @@ + +objID dimensionless BIGINT 8 NA ODM object identifier +uniquePspsSTid dimensionless BIGINT 8 NA unique identifier provided by ipptopsps +ippObjID dimensionless BIGINT 8 NA object ID generated by IPP +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. +-------------------------------------------------------- replicate below for all filters (grizy) +gippDetectID dimensionless BIGINT 8 NA ipp detect identifier +gstackDetectID dimensionless BIGINT 8 NA ODM detection identifier +gstackMetaID dimensionless BIGINT 8 NA stack identifier +---------------------------------------------------------------------------------------- +gSerRadius arcsec REAL 4 -999 Sersic radius +gSerRadiusErr arcsed REAL 4 -999 estimated error in Sersic radius +gSerMag AB_mag REAL 4 -999 Sersic Flux +gSerMagErr AB_mag 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 +gSerRa dimensionless REAL 4 -999 Offset in RA of Sersic fit from PSF RA +gSerDec dimensionless REAL 4 -999 Offset in DEC of Sersic fit from PSF DEC +gSerRaErr dimensionless REAL 4 -999 estimated error in raSerOff +gSerDecErr dimensionless REAL 4 -999 estimated error in decSerOff +gserCf dimensionless REAL 4 -999 Sersic fit coverage factor +gserChisq + Index: /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitSer.txt =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitSer.txt (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitSer.txt (revision 38088) @@ -0,0 +1,31 @@ + +objID + from StackObjectThin +uniquePspsSTid = ipptopsps +ippObjID + from StackObjectThin +randomStackObjID + from StackObjectThin +stackDetectRowID - PSPS +primaryDetection - from StackObjectThin NOT YET TESTED +bestDetection - from StackObjectThin CANNOT BE SET until after PV3 +-- +---------------- +gippDetectID + from StackObjectThin +gstackDetectID + from StackObjectThin +gstackMetaID + from StackObjectThin +---------------- +gSerRadius + cmf : EXT_WIDTH_MAJ +gSerRadiusErr - cmf : EXT_WIDTH_MAJ_SIG ** NULL in cmf +gSerMag + cmf : EXT_INST_MAG + 2.5log(exptime) + dvo.zp +gSerMagErr + cmf : EXT_INST_MAG_SIG ** seems kind of small in CMF +gSerAb - cmf : EXT_WIDTH_MAJ/EXT_WIDTH_MIN ** should this be Minor / Major? +gSerAbErr - cmf : EXT_WIDTH_MIN_ERR +gSerNu + cmf : EXT_PAR_07 +gSerNuErr - cmf : 0.1 ** NOTE this is hard-wired +gSerPhi - cmf : EXT_THETA ** in radians, not degrees +gSerPhiErr - cmf : EXT_THETA_ERR +gSerRa + cmf : use X_EXT and X_PSF, PLTSCALE to offset StackObjectThin.gra +gSerDec + cmf : use Y_EXT and Y_PSF, PLTSCALE to offset StackObjectThin.gdec +gSerRaErr + cmf : X_EXT_SIG * PLTSCALE +gSerDecErr + cmf : Y_EXT_SIG * PLTSCALE +gSerCf - ** I do not have a source for this in the CMF +gSerChisq - cmf : EXT_CHISQ / EXT_NDOF +--gSerLikelihood - ** replace with chisq? Index: /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectAttributes =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectAttributes (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectAttributes (revision 38088) @@ -0,0 +1,43 @@ + +objID dimensionless BIGINT 8 NA ODM object identifie +uniquePspsSTid dimensionless BIGINT 8 NA unique identifier provided by ipptopsps +ippObjID dimensionless BIGINT 8 NA object ID generated by IPP +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. +------------------------------------------------------------------------------------------ +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 pixels REAL 4 -999 measured x in sky Cell from PSF fit +gyPos pixels REAL 4 -999 measured y in sky Cell from PSF fit +gxPosErr pixels REAL 4 -999 estimated error in x +gyPosErr pixels REAL 4 -999 estimated error in y +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 (REMOVE) +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 +gexpTime seconds REAL 4 -999 total exposure time (informational) +gExtNSigma dimensionless REAL 4 -999 EXT_NSIGMA, how extended something is +gzp magnitude REAL 4 0 zeropoint , no error given +gPlateScale arcsec/pixel REAL 4 0 plate scale Index: /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectAttributes.txt =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectAttributes.txt (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectAttributes.txt (revision 38088) @@ -0,0 +1,44 @@ + +objID + from StackObjectThin +uniquePspsSTid = ipptopsps +ippObjID + from StackObjectThin +randomStackObjID + from StackObjectThin +stackDetectRowID - PSPS +primaryDetection - from StackObjectThin NOT YET TESTED +bestDetection - from StackObjectThin CANNOT BE SET until after PV3 + +------------------ +gippDetectID + from StackObjectThin +gstackDetectID + from StackObjectThin +gstackMetaID + from StackObjectThin +------------------ +gxPos + cmf : X_PSF +gyPos + cmf : Y_PSF +gxPosErr + cmf : X_PSF_SIG +gyPosErr + cmf : Y_PSF_SIG +gpsfMajorFWHM + cmf : PSF_FWHM_MAJ +gpsfMinorFWHM + cmf : PSF_FWHM_MIN +gpsfTheta + cmf : PSF_THETA +gpsfCore + cmf : PSF_CORE +gpsfLikelihood - cmf : psfLikelihood(EXT_NSIGMA) ** problem with calculation? plot +gpsfQf + cmf : PSF_QF +gpsfQfPerfect + cmf : PSF_QF_PERFECT +gpsfChiSq + cmf : PSF_CHISQ / PSF_NDOF +gmomentXX + cmf : MOMENTS_XX +gmomentXY + cmf : MOMENTS_XY +gmomentYY + cmf : MOMENTS_YY +gmomentR1 + cmf : MOMENTS_R1 +gmomentRH + cmf : MOMENTS_RH +gPSFFlux + cmf : PSF_INST_FLUX / exptime +gPSFFluxErr + cmf : PSF_INST_FLUX_SIG / exptime +gApFlux + cmf : AP_FLUX / exptime +gApFluxErr + cmf : AP_FLUX_SIG / exptime +gApFillFac + cmf : AP_NPIX / (3.14159265359 * POW(b.AP_MAG_RADIUS - 0.5, 2)) ** adjusted formula, re-check +gApRadius + cmf : AP_MAG_RADIUS +gKronFlux + cmf : KRON_FLUX / exptime +gKronFluxErr + cmf : KRON_FLUX_ERR / exptime +gKronRad + cmf : MOMENTS_R1 * 2.5 +gexpTime + cmf : header EXPTIME +gExtNsigma + cmg : EXT_NSIGMA +gzp + dvo : zp ** clarify in dvopsps +gPlateScale + cmf : PLTSCALE Index: /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectThin =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectThin (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectThin (revision 38088) @@ -0,0 +1,40 @@ + +objID dimensionless BIGINT 8 NA ODM object identifier +uniquePspsSTid dimensionless BIGINT 8 NA unique identifier provided by ipptopsps +ippObjID dimensionless BIGINT 8 NA object ID generated by IPP [this is a per-object, not per-filter value] +surveyID dimensionless TINYINT 1 NA survey flag identifier +tessID dimensionless TINYINT 1 -1 ID mapping to tessellation names (eg, RINGS.V3, MD01.V3, etc) +projectionID dimensionless SMALLINT 2 -999 valid values 0 - < 10000 +skyCellID dimensionless TINYINT 1 255 valid values 0 - 143 (12x12 grid) +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 INT 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) +------------------------------------------------------------------------------------------ +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 +------------------------------------------------------------------------------------------ +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?) +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 INT 4 0 informational bits +ginfoFlag2 dimensionless INT 4 0 informational bits +gnFrames dimensionless INT 4 -999 Number of frames contributing to source + +-- [220 byte/filter/obj + 44 byte/obj] Index: /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectThin.txt =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectThin.txt (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectThin.txt (revision 38088) @@ -0,0 +1,40 @@ + +-- fields marked with + below have been verified by EAM in the ippToPsps output mysql tables + +objID + dvo = average.extID [calculated in addstar] +uniquePspsSTid = ipptopsps +ippObjID + dvo = average.objID + (average.catID << 32) [NOTE: this is a change in definition] +surveyID + ipptopsps : internal, from survey name +tessID + smf : TESS_ID (table mapping) +projectionID + smf : parse SKYCELL (skycell.NNN or skycell.MMMM.NNN) +skycellID + smf : parse SKYCELL (skycell.NNN or skycell.MMMM.NNN) +randomStackObjID + ipptopsps (RANDOM on sql into mysql) +stackDetectRowID - set by PSPS +primaryDetection + (dvo:measure.dbFlags >> 16) +bestDetection - dvo * THIS CANNOT BE SET UNTIL LATER (after PV3 initial ingest to psps) + +dvoRegionID + dvo = measure.catID +dataRelease + ippToPsps : user input (skychunk.dataRelease) +-- +-- +-- +-- +gippDetectID + dvopsps.ippDetectID = dvo:measure.detID = smf / IPP_IDET +gstackDetectID + dvopsps.detectID = dvo:measure.extID [calculated in addstar: psps stack detect ID] +gstackMetaID + ipptopsps : gpc1 db, matches cmf IMAGEID +-- +gra + dvo = measure.ra +gdec + dvo = measure.dec +graErr + dvo = X_PSF_SIG * PLTSCALE +gdecErr + dvo = X_PSF_SIG * PLTSCALE +gPSFMag + dvo = measure.Mpsf +gPSFMagErr + dvo = measure.dMpsf +gApMag + dvo = measure.Map +gApMagErr + dvo = measure.dMap +gKronMag + dvo = measure.Mkron +gKronMagErr + dvo = measure.dMkron +gsky + smf : SKY / exptime +gskyErr + smf : SKY_SIGMA / exptime +ginfoFlag + smf : FLAGS +ginfoFlag2 - smf + dvo : FLAGS2 | measure.flags << 13 *** we only include measure.dbflags, not secfilt.flags +gnFrames + smf : N_FRAMES Index: /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackPetrosian =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackPetrosian (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackPetrosian (revision 38088) @@ -0,0 +1,23 @@ + +objID dimensionless BIGINT 8 NA ODM object identifier +uniquePspsSTid dimensionless BIGINT 8 NA unique identifier provided by ipptopsps +ippbjID dimensionless BIGINT 8 NA object ID generated by IPP +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. +-------------------------------------------------------- replicate below for all filters (grizy) +gippDetectID dimensionless BIGINT 8 NA ipp detect identifier +gstackDetectID dimensionless BIGINT 8 NA ODM detection identifier +gstackMetaID dimensionless BIGINT 8 NA stack identifier +---------------------------------------------------------------------------------------- +gpetRadius arcsec REAL 4 -999 Petrosian radius +gpetRadiusErr arcsec REAL 4 -999 estimated error inPetrosian radius +gpetMag AB_mag REAL 4 -999 Petrosian Flux +gpetMagErr AB_mag REAL 4 -999 estimated error in petFlux +gpetR50 arcsec REAL 4 -999 Petrosian radius at 50% light +gpetR50Err arcsec REAL 4 -999 estimated error inPetrosian radius at 50% light +gpetR90 arcsec REAL 4 -999 Petrosian radius at 90% light +gpetR90Err arcsec REAL 4 -999 estimated error in Petrosian radius at 90% light +gpetCf dimensionless REAL 4 -999 Petrosian fit coverage factor Index: /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackPetrosian.txt =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackPetrosian.txt (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackPetrosian.txt (revision 38088) @@ -0,0 +1,23 @@ + +objID + from StackObjectThin +uniquePspsSTid = ipptopsps +ippobjID + from StackObjectThin +randomStackObjID + from StackObjectThin +stackDetectRowID - PSPS +primaryDetection - from StackObjectThin NOT YET TESTED +bestDetection - from StackObjectThin CANNOT BE SET until after PV3 +-- +---------------- +gippDetectID + from StackObjectThin +gstackDetectID + from StackObjectThin +gstackMetaID + from StackObjectThin +---------------- +gpetRadius + cmf : PETRO_RADIUS +gpetRadiusErr + cmf : PETRO_RADIUS_ERR +gpetMag + cmf : PETRO_MAG - header:FPA.ZP + dvo.zp +gpetMagErr + cmf : PETRO_MAG_ERR +gpetR50 + cmf : PETRO_RADIUS_50 +gpetR50Err + cmf : PETRO_RADIUS_50_ERR +gpetR90 + cmf : PETRO_RADIUS_90 +gpetR90Err + cmf : PETRO_RADIUS_90_ERR +gpetCf - cmf : PETRO_FILL ** consistently > 1.0?? [problem in cmf] Index: /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/changes.r36847 =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/changes.r36847 (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/changes.r36847 (revision 38088) @@ -0,0 +1,199 @@ +Index: Detection +=================================================================== +--- Detection (revision 36838) ++++ Detection (working copy) +@@ -7,7 +7,7 @@ + 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 ++dvoRegionID dimensionless INT 4 0 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 +@@ -53,7 +53,8 @@ + 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 ++infoFlag dimensionless INT 4 -999 flag indicating provenance information ++infoFlag2 dimensionless INT 4 -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: StackApFlx +=================================================================== +--- StackApFlx (revision 36838) ++++ StackApFlx (working copy) +@@ -1,6 +1,7 @@ + + objID dimensionless BIGINT 8 NA ODM object identifier + gcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier ++ippObjID dimensionless BIGINT 8 NA ipp object 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 +@@ -8,13 +9,12 @@ + 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 ++dvoRegionID dimensionless INT 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 ++gippDetectID dimensionless BIGINT 8 NA stack identifier + 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 +Index: ForcedWarpMeasurement +=================================================================== +--- ForcedWarpMeasurement (revision 36838) ++++ ForcedWarpMeasurement (working copy) +@@ -8,7 +8,7 @@ + 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 ++dvoRegionID dimensionless INT 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 +Index: DiffDetection +=================================================================== +--- DiffDetection (revision 36838) ++++ DiffDetection (working copy) +@@ -1,3 +1,4 @@ ++ + 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 +@@ -8,7 +9,7 @@ + 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 ++dvoRegionID dimensionless INT 4 0 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 +@@ -65,5 +66,6 @@ + ------------------------------------------------------- + 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 ++infoFlag dimensionless INT 4 -999 flag indicating provenance information ++infoFlag2 dimensionless INT 4 -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: ObjectThin +=================================================================== +--- ObjectThin (revision 36838) ++++ ObjectThin (working copy) +@@ -9,7 +9,7 @@ + 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 ++dvoRegionID dimensionless INT 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 +Index: StackModelFit +=================================================================== +--- StackModelFit (revision 36838) ++++ StackModelFit (working copy) +@@ -1,6 +1,7 @@ + + objID dimensionless BIGINT 8 NA ODM object identifier + gcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier ++ippObjID dimensionless BIGINT 8 NA ipp object 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 +@@ -8,17 +9,17 @@ + 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 ++dvoRegionID dimensionless INT 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) ++gippDetectID dimensionless BIGINT 8 NA ipp detect identifier + 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 +Index: ForcedMeanObject +=================================================================== +--- ForcedMeanObject (revision 36838) ++++ ForcedMeanObject (working copy) +@@ -1,3 +1,4 @@ ++ + 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 +Index: DiffDetObject +=================================================================== +--- DiffDetObject (revision 36838) ++++ DiffDetObject (working copy) +@@ -9,7 +9,7 @@ + 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 ++dvoRegionID dimensionless INT 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 +Index: StackObject +=================================================================== +--- StackObject (revision 36838) ++++ StackObject (working copy) +@@ -1,6 +1,7 @@ + + objID dimensionless BIGINT 8 NA ODM object identifier + gcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier ++ippObjID dimensionless BIGINT 8 NA object ID generated by IPP + 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 +@@ -8,16 +9,16 @@ + 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 ++dvoRegionID dimensionless INT 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 +@@ -57,7 +58,8 @@ + 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 ++ginfoFlag dimensionless INT 4 -999 indicator of strange propeties ++ginfoFlag2 dimensionless INT 4 -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/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/notes.txt =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/notes.txt (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/notes.txt (revision 38088) @@ -0,0 +1,22 @@ + +tables processed by the different batch types: + +objectbatch.py: + ObjectThin + MeanObject + +detectionbatch.py: + Detection + +stackbatch.py: + StackObjectThin - populated for all stack detections * checked + StackObjectRaw - populated for all stack detections * checked + StackModelFitThin - populated for Galactic Cap regions + StackModelFitDeV - populated for Galactic Cap regions * checked + StackModelFitExp - populated for Galactic Cap regions * checked + StackModelFitSer - populated for Galactic Cap regions * checked + StackApFlx - populated for all stack detections + StackApFlxFull - populated for Galactic Cap regions * checked + StackApFlxFullC1 - populated for Galactic Cap regions * checked + StackApFlxFullC2 - populated for Galactic Cap regions * checked + StackPetrosian - populated for Galactic Cap regions * checked Index: /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/schema18.notes.txt =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/schema18.notes.txt (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/schema18.notes.txt (revision 38088) @@ -0,0 +1,160 @@ + +This document describes the new PSPS schema (18.0) and identifies existing problems. + +ObjectThin + + Changes since Schema 16.0: + + * DROPPED gcObjID (concept rejected by DRAVG) + * replaced skycellID (REAL) with combination of tessID, projectionID, skycellID (1,2,1 byte INTs) + * replaced raMeanStd, decMeanStd (not calculated) with posMeanChisq + + Concerns: + + * objName is generated by SQL in ippToPsps and is probably fragile: move to dvopsps? + * fields calculated by PSPS and not tested (htmID, zoneID, cx,cy,cz, lambda,beta, l,b) + * nStackObjectRows is not calculated + * should nStackDetections be split per filter? + * quality flag is currently the upper byte of dvo:average.flags, is this reasonable? + * consistency flag is hard-wired as 0 + * raStack, etc are not yet calculated by relastro (set to match raMean, etc) + +MeanObject + + Changes since Schema 16.0: + + * DROPPED gcObjID (concept rejected by DRAVG) + * CHANGED gFlags to be 4 byte not 8 byte (secfilt.flags is 4 byte) + * renamed fields to have consistent naming structure: + * gMeanTYPEMagVALUE, where TYPE = (PSF, Kron, Ap) and VALUE = (Err, Std, Min Max, Npt) + + Concerns: + + * NONE + +Detections + + Changes since Schema 16.0: + + * ADDED apRadius + * DROPPED gcObjID (concept rejected by DRAVG) + * DROPPED kronRadErr (not measured by psphot, probably not needed?) + + Concerns: + + * imageID : this is currently generated from expID + ccd X,Y. + shouldn't we use gpc1.chipImfile.chip_imfile_id? (IMAGE_ID in + header) + * double-check reported value for zero point (needs to include airmass term, etc) + + Implementation Changes: + + * raErr,decErr are now taken from the SMF file not from dvo (x,y errors truncated in dvo) + * dvoRegion now uses CAT_ID from dvopsps + * psfMajor,MinorFWHM use PSF_FWHM_MJA,MIN + * added PSF_CORE to smf + * apFlux, kronFlux use FLUX values directly from smf + +Stacks + + Measurements related to the stacks are now split into 11 separate + tables depending on the measurements and, in some cases, the Galactic + latitude. The granularity of the split is partly mandated by the + inability of PSPS or its ingest system to handle excessively wide + tables. Note that in all of the tables below, a single row represents + the set of measurements from all 5 filters (grizy) for the aparition + of an astronomical object in a single skycell. The primaryDetection + flag is set to identify the row which comes from the primary skycell + for that location on the sky. + + Several of the tables are meant to be filled only for the Galactic cap + regions. As of 2014.08.09, ippToPsps is not setting this limit. + These tables are: + + StackModelFitDeV + StackModelFitExp + StackModelFitSer + StackModelFitExtra + StackApFlxFull + StackApFlxFullC1 + StackApFlxFullC2 + StackPetrosian + + Other general concerns: + + * various size-related fields are reported in pixels not arcseconds. + + * I need to double-check the reported zero point and telluric + extinction values. + + * are we defining too many radial apertures? + + The tables are divided as follows: + + StackObjectThin : basic properties of the stack object detection. + * stackDetectRowID : this field will be set by PSPS and cannot be + tested in the ippToPsps code + + * bestDetection : this field cannot be set until the entire PSPS is + populated. this will be deferred until the end of + the ingest. + + * primaryDetection : NOT YET TESTED + * xinfoFlag2 : currently only includes bits from + dvo:measure.dbflags but not dvo:secfilt.flags + + * NOTE : stackDetectRowID, bestDetection, primaryDetection are + inherited by the following tables from StackObjectThin, so the issue + above are present in all Stack tables + + StackObjectRaw : raw measurement values from the PSF fits + * xpsfLikelihood : some values seem to be negative, which should + not be allowed + + StackModelFitExtra : extra properties derived from extended source + fits. NOTE: this table is not being generated + + StackModelFitExp : Exponential model fit parameters + * xExpRadiusErr : EXT_WIDTH_MAJ_SIG is not being set in the CMF file + * xExpAbErr : EXT_WIDTH_MIN_SIG is not being set in the CMF file + * xExpPhiErr : not set in CMF + * xExpRa,Dec : this position is currently an approximation based on + X_EXT, X_PSF and the plate scale + * xExpRa,DecErr : circularly symmetric approximation based on S/N + * xExpCf : not calculated in psphot + * xExpChisq : the fit chisq is provided, not the likelihood + + StackModelFitDeV : DeVaucouleur model fit parameters + * NOTE same issues as for Exp + + StackModelFitSer : Sersic model fit parameters + * NOTE same issues as for Exp, also: + * xSerNuErr : value is hard-wired at 0.1, and not well-measured + in CMF + + StackApFlx : flux measured in radial apertures (only 3 radii; raw and + both convolutions) + + * standard deviation fields (eg, gflxR3Std) are measured in psphot as + the standard deviation across the full object. Should this perhaps + be a measurement of the standard deviation after the radial profile + is subtracted? + + StackApFlxFull : flux measured in radial apertures (raw, all radii) + + * see note above on Standard Deviation + * radius 10 is not measured or reported in the CMF + + StackApFlxFullC1 : flux measured in radial apertures (first convolution, all radii) + + * see note above on Standard Deviation + * radius 10 is not measured or reported in the CMF + + StackApFlxFullC2 : flux measured in radial apertures (second convolution, all radii) + + * see note above on Standard Deviation + * radius 10 is not measured or reported in the CMF + + StackPetrosian : petrosian analysis data + * xpetCf : fill factor is mis-calculated in psphot (consistently > 1.0) + * NOTE that PETRO_MAG_ERR is inverted in pmSourceIO_CMF.c.in r37244 Index: /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/CameraConfig =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/CameraConfig (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/CameraConfig (revision 38088) @@ -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/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/DetectionFlags =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/DetectionFlags (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/DetectionFlags (revision 38088) @@ -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/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/DiffMeta =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/DiffMeta (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/DiffMeta (revision 38088) @@ -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 alphanumeric VARCHAR(100) 100 -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/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/DiffToImage =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/DiffToImage (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/DiffToImage (revision 38088) @@ -0,0 +1,2 @@ +diffMetaID BIGINT 8 NA diff identifier +imageID BIGINT 8 NA hashed exposure-ccdID identifier Index: /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/Filter =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/Filter (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/Filter (revision 38088) @@ -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/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/FitModel =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/FitModel (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/FitModel (revision 38088) @@ -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/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/ForcedWarpMeta =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/ForcedWarpMeta (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/ForcedWarpMeta (revision 38088) @@ -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/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/ForcedWarpToImage =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/ForcedWarpToImage (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/ForcedWarpToImage (revision 38088) @@ -0,0 +1,2 @@ +forcedWarpID BIGINT 8 NA forced warp identifier +imageID BIGINT 8 NA hashed exposure-ccdID identifier Index: /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/FrameMeta =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/FrameMeta (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/FrameMeta (revision 38088) @@ -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 NA IPP software analysis release +p1Recip alphanumeric VARCHAR(MAX) 8000 NA IPP phase 1 MD5 Checksum +p2Recip alphanumeric VARCHAR(MAX) 8000 NA IPP phase 2 MD5 Checksum +p3Recip alphanumeric VARCHAR(MAX) 8000 NA 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 NA name of astrometric projection in RA +ctype2 alphanumeric VARCHAR(MAX) 8000 NA 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 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/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/FrameMeta.txt =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/FrameMeta.txt (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/FrameMeta.txt (revision 38088) @@ -0,0 +1,50 @@ +frameID | ipptopsps : gpc1.rawExp.exp_id +frameName | ipptopsps : gpc1.rawExp.exp_name +surveyID | ipptopsps : internal, from survey name +filterID | ipptopsps : internal, lookup from filter (grizy) +cameraID | ipptopsps : hardwired to 1 *** +cameraConfigID | ipptopsps : hardwired to 1 *** +telescopeID | ipptopsps : hardwired to 1 *** +analysisVer | ipptopsps : gpc1.camRun.software_ver +p1Recip | * NOT SET +p2Recip | * NOT SET +p3Recip | * NOT SET +nOTA | ipptopsps : count of OTAs +photoScat | cmf: ZPT_ERR +numPhotoRef | sum(cmf:NASTRO) +expStart | cmf:MJD-OBS +expTime | cmf:EXPREQ +airmass | cmf:AIRMASS +raBore | cmf:RA +decBore | cmf:DEC +ctype1 | cmf:CTYPE1 +ctype2 | cmf:CTYPE2 +crval1 | cmf:CRVAL1 +crval2 | cmf:CRVAL2 +crpix1 | cmf:CRPIX1 +crpix2 | cmf:CRPIX2 +cdelt1 | cmf:CDELT1 +cdelt2 | cmf:CDELT2 +pc001001 | cmf:PC001001 +pc001002 | cmf:PC001002 +pc002001 | cmf:PC002001 +pc002002 | cmf:PC002002 +polyOrder | cmf:NPLYTERM +pca1x3y0 | cmf:PCA1X3Y0 +pca1x2y1 | cmf:PCA1X2Y1 +pca1x1y2 | cmf:PCA1X1Y2 +pca1x0y3 | cmf:PCA1X0Y3 +pca1x2y0 | cmf:PCA1X2Y0 +pca1x1y1 | cmf:PCA1X1Y1 +pca1x0y2 | cmf:PCA1X0Y2 +pca2x3y0 | cmf:PCA2X3Y0 +pca2x2y1 | cmf:PCA2X2Y1 +pca2x1y2 | cmf:PCA2X1Y2 +pca2x0y3 | cmf:PCA2X0Y3 +pca2x2y0 | cmf:PCA2X2Y0 +pca2x1y1 | cmf:PCA2X1Y1 +pca2x0y2 | cmf:PCA2X0Y2 +calibModNum | ipptopsps: hardwired to 0 *** +batchID | ipptopsps: internal +dataRelease | ipptopsps: user input (skychunk.dataRelease) + Index: /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/ImageFlags =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/ImageFlags (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/ImageFlags (revision 38088) @@ -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/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/ImageMeta =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/ImageMeta (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/ImageMeta (revision 38088) @@ -0,0 +1,71 @@ +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 +momentMajor pixels REAL 4 -999 momentMajor +momentMinor pixels REAL 4 -999 momentMinor +momentM2C pixels squared REAL 4 -999 momentM2C +momentM2S pixels squared REAL 4 -999 momentM2S +momentM3 pixels squared REAL 4 -999 momentM3 +momentM4 pixels squared REAL 4 -999 momentM4 +apResid magnitude REAL 4 -999 corrected aperture residual +dapResid magnitude 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/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/ImageMeta.txt =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/ImageMeta.txt (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/ImageMeta.txt (revision 38088) @@ -0,0 +1,71 @@ +imageID | ipptopsps : expID x y (*** is this right???) (smf:IMAGEID / gpc1.chipRun.chip_image_id)_ +frameID | ipptopsps : gpc1.rawExp.exp_id +ccdID | ipptopsps : from XYnn +photoCalID | dvo:photcode (from photcode table) +filterID | ipptopsps : internal, lookup from filter (grizy) +bias | gpc1.rawExp.bg *** WRONG! +biasScat | gpc1.rawExp.bg_stdev *** WRONG! +sky | MSKY_MN +skyScat | MSKY_SIG +nDetect | ipptopsps : rows(Detection table) +magSat | FSATUR +completMag | FLIMIT +astroScat | CERROR +photoScat | ZPT_OBS ** wrong +numAstroRef | NASTRO +numPhotoRef | NASTRO +nx | CNAXIS1 +ny | CNAXIS2 +psfModelID | ** NOT SET +psfFwhm | 0.5*(FWHM_MAJ + FWHM_MIN) +psfWidMajor | FWHM_MAJ +psfWidMinor | FWHM_MIN +psfTheta | ANGLE +momentMajor | IQ_FW1 +momentMinor | IQ_FW1 +momentM2C | IQ_M2C +momentM2S | IQ_M2S +momentM3 | IQ_M3 +momentM4 | IQ_M4 +apResid | APMIFIT +dapResid | DAPMIFIT +detectorID | DETECTOR +qaFlags | dvo:image.flags +detrend1 | DETREND.MASK +detrend2 | DETREND.DARK +detrend3 | DETREND.FLAT +detrend4 | ** NOT SET +detrend5 | ** NOT SET +detrend6 | ** NOT SET +detrend7 | ** NOT SET +detrend8 | ** NOT SET +photoZero | ZPT_OBS +ctype1 | CTYPE1 +ctype2 | CTYPE2 +crval1 | CRVAL1') +crval2 | CRVAL2') +crpix1 | CRPIX1') +crpix2 | CRPIX2') +cdelt1 | CDELT1') +cdelt2 | CDELT2') +pc001001 | PC001001 +pc001002 | PC001002 +pc002001 | PC002001 +pc002002 | PC002002 +polyOrder | NPLYTERM +pca1x2y0 | PCA1X2Y0 +pca1x1y1 | PCA1X1Y1 +pca1x0y2 | PCA1X0Y2 +pca2x2y0 | PCA2X2Y0 +pca2x1y1 | PCA2X1Y1 +pca2x0y2 | PCA2X0Y2 +pca1x3y0 | PCA1X3Y0 +pca1x2y1 | PCA1X2Y1 +pca1x1y2 | PCA1X1Y2 +pca1x0y3 | PCA1X0Y3 +pca2x3y0 | PCA2X3Y0 +pca2x2y1 | PCA2X2Y1 +pca2x1y2 | PCA2X1Y2 +pca2x0y3 | PCA2X0Y3 +calibModNum | ipptopsps: hardwired to 0 *** +dataRelease | ipptopsps: user input (skychunk.dataRelease) Index: /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/Mask =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/Mask (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/Mask (revision 38088) @@ -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/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/MovingObjToDet =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/MovingObjToDet (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/MovingObjToDet (revision 38088) @@ -0,0 +1,2 @@ +MovingObjID BIGINT 8 NA Moving Object identifier +DetectionID BIGINT 8 NA detection identifier Index: /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/MovingObjToDiffDet =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/MovingObjToDiffDet (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/MovingObjToDiffDet (revision 38088) @@ -0,0 +1,2 @@ +MovingObjID BIGINT 8 NA Moving Object identifier +DiffDetID BIGINT 8 NA difference image detection identifier Index: /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/MovingObjToObject =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/MovingObjToObject (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/MovingObjToObject (revision 38088) @@ -0,0 +1,2 @@ +MovingObjID BIGINT 8 NA Moving Object identifier +ObjID BIGINT 8 NA Object identifier Index: /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/ObjectFilterFlags =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/ObjectFilterFlags (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/ObjectFilterFlags (revision 38088) @@ -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/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/ObjectInfoFlags =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/ObjectInfoFlags (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/ObjectInfoFlags (revision 38088) @@ -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/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/ObjectQualityFlags =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/ObjectQualityFlags (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/ObjectQualityFlags (revision 38088) @@ -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/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/PhotoCal =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/PhotoCal (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/PhotoCal (revision 38088) @@ -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/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/ProjectionCell =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/ProjectionCell (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/ProjectionCell (revision 38088) @@ -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/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/PsConstant =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/PsConstant (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/PsConstant (revision 38088) @@ -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/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/Region =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/Region (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/Region (revision 38088) @@ -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/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/RegionPatch =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/RegionPatch (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/RegionPatch (revision 38088) @@ -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/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/SkyCell =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/SkyCell (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/SkyCell (revision 38088) @@ -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/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/StackDetectionFlags =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/StackDetectionFlags (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/StackDetectionFlags (revision 38088) @@ -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/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/StackMeta =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/StackMeta (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/StackMeta (revision 38088) @@ -0,0 +1,37 @@ +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 filter number identifier +stackTypeID dimensionless TINYINT 1 0 stack type identifier +tessID dimensionless TINYINT 1 -1 ID mapping to tessellation names (eg, RINGS.V3, MD01.V3, etc) +projectionID dimensionless SMALLINT 2 -999 valid values 0 - < 10000 +skyCellID dimensionless TINYINT 1 255 valid values 0 - 143 (12x12 grid) +photoCalID dimensionless INT 4 NA photometry code +magSat dimensionless REAL 4 -999 saturation magnitude level +analysisVer dimensionless INT 4 -999 analysis version index x +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 +nPhotomRef 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/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/StackMeta.txt =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/StackMeta.txt (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/StackMeta.txt (revision 38088) @@ -0,0 +1,37 @@ +stackMetaID | ipptopsps : gpc1 db, matches cmf IMAGEID +batchID | ipptopsps : internal +surveyID | ipptopsps : internal, from survey name +filterID | ipptopsps : internal, lookup from filter (grizy) +stackTypeID | ipptopsps : internal, *** hard-wired name *** +tessID | smf : TESS_ID (table mapping) +projectionID | smf : parse SKYCELL (skycell.NNN or skycell.MMMM.NNN) +skycellID | smf : parse SKYCELL (skycell.NNN or skycell.MMMM.NNN) +photoCalID | dvo.images : photcode +magSat | * NOT SET +analysisVer | gpc1.stackRun.software_ver [EAM: changed this name] +expTime | cmf header EXPTIME +nP2Images | [populateStackToImage] : counts inputs NOTE is this set reasonable? +completMag | * NOT SET +astroScat | * NOT SET +photoScat | * NOT SET +nAstroRef | * NOT SET +nPhotomRef | * NOT SET +psfModelID | cmf header PSFMODEL +psfFwhm_mean | cmf header FWHM_MAJ *** probably wrong value +psfFwhm_max | cmf header FW_MJ_UW *** name and definition are inconsistent +photoZero | cmf header FPA.ZP *** this is not dvo corrected) +photoColor | * NOT SET +ctype1 | cmf header +ctype2 | cmf header +crval1 | cmf header +crval2 | cmf header +crpix1 | cmf header +crpix2 | cmf header +cdelt1 | cmf header +cdelt2 | cmf header +pc001001 | cmf header +pc001002 | cmf header +pc002001 | cmf header +pc002002 | cmf header +calibModNum | * NOT SET +dataRelease | ipptopsps : user input (skychunk.dataRelease) Index: /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/StackToImage =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/StackToImage (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/StackToImage (revision 38088) @@ -0,0 +1,2 @@ +stackMetaID BIGINT 8 NA stack identifier +imageID BIGINT 8 NA hashed exposure-ccdID identifier Index: /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/StackType =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/StackType (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/StackType (revision 38088) @@ -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/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/Survey =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/Survey (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/Survey (revision 38088) @@ -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/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/TelescopeConfig =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/TelescopeConfig (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/TelescopeConfig (revision 38088) @@ -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/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/TessellationType =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/TessellationType (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/TessellationType (revision 38088) @@ -0,0 +1,3 @@ +tessID TINYINT 1 -999 stack type identifier +name VARCHAR(20) 20 NULL stack type name +description VARCHAR(MAX) 8000 NULL stack type description Index: /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/pcsGalaxyModel =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/pcsGalaxyModel (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/pcsGalaxyModel (revision 38088) @@ -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/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/pcsPhotoZRecipe =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/pcsPhotoZRecipe (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/pcsPhotoZRecipe (revision 38088) @@ -0,0 +1,2 @@ +photozRecipeID dimensionless TINYINT 1 -999 recipe index +description dimensionless VARCHAR(MAX) 8000 string\ describing\ the\ recipe Index: /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/pcsSGSepRecipe =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/pcsSGSepRecipe (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/pcsSGSepRecipe (revision 38088) @@ -0,0 +1,2 @@ +sgSepRecipeID dimensionless INT 4 NA Star/Galaxy Seperator Recuipe ID +description dimensionless VARCHAR(128) 128 Description Index: /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/pcsStarModel =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/pcsStarModel (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/pcsStarModel (revision 38088) @@ -0,0 +1,2 @@ +starModelID dimensionless INT 4 -999 modelID +description dimensionless VARCHAR(128) 128 model description, spectral type etc Index: /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/pcsStellarParamsRecipe =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/pcsStellarParamsRecipe (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/MetaData_Tables/pcsStellarParamsRecipe (revision 38088) @@ -0,0 +1,3 @@ +stellarParamsRecipeID dimensionless INT 4 NA Na +description dimensionless VARCHAR(128) 128 Description:wq + Index: /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_VIEWS/README =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_VIEWS/README (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_VIEWS/README (revision 38088) @@ -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/SchemaNew20.0/PSPS_VIEWS/Views =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_VIEWS/Views (revision 38088) +++ /trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_VIEWS/Views (revision 38088) @@ -0,0 +1,28 @@ +PSPS VIEWS - examples (not complete, please suggest others) + +*note: drop batchID it is not needed + +MeanObjectView = ObjectThin join MeanObject +StackObjectView = ObjectThin join StackObjectThin join StackObjectAttributes +StackApFlxObjectView = ObjectThin join StackApFlx +StackApFlxExGalUncObjectView = ObjectThin join StackApFlxExGalUnc +StackApFlxExGalCon6ObjectView = ObjectThin join StackApFlxExGalCon6 +StackApFlxExGalCon8ObjectView = ObjectThin join StackApFlxExGalCon8 +StackModelObjectView = ObjectThin join StackModelFitExp join StackModelFitDeV join StackModelFitSer join StackPetrosian +StackModelFitExpObjectView = ObjectThin join StackModelFitExp +StackModelFitDeVObjectView = ObjectThin join StackModelFitDeV +StackModelFitSerObjectView = ObjectThin join StackModelFitSer +StackModelFitPetObjectView = ObjectThin join StackPetrosian +StackObjectPrimaryView = ObjectThin join StackObjectThin join StackObjectAttributes join StackApFlx where primaryDection is true +* StackObjectBestView = ObjectThin join StackObject join StackObjectAttributes join StackApFlx where bestDetection is true +ForcedMeanObjectView = ObjectThin join ForcedMeanObject +DetectionObjectView = ObjectThin join MeanObject join Detection +DiffDetObjectView = DiffDetObject join DiffDetection +ForcedDetObjectView = ObjectThin join ForcedWarpDetection + + +*note1: StackObjectBestView - skip - we don't currently set bestDetection +*note2: drop batchID it is not needed + + +