On 8/9/2013 5:18 PM, Brent Wood wrote:
You might install Postgis to implement very powerful spatial functionality that can easily do what you are asking (plus a whole lot more).
indeed, PostGIS is the logical answer, but the OP specifically stated he wanted the functionality without 'sophisticated geographic systems'. so I ignored the question.
the alternative would be implementing your own spherical geometry functions, and hook them up to GiST indexing, its not /that /hard, but by the time you got all the functionality you need, you'd be half way to PostGIS, so why fight it?
-- john r pierce 37N 122W somewhere on the middle of the left coast
