Context

Gaia is an ambitious space mission launched in 2013 aimed at mapping a billion astronomical objects. Hipparcos, its predecessor, was launched in 1989, and it mapped 118K stars.

The Hipparcos and Gaia databases provide stellar magnitude (brightness) measurements that are about 24 years apart.

Content

The Gaia Archive was used to query data from Gaia DR2 and Hipparcos databases, and to perform the crossmatch between them. The following query was used, and the resultset is made available in this dataset as is.

select G.source_id,G.ra,G.dec,G.parallax,G.parallax_error,G.phot_g_mean_mag,G.phot_bp_mean_mag,G.phot_rp_mean_mag,G.l,G.b,     G.pmra,G.pmdec,     G.phot_g_n_obs,G.phot_g_mean_flux,G.phot_g_mean_flux_error,     H.btmag,H.e_btmag,H.e_hpmag,H.e_vtmag,H.hip,H.hpmag,H.sptype,H.vmag,H.vtmag,     HG.angular_distance FROM gaiadr2.hipparcos2_best_neighbour HG inner join gaiadr2.gaia_source G ON HG.source_id = G.source_id inner join public.hipparcos H ON H.hip=HG.original_ext_source_id where HG.angular_distance <= 0.35 AND G.phot_g_mean_mag <= 13.0 AND HG.number_of_neighbours=1 AND H.btmag IS NOT NULL AND H.hpmag IS NOT NULL AND H.vmag IS NOT NULL AND H.vtmag IS NOT NULL AND G.phot_bp_mean_mag IS NOT NULL AND G.phot_rp_mean_mag IS NOT NULL AND G.phot_g_mean_mag IS NOT NULL 

Acknowledgements

This work has made use of data from the European Space Agency (ESA) mission Gaia (https://www.cosmos.esa.int/gaia), processed by the Gaia Data Processing and Analysis Consortium (DPAC, https://www.cosmos.esa.int/web/gaia/dpac/consortium). Funding for the DPAC has been provided by national institutions, in particular the institutions participating in the Gaia Multilateral Agreement.

The Hipparcos and Tycho Catalogues are the primary products of the European Space Agency's astrometric mission, Hipparcos. The satellite, which operated for four years, returned high quality scientific data from November 1989 to March 1993.