wfau / ScienceArchives

0 stars 0 forks source link

Calculate noise model for each setup #607

Open wfastrononomer opened 3 months ago

wfastrononomer commented 3 months ago

Each setup will have a different equivalent depth and so the MapProvenance table needs to be used to go from depth per image to set of images.

Also the noise model needs to calculated from calibrated fluxes, not magnitudes. A new equation is needed.

wfastrononomer commented 3 months ago

Remove fieldID from Variability table? Process noise model per field and then apply to source as weighted average?

wfastrononomer commented 2 days ago

Basic Light curve query for setupID<0

select top 5 r.apertureID,r.catalogueID,r.mjd,p.aperJky3,p.aperJky3Err,r.ppErrBits from ultravistaMapRemeasurementRaw as r,ultravistaMapRemeasurementPhotometry as p, MapFrameStatus as mfs,ProgrammeFrame as pf where r.catalogueID=p.catalogueID and r.apertureID=p.apertureID and mfs.catalogueID=r.catalogueID and pf.programmeID=mfs.programmeID and pf.multiframeID=mfs.multiframeID and mfs.mapID=2 and pf.fieldID=2

NO! This won't full light curve from overlap areas. Do we want to do noise per fieldID and then do rest of variability stats per N apertures

wfastrononomer commented 2 days ago

Do we want to add fieldID to MapFrameStatus? Perhaps? Are combiCatIDs all have catalogueIDs from same fieldID? YES they do!.

update MapFrameStatus set fieldID=p.fieldID from ProgrammeFrame as p where p.programmeID=MapFrameStatus.programmeID and p.multiframeID=MapFrameStatus.multiframeID

update MapFrameStatus set fieldID=T.fieldID from (select mp.combiCatID,p.fieldID from MapProvenance as mp,MapFrameStatus as mfs, ProgrammeFrame as p where mp.catalogueID=mfs.catalogueID and mfs.multiframeID=p.multiframeID and mfs.programmeID=p.programmeID and mfs.programmeID=160 and mfs.mapID=2 group by mp.combiCatID,p.fieldID) as T where T.combiCatID=MapFrameStatus.catalogueID and MapFrameStatus.multiframeID<0

Also add filterID for same reasons...

update MapFrameStatus set filterID=m.filterID from Multiframe as m where m.multiframeID=MapFrameStatus.multiframeID and m.multiframeID>0

update MapFrameStatus set filterID=T.filterID from (select mp.combiCatID,m.filterID from MapProvenance as mp,MapFrameStatus as mfs, Multiframe as m where mp.catalogueID=mfs.catalogueID and mfs.multiframeID=m.multiframeID and mfs.programmeID=160 and mfs.mapID=2 group by mp.combiCatID,m.filterID) as T where T.combiCatID=MapFrameStatus.catalogueID and MapFrameStatus.multiframeID<0

wfastrononomer commented 2 days ago

Use something like VariabilityProcessing to control....