{"id":37,"date":"2007-05-10T01:29:57","date_gmt":"2007-05-10T05:29:57","guid":{"rendered":"http:\/\/www.virtualroadside.com\/blog\/index.php\/2007\/05\/10\/introducing-standalone-gps-sql-logging-software-for-linux\/"},"modified":"2007-05-10T10:59:40","modified_gmt":"2007-05-10T14:59:40","slug":"introducing-standalone-gps-sql-logging-software-for-linux","status":"publish","type":"post","link":"https:\/\/www.virtualroadside.com\/blog\/index.php\/2007\/05\/10\/introducing-standalone-gps-sql-logging-software-for-linux\/","title":{"rendered":"Standalone GPS SQL logging software for Linux"},"content":{"rendered":"<p>I was not able to find any decent standalone GPS data logging software for Linux (for use in my car computer), so I decided to write my own &#8212; and it works pretty well for what I want to do. Of course, I&#8217;m not quite sure what the practical implications are, but I guess I&#8217;ll figure that out later (and post it here, of course!). Anyways&#8230;<\/p>\n<p>geoHist is a (relatively) simple program I wrote to log GPS data retrieved from GPSD into a MySQL database. It is designed to meet the following requirements:<\/p>\n<ul>\n<li>Standalone<\/li>\n<li>Run from system startup to shutdown<\/li>\n<li>Small\/fast, non-intrusive<\/li>\n<li>Robust<\/li>\n<li>Log data to an SQL database<\/li>\n<\/ul>\n<p>geoHist will poll GPSD every 10 seconds and then send that data to a preconfigured MySQL database. It will attempt to detect if you are standing still, and if you are then it will NOT log the data. It decides this using a simple drift factor. It will always log position to the database at least once if there is a satellite fix.<\/p>\n<p>All this program does is log your data into mysql. You will need to figure out what exactly you want to do with that data. At the moment, I&#8217;m not quite sure what I&#8217;m going to do with the data either, but if I figure something out I will surely include it in the next release.<\/p>\n<p>I haven&#8217;t put it through a ton of use (yet), but it seems to be doing its job quite well. Now all I need to do is figure out a good practical application, and write some scripts to export the data from the database nicely.<\/p>\n<p>Link: <a href=\"http:\/\/www.virtualroadside.com\/geoHist\/\">http:\/\/www.virtualroadside.com\/geoHist\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>I was not able to find any decent standalone GPS data logging software for Linux (for use in my car computer), so I decided to write my own &#8212; and it works pretty well for what I want to do. Of course, I&#8217;m not quite sure what the practical implications are, but I guess I&#8217;ll [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9,6],"tags":[],"_links":{"self":[{"href":"https:\/\/www.virtualroadside.com\/blog\/index.php\/wp-json\/wp\/v2\/posts\/37"}],"collection":[{"href":"https:\/\/www.virtualroadside.com\/blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.virtualroadside.com\/blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.virtualroadside.com\/blog\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.virtualroadside.com\/blog\/index.php\/wp-json\/wp\/v2\/comments?post=37"}],"version-history":[{"count":0,"href":"https:\/\/www.virtualroadside.com\/blog\/index.php\/wp-json\/wp\/v2\/posts\/37\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.virtualroadside.com\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=37"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.virtualroadside.com\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=37"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.virtualroadside.com\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=37"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}