[postgis-users] intersection/within queries - newbie basic spatial queries

[Craigie Dirk]

I am a new user and trying to perform some basic spatial queries using
within/intersect/union etc.

 

I have 2 x polygon files :

 

Prim_catch (19 x records)

Sec_catch (attribute secondary = text field name of catchment)

 

All the polys in sec_catch fall within a single record (polygon) of
prim_catch  

The query I am using (see below) needs some kind of loop or temporary
table as it returns a true/false and not a list of the records = true.

------------

SELECT secondary FROM sec_catch  

WHERE WITHIN((select the_geom from sec_catch),(select the_geom from
prim_catch))

-----------

 

Any help, sample will be appreciated

 

Thanks,

 

 

Dirk Craigie

 



DISCLAIMER:
This message and any attachments are confidential and intended solely for the addressee. If you have received this message in error, please notify the system manager/sender.  Any unauthorized use, alteration or dissemination is prohibited.  The Department of Water Affairs and Forestry further accepts no liability whatsoever for any loss, whether it be direct, indirect or consequential, arising from this e-mail, nor for any consequence of its use or storage.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20071207/038cdc5b/attachment.html>