EDP Sciences
Gaia Data Release 1
Press Release
Free Access

Table B.1

Minimal queries that can be submitted to the Gaia archive in the Astronomical Data Query Language to retrieve the data necessary to reproduce the HR diagrams and the magnitude distribution in Figs. 3 and 4.

Query to reproduce panels a and b of Fig. 3. This results in a table of 43 546 rows listing the Gaia source identifier, the Hipparcos number, the values of MG based on the Hipparcos and Gaia DR1 parallaxes respectively, and the value of (BV) from the Hipparcos catalogue (van Leeuwen 2007).
elect gaia.source_id, gaia.hip, gaia.phot_g_mean_mag+5*log10(gaia.parallax)-10 as g_mag_abs_gaia, gaia.phot_g_mean_mag+5*log10(hip.plx)-10 as g_mag_abs_hip, hip.b_v from gaiadr1.tgas_source as gaia inner join public.hipparcos_newreduction as hip on gaia.hip = hip.hip where gaia.parallax/gaia.parallax_error >= 5 and hip.plx/hip.e_plx >= 5 and hip.e_b_v > 0.0 and hip.e_b_v <= 0.05 and 2.5/log(10)*gaia.phot_g_mean_flux_error/gaia.phot_g_mean_flux <= 0.05
Query to reproduce panel c of Fig. 3. This results in a table of 74 771 rows listing the Gaia source identifier, the values of MG based on the Gaia DR1 parallax, and the value of (BV) from the Hipparcos catalogue (van Leeuwen 2007).
select gaia.source_id, gaia.hip, gaia.phot_g_mean_mag+5*log10(gaia.parallax)-10 as g_mag_abs, hip.b_v from gaiadr1.tgas_source as gaia inner join public.hipparcos_newreduction as hip on gaia.hip = hip.hip where gaia.parallax/gaia.parallax_error >= 5 and hip.e_b_v > 0.0 and hip.e_b_v <= 0.05 and 2.5/log(10)*gaia.phot_g_mean_flux_error/gaia.phot_g_mean_flux <= 0.05
Query to reproduce Fig. 4. This results in a table of 3174 rows listing the Gaia source identifier, and the values of MG based on the Gaia DR1 and Hipparcos (van Leeuwen 2007) parallaxes, respectively.
select gaia.source_id, gaia.hip, gaia.phot_g_mean_mag+5*log10(gaia.parallax)-10 as g_mag_abs_gaia, gaia.phot_g_mean_mag+5*log10(hip.plx)-10 as g_mag_abs_hip from gaiadr1.tgas_source as gaia inner join public.hipparcos_newreduction as hip on gaia.hip = hip.hip where gaia.parallax/gaia.parallax_error >= 5 and hip.plx/hip.e_plx >= 5 and hip.e_b_v > 0.0 and hip.e_b_v <= 0.05 and hip.b_v >= 1.0 and hip.b_v <= 1.1 and 2.5/log(10)*gaia.phot_g_mean_flux_error/gaia.phot_g_mean_flux <= 0.05

Current usage metrics show cumulative count of Article Views (full-text article views including HTML views, PDF and ePub downloads, according to the available data) and Abstracts Views on Vision4Press platform.

Data correspond to usage on the plateform after 2015. The current usage metrics is available 48-96 hours after online publication and is updated daily on week days.

Initial download of the metrics may take a while.