{"id":42645,"date":"2026-09-22T10:27:07","date_gmt":"2026-09-22T08:27:07","guid":{"rendered":"https:\/\/www.graviton.at\/letterswaplibrary\/new-data-set-700-million-data-points-from-opensky-networks-with-opensharing\/"},"modified":"2026-09-22T10:27:07","modified_gmt":"2026-09-22T08:27:07","slug":"new-data-set-700-million-data-points-from-opensky-networks-with-opensharing","status":"publish","type":"post","link":"https:\/\/www.graviton.at\/letterswaplibrary\/new-data-set-700-million-data-points-from-opensky-networks-with-opensharing\/","title":{"rendered":"New Data Set: 700 Million Data Points From OpenSky Networks With OpenSharing"},"content":{"rendered":"<p><!-- SC_OFF --><\/p>\n<div class=\"md\">\n<p>Together with <a href=\"https:\/\/opensky-network.org\/\">OpenSky Network<\/a> I published a 700 million record dataset of every plane flying world-wide on March 1 2026, one full day of telemetry. The data is public and free for private and research use, and you read it straight from pandas or Spark with Apache OpenSharing.<\/p>\n<p>The OpenSky data is static, it&#8217;s hosted on <a href=\"https:\/\/marketplace.databricks.com\/details\/feb64bf4-77a8-4f6a-8e21-94c51042e41f\/Databricks_OpenSky-Networks-full-day-avionics-dataset\">Databricks Marketplace<\/a> and part of this free <a href=\"https:\/\/community.databricks.com\/t5\/technical-blog\/tutorial-databricks-genie-for-data-engineers-and-data-scientists\/ba-p\/168969\">tutorial on Databricks Genie<\/a> which comes with some cool avionics animations.<\/p>\n<h1>What is in the data?<\/h1>\n<ul>\n<li>Around 700 million avionic state points<\/li>\n<li>One full day; every plane flying on March 1st, 2026<\/li>\n<li>Per aircraft: position (lat, lon), altitude, callsign and the ICAO aircraft id<\/li>\n<li>Served as a table you query from pandas, Spark and other clients<\/li>\n<\/ul>\n<h1>How the OpenSharing works<\/h1>\n<p>It runs on OpenSharing, the open protocol (Linux Foundation, Apache 2.0), so to read it you:<\/p>\n<ol>\n<li>Grab a small credential file<\/li>\n<li>Point the <code>delta-sharing<\/code> client at it<\/li>\n<li>Load the table<\/li>\n<\/ol>\n<p>No vendor, cloud, or platform lock-in, no data copy, no vendor SDK.<\/p>\n<h1>Why it&#8217;s cool<\/h1>\n<ul>\n<li>It is a real large dataset, not a toy CSV, so it makes a great source for your own Spark and pandas examples, demos and benchmarks.<\/li>\n<li>Real data means it&#8217;s dirty. There are outliers. Some sensors sent test data. Yes, that&#8217;s cool!<\/li>\n<li>It&#8217;s fabulous data for animations, visualization, geo apps.<\/li>\n<li>The data is free, and OpenSharing just hands you a plain table, so you can process it almost anywhere: a laptop with pandas, a Spark cluster, or any other engine.<\/li>\n<li>This is a static dataset. We have no intention to update it at all (the titanic dataset wasn&#8217;t updated either). Using Apache SDP, you can get the current avionics data as a data stream. I published the tutorial in this <a href=\"https:\/\/www.reddit.com\/r\/dataengineering\/comments\/1wm64sf\/getting_started_with_apache_spark_declarative\/\">reddit posting on \/dataengineering<\/a>.<\/li>\n<\/ul>\n<h1><a href=\"https:\/\/community.databricks.com\/t5\/technical-blog\/tutorial-databricks-genie-for-data-engineers-and-data-scientists\/ba-p\/168969\">The tutorial<\/a><\/h1>\n<p>I built a small free tutorial around it, fully open source. The step that reads the shared data is just pandas in VS Code, no Spark, so anyone can replicate it for free.<\/p>\n<h1>Why I care (and you should too)<\/h1>\n<p>Databricks created a lot of the open source projects you know, Spark, Delta Lake, MLflow and Delta Sharing, and I like showing how well it also plugs into the wider open source ecosystem.<\/p>\n<p>This is one of a series of small, free tutorials based on that OpenSky dataset. All of these tutorials run on Free Edition (no cost, no credit card, sign-up with Gmail etc).<\/p>\n<p>This section focuses on open source data sharing. Reading a shared dataset with nothing but pandas is a good example \ud83d\ude42<\/p>\n<ul>\n<li>Check out t<a href=\"https:\/\/github.com\/databricks\/tmm\/blob\/main\/DSDE-Genie-Tutorial\/docs\/70-opensharing.md\">his tutorial step with OpenSharing, VS Code and Pandas<\/a><\/li>\n<li>I published the full guide as a Databricks Community Tech blog which entirely runs on Databricks Free Edition (no credit card required!): <a href=\"https:\/\/community.databricks.com\/t5\/technical-blog\/tutorial-databricks-genie-for-data-engineers-and-data-scientists\/ba-p\/168969\">Tutorial: Genie for Data Engineers and Data Scientists on Databricks Free Edition<\/a><\/li>\n<\/ul><\/div>\n<p><!-- SC_ON -->   submitted by   <a href=\"https:\/\/www.reddit.com\/user\/CompetitiveBet8978\"> \/u\/CompetitiveBet8978 <\/a> <br \/> <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/1wn3cwq\/new_data_set_700_million_data_points_from_opensky\/\">[link]<\/a><\/span>   <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/1wn3cwq\/new_data_set_700_million_data_points_from_opensky\/\">[comments]<\/a><\/span><\/p><div class='watch-action'><div class='watch-position align-right'><div class='action-like'><a class='lbg-style1 like-42645 jlk' href='javascript:void(0)' data-task='like' data-post_id='42645' data-nonce='b9a40cecc8' rel='nofollow'><img class='wti-pixel' src='https:\/\/www.graviton.at\/letterswaplibrary\/wp-content\/plugins\/wti-like-post\/images\/pixel.gif' title='Like' \/><span class='lc-42645 lc'>0<\/span><\/a><\/div><\/div> <div class='status-42645 status align-right'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>Together with OpenSky Network I published a 700 million record dataset of every plane flying world-wide on&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[85],"tags":[],"class_list":["post-42645","post","type-post","status-publish","format-standard","hentry","category-datatards","wpcat-85-id"],"_links":{"self":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/42645","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/comments?post=42645"}],"version-history":[{"count":0,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/42645\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/media?parent=42645"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/categories?post=42645"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/tags?post=42645"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}