tag:blogger.com,1999:blog-344660277417596719.post2537968615859541775..comments2023-09-17T13:48:37.787+01:00Comments on Midge Diabolik - Another Byte Of Banality: That 'Hidden' iPhone Location File for Windows UsersDigbeth Slackerhttp://www.blogger.com/profile/10670669850700593818noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-344660277417596719.post-38580629109829342792011-04-23T12:57:58.469+01:002011-04-23T12:57:58.469+01:00Use this sql to convert the unix timestamp to a lo...Use this sql to convert the unix timestamp to a local timeformat:<br /><br />SELECT datetime(Timestamp,'unixepoch','localtime'), latitude, longitude FROM celllocationTiNNiThttps://www.blogger.com/profile/11713605886412879837noreply@blogger.comtag:blogger.com,1999:blog-344660277417596719.post-54902581564091300082011-04-22T17:19:30.707+01:002011-04-22T17:19:30.707+01:00@Michael i've had a quick Google and here'...@Michael i've had a quick Google and here's an article that shows how to convert Unix style Timestamps to dd/mm/yy in a spreadsheet.<br /><br />http://spreadsheetpage.com/index.php/tip/converting_unix_timestamps/<br /><br />note: the formula needs tweaking to read..<br /><br />=(((A1/60)/60)/24)+DATE(2001,1,1)Digbeth Slackerhttps://www.blogger.com/profile/10670669850700593818noreply@blogger.comtag:blogger.com,1999:blog-344660277417596719.post-16820938998954471012011-04-22T16:57:54.393+01:002011-04-22T16:57:54.393+01:00@Michael You would use
SELECT Latitude, Longitude...@Michael You would use<br /><br />SELECT Latitude, Longitude, Timestamp FROM CellLocation<br /> <br />in SQLLite 'Execute SQL' tab (and add 'name' heading in the .csv file).<br /> The slight problem is it uses a Unix style Timestamp (seconds elapsed from January 1st 2001).I guessing there's a method to change this to a regular dd/mm/yy time format in a spreadsheet (made from .csv file) but that is a bit beyond me atm.Digbeth Slackerhttps://www.blogger.com/profile/10670669850700593818noreply@blogger.comtag:blogger.com,1999:blog-344660277417596719.post-80678099613415352892011-04-22T10:47:38.678+01:002011-04-22T10:47:38.678+01:00Thanks, it worked great! I had 23000+ coords so va...Thanks, it worked great! I had 23000+ coords so vanilla google maps failed to render most of the points - Google Fusion tables came to the rescue.Ianhttps://www.blogger.com/profile/10417553109483803246noreply@blogger.comtag:blogger.com,1999:blog-344660277417596719.post-9511004292508958382011-04-22T09:40:04.247+01:002011-04-22T09:40:04.247+01:00This is great and worked perfectly. Thanks very mu...This is great and worked perfectly. Thanks very much.<br /><br />(You could mention that kml is found under "Google Earth (Keyhole) Markup Language" in GPSBabel for the ignorant like me.Nestorhttps://www.blogger.com/profile/11452471274055220125noreply@blogger.comtag:blogger.com,1999:blog-344660277417596719.post-36245888980488615672011-04-21T20:07:13.511+01:002011-04-21T20:07:13.511+01:00How do you add a timestamp to the lat/longs?How do you add a timestamp to the lat/longs?Unknownhttps://www.blogger.com/profile/03973635032424450111noreply@blogger.com