![MONGODB GEOSPATIAL INDEX
>db.places.insert({ loc : [ 50 , 30 ] })
>db.places.insert({ loc : { x : 50 , y : 30 } })
>db.places.insert({ loc : { foo : 50 , y : 30 } })
>db.places.insert({ loc : { long : 40.7390,lat: 73.9929 } })
>db.places.ensureIndex( { loc : "2d" } )
>db.places.find( { loc : [50,50] } )
>db.places.find( { loc : { $near : [50,50] } } )
>db.places.find( { loc : { $near : [50,50] } } ).limit(20)
>db.places.find( { loc : { $near : [50,50] , $maxDistance :
5 } } ).limit(20)
2011 6 14](https://image.slidesharecdn.com/lbsmongo-130219003946-phpapp01/85/LBS-with-MongoDB-8-320.jpg)
![MONGODB GEOSPATIAL INDEX
Compound Indexes
>db.places.ensureIndex(
{ location : "2d" , category : 1 }
);
>db.places.find(
{
location : { $near : [50,50] },
category : 'coffee'
});
geoNear Command
> db.runCommand( { geoNear : "places" , near : [50,50],
num : 10 } , query : { category : 'coffee' });
Valid options are: "near", "num", "maxDistance", "distanceMultiplier" and "query"
2011 6 14](https://image.slidesharecdn.com/lbsmongo-130219003946-phpapp01/85/LBS-with-MongoDB-9-320.jpg)
![MONGODB GEOSPATIAL INDEX
public List<DBObject> retriveByLoc(int flag, Double geolong, Double geolat)
{
DBObject cmd = new BasicDBObject(), query = new BasicDBObject();;
query = new BasicDBObject();
query.put("flag", flag);
Object[] location = new Object[]{ geolong, geolat };
cmd = new BasicDBObject();
cmd.put("geoNear", "position");
cmd.put("near", location);
cmd.put("num", 30);
cmd.put("distanceMultiplier", 1.609344*1000*1000); //蟇磯Μ m
cmd.put("spherical", true); //蟇磯Μ螻 ?
cmd.put("query", query);
CommandResult cr = mongoTemplate.getDb().command(cmd);
return (List<DBObject>)cr.get("results");
}
2011 6 14](https://image.slidesharecdn.com/lbsmongo-130219003946-phpapp01/85/LBS-with-MongoDB-10-320.jpg)
LBS with MongoDB
- 1. LBS WITH MONGODB LOCATION BASED SERVICE WITH MONGODB ( 覈所觜襦 豺蠍磯 觜 襷り鍵 ) 2011 6 14
- 2. 螳螳 伎 ITEMBAY / PROGRAMMER / SPRINGSPROUT / UNLOGICAL OKJSP / SKYNLE TWITTER / SKYNLE 2011 6 14
- 3. DAUM PLACE, FOURSQUARE, GOOGLE PLACES 2011 6 14
- 4. SAMPLE PAGE HTTP://192.168.123.1:8080/MONGO/MAP 300,000 150,000/1覿 1 SELECT & 1 UPDATE MACBOOK PRO, DUAL CORE 2.54G, 4G, 128SSD JBOSS 5.1 WITH IN ECLIPSE / JDK 1.6 MONGODB 1.8 2011 6 14
- 5. OTHERS ? SPRING3 SPRING DATA MONGO ... GOOGLE MAP V3 TILES2 JQUERY ALL FREE 2011 6 14
- 6. WHY MONGODB ? FREE GEOSPATIAL INDEX DISTANCE EASY WITH JAVA AND ... 2011 6 14
- 7. MONGODB HTTP://MONGODB.ORG 2011 6 14
- 8. MONGODB GEOSPATIAL INDEX >db.places.insert({ loc : [ 50 , 30 ] }) >db.places.insert({ loc : { x : 50 , y : 30 } }) >db.places.insert({ loc : { foo : 50 , y : 30 } }) >db.places.insert({ loc : { long : 40.7390,lat: 73.9929 } }) >db.places.ensureIndex( { loc : "2d" } ) >db.places.find( { loc : [50,50] } ) >db.places.find( { loc : { $near : [50,50] } } ) >db.places.find( { loc : { $near : [50,50] } } ).limit(20) >db.places.find( { loc : { $near : [50,50] , $maxDistance : 5 } } ).limit(20) 2011 6 14
- 9. MONGODB GEOSPATIAL INDEX Compound Indexes >db.places.ensureIndex( { location : "2d" , category : 1 } ); >db.places.find( { location : { $near : [50,50] }, category : 'coffee' }); geoNear Command > db.runCommand( { geoNear : "places" , near : [50,50], num : 10 } , query : { category : 'coffee' }); Valid options are: "near", "num", "maxDistance", "distanceMultiplier" and "query" 2011 6 14
- 10. MONGODB GEOSPATIAL INDEX public List<DBObject> retriveByLoc(int flag, Double geolong, Double geolat) { DBObject cmd = new BasicDBObject(), query = new BasicDBObject();; query = new BasicDBObject(); query.put("flag", flag); Object[] location = new Object[]{ geolong, geolat }; cmd = new BasicDBObject(); cmd.put("geoNear", "position"); cmd.put("near", location); cmd.put("num", 30); cmd.put("distanceMultiplier", 1.609344*1000*1000); //蟇磯Μ m cmd.put("spherical", true); //蟇磯Μ螻 ? cmd.put("query", query); CommandResult cr = mongoTemplate.getDb().command(cmd); return (List<DBObject>)cr.get("results"); } 2011 6 14
- 11. WHAT ? MONGODB襯 伎 ｸ襴螻, 螳覲蟆 豺蠍磯觜(LBS)襯 . 2011 6 14
- 12. Q/A 2011 6 14