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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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.
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
