Mongodb Query for finding distance between latitude and longitude points

geocodinggeolocationmongodbmongodb-querymongoose

I have a user's collection with Latitude and longitude points for each user.

I want to calculate distance between given Lat, long values and
user's location.

In MYSQL there is a query for it

SELECT id, ( 3959 * acos( cos( radians(37) ) * cos( radians( lat ) ) * cos( radians( lng ) - radians(-122) ) + sin( radians(37) ) * sin( radians( lat ) ) ) ) AS distance FROM markers HAVING distance < 25 ORDER BY distance LIMIT 0 , 20;

Is there any equivalent approach/ Query in mongodb? There are ways to accomplish this in Javascript but it would be better if coded in a Query.

Best Answer

Mongo does not provide you with easy field manipulations like you had in sql world. Some of the geospatial results give you back the distance as well, but for the task you want, I would rather do this calculation afterwards. There is a question on SO which targets you perfectly and among many answers I gave an optimized javascript solution.

Related Solutions

Mysql – how to get accurate or (near accurate) distance between two places? Mysql/PHP

Have a look at this source code. When I tested it against various other measurement services it seemed to get the same results. It's C# but the math should be easy enough to convert.

Here are the relevant pieces:

public const double EarthRadius = 6371.0072; // Kilometers
//public const double EarthRadius = 3958.76; // Miles

/* ... */

const double dtr = Math.PI / 180;
double latA = this.Latitude * dtr;
double lonA = this.Longitude * dtr;
double latB = other.Latitude * dtr;
double lonB = other.Longitude * dtr;

return GpsLocation.EarthRadius * Math.Acos(Math.Cos(latA) * Math.Cos(latB) * Math.Cos(lonB - lonA) + Math.Sin(latA) * Math.Sin(latB));

Note: The Earth is not perfectly spherical, so the constants used may differ. There is no easy way to make the measurements truly exact. See Wikipedia.

Mysql – A reverse of Haversine formula for MySQL

MySQL has a whole host of spatial data functions:

Spatial Extensions to MySQL

I think the section on measuring the relationships between geometries is what you're after:

Relationships Between Geometries

Best Answer

Related Solutions

Mysql – how to get accurate or (near accurate) distance between two places? Mysql/PHP

Mysql – A reverse of Haversine formula for MySQL

Related Topic