Gaia EDR3

Raw data

Mirrored to cephfs using lftp:

   mirror -r -v -c -P4 http://cdn.gea.esac.esa.int/Gaia/gedr3/gaia_source/ /cephfs/pic.es/astro/scratch/tallada/gaia_edr3

External table

CREATE EXTERNAL TABLE tallada.gaia_edr3_csv (
    solution_id bigint,
    designation string,
    source_id bigint,
    random_index bigint,
    ref_epoch float,
    ra double,
    ra_error float,
    `dec` double,
    dec_error float,
    parallax double,
    parallax_error float,
    parallax_over_error float,
    pm float,
    pmra double,
    pmra_error float,
    pmdec double,
    pmdec_error float,
    ra_dec_corr float,
    ra_parallax_corr float,
    ra_pmra_corr float,
    ra_pmdec_corr float,
    dec_parallax_corr float,
    dec_pmra_corr float,
    dec_pmdec_corr float,
    parallax_pmra_corr float,
    parallax_pmdec_corr float,
    pmra_pmdec_corr float,
    astrometric_n_obs_al smallint,
    astrometric_n_obs_ac smallint,
    astrometric_n_good_obs_al smallint,
    astrometric_n_bad_obs_al smallint,
    astrometric_gof_al float,
    astrometric_chi2_al float,
    astrometric_excess_noise float,
    astrometric_excess_noise_sig float,
    astrometric_params_solved tinyint,
    astrometric_primary_flag boolean,
    nu_eff_used_in_astrometry float,
    pseudocolour float,
    pseudocolour_error float,
    ra_pseudocolour_corr float,
    dec_pseudocolour_corr float,
    parallax_pseudocolour_corr float,
    pmra_pseudocolour_corr float,
    pmdec_pseudocolour_corr float,
    astrometric_matched_transits smallint,
    visibility_periods_used smallint,
    astrometric_sigma5d_max float,
    matched_transits smallint,
    new_matched_transits smallint,
    matched_transits_removed smallint,
    ipd_gof_harmonic_amplitude float,
    ipd_gof_harmonic_phase float,
    ipd_frac_multi_peak tinyint,
    ipd_frac_odd_win tinyint,
    ruwe float,
    scan_direction_strength_k1 float,
    scan_direction_strength_k2 float,
    scan_direction_strength_k3 float,
    scan_direction_strength_k4 float,
    scan_direction_mean_k1 float,
    scan_direction_mean_k2 float,
    scan_direction_mean_k3 float,
    scan_direction_mean_k4 float,
    duplicated_source boolean,
    phot_g_n_obs smallint,
    phot_g_mean_flux double,
    phot_g_mean_flux_error float,
    phot_g_mean_flux_over_error float,
    phot_g_mean_mag float,
    phot_bp_n_obs smallint,
    phot_bp_mean_flux double,
    phot_bp_mean_flux_error float,
    phot_bp_mean_flux_over_error float,
    phot_bp_mean_mag float,
    phot_rp_n_obs smallint,
    phot_rp_mean_flux double,
    phot_rp_mean_flux_error float,
    phot_rp_mean_flux_over_error float,
    phot_rp_mean_mag float,
    phot_bp_n_contaminated_transits smallint,
    phot_bp_n_blended_transits smallint,
    phot_rp_n_contaminated_transits smallint,
    phot_rp_n_blended_transits smallint,
    phot_proc_mode tinyint,
    phot_bp_rp_excess_factor float,
    bp_rp float,
    bp_g float,
    g_rp float,
    dr2_radial_velocity float,
    dr2_radial_velocity_error float,
    dr2_rv_nb_transits smallint,
    dr2_rv_template_teff float,
    dr2_rv_template_logg float,
    dr2_rv_template_fe_h float,
    l double,
    b double,
    ecl_lon double,
    ecl_lat double
)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
LOCATION '/user/tallada/data/gaia_edr3'
;