UNIONS CFIS Pan-STARRS Subaru

UNIONS catalog query page

Query system documentation
Query builder
Submission method:
Return format:
Query:
This box shows the query (in ADQL) that will be executed. You can use the other boxes on this page to set the query, or modify this box directly for greater control.
(more documentation)
Max rows:
Asynchronous query monitor
Messages
no messages
Show columns from:
UNIONS CFIS DR3 UNIONS Pan-STARRS DR2 Pan-STARRS 3PI GAIA EDR3 SDSS DR16
UNIONS CFIS DR3
include sky position as a returned column
RA:
Dec:
Use a: with sides
ID ≥ ≤
RA ≥ ≤ Dec ≥ ≤
X_IMAGE ≥ ≤ Y_IMAGE ≥ ≤
U_MAG_AUTO ≥ ≤ R_MAG_AUTO ≥ ≤
U_MAGERR_AUTO ≥ ≤ R_MAGERR_AUTO ≥ ≤
U_MAG_COG ≥ ≤ R_MAG_COG ≥ ≤
U_MAGERR_COG ≥ ≤ R_MAGERR_COG ≥ ≤
U_MAG_APAUTO ≥ ≤ R_MAG_APAUTO ≥ ≤
U_MAGERR_APAUTO ≥ ≤ R_MAGERR_APAUTO ≥ ≤
U_IQ ≥ ≤ R_IQ ≥ ≤
U_A_WORLD ≥ ≤ R_A_WORLD ≥ ≤
U_ERRA_WORLD ≥ ≤ R_ERRA_WORLD ≥ ≤
U_B_WORLD ≥ ≤ R_B_WORLD ≥ ≤
U_ERRB_WORLD ≥ ≤ R_ERRB_WORLD ≥ ≤
U_THETA_J2000 ≥ ≤ R_THETA_J2000 ≥ ≤
U_ERRTHETA_J2000 ≥ ≤ R_ERRTHETA_J2000 ≥ ≤
U_ISOAREA_IMAGE ≥ ≤ R_ISOAREA_IMAGE ≥ ≤
U_MU_MAX ≥ ≤ R_MU_MAX ≥ ≤
U_FLUX_RADIUS ≥ ≤ R_FLUX_RADIUS ≥ ≤
U_FLAGS ≥ ≤ R_FLAGS ≥ ≤
U_MAG_2ARC ≥ ≤ R_MAG_2ARC ≥ ≤
U_MAGERR_2ARC ≥ ≤ R_MAGERR_2ARC ≥ ≤
U_MAGLIM_2ARC ≥ ≤ R_MAGLIM_2ARC ≥ ≤
U_MAGLIM_APAUTO ≥ ≤ R_MAGLIM_APAUTO ≥ ≤
U_MAGLIM_COG ≥ ≤ R_MAGLIM_COG ≥ ≤
U_MAG_BEST ≥ ≤ R_MAG_BEST ≥ ≤
U_MAGERR_BEST ≥ ≤ R_MAGERR_BEST ≥ ≤
U_MAG_APER_1 ≥ ≤ R_MAG_APER_1 ≥ ≤
U_MAG_APER_2 ≥ ≤ R_MAG_APER_2 ≥ ≤
U_MAG_APER_3 ≥ ≤ R_MAG_APER_3 ≥ ≤
U_MAG_APER_4 ≥ ≤ R_MAG_APER_4 ≥ ≤
U_MAG_APER_5 ≥ ≤ R_MAG_APER_5 ≥ ≤
U_MAG_APER_6 ≥ ≤ R_MAG_APER_6 ≥ ≤
U_MAG_APER_7 ≥ ≤ R_MAG_APER_7 ≥ ≤
U_MAG_APER_8 ≥ ≤ R_MAG_APER_8 ≥ ≤
U_MAG_APER_9 ≥ ≤ R_MAG_APER_9 ≥ ≤
U_MAG_APER_10 ≥ ≤ R_MAG_APER_10 ≥ ≤
U_MAG_APER_11 ≥ ≤ R_MAG_APER_11 ≥ ≤
U_MAG_APER_12 ≥ ≤ R_MAG_APER_12 ≥ ≤
U_MAG_APER_13 ≥ ≤ R_MAG_APER_13 ≥ ≤
U_MAG_APER_14 ≥ ≤ R_MAG_APER_14 ≥ ≤
U_MAG_APER_15 ≥ ≤ R_MAG_APER_15 ≥ ≤
U_MAG_APER_16 ≥ ≤ R_MAG_APER_16 ≥ ≤
U_MAG_APER_17 ≥ ≤ R_MAG_APER_17 ≥ ≤
U_MAG_APER_18 ≥ ≤ R_MAG_APER_18 ≥ ≤
U_MAG_APER_19 ≥ ≤ R_MAG_APER_19 ≥ ≤
U_MAG_APER_20 ≥ ≤ R_MAG_APER_20 ≥ ≤
U_MAGERR_APER_1 ≥ ≤ R_MAGERR_APER_1 ≥ ≤
U_MAGERR_APER_2 ≥ ≤ R_MAGERR_APER_2 ≥ ≤
U_MAGERR_APER_3 ≥ ≤ R_MAGERR_APER_3 ≥ ≤
U_MAGERR_APER_4 ≥ ≤ R_MAGERR_APER_4 ≥ ≤
U_MAGERR_APER_5 ≥ ≤ R_MAGERR_APER_5 ≥ ≤
U_MAGERR_APER_6 ≥ ≤ R_MAGERR_APER_6 ≥ ≤
U_MAGERR_APER_7 ≥ ≤ R_MAGERR_APER_7 ≥ ≤
U_MAGERR_APER_8 ≥ ≤ R_MAGERR_APER_8 ≥ ≤
U_MAGERR_APER_9 ≥ ≤ R_MAGERR_APER_9 ≥ ≤
U_MAGERR_APER_10 ≥ ≤ R_MAGERR_APER_10 ≥ ≤
U_MAGERR_APER_11 ≥ ≤ R_MAGERR_APER_11 ≥ ≤
U_MAGERR_APER_12 ≥ ≤ R_MAGERR_APER_12 ≥ ≤
U_MAGERR_APER_13 ≥ ≤ R_MAGERR_APER_13 ≥ ≤
U_MAGERR_APER_14 ≥ ≤ R_MAGERR_APER_14 ≥ ≤
U_MAGERR_APER_15 ≥ ≤ R_MAGERR_APER_15 ≥ ≤
U_MAGERR_APER_16 ≥ ≤ R_MAGERR_APER_16 ≥ ≤
U_MAGERR_APER_17 ≥ ≤ R_MAGERR_APER_17 ≥ ≤
U_MAGERR_APER_18 ≥ ≤ R_MAGERR_APER_18 ≥ ≤
U_MAGERR_APER_19 ≥ ≤ R_MAGERR_APER_19 ≥ ≤
U_MAGERR_APER_20 ≥ ≤ R_MAGERR_APER_20 ≥ ≤
UNIONS Pan-STARR DR2
include sky position as a returned column
RA:
Dec:
Use a: with sides
srcID ≥ ≤
catID ≥ ≤ objID ≥ ≤
ra ≥ ≤ dec ≥ ≤
Nmeas ≥ ≤
i_chp_aper ≥ ≤ z_chp_aper ≥ ≤
i_chp_aper_err ≥ ≤ z_chp_aper_err ≥ ≤
i_chp_kron ≥ ≤ z_chp_kron ≥ ≤
i_chp_kron_err ≥ ≤ z_chp_kron_err ≥ ≤
i_chp_psf ≥ ≤ z_chp_psf ≥ ≤
i_chp_psf_err ≥ ≤ z_chp_psf_err ≥ ≤
i_flags ≥ ≤ z_flags ≥ ≤
i_nwarp ≥ ≤ z_nwarp ≥ ≤
i_nwarp_good ≥ ≤ z_nwarp_good ≥ ≤
i_stk_aper ≥ ≤ z_stk_aper ≥ ≤
i_stk_aper_err ≥ ≤ z_stk_aper_err ≥ ≤
i_stk_kron ≥ ≤ z_stk_kron ≥ ≤
i_stk_kron_err ≥ ≤ z_stk_kron_err ≥ ≤
i_stk_psf ≥ ≤ z_stk_psf ≥ ≤
i_stk_psf_err ≥ ≤ z_stk_psf_err ≥ ≤
i_wrp_aper ≥ ≤ z_wrp_aper ≥ ≤
i_wrp_aper_err ≥ ≤ z_wrp_aper_err ≥ ≤
i_wrp_aper_nphot ≥ ≤ z_wrp_aper_nphot ≥ ≤
i_wrp_kron ≥ ≤ z_wrp_kron ≥ ≤
i_wrp_kron_err ≥ ≤ z_wrp_kron_err ≥ ≤
i_wrp_kron_nphot ≥ ≤ z_wrp_kron_nphot ≥ ≤
i_wrp_psf ≥ ≤ z_wrp_psf ≥ ≤
i_wrp_psf_err ≥ ≤ z_wrp_psf_err ≥ ≤
i_wrp_psf_nphot ≥ ≤ z_wrp_psf_nphot ≥ ≤
Pan-STARR 3PI
include sky position as a returned column
RA:
Dec:
Use a: with sides
id ≥ ≤
ra ≥ ≤ dec ≥ ≤
Nmeas ≥ ≤
g_chp_kron ≥ ≤ r_chp_kron ≥ ≤ i_chp_kron ≥ ≤ y_chp_kron ≥ ≤ z_chp_kron ≥ ≤
g_chp_kron_err ≥ ≤ r_chp_kron_err ≥ ≤ i_chp_kron_err ≥ ≤ y_chp_kron_err ≥ ≤ z_chp_kron_err ≥ ≤
g_chp_psf ≥ ≤ r_chp_psf ≥ ≤ i_chp_psf ≥ ≤ y_chp_psf ≥ ≤ z_chp_psf ≥ ≤
g_chp_psf_err ≥ ≤ r_chp_psf_err ≥ ≤ i_chp_psf_err ≥ ≤ y_chp_psf_err ≥ ≤ z_chp_psf_err ≥ ≤
g_flags ≥ ≤ r_flags ≥ ≤ i_flags ≥ ≤ y_flags ≥ ≤ z_flags ≥ ≤
g_ncode ≥ ≤ r_ncode ≥ ≤ i_ncode ≥ ≤ y_ncode ≥ ≤ z_ncode ≥ ≤
g_nwarp_good ≥ ≤ r_nwarp_good ≥ ≤ i_nwarp_good ≥ ≤ y_nwarp_good ≥ ≤ z_nwarp_good ≥ ≤
g_wrp_kron ≥ ≤ r_wrp_kron ≥ ≤ i_wrp_kron ≥ ≤ y_wrp_kron ≥ ≤ z_wrp_kron ≥ ≤
g_wrp_kron_err ≥ ≤ r_wrp_kron_err ≥ ≤ i_wrp_kron_err ≥ ≤ y_wrp_kron_err ≥ ≤ z_wrp_kron_err ≥ ≤
g_wrp_psf ≥ ≤ r_wrp_psf ≥ ≤ i_wrp_psf ≥ ≤ y_wrp_psf ≥ ≤ z_wrp_psf ≥ ≤
g_wrp_psf_err ≥ ≤ r_wrp_psf_err ≥ ≤ i_wrp_psf_err ≥ ≤ y_wrp_psf_err ≥ ≤ z_wrp_psf_err ≥ ≤
GAIA EDR3
include sky position as a returned column
RA:
Dec:
Use a: with sides
solution_id ≥ ≤
source_id ≥ ≤
ref_epoch ≥ ≤
ra ≥ ≤
ra_error ≥ ≤
dec ≥ ≤
dec_error ≥ ≤
parallax ≥ ≤
parallax_error ≥ ≤
pmra ≥ ≤
pmra_error ≥ ≤
pmdec ≥ ≤
pmdec_error ≥ ≤
ra_dec_corr ≥ ≤
ra_parallax_corr ≥ ≤
ra_pmra_corr ≥ ≤
ra_pmdec_corr ≥ ≤
dec_parallax_corr ≥ ≤
dec_pmra_corr ≥ ≤
dec_pmdec_corr ≥ ≤
parallax_pmra_corr ≥ ≤
parallax_pmdec_corr ≥ ≤
pmra_pmdec_corr ≥ ≤
phot_g_n_obs ≥ ≤
phot_g_mean_mag ≥ ≤
phot_bp_n_obs ≥ ≤
phot_bp_mean_mag ≥ ≤
phot_rp_n_obs ≥ ≤
phot_rp_mean_mag ≥ ≤
a_g_val ≥ ≤
e_bp_min_rp_val ≥ ≤
astrometric_n_good_obs_al ≥ ≤
astrometric_chi2_al ≥ ≤
astrometric_excess_noise ≥ ≤
visibility_periods_used ≥ ≤
phot_g_mean_flux ≥ ≤
phot_g_mean_flux_error ≥ ≤
phot_bp_mean_flux ≥ ≤
phot_bp_mean_flux_error ≥ ≤
phot_rp_mean_flux ≥ ≤
phot_rp_mean_flux_error ≥ ≤
phot_bp_rp_excess_factor ≥ ≤
phot_variable_flag ≥ ≤
SDSS DR16
include sky position as a returned column
RA:
Dec:
Use a: with sides
ra ≥ ≤
dec ≥ ≤
objid ≥ ≤
psfMag_g ≥ ≤
psfMag_i ≥ ≤
psfMag_r ≥ ≤
psfMag_u ≥ ≤
psfMag_z ≥ ≤
psfMagErr_g ≥ ≤
psfMagErr_i ≥ ≤
psfMagErr_r ≥ ≤
psfMagErr_u ≥ ≤
psfMagErr_z ≥ ≤
petroR50_r ≥ ≤
probPSF ≥ ≤
CADC For questions concerning these webpages, please contact the CADC (support@canfar.net).
For questions about the data itself please contact the data processors: Stephen Gwyn (stephen.gwyn@nrc-cnrc.gc.ca), Eugene Magnier (eugene@ifa.hawaii.edu) Hisanori Furusawa (furusawa.hisanori@nao.ac.jp)