EDP Sciences
Gaia Data Release 1
Press Release
Free Access

Table B.2

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 diagram in Fig. 5 as well as the Pleiades parallax histogram in Fig. 9.

Query to reproduce Fig. 5. This results in a table of 1 004 207 rows (1 004 204 when including the zero-point uncertainty on G in the selection criteria) listing the Gaia source identifier and the values of MG and (GKs).
select gaia.source_id, gaia.phot_g_mean_mag+5*log10(gaia.parallax)-10 as g_mag_abs, gaia.phot_g_mean_mag-tmass.ks_m as g_min_ks from gaiadr1.tgas_source as gaia inner join gaiadr1.tmass_best_neighbour as xmatch on gaia.source_id = xmatch.source_id inner join gaiadr1.tmass_original_valid as tmass on tmass.tmass_oid = xmatch.tmass_oid where gaia.parallax/gaia.parallax_error >= 5 and ph_qual = 'AAA' and sqrt(power(2.5/log(10)*gaia.phot_g_mean_flux_error/gaia.phot_g_mean_flux,2)) <= 0.05 and sqrt(power(2.5/log(10)*gaia.phot_g_mean_flux_error/gaia.phot_g_mean_flux,2) + power(tmass.ks_msigcom,2)) <= 0.05
Query to carry out a simplistic selection of Pleiades cluster members and reproduce Fig. 9. This results in a table of 164 rows listing the Gaia source identifier and the Gaia parallax.
select gaia.source_id, gaia.parallax from gaiadr1.tgas_source as gaia where contains(point('ICRS',gaia.ra,gaia.dec),circle('ICRS',56.75,24.12,5)) = 1 and sqrt(power(gaia.pmra-20.5,2)+power(gaia.pmdec+45.5,2)) < 6.0

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.