earthdistance or PostGIS for find * within point and radius

From: John Cheng <johnlicheng(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: earthdistance or PostGIS for find * within point and radius
Date: 2010-10-28 15:28:24
Message-ID: AANLkTi=M_B4JBbw2icBCxQfutv0pqoNBGGhPPfNe8Okr@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a database with the earthdistance contrib module installed and
I need to find records whose long & latitude are within a given
distance of a zip code. From the documentation on earthdistance, I
believe it is certainly possible to do a "find points within a
distance of another point" using the ll_to_earth, earth_box, and
earth_distance functions. What would be the advantages to installing
and using PostGIS instead?

I would like to avoid adding another dependency to the system and I
think earthdistance will be able to do what I need. However, I'll
certainly try PostGIS if it has a significant performance advantage.
Can anyone talk a bit about the pros and cons of earthdistance and
PostGIS?

--
---
John L Cheng

Browse pgsql-general by date

  From Date Subject
Next Message Ozz Nixon 2010-10-28 15:36:21 Re: Why Select Count(*) from table - took over 20 minutes?
Previous Message Michael Clark 2010-10-28 15:23:23 Re: Should PQconsumeInput/PQisBusy be expensive to use?