MongoDB 空間定位（點） 與 距離檢索

標籤：mongodb   位置空間資料   位置檢索   

基於 MongoDB 2.6

GeoJSON 格式

{ "type": "Point", "coordinates": [lon(經度),lat(緯度)]}

測試資料

db.point.test.insert({"address" : "南京 祿口國際機場","loc" : { "type": "Point", "coordinates": [118.783799,31.979234]}})db.point.test.insert({"address" : "南京 浦口公園","loc" : { "type": "Point", "coordinates": [118.639523,32.070078]}})db.point.test.insert({"address" : "南京 火車站","loc" : { "type": "Point", "coordinates": [118.803032,32.09248]}})db.point.test.insert({"address" : "南京 新街口","loc" : { "type": "Point", "coordinates": [118.790611,32.047616]}})db.point.test.insert({"address" : "南京 張府園","loc" : { "type": "Point", "coordinates": [118.790427,32.03722]}})db.point.test.insert({"address" : "南京 三山街","loc" : { "type": "Point", "coordinates": [118.788135,32.029064]}})db.point.test.insert({"address" : "南京 中華門","loc" : { "type": "Point", "coordinates": [118.781161,32.013023]}})db.point.test.insert({"address" : "南京 安德門","loc" : { "type": "Point", "coordinates": [118.768964,31.99646]}})

一定要加索引

db.point.test.ensureIndex( { loc : "2dsphere" } )

檢索規定半徑以內資料（單位為米）

{loc:{$near: {$geometry: {type: "Point" ,coordinates: [118.783799,31.979234]},$maxDistance: 5000}}} //5000米以內資料

MongoDB 空間定位（點） 與 距離檢索