Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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,

    1. When there is no maxDistance => It finds out the location perfectly from anywhere.
    2. When I add maxDistance as 5 and search exactly at the same location (with same latitude, longitude), it does not find the location.
    3. If it is 50, same as point 2.
    4. 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.

like image 886
user644745 Avatar asked Sep 30 '11 04:09

user644745


2 Answers

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.

like image 183
user644745 Avatar answered Nov 11 '22 04:11

user644745


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

like image 7
RameshVel Avatar answered Nov 11 '22 04:11

RameshVel