Sha256: 6ee076d7415d69937774002a033aba5a0edb4cc580357a7c14757a926e0ae015
Contents?: true
Size: 1.67 KB
Versions: 22
Compression:
Stored size: 1.67 KB
Contents
module PostgisFunctions
#
# Class Methods
#
module ClassMethods
#
# Returns the closest record
def closest_to(p, opts = {})
srid = opts.delete(:srid) || 4326
opts.merge!(:order => "ST_Distance(geom, GeomFromText('POINT(#{p.x} #{p.y})', #{srid}))")
find(:first, opts)
end
#
# Order by distance
def close_to(p, opts = {})
srid = opts.delete(:srid) || 4326
opts.merge!(:order => "ST_Distance(geom, GeomFromText('POINT(#{p.x} #{p.y})', #{srid}))")
find(:all, opts)
end
def by_length opts = {}
sort = opts.delete(:sort) || 'asc'
opts.merge!(:order => "ST_length(geom) #{sort}")
find(:all, opts)
end
def longest
find(:first, :order => "ST_length(geom) DESC")
end
def contains(p, srid=4326)
find(:all, :conditions => ["ST_Contains(geom, GeomFromText('POINT(#{p.x} #{p.y})', #{srid}))"])
end
def contain(p, srid=4326)
find(:first, :conditions => ["ST_Contains(geom, GeomFromText('POINT(#{p.x} #{p.y})', #{srid}))"])
end
def by_area sort='asc'
find(:all, :order => "ST_Area(geom) #{sort}" )
end
def by_perimeter sort='asc'
find(:all, :order => "ST_Perimeter(geom) #{sort}" )
end
def all_within(other, margin=1)
# find(:all, :conditions => "ST_DWithin(geom, ST_GeomFromEWKB(E'#{other.as_ewkt}'), #{margin})")
find(:all, :conditions => "ST_DWithin(geom, ST_GeomFromEWKT(E'#{other.as_hex_ewkb}'), #{margin})")
end
def by_boundaries sort='asc'
find(:all, :order => "ST_Boundary(geom) #{sort}" )
end
end
end
Version data entries
22 entries across 22 versions & 3 rubygems