地理位置索引

PHP 代码(使用yiisoft/yii2-mongodb):

$longitude = 113.801367;

$latitude = 22.987066;

 

$param = array(

'loc' => array(

'$nearSphere' => array(

'$geometry' => array(

'type' => 'Point',

'coordinates' => array(doubleval($longitude), doubleval($latitude)),

),

'$maxDistance' => 50 * 1000

)

)

);

 

$result = StationMongo::findAll($param);

 

 

var_dump($result);

exit();

 

 

https://www.2cto.com/database/201406/305985.html

https://blog.csdn.net/flamingsky007/article/details/39208837

https://blog.csdn.net/ghlfllz/article/details/6774315

 

 

db.station.insert({"address" : "南京 禄口国际机场","loc" : { "type": "Point", "coordinates": [118.783799,31.979234]}})

db.station.insert({"address" : "南京 浦口公园","loc" : { "type": "Point", "coordinates": [118.639523,32.070078]}})

db.station.insert({"address" : "南京 火车站","loc" : { "type": "Point", "coordinates": [118.803032,32.09248]}})

db.station.insert({"address" : "南京 新街口","loc" : { "type": "Point", "coordinates": [118.790611,32.047616]}})

db.station.insert({"address" : "南京 张府园","loc" : { "type": "Point", "coordinates": [118.790427,32.03722]}})

db.station.insert({"address" : "南京 三山街","loc" : { "type": "Point", "coordinates": [118.788135,32.029064]}})

db.station.insert({"address" : "南京 中华门","loc" : { "type": "Point", "coordinates": [118.781161,32.013023]}})

db.station.insert({"address" : "南京 安德门","loc" : { "type": "Point", "coordinates": [118.768964,31.99646]}})

 

 

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

 

db.station.find({loc:{$near: {$geometry: {type: "Point" ,coordinates: [118.783799,31.979234]},$maxDistance: 5000}}}) //5000米以内数据

 

为什么用db.station.find(), 真实collection位于db.qshd.station.

 

该文转载：https://note.youdao.com/share/?id=05f3dd85f8da6823d6a95467a0a01522&type=note#/