|
Thanks
to Jacques Paris for the final piece of the jigsaw.
The
full expression for calculating the area of overlap of a number of small
regions which overlap larger regions is:
Select
proportionoverlap(small.Obj,large.Obj)*area(obj,”sq m”) from small,large
where small.obj
Intersects large.obj into selection
Browse * From selection Thanks
again to all who helped.
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. |
Title: Re: MI-L Updating column with areas from another table - almost there!
