IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Changeset 37524


Ignore:
Timestamp:
Oct 22, 2014, 11:24:31 AM (12 years ago)
Author:
heather
Message:

more information in the schema for where values in forced tables come from

Location:
trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables
Files:
3 edited

Legend:

Unmodified
Added
Removed

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

    r37519 r37524  
    11                 
    2 objID            = cps.extID
     2objID            = cpt.extID
    33unique_psps_fo_id  = ipptopsps
    44gcobjID          = remove?
    5 ippObjID         = cps.objID | cps.catID << 32
     5ippObjID         = cpt.objID | cpt.catID << 32
    66nDetections      = sql sum of cps.NCODE (xnTotal)
    77batchID          = ipptopsps

  • trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpExtended.txt

    r37474 r37524  
    11
    2 objID            = dvo/addstar
     2objID            = cpt.extID (???)
    33unique_psps_fw_id = ipptopsps
    4 gcObjID          = dvo/addstar
    5 detectID         = dvo/addstar
    6 ippObjID         = dvo/addstar
    7 ippDetectID      = dvo/addstar
    8 filterID         =
    9 surveyID         =
    10 forcedWarpID     =
    11 randomWarpID     =
    12 skyCellID        =
    13 dvoRegionID      =
     4gcObjID          = remove?
     5detectID         = cpm.extID (???)
     6ippObjID         = cpx.obj_ID | cpx.cat_ID << 32
     7ippDetectID      = cpx.det_ID (???)
     8filterID         = ipptopsps / gpc1
     9surveyID         = ipptopsps
     10forcedWarpID     = ipptopsps / gpc1
     11randomWarpID     = ipptopsps
     12skyCellID        = ipptopsps / gpc1
     13dvoRegionID      = ipptopsps / gpc1
    1414obsTime          = smf
    1515---------------- =
    16 lensObjSmearX11  = smf [PS1_V5]
    17 lensObjSmearX12  = smf [PS1_V5]
    18 lensObjSmearX22  = smf [PS1_V5]
    19 lensObjSmearE1   = smf [PS1_V5]
    20 lensObjSmearE2   = smf [PS1_V5]
    21 lensObjShearX11  = smf [PS1_V5]
    22 lensObjShearX12  = smf [PS1_V5]
    23 lensObjShearX22  = smf [PS1_V5]
    24 lensObjShearE1   = smf [PS1_V5]
    25 lensObjShearE2   = smf [PS1_V5]
    26 lensPSFSmearX11  = smf [PS1_V5]
    27 lensPSFSmearX12  = smf [PS1_V5]
    28 lensPSFSmearX22  = smf [PS1_V5]
    29 lensPSFSmearE1   = smf [PS1_V5]
    30 lensPSFSmearE2   = smf [PS1_V5]
    31 lensPSFShearX11  = smf [PS1_V5]
    32 lensPSFShearX12  = smf [PS1_V5]
    33 lensPSFShearX22  = smf [PS1_V5]
    34 lensPSFShearE1   = smf [PS1_V5]
    35 lensPSFShearE2   = smf [PS1_V5]
     16lensObjSmearX11  = cpx.X11_SM_OBJ
     17lensObjSmearX12  = cpx.X12_SM_OBJ
     18lensObjSmearX22  = cpx.X22_SM_OBJ
     19lensObjSmearE1   = cpx.E1_SM_OBJ
     20lensObjSmearE2   = cpx.E2_SM_OBJ
     21lensObjShearX11  = cpx.X11_SH_OBJ
     22lensObjShearX12  = cpx.X12_SH_OBJ
     23lensObjShearX22  = cpx.X22_SH_OBJ
     24lensObjShearE1   = cpx.E1_SH_OBJ
     25lensObjShearE2   = cpx.E2_SH_OBJ
     26lensPSFSmearX11  = cpx.X11_SM_PSF
     27lensPSFSmearX12  = cpx.X12_SM_PSF
     28lensPSFSmearX22  = cpx.X22_SM_PSF
     29lensPSFSmearE1   = cpx.E1_SM_PSF
     30lensPSFSmearE2   = cpx.E2_SM_PSF
     31lensPSFShearX11  = cpx.X11_SH_PSF
     32lensPSFShearX12  = cpx.X12_SH_PSF
     33lensPSFShearX22  = cpx.X22_SH_PSF
     34lensPSFShearE1   = cpx.E1_SH_PSF
     35lensPSFShearE2   = cpx.E2_SH_PSF
    3636---------------- =
    37 flxR5            = smf [?? calculated?]
    38 flxR5Err         = smf [?? calculated?]
    39 flxR5Std         = smf [?? calculated?]
    40 flxR5Fill        = smf [?? calculated?]
    41 flxR6            = smf [?? calculated?]
    42 flxR6Err         = smf [?? calculated?]
    43 flxR6Std         = smf [?? calculated?]
    44 flxR6Fill        = smf [?? calculated?]
     37flxR5            = cpx.FLX_AP_R5
     38flxR5Err         = cpx.FLX_ERR_AP_R5
     39flxR5Std         = cpx.FLX_STD_AP_R5
     40flxR5Fill        = cpx.FLX_FIL_AP_R5
     41flxR6            = cpx.FLX_AP_R6
     42flxR6Err         = cpx.FLX_ERR_AP_R6
     43flxR6Std         = cpx.FLX_STD_AP_R6
     44flxR6Fill        = cpx.FLX_FIL_AP_R6
    4545---------------- =

  • trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpMeasurement.txt

    r37474 r37524  
    11
    2 objID            = dvo/addstar
     2objID            = cpt.extID (???)
    33unique_psps_fw_id = ipptopsps
    4 gcObjID          = dvo/addstar
    5 detectID         = dvo/addstar
    6 ippObjID         = dvo/addstar
    7 ippDetectID      = dvo/addstar
    8 filterID         =
    9 surveyID         =
    10 forcedWarpID     =
    11 randomWarpID     =
    12 skyCellID        =
    13 dvoRegionID      =
     4gcObjID          = remove?
     5detectID         = cpm.extID (???)
     6ippObjID         = cpx.obj_id | cps.cat_id << 32
     7ippDetectID      = cpx.det_id (???)
     8filterID         = ipptopsps /gpc1
     9surveyID         = ipptopsps
     10forcedWarpID     = ipptopsps / gpc1
     11randomWarpID     = ipptopsps
     12skyCellID        = ipptopsps / gpc1
     13dvoRegionID      = ipptopsps / gpc1
    1414obsTime          = smf
    1515---------------- =
    16 zp               = smf
    17 telluricExt      = (zp - zpNominal)
     16zp               = smf (???)
     17telluricExt      = smf (???) (zp - zpNominal)
    1818expTime          = smf
    1919airMass          = smf
    … …  
    4949sky              = smf
    5050skyErr           = smf
    51 infoFlag         =
    52 dataRelease      =
     51infoFlag         = smf
     52dataRelease      = ipptopsps
Note: See TracChangeset for help on using the changeset viewer.