Thanks first of all to everyone who replied to my query. I almost have an answer that does what I want, thanks to Mike Hankins. Mike suggested using the following:
Select proportionoverlap(small.Obj,large.Obj) from small,large where small.obj Intersects large.obj into selection
Browse * From selection
where small = table of small areas and large = table of large areas.
This query gets me the proportion of each small area which overlaps the large area (ie. if half the small area is within the large area, it returns 0.5.). Does anyone know how I can add to the qurery to convert this 'proportion' figure into a square meter area, something along the lines of -
'proportion of overlap' * 'total m� of small area'
Thanks again for the responses
Andrew Young
IMPORTANT NOTICE: This e-mail is confidential. It must not be read, copies disclosed or used by any person other than the named recipient. Unauthorised use, disclosure or copying is strictly prohibited and may be unlawful. If you have received this e-mail in error, please contact the sender immediately.
