Balrog matches to deep field and photo-z's¶

Notes by Huan Lin, 21 Mar 2019

• Table of contents
• Balrog matches to deep field and photo-z's
  • Matching Balrog detections to deep field coordinates

Matching Balrog detections to deep field coordinates¶

The Balrog Run 1 detected objects were matched to the Y3 deep field coadd objects in order to obtain the original true RA and Dec of the respective parent deep field objects.

Query used on DESSCI for the Balrog/COSMOS detections:

select y.bal_id, y.true_id, y.true_tilename, y.true_ra, y.true_dec, y.meas_cm_mag_g, y.meas_cm_mag_r,
y.meas_cm_mag_i, y.meas_cm_mag_z, y.true_cm_mag_deredden_g, y.true_cm_mag_deredden_r, 
y.true_cm_mag_deredden_i, y.true_cm_mag_deredden_z, c.tilename, c.ra, c.dec 
from YANNY.BALROG_MATCHED_CATALOG_FLATTEN y, Y3A2_MISC_MOF_V3_COSMOS c 
where y.true_id = c.coadd_object_id and y.true_tilename like '%COSMOS%'; > balrog_cosmos.fits

Query used on DESSCI for the Balrog/SN detections:

select y.bal_id, y.true_id, y.true_tilename, y.true_ra, y.true_dec, y.meas_cm_mag_g, y.meas_cm_mag_r, 
y.meas_cm_mag_i, y.meas_cm_mag_z, y.true_cm_mag_deredden_g, y.true_cm_mag_deredden_r, 
y.true_cm_mag_deredden_i, y.true_cm_mag_deredden_z, c.tilename, c.ra, c.dec 
from YANNY.BALROG_MATCHED_CATALOG_FLATTEN y, Y3A2_MISC_MOF_V1_COADD_TRUTH c 
where y.true_id = c.coadd_object_id and y.true_tilename like '%SN%'; > balrog_sn.fits

The resulting fits files are here:

• balrog_cosmos.fits
• balrog_sn.fits