IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Ignore:
Timestamp:
Apr 6, 2015, 4:38:40 PM (11 years ago)
Author:
heather
Message:

shcema20 first

Location:
trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables
Files:
6 edited

Legend:

Unmodified
Added
Removed

  • trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/DiffDetObject

    r38088 r38090  
    55ippObjID        dimensionless   BIGINT  8       NA      IPP object number
    66surveyID        dimensionless   TINYINT 1       255     Survey ID
    7 skyCellID       dimensionless   REAL    4       -999    single float giving PrimaryCell.SkyCell identifier
    87htmID           dimensionless   BIGINT  8       NA      HTM index
    98zoneID          dimensionless   INT     4       NA      Zone index
    10 randomID        dimensionless   BIGINT  8       0       Random integer between 0 and 2^32 = 4,394,967,296 remaining ramdom integer 0 
     9randomDiffObjID         dimensionless   BIGINT  8       0       Random integer between 0 and 2^32 = 4,394,967,296 remaining ramdom integer 0 
    1110batchID         dimensionless   BIGINT  8       -999   
    1211dvoRegionID     dimensionless   INT     4       -999    identifier to dvo spatial region

  • trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/DiffDetObject.txt

    r38088 r38090  
    55ippObjID         = dvo:cpt.objID | cpt.catID <<32
    66surveyID         = ipptopsps
    7 skyCellID        = smf header ?? how does this work for objects
    87htmID            = PSPS
    98zoneID           = PSPS
    10 randomID         = ipptopsps
     9randomDiffObjID          = ipptopsps
    1110batchID          = ipptopsps
    1211dvoRegionID      = dvo:cpt:catID

  • trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedMeanLensing

    r38088 r38090  
    33uniquePspsFOid dimensionless BIGINT   8   NA    unique id supplied by ipptopsps
    44ippObjID        dimensionless   BIGINT   8        NA    IPP object identifier
     5randomForcedMeanObjID dimensionless BIGINT   8    NA    random number for this object 
    56nDetections     dimensionless   SMALLINT 2      -999    total number of detection measurements in all filters
    67batchID         dimensionless   BIGINT   8        NA    batch id
    78-----------------------------------------------------   replicate to bottom for each filter
    8 gStackID        dimensionless   INT      4              stack image id (how to carry through IPP + DVO)
    99gLensObjSmearX11 arcsec^-2      REAL     4      -999    per-object smear polarizability X11 term
    1010gLensObjSmearX12 arcsec^-2      REAL     4      -999    per-object smear polarizability X12 term

  • trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedMeanLensing.txt

    r38088 r38090  
    33uniquePspsFOid   = ipptopsps
    44ippObjID         = cpt.objID | cpt.catID << 32
     5randomForcedObjID = ipptopsps
    56nDetections      = sql sum of cps.NCODE (xnTotal)
    67batchID          = ipptopsps
    78---------------- =
    8 gStackID         = ipptopsps / gpc1 db
    99gLensObjSmearX11 = cpy.X11_SM_OBJ
    1010gLensObjSmearX12 = cpy.X12_SM_OBJ

  • trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedMeanObject

    r38088 r38090  
    33uniquePspsFOid dimensionless BIGINT   8   NA    unique id supplied by ipptopsps
    44ippObjID        dimensionless   BIGINT   8        NA    IPP object identifier
     5randomForcedObjID dimensionless BIGINT   8        NA    random number generated by ipptopsps
    56nDetections     dimensionless   SMALLINT 2      -999    total number of detection measurements in all filters
    67batchID         dimensionless   BIGINT   8        NA    batch id
    78-----------------------------------------------------   replicate to bottom for each filter
    8 gStackID        dimensionless   INT      4              stack image id (how to carry through IPP + DVO)
    99gnTotal         dimensionless   SMALLINT 2      -999    number of detections in g filter
    1010gnIncPSFFlux     dimensionless   SMALLINT 2      -999    number of detections included in robust psf mean in g filter

  • trunk/ippToPsps/pspsschema/SchemaNew20.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedMeanObject.txt

    r38088 r38090  
    33uniquePspsFOid   = ipptopsps
    44ippObjID         = cpt.objID | cpt.catID << 32
     5randomForcedObjID = ipptopsps
    56nDetections      = sql sum of cps.NCODE (xnTotal)
    67batchID          = ipptopsps
    78---------------- =
    8 gStackID         = ipptopsps / gpc1 db
    99gnTotal          = cps.NWARP
    1010gnIncPSFFlux     = cps.NUSED_WRP
Note: See TracChangeset for help on using the changeset viewer.