数据结构 ?
20.07M
Data Structure ?
* 以上分析是由系统提取分析形成的结果，具体实际数据为准。
README.md
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.
暂无相关内容。
暂无相关内容。
- 分享你的想法
去分享你的想法~~
全部内容
欢迎交流分享
开始分享您的观点和意见，和大家一起交流分享.
数据使用声明：
- 1、该数据来自于互联网数据采集或服务商的提供，本平台为用户提供数据集的展示与浏览。
- 2、本平台仅作为数据集的基本信息展示、包括但不限于图像、文本、视频、音频等文件类型。
- 3、数据集基本信息来自数据原地址或数据提供方提供的信息，如数据集描述中有描述差异，请以数据原地址或服务商原地址为准。
- 1、本站中的所有数据集的版权都归属于原数据发布者或数据提供方所有。
- 1、如您需要转载本站数据，请保留原数据地址及相关版权声明。
- 1、如本站中的部分数据涉及侵权展示，请及时联系本站，我们会安排进行数据下线。
VIP下载(最低0.24/天)
下载数据集
0 
184浏览
0下载
0点赞
收藏
分享