Index: trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/Detection =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/Detection (revision 36846) +++ trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/Detection (revision 36847) @@ -8,5 +8,5 @@ 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 @@ -54,5 +54,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: trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/DiffDetObject =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/DiffDetObject (revision 36846) +++ trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/DiffDetObject (revision 36847) @@ -2,5 +2,5 @@ diffObjName string VAR 8 NA IAU Name constructed from objID postion PS1.x JHHMMSS.SS+/-DDMMSS.S x procesing version diffObjID dimensionless BIGINT 8 NA ODM object identifier index -diffgcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier +diffgcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier ippObjID dimensionless BIGINT 8 NA IPP object number surveyID dimensionless TINYINT 1 255 Survey ID @@ -10,5 +10,5 @@ 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 Index: trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/DiffDetection =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/DiffDetection (revision 36846) +++ trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/DiffDetection (revision 36847) @@ -1,4 +1,5 @@ + diffObjID dimensionless BIGINT 8 NA diff object identifier -diffgcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier +diffgcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier diffDetID dimensionless BIGINT 8 NA diff detection identifier diffDetMetaID dimensionless BIGINT 8 NA diff detection meta identifier @@ -9,5 +10,5 @@ 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 @@ -66,4 +67,5 @@ 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: trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedMeanObject =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedMeanObject (revision 36846) +++ trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedMeanObject (revision 36847) @@ -1,4 +1,5 @@ + objID dimensionless BIGINT 8 NA ODM object identifier index -gcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier +gcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier ippObjID dimensionless BIGINT 8 NA IPP object identifier nDetections dimensionless SMALLINT 2 -999 total number of detection measurements in all filters Index: trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpMeasurement =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpMeasurement (revision 36846) +++ trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpMeasurement (revision 36847) @@ -1,4 +1,4 @@ objID dimensionless BIGINT 8 NA ODM object identifier -gcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier +gcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier detectID dimensionless BIGINT 8 NA ODM detection identifier ippObjID dimensionless BIGINT 8 NA ippobject id generated by IPP @@ -9,5 +9,5 @@ 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 ------------------------------------------------------ Index: trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/MeanObject =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/MeanObject (revision 36846) +++ trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/MeanObject (revision 36847) @@ -4,5 +4,5 @@ objID dimensionless BIGINT 8 NA ODM object identifier index -gcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier +gcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier gQfPerfect dimensionless REAL 4 -999 maximum psf qfPerfect from best available g band detections gMeanPSFMag AB magnitude REAL 4 -999 mean g psf AB magnitude from best available measurements (best available as current defined by ipp "waterfall logic" Index: trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ObjectThin =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ObjectThin (revision 36846) +++ trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ObjectThin (revision 36847) @@ -10,5 +10,5 @@ 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 Index: trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlx =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlx (revision 36846) +++ trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlx (revision 36847) @@ -1,5 +1,6 @@ objID dimensionless BIGINT 8 NA ODM object identifier -gcObjID dimensionless BIGINT 8 NA ODM galactic coordinates 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 @@ -9,11 +10,10 @@ 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 Index: trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFit =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFit (revision 36846) +++ trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFit (revision 36847) @@ -1,5 +1,6 @@ objID dimensionless BIGINT 8 NA ODM object identifier -gcObjID dimensionless BIGINT 8 NA ODM galactic coordinates 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 @@ -9,5 +10,5 @@ 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) @@ -16,8 +17,8 @@ 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 Index: trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObject =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObject (revision 36846) +++ trunk/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObject (revision 36847) @@ -1,5 +1,6 @@ objID dimensionless BIGINT 8 NA ODM object identifier -gcObjID dimensionless BIGINT 8 NA ODM galactic coordinates 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 @@ -9,5 +10,5 @@ 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. ------------------------------------------------------------------------------------------ @@ -15,8 +16,8 @@ -- 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 @@ -58,5 +59,6 @@ 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