1
0
-1

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.

    CommentAdd your comment...

    2 answers

    1.  
      1
      0
      -1

      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?

        CommentAdd your comment...
      1.  
        1
        0
        -1

        Hi Aurelio,

        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,

         

         

        1. Aurelio Carnero

          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?

        CommentAdd your comment...