Error creating Geospatial index in MongoDB

Question

I have a collection ('stops') with 14000 records imported from a CSV. Included in each record is some geospatial data, which I've converted into an array, so each essentially looks like this:

{
  _id: ...,
  // other fields
  "loc": [
    153.019073,
    -27.467834
  ]
}

When I run db.stops.ensureIndex({ loc: '2d' }) it gives the error:

location object expected, location array not in correct format

I guess that something's wrong in one of the fields, but I can't figure out which one. Any ideas?

nickf · Accepted Answer · 2012-12-20 14:30:41Z

1

The problem was that there was a single record which wasn't imported correctly (probably an empty line at the end of the file).

To find it (and later remove it), I used the $where operator:

db.stops.find({ $where: 'typeof this.loc[0] != "number"' })

answered Dec 20, 2012 at 14:30

nickf

548k199 gold badges660 silver badges727 bronze badges

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

Collectives™ on Stack Overflow

Error creating Geospatial index in MongoDB

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related