MongoDB print distance between two points

by

You can use the $geoNear aggregate pipeline stage to produce a distance from the queried point:

 db.new_stores.aggregate([
    { "$geoNear": {
        "near": {
            "type": "Point",
            "coordinates": [ -81.093699, 32.074673 ]
        }, 
        "maxDistance": 500 * 1609,
        "key" : "myLocation",
        "spherical": true,
        "distanceField": "distance",
        "distanceMultiplier": 0.000621371
    }}
]).pretty()

This allows you to specify "distanceField" which will produce another field in the output documents containing the distance from the queried point. You can also use "distanceMultiplier" to apply any conversion to the output distance as required ( i.e meters to miles, and noting that all GeoJSON distances are returned in meters )

There is also the geoNear command with similar options, but it of course does not return a cursor as output.

if you have more than one 2dsphere, you should specify a "key".

More Related Contents:

  1. MongoDB ‘unable to find index for $geoNear query’
  2. Geospatial $near within current document field value
  3. Group result by 15 minutes time interval in MongoDb
  4. Random record from MongoDB
  5. Moongoose aggregate $match does not match id’s
  6. Find in Double Nested Array MongoDB
  7. MongoDB: upsert sub-document
  8. How to join multiple collections with $lookup in mongodb
  9. Check if every element in array matches condition
  10. Get a count of total documents with MongoDB when using limit
  11. How can I get a random record from MongoDB?
  12. Include all existing fields and add new fields to document
  13. mongodb count num of distinct values per field/key
  14. MongoDB aggregation comparison: group(), $group and MapReduce
  15. Mongodb aggregation lookup with conditions
  16. MongoDB group by array inner-elements
  17. Multiple Counts with single query in mongodb
  18. How to return array of string with mongodb aggregation
  19. How to return just the nested documents of an array from all documents
  20. What is a Cursor in MongoDB?
  21. Get n-th element of an array in MongoDB
  22. Pull and addtoset at the same time with mongo
  23. How do I rename fields when performing search/projection in MongoDB?
  24. mongodb aggregation framework match by nested documents
  25. Efficient paging in MongoDB using mgo
  26. How to get back the new value after an update in a embedded array?
  27. count array occurrences across all documents with mongo
  28. Mongodb concat int and string
  29. Return actual type of a field in MongoDB
  30. MongoDB $lookup on nested document

Leave a Comment