Euclid Q1: MER catalogs#

Learning Goals#

By the end of this tutorial, you will:

Understand the basic characteristics of Euclid Q1 MER catalogs.
What columns are available in the MER catalog.
How to query with ADQL in the MER catalog.
How to make a simple color-magnitude diagram with the data.

Introduction#

Euclid launched in July 2023 as a European Space Agency (ESA) mission with involvement by NASA. The primary science goals of Euclid are to better understand the composition and evolution of the dark Universe. The Euclid mission is providing space-based imaging and spectroscopy as well as supporting ground-based imaging to achieve these primary goals. These data will be archived by multiple global repositories, including IRSA, where they will support transformational work in many areas of astrophysics.

Euclid Quick Release 1 (Q1) consists of consists of ~30 TB of imaging, spectroscopy, and catalogs covering four non-contiguous fields: Euclid Deep Field North (22.9 sq deg), Euclid Deep Field Fornax (12.1 sq deg), Euclid Deep Field South (28.1 sq deg), and LDN1641.

Among the data products included in the Q1 release are the three MER catalogs: the final catalog, the morphology catalog, and the cutouts catalog. This notebook provides an introduction to the MER final catalog. Each entry is a single source with associated photometry from the multiwavelength MER Mosaics (VIS, Y, J, H, and any accompanying external ground-based measurements), along with other basic measurements, like size and shape. If you have questions about this notebook, please contact the IRSA helpdesk.

Imports#

# Uncomment the next line to install dependencies if needed
# !pip install numpy matplotlib 'astroquery>=0.4.10'

import numpy as np
import matplotlib.pyplot as plt

from astroquery.ipac.irsa import Irsa

1. Download MER catalog from IRSA directly to this notebook#

First, have a look at what Euclid catalogs are available. With the list_catalogs functionality, we’ll receive a list of the name of the catalogs as well as their brief desciption.

Irsa.list_catalogs(filter='euclid')

{'euclid_q1_mer_catalogue': 'Euclid Q1 MER Catalog',
 'euclid_q1_mer_morphology': 'Euclid Q1 MER Morphology',
 'euclid_q1_mer_cutouts': 'Euclid Q1 MER Cutouts',
 'euclid_q1_phz_photo_z': 'Euclid Q1 PHZ Photo-z Catalog',
 'euclid_q1_phz_classification': 'Euclid Q1 PHZ Classification Catalog',
 'euclid_q1_phz_galaxy_sed': 'Euclid Q1 PHZ Galaxy SED Catalog',
 'euclid_q1_phz_star_sed': 'Euclid Q1 PHZ Star SED Catalog',
 'euclid_q1_phz_star_template': 'Euclid Q1 PHZ Star Template Catalog',
 'euclid_q1_spectro_zcatalog_spe_quality': 'Euclid Q1 SPE Redshift Catalog - Quality',
 'euclid_q1_spectro_zcatalog_spe_classification': 'Euclid Q1 SPE Redshift Catalog - Classification',
 'euclid_q1_spectro_zcatalog_spe_galaxy_candidates': 'Euclid Q1 SPE Redshift Catalog - Galaxy Candidates',
 'euclid_q1_spectro_zcatalog_spe_star_candidates': 'Euclid Q1 SPE Redshift Catalog - Star Candidates',
 'euclid_q1_spectro_zcatalog_spe_qso_candidates': 'Euclid Q1 SPE Redshift Catalog - QSO Candidates',
 'euclid_q1_spe_lines_line_features': 'Euclid Q1 SPE Lines Catalog - Spectral Lines',
 'euclid_q1_spe_lines_continuum_features': 'Euclid Q1 SPE Lines Catalog - Continuum Features',
 'euclid_q1_spe_lines_atomic_indices': 'Euclid Q1 SPE Lines Catalog - Atomic Indices',
 'euclid_q1_spe_lines_molecular_indices': 'Euclid Q1 SPE Lines Catalog - Molecular Indices',
 'euclid.tileid_association_q1': 'Euclid Q1 TILEID to Observation ID Association Table',
 'euclid.objectid_spectrafile_association_q1': 'Euclid Q1 Object ID to Spectral File Association Table',
 'euclid.observation_euclid_q1': 'Euclid Q1 CAOM Observation Table',
 'euclid.plane_euclid_q1': 'Euclid Q1 CAOM Plane Table',
 'euclid.artifact_euclid_q1': 'Euclid Q1 CAOM Artifact Table'}

Choose the Euclid MER table#

table_mer = 'euclid_q1_mer_catalogue'

Learn some information about the MER catalog:#

How many columns are there?
List the column names

columns_info = Irsa.list_columns(catalog=table_mer)
print(len(columns_info))

columns_info

