地理位置索引

最新推荐文章于 2024-08-14 13:00:19 发布

weixin_30532987

最新推荐文章于 2024-08-14 13:00:19 发布

阅读量96

点赞数

文章标签： php 数据库

原文链接：http://www.cnblogs.com/xinhui/p/8920105.html

版权

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();

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#/

转载于:https://www.cnblogs.com/xinhui/p/8920105.html

关注