How to import specific csv values as array in MongoDB?

Question

I have a mysql table that has postcode and co-ordinates that I would like to import to Mongo. After exporting to csv and importing to MongoDB it looks like this

> db.postcode.findOne()
{
        "_id" : ObjectId("5596d56365f8d76adbae63ed"),
        "postcode" : "AB101XG",
        "latitude" : 57.14416516,
        "longitude" : -2.114847768
}

However, I would like to have the co-ordinates in a array format (assuming it is the format required for geo queries) as below

> db.postcode.findOne()
{
        "_id" : ObjectId("5596d56365f8d76adbae63ed"),
        "postcode" : "AB101XG",
        "loc" : [57.14416516, -2.114847768]
}

Being newbie to Mongo, I am not sure how to achieve it.

Can't you post process it?

michelem
– michelem

2015-07-03 18:49:23 +00:00
Commented Jul 3, 2015 at 18:49 — michelem
– michelem, Commented Jul 3, 2015 at 18:49

Bala · Accepted Answer · 2016-07-22 10:42:31Z

3

Looks like post processing was the only way to go.

> db.postcode.find().forEach( function(r) { 
    r.loc = [r.latitude, r.longitude]; 
    db.postcode.save(r); 
  });

edited Jul 22, 2016 at 10:42

answered Jul 4, 2015 at 5:49

Bala

11.3k19 gold badges75 silver badges133 bronze badges

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

1 Comment

Harry Moreno Over a year ago

Just to clarify, db.postcode.save(r) does an update of the document as desired.

Collectives™ on Stack Overflow

How to import specific csv values as array in MongoDB?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related