mongoDB index생성하여 좌표찍기

 

 

예제

db.tel_pos.save( { mobile_no : "01038631858",
last_pos : [ [127.0945116,37.5353970],
[126.9815316,37.5685375],
[127.0305035, 37.5017141] ] } )
db.tel_pos.save( {mobile_no : "01075993678",
last_pos : [ [127.1353452,37.4576521],
 [127.1359081,37.4512311],
[125.7823091, 36.3339801] ] })
db.tel_pos.save( {mobile_no : "01071229021",
last_pos : [ [126.3411234,36.1098761],
[124.3410922,37.3409901],
[127.2223331, 37.0912090] ] })

 

 

* 인덱스 생성

db.tel_pos.ensureIndex( {last_pos : "2d" } )

 

* 확인하기

db.tel_pos.find( { last_pos : { $within : { $centerSphere :[[ 127.0352915,37.5360206 ],30/3963] }} }, {_id : 0, mobile_no : 1, last_pos :1 }).pretty()

 

 

 

 

 

* 예제

db.position.insert( { "_id" :  "m239092" , "data_type" : NumberLong(1) ,   "loc" : { "type" : "Point", "coordinates" : [127.1058431, 37.516413] },   "pos_name" : ["name=잠실역 2호선", "trans_type=지하철" ] })

db.position.insert( { "_id" :  "m239091" , "data_type" : NumberLong(1) ,  "loc" : { "type" : "Point", "coordinates" : [127.0980748, 37.5301218] }, "pos_name" : ["name=동서울 터미널", "trans_type=버스터미널" ] })

db.position.insert( { "_id" :  "m239090" , "data_type" : NumberLong(1) ,  "loc" : { "type" : "Point", "coordinates" : [127.0952154, 37.5398467] }, "pos_name" : ["name=강변역 2호선", "trans_type=지하철" ] })

db.position.insert( { "_id" :  "m239089" , "data_type" : NumberLong(1) ,  "loc" : { "type" : "Point", "coordinates" : [127.0742172, 37.5419541] }, "pos_name" : ["name=건국대학역 2호선", "trans_type=지하철" ] })

 

 

db.position.createIndex({loc:"2dsphere"})

=> 인덱스 생성