Unwrap text
Report abuse
def set_geom
self.update_attributes(:the_geom=>ActiveRecord::Base.connection.execute("ST_PointFromText('POINT(' || #{self.lng}|| ' ' || #{self.lat} || ')',4326);")
self.update_attributes(:neighborhood_id=>ActiveRecord::Base.connection.execute("SELECT neighborhoods.id FROM neighborhoods, items WHERE ST_Contains(neighborhoods.the_geom,self.the_geom);")
end