Sha256: 9b5233845378cea590fb9dd4b49442b777e9859a7abe6d531fdbb87318c03571
Contents?: true
Size: 795 Bytes
Versions: 34
Compression:
Stored size: 795 Bytes
Contents
module Geokit
module Adapters
class Mysql2 < 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
34 entries across 34 versions & 6 rubygems