[postgis-users] Loading only data that intersects another feature

[Marcus C. England]

Hi all,

I have a postgis polygon layer representing a site boundary (we will 
call the layer "boundary") and another postgis point layer with a larger 
extent representing California condor observations (we will call the 
layer "condors"). I am using gvSIG which allows SQL restrictions of 
layer loads from postgis. What SQL statement would I use (keep in mind 
the above layer names) to only load the "condors" data that intersects 
"boundary"?

-Marcus