{'fluxerr_z_ext_panstarrs_sersic': 'Zext PS band source flux error from the Sersic fit',
 'fluxerr_g_ext_hsc_sersic': 'Gext HSC band source flux error from the Sersic fit',
 'fluxerr_z_ext_hsc_sersic': 'Zext HSC band source flux error from the Sersic fit',
 'flux_vis_disk_sersic': 'VIS band source flux from the Disk+Sersic fit',
 'flux_y_disk_sersic': 'NIR Y band source flux from the Disk+Sersic fit',
 'flux_j_disk_sersic': 'NIR J band source flux from the Disk+Sersic fit',
 'flux_h_disk_sersic': 'NIR H band source flux from the Disk+Sersic fit',
 'flux_u_ext_decam_disk_sersic': 'Uext DECam band source flux from the Disk+Sersic fit',
 'flux_g_ext_decam_disk_sersic': 'Gext DECam band source flux from the Disk+Sersic fit',
 'flux_r_ext_decam_disk_sersic': 'Rext DECam band source flux from the Disk+Sersic fit',
 'flux_i_ext_decam_disk_sersic': 'Iext DECam band source flux from the Disk+Sersic fit',
 'flux_z_ext_decam_disk_sersic': 'Zext DECam band source flux from the Disk+Sersic fit',
 'flux_u_ext_lsst_disk_sersic': 'Uext LSST band source flux from the Disk+Sersic fit',
 'flux_g_ext_lsst_disk_sersic': 'Gext LSST band source flux from the Disk+Sersic fit',
 'flux_r_ext_lsst_disk_sersic': 'Rext LSST band source flux from the Disk+Sersic fit',
 'flux_i_ext_lsst_disk_sersic': 'Iext LSST band source flux from the Disk+Sersic fit',
 'flux_z_ext_lsst_disk_sersic': 'Zext LSST band source flux from the Disk+Sersic fit',
 'flux_u_ext_megacam_disk_sersic': 'Uext Megacam band source flux from the Disk+Sersic fit',
 'flux_r_ext_megacam_disk_sersic': 'Rext Megacam band source flux from the Disk+Sersic fit',
 'flux_g_ext_jpcam_disk_sersic': 'Gext JPCAM band source flux from the Disk+Sersic fit',
 'flux_i_ext_panstarrs_disk_sersic': 'Iext PS band source flux from the Disk+Sersic fit',
 'flux_z_ext_panstarrs_disk_sersic': 'Zext PS band source flux from the Disk+Sersic fit',
 'flux_g_ext_hsc_disk_sersic': 'Gext HSC band source flux from the Disk+Sersic fit',
 'flux_z_ext_hsc_disk_sersic': 'Zext HSC band source flux from the Disk+Sersic fit',
 'fluxerr_vis_disk_sersic': 'VIS band source flux error from the Disk+Sersic fit',
 'fluxerr_y_disk_sersic': 'NIR Y band source flux error from the Disk+Sersic fit',
 'fluxerr_j_disk_sersic': 'NIR J band source flux error from the Disk+Sersic fit',
 'fluxerr_h_disk_sersic': 'NIR H band source flux error from the Disk+Sersic fit',
 'fluxerr_u_ext_decam_disk_sersic': 'Uext DECam band source flux error from the Disk+Sersic fit',
 'fluxerr_g_ext_decam_disk_sersic': 'Gext DECam band source flux error from the Disk+Sersic fit',
 'fluxerr_r_ext_decam_disk_sersic': 'Rext DECam band source flux error from the Disk+Sersic fit',
 'fluxerr_i_ext_decam_disk_sersic': 'Iext DECam band source flux error from the Disk+Sersic fit',
 'fluxerr_z_ext_decam_disk_sersic': 'Zext DECam band source flux error from the Disk+Sersic fit',
 'fluxerr_u_ext_lsst_disk_sersic': 'Uext LSST band source flux error from the Disk+Sersic fit',
 'fluxerr_g_ext_lsst_disk_sersic': 'Gext LSST band source flux error from the Disk+Sersic fit',
 'fluxerr_r_ext_lsst_disk_sersic': 'Rext LSST band source flux error from the Disk+Sersic fit',
 'fluxerr_i_ext_lsst_disk_sersic': 'Iext LSST band source flux error from the Disk+Sersic fit',
 'fluxerr_z_ext_lsst_disk_sersic': 'Zext LSST band source flux error from the Disk+Sersic fit',
 'fluxerr_u_ext_megacam_disk_sersic': 'Uext Megacam band source flux error from the Disk+Sersic fit',
 'fluxerr_r_ext_megacam_disk_sersic': 'Rext Megacam band source flux error from the Disk+Sersic fit',
 'fluxerr_g_ext_jpcam_disk_sersic': 'Gext JPCAM band source flux error from the Disk+Sersic fit',
 'fluxerr_i_ext_panstarrs_disk_sersic': 'Iext PS band source flux error from the Disk+Sersic fit',
 'fluxerr_z_ext_panstarrs_disk_sersic': 'Zext PS band source flux error from the Disk+Sersic fit',
 'fluxerr_g_ext_hsc_disk_sersic': 'Gext HSC band source flux error from the Disk+Sersic fit',
 'fluxerr_z_ext_hsc_disk_sersic': 'Zext HSC band source flux error from the Disk+Sersic fit',
 'sersic_fract_vis_disk_sersic': 'VIS band Sersic fraction',
 'sersic_fract_y_disk_sersic': 'NIR Y band Sersic fraction',
 'sersic_fract_j_disk_sersic': 'NIR J band Sersic fraction',
 'sersic_fract_h_disk_sersic': 'NIR H band Sersic fraction',
 'sersic_fract_u_ext_decam_disk_sersic': 'Uext DECam band Sersic fraction',
 'sersic_fract_g_ext_decam_disk_sersic': 'Gext DECam band Sersic fraction',
 'sersic_fract_r_ext_decam_disk_sersic': 'Rext DECam band Sersic fraction',
 'sersic_fract_i_ext_decam_disk_sersic': 'Iext DECam band Sersic fraction',
 'sersic_fract_z_ext_decam_disk_sersic': 'Zext DECam band Sersic fraction',
 'sersic_fract_u_ext_lsst_disk_sersic': 'Uext LSST band Sersic fraction',
 'sersic_fract_g_ext_lsst_disk_sersic': 'Gext LSST band Sersic fraction',
 'sersic_fract_r_ext_lsst_disk_sersic': 'Rext LSST band Sersic fraction',
 'sersic_fract_i_ext_lsst_disk_sersic': 'Iext LSST band Sersic fraction',
 'sersic_fract_z_ext_lsst_disk_sersic': 'Zext LSST band Sersic fraction',
 'sersic_fract_u_ext_megacam_disk_sersic': 'Uext Megacam band Sersic fraction',
 'sersic_fract_r_ext_megacam_disk_sersic': 'Rext Megacam band Sersic fraction',
 'sersic_fract_g_ext_jpcam_disk_sersic': 'Gext JPCAM band Sersic fraction',
 'sersic_fract_i_ext_panstarrs_disk_sersic': 'Iext PS band Sersic fraction',
 'sersic_fract_z_ext_panstarrs_disk_sersic': 'Zext PS band Sersic fraction',
 'sersic_fract_g_ext_hsc_disk_sersic': 'Gext HSC band Sersic fraction',
 'sersic_fract_z_ext_hsc_disk_sersic': 'Zext HSC band Sersic fraction',
 'sersic_fract_vis_disk_sersic_err': 'VIS band Sersic fraction error',
 'sersic_fract_y_disk_sersic_err': 'NIR Y band Sersic fraction error',
 'sersic_fract_j_disk_sersic_err': 'NIR J band Sersic fraction error',
 'sersic_fract_h_disk_sersic_err': 'NIR H band Sersic fraction error',
 'sersic_fract_u_ext_decam_disk_sersic_err': 'Uext DECam band Sersic fraction error',
 'sersic_fract_g_ext_decam_disk_sersic_err': 'Gext DECam band Sersic fraction error',
 'sersic_fract_r_ext_decam_disk_sersic_err': 'Rext DECam band Sersic fraction error',
 'sersic_fract_i_ext_decam_disk_sersic_err': 'Iext DECam band Sersic fraction error',
 'sersic_fract_z_ext_decam_disk_sersic_err': 'Zext DECam band Sersic fraction error',
 'sersic_fract_u_ext_lsst_disk_sersic_err': 'Uext LSST band Sersic fraction error',
 'sersic_fract_g_ext_lsst_disk_sersic_err': 'Gext LSST band Sersic fraction error',
 'sersic_fract_r_ext_lsst_disk_sersic_err': 'Rext LSST band Sersic fraction error',
 'sersic_fract_i_ext_lsst_disk_sersic_err': 'Iext LSST band Sersic fraction error',
 'sersic_fract_z_ext_lsst_disk_sersic_err': 'Zext LSST band Sersic fraction error',
 'sersic_fract_u_ext_megacam_disk_sersic_err': 'Uext Megacam band Sersic fraction error',
 'sersic_fract_r_ext_megacam_disk_sersic_err': 'Rext Megacam band Sersic fraction error',
 'sersic_fract_g_ext_jpcam_disk_sersic_err': 'Gext JPCAM band Sersic fraction error',
 'sersic_fract_i_ext_panstarrs_disk_sersic_err': 'Iext PS band Sersic fraction error',
 'sersic_fract_z_ext_panstarrs_disk_sersic_err': 'Zext PS band Sersic fraction error',
 'sersic_fract_g_ext_hsc_disk_sersic_err': 'Gext HSC band Sersic fraction error',
 'sersic_fract_z_ext_hsc_disk_sersic_err': 'Zext HSC band Sersic fraction error',
 'flag_vis': 'Objects flag keeping track of the flagged pixels in the VIS flag image',
 'flag_y': 'Objects flag keeping track of the flagged pixels in the NIR Y flag image',
 'flag_j': 'Objects flag keeping track of the flagged pixels in the NIR J flag image',
 'flag_h': 'Objects flag keeping track of the flagged pixels in the NIR H flag image',
 'flag_nir_stack': 'Objects flag keeping track of the flagged pixels in the NIR stack flag image',
 'flag_u_ext_decam': 'Objects flag keeping track of the flagged pixels in the UextDECam flag image',
 'flag_g_ext_decam': 'Objects flag keeping track of the flagged pixels in the GextDECam flag image',
 'flag_r_ext_decam': 'Objects flag keeping track of the flagged pixels in the RextDECam flag image',
 'flag_i_ext_decam': 'Objects flag keeping track of the flagged pixels in the IextDECam flag image',
 'flag_z_ext_decam': 'Objects flag keeping track of the flagged pixels in the ZextDECam flag image',
 'flag_u_ext_lsst': 'Objects flag keeping track of the flagged pixels in the Uext LSST flag image',
 'flag_g_ext_lsst': 'Objects flag keeping track of the flagged pixels in the Gext LSST flag image',
 'flag_r_ext_lsst': 'Objects flag keeping track of the flagged pixels in the Rext LSST flag image',
 'flag_i_ext_lsst': 'Objects flag keeping track of the flagged pixels in the Iext LSST flag image',
 'flag_z_ext_lsst': 'Objects flag keeping track of the flagged pixels in the Zext LSST flag image',
 'flag_u_ext_megacam': 'Objects flag keeping track of the flagged pixels in the Uext Megacam flag image',
 'flag_r_ext_megacam': 'Objects flag keeping track of the flagged pixels in the Rext Megacam flag image',
 'flag_g_ext_jpcam': 'Objects flag keeping track of the flagged pixels in the Gext JPCAM flag image',
 'flag_i_ext_panstarrs': 'Objects flag keeping track of the flagged pixels in the Iext PS flag image',
 'flag_z_ext_panstarrs': 'Objects flag keeping track of the flagged pixels in the Zext PS flag image',
 'flag_g_ext_hsc': 'Objects flag keeping track of the flagged pixels in the Gext HSC flag image',
 'flag_z_ext_hsc': 'Objects flag keeping track of the flagged pixels in the Zext HSC flag image',
 'avg_trans_wave_vis': 'Average filter transmission curve wavelength for the VIS band',
 'avg_trans_wave_y': 'Average filter transmission curve wavelength for the NIR Y band',
 'avg_trans_wave_j': 'Average filter transmission curve wavelength for the NIR J band',
 'avg_trans_wave_h': 'Average filter transmission curve wavelength for the NIR H band',
 'avg_trans_wave_u_ext_decam': 'Average filter transmission curve wavelength for the DECam U band',
 'avg_trans_wave_g_ext_decam': 'Average filter transmission curve wavelength for the DECam G band',
 'avg_trans_wave_r_ext_decam': 'Average filter transmission curve wavelength for the DECam R band',
 'avg_trans_wave_i_ext_decam': 'Average filter transmission curve wavelength for the DECam I band',
 'avg_trans_wave_z_ext_decam': 'Average filter transmission curve wavelength for the DECam Z band',
 'avg_trans_wave_u_ext_lsst': 'Average filter transmission curve wavelength for the LSST U band',
 'avg_trans_wave_g_ext_lsst': 'Average filter transmission curve wavelength for the LSST G band',
 'avg_trans_wave_r_ext_lsst': 'Average filter transmission curve wavelength for the LSST R band',
 'avg_trans_wave_i_ext_lsst': 'Average filter transmission curve wavelength for the LSST I band',
 'avg_trans_wave_z_ext_lsst': 'Average filter transmission curve wavelength for the LSST Z band',
 'avg_trans_wave_u_ext_megacam': 'Average filter transmission curve wavelength for the Megacam U band',
 'avg_trans_wave_r_ext_megacam': 'Average filter transmission curve wavelength for the Megacam R band',
 'avg_trans_wave_g_ext_jpcam': 'Average filter transmission curve wavelength for the JPCAM G band',
 'avg_trans_wave_i_ext_panstarrs': 'Average filter transmission curve wavelength for the PS I band',
 'avg_trans_wave_z_ext_panstarrs': 'Average filter transmission curve wavelength for the PS Z band',
 'avg_trans_wave_g_ext_hsc': 'Average filter transmission curve wavelength for the HSC G band',
 'avg_trans_wave_z_ext_hsc': 'Average filter transmission curve wavelength for the HSC Z band',
 'deblended_flag': 'Flag marking if the object was originally blended with another one',
 'parent_id': 'ID of the parent sources of a deblended object',
 'parent_visnir': 'ID of the parent sources of a deblended object',
 'blended_prob': 'Probability that the source is blended with another source',
 'she_flag': 'Flags for objects SHE might want to remove (eg. bright stars)',
 'variable_flag': 'Object variability flag',
 'binary_flag': 'Flag for potentially binary stars',
 'point_like_flag': '"Point-like flag : flag set to 1 for VIS detections with (DET_QUALITY_FLAG==0) AND (POINT_LIKE_PROBA>threshold), otherwise set to NaN"',
 'point_like_prob': "Probability between 0 and 1 that the source is point-like (the estimation uses a 'star probability cub' defined in the MDB). Value is set to NaN for ...",
 'extended_flag': 'Extended source flag',
 'extended_prob': 'Probability between 0 and 1 that the source is extended',
 'spurious_flag': 'Spurious source flag',
 'spurious_prob': 'Probability between 0 and 1 that the source is spurious',
 'mag_stargal_sep': 'Magnitude used to compute POINT_LIKE_PROB',
 'det_quality_flag': 'Detection step flags that could indicate the possible corruption of the MAG_STARGAL_SEP values',
 'mu_max': 'Peak surface brightness above the background in the detection band (directly from SExtractor)',
 'mumax_minus_mag': '"The difference between MU_MAX and MAG_STARGAL_SEP, valid even for NIR-only sources"',
 'segmentation_area': 'Isophotal area of the source above the analysis threshold (SExtractor ISOAREA_IMAGE)',
 'semimajor_axis': 'Semi-major axis of the source (from Asterism)',
 'semimajor_axis_err': 'Semi-major axis error',
 'position_angle': 'Position angle (CCW/x) of the source (SExtractor THETA_IMAGE) range: -90 up to +90 decimal degrees',
 'position_angle_err': 'Position angle error',
 'ellipticity': '"A parametrization of how stretched an object is in the detection band, computed from the minor and major axes of the object itself (directly from SExt..."',
 'ellipticity_err': 'Ellipticity error',
 'kron_radius': 'Major semi-axis (in pixels) of the elliptical aperture used for total (Kron) aperture photometry on the detection image',
 'kron_radius_err': 'Error on the major semi-axis (in pixels) of the elliptical aperture used for total (Kron) aperture photometry on the detection image',
 'fwhm': '"FWHM (in arcsec) used in a-phot to compute colors. A-phot fluxes are computed within apertures that are multiples (1, 2, 3, 4 times) of this FWHM"',
 'gal_ebv': 'Estimated galactic E(B-V) at the source centroid according to the reference Planck map',
 'gal_ebv_err': 'Error on galactic E(B-V) according to the reference Planck map',
 'gaia_id': 'The associated GAIA source id',
 'gaia_match_quality': 'The quality of the GAIA match',
 'tileid': 'Euclid Tile ID',
 'x': 'Unit sphere (x,y,z) position x value',
 'y': 'Unit sphere (x,y,z) position y value',
 'z': 'Unit sphere (x,y,z) position z value',
 'spt_ind': 'Spatial (x,y,z) index key',
 'htm20': 'HTM spatial (x,y,z) index key',
 'cntr': '',
 'object_id': 'Euclid unique source identifier',
 'ra': 'Source barycenter RA coordinate (SExtractor ALPHA_J2000) decimal degrees',
 'dec': 'Source barycenter DEC coordinate (SExtractor DELTA_J2000) decimal degrees',
 'right_ascension_psf_fitting': 'Source RA coordinate derived by the PSF-fitting photometry method',
 'declination_psf_fitting': 'Source DEC coordinate derived by the PSF-fitting photometry method',
 'segmentation_map_id': 'Source ID in the associated segmentation map',
 'vis_det': 'Flag to indicate if the source is detected in the VIS mosaic (1) or is only detected in the NIR mosaic (0)',
 'flux_vis_1fwhm_aper': 'VIS band source aperture photometry flux (1 FWHM diameter) on PSF-matched images',
 'flux_vis_2fwhm_aper': 'VIS band source aperture photometry flux (2 FWHM diameter) on PSF-matched images',
 'flux_vis_3fwhm_aper': 'VIS band source aperture photometry flux (3 FWHM diameter) on PSF-matched images',
 'flux_vis_4fwhm_aper': 'VIS band source aperture photometry flux (4 FWHM diameter) on PSF-matched images',
 'flux_y_1fwhm_aper': 'NIR Y band source aperture photometry flux (1 FWHM diameter) on PSF-matched images',
 'flux_y_2fwhm_aper': 'NIR Y band source aperture photometry flux (2 FWHM diameter) on PSF-matched images',
 'flux_y_3fwhm_aper': 'NIR Y band source aperture photometry flux (3 FWHM diameter) on PSF-matched images',
 'flux_y_4fwhm_aper': 'NIR Y band source aperture photometry flux (4 FWHM diameter) on PSF-matched images',
 'flux_j_1fwhm_aper': 'NIR J band source aperture photometry flux (1 FWHM diameter) on PSF-matched images',
 'flux_j_2fwhm_aper': 'NIR J band source aperture photometry flux (2 FWHM diameter) on PSF-matched images',
 'flux_j_3fwhm_aper': 'NIR J band source aperture photometry flux (3 FWHM diameter) on PSF-matched images',
 'flux_j_4fwhm_aper': 'NIR J band source aperture photometry flux (4 FWHM diameter) on PSF-matched images',
 'flux_h_1fwhm_aper': 'NIR H band source aperture photometry flux (1 FWHM diameter) on PSF-matched images',
 'flux_h_2fwhm_aper': 'NIR H band source aperture photometry flux (2 FWHM diameter) on PSF-matched images',
 'flux_h_3fwhm_aper': 'NIR H band source aperture photometry flux (3 FWHM diameter) on PSF-matched images',
 'flux_h_4fwhm_aper': 'NIR H band source aperture photometry flux (4 FWHM diameter) on PSF-matched images',
 'flux_nir_stack_1fwhm_aper': 'NIR stack band source aperture photometry flux (1 FWHM diameter) on PSF-matched images',
 'flux_nir_stack_2fwhm_aper': 'NIR stack band source aperture photometry flux (2 FWHM diameter) on PSF-matched images',
 'flux_nir_stack_3fwhm_aper': 'NIR stack band source aperture photometry flux (3 FWHM diameter) on PSF-matched images',
 'flux_nir_stack_4fwhm_aper': 'NIR stack band source aperture photometry flux (4 FWHM diameter) on PSF-matched images',
 'flux_u_ext_decam_1fwhm_aper': 'Uext DECam band source aperture photometry flux (1 FWHM diameter) on PSF-matched images',
 'flux_u_ext_decam_2fwhm_aper': 'Uext DECam band source aperture photometry flux (2 FWHM diameter) on PSF-matched images',
 'flux_u_ext_decam_3fwhm_aper': 'Uext DECam band source aperture photometry flux (3 FWHM diameter) on PSF-matched images',
 'flux_u_ext_decam_4fwhm_aper': 'Uext DECam band source aperture photometry flux (4 FWHM diameter) on PSF-matched images',
 'flux_g_ext_decam_1fwhm_aper': 'Gext DECam band source aperture photometry flux (1 FWHM diameter) on PSF-matched images',
 'flux_g_ext_decam_2fwhm_aper': 'Gext DECam band source aperture photometry flux (2 FWHM diameter) on PSF-matched images',
 'flux_g_ext_decam_3fwhm_aper': 'Gext DECam band source aperture photometry flux (3 FWHM diameter) on PSF-matched images',
 'flux_g_ext_decam_4fwhm_aper': 'Gext DECam band source aperture photometry flux (4 FWHM diameter) on PSF-matched images',
 'flux_r_ext_decam_1fwhm_aper': 'Rext DECam band source aperture photometry flux (1 FWHM diameter) on PSF-matched images',
 'flux_r_ext_decam_2fwhm_aper': 'Rext DECam band source aperture photometry flux (2 FWHM diameter) on PSF-matched images',
 'flux_r_ext_decam_3fwhm_aper': 'Rext DECam band source aperture photometry flux (3 FWHM diameter) on PSF-matched images',
 'flux_r_ext_decam_4fwhm_aper': 'Rext DECam band source aperture photometry flux (4 FWHM diameter) on PSF-matched images',
 'flux_i_ext_decam_1fwhm_aper': 'Iext DECam band source aperture photometry flux (1 FWHM diameter) on PSF-matched images',
 'flux_i_ext_decam_2fwhm_aper': 'Iext DECam band source aperture photometry flux (2 FWHM diameter) on PSF-matched images',
 'flux_i_ext_decam_3fwhm_aper': 'Iext DECam band source aperture photometry flux (3 FWHM diameter) on PSF-matched images',
 'flux_i_ext_decam_4fwhm_aper': 'Iext DECam band source aperture photometry flux (4 FWHM diameter) on PSF-matched images',
 'flux_z_ext_decam_1fwhm_aper': 'Zext DECam band source aperture photometry flux (1 FWHM diameter) on PSF-matched images',
 'flux_z_ext_decam_2fwhm_aper': 'Zext DECam band source aperture photometry flux (2 FWHM diameter) on PSF-matched images',
 'flux_z_ext_decam_3fwhm_aper': 'Zext DECam band source aperture photometry flux (3 FWHM diameter) on PSF-matched images',
 'flux_z_ext_decam_4fwhm_aper': 'Zext DECam band source aperture photometry flux (4 FWHM diameter) on PSF-matched images',
 'flux_u_ext_lsst_1fwhm_aper': 'Uext LSST band source aperture photometry flux (1 FWHM diameter) on PSF-matched images',
 'flux_u_ext_lsst_2fwhm_aper': 'Uext LSST band source aperture photometry flux (2 FWHM diameter) on PSF-matched images',
 'flux_u_ext_lsst_3fwhm_aper': 'Uext LSST band source aperture photometry flux (3 FWHM diameter) on PSF-matched images',
 'flux_u_ext_lsst_4fwhm_aper': 'Uext LSST band source aperture photometry flux (4 FWHM diameter) on PSF-matched images',
 'flux_g_ext_lsst_1fwhm_aper': 'Gext LSST band source aperture photometry flux (1 FWHM diameter) on PSF-matched images',
 'flux_g_ext_lsst_2fwhm_aper': 'Gext LSST band source aperture photometry flux (2 FWHM diameter) on PSF-matched images',
 'flux_g_ext_lsst_3fwhm_aper': 'Gext LSST band source aperture photometry flux (3 FWHM diameter) on PSF-matched images',
 'flux_g_ext_lsst_4fwhm_aper': 'Gext LSST band source aperture photometry flux (4 FWHM diameter) on PSF-matched images',
 'flux_r_ext_lsst_1fwhm_aper': 'Rext LSST band source aperture photometry flux (1 FWHM diameter) on PSF-matched images',
 'flux_r_ext_lsst_2fwhm_aper': 'Rext LSST band source aperture photometry flux (2 FWHM diameter) on PSF-matched images',
 'flux_r_ext_lsst_3fwhm_aper': 'Rext LSST band source aperture photometry flux (3 FWHM diameter) on PSF-matched images',
 'flux_r_ext_lsst_4fwhm_aper': 'Rext LSST band source aperture photometry flux (4 FWHM diameter) on PSF-matched images',
 'flux_i_ext_lsst_1fwhm_aper': 'Iext LSST band source aperture photometry flux (1 FWHM diameter) on PSF-matched images',
 'flux_i_ext_lsst_2fwhm_aper': 'Iext LSST band source aperture photometry flux (2 FWHM diameter) on PSF-matched images',
 'flux_i_ext_lsst_3fwhm_aper': 'Iext LSST band source aperture photometry flux (3 FWHM diameter) on PSF-matched images',
 'flux_i_ext_lsst_4fwhm_aper': 'Iext LSST band source aperture photometry flux (4 FWHM diameter) on PSF-matched images',
 'flux_z_ext_lsst_1fwhm_aper': 'Zext LSST band source aperture photometry flux (1 FWHM diameter) on PSF-matched images',
 'flux_z_ext_lsst_2fwhm_aper': 'Zext LSST band source aperture photometry flux (2 FWHM diameter) on PSF-matched images',
 'flux_z_ext_lsst_3fwhm_aper': 'Zext LSST band source aperture photometry flux (3 FWHM diameter) on PSF-matched images',
 'flux_z_ext_lsst_4fwhm_aper': 'Zext LSST band source aperture photometry flux (4 FWHM diameter) on PSF-matched images',
 'flux_u_ext_megacam_1fwhm_aper': 'Uext Megacam band source aperture photometry flux (1 FWHM diameter) on PSF-matched images',
 'flux_u_ext_megacam_2fwhm_aper': 'Uext Megacam band source aperture photometry flux (2 FWHM diameter) on PSF-matched images',
 'flux_u_ext_megacam_3fwhm_aper': 'Uext Megacam band source aperture photometry flux (3 FWHM diameter) on PSF-matched images',
 'flux_u_ext_megacam_4fwhm_aper': 'Uext Megacam band source aperture photometry flux (4 FWHM diameter) on PSF-matched images',
 'flux_r_ext_megacam_1fwhm_aper': 'Rext Megacam band source aperture photometry flux (1 FWHM diameter) on PSF-matched images',
 'flux_r_ext_megacam_2fwhm_aper': 'Rext Megacam band source aperture photometry flux (2 FWHM diameter) on PSF-matched images',
 'flux_r_ext_megacam_3fwhm_aper': 'Rext Megacam band source aperture photometry flux (3 FWHM diameter) on PSF-matched images',
 'flux_r_ext_megacam_4fwhm_aper': 'Rext Megacam band source aperture photometry flux (4 FWHM diameter) on PSF-matched images',
 'flux_g_ext_jpcam_1fwhm_aper': 'Gext JPCAM band source aperture photometry flux (1 FWHM diameter) on PSF-matched images',
 'flux_g_ext_jpcam_2fwhm_aper': 'Gext JPCAM band source aperture photometry flux (2 FWHM diameter) on PSF-matched images',
 'flux_g_ext_jpcam_3fwhm_aper': 'Gext JPCAM band source aperture photometry flux (3 FWHM diameter) on PSF-matched images',
 'flux_g_ext_jpcam_4fwhm_aper': 'Gext JPCAM band source aperture photometry flux (4 FWHM diameter) on PSF-matched images',
 'flux_i_ext_panstarrs_1fwhm_aper': 'Iext PS band source aperture photometry flux (1 FWHM diameter) on PSF-matched images',
 'flux_i_ext_panstarrs_2fwhm_aper': 'Iext PS band source aperture photometry flux (2 FWHM diameter) on PSF-matched images',
 'flux_i_ext_panstarrs_3fwhm_aper': 'Iext PS band source aperture photometry flux (3 FWHM diameter) on PSF-matched images',
 'flux_i_ext_panstarrs_4fwhm_aper': 'Iext PS band source aperture photometry flux (4 FWHM diameter) on PSF-matched images',
 'flux_z_ext_panstarrs_1fwhm_aper': 'Zext PS band source aperture photometry flux (1 FWHM diameter) on PSF-matched images',
 'flux_z_ext_panstarrs_2fwhm_aper': 'Zext PS band source aperture photometry flux (2 FWHM diameter) on PSF-matched images',
 'flux_z_ext_panstarrs_3fwhm_aper': 'Zext PS band source aperture photometry flux (3 FWHM diameter) on PSF-matched images',
 'flux_z_ext_panstarrs_4fwhm_aper': 'Zext PS band source aperture photometry flux (4 FWHM diameter) on PSF-matched images',
 'flux_g_ext_hsc_1fwhm_aper': 'Gext HSC band source aperture photometry flux (1 FWHM diameter) on PSF-matched images',
 'flux_g_ext_hsc_2fwhm_aper': 'Gext HSC band source aperture photometry flux (2 FWHM diameter) on PSF-matched images',
 'flux_g_ext_hsc_3fwhm_aper': 'Gext HSC band source aperture photometry flux (3 FWHM diameter) on PSF-matched images',
 'flux_g_ext_hsc_4fwhm_aper': 'Gext HSC band source aperture photometry flux (4 FWHM diameter) on PSF-matched images',
 'flux_z_ext_hsc_1fwhm_aper': 'Zext HSC band source aperture photometry flux (1 FWHM diameter) on PSF-matched images',
 'flux_z_ext_hsc_2fwhm_aper': 'Zext HSC band source aperture photometry flux (2 FWHM diameter) on PSF-matched images',
 'flux_z_ext_hsc_3fwhm_aper': 'Zext HSC band source aperture photometry flux (3 FWHM diameter) on PSF-matched images',
 'flux_z_ext_hsc_4fwhm_aper': 'Zext HSC band source aperture photometry flux (4 FWHM diameter) on PSF-matched images',
 'fluxerr_vis_1fwhm_aper': 'VIS band source aperture photometry flux (1 FWHM diameter) on PSF-matched images error',
 'fluxerr_vis_2fwhm_aper': 'VIS band source aperture photometry flux (2 FWHM diameter) on PSF-matched images error',
 'fluxerr_vis_3fwhm_aper': 'VIS band source aperture photometry flux (3 FWHM diameter) on PSF-matched images error',
 'fluxerr_vis_4fwhm_aper': 'VIS band source aperture photometry flux (4 FWHM diameter) on PSF-matched images error',
 'fluxerr_y_1fwhm_aper': 'NIR Y band source aperture photometry flux (1 FWHM diameter) on PSF-matched images error',
 'fluxerr_y_2fwhm_aper': 'NIR Y band source aperture photometry flux (2 FWHM diameter) on PSF-matched images error',
 'fluxerr_y_3fwhm_aper': 'NIR Y band source aperture photometry flux (3 FWHM diameter) on PSF-matched images error',
 'fluxerr_y_4fwhm_aper': 'NIR Y band source aperture photometry flux (4 FWHM diameter) on PSF-matched images error',
 'fluxerr_j_1fwhm_aper': 'NIR J band source aperture photometry flux (1 FWHM diameter) on PSF-matched images error',
 'fluxerr_j_2fwhm_aper': 'NIR J band source aperture photometry flux (2 FWHM diameter) on PSF-matched images error',
 'fluxerr_j_3fwhm_aper': 'NIR J band source aperture photometry flux (3 FWHM diameter) on PSF-matched images error',
 'fluxerr_j_4fwhm_aper': 'NIR J band source aperture photometry flux (4 FWHM diameter) on PSF-matched images error',
 'fluxerr_h_1fwhm_aper': 'NIR H band source aperture photometry flux (1 FWHM diameter) on PSF-matched images error',
 'fluxerr_h_2fwhm_aper': 'NIR H band source aperture photometry flux (2 FWHM diameter) on PSF-matched images error',
 'fluxerr_h_3fwhm_aper': 'NIR H band source aperture photometry flux (3 FWHM diameter) on PSF-matched images error',
 'fluxerr_h_4fwhm_aper': 'NIR H band source aperture photometry flux (4 FWHM diameter) on PSF-matched images error',
 'fluxerr_nir_stack_1fwhm_aper': 'NIR stack band source aperture photometry flux (1 FWHM diameter) on PSF-matched images error',
 'fluxerr_nir_stack_2fwhm_aper': 'NIR stack band source aperture photometry flux (2 FWHM diameter) on PSF-matched images error',
 'fluxerr_nir_stack_3fwhm_aper': 'NIR stack band source aperture photometry flux (3 FWHM diameter) on PSF-matched images error',
 'fluxerr_nir_stack_4fwhm_aper': 'NIR stack band source aperture photometry flux (4 FWHM diameter) on PSF-matched images error',
 'fluxerr_u_ext_decam_1fwhm_aper': 'Uext DECam band source aperture photometry flux (1 FWHM diameter) on PSF-matched images error',
 'fluxerr_u_ext_decam_2fwhm_aper': 'Uext DECam band source aperture photometry flux (2 FWHM diameter) on PSF-matched images error',
 'fluxerr_u_ext_decam_3fwhm_aper': 'Uext DECam band source aperture photometry flux (3 FWHM diameter) on PSF-matched images error',
 'fluxerr_u_ext_decam_4fwhm_aper': 'Uext DECam band source aperture photometry flux (4 FWHM diameter) on PSF-matched images error',
 'fluxerr_g_ext_decam_1fwhm_aper': 'Gext DECam band source aperture photometry flux (1 FWHM diameter) on PSF-matched images error',
 'fluxerr_g_ext_decam_2fwhm_aper': 'Gext DECam band source aperture photometry flux (2 FWHM diameter) on PSF-matched images error',
 'fluxerr_g_ext_decam_3fwhm_aper': 'Gext DECam band source aperture photometry flux (3 FWHM diameter) on PSF-matched images error',
 'fluxerr_g_ext_decam_4fwhm_aper': 'Gext DECam band source aperture photometry flux (4 FWHM diameter) on PSF-matched images error',
 'fluxerr_r_ext_decam_1fwhm_aper': 'Rext DECam band source aperture photometry flux (1 FWHM diameter) on PSF-matched images error',
 'fluxerr_r_ext_decam_2fwhm_aper': 'Rext DECam band source aperture photometry flux (2 FWHM diameter) on PSF-matched images error',
 'fluxerr_r_ext_decam_3fwhm_aper': 'Rext DECam band source aperture photometry flux (3 FWHM diameter) on PSF-matched images error',
 'fluxerr_r_ext_decam_4fwhm_aper': 'Rext DECam band source aperture photometry flux (4 FWHM diameter) on PSF-matched images error',
 'fluxerr_i_ext_decam_1fwhm_aper': 'Iext DECam band source aperture photometry flux (1 FWHM diameter) on PSF-matched images error',
 'fluxerr_i_ext_decam_2fwhm_aper': 'Iext DECam band source aperture photometry flux (2 FWHM diameter) on PSF-matched images error',
 'fluxerr_i_ext_decam_3fwhm_aper': 'Iext DECam band source aperture photometry flux (3 FWHM diameter) on PSF-matched images error',
 'fluxerr_i_ext_decam_4fwhm_aper': 'Iext DECam band source aperture photometry flux (4 FWHM diameter) on PSF-matched images error',
 'fluxerr_z_ext_decam_1fwhm_aper': 'Zext DECam band source aperture photometry flux (1 FWHM diameter) on PSF-matched images error',
 'fluxerr_z_ext_decam_2fwhm_aper': 'Zext DECam band source aperture photometry flux (2 FWHM diameter) on PSF-matched images error',
 'fluxerr_z_ext_decam_3fwhm_aper': 'Zext DECam band source aperture photometry flux (3 FWHM diameter) on PSF-matched images error',
 'fluxerr_z_ext_decam_4fwhm_aper': 'Zext DECam band source aperture photometry flux (4 FWHM diameter) on PSF-matched images error',
 'fluxerr_u_ext_lsst_1fwhm_aper': 'Uext LSST band source aperture photometry flux (1 FWHM diameter) on PSF-matched images error',
 'fluxerr_u_ext_lsst_2fwhm_aper': 'Uext LSST band source aperture photometry flux (2 FWHM diameter) on PSF-matched images error',
 'fluxerr_u_ext_lsst_3fwhm_aper': 'Uext LSST band source aperture photometry flux (3 FWHM diameter) on PSF-matched images error',
 'fluxerr_u_ext_lsst_4fwhm_aper': 'Uext LSST band source aperture photometry flux (4 FWHM diameter) on PSF-matched images error',
 'fluxerr_g_ext_lsst_1fwhm_aper': 'Gext LSST band source aperture photometry flux (1 FWHM diameter) on PSF-matched images error',
 'fluxerr_g_ext_lsst_2fwhm_aper': 'Gext LSST band source aperture photometry flux (2 FWHM diameter) on PSF-matched images error',
 'fluxerr_g_ext_lsst_3fwhm_aper': 'Gext LSST band source aperture photometry flux (3 FWHM diameter) on PSF-matched images error',
 'fluxerr_g_ext_lsst_4fwhm_aper': 'Gext LSST band source aperture photometry flux (4 FWHM diameter) on PSF-matched images error',
 'fluxerr_r_ext_lsst_1fwhm_aper': 'Rext LSST band source aperture photometry flux (1 FWHM diameter) on PSF-matched images error',
 'fluxerr_r_ext_lsst_2fwhm_aper': 'Rext LSST band source aperture photometry flux (2 FWHM diameter) on PSF-matched images error',
 'fluxerr_r_ext_lsst_3fwhm_aper': 'Rext LSST band source aperture photometry flux (3 FWHM diameter) on PSF-matched images error',
 'fluxerr_r_ext_lsst_4fwhm_aper': 'Rext LSST band source aperture photometry flux (4 FWHM diameter) on PSF-matched images error',
 'fluxerr_i_ext_lsst_1fwhm_aper': 'Iext LSST band source aperture photometry flux (1 FWHM diameter) on PSF-matched images error',
 'fluxerr_i_ext_lsst_2fwhm_aper': 'Iext LSST band source aperture photometry flux (2 FWHM diameter) on PSF-matched images error',
 'fluxerr_i_ext_lsst_3fwhm_aper': 'Iext LSST band source aperture photometry flux (3 FWHM diameter) on PSF-matched images error',
 'fluxerr_i_ext_lsst_4fwhm_aper': 'Iext LSST band source aperture photometry flux (4 FWHM diameter) on PSF-matched images error',
 'fluxerr_z_ext_lsst_1fwhm_aper': 'Zext LSST band source aperture photometry flux (1 FWHM diameter) on PSF-matched images error',
 'fluxerr_z_ext_lsst_2fwhm_aper': 'Zext LSST band source aperture photometry flux (2 FWHM diameter) on PSF-matched images error',
 'fluxerr_z_ext_lsst_3fwhm_aper': 'Zext LSST band source aperture photometry flux (3 FWHM diameter) on PSF-matched images error',
 'fluxerr_z_ext_lsst_4fwhm_aper': 'Zext LSST band source aperture photometry flux (4 FWHM diameter) on PSF-matched images error',
 'fluxerr_u_ext_megacam_1fwhm_aper': 'Uext Megacam band source aperture photometry flux (1 FWHM diameter) on PSF-matched images error',
 'fluxerr_u_ext_megacam_2fwhm_aper': 'Uext Megacam band source aperture photometry flux (2 FWHM diameter) on PSF-matched images error',
 'fluxerr_u_ext_megacam_3fwhm_aper': 'Uext Megacam band source aperture photometry flux (3 FWHM diameter) on PSF-matched images error',
 'fluxerr_u_ext_megacam_4fwhm_aper': 'Uext Megacam band source aperture photometry flux (4 FWHM diameter) on PSF-matched images error',
 'fluxerr_r_ext_megacam_1fwhm_aper': 'Rext Megacam band source aperture photometry flux (1 FWHM diameter) on PSF-matched images error',
 'fluxerr_r_ext_megacam_2fwhm_aper': 'Rext Megacam band source aperture photometry flux (2 FWHM diameter) on PSF-matched images error',
 'fluxerr_r_ext_megacam_3fwhm_aper': 'Rext Megacam band source aperture photometry flux (3 FWHM diameter) on PSF-matched images error',
 'fluxerr_r_ext_megacam_4fwhm_aper': 'Rext Megacam band source aperture photometry flux (4 FWHM diameter) on PSF-matched images error',
 'fluxerr_g_ext_jpcam_1fwhm_aper': 'Gext JPCAM band source aperture photometry flux (1 FWHM diameter) on PSF-matched images error',
 'fluxerr_g_ext_jpcam_2fwhm_aper': 'Gext JPCAM band source aperture photometry flux (2 FWHM diameter) on PSF-matched images error',
 'fluxerr_g_ext_jpcam_3fwhm_aper': 'Gext JPCAM band source aperture photometry flux (3 FWHM diameter) on PSF-matched images error',
 'fluxerr_g_ext_jpcam_4fwhm_aper': 'Gext JPCAM band source aperture photometry flux (4 FWHM diameter) on PSF-matched images error',
 'fluxerr_i_ext_panstarrs_1fwhm_aper': 'Iext PS band source aperture photometry flux (1 FWHM diameter) on PSF-matched images error',
 'fluxerr_i_ext_panstarrs_2fwhm_aper': 'Iext PS band source aperture photometry flux (2 FWHM diameter) on PSF-matched images error',
 'fluxerr_i_ext_panstarrs_3fwhm_aper': 'Iext PS band source aperture photometry flux (3 FWHM diameter) on PSF-matched images error',
 'fluxerr_i_ext_panstarrs_4fwhm_aper': 'Iext PS band source aperture photometry flux (4 FWHM diameter) on PSF-matched images error',
 'fluxerr_z_ext_panstarrs_1fwhm_aper': 'Zext PS band source aperture photometry flux (1 FWHM diameter) on PSF-matched images error',
 'fluxerr_z_ext_panstarrs_2fwhm_aper': 'Zext PS band source aperture photometry flux (2 FWHM diameter) on PSF-matched images error',
 'fluxerr_z_ext_panstarrs_3fwhm_aper': 'Zext PS band source aperture photometry flux (3 FWHM diameter) on PSF-matched images error',
 'fluxerr_z_ext_panstarrs_4fwhm_aper': 'Zext PS band source aperture photometry flux (4 FWHM diameter) on PSF-matched images error',
 'fluxerr_g_ext_hsc_1fwhm_aper': 'Gext HSC band source aperture photometry flux (1 FWHM diameter) on PSF-matched images error',
 'fluxerr_g_ext_hsc_2fwhm_aper': 'Gext HSC band source aperture photometry flux (2 FWHM diameter) on PSF-matched images error',
 'fluxerr_g_ext_hsc_3fwhm_aper': 'Gext HSC band source aperture photometry flux (3 FWHM diameter) on PSF-matched images error',
 'fluxerr_g_ext_hsc_4fwhm_aper': 'Gext HSC band source aperture photometry flux (4 FWHM diameter) on PSF-matched images error',
 'fluxerr_z_ext_hsc_1fwhm_aper': 'Zext HSC band source aperture photometry flux (1 FWHM diameter) on PSF-matched images error',
 'fluxerr_z_ext_hsc_2fwhm_aper': 'Zext HSC band source aperture photometry flux (2 FWHM diameter) on PSF-matched images error',
 'fluxerr_z_ext_hsc_3fwhm_aper': 'Zext HSC band source aperture photometry flux (3 FWHM diameter) on PSF-matched images error',
 'fluxerr_z_ext_hsc_4fwhm_aper': 'Zext HSC band source aperture photometry flux (4 FWHM diameter) on PSF-matched images error',
 'flux_y_templfit': 'NIR Y band source template fitting flux (TPHOT measurement)',
 'flux_j_templfit': 'NIR J band source template fitting flux (TPHOT measurement)',
 'flux_h_templfit': 'NIR H band source template fitting flux (TPHOT measurement)',
 'flux_u_ext_decam_templfit': 'Uext DECam band source template fitting flux (TPHOT measurement)',
 'flux_g_ext_decam_templfit': 'Gext DECam band source template fitting flux (TPHOT measurement)',
 'flux_r_ext_decam_templfit': 'Rext DECam band source template fitting flux (TPHOT measurement)',
 'flux_i_ext_decam_templfit': 'Iext DECam band source template fitting flux (TPHOT measurement)',
 'flux_z_ext_decam_templfit': 'Zext DECam band source template fitting flux (TPHOT measurement)',
 'flux_u_ext_lsst_templfit': 'Uext LSST band source template fitting flux (TPHOT measurement)',
 'flux_g_ext_lsst_templfit': 'Gext LSST band source template fitting flux (TPHOT measurement)',
 'flux_r_ext_lsst_templfit': 'Rext LSST band source template fitting flux (TPHOT measurement)',
 'flux_i_ext_lsst_templfit': 'Iext LSST band source template fitting flux (TPHOT measurement)',
 'flux_z_ext_lsst_templfit': 'Zext LSST band source template fitting flux (TPHOT measurement)',
 'flux_u_ext_megacam_templfit': 'Uext Megacam band source template fitting flux (TPHOT measurement)',
 'flux_r_ext_megacam_templfit': 'Rext Megacam band source template fitting flux (TPHOT measurement)',
 'flux_g_ext_jpcam_templfit': 'Gext JPCAM band source template fitting flux (TPHOT measurement)',
 'flux_i_ext_panstarrs_templfit': 'Iext PS band source template fitting flux (TPHOT measurement)',
 'flux_z_ext_panstarrs_templfit': 'Zext PS band source template fitting flux (TPHOT measurement)',
 'flux_g_ext_hsc_templfit': 'Gext HSC band source template fitting flux (TPHOT measurement)',
 'flux_z_ext_hsc_templfit': 'Zext HSC band source template fitting flux (TPHOT measurement)',
 'fluxerr_y_templfit': 'NIR Y band source template fitting flux error (TPHOT measurement)',
 'fluxerr_j_templfit': 'NIR J band source template fitting flux error (TPHOT measurement)',
 'fluxerr_h_templfit': 'NIR H band source template fitting flux error (TPHOT measurement)',
 'fluxerr_u_ext_decam_templfit': 'Uext DECam band source template fitting flux error (TPHOT measurement)',
 'fluxerr_g_ext_decam_templfit': 'Gext DECam band source template fitting flux error (TPHOT measurement)',
 'fluxerr_r_ext_decam_templfit': 'Rext DECam band source template fitting flux error (TPHOT measurement)',
 'fluxerr_i_ext_decam_templfit': 'Iext DECam band source template fitting flux error (TPHOT measurement)',
 'fluxerr_z_ext_decam_templfit': 'Zext DECam band source template fitting flux error (TPHOT measurement)',
 'fluxerr_u_ext_lsst_templfit': 'Uext LSST band source template fitting flux error (TPHOT measurement)',
 'fluxerr_g_ext_lsst_templfit': 'Gext LSST band source template fitting flux error (TPHOT measurement)',
 'fluxerr_r_ext_lsst_templfit': 'Rext LSST band source template fitting flux error (TPHOT measurement)',
 'fluxerr_i_ext_lsst_templfit': 'Iext LSST band source template fitting flux error (TPHOT measurement)',
 'fluxerr_z_ext_lsst_templfit': 'Zext LSST band source template fitting flux error (TPHOT measurement)',
 'fluxerr_u_ext_megacam_templfit': 'Uext Megacam band source template fitting flux error (TPHOT measurement)',
 'fluxerr_r_ext_megacam_templfit': 'Rext Megacam band source template fitting flux error (TPHOT measurement)',
 'fluxerr_g_ext_jpcam_templfit': 'Gext JPCAM band source template fitting flux error (TPHOT measurement)',
 'fluxerr_i_ext_panstarrs_templfit': 'Iext PS band source template fitting flux error (TPHOT measurement)',
 'fluxerr_z_ext_panstarrs_templfit': 'Zext PS band source template fitting flux error (TPHOT measurement)',
 'fluxerr_g_ext_hsc_templfit': 'Gext HSC band source template fitting flux error (TPHOT measurement)',
 'fluxerr_z_ext_hsc_templfit': 'Zext HSC band source template fitting flux error (TPHOT measurement)',
 'flux_vis_to_y_templfit': 'VIS band source flux on a VIS image PSF-matched to NIR Y band (TPHOT measurement)',
 'flux_vis_to_j_templfit': 'VIS band source flux on a VIS image PSF-matched to NIR J band (TPHOT measurement)',
 'flux_vis_to_h_templfit': 'VIS band source flux on a VIS image PSF-matched to NIR H band (TPHOT measurement)',
 'flux_vis_to_u_ext_decam_templfit': 'VIS band source flux on a VIS image PSF-matched to Uext DECam band (TPHOT measurement)',
 'flux_vis_to_g_ext_decam_templfit': 'VIS band source flux on a VIS image PSF-matched to Gext DECam band (TPHOT measurement)',
 'flux_vis_to_r_ext_decam_templfit': 'VIS band source flux on a VIS image PSF-matched to Rext DECam band (TPHOT measurement)',
 'flux_vis_to_i_ext_decam_templfit': 'VIS band source flux on a VIS image PSF-matched to Iext DECam band (TPHOT measurement)',
 'flux_vis_to_z_ext_decam_templfit': 'VIS band source flux on a VIS image PSF-matched to Zext DECam band (TPHOT measurement)',
 'flux_vis_to_u_ext_lsst_templfit': 'VIS band source flux on a VIS image PSF-matched to Uext LSST band (TPHOT measurement)',
 'flux_vis_to_g_ext_lsst_templfit': 'VIS band source flux on a VIS image PSF-matched to Gext LSST band (TPHOT measurement)',
 'flux_vis_to_r_ext_lsst_templfit': 'VIS band source flux on a VIS image PSF-matched to Rext LSST band (TPHOT measurement)',
 'flux_vis_to_i_ext_lsst_templfit': 'VIS band source flux on a VIS image PSF-matched to Iext LSST band (TPHOT measurement)',
 'flux_vis_to_z_ext_lsst_templfit': 'VIS band source flux on a VIS image PSF-matched to Zext LSST band (TPHOT measurement)',
 'flux_vis_to_u_ext_megacam_templfit': 'VIS band source flux on a VIS image PSF-matched to Uext Megacam band (TPHOT measurement)',
 'flux_vis_to_r_ext_megacam_templfit': 'VIS band source flux on a VIS image PSF-matched to Rext Megacam band (TPHOT measurement)',
 'flux_vis_to_g_ext_jpcam_templfit': 'VIS band source flux on a VIS image PSF-matched to Gext JPCAM band (TPHOT measurement)',
 'flux_vis_to_i_ext_panstarrs_templfit': 'VIS band source flux on a VIS image PSF-matched to Iext PS band (TPHOT measurement)',
 'flux_vis_to_z_ext_panstarrs_templfit': 'VIS band source flux on a VIS image PSF-matched to Zext PS band (TPHOT measurement)',
 'flux_vis_to_g_ext_hsc_templfit': 'VIS band source flux on a VIS image PSF-matched to Gext HSC band (TPHOT measurement)',
 'flux_vis_to_z_ext_hsc_templfit': 'VIS band source flux on a VIS image PSF-matched to Zext HSC band (TPHOT measurement)',
 'fluxerr_vis_to_y_templfit': 'VIS band source flux error on a VIS image PSF-matched to NIR Y band (TPHOT measurement)',
 'fluxerr_vis_to_j_templfit': 'VIS band source flux error on a VIS image PSF-matched to NIR J bandr (TPHOT measurement)',
 'fluxerr_vis_to_h_templfit': 'VIS band source flux error on a VIS image PSF-matched to NIR H band (TPHOT measurement)',
 'fluxerr_vis_to_u_ext_decam_templfit': 'VIS band source flux error on a VIS image PSF-matched to Uext DECam band (TPHOT measurement)',
 'fluxerr_vis_to_g_ext_decam_templfit': 'VIS band source flux error on a VIS image PSF-matched to Gext DECam band (TPHOT measurement)',
 'fluxerr_vis_to_r_ext_decam_templfit': 'VIS band source flux error on a VIS image PSF-matched to Rext DECam band (TPHOT measurement)',
 'fluxerr_vis_to_i_ext_decam_templfit': 'VIS band source flux error on a VIS image PSF-matched to Iext DECam band (TPHOT measurement)',
 'fluxerr_vis_to_z_ext_decam_templfit': 'VIS band source flux error on a VIS image PSF-matched to Zext DECam band (TPHOT measurement)',
 'fluxerr_vis_to_u_ext_lsst_templfit': 'VIS band source flux error on a VIS image PSF-matched to Uext LSST band (TPHOT measurement)',
 'fluxerr_vis_to_g_ext_lsst_templfit': 'VIS band source flux error on a VIS image PSF-matched to Gext LSST band (TPHOT measurement)',
 'fluxerr_vis_to_r_ext_lsst_templfit': 'VIS band source flux error on a VIS image PSF-matched to Rext LSST band (TPHOT measurement)',
 'fluxerr_vis_to_i_ext_lsst_templfit': 'VIS band source flux error on a VIS image PSF-matched to Iext LSST band (TPHOT measurement)',
 'fluxerr_vis_to_z_ext_lsst_templfit': 'VIS band source flux error on a VIS image PSF-matched to Zext LSST band (TPHOT measurement)',
 'fluxerr_vis_to_u_ext_megacam_templfit': 'VIS band source flux error on a VIS image PSF-matched to Uext Megacam band (TPHOT measurement)',
 'fluxerr_vis_to_r_ext_megacam_templfit': 'VIS band source flux error on a VIS image PSF-matched to Rext Megacam band (TPHOT measurement)',
 'fluxerr_vis_to_g_ext_jpcam_templfit': 'VIS band source flux error on a VIS image PSF-matched to Gext JPCAM band (TPHOT measurement)',
 'fluxerr_vis_to_i_ext_panstarrs_templfit': 'VIS band source flux error on a VIS image PSF-matched to Iext PS band (TPHOT measurement)',
 'fluxerr_vis_to_z_ext_panstarrs_templfit': 'VIS band source flux error on a VIS image PSF-matched to Zext PS band (TPHOT measurement)',
 'fluxerr_vis_to_g_ext_hsc_templfit': 'VIS band source flux error on a VIS image PSF-matched to Gext HSC band (TPHOT measurement)',
 'fluxerr_vis_to_z_ext_hsc_templfit': 'VIS band source flux error on a VIS image PSF-matched to Zext HSC band (TPHOT measurement)',
 'flux_vis_psf': 'VIS band source PSF-fitting photometry flux (TPHOT measurement)',
 'fluxerr_vis_psf': 'VIS band source PSF-fitting photometry flux error (TPHOT measurement)',
 'flux_segmentation': 'VIS or NIR stack band source segmented area flux',
 'fluxerr_segmentation': 'VIS or NIR stack band source total flux (Kron aperture)',
 'flux_detection_total': 'VIS or NIR stack band source total flux error (Kron aperture)',
 'fluxerr_detection_total': 'VIS or NIR stack band source segmented area flux',
 'flux_vis_sersic': 'VIS band source flux from the Sersic fit',
 'flux_y_sersic': 'NIR Y band source flux from the Sersic fit',
 'flux_j_sersic': 'NIR J band source flux from the Sersic fit',
 'flux_h_sersic': 'NIR H band source flux from the Sersic fit',
 'flux_u_ext_decam_sersic': 'Uext DECam band source flux from the Sersic fit',
 'flux_g_ext_decam_sersic': 'Gext DECam band source flux from the Sersic fit',
 'flux_r_ext_decam_sersic': 'Rext DECam band source flux from the Sersic fit',
 'flux_i_ext_decam_sersic': 'Iext DECam band source flux from the Sersic fit',
 'flux_z_ext_decam_sersic': 'Zext DECam band source flux from the Sersic fit',
 'flux_u_ext_lsst_sersic': 'Uext LSST band source flux from the Sersic fit',
 'flux_g_ext_lsst_sersic': 'Gext LSST band source flux from the Sersic fit',
 'flux_r_ext_lsst_sersic': 'Rext LSST band source flux from the Sersic fit',
 'flux_i_ext_lsst_sersic': 'Iext LSST band source flux from the Sersic fit',
 'flux_z_ext_lsst_sersic': 'Zext LSST band source flux from the Sersic fit',
 'flux_u_ext_megacam_sersic': 'Uext Megacam band source flux from the Sersic fit',
 'flux_r_ext_megacam_sersic': 'Rext Megacam band source flux from the Sersic fit',
 'flux_g_ext_jpcam_sersic': 'Gext JPCAM band source flux from the Sersic fit',
 'flux_i_ext_panstarrs_sersic': 'Iext PS band source flux from the Sersic fit',
 'flux_z_ext_panstarrs_sersic': 'Zext PS band source flux from the Sersic fit',
 'flux_g_ext_hsc_sersic': 'Gext HSC band source flux from the Sersic fit',
 'flux_z_ext_hsc_sersic': 'Zext HSC band source flux from the Sersic fit',
 'fluxerr_vis_sersic': 'VIS band source flux error from the Sersic fit',
 'fluxerr_y_sersic': 'NIR Y band source flux error from the Sersic fit',
 'fluxerr_j_sersic': 'NIR J band source flux error from the Sersic fit',
 'fluxerr_h_sersic': 'NIR H band source flux error from the Sersic fit',
 'fluxerr_u_ext_decam_sersic': 'Uext DECam band source flux error from the Sersic fit',
 'fluxerr_g_ext_decam_sersic': 'Gext DECam band source flux error from the Sersic fit',
 'fluxerr_r_ext_decam_sersic': 'Rext DECam band source flux error from the Sersic fit',
 'fluxerr_i_ext_decam_sersic': 'Iext DECam band source flux error from the Sersic fit',
 'fluxerr_z_ext_decam_sersic': 'Zext DECam band source flux error from the Sersic fit',
 'fluxerr_u_ext_lsst_sersic': 'Uext LSST band source flux error from the Sersic fit',
 'fluxerr_g_ext_lsst_sersic': 'Gext LSST band source flux error from the Sersic fit',
 'fluxerr_r_ext_lsst_sersic': 'Rext LSST band source flux error from the Sersic fit',
 'fluxerr_i_ext_lsst_sersic': 'Iext LSST band source flux error from the Sersic fit',
 'fluxerr_z_ext_lsst_sersic': 'Zext LSST band source flux error from the Sersic fit',
 'fluxerr_u_ext_megacam_sersic': 'Uext Megacam band source flux error from the Sersic fit',
 'fluxerr_r_ext_megacam_sersic': 'Rext Megacam band source flux error from the Sersic fit',
 'fluxerr_g_ext_jpcam_sersic': 'Gext JPCAM band source flux error from the Sersic fit',
 'fluxerr_i_ext_panstarrs_sersic': 'Iext PS band source flux error from the Sersic fit'}

