{ "data_id": "43669", "name": "Stars-from-Gaia-DR2-and-RAVE-DR5", "exact_name": "Stars-from-Gaia-DR2-and-RAVE-DR5", "version": 1, "version_label": "v1.0", "description": "Context\nThe RAVE dataset along with Gaia DR1 was used by Zackrisson et al. (2018), a paper on Dysonian SETI.\nGaia is a mission of the European Space Agency (ESA) that aims to accurately measure the position, distance and magnitude of over a billion stars. RAVE is a radial velocity dataset. RAVE also provides spectrophotometric parallax data, as well as cross-identification of stars with a number of other datasets, including Gaia DR2.\nContent\nThis dataset is a combination of RAVE DR5 and Gaia DR2 sources. The data is obtained using the query tool of the RAVE project. The SQL query follows:\nSELECT G.source_id,G.parallax,G.parallax_error,G.ra,G.dec,G.phot_g_mean_mag,G.phot_bp_mean_mag,G.phot_rp_mean_mag,G.l,G.b,G.pmra,G.pmdec, R.HRV AS r_hrv,R.Met_K AS r_metallicity,R.Algo_Conv_K AS r_quality,R.Mg AS r_mg,R.Si AS r_si,R.Ti AS r_ti,R.Fe AS r_fe,R.Ni AS r_ni,R.distance r_distance,R.parallax r_parallax,R.Jmag_2MASS r_jmag_2mass,R.Hmag_2MASS r_hmag_2mass,R.Kmag_2MASS r_kmag_2mass, R.RAdeg r_ra,R.DEdeg r_de, W1mag_ALLWISE r_w1mag_allwise, W2mag_ALLWISE r_w2mag_allwise, W3mag_ALLWISE r_w3mag_allwise, W4mag_ALLWISE r_w4mag_allwise, BTmag_TYCHO2 r_btmag_tycho2, VTmag_TYCHO2 r_vtmag_tycho2, Bmag_APASSDR9 r_bmag_apassdr9, Vmag_APASSDR9 r_vmag_apassdr9, rpmag_APASSDR9 r_rpmag_apassdr9, ipmag_APASSDR9 r_ipmag_apassdr9, Imag_DENIS r_imag_denis, Jmag_DENIS r_jmag_denis, Kmag_DENIS r_kmag_denis, B1mag_USNOB1 r_b1mag_usnob1, R1mag_USNOB1 r_r1mag_usnob1, B2mag_USNOB1 r_b2mag_usnob1, R2mag_USNOB1 r_r2mag_usnob1, Imag_USNOB1 r_imag_usnob1 FROM RAVEPUB_DR5.RAVE_DR2gaia_source G INNER JOIN RAVEPUB_DR5.RAVE_DR5 R ON R.RAVE_OBS_ID=G.RAVE_OBS_ID WHERE G.parallax IS NOT NULL\n\nThe following processing was done:\n\nRemoved rows with missing values in any of the following columns: \n\"ra\",\n \"dec\",\n \"pmra\",\n \"pmdec\",\n \"l\",\n \"b\",\n \"parallax\",\n \"parallaxerror\",\n \"photgmeanmag\",\n \"photbpmeanmag\",\n \"photrpmeanmag\",\n \"rhrv\",\n \"rmetallicity\",\n \"rdistance\",\n \"rparallax\",\n \"rjmag2mass\",\n \"rhmag2mass\",\n \"rkmag2mass\",\n \"rmg\",\n \"rsi\",\n \"rfe\", \n \"rquality\",\n \"rra\",\n \"rde\",\n \"rw1magallwise\",\n \"rw2magallwise\",\n \"rw3magallwise\",\n \"rw4magallwise\",\n \"rbmagapassdr9\",\n \"rvmagapassdr9\",\n \"rrpmagapassdr9\",\n \"ripmagapassdr9\",\n \"rimagdenis\",\n \"rjmagdenis\",\n \"rkmagdenis\"\nAveraged those values for rows that have the same Gaia \"source_id\".\n\nNote\nAn alternative dataset is recommended: 257k Gaia DR2 stars. It contains sources from the Northern and Southern Hemispheres. \nAcknowledgements\nThis 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.\nReferences\nKunder et al. (2016). The Radial Velocity Experiment (RAVE): Fifth Data Release. arXiv:1609.03210\nZackrisson et al. (2018). SETI with Gaia: The observational signatures of nearly complete Dyson spheres. arXiv:1804.08351", "format": "arff", "uploader": "Dustin Carrion", "uploader_id": 30123, "visibility": "public", "creator": null, "contributor": null, "date": "2022-03-24 01:20:50", "update_comment": null, "last_update": "2022-03-24 01:20:50", "licence": "CC0: Public Domain", "status": "active", "error_message": null, "url": "https:\/\/www.openml.org\/data\/download\/22102494\/dataset", "default_target_attribute": null, "row_id_attribute": null, "ignore_attribute": "\"source_id\"", "runs": 0, "suggest": { "input": [ "Stars-from-Gaia-DR2-and-RAVE-DR5", "Context The RAVE dataset along with Gaia DR1 was used by Zackrisson et al. (2018), a paper on Dysonian SETI. Gaia is a mission of the European Space Agency (ESA) that aims to accurately measure the position, distance and magnitude of over a billion stars. RAVE is a radial velocity dataset. RAVE also provides spectrophotometric parallax data, as well as cross-identification of stars with a number of other datasets, including Gaia DR2. Content This dataset is a combination of RAVE DR5 and Gaia DR2 " ], "weight": 5 }, "qualities": { "NumberOfInstances": 253040, "NumberOfFeatures": 35, "NumberOfClasses": null, "NumberOfMissingValues": 0, "NumberOfInstancesWithMissingValues": 0, "NumberOfNumericFeatures": 35, "NumberOfSymbolicFeatures": 0, "Dimensionality": 0.00013831805248182107, "PercentageOfNumericFeatures": 100, "MajorityClassPercentage": null, "PercentageOfSymbolicFeatures": 0, "MajorityClassSize": null, "MinorityClassPercentage": null, "MinorityClassSize": null, "NumberOfBinaryFeatures": 0, "PercentageOfBinaryFeatures": 0, "PercentageOfInstancesWithMissingValues": 0, "AutoCorrelation": null, "PercentageOfMissingValues": 0 }, "tags": [ { "uploader": "38960", "tag": "Computer Systems" }, { "uploader": "38960", "tag": "Machine Learning" } ], "features": [ { "name": "source_id", "index": "0", "type": "numeric", "distinct": "252927", "missing": "0", "ignore": "1", "min": "2147483647", "max": "2147483647", "mean": "2147483647", "stdev": "2147483647" }, { "name": "ra", "index": "1", "type": "numeric", "distinct": "253040", "missing": "0", "min": "0", "max": "360", "mean": "185", "stdev": "103" }, { "name": "dec", "index": "2", "type": "numeric", "distinct": "253040", "missing": "0", "min": "-87", "max": "2", "mean": "-38", "stdev": "22" }, { "name": "pmra", "index": "3", "type": "numeric", "distinct": "253040", "missing": "0", "min": "-617", "max": "731", "mean": "0", "stdev": "24" }, { "name": "pmdec", "index": "4", "type": "numeric", "distinct": "253040", "missing": "0", "min": "-407", "max": "352", "mean": "-5", "stdev": "20" }, { "name": "l", "index": "5", "type": "numeric", "distinct": "253040", "missing": "0", "min": "0", "max": "360", "mean": "244", "stdev": "105" }, { "name": "b", "index": "6", "type": "numeric", "distinct": "253040", "missing": "0", "min": "-90", "max": "63", "mean": "-17", "stdev": "35" }, { "name": "parallax", "index": "7", "type": "numeric", "distinct": "253040", "missing": "0", "min": "-26", "max": "67", "mean": "2", "stdev": "2" }, { "name": "parallax_error", "index": "8", "type": "numeric", "distinct": "253040", "missing": "0", "min": "0", "max": "2", "mean": "0", "stdev": "0" }, { "name": "phot_g_mean_mag", "index": "9", "type": "numeric", "distinct": "42560", "missing": "0", "min": "5", "max": "19", "mean": "11", "stdev": "1" }, { "name": "phot_bp_mean_mag", "index": "10", "type": "numeric", "distinct": "40809", "missing": "0", "min": "6", "max": "18", "mean": "12", "stdev": "1" }, { "name": "phot_rp_mean_mag", "index": "11", "type": "numeric", "distinct": "62578", "missing": "0", "min": "4", "max": "17", "mean": "11", "stdev": "1" }, { "name": "r_hrv", "index": "12", "type": "numeric", "distinct": "125834", "missing": "0", "min": "-455", "max": "586", "mean": "8", "stdev": "41" }, { "name": "r_metallicity", "index": "13", "type": "numeric", "distinct": "2146", "missing": "0", "min": "-3", "max": "1", "mean": "0", "stdev": "0" }, { "name": "r_distance", "index": "14", "type": "numeric", "distinct": "218044", "missing": "0", "min": "20", "max": "14268", "mean": "1103", "stdev": "1030" }, { "name": "r_parallax", "index": "15", "type": "numeric", "distinct": "225661", "missing": "0", "min": "0", "max": "54", "mean": "2", "stdev": "2" }, { "name": "r_jmag_2mass", "index": "16", "type": "numeric", "distinct": "5881", "missing": "0", "min": "3", "max": "15", "mean": "10", "stdev": "1" }, { "name": "r_hmag_2mass", "index": "17", "type": "numeric", "distinct": "6283", "missing": "0", "min": "2", "max": "14", "mean": "9", "stdev": "1" }, { "name": "r_kmag_2mass", "index": "18", "type": "numeric", "distinct": "6404", "missing": "0", "min": "2", "max": "14", "mean": "9", "stdev": "1" }, { "name": "r_mg", "index": "19", "type": "numeric", "distinct": "1944", "missing": "0", "min": "-2", "max": "1", "mean": "0", "stdev": "0" }, { "name": "r_si", "index": "20", "type": "numeric", "distinct": "2059", "missing": "0", "min": "-2", "max": "1", "mean": "0", "stdev": "0" }, { "name": "r_fe", "index": "21", "type": "numeric", "distinct": "2085", "missing": "0", "min": "-2", "max": "1", "mean": "0", "stdev": "0" }, { "name": "r_quality", "index": "22", "type": "numeric", "distinct": "62", "missing": "0", "min": "0", "max": "4", "mean": "1", "stdev": "1" }, { "name": "r_ra", "index": "23", "type": "numeric", "distinct": "248783", "missing": "0", "min": "0", "max": "360", "mean": "185", "stdev": "103" }, { "name": "r_de", "index": "24", "type": "numeric", "distinct": "242375", "missing": "0", "min": "-87", "max": "2", "mean": "-38", "stdev": "22" }, { "name": "r_w1mag_allwise", "index": "25", "type": "numeric", "distinct": "6497", "missing": "0", "min": "0", "max": "16", "mean": "9", "stdev": "1" }, { "name": "r_w2mag_allwise", "index": "26", "type": "numeric", "distinct": "6476", "missing": "0", "min": "0", "max": "16", "mean": "9", "stdev": "1" }, { "name": "r_w3mag_allwise", "index": "27", "type": "numeric", "distinct": "6542", "missing": "0", "min": "1", "max": "13", "mean": "9", "stdev": "1" }, { "name": "r_w4mag_allwise", "index": "28", "type": "numeric", "distinct": "4775", "missing": "0", "min": "0", "max": "10", "mean": "8", "stdev": "1" }, { "name": "r_bmag_apassdr9", "index": "29", "type": "numeric", "distinct": "6758", "missing": "0", "min": "7", "max": "17", "mean": "13", "stdev": "1" }, { "name": "r_vmag_apassdr9", "index": "30", "type": "numeric", "distinct": "5867", "missing": "0", "min": "6", "max": "15", "mean": "12", "stdev": "1" }, { "name": "r_rpmag_apassdr9", "index": "31", "type": "numeric", "distinct": "5657", "missing": "0", "min": "6", "max": "16", "mean": "11", "stdev": "1" }, { "name": "r_ipmag_apassdr9", "index": "32", "type": "numeric", "distinct": "5643", "missing": "0", "min": "5", "max": "16", "mean": "11", "stdev": "1" }, { "name": "r_imag_denis", "index": "33", "type": "numeric", "distinct": "734", "missing": "0", "min": "8", "max": "15", "mean": "11", "stdev": "1" }, { "name": "r_jmag_denis", "index": "34", "type": "numeric", "distinct": "1045", "missing": "0", "min": "3", "max": "15", "mean": "10", "stdev": "1" }, { "name": "r_kmag_denis", "index": "35", "type": "numeric", "distinct": "1200", "missing": "0", "min": "4", "max": "13", "mean": "9", "stdev": "1" } ], "nr_of_issues": 0, "nr_of_downvotes": 0, "nr_of_likes": 0, "nr_of_downloads": 0, "total_downloads": 0, "reach": 0, "reuse": 0, "impact_of_reuse": 0, "reach_of_reuse": 0, "impact": 0 }