Skip site navigation (1) Skip section navigation (2)

Re: finding gps within polygon

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: blackwater dev <blackwaterdev(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: finding gps within polygon
Date: 2006-06-30 13:08:20
Message-ID: 20060630130820.GA72557@winnie.fuhr.org (view raw or flat)
Thread:
Lists: pgsql-general
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

In response to

pgsql-general by date

Next:From: Jason McManusDate: 2006-06-30 13:17:56
Subject: Notes on converting from MySQL 5.0.x to PostgreSQL 8.1.4
Previous:From: chris smithDate: 2006-06-30 12:19:38
Subject: Re: Installation problems

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group