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
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? |