RE: MI-L Updating column with areas from another table - almost t here!

[pel]

Hi All

Why not use the AreaOverlap() function

then  your expresioin is

Select AreaOverlap(small.obj, large.obj) from Small, Large Where Small.obj
intersects latge.obj





      Med venlig hilsen
      Peter Laulund

      *************************************************************
      Kort & Matrikelstyrelsen  �  www.kms.dk
      National Survey and Cadastre - Denmark
      Rentemestervej 8  �  DK 2400 K�benhavn NV
      E-mail:  [EMAIL PROTECTED]  �  Home: [EMAIL PROTECTED]
      Phone: +45 3587 5050  �  Direct: +45 3587 5173

      *************************************************************




[EMAIL PROTECTED] - 01-11-2000 13:30:30

      Besvar venligst til [EMAIL PROTECTED]

Til:    [EMAIL PROTECTED]
cc:      (bcc: Peter Laulund/MI/KMS)
Vedr�rende:    RE: MI-L Updating column with areas from another table -
        almost t    here!




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!

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.