KeJyun kejyun
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // 找捷運台北車站附近距離2公里內的捷運站 | |
| db.lbs_test.find({loc: {$near:[25.046084,121.517542] , $maxDistance:2/111.12 }}).forEach(printjson); | |
| //查詢結果 | |
| { | |
| "_id" : ObjectId("5238179cdfba7ac818bb5fcd"), | |
| "name" : "捷運臺大醫院站", | |
| "loc" : { | |
| "lat" : 25.041535, | |
| "long" : 121.516029 |
kejyun
/ mongodb_find_lbs_orderby_time.js
Created
September 17, 2013 09:58
MongoDB LBS查詢範例 : 找捷運台北車站附近距離2公里內的捷運站、依照建立時間做排序
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // 找捷運台北車站附近距離2公里內的捷運站、依照建立時間做排序 | |
| db.lbs_test.find({loc: {$near:[25.046084,121.517542] , $maxDistance:2/111.12 }}).sort({time:1}).forEach(printjson); | |
| //查詢結果 | |
| { | |
| "_id" : ObjectId("5238179cdfba7ac818bb5fcd"), | |
| "name" : "捷運臺大醫院站", | |
| "loc" : { | |
| "lat" : 25.041535, | |
| "long" : 121.516029 |
kejyun
/ mongodb_find_lbs_orderby_time_limit3.js
Last active
December 23, 2015 06:09
MongoDB LBS查詢範例 : 找捷運台北車站附近距離2公里內的捷運站、依照建立時間做排序、找前3筆資料
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // 找捷運台北車站附近距離2公里內的捷運站、依照建立時間做排序、找前3筆資料 | |
| db.lbs_test.find({loc: {$near:[25.046084,121.517542] , $maxDistance:2/111.12 }}).sort({time:1}).limit(3).forEach(printjson); | |
| //查詢結果 | |
| { | |
| "_id" : ObjectId("5238179cdfba7ac818bb5fcd"), | |
| "name" : "捷運臺大醫院站", | |
| "loc" : { | |
| "lat" : 25.041535, | |
| "long" : 121.516029 |
kejyun
/ mongodb_find_lbs_orderby_time_limit3_alldata.js
Created
September 17, 2013 10:06
MongoDB LBS查詢範例 : 找捷運台北車站附近距離2公里內的捷運站、依照建立時間做排序、找前3筆資料，查詢結果與預期比較
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // 找捷運台北車站附近距離2公里內的捷運站、依照建立時間做排序、找前3筆資料 | |
| // 預期查詢結果 | |
| { | |
| "_id" : ObjectId("5238179cdfba7ac818bb5fcd"), | |
| "name" : "捷運臺大醫院站", | |
| "loc" : { | |
| "lat" : 25.041535, | |
| "long" : 121.516029 | |
| }, | |
| "time" : 11 |
kejyun
/ mongodb_find_lbs_orderby_time_limit3_subquery.js
Created
September 17, 2013 10:08
MongoDB LBS查詢範例 : 找捷運台北車站附近距離2公里內的捷運站、依照建立時間做排序、找前3筆資料(子查詢)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| var query = db.lbs_test.find({loc: {$near:[25.046084,121.517542] , $maxDistance:2/111.12 }}).sort({time:1}); | |
| query.limit(3).forEach(printjson); | |
| // 查詢結果 | |
| { | |
| "_id" : ObjectId("5238179cdfba7ac818bb5fcd"), | |
| "name" : "捷運臺大醫院站", | |
| "loc" : { | |
| "lat" : 25.041535, |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| $ dpkg -l '*php*' | |
| 要求=U:未知/I:安裝/R:刪除/P:清除/H:保留 | |
| | 狀態=N:未安裝/I:已安裝/C:設定檔/U:已解開/F:半設定/H:半安裝/W:待觸發/T:未觸發 | |
| |/ 錯誤?=(無)/R:須重新安裝（狀態，錯誤：大寫=有問題） | |
| ||/ 名稱 版本 簡介 | |
| +++-=================================-=================================-================================================================================== | |
| un libapache2-mod-php4 <無> （無相關介紹） | |
| ii libapache2-mod-php5 5.4.19-1+debphp.org~precise+3 server-side, HTML-embedded scripting language (Apache 2 module) | |
| un libapache2-mod-php5filter <無> （無相關介紹） | |
| un libow-php5 <無> （無相關介紹） |
kejyun
/ mongodb_aggregation_lbs_search.js
Last active
December 23, 2015 07:59
MongoDB Aggregation LBS查詢:找捷運台北車站附近距離2公里內的捷運站
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // 找捷運台北車站附近距離2公里內的捷運站 | |
| db.lbs_test.aggregate( | |
| { | |
| $geoNear : { | |
| near : [25.046084,121.517542], | |
| distanceField : "dist", | |
| maxDistance : 2 / 111.12 | |
| } | |
| } | |
| ); |
kejyun
/ mongodb_aggregation_lbs_search_orderby_time.js
Created
September 18, 2013 03:24
MongoDB Aggregation LBS查詢:找捷運台北車站附近距離2公里內的捷運站、依照建立時間做排序
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // 找捷運台北車站附近距離2公里內的捷運站、依照建立時間做排序 | |
| db.lbs_test.aggregate( | |
| { | |
| $geoNear : { | |
| near : [25.046084,121.517542], | |
| distanceField : "dist", | |
| maxDistance : 2 / 111.12 | |
| } | |
| }, | |
| { |
kejyun
/ mongodb_aggregation_lbs_search_orderby_time_limit3.js
Created
September 18, 2013 03:26
MongoDB Aggregation LBS查詢:找捷運台北車站附近距離2公里內的捷運站、依照建立時間做排序、找前3筆資料
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // 找捷運台北車站附近距離2公里內的捷運站、依照建立時間做排序、找前3筆資料 | |
| db.lbs_test.aggregate( | |
| { | |
| $geoNear : { | |
| near : [25.046084,121.517542], | |
| distanceField : "dist", | |
| maxDistance : 2 / 111.12 | |
| } | |
| }, | |
| { |
kejyun
/ mongodb_aggregation_lbs_search_orderby_time_limit3_offset3.js
Created
September 18, 2013 03:28
MongoDB Aggregation LBS查詢:找捷運台北車站附近距離2公里內的捷運站、依照建立時間做排序、找第4、5、6筆的資料
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // 找捷運台北車站附近距離2公里內的捷運站、依照建立時間做排序、找第4、5、6筆的資料 | |
| db.lbs_test.aggregate( | |
| { | |
| $geoNear : { | |
| near : [25.046084,121.517542], | |
| distanceField : "dist", | |
| maxDistance : 2 / 111.12 | |
| } | |
| }, | |
| { |