class Geokit::Adapters::OracleEnhanced

Constants

TO_DEGREES

Public Instance Methods

flat_distance_sql(origin, lat_degree_units, lng_degree_units) click to toggle source
# File lib/geokit-rails/adapters/oracleenhanced.rb, line 22
      def flat_distance_sql(origin, lat_degree_units, lng_degree_units)
        %{
SQRT(
  POWER(#{lat_degree_units}*(#{origin.lat}-#{qualified_lat_column_name}), 2)
  POWER(#{lng_degree_units}*(#{origin.lng}-#{qualified_lng_column_name}), 2)
)
         }
      end
sphere_distance_sql(lat, lng, multiplier) click to toggle source
# File lib/geokit-rails/adapters/oracleenhanced.rb, line 5
      def sphere_distance_sql(lat, lng, multiplier)
        %{
(
  ACOS(
    COS(#{lat}) * COS(#{lng}) *
    COS(#{TO_DEGREES} * #{qualified_lat_column_name}) *
    COS(#{TO_DEGREES} * #{qualified_lng_column_name}) +
    COS(#{lat}) * SIN(#{lng}) *
    COS(#{TO_DEGREES} * #{qualified_lat_column_name}) *
    SIN(#{TO_DEGREES} * #{qualified_lng_column_name}) +
    SIN(#{lat}) *
    SIN(#{TO_DEGREES} * #{qualified_lat_column_name})
  ) *
  #{multiplier})
}
      end