资源介绍
Context Gaia is a ESA project that aims to measure the parallax and magnitude of billions of stars. Kepler was a NASA mission launched to discover exoplanets in a specific region of the sky (i.e. the Kepler field). Content The CSV files in the dataset come primarily from [Gaia Archive](https://gea.esac.esa.int/archive/) ADQL queries. A **kepid** field has been added based on the 1 arcsec crossmatch provided by [gaia-kepler.fun](https://gaia-kepler.fun/). Crossmatch rows whose **source_id** or **kepid** appear in more than one row were removed altogether. Query used to produce **gaia-dr2-kepler-field-plain.csv**: SELECT G.source_id, G.parallax,G.parallax_error, G.phot_g_mean_mag,G.phot_rp_mean_mag,G.phot_bp_mean_mag, G.phot_g_mean_flux_error, G.ra,G.dec,G.ra_error,G.dec_error, G.l,G.b, G.pmra,G.pmdec FROM gaiadr2.gaia_source G WHERE G.parallax >= 1.0 AND G.parallax_error <= 0.05 AND G.ra >= 279 AND G.ra <= 302 AND G.dec >= 36 AND G.dec <= 53 AND G.phot_g_mean_mag <= 17.0 AND G.parallax_error IS NOT NULL AND G.phot_rp_mean_mag IS NOT NULL AND G.phot_bp_mean_mag IS NOT NULL AND G.phot_g_mean_flux_error IS NOT NULL Query used to produce **gaia-dr2-kepler-field-3-extra-dbs.csv**: SELECT G.source_id,TY.id AS tycho2_id, G.parallax,G.parallax_error, G.phot_g_mean_mag,G.phot_rp_mean_mag,G.phot_bp_mean_mag, G.phot_g_mean_flux_error, G.ra,G.dec,G.ra_error,G.dec_error, G.l,G.b, G.pmra,G.pmdec, AWBN.angular_distance AS allwise_ang_dist, TMBN.angular_distance AS tmass_ang_dist, TYBN.angular_distance AS tycho2_ang_dist, AW.w2mpro AS allwise_w2, AW.w3mpro AS allwise_w3, AW.w4mpro AS allwise_w4, TM.j_m AS tmass_j_m, TM.h_m AS tmass_h_m, TM.ks_m AS tmass_ks_m, TY.bt_mag AS tycho2_bt_mag, TY.vt_mag AS tycho2_vt_mag FROM gaiadr2.gaia_source G INNER JOIN gaiadr2.allwise_best_neighbour AWBN ON AWBN.source_id=G.source_id INNER JOIN gaiadr2.tmass_best_neighbour TMBN ON TMBN.source_id=G.source_id INNER JOIN gaiadr2.tycho2_best_neighbour TYBN ON TYBN.source_id=G.source_id INNER JOIN gaiadr1.allwise_original_valid AW ON AW.designation=AWBN.original_ext_source_id INNER JOIN gaiadr1.tmass_original_valid TM ON TM.designation=TMBN.original_ext_source_id INNER JOIN public.tycho2 TY ON TY.id=TYBN.original_ext_source_id WHERE G.parallax >= 1.7 AND G.parallax_error <= 0.1 AND G.ra >= 279 AND G.ra <= 302 AND G.dec >= 36 AND G.dec <= 53 AND G.phot_g_mean_mag <= 17.0 AND G.parallax_error IS NOT NULL AND G.phot_rp_mean_mag IS NOT NULL AND G.phot_bp_mean_mag IS NOT NULL AND G.phot_g_mean_flux_error IS NOT NULL AND AW.w2mpro IS NOT NULL AND AW.w3mpro IS NOT NULL AND AW.w4mpro IS NOT NULL AND TM.j_m IS NOT NULL AND TM.h_m IS NOT NULL AND TM.ks_m IS NOT NULL AND TY.bt_mag IS NOT NULL AND TY.vt_mag IS NOT NULL AND AWBN.angular_distance <= 0.15 AND TMBN.angular_distance <= 0.15 AND TYBN.angular_distance <= 0.25 AND AWBN.best_neighbour_multiplicity=1 AND TMBN.best_neighbour_multiplicity=1 AND TYBN.number_of_neighbours=1 Acknowledgements The data provided comes primarily from the European Space Agency (ESA) mission Gaia, processed by the Gaia Data Processing and Analysis Consortium (DPAC). Funding for the DPAC has been provided by national institutions, in particular the institutions participating in the Gaia Multilateral Agreement. This work made use of the gaia-kepler.fun crossmatch database created by Megan Bedell.
