I have a region_polygons table where region_polygons.rpg_geom is a
MULTIPOLYGON.
I want to select rows in the geom_table where geom_table.geom_fld is within
region_polygons.rpg_geom
The following idiom works for me, but is waaaay slow (whereas I found other
kinds of spatial queries are pretty zippy):
SELECT * from geom_table where EXISTS
(select rpg_id from region_polygons where
geom_fld && rpg_geom and intersects(geom_fld, rpg_geom) and
rpg_name='GVRD_OLD')
Where should I start?
a) Simplify the multipolygon?
b) Joins instead of EXISTS?
c) Would putting the literal WK format for the polygon right into the SQL
query help?
d) ... or something else?
--
Robin R Chauhan
Pathway Intelligence Inc
[EMAIL PROTECTED]
604-886-3964
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
