Android sqlite how to calculate distance from latitude and longitude

Asked Jan 14 '16 at 08:54

Active Jan 14 '16 at 09:01

Viewed 360 times

I am calculating distance from latitude and longitude in sqlite in android. First I have to fetch coordinates from web service then I have to converted coordinates from degrees to radians using below code:

 Math.cos(deg2rad(outlet.getLatitude()))
 Math.sin(deg2rad(outlet.getLatitude()))
 public static double deg2rad(double deg) {
     return (deg * Math.PI / 180.0);
 }

then I have inserted it into my Table and then I am using this query to calculate the distance in sqlite. When I run this query:

SELECT "location",
(sin_lat_rad  "sin_lat_rad" + cos_lat_rad  "cos_lat_rad" *
 (sin_lon_rad  "sin_lon_rad" + cos_lon_rad  "cos_lon_rad"))

I am getting 0.99999999 in output

edited Jan 14 '16 at 09:01

mixel

25,177
13
126
165

asked Jan 14 '16 at 08:54

Achin

1,252
4
28
63

What is your question? – Egor Jan 14 '16 at 08:55
i need to calculate distance from my current lat / long to destination lat / long – Achin Jan 14 '16 at 08:56
@Achin: You can use the Haversine algorithm http://stackoverflow.com/a/17787472/1878151 – kevz Jan 14 '16 at 09:02
i want to calculate the distance using sqlite query – Achin Jan 14 '16 at 09:04
i am using this procedure http://stackoverflow.com/questions/10126404/calculate-distance-between-two-points-directly-in-sqlite – Achin Jan 14 '16 at 09:21

Android sqlite how to calculate distance from latitude and longitude

0 Answers0