This is Heather's page to track PSPS verification.

Table Verifications

The following tables are listed in the PSPS ODM. Legend of colors:

• black = all is well
• red = completely unpopulated table
• table has some unpopulated columns

Ideally we want to fix the red and bumblebee colored items.

• Fundamental IPP Data Products
  • Detection -- only a few unfilled columns: activeFlag, historyModNum
  • DetectionCalib - this looks lovely, all filled
  • DetectionFull - this looks lovely, all filled
  • DetectionOrphan
  • Object some unfilled columns: projectionCellID, stackVer, objInfoFlag, updated = -999 varFlag = 0, consistencyFlag = 0 when no detections, and -999 otherwise.
  • ObjectCalColor some unfilled columns: calColor, calColorErr, calibModNum
  • StackApFlx piles of unfilled columns: primaryF = 0, isophotmag, isophotmagerr, isophotmajaxis, isophotmagaxiserr, .. Heather gave up recording them...
  • StackB2DFit
  • !StackDetection a few unfilled columns: primaryF, activeFlag, historymodnum = 0 apmagerr, kronraderr = -999
  • StackDetectionCalib -- looks fine
  • StackDetectionFull a few unfilled columns: primarF, activeflag,historymodnum =0, apmagerr, kronraderr =-999
  • StackModelFit - lots of unfilled columns: primaryF , devcovar[12,13,14,15,16,17], expcovar[12,13,14,15,16,17], activeflag= 0 deVradiusErr,deVAbErr, deVPhiErr, raDeVoff, decDevoff, radevofferr, decdevofferr, devcf, devlikelihood, expRadiusErr,expAbErr, expPhiErr,raexpoff, decexpoff, raexpofferr, decexpofferr,expcf,explikelihood, serradiuserr,seraberr,serphierr, raseroff,decseroff,raserofferr,decserofferr,sercf,serlikelihood, = -999
  • StackOrphan - currently unpopulated
• Derived Data Products
  • PPM -currently unpopulated
  • Photoz - currently unpopulated
• Observational Metadata and Supporting System Metadata tables
  • CameraConfig -- doubt ConfigDetails is accurate at all... this looks just like it was testing only
  • DetectionFlags -- looks fine
  • Filter -- we need to add w to this
  • FitModel
  • FrameMeta --looks fine
  • ImageFlags - looks fine- why can't we have this for all the flags?
  • ImageMeta --magSat and completeMag are 0 , psfModelID is -999, qaFlags, crval1,crval2, calibModNum are 0
  • PhotoCal -- looks fine except missing w stuff (how does that get updated?)
  • PhotozRecipe -looks fine
  • StackMeta unfilled: magSat, analVer,completMag, astroScat, photoScat, nAstroRef,nPhoRef,photoColor, calibModNum
  • StackToImage - no problems here!
  • Survey - no problems here!
• Object-Detection Modifications History
  • ObjectModHistory - currently unpopulated
• Internal Tables
  • PsConstant - currently unpopulated
• Difference Image Detection
  • StackDeltaAltFit - currently unpopulated
  • StackHighSigDelta - currently unpopulated