Mongoose near(...) query on 2dsphere indexed field not returning valid results

Question

I am unable to query a mongodb database using mongoose's `qry.where().near()` syntax. I have a Schema with coordinates stored as an array, indexed as `2dsphere`: ``` loc : { type: [Number], index: '2dsphere' } ``` I am running a mongoose query using `.where().near()`: ``` qry.where('loc').near({ center: search.loc, maxDistance: search.distance * 1000 }); ``` I have enabled `mongoose.set('debug', true)`, and can see the resulting debug: Inserting 2 documents in the collection with coordinates `[ 10, -20 ]`: ``` Mongoose: models.insert({ _id: ..., loc: [ 10, -20 ], type: 'apple' }) {} Mongoose: models.insert({ _id: ..., loc: [ 10, -20 ], type: 'orange' }) {} ``` Searching for documents near coordinates `[ 10, -20 ]`: ``` Mongoose: models.find({ loc: { '$near': [ 10, -20 ], '$maxDistance': 1000 } }) ``` The query returns no results. I have proved the documents are in the database by searching on `type`. Its the geospatial query I can't get to work. I am using `mongodb v2.6.1` and `mongoo…

Accepted Answer

Seems this is a moongoose bug.

Changing the query to use a `GeoJSON` object instead of a coordinate pair, as such:

```
qry.where('loc').near({
    center: {
        type: 'Point',
        coordinates: search.loc
    },
    maxDistance: search.distance * 1000
});
```

results in the following query:

```
Mongoose: models.find({ loc: { '$near': { 
        '$maxDistance': 1,
        '$geometry': { type: 'Point', coordinates: [ 10, -20 ] } } } 
    }) { fields: undefined }  
```

The search now succeeds.

The docs explicitly show a query using a coordinate pair:

```
query.where('loc').near({ center: [10, 10], maxDistance: 5 });
```

However, it looks like this doesn't work, and the example should be:

```
query.where('loc').near({ center: { coordinates: [10, 10], type: 'Point' }, maxDistance: 5 });
```

Mongoose near(...) query on 2dsphere indexed field not returning valid results

Solution

Problem