Mongoid Spacial

A Mongoid Extention that simplifies and adds support for MongoDB Geo Spacial Calculations.

Quick Start

Add mongoid_spacial to your Gemfile:

gem 'mongoid_spacial'

Set up some slugs:

class River
  include Mongoid::Document
  include Mongoid::Spacial::Document

  field :name,              type: String
  field :length,            type: Integer
  field :average_discharge, type: Integer
  field :source,            type: Array,    spacial: true

  # set return_array to true if you do not want a hash returned all the time
  field :mouth,             type: Array,    spacial: {lat: :latitude, lng: :longitude, return_array: true }

  # simplified spacial indexing
  # you can only index one point in mongodb version below 1.9
  # if you want something besides the defaults {bit: 24, min: -180, max: 180} just set index to the options on the index
  spacial_index :source

end

Generate indexes on MongoDB:

rake db:mongoid:create_indexes

Before we manipulate the data mongoid_spacial handles is what we call points.

Points can be:

  • an unordered hash with the lat long string keys defined when setting the field (only applies for setting the field)
  • longitude latitude array in that order - [long,lat]
  • an unordered hash with latitude key(:lat, :latitude) and a longitude key(:lon, :long, :lng, :longitude)
  • an ordered hash with longitude as the first item and latitude as the second item This hash does not have include the latitude and longitude keys *only works in ruby 1.9 and up because hashes below ruby 1.9 because they are not ordered
  • anything with the method to_lng_lat that converts it to a [long,lat] We store data in the DB as a [lng,lat] array then reformat when it is returned to you
hudson = River.create(
  name: 'Hudson',
  length: 315,
  average_discharge: 21_400,
  # when setting array LONGITUDE MUST BE FIRST LATITUDE MUST BE SECOND
  # source: [-73.935833,44.106667],
  # but we can use hash in any order,
  # the default keys for latitude and longitude are :lat and :lng respectively
  source: {:lat => 44.106667, :lng => -73.935833},
  mouth: {:latitude => 40.703056, :longitude => -74.026667}
)

# now to access this spacial information we can now do this
hudson.source #=> {:lng => -73.935833, :lat => 44.106667}
hudson.mouth  #=> [-74.026667, 40.703056] # notice how this returned as a lng,lat array because return_array was true
# notice how the order of lng and lat were switched. it will always come out like this when using spacial.
# Also adds a handy distance function
hudson.distance_from(:source, [-74,40], {:unit=>:mi})

Mongoid Geo has extended all built in spacial symbol extentions

  • near
    • River.where(:source.near => [-73.98, 40.77])
    • River.where(:source.near => [[-73.98, 40.77],5]) # sets max distance of 5
    • River.where(:source.near => => [-73.98, 40.77], :max => 5) # sets max distance of 5
    • River.where(:source.near(:sphere) => [[-73.98, 40.77],5]) # sets max distance of 5 radians
    • River.where(:source.near(:sphere) => => [-73.98, 40.77], :max => 5, :unit => :km) # sets max distance of 5 km
    • River.where(:source.near(:sphere) => [-73.98, 40.77])
  • within
    • River.where(:source.within(:box) => [[-73.99756,40.73083], [-73.988135,40.741404]])
    • River.where(:source.within(:box) => [ => 40.73083, :lng => -73.99756, [-73.988135,40.741404]])
    • River.where(:source.within(:polygon) => [ [ 10, 20 ], [ 10, 40 ], [ 30, 40 ], [ 30, 20 ] ]
    • River.where(:source.within(:polygon) => { a : { x : 10, y : 20 }, b : { x : 15, y : 25 }, c : { x : 20, y : 20 } })
    • River.where(:source.within(:center) => [[-73.98, 40.77],5]) # same format as near
    • River.where(:source.within(:center_sphere) => [[-73.98, 40.77],5]) # same format as near(:sphere)

One of the most handy features we have added is geo_near finder

# accepts all criteria chains except without, only, asc, desc, order\_by
River.where(:name=>'hudson').geo_near({:lat => 40.73083, :lng => -73.99756})

# geo\_near accepts a few parameters besides a point
# :num = limit
# :query = where
# :unit - [:km, :m, :mi, :ft] - converts :max\_distance to appropriate values and automatically sets :distance\_multiplier. accepts
# :max\_distance - Integer
# :distance\_multiplier - Integer
# :spherical - true - To enable spherical calculations
River.geo_near([-73.99756,40.73083], :max_distance => 4, :unit => :mi, :spherical => true)

There are two types of pagination!

  • MongoDB Pagination - Stores start of rows to page limit in memory
  • Post Query Pagination - Stores all rows in memory

Post-Result is only minutely slower than MongoDB because MongoDB has to calculate distance for all of the rows anyway. The slow up is in the transfer of data from the database to ruby.

Post-Result has some advantages that are listed below.

# MongoDB pagination
# overwrites #skip chain method
# :page - pagination will be enabled if set to any variable including nil, pagination will not be enabled if either :per\_page or :paginator is set
#   :per\_page
#   :paginator - Choose which paginator to use. [default :arrary]
#     Prefered method to set is Mongoid::Spacial.paginator=:array
#     Available Paginators [:kaminari, :will\_paginate, :array]
#     The only thing this does really is configure default per\_page so it is only kind of useful
River.geo_near([-73.99756,40.73083], :page => 1)
# Post Query Pagination
# At carzen we use Post Query Pagination because we need to re-sort our rows after fetching. Pagination is not friendly with re-sorting.
# You can jump pages continously without querying the database again.
# listens to #limit/:num & #skip before geo\_near
# #page(page\_number, opts = {})
#  opts:
#   :per\_page
#   :paginator
# #per(per\_page\_number, opts = {})
#  opts:
#   :page
#   :paginator
#
# both return a GeoNearResults, which is really just a modified Array
# #per really just #page but just moves the options around
rivers = River.geo_near([-73.99756,40.73083]).sort_by!{|r| r.geo[:distance] * r.multiplier }
rivers = rivers.per(25).page(1)
rivers.reset! # resets the object to it is original state right after query.

Troubleshooting

Mongo::OperationFailure: can't find special index: 2d

Indexes need to be created. Execute command: rake db:mongoid:create_indexes

Thanks

  • Thanks to Kristian Mandrup for creating the base of the gem and a few of the tests
  • Thanks to CarZen LLC. for letting me release the code we are using

Contributing to mongoid_spacial

  • Check out the latest master to make sure the feature hasn't been implemented or the bug hasn't been fixed yet
  • Check out the issue tracker to make sure someone already hasn't requested it and/or contributed it
  • Fork the project
  • Start a feature/bugfix branch
  • Commit and push until you are happy with your contribution
  • Make sure to add tests for it. This is important so I don't break it in a future version unintentionally.
  • Please try not to mess with the Rakefile, version, or history. If you want to have your own version, or is otherwise necessary, that is fine, but please isolate to its own commit so I can cherry-pick around it.

Copyright (c) 2011 Ryan Ong. See LICENSE.txt for further details.