Project

General

Profile

Balrog matches to deep field and photo-z's » History » Version 2

Version 1 (Huan Lin, 03/21/2019 12:36 PM) → Version 2/11 (Huan Lin, 03/21/2019 02:00 PM)

h1. Balrog matches to deep field and photo-z's

Notes by Huan Lin, 21 Mar 2019

h2. Matching Balrog detections to deep field coordinates

The "Balrog Run 1":https://cdcvs.fnal.gov/redmine/projects/des/wiki/Balrog_Run detected objects were matched to the "Y3 deep field coadd":https://cdcvs.fnal.gov/redmine/projects/des-y3/wiki/Y3_Deep_Coadds 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:
<pre>
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
</pre>

Query used on DESSCI for the Balrog/SN detections:
<pre>
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
</pre>
test