{"id":716,"date":"2018-06-04T17:51:09","date_gmt":"2018-06-04T15:51:09","guid":{"rendered":"https:\/\/aerospaceresearch.net\/?p=716"},"modified":"2018-06-11T22:34:48","modified_gmt":"2018-06-11T20:34:48","slug":"gsoc2018-orbit-determinator-implementing-two-line-element-tle-input-output-and-using-it-for-evaluation-aakash","status":"publish","type":"post","link":"https:\/\/aerospaceresearch.net\/?p=716","title":{"rendered":"[GSoC2018|OrbitDeterminator|Aakash] Implementing Two-Line Element (TLE) Input \/ Output and using it for evaluation"},"content":{"rendered":"<pre><span style=\"font-weight: 400;\">About the author:\u00a0<\/span><span style=\"font-weight: 400;\">Hello everyone, I am Aakash Deep, B.Tech student in Computer Science and Engineering (CSE) from Indraprastha Institute of Information Technology, Delhi (IIIT-D). Currently completed my 3rd year in it. I am a space enthusiast and always keep searching about the space.<\/span><\/pre>\n<h2>Introduction<\/h2>\n<p>Orbit Determinator,\u00a0 I think the project is self-explanatory. Yes, you are right the project is tracking the orbit of the satellites using their TLEs at different time points.<\/p>\n<p>TLE short for Two-Line Element. It is a data format encoding a list of orbital elements of the Earth-orbiting object for a given point in time. It consists of two line with each having character length 70. Orbital elements play a major\u00a0role in plotting the orbit of the satellite. Line2 of the TLE contains all the orbital elements.<!--more--><\/p>\n<h2>Organization: AerospaceResearch.net<\/h2>\n<p>AerospaceResearch.net is a small team but the scope of the projects are big. The organization works\u00a0with Small Satellite Student Society University o Stuttgart (KSat e.V.) and the Cosmic Dust Team and obviously with individual enthusiasts at the global level. Here all people work to solve problems related to space.<\/p>\n<p>The work culture of this organization is very good. You got the freedom to work on your project the way you like. Working for this organization makes me feel good as I got to know more about the things related to space.<\/p>\n<h2>Work till starting 2 weeks<\/h2>\n<p>The Google Summer of Code 2018 officially started on May 14. The very first step is to get the TLE data and to store it in a database.<\/p>\n<p>Now as we need a database, we must be clear which type of database we are going to use: SQL or No-SQL database. Both have their own advantages and disadvantages. After looking at the number of attributes we will need in a table, we chose SQL database.<\/p>\n<p>For the database initialisation and updates. I wrote two python codes:<\/p>\n<ul>\n<li>init_database.py<br \/>\nThe code first creates a database named <em><strong>cubesat<\/strong><\/em> in the MySQL database. Then is taking the NORAD cubesat TLEs from <a href=\"https:\/\/www.celestrak.com\/NORAD\/elements\/cubesat.txt\">here<\/a>\u00a0and for each satellite it creates a table with timestamp, line1 and line2 as attributes.The first problem came during the creation of tables in the database with table name as a satellite name because satellite name contains special characters (such as -,(,),whitespace). To solve this problem, I converted the name of the satellite into hexadecimal hash using md5 hash function.<img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-722\" src=\"https:\/\/aerospaceresearch.net\/wp-content\/uploads\/2018\/06\/mapping.png\" alt=\"\" width=\"1860\" height=\"1055\" \/><\/li>\n<li>scraper.py<br \/>\nThe code updates the database. First it makes a connection to database and then select the database as <em><strong>cubesat<\/strong><\/em>. Then scrapes the data from the <a href=\"https:\/\/www.celestrak.com\/NORAD\/elements\/cubesat.txt\">here<\/a>\u00a0and then it converts the satellite&#8217;s name into it&#8217;s corresponding md5 hexadecimal hash and updates the table by adding a tuple.<\/li>\n<\/ul>\n<p><!--more--><\/p>\n<p>The database contains a table named <em><strong>mapping<\/strong><\/em> which contains two attributes satellite name and it&#8217;s corresponding md5 hexadecimal hash.<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-723\" src=\"https:\/\/aerospaceresearch.net\/wp-content\/uploads\/2018\/06\/tables.png\" alt=\"\" width=\"1861\" height=\"1058\" \/><\/p>\n<h3>Work on Progress<\/h3>\n<ul>\n<li>The propagation model is almost complete.<\/li>\n<li>Testing<\/li>\n<li>Documentation<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>About the author:\u00a0Hello everyone, I am Aakash Deep, B.Tech student in Computer Science and Engineering (CSE) from Indraprastha Institute of Information Technology, Delhi (IIIT-D). Currently completed my 3rd year in it. I am a space enthusiast and always keep searching about the space. Introduction Orbit Determinator,\u00a0 I think the project is self-explanatory. Yes, you are &hellip; <a href=\"https:\/\/aerospaceresearch.net\/?p=716\" class=\"more-link\"><span class=\"screen-reader-text\">\u201e[GSoC2018|OrbitDeterminator|Aakash] Implementing Two-Line Element (TLE) Input \/ Output and using it for evaluation\u201c<\/span> weiterlesen<\/a><\/p>\n","protected":false},"author":11,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/aerospaceresearch.net\/index.php?rest_route=\/wp\/v2\/posts\/716"}],"collection":[{"href":"https:\/\/aerospaceresearch.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aerospaceresearch.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aerospaceresearch.net\/index.php?rest_route=\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/aerospaceresearch.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=716"}],"version-history":[{"count":11,"href":"https:\/\/aerospaceresearch.net\/index.php?rest_route=\/wp\/v2\/posts\/716\/revisions"}],"predecessor-version":[{"id":747,"href":"https:\/\/aerospaceresearch.net\/index.php?rest_route=\/wp\/v2\/posts\/716\/revisions\/747"}],"wp:attachment":[{"href":"https:\/\/aerospaceresearch.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=716"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aerospaceresearch.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=716"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aerospaceresearch.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=716"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}