https://pwiki.pic.es/index.php?action=history&feed=atom&title=Gaia_EDR3 2026-04-20T15:07:32Z Revision history for this page on the wiki MediaWiki 1.35.14 https://pwiki.pic.es/index.php?title=Gaia_EDR3&diff=885&oldid=prev 2020-12-03T17:40:35Z

<p></p> <a href="//pwiki.pic.es/index.php?title=Gaia_EDR3&amp;diff=885&amp;oldid=884">Show changes</a>

Tallada https://pwiki.pic.es/index.php?title=Gaia_EDR3&diff=884&oldid=prev 2020-12-03T14:39:10Z

<p>Created page with &quot;== 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 ==...&quot;</p> <p><b>New page</b></p><div>== Raw data ==<br /> <br /> Mirrored to cephfs using lftp:<br /> <br /> mirror -r -v -c -P4 http://cdn.gea.esac.esa.int/Gaia/gedr3/gaia_source/ /cephfs/pic.es/astro/scratch/tallada/gaia_edr3<br /> <br /> == External table ==<br /> <br /> CREATE EXTERNAL TABLE tallada.gaia_edr3_csv (<br /> solution_id bigint,<br /> designation string,<br /> source_id bigint,<br /> random_index bigint,<br /> ref_epoch float,<br /> ra double,<br /> ra_error float,<br /> `dec` double,<br /> dec_error float,<br /> parallax double,<br /> parallax_error float,<br /> parallax_over_error float,<br /> pm float,<br /> pmra double,<br /> pmra_error float,<br /> pmdec double,<br /> pmdec_error float,<br /> ra_dec_corr float,<br /> ra_parallax_corr float,<br /> ra_pmra_corr float,<br /> ra_pmdec_corr float,<br /> dec_parallax_corr float,<br /> dec_pmra_corr float,<br /> dec_pmdec_corr float,<br /> parallax_pmra_corr float,<br /> parallax_pmdec_corr float,<br /> pmra_pmdec_corr float,<br /> astrometric_n_obs_al smallint,<br /> astrometric_n_obs_ac smallint,<br /> astrometric_n_good_obs_al smallint,<br /> astrometric_n_bad_obs_al smallint,<br /> astrometric_gof_al float,<br /> astrometric_chi2_al float,<br /> astrometric_excess_noise float,<br /> astrometric_excess_noise_sig float,<br /> astrometric_params_solved tinyint,<br /> astrometric_primary_flag boolean,<br /> nu_eff_used_in_astrometry float,<br /> pseudocolour float,<br /> pseudocolour_error float,<br /> ra_pseudocolour_corr float,<br /> dec_pseudocolour_corr float,<br /> parallax_pseudocolour_corr float,<br /> pmra_pseudocolour_corr float,<br /> pmdec_pseudocolour_corr float,<br /> astrometric_matched_transits smallint,<br /> visibility_periods_used smallint,<br /> astrometric_sigma5d_max float,<br /> matched_transits smallint,<br /> new_matched_transits smallint,<br /> matched_transits_removed smallint,<br /> ipd_gof_harmonic_amplitude float,<br /> ipd_gof_harmonic_phase float,<br /> ipd_frac_multi_peak tinyint,<br /> ipd_frac_odd_win tinyint,<br /> ruwe float,<br /> scan_direction_strength_k1 float,<br /> scan_direction_strength_k2 float,<br /> scan_direction_strength_k3 float,<br /> scan_direction_strength_k4 float,<br /> scan_direction_mean_k1 float,<br /> scan_direction_mean_k2 float,<br /> scan_direction_mean_k3 float,<br /> scan_direction_mean_k4 float,<br /> duplicated_source boolean,<br /> phot_g_n_obs smallint,<br /> phot_g_mean_flux double,<br /> phot_g_mean_flux_error float,<br /> phot_g_mean_flux_over_error float,<br /> phot_g_mean_mag float,<br /> phot_bp_n_obs smallint,<br /> phot_bp_mean_flux double,<br /> phot_bp_mean_flux_error float,<br /> phot_bp_mean_flux_over_error float,<br /> phot_bp_mean_mag float,<br /> phot_rp_n_obs smallint,<br /> phot_rp_mean_flux double,<br /> phot_rp_mean_flux_error float,<br /> phot_rp_mean_flux_over_error float,<br /> phot_rp_mean_mag float,<br /> phot_bp_n_contaminated_transits smallint,<br /> phot_bp_n_blended_transits smallint,<br /> phot_rp_n_contaminated_transits smallint,<br /> phot_rp_n_blended_transits smallint,<br /> phot_proc_mode tinyint,<br /> phot_bp_rp_excess_factor float,<br /> bp_rp float,<br /> bp_g float,<br /> g_rp float,<br /> dr2_radial_velocity float,<br /> dr2_radial_velocity_error float,<br /> dr2_rv_nb_transits smallint,<br /> dr2_rv_template_teff float,<br /> dr2_rv_template_logg float,<br /> dr2_rv_template_fe_h float,<br /> l double,<br /> b double,<br /> ecl_lon double,<br /> ecl_lat double<br /> )<br /> ROW FORMAT DELIMITED<br /> FIELDS TERMINATED BY ','<br /> LOCATION '/user/tallada/data/gaia_edr3'<br /> ;</div>

Tallada