MongoDB: Location based applications

Transcript

2. MONGODB FOR LOCATION BASED APPLICATIONS Created by / Vitaly Domnikov @dotcypress
3. LOOK AROUND
4. NO MONEY - NO HONEY
5. GEOSPATIAL INDEXES WE NEED DATA FIELD AND INDEX l o c a t i o n : [ x , y ] l o c a t i o n : { x : 1 , y : 2 } d b . a t m s . e n s u r e I n d e x ( { ' l o c a t i o n ' : ' 2 d ' } )
6. QUERIES Proximity queries Bounded queries Exact queries
7. PROXIMITY QUERIES d b . a t m s . f i n d ( { l o c a t i o n : { $ n e a r : [ - 7 0 , 4 0 ] } } ) d b . r u n C o m m a n d ( { g e o N e a r : " a t m s " , n e a r : [ x , y ] } )
8. QUERIES RESULTS { " n s " : " t e s t . p l a c e s " , " r e s u l t s " : [ { " d i s " : 3 , " o b j " : { " _ i d " : O b j e c t I d ( " . . . " ) , " l o c a t i o n " : [ - 7 3 , 3 9 ] } } ] , . . . }
9. DISTANCE QUERIES d b . a t m s . f i n d ( { l o c a t i o n : { $ n e a r : [ - 7 0 , 4 0 ] , $ m a x D i s t a n c e : 2 0 } } ) d b . r u n C o m m a n d ( { g e o N e a r : " a t m s " , n e a r : [ x , y ] , $ m a x D i s t a n c e : 2 0 } )
10. SPHERICAL GEOMETRY f i n d ( . . $ n e a r S p h e r e . . ) f i n d ( . . $ c e n t e r S p h e r e . . ) g e o N e a r ( . . { s p h e r i c a l : t r u e } . . )
11. DISTANCE CALCULATION The radius of the Earth is approximately: 3963.192 miles 6378.137 kilometers.
12. DISTANCE MULTIPLIER d b . r u n C o m m a n d ( { g e o N e a r : " a t m s " , n e a r : [ - 7 4 , 4 0 . 7 4 ] , s p h e r i c a l : t r u e , d i s t a n c e M u l t i p l i e r : 6 3 7 8 . 1 3 7 } )
13. BOUNDED QUERIES Circles Rectangles Polygons
14. CIRCLES d b . a t m s . f i n d ( { " l o c a t i o n " : { " $ w i t h i n " : { " $ c e n t e r " : [ [ - 7 4 , 4 0 . 7 4 ] , 1 0 ] } } } )
15. RECTANGLES d b . a t m s . f i n d ( { " l o c a t i o n " : { " $ w i t h i n " : { " $ b o x " : [ [ - 7 4 , 4 0 . 7 4 ] ] } } } )
16. POLYGONS d b . a t m s . f i n d ( { " l o c a t i o n " : { " $ p o l y g o n " : { " $ b o x " : [ [ 0 , 0 ] , [ 3 , 3 ] , [ 6 , 0 ] ] } } } )
17. EXACT QUERIES d b . a t m s . f i n d ( { " l o c a t i o n " : [ [ - 7 4 , 4 0 . 7 4 ] ] } )
19. THE END BY VITALY DOMNIKOV / @DOTCYPRESS