DIASource schema
| DIASource column | CatSim/OpSim column | CatSim or OpSim |
|---|---|---|
| diaSourceId | some combination of uniqueID and obsHistID | both |
| ccdVisitId | can be calculated from chipNameFromRaDec() and obsHistID | CatSim |
| ssObjectId | ssmid (in solar system object tables) | CatSim |
| parentSourceId | uniqueID | CatSim |
| midPointTai | expMJD (need to check whether this is the beginning or the middle of the exposure | OpSim |
| filterName | filter | OpSim |
| radec | raICRS, decICRS (cannot use raJ2000, decJ2000 if you want to account for proper motion) | CatSim |
| radecCov | None | |
| xy | pixelCoordsFromRaDec() | CatSim |
| xyCov | None | |
| apFlux | methods in sims_photUtils can calculate flux (remember to subtract off mean flux of the source) | CatSim |
| apFluxErr | methods in sims_photUtils can calculate flux uncertainties given m5 (from OpSim) | CatSim |
| SNR | methods in sims_photUtils can calculate signal to noise given m5 (from OpSim) | CatSim |
| psFlux | treat same as apFlux | CatSim |
| psFluxSigma | might be able to calculate analogously to apFluxErr | CatSim |
| psRadec | treat same as radec | CatSim |
| psCov | None | |
| psLnL | None | |
| psChi2 | None | |
| psNdata | None (could probably calculate something from a PSF model, if needed) | |
| trailFlux | treat same as apFlux | CatSim |
| trailRadec | treat same as radec | CatSim |
| trailLength | None | |
| trailAngle | None | |
| trailCov | None | |
| trailLnL | None | |
| trailChi2 | None | |
| trailNdata | None | |
| dipMeanFlux | treat same as apFlux | CatSim |
| dipFluxDiff | None | |
| dipRadec | treat same as radec | CatSim |
| dipLength | None | |
| dipAngle | None | |
| dipCov | None | |
| dipLnL | None | |
| dipChi2 | None | |
| dipNdata | None | |
| totFlux | treat same as apFlux, but do not subtract off mean | CatSim |
| totFluxErr | treat same as apFluxErr | CatSim |
| diffFlux | can be calculated from sims_photUtils | CatSim |
| diffFluxErr | can be calculated from sims_photUtils | CatSim |
| fpBkgd | can be calculated from sims_photUtils | CatSim |
| fpBkgdErr | can be calculated from sims_photUtils | CatSim |
| Ixx | None | |
| Iyy | None | |
| Icov | None | |
| IxxPSF | None (but could probably cook something up from a PSF model) | |
| IyyPSF | None | |
| IxyPSF | None | |
| extendendess | Could probably read directly from CatSim object type | CatSim |
| spuriousness | Could probably do something with SNR to get this | CatSim |
| flags | None |
DIAObject schema
| DIAObject column | CatSim/OpSim column | CatSim or OpSim |
|---|---|---|
| diaObjectID | uniqueID | CatSim |
| radec | raICRS, decICRS (raJ2000 and decJ2000 do not account for proper motion) | CatSim |
| radecCov | None | |
| radecTai | expMJD | OpSim |
| pm | properMotionRA, properMotionDec | CatSim |
| parallax | parallax | CatSim |
| pmParallaxCov | None | |
| pmParallaxLnL | None | |
| pmParallaxChi2 | None | |
| pmParallaxNdata | None | |
| psFluxMean | can calculate with sims_photUtils | CatSim |
| psFluxMeanErr | can calculate with sims_photUtils given m5 (OpSim) | CatSim |
| psFluxSigma | can (probably) calculate with sims_photUtils from multiple observations of the same source | CatSim |
| psFluxChi2 | can (probably) calculate with sims_photUtils from multiple observations of the same source | CatSim |
| psFluxNdata | number of observations of the same source | OpSim |
| fpFluxMean | treat like psFluxMean | CatSim |
| fpFluxMeanErr | treat like psFluxMeanErr | CatSim |
| fpFluxMeanSigma | treat like psFluxMeanSigma | CatSim |
| lcPeriodic | can extract with third party packages (i.e. gatspy), if we desire | third party |
| lcNonPeriodic | can extract with third party packages (i.e. gatspy), if we desire | third party |
| nearbyObj | search CatSim tables | CatSim |
| nearbyObjDist | search CatSim tables | CatSim |
| nearbyObjLnP | None | |
| flags | None |
SSObject schema
| SSObject column | CatSim/OpSim column | CatSim or OpSim |
|---|---|---|
| ssObjectId | ssmid | CatSim |
| oe | not stored in CatSim, but can probably be dug up from our original data | external |
| oeCov | None | |
| arc | dates observed by OpSim  | OpSim |
| orbFitLnL | None | |
| orbFitChi2 | None | |
| orbFitNdata | None | |
| MOID | None | |
| moidLon | None | |
| H | calculate from asteroid magnitude parameters | CatSim |
| G1 | calculate from asteroid magnitude parameters | CatSim |
| G2 | calculate from asteroid magnitude parameters | CatSim |
| hErr | might be able to calculate from sims_photUtils | CatSim |
| g1Err | should be easy to calculate | new method |
| g2Err | should be easy to calculate | new method |
| flags | None |