Geospatial Indexing with MongoDB

Discusses the use of Geospatial Indexing - source code will be available soon for the second part of the talk.

Transcript

1. Geospatial Indexing Ryan Fischer @ryanfischer20 Tuesday, November 15, 11
2. What is covered The most amazing slides ever to be displayed Getting Started with Geospatial Indexing A real live working session of the most amazing code How many times I say ‘um’ Tuesday, November 15, 11
3. geospatial Tuesday, November 15, 11
4. simple Tuesday, November 15, 11
5. SQL SELECT * FROM Places WHERE acos(sin(1.3963) * sin(Lat) + cos(1.3963) * cos(Lat) * cos(Lon - (-0.6981))) * 6371 <= 1000; Tuesday, November 15, 11
6. MongoDB db.places.find({loc : { $near:[50,50] } } ) Tuesday, November 15, 11
7. how do you want to search? Tuesday, November 15, 11
8. Exact Queries Search by closest points Tuesday, November 15, 11
9. Query within a rectangle Circle with a center point and radius Search within a polygon ( >= 1.9 ) Bound Queries Tuesday, November 15, 11
10. The earth is round (seriously) Tuesday, November 15, 11
11. Tuesday, November 15, 11
12. Tuesday, November 15, 11
13. Spherical Model Use decimal degrees - 42.53 Use [longitude, latitude] as ordering Use radians for distance $nearSphere and $centerSphere Tuesday, November 15, 11
14. geoNear returns distance for object db.runCommand({ geoNear: "persons", near: [50,50] }) Tuesday, November 15, 11
15. Multi-location Documents objects can contain sub-objects for multiple locations can show up more than once in location queries Tuesday, November 15, 11
16. Sharding Now supported Can only use geoNear command MongoDB is still young Tuesday, November 15, 11
17. MongoDB meets Ruby Tuesday, November 15, 11
18. The End Follow me - @ryanfischer20 Tuesday, November 15, 11
19. Tuesday, November 15, 11