Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
Geospatial Indexing with MongoDB
Search
20spokes
January 22, 2012
Programming
3
100
Geospatial Indexing with MongoDB
20spokes
January 22, 2012
Tweet
Share
More Decks by 20spokes
See All by 20spokes
Start Your Startup: The Essential Steps to Launch Your Idea
ryan_fischer
1
77
Intro to MongoDB (Updated)
ryan_fischer
2
67
Intro to MongoDB
ryan_fischer
2
210
MongoDB and Ruby on Rails
ryan_fischer
2
150
Other Decks in Programming
See All in Programming
PHPでOfficeファイルを取り扱う! PHP Officeライブラリを プロダクトに組み込んだ話
hirobe1999
0
840
document.write再考
brn
5
2.5k
Enhancing Applications with Accessibility API
kishikawakatsumi
3
920
孤独のCTOグルメという やや奇抜な企画をやった目的と効果
shoheimitani
3
1k
Learning PHP and Static Analysis with PHP Parser
inouehi
1
250
自動テスト実行結果の目的を整理する / Organizing objectives of automated test results
twada
PRO
10
2.1k
Data Contracts In Practice With Debezium and Apache Flink (Kafka Summit London)
gunnarmorling
2
280
自作ソフト(VMagicMirror)がVRMA対応してる話+実装のTips
bakudreameater
0
110
オブジェクト指向コードレビューの新しいアプローチ
akkie76
3
1.5k
生成 AI の中身を覗いてみよう〜基礎から医療現場での応用まで〜
soh9834
2
760
フロントエンドパフォーマンス 入門
shouta2
7
1.5k
Prepare for Jakarta EE 11 - Performance and Developer Productivity
ivargrimstad
0
500
Featured
See All Featured
For a Future-Friendly Web
brad_frost
170
8.9k
Six Lessons from altMBA
skipperchong
19
2.9k
RailsConf & Balkan Ruby 2019: The Past, Present, and Future of Rails at GitHub
eileencodes
124
32k
Stop Working from a Prison Cell
hatefulcrawdad
265
19k
The Invisible Side of Design
smashingmag
293
49k
Dealing with People You Can't Stand - Big Design 2015
cassininazir
355
22k
Fantastic passwords and where to find them - at NoRuKo
philnash
35
2.4k
Fireside Chat
paigeccino
19
2.6k
The Cost Of JavaScript in 2023
addyosmani
13
3.7k
How to Ace a Technical Interview
jacobian
272
22k
Intergalactic Javascript Robots from Outer Space
tanoku
266
26k
Product Roadmaps are Hard
iamctodd
43
9.6k
Transcript
Geospatial Indexing Ryan Fischer @ryanfischer20 Tuesday, November 15, 11
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
geospatial Tuesday, November 15, 11
simple Tuesday, November 15, 11
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
MongoDB db.places.find({loc : { $near:[50,50] } } ) Tuesday, November
15, 11
how do you want to search? Tuesday, November 15, 11
Exact Queries Search by closest points Tuesday, November 15, 11
Query within a rectangle Circle with a center point and
radius Search within a polygon ( >= 1.9 ) Bound Queries Tuesday, November 15, 11
The earth is round (seriously) Tuesday, November 15, 11
Tuesday, November 15, 11
Tuesday, November 15, 11
Spherical Model Use decimal degrees - 42.53 Use [longitude, latitude]
as ordering Use radians for distance $nearSphere and $centerSphere Tuesday, November 15, 11
geoNear returns distance for object db.runCommand({ geoNear: "persons", near: [50,50]
}) Tuesday, November 15, 11
Multi-location Documents objects can contain sub-objects for multiple locations can
show up more than once in location queries Tuesday, November 15, 11
Sharding Now supported Can only use geoNear command MongoDB is
still young Tuesday, November 15, 11
MongoDB meets Ruby Tuesday, November 15, 11
The End Follow me - @ryanfischer20 Tuesday, November 15, 11
Tuesday, November 15, 11