GeoLocation query in mongo db

Question

How Could i get longitude and lattitude using mongodb query from mongo collection based on disatnce and certain coordinates.

{
    "_id" : ObjectId("5a559b13ae201d0c05cb6f6a"),
    "id" : "99623",
    "city" : "Wasilla",
    "cnty" : "Matanuska Susitna",
    "cntyFips" : null,
    "st" : "AK",
    "stName" : "Alaska",
    "areaCode" : "907",
    "lat" : 61.5816,
    "long" : -149.4393,
    "rgn" : "West",
    "__v" : 0 
}

in this document "lat" is for latitude and "long" is for longitude.

so basically i have to get all ids based on present id lat and long which comes in a particular miles distance range.

Alexis Facques · Accepted Answer · 2018-04-18 13:30:29Z

1

Mongo supports GeoJSON which should allow you to perform basic queries easily on these kind of data. Examples include $geoWithin for your particular use-case.

answered Apr 18, 2018 at 13:30

Alexis Facques

1,8733 gold badges14 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

O Genthe · Accepted Answer · 2018-04-18 20:55:08Z

0

We need a little more information on the structure of the documents that you are querying, but here is a simple example of the query available in the Mongo documentation here.
It's worth noting that you require a 2dsphere index for location data defined as GeoJSON points in order for this to be effective.

 {
   $nearSphere: {
      $geometry: {
         type : "Point",
         coordinates : [ <longitude>, <latitude> ]
      },
      $minDistance: <distance in meters>,
      $maxDistance: <distance in meters>
   }
 }

edited Apr 18, 2018 at 20:55

answered Apr 18, 2018 at 20:44

O Genthe

17111 bronze badges

5 Comments

dpk45 Over a year ago

i have a document which contains latitude and longitude and id as zipcode. { "_id" : ObjectId("5a559b13ae201d0c05cb6f6a"), "id" : "99623", "city" : "Wasilla", "cnty" : "Matanuska Susitna", "cntyFips" : null, "st" : "AK", "stName" : "Alaska", "areaCode" : "907", "lat" : 61.5816, "long" : -149.4393, "rgn" : "West", "__v" : 0 } in this document lat is for latitude and long is for longitude. so basically i have to get all ids based on present id lat and long which comes in a particular miles distance range.

O Genthe Over a year ago

Is it possible to update the structure of your data or are you locked into the format? You could write a complex query that could get the information but it would be best and fastest to get your data coordinates into a GeoJSON format.

dpk45 Over a year ago

thnx @Genthe i managed my document structure in GeoJSON format .

O Genthe Over a year ago

So it's all working for you now or do you still need assistance?

O Genthe Over a year ago

That's great. Glad you are sorted.

Collectives™ on Stack Overflow

GeoLocation query in mongo db

2 Answers 2

Comments

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related