IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Changeset 37177


Ignore:
Timestamp:
Aug 4, 2014, 8:47:07 AM (12 years ago)
Author:
eugene
Message:

adding notes on stack fields

Location:
branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES
Files:
1 added
3 edited

Legend:

Unmodified
Added
Removed

  • branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectThin.txt

    r37167 r37177  
    11                 
    22objID              = dvo = average.extID   [calculated in addstar]
    3 gcObjID            = dvo = average.extIDgc [not done]
    4 ippObjID           = dvo = average.objID + (average.catID << 32)
    5 surveyID           = ipptopsps
    6 skyCellID          = ipptopsps / smf header
     3gcObjID            = dvo = average.extIDgc *** NOT SET [DROP?]
     4ippObjID           = dvo = average.objID + (average.catID << 32) [NOTE: this is a change in definition]
     5surveyID           = ipptopsps : internal, from survey name
     6skyCellID          = *** we need to decide how we should store this
    77randomStackObjID   = ipptopsps (RANDOM on sql into mysql)
    88stackDetectRowID   = PSPS ?
    9 primaryDetection   = dvo
    10 bestDetection      = dvo ?
     9primaryDetection   = dvo *** NOT YET DONE CORRECTLY
     10bestDetection      = dvo *** THIS CANNOT BE SET UNTIL LATER
    1111                   =
    12 dvoRegionID        = dvo = average.catID
    13 dataRelease        = ippToPsps
     12dvoRegionID        = dvo = average.catID *** NOT YET CARRIED IN FROM dvopsps
     13dataRelease        = ippToPsps : user input (skychunk.dataRelease)
    1414--
    1515--
    … …  
    1818gippDetectID       = dvopsps.ippDetectID = dvo:measure.detID = smf / IPP_IDET
    1919gstackDetectID     = dvopsps.detectID = dvo:measure.extID [calculated in addstar: psps stack detect ID]
    20 gstackMetaID       = smf header
     20gstackMetaID       = ipptopsps : gpc1 db, matches cmf IMAGEID
    2121--
    22 gra                = dvo = average.Rstk [relastro]
    23 gdec               = dvo = average.Dstk [relastro]
    24 graErr             = dvo = average.dRstk [relastro]
    25 gdecErr            = dvo = average.dDstk [relastro]
    26 gzp                = dvo [relphot] -- XXX define this more exactly
    27 gPSFMag            = dvo
    28 gPSFMagErr         = dvo
    29 gApMag             = dvo
    30 gApMagErr          = dvo
    31 gKronMag           = dvo
    32 gKronMagErr        = dvo
    33 gsky               = smf
    34 gskyErr            = smf
    35 ginfoFlag          = smf
    36 ginfoFlag2         = smf
    37 gnFrames           = smf
    38 
    39 [NOTE: for stacks, dvo only needs to determine the
    40        primary measurement (and modified zero point?).
     22gra                = dvo = measure.ra
     23gdec               = dvo = average.dec
     24graErr             = dvo = measure.dX * pltscale
     25gdecErr            = dvo = measure.dY * pltscale (circularly sym)
     26gPSFMag            = dvo = measure.Mpsf
     27gPSFMagErr         = dvo = measure.dMpsf
     28gApMag             = dvo = measure.Map
     29gApMagErr          = dvo = measure.dMap
     30gKronMag           = dvo = measure.Mkron
     31gKronMagErr        = dvo = measure.dMkron
     32gsky               = smf : SKY / exptime
     33gskyErr            = smf : SKY_SIGMA / exptime
     34ginfoFlag          = smf : FLAGS
     35ginfoFlag2         = smf + dvo : FLAGS2 | secfilt.flags << 13 *** CHECK THIS
     36gnFrames           = smf : N_FRAMES

  • branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/MetaData_Tables/StackMeta

    r37167 r37177  
    77photoCalID  dimensionless   INT 4 NA photometry code
    88magSat      dimensionless   REAL 4 -999 saturation magnitude level
    9 analVer     dimensionless   SMALLINT 2 -999 analysis version index
     9analysisVer dimensionless   SMALLINT 2 -999 analysis version index x
    1010expTime     seconds         REAL 4 -999 exposure time
    1111nP2Images   dimensionless   SMALLINT 2 -999 number of P2 images contributing to this cell
    … …  
    1414photoScat   dimensionless   REAL 4 -999 photometric scatter for chip
    1515nAstroRef   dimensionless   INT 4 -999 number of astrometric reference sources
    16 nPhoRef     dimensionless   INT 4 -999 number of photometric reference sources
     16nPhotomRef  dimensionless   INT 4 -999 number of photometric reference sources
    1717psfModelID  dimensionless   VARCHAR(MAX) 8000 PSF model identifier
    1818psfFwhm_mean arcsec         FLOAT 8 -999 mean PSF FWHM in the stack

  • branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/MetaData_Tables/StackMeta.txt

    r37169 r37177  
    1 stackMetaID   |
    2 batchID       |
    3 surveyID      |
    4 filterID      |
    5 stackTypeID   |
    6 skyCellID     |
    7 photoCalID    |
    8 magSat        | *
    9 analVer       | *
    10 expTime       |
    11 nP2Images     | [populateStackToImage]
    12 completMag    | *
    13 astroScat     | *
    14 photoScat     | *
    15 nAstroRef     | *
    16 nPhoRef       | *
    17 psfModelID    |
    18 psfFwhm_mean  |
    19 psfFwhm_max   |
    20 photoZero     |
    21 photoColor    | *
    22 ctype1        |
    23 ctype2        |
    24 crval1        |
    25 crval2        |
    26 crpix1        |
    27 crpix2        |
    28 cdelt1        |
    29 cdelt2        |
    30 pc001001      |
    31 pc001002      |
    32 pc002001      |
    33 pc002002      |
    34 calibModNum   | *
    35 dataRelease   |
     1stackMetaID   | ipptopsps : gpc1 db, matches cmf IMAGEID
     2batchID       | ipptopsps : internal
     3surveyID      | ipptopsps : internal, from survey name
     4filterID      | ipptopsps : internal, lookup from filter (griz)
     5stackTypeID   | ipptopsps : internal, *** hard-wired name ***
     6skyCellID     | *** we need to decide how we should store this. 
     7photoCalID    | dvo.images : photcode
     8magSat        | * NOT SET
     9analysisVer   | gpc1.stackRun.software_ver [EAM: changed this name]
     10expTime       | cmf header EXPTIME
     11nP2Images     | [populateStackToImage] : counts inputs NOTE is this set reasonable?
     12completMag    | * NOT SET
     13astroScat     | * NOT SET
     14photoScat     | * NOT SET
     15nAstroRef     | * NOT SET
     16nPhotomRef    | * NOT SET
     17psfModelID    | cmf header PSFMODEL
     18psfFwhm_mean  | cmf header FWHM_MAJ *** probably wrong value
     19psfFwhm_max   | cmf header FW_MJ_UW *** name and definition are inconsistent
     20photoZero     | cmf header FPA.ZP *** this is not dvo corrected)
     21photoColor    | * NOT SET
     22ctype1        | cmf header
     23ctype2        | cmf header
     24crval1        | cmf header
     25crval2        | cmf header
     26crpix1        | cmf header
     27crpix2        | cmf header
     28cdelt1        | cmf header
     29cdelt2        | cmf header
     30pc001001      | cmf header
     31pc001002      | cmf header
     32pc002001      | cmf header
     33pc002002      | cmf header
     34calibModNum   | * NOT SET
     35dataRelease   | ipptopsps : user input (skychunk.dataRelease)
Note: See TracChangeset for help on using the changeset viewer.