[wiki:ThingsToBeDoneBeforeSas40 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. * psfModelID is a string in StackMeta/ForcedWarpMeta. * !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?