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