[postgis-users] question on performance?

[Paragon Corporation]

Saka,
 
Not sure if this answers your question.  As long as you have spatial indexes
in place point in polygon queries should run pretty fast.  No you don't need
to do point by point comparisons you can do point by polygon comparisons
 
You would do something along the line of
 
SELECT polytable.the_polygon, pointtable.the_point
FROM polytable INNER JOIN pointtable ON ST_Intersects(the_polygon,
the_point)
 
 

  _____  

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Saka
Royban
Sent: Monday, August 04, 2008 11:04 AM
To: PostGIS
Subject: [postgis-users] question on performance?


Hi all. 
I've a large set of points and a set of polygons. I have written a program
for point in polygon of these dataset even writing its algorithm.
I wanted to know about performance of doing this by PostGIS. however a cost
of connection to postgis exists.
also, can i do it in a bunch manner other than just point by point using
PostGIS.


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080804/55d9be73/attachment.html>