Cone search sorted by distance on Flagship Mockup catalogue

Use case: select galaxies in a cone area of 6 arcmin, brighter than magnitude 24 and colour cut red galaxies, sorted by distance to some point in galactic coordinates.

Note that radius unit is decimal degrees.

Target table: flagship_mock_1_10_3_s_sc8_c
Query:

SELECT DISTANCE(
  POINT('ICRS', ra_gal, dec_gal), 
  POINT('ICRS',220,10))*3600 AS dist, ra_gal, dec_gal, euclid_vis, euclid_nisp_y, euclid_nisp_j, euclid_nisp_h, observed_redshift_gal
FROM sascat.flagship_mock_1_10_3_s_sc8_c  
WHERE CONTAINS(POINT('ICRS',ra_gal,dec_gal),CIRCLE('ICRS',220,10,0.1))=1 
AND (euclid_vis - euclid_nisp_h) > 0
AND (euclid_vis < 24)
ORDER by dist ASC

Box search sorted by distance on Flagship Mockup catalogue

Use case: select all objects in a rectangular area

Target table: flagship_mock_1_10_3_s_sc8_c
Query:

SELECT ra_gal, dec_gal, euclid_vis, euclid_nisp_y, euclid_nisp_j, euclid_nisp_h, observed_redshift_gal 
FROM flagship_mock_1_10_3_s_sc8_c 
WHERE (ra_gal > 220) AND (ra_gal < 221) AND (dec_gal > 10) AND (dec_gal < 11)

Cone search sorted by distance and redshift on Flagship Mockup catalogue

Use case: select all galaxies in the Flagship in a cone area in the redshift range 1 to 2

Target table: flagship_mock_1_10_3_s_sc8_c
Query:

SELECT DISTANCE(
  POINT('ICRS', ra_gal, dec_gal), 
  POINT('ICRS',220,10))*3600 AS dist, ra_gal, dec_gal, euclid_vis, euclid_nisp_y, euclid_nisp_j, euclid_nisp_h, observed_redshift_gal
FROM flagship_mock_1_10_3_s_sc8_c  
WHERE CONTAINS(POINT('ICRS',ra_gal,dec_gal),CIRCLE('ICRS',220,10,0.5))=1 
AND (true_redshift_gal > 1.0) AND (true_redshift_gal < 2.0)
ORDER by observed_redshift_gal ASC

Search by flux in SC#8 Catalogue

Use case: return the JPCAM and LSST photometry for some galaxias around a given region in the sky

Target table: sascat_sc8.mer_final_cat_sc8

Query:

SELECT TOP 500 mer_final_cat_sc8.a_image,mer_final_cat_sc8.avg_trans_wave_g_ext_jpcam,mer_final_cat_sc8.avg_trans_wave_i_ext_lsst,mer_final_cat_sc8.avg_trans_wave_r_ext_lsst
FROM sascat_sc8.mer_final_cat_sc8 
WHERE CONTAINS(POINT('ICRS',right_ascension,declination),CIRCLE('ICRS',232,26,0.83333))=1

Search by flux in SC#8 Catalogue

Use case: select brightest galaxies in SC8 catalogue.

Target table: sascat_sc8.mer_final_cat_sc8
Query:

SELECT right_ascension, declination, flux_g_ext_decam_aper, flux_vis_aper, flux_r_ext_decam_aper, flux_i_ext_decam_aper, flux_z_ext_decam_aper,  flux_y_aper, flux_j_aper, flux_h_aper
FROM sascat_sc8.mer_final_cat_sc8 
WHERE (flux_vis_aper > 10)
ORDER by flux_y_aper DESC

The results of the query can be shown by clicking on the Display top results button:

images/confluence/download/attachments/120474422/exampleQueries2.png

The top left option Query examples will show a few useful examples similar to the above ones.