How to convert integer number to latitude and longitude

Question

Initially the data was in BLOB field of SQLite database then -> hex data -> decimal data.

(ëÑ·,Êz¾5)->(14EBD1B7, CA7ABE35)->(350998860, 3397041663)

Finally, I got a set like this:

I know the data was taken close to the university of Memphis with Latitude:N 35° 7' 6.9956" Longitude:W 89° 56' 13.204". But I have not found any way to obtain a similar values from this dataset. Any ideas?

score 0 · Answer 1 · edited May 23 '17 at 10:26

taking reference from this link i wrote following function and it is working perfectly:

Private Function ConvertHexToLatLng(h As String) As Double
    Dim intDec As Integer
    intDec = Convert.ToInt32(h, 16)
    Dim dblLatOrLng As Double
    If intDec < Convert.ToInt32("7FFFFFFF", 16) Then
        dblLatOrLng = intDec * 0.0000001
    Else
        dblLatOrLng = 0 - ((Convert.ToInt32("FFFFFFFF", 16) - intDec) * 0.0000001)
    End If
    Return dblLatOrLng
End Function

How to convert integer number to latitude and longitude

1 Answers1