文脈 ガイアは欧州宇宙機関（ESA）のミッションで、10億を超える恒星の位置、距離、光度を正確に測定することを目的としています。 内容 以下のADQLクエリをそのまま使用してデータを取得しました。 SELECT G.source_id,GSBN.original_ext_source_id AS gsc23_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, AWBN.angular_distance AS allwise_ang_dist, GSBN.angular_distance AS gsc23_ang_dist, PPBN.angular_distance AS ppmxl_ang_dist, TMBN.angular_distance AS tmass_ang_dist, URBN.angular_distance AS urat1_ang_dist, AW.w1mpro AS allwise_w1, AW.w2mpro AS allwise_w2, AW.w3mpro AS allwise_w3, AW.w4mpro AS allwise_w4, GS.v_mag AS gsc23_v_mag,GS.b_mag AS gsc23_b_mag, PP.b1mag AS ppmxl_b1mag, PP.b2mag AS ppmxl_b2mag, PP.r1mag AS ppmxl_r1mag, PP.imag AS ppmxl_imag, TM.j_m AS tmass_j_m, TM.h_m AS tmass_h_m, TM.ks_m AS tmass_ks_m, UR.f_mag AS urat1_f_mag, UR.b_mag AS urat1_b_mag, UR.v_mag AS urat1_v_mag, UR.g_mag AS urat1_g_mag, UR.r_mag AS urat1_r_mag, UR.i_mag AS urat1_i_mag FROM gaiadr2.gaia_source G INNER JOIN gaiadr2.allwise_best_neighbour AWBN ON AWBN.source_id=G.source_id INNER JOIN gaiadr2.gsc23_best_neighbour GSBN ON GSBN.source_id=G.source_id INNER JOIN gaiadr2.ppmxl_best_neighbour PPBN ON PPBN.source_id=G.source_id INNER JOIN gaiadr2.tmass_best_neighbour TMBN ON TMBN.source_id=G.source_id INNER JOIN gaiadr2.urat1_best_neighbour URBN ON URBN.source_id=G.source_id INNER JOIN gaiadr1.allwise_original_valid AW ON AW.designation=AWBN.original_ext_source_id INNER JOIN gaiadr1.gsc23_original_valid GS ON GS.gsc23_identifier=GSBN.original_ext_source_id INNER JOIN gaiadr1.ppmxl_original_valid PP ON PP.ppmxl_oid=PPBN.ppmxl_oid INNER JOIN gaiadr1.tmass_original_valid TM ON TM.designation=TMBN.original_ext_source_id INNER JOIN gaiadr1.urat1_original_valid UR ON UR.urat1_identifier=URBN.original_ext_source_id WHERE G.parallax >= 1.7 AND G.parallax_error <= 0.04 AND G.phot_g_mean_mag <= 13.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.w1mpro IS NOT NULL AND AW.w2mpro IS NOT NULL AND AW.w3mpro IS NOT NULL AND AW.w4mpro IS NOT NULL AND GS.v_mag IS NOT NULL AND GS.b_mag IS NOT NULL AND PP.b1mag IS NOT NULL AND PP.b2mag IS NOT NULL AND PP.r1mag IS NOT NULL AND PP.imag 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 UR.f_mag IS NOT NULL AND UR.b_mag IS NOT NULL AND UR.v_mag IS NOT NULL AND UR.g_mag IS NOT NULL AND UR.r_mag IS NOT NULL AND UR.i_mag IS NOT NULL AND AWBN.angular_distance <= 0.4 AND GSBN.angular_distance <= 0.4 AND PPBN.angular_distance <= 0.4 AND TMBN.angular_distance <= 0.4 AND URBN.angular_distance <= 0.4 AND AWBN.best_neighbour_multiplicity=1 AND GSBN.best_neighbour_multiplicity=1 AND PPBN.best_neighbour_multiplicity=1 AND TMBN.best_neighbour_multiplicity=1 AND URBN.best_neighbour_multiplicity=1 注釈 このデータセットには南半球の恒星はそれほど含まれていません。代替案については*[257K Gaia DR2 Stars][1]*を参照してください。 謝辞 この研究では、欧州宇宙機関（ESA）のガイアミッション（https://www.cosmos.esa.int/gaia）のデータを使用しており、これはガイアデータ処理分析コンソーシアム（DPAC、https://www.cosmos.esa.int/web/gaia/dpac/consortium）によって処理されています。DPACへの資金提供は各国の機関、特にガイア多国間協定に参加している機関によって行われています。 [1]: https://www.kaggle.com/solorzano/257k-gaia-dr2-stars