I want to get all the individual magnitude values that make the coadd magnitude (auto, for example), given its coadd_object_id from Y3, for one of the 5 bands, grizY.
Sorry, I did not explain correctly, I meant the fluxes/magnitudes of each single exposure, that is later coadded to give you the magnitude in Y3A1_COADD_OBJECT_SUMMARY. grizY are coadded magnitudes, how can I find the final exposure magnitudes (or combination of flux+zeropoints) that goes into the coadd, and its band?
There are 2 options,
The table Y3A1_COADD_OBJECT_SUMMARY contains magnitudes for all the bands for the following:
MAG_APER_8,MAG_AUTO,MAG_DETMODEL and WAVG_MAG_PSF
A simple example query from just that table:
select COADD_OBJECT_ID, RA,DEC, MAG_AUTO_G,MAG_AUTO_R,MAG_AUTO_I from Y3A1_COADD_OBJECT_SUMMARY where rownum < 5;
If you need other magnitude you need to join with a 'band' table, for example for the G band: Y3A1_COADD_OBJECT_BAND_G
with something like:
select t.COADD_OBJECT_ID, g.MAG_APER_4 from Y3A1_COADD_OBJECT_SUMMARY t join Y3A1_COADD_OBJECT_BAND_G g on t.COADD_OBJECT_ID = g.COADD_OBJECT_ID where rownum < 5
If you know the id and the magnitude is not on the summary table, then you can use something like:
select g.COADD_OBJECT_ID, g.MAG_APER_4 MAG_APER_G, r.MAG_APER_4 MAG_APER_4_R from Y3A1_COADD_OBJECT_BAND_G g, Y3A1_COADD_OBJECT_BAND_R r where g.COADD_OBJECT_ID = 307225361 and g.COADD_OBJECT_ID=r.COADD_OBJECT_ID;
Hope this helps,
Powered by a free Atlassian Confluence Open Source Project License granted to NCSA OpenSource. Evaluate Confluence today.