Contents

module Geokit
  module Adapters
    class PostgreSQL < Abstract
      
      def sphere_distance_sql(lat, lng, multiplier)
        %|
          (ACOS(least(1,COS(#{lat})*COS(#{lng})*COS(RADIANS(#{qualified_lat_column_name}))*COS(RADIANS(#{qualified_lng_column_name}))+
          COS(#{lat})*SIN(#{lng})*COS(RADIANS(#{qualified_lat_column_name}))*SIN(RADIANS(#{qualified_lng_column_name}))+
          SIN(#{lat})*SIN(RADIANS(#{qualified_lat_column_name}))))*#{multiplier})
         |
      end
      
      def flat_distance_sql(origin, lat_degree_units, lng_degree_units)
        %|
          SQRT(POW(#{lat_degree_units}*(#{origin.lat}-#{qualified_lat_column_name}),2)+
          POW(#{lng_degree_units}*(#{origin.lng}-#{qualified_lng_column_name}),2))
         |
      end
      
    end
  end
end

Version data entries

168 entries across 168 versions & 14 rubygems

Version	Path
geokit-rails-2.5.0	lib/geokit-rails/adapters/postgresql.rb
geokit-rails-2.3.2	lib/geokit-rails/adapters/postgresql.rb
geokit-rails-2.3.1	lib/geokit-rails/adapters/postgresql.rb
geokit-rails-2.3.0	lib/geokit-rails/adapters/postgresql.rb
geokit-rails-2.2.0	lib/geokit-rails/adapters/postgresql.rb
geokit-rails-2.1.0	lib/geokit-rails/adapters/postgresql.rb
geokit-rails-2.0.1	lib/geokit-rails/adapters/postgresql.rb
geokit-rails-2.0.0	lib/geokit-rails/adapters/postgresql.rb
geokit-rails-2.0.0.rc1	lib/geokit-rails/adapters/postgresql.rb
geokit-ar-0.0.1	lib/geokit-ar/adapters/postgresql.rb
earth-1.0.3	vendor/geokit-rails/lib/geokit-rails/adapters/postgresql.rb
earth-1.0.2	vendor/geokit-rails/lib/geokit-rails/adapters/postgresql.rb
earth-1.0.1	vendor/geokit-rails/lib/geokit-rails/adapters/postgresql.rb
earth-1.0.0	vendor/geokit-rails/lib/geokit-rails/adapters/postgresql.rb
earth-0.12.4	vendor/geokit-rails/lib/geokit-rails/adapters/postgresql.rb
earth-0.12.3	vendor/geokit-rails/lib/geokit-rails/adapters/postgresql.rb
earth-0.12.2	vendor/geokit-rails/lib/geokit-rails/adapters/postgresql.rb
earth-0.12.1	vendor/geokit-rails/lib/geokit-rails/adapters/postgresql.rb
earth-0.12.0	vendor/geokit-rails/lib/geokit-rails/adapters/postgresql.rb
earth-0.11.20	vendor/geokit-rails/lib/geokit-rails/adapters/postgresql.rb