Accessing PostGIS spatial data from Rails

Posted by Lakitu on Stack Overflow See other posts from Stack Overflow or by Lakitu
Published on 2009-10-07T14:10:23Z Indexed on 2010/05/12 2:54 UTC
Read the original article Hit count: 302

Filed under:

ruby-on-rails

|

spatial

|

postgis

I need to use an existing PostGIS database from my Rails application. So far I am able to access the DB just fine, GeoRuby nicely converts the 'geom' column into a Point object.

What I am looking for is an easy way to execute ActiveRecord-like queries on those tables, e.g.

Poi.find_within_radius(...)

or similar spatial queries like distance calculations et. al.

I tried several combinations of geokit, accompanying rails plugins but I'm quite sure there must be something better out there in the ruby/rails universe. Any hints?

© Stack Overflow or respective owner

Related posts about ruby-on-rails

Ruby on Rails - How can I start? [closed]

as seen on Programmers - Search for 'Programmers'
I have misconception in understanding the relationship between Ruby language and Ruby on Rails Framework. Because of 'I am an absolute beginner' in web development I have no idea if I have to grasp the fundamentals of Ruby before I go with Ruby on Rails! I also want to ask who is behind both Ruby… >>> More
DES3 decryption in Ruby on Rails

as seen on Stack Overflow - Search for 'Stack Overflow'
My RoR server receives a string, that was encrypted in C++ application using des3 with base64 encoding The cipher object is created so: cipher = OpenSSL::Cipher::Cipher::new("des3") cipher.key = key_str cipher.iv = iv_str key_str and iv_str: are string representations of key and initialization… >>> More
Ruby on rails: Image downloads with Authentication/Authorization/Time outs

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi Guys, I'm having few doubts on implementing file downloads. I'm creating an app where I use attachment_fu with Amazon s3 to upload files. Things are working pretty well so far on uploading side. Now its the time to start the file downloads. Here is what I need, a logged in user search and browse… >>> More
Ruby on Rails deployment, on "thin" server with lot of attachments

as seen on Stack Overflow - Search for 'Stack Overflow'
A lot of PDFs are stored inside MySQL as a BLOB field for each PDF file. The average file size is 500K each. The Rails app will stream the :binary data as file downloads, where there is a user click on the download link. Assume there is a maximum of 5 users downloading 5 PDFs concurrently, what… >>> More
Apply Behavior Driven Development to Ruby on Rails with Rspec

as seen on Internet.com - Search for 'Internet.com'
Applying the Behavior Driven Development (BDD) methodology to your Rails development takes you beyond traditional Test Driven Development. Learn how to do it with the Ruby-based BDD framework RSpec. >>> More

Related posts about spatial

Working with Spatial Data Part III - Reporting Spatial data using Reports Builder 3.0

as seen on SQL Server Performance - Search for 'SQL Server Performance'
Overview Development of any analytical solution normally ends with a form of report, whether it is a normal tabular report or a sophisticated interactive dashboard. In the first part of our BI-Satellite project, we ... [Read Full Article] >>> More
Working with Spatial Data Part III - Reporting Spatial data using Reports Builder 3.0

as seen on SQL Server Central - Search for 'SQL Server Central'
Part III of our spatial data series, continues building a demo spatial data app and uses Reports Builder for detailed visual mapping. >>> More
Oracle Spatial renamed Oracle Spatial and Graph

as seen on Oracle Blogs - Search for 'Oracle Blogs'
As of the July 19th, 2012 Global Price List, we have renamed "Oracle … >>> More
SQL SERVER – What is Spatial Database? – Developing with SQL Server Spatial and Deep Dive into Spati

as seen on SQL Authority - Search for 'SQL Authority'
What is Spatial Database? A spatial database is a database that is optimized to store and query data related to objects in space, including points, lines and polygons. While typical databases can understand various numeric and character types of data, additional functionality needs to be added for… >>> More
SQL SERVER What is Spatial Database? Developing with SQL Server Spatial and Deep Dive into Spatial

as seen on Dot net Slackers - Search for 'Dot net Slackers'
What is Spatial Database?A spatial database is a database that is optimized to store and query data related to objects in space, including points, lines and polygons. While typical databases can understand various numeric and character types of data, additional functionality needs to be added for… >>> More