From: David <de4@kent.ac.uk>
To: pgsql-sql@postgresql.org
Subject: searching polygons
Date: Tue, 17 Feb 2004 19:01:51 -0000
Message-ID: <006501c3f588$807b56b0$9b660c81@ad.kent.ac.uk> (raw)
What query would i have to use to search for an item using a polygon as a
parameter? (i.e a very large polygon that would identify smaller polygons
within it) ideally i would like to give postgresq a series of co-ordinates
and then have it return all those results whose polygons fall into that set
of co-ordinates, is this possible?
at the moment all i can think of is
select * from species where location between '(0,0)' and '(1000,0)' and
'(0, 1000)' and '(1000; 1000)';
I think im way off, any suggestions?
Cheers Dave
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: de4@kent.ac.uk
Subject: Re: searching polygons
In-Reply-To: <006501c3f588$807b56b0$9b660c81@ad.kent.ac.uk>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox