Back up.

This may duplicate entries on the other lists. I have not checked for duplicates yet (I will strike through the entry here when I do so).

• Schema Browser
  • Detection table references DetectionCalib and DetectionFull tables, which do not appear to exist.
    • Typos in table description: "unless one wantw to do the our the astrometric".
    • Are the FWHM values really in arcseconds?
  • No description text for DiffDetObject table.
  • No description text for DiffDetection table.
  • DiffDetection uses "pixels" and "raw pixels". This seems like an error. "raw pixels" seems to be the standard on other tables.
  • Should DiffMeta/DiffToImage be listed in "Fundamental IPP Data Products" or "Observational Metadata and Supporting System MetaData Tables"?
  • ForcedMeanObject lists gFPSFFluxStd, gFKronFluxStd, gFApFluxStd, etc for other filters as dimensionless. These should be set to the correct flux unit to match the gFPSFFlux/gFPSFFluxErr values.
    • gFPSFFlux/gFPSFFluxErr claim to be AB magnitudes. They are fluxes, and therefore should not be in magnitudes. A database query suggests they are in Janskies.
    • gFPSFFlux and other filters has confusing Description text.
  • No table descriptions for DiffMeta, DiffToImage, ForcedMeanLensing, ForcedMeanObject, ForcedWarpMeasurement.
    • Are the FWHM values really in arcseconds?
  • MeanObject table has no table information. Unclear table description. Quadruple-quote typos.
    • Column orderings are different between g and other filters. gMeanPSFMagNpt comes after MagMin/MagMax, but r-y have this before.
  • ObjectThin has confusing table description.
    • I do not think the objName is being calculated correctly. For example objID = 101273355750459367, (raMean, decMean) are (335.57505452, -5.60085831). This should convert to sexagesimal as (22:22:18, -5:36:03), which does not match the given name of "PS1.2 J222218.0--62356.9". I'm not sure if this is generically true, or simply a mishandling of negative declination.
      • Is this even the correct format?
    • objName description in DiffDetObject should probably match the version found here.
    • consistencyFlag does not appear populated.
    • nStackObjectRows does not appear to be populated.
    • nStackDetections does not appear to be correct. Example objID =101683338006825170.
    • nDetections seems wrong as well. objID = 101683337908223873
    • Unclear cx,cy,cz,lambda,beta,l,b descriptions.
    • ra/decErr occasionally -999, which doesn't not seem correct. Example objID = 101283355856926633.
  • StackApFlx table description does not state the convolved FWHM values.
    • primaryDetection description is unhelpful.
    • gflxR5 and other radii and filters: can this list the radius in physical units as well?
  • !StackApFlxExGalCon6 has no table description.
    • stackDetectRowID has typo in description. Is this a bitmask? A query to the database indicates this value is unpopulated with values -999.
    • primaryDetection description is unhelpful.
    • gc6flxR3 and other radii/filters: what are the radius units?
  • !StackApFlxExGalCon8 has the same issues as !StackApFlxExGalCon6.
  • !StackModelFitDeV has no table description.
    • stackDetectRowID complaint.
    • primaryDetection description is unhelpful.
    • DeVaucouleurs inconsistently spelled.
  • StackModelFitExp has no table description.
    • stackDetectRowID/primaryDetection issue.
    • Exponential likely not needed capitalized in row descriptions.
  • StackModelFitExtra has no table description.
    • stackDetectRowID/primaryDetection issue.
    • glogC/other filters description does not close parentheses.
  • StackModelFitSer has no table description.
    • stackDetectRowID/primaryDetection issue.
  • StackModelFitPet gpetCf is in pixels, and is dimensionless in other tables (see serCf in StackModelFitSer)
  • StackObjectAttributes has no table description.
    • stackDetectRowID/primaryDetection issue.
    • gxPos/gyPos/other filters claim to be in arcseconds, but a query suggests it is in pixels (or "stack pixels" to keep consistent with ForcedWarpMeasurement/Detection)
    • gxPosErr/gyPosErr/other filters also claims to be in arcseconds. The query again suggests pixels.
    • gpsfMajorFWHM/gpsfMinorFWHM claims to be in arcseconds as well. I suspect this to be in pixels as well. This point is more thorough than those for Detection and ForcedWarpMeasurement because I didn't notice any issues until going back to check from here.
    • gmomentXX/XY/YY/R1/RH claim to be in units arcsec squared/arcsec squared/arcsec/sqrt arcsec. This is inconsistent with Detection and ForcedWarpMeasurement, which list all five in units of pixels.
    • gapFillFac/gexpTime/filters is unclear.
    • gsky/filters is unclear in units between description and units.
  • StackObjectThin has no table description.
    • randomStackObjID references a random objid that does not appear in this table.
    • stackDetectRowID/primaryDetection issue.
    • ginfoFlag/ginfoFlag2/ginfoFlag3/filters descriptions are unhelpful.
  • StackPetrosian has no table description.
    • stackDetectRowID/primaryDetection issue.
    • gpetRadiusErr/filters largely all -999.
    • when gpetMag/filters = -999, the gpetR50/gpetR90 values and errors appear to be nonsense.
    • gpetCf/filters has values greater than 1. This is listed as units of pixels, but a I was expecting a coverage factor to be a 0-1 like Detection.psfQf.
  • ImageFlags looks correct.
  • CameraConfig has an unhelpful description.
  • DetectionFlags suggests that it is only applicable to the Detection table.
  • I am assuming that all *ObjectView tables pull their row description information from the tables that comprise the view, and will not re-examine those.
  • Filter has an unhelpful description.
  • ForcedWarpExtended has no table description.
    • skyCellID has a typo in the description.
    • flxR5/radii should have radius units in the description.
    • obsTime description references "positive detection" which is all that exists for a forced warp measurement.
  • ForcedWarpLensing has no table description.
    • skyCellID/obsTime as before.
  • ForcedWarpMeta has no table description.
    • This table is also the first place I've seen an "alphanumeric" unit, which have been simply "dimensionless" in other tables when a similar field was a string (qv DetectionFlags).
  • ForcedWarpToImage has no table description.
  • FrameMeta has typos in the table description.
    • ~p1Recip/p2Recip/p3Recip do not appear to be populated.~
    • expStart is in "days". Previous entries for similar time fields have used Mean Julian Days.
    • ctype2 has no unit description, neither alphanumeric nor dimensionless.
    • crpix1 has "pc001001" as the units, which is a header keyword. crpix2 has units "dimensionless" which doesn't seem right either although it does match other uses (DiffMeta).
    • telescopeID does not reference a table.
  • ImageMeta.
    • imageID has undefined reference to ALEX.
    • I am suspicious that the bias and biasScat values are identical for all OTAs in an exposure.
    • magSat and completMag do not appear to be populated (values=0, not the default value of -999).
    • nx/ny are incorrect, or at best incomplete. They list values = (590, 598) which is the size of a single cell, not the full OTA that this table is describing. Are these useful at all given that they will be identical for every exposure?
    • A similar question about psfModelID (=-999).
    • My continuing confusion on FWHM units. These again have values (~4) that make me suspect they are actually in pixels. Similarly for psfWidMajor, psfWidMinor.
    • momentM2C/M2S/M3/M4 units. These are all pixels for the Detection table.
    • detrend1-8. If these are pulling specific header values (which they appear should be), then the descriptions should be updated to reflect which detrend they are mapping. In addition, ~DETREND.NOISEMAP, DETREND.NONLIN, DETREND.VIDEODARK~, and if it's not already included DETREND.FRINGE should be included. Pulling PTRN_ROW and PTRN_CON (booleans) might also be useful.
    • crpix1/2 have units of pixels here, and so FrameMeta should be changed to match.
  • ObjectFilterFlags has an unclear table description.
  • ObjectInfoFlags has an unclear table description.
  • ObjectQualityFlags has an unclear table description.
  • PhotoCal references a DetectionCalib table that does not exist.
  • StackDetectionFlags references a StackDetection table that does not exist.
  • StackMeta ~magSat does not appear to be populated.~
    • expTime references the units in the description.
    • completMag,astroScat,photScat,nAstroRef,~nPhoRef~, photoColor do not appear to be populated.
    • crpix1/2 have units dimensionless.
    • psfFwhm_mean/_max units.
  • TessellationType does not have a table description.
  • Should nAstroRef and nPhoRef be changed to match the usage in ImageMeta, ie numAstroRef/numPhotoRef?