将位置数据存储在Mongodb文档中 [英] Store location data in Mongodb document

问题描述

在当前项目中，我将以下格式的位置数据存储在Mongodb文档中

In my current project , I am storing the location data in the following format in a Mongodb document

"location" : {
        "loc" : {
            "lng" : -118.15592692,
            "lat" : 34.03566804
        },
        "geocode" : {
            "city" : "East Los Angeles",
            "state" : "CA",
            "zipcode" : "90022",
            "countrycode" : "US",
            "country" : "United States"
        }
    }

在location.loc字段上创建了一个二维索引:-

There is a 2d index created on location.loc field:-

{
    "location.loc" : "2d"
}

但是，当结果集很大(即超过7000条记录)时，地理空间查询会花费很长时间. 在我看来，该索引不起作用.是因为数据没有以以下格式存储:-

But the geospatial queries are taking long time when the result set is large i.e more than 7000 records. it seems to me that the index is not working . Is it because the data has not been stored in the format:-

loc: [-118.15592692, 34.03566804]

请提出可以改善性能的建议?

Please suggest what can be done to improve the performance?

推荐答案

更新您的文档并创建一个新集合

Update your documents and create a new collection

db.location.aggregate([
  { "$addFields": {
    "location": {
      "type": "Point",
      "coordinates": ["$location.loc.lng", "$location.loc.lat"]
    },
    "geocode": "$location.geocode"
  }},
  { "$out": "location" }
])

然后在location字段上创建索引

db.location.createIndex({ "location": "2d" })

这篇关于将位置数据存储在Mongodb文档中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！