How do I convert all geo locations in mongo db from strings to floats?

Question

skatespot-dev> db.parks.findOne();
{
  _id: ObjectId("638f9866d9014fabfc47275e"),
  address: '801 Pine St, Anchorage, AK',
  name: 'Russian Jack Skatepark',
  location: { type: 'Point', coordinates: [ '61.214855', '-149.793563' ] }
}

I need to run a query to convert all coodinates to floats i guess.

This is looks like a duplicate of [this question](https://stackoverflow.com/questions/37942844/mongodb-convert-string-type-to-float-type) — justin, Dec 07 '22 at 16:46

nimrod serok · Accepted Answer · 2022-12-07T18:02:14.740

1

You can convert them to double using update with pipeline, like this:

db.collection.updateMany({},
[
  {
    $set: {
      "location.coordinates": [
        {
          $toDouble: {
            $first: "$location.coordinates"
          }
        },
        {
          $toDouble: {
            $last: "$location.coordinates"
          }
        }
      ]
    }
  }
])

See how it works on the playground example

edited Dec 07 '22 at 18:02

answered Dec 07 '22 at 17:13

nimrod serok

14,151
2
11
33

How do I convert all geo locations in mongo db from strings to floats?

1 Answers1