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 there!
Thanks to Jacques Paris
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
Title: Re: MI-L Updating column with areas from another table - almost there!
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
ssage -
From:
[EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, October 30, 2000 9:50
AM
Subject: MI-L Updating column with areas
from another table
Hello all,
I have one table with a lot of small regions and
one with two or three larger regions. I want to
Title: Updating column with areas from another table
Hello all,
I have one table with a lot of small regions and one with two or three larger regions. I want to update a column in the 'larger regions' table with the area of the smaller regions which are within the larger regions (are you wit