Tip

The MER catalog contains 476 columns, below are a few highlights:

object_id
flux_vis_psf, mer.flux_y_templfit,flux_j_templfit, mer.flux_h_templfit
fwhm

Define the following ADQL query to find the first 10k stars in the MER catalog#

Since we are just using the MER catalog alone, it does not have a column for classification. We can use the point_like_flag = 1 or point_like_prob > 0.99 for stars.

Set all the fluxes to be greater than 0 so the object is detected in all four Euclid MER mosaic images.

adql_stars = ("SELECT TOP 10000 mer.object_id, mer.ra, mer.dec, mer.flux_vis_psf, mer.fluxerr_vis_psf, "
              "mer.flux_y_templfit,mer.fluxerr_y_templfit, mer.flux_j_templfit, mer.fluxerr_j_templfit, "
              "mer.flux_h_templfit, mer.fluxerr_h_templfit, mer.point_like_prob, mer.extended_prob "
              f"FROM {table_mer} AS mer "
              "WHERE  mer.flux_vis_psf > 0 "
              "AND mer.flux_y_templfit > 0 "
              "AND mer.flux_j_templfit > 0 "
              "AND mer.flux_h_templfit > 0 "
              "AND mer.point_like_flag = 1 ")

We can run the query with the TAP service, and then look at some of the results.

