I'm analyzing search_history.db table suggestions of Google Maps. There longitude latitude values have following data. {121106469, 16386922}
How can I interpret them in term of longitude / latitude values? (in degrees)
Edited post
The location appears to be in the Philippines
As I don’t have the actual table I created one with three fields, id, lat, long and used your example data.
Using the forensic browser for SQLite I created a new query as follows
SELECT coord2.id,
coord2.lat,
coord2.long,
SubStr(coord2.lat, 1, 2) || '.' || SubStr(coord2.lat, 3, 9) AS lat2,
SubStr(coord2.long, 1, 3) || '.' || SubStr(coord2.long, 4, 9) AS long2
FROM coord2
This creates a report for each row (just one in my example) with two new columns lat2 and long2 this splits your example data assuming that the integral part of the data is 2 digits for lat and 3 for long (this is quite standard)
The results look as follows
id lat long lat2 long2
1 16386922 121106469 16.386922 121.106469
I then create a temporary “view” called ‘NewCoordinates’ on this query (there is a menu option for this)
I then use the built in feature of the Forensic Browser for SQLite to create geolocated images from the lat and long data (this feature requires that the lat and long are stored in the ‘normal’ floating point format).
The resultant display looks as follows
Thank you for the descriptive reply )