Child pages
  • Mapping CatSim quantities to DIASource and DIAObject schemas
Skip to end of metadata
Go to start of metadata

 

DIASource schema

DIASource columnCatSim/OpSim columnCatSim or OpSim
diaSourceIdsome combination of uniqueID and obsHistIDboth
ccdVisitIdcan be calculated from chipNameFromRaDec() and obsHistIDCatSim
ssObjectIdssmid (in solar system object tables)CatSim
parentSourceIduniqueIDCatSim
midPointTaiexpMJD (need to check whether this is the beginning or the middle of the exposureOpSim
filterNamefilterOpSim
radecraICRS, decICRS (cannot use raJ2000, decJ2000 if you want to account for proper motion)CatSim
radecCovNone 
xypixelCoordsFromRaDec()CatSim
xyCovNone 
apFlux

methods in sims_photUtils can calculate flux

(remember to subtract off mean flux of the source)

CatSim
apFluxErrmethods in sims_photUtils can calculate flux uncertainties given m5 (from OpSim)CatSim
SNRmethods in sims_photUtils can calculate signal to noise given m5 (from OpSim)CatSim
psFluxtreat same as apFluxCatSim
psFluxSigmamight be able to calculate analogously to apFluxErrCatSim
psRadectreat same as radecCatSim
psCovNone 
psLnLNone 
psChi2None 
psNdataNone (could probably calculate something from a PSF model, if needed) 
trailFluxtreat same as apFluxCatSim
trailRadectreat same as radecCatSim
trailLengthNone 
trailAngleNone 
trailCovNone 
trailLnLNone 
trailChi2None 
trailNdataNone 
dipMeanFluxtreat same as apFluxCatSim
dipFluxDiffNone 
dipRadectreat same as radecCatSim
dipLength

None

 
dipAngleNone 
dipCovNone 
dipLnLNone 
dipChi2None 
dipNdataNone 
totFluxtreat same as apFlux, but do not subtract off meanCatSim
totFluxErrtreat same as apFluxErrCatSim
diffFluxcan be calculated from sims_photUtilsCatSim
diffFluxErrcan be calculated from sims_photUtilsCatSim
fpBkgdcan be calculated from sims_photUtilsCatSim
fpBkgdErrcan be calculated from sims_photUtilsCatSim
IxxNone 
Iyy

None

 
IcovNone 
IxxPSFNone (but could probably cook something up from a PSF model) 
IyyPSFNone 
IxyPSFNone 
extendendessCould probably read directly from CatSim object typeCatSim
spuriousnessCould probably do something with SNR to get thisCatSim
flagsNone 

 

DIAObject schema

DIAObject columnCatSim/OpSim columnCatSim or OpSim
diaObjectIDuniqueIDCatSim
radecraICRS, decICRS (raJ2000 and decJ2000 do not account for proper motion)CatSim
radecCovNone 
radecTaiexpMJDOpSim
pmproperMotionRA, properMotionDecCatSim
parallaxparallaxCatSim
pmParallaxCovNone 
pmParallaxLnLNone 
pmParallaxChi2None 
pmParallaxNdataNone 
psFluxMeancan calculate with sims_photUtilsCatSim
psFluxMeanErrcan 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
psFluxNdatanumber of observations of the same sourceOpSim
fpFluxMeantreat like psFluxMeanCatSim
fpFluxMeanErrtreat like psFluxMeanErrCatSim
fpFluxMeanSigmatreat like psFluxMeanSigmaCatSim
lcPeriodiccan extract with third party packages (i.e. gatspy), if we desirethird party
lcNonPeriodiccan extract with third party packages (i.e. gatspy), if we desirethird party
nearbyObjsearch CatSim tablesCatSim
nearbyObjDistsearch CatSim tablesCatSim
nearbyObjLnPNone 
flagsNone 

 

SSObject schema

SSObject columnCatSim/OpSim columnCatSim or OpSim
ssObjectIdssmidCatSim
oenot stored in CatSim, but can probably be dug up from our original dataexternal
oeCovNone 
arcdates observed by OpSim (question)OpSim
orbFitLnLNone 
orbFitChi2None 
orbFitNdataNone 
MOIDNone 
moidLonNone 
Hcalculate from asteroid magnitude parametersCatSim
G1calculate from asteroid magnitude parametersCatSim
G2calculate from asteroid magnitude parametersCatSim
hErrmight be able to calculate from sims_photUtilsCatSim
g1Errshould be easy to calculatenew method
g2Errshould be easy to calculatenew method
flagsNone 
  • No labels