result_stars = Irsa.query_tap(adql_stars).to_table()
result_stars[:5]

Table length=5

object_id	ra	dec	flux_vis_psf	fluxerr_vis_psf	flux_y_templfit	fluxerr_y_templfit	flux_j_templfit	fluxerr_j_templfit	flux_h_templfit	fluxerr_h_templfit	point_like_prob	extended_prob
NA	deg	deg	uJy	uJy	uJy	uJy	uJy	uJy	uJy	uJy	NA	NA
int64	float64	float64	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32
2718284139656546334	271.8284139	65.65463345	12.01498032	0.04741815105	51.19612122	0.458874613	56.89655685	0.4349552691	56.17173767	0.4241253436	0.9730213284	--
2719785536656648264	271.9785537	65.66482644	31.63032532	0.08549753577	96.24780273	0.7781062126	115.8668213	0.7928025126	114.639679	0.8658923507	0.9961251616	--
2718247369656535106	271.8247369	65.65351064	12.83476448	0.05740290135	52.80757141	0.5690165758	60.46030807	0.4410717487	61.1444664	0.4651491344	0.97648561	--
2717152438656571540	271.7152439	65.65715401	6.691594124	0.0436687544	27.39351463	0.327249229	33.16018295	0.3623997569	33.58624268	0.3671961129	0.9698008895	--
2721315831656654537	272.1315831	65.66545379	7.238943577	0.04437031969	24.85434532	0.2644696832	27.87883377	0.2431959957	27.74636078	0.2520694137	0.9711326361	--

