mongodb mongoose unit of maxDistance
In my application, I am trying to use, RentModel.find({prop_location : { $near : [msg.lat, msg.lng], $maxDistance : 500}}, function(err, docs){} I have only one value in the database with latitude, longitude of san francisco. Now,
- When there is no maxDistance => It finds out the location perfectly from anywhere.
- When开发者_如何学编程 I add maxDistance as 5 and search exactly at the same location (with same latitude, longitude), it does not find the location.
- If it is 50, same as point 2.
- If it is 500, I can even find the location from London.
What's wrong ?
what is the unit of distance ? I want to find out everything within 5km (kilometer) distance. will db.executeCommand solve my problem ? need to check.
Thanks in advance.
Finally I found the answer to my problem. Theoretically longitude is x-axis and latitude is y-axis. But we are used to latitude- longitude rather than longitude-latitude... So the way I was searching was wrong
$near : [msg.lat, msg.lng]
When I changed this to $near : [msg.lng, msg.lat] , it started working even with 5KM... So ordering was the problem.
You need to divide the maxdistance value by 111.12 (one degree is approximately 111.12 kilometers) to convert the degree radius to km distance.
so you can try this
RentModel.find({prop_location : { $near : [msg.lat, msg.lng], $maxDistance : 500/111.2}})
But the same works different is sphere queries, there you have to divide the degree radius by earth-radius 6371 to work with km values
精彩评论