Index: unk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Derived_Data_Product_Tables/stargal =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Derived_Data_Product_Tables/stargal (revision 37733) +++ (revision ) @@ -1,17 +1,0 @@ - - -Name Unit Data Type Size Default Value Description - -objID dimensionless BIGINT 8 NA ODM object identifier index -ippObjID dimensionless BIGINT 8 NA IPP object number -StarProb1 fraction FLOAT 8 -999 fractional probability object is a star, Recipe 1 -GalProb1 fraction FLOAT 8 -999 fractional probability object is a galaxy, Recipe 1 -StarProb2 fraction FLOAT 8 -999 fractional probability object is a star, Recipe 2 -GalProb2 fraction FLOAT 8 -999 fractional probability object is a galaxy, Recipe 2 -StarProb3 fraction FLOAT 8 -999 fractional probability object is a star, Recipe 3 -GalProb3 fraction FLOAT 8 -999 fractional probability object is a galaxy, Recipe 3 - - -comment - may come from different combinations of ipp parameters, model fit as function of magnitude, -or Support Vector Machine result. - Index: /trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/Detection =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/Detection (revision 37733) +++ /trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/Detection (revision 37734) @@ -21,5 +21,5 @@ raErr arcsec REAL 4 NA Right Ascension error decErr arcsec REAL 4 NA Declination error -extNSigma unkown REAL 4 -999 measure of extendedness +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 @@ -41,5 +41,5 @@ momentYY arcsec^2 REAL 4 -999 momeny YY momentR1 arcsec REAL 4 -999 first radial moment -momentRH arcsec REAL 4 -999 half light radius (REMOVE THIS) +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) Index: /trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/DiffDetection =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/DiffDetection (revision 37733) +++ /trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/DiffDetection (revision 37734) @@ -42,5 +42,5 @@ momentYY arcsec^2 REAL 4 -999 momeny YY momentR1 arcsec REAL 4 -999 first radial moment -momentRH arcsec REAL 4 -999 half light radius (DROP) +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) Index: /trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectAttributes =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectAttributes (revision 37733) +++ /trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectAttributes (revision 37734) @@ -39,5 +39,5 @@ gKronRad arcsec REAL 4 -999 Kron radius gexpTime seconds REAL 4 -999 total exposure time (informational) -gExtNSigma unknown REAL 4 -999 EXT_NSIGMA, how extended something is +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/SchemaNew19.0/PSPS_VIEWS/Views =================================================================== --- /trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_VIEWS/Views (revision 37733) +++ /trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_VIEWS/Views (revision 37734) @@ -1,13 +1,13 @@ PSPS VIEWS - examples (not complete, please suggest others) -ObjectMean = ObjectThin join MeanObject -ObjectStack = ObjectThin join StackObjectThin join StackObjectAttributes -ObjectApFlx = ObjectThin join StackApFlx -ObjectApFlxEG = ObjectThin join StackApFlxEGUnc join StackApFlxEGCon6 join StackApFlxEGCon8 -ObjectModelFull = ObjectThin join StackModelFitExp join StackModelFitDeV join StackModelFitSer join StackPetrosian -ObjectStackFull = ObjectThin join StackObjectThin join StackObjectAttributes join StackModelFitExp join StackModelFitDeV join StackModelFitSer join StackPetrosian join StackApFlxEGUnc join StackApFlxEGCon6 join StackApFlxEGCon8 -ObjectForcedMean = ObjectThin join ForcedMeanObject -ObjectPrimary = ObjectThin join StackObjectThin join StackObjectAttributes join StackApFlx where primaryDection is true -ObjectBest = ObjectThin join StackObject join StackObjectAttributes join StackApFlx where bestDetection is true +MeanObjectView = ObjectThin join MeanObject +StackObjectView = ObjectThin join StackObjectThin join StackObjectAttributes +StackApFlxObjectView = ObjectThin join StackApFlx +StackApFlxEGObjectView = ObjectThin join StackApFlxEGUnc join StackApFlxEGCon6 join StackApFlxEGCon8 +StackModelObjectView = ObjectThin join StackModelFitExp join StackModelFitDeV join StackModelFitSer join StackPetrosian +ForcedMeanObjectView = ObjectThin join ForcedMeanObject +StackObjectPrimaryView = ObjectThin join StackObjectThin join StackObjectAttributes join StackApFlx where primaryDection is true +StackObjectBestView = ObjectThin join StackObject join StackObjectAttributes join StackApFlx where bestDetection is true +DiffDetObjectView = DiffDetObject join DiffDetection @@ -15,3 +15,2 @@ -