Using find () with geospatial coordinates in Mongoose (NodeJS + MongoDB)

Question

Mongoose version: 3.6 Node version: 0.10

I tried to solve this problem for hours. I want to find all documents closer than maxDistance to some coordinates. I am trying to use GeoJSON specifications for MongoDB (2dsphere) so that I can enter the distance in meters.

This is my venue.js schema:

var db = require('mongoose'), Schema = db.Schema, ObjectId = Schema.ObjectId; var venueSchema = new Schema({ geo: { type: [Number], index: '2dsphere'}, city: String, name: String, address: String }); module.exports = db.model('Venue', venueSchema); 

Here I insert the ctrlVenue.js request:

 var Venue = require('../models/venue.js'); VenueController = function(){}; /** GET venues list ordered by the distance from a "geo" parameter. Endpoint: /venues Params: - geo: center for the list of venues - longitude, latitude (default: 25.466667,65.016667 - Oulu); - maxDistance: maxímum distance from the center for the list of venues (default: 0.09) **/ exports.getVenues =function(req, res) { var maxDistance = typeof req.params.maxDistance !== 'undefined' ? req.params.maxDistance : 0.09; //TODO: validate var geo = typeof req.params.geo !== 'undefined' ? req.params.geo.split(',') : new Array(25.466667, 65.016667); //TODO: validate var lonLat = { $geometry : { type : "Point" , coordinates : geo } }; Venue.find({ geo: { $near: lonLat, $maxDistance: maxDistance }}).exec(function(err,venues){ if (err) res.send(500, 'Error #101: '+err); else res.send(venues); }); } 

When I run the code, I get an error message:

"Error # 101: CastError: failed on number with error for value \" [object Object] \ "at path \" geo \ ""

If I change this line:

 $near: lonLat, 

with

 $near: geo, 

I receive documents correctly, but then I can not use counters as a unit of measure. I based my assumptions on the following table: http://docs.mongodb.org/manual/reference/operator/query-geospatial/

I saw many examples of work using $ geometry, but not one along with $ next. What am I doing wrong?

Answer 1

I had to use the Mixed type and added some custom validation to ensure that the values ​​were arrays and had a length of 2. I also checked for empty arrays and converted them to null , because this is necessary when using sparse indexes with 2dsphere . (Mongoose helps set the array fields to [] for you, which is not a valid coordinate!)

 var schema = new mongoose.Schema({ location: { type: {}, index: '2dsphere', sparse: true } }); schema.pre('save', function (next) { var value = that.get('location'); if (value === null) return next(); if (value === undefined) return next(); if (!Array.isArray(value)) return next(new Error('Coordinates must be an array')); if (value.length === 0) return that.set(path, undefined); if (value.length !== 2) return next(new Error('Coordinates should be of length 2')) next(); });