Project

General

Profile

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

« Previous - Version 2/11 (diff) - Next » - Current version
Huan Lin, 03/21/2019 02:00 PM


Balrog matches to deep field and photo-z's

Notes by Huan Lin, 21 Mar 2019

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