finding gps within polygon

Started by blackwater devalmost 20 years ago2 messagesgeneral
Jump to latest
#1blackwater dev
blackwaterdev@gmail.com

Hello,

Does anyone have a good tutorial on finding gps points within a polygon? I
need to be able to pass in a list of gps coordinates and let postgres return
to me matching cities from my cities table that are within that polygon.

Thanks!

#2Michael Fuhr
mike@fuhr.org
In reply to: blackwater dev (#1)
Re: finding gps within polygon

On Thu, Jun 29, 2006 at 11:15:09PM -0400, blackwater dev wrote:

Does anyone have a good tutorial on finding gps points within a polygon? I
need to be able to pass in a list of gps coordinates and let postgres return
to me matching cities from my cities table that are within that polygon.

PostgreSQL has some basic geometry types and functions, but for
more advanced spatial work consider using PostGIS (an add-on to
PostgreSQL). The documentation has a "Using PostGIS" chapter with
examples.

http://www.postgis.org/

--
Michael Fuhr