2. Make a color-magnitude diagram using the catalogs pulled from IRSA#

Convert from flux in uJy to magnitudes using the zero point correction
Convert the error bars to magnitudes as well
Plot the color-magnitude diagram

mag_y = -2.5 * np.log10(result_stars["flux_y_templfit"]) + 23.9 
mag_h = -2.5 * np.log10(result_stars["flux_h_templfit"]) + 23.9

x = mag_y - mag_h  # Y - H
y = mag_y

xerr = (2.5 / np.log(10) * np.sqrt((result_stars["fluxerr_y_templfit"] / result_stars["flux_y_templfit"])**2
                                   + (result_stars["fluxerr_h_templfit"] / result_stars["flux_h_templfit"])**2))
yerr = (2.5 / np.log(10) * (result_stars["fluxerr_y_templfit"] / result_stars["flux_y_templfit"]))

plt.errorbar(x, y, xerr=xerr, yerr=yerr,
             fmt='o', markersize=1.5, ecolor='lightgrey', elinewidth=0.5, capsize=2)

plt.xlabel('Y-H')
plt.ylabel('Y')
plt.xlim(-10, 10)
plt.ylim(10, 35)
plt.title('10k Stars in MER catalog -- IRSA')

Text(0.5, 1.0, '10k Stars in MER catalog -- IRSA')

../../_images/8f63260a4e7e43e09a727b9fecbd0808afb24948de24395529081eb98144d6f6.png

About this Notebook#

Author: Tiffany Meshkat, Anahita Alavi, Anastasia Laity, Andreas Faisst, Brigitta Sipőcz, Dan Masters, Harry Teplitz, Jaladh Singhal, Shoubaneh Hemmati, Vandana Desai

Updated: 2025-04-09

Contact: the IRSA Helpdesk with questions or reporting problems.

Euclid Q1: MER catalogs

Contents

Euclid Q1: MER catalogs#

Learning Goals#

Introduction#

Imports#

1. Download MER catalog from IRSA directly to this notebook#

Choose the Euclid MER table#

Learn some information about the MER catalog:#

Define the following ADQL query to find the first 10k stars in the MER catalog#

2. Make a color-magnitude diagram using the catalogs pulled from IRSA#

About this Notebook#