There is a SQL function called Proportion Overlap.
Select Columns--whichever columns from the two tables you want for
your selection, ProportionOverlap(table1.obj,table2.obj)
From--Table1, Table2
Where Condition--Table1.obj Intersects Table2.obj
Order by--Whatever column you want(i.e. 1 or 2 or 1,2
You can place this into a new table or it will automatically call it a
Query.
Hints: This is very powerful. I use it for Census overlays. Where
condition--Will return different results for contains, within, or
intersects. When I use this file, I must put the Census table first and the
table I am running against second or it doesn't work. Order seems to
matter.
If you have any further questions about this, let me know.
Mike Hankins
Actuarial Services Analyst
COUNTRY Insurance and Financial Services
309-821-2302
-----Original Message-----
From: Peter Hatton [mailto:[EMAIL PROTECTED]]
Sent: Sunday, October 13, 2002 9:10 PM
To: '[EMAIL PROTECTED]'
Subject: MI-L SQL - PROPORTION OVERLAY
Greetings list,
Does anyone know of an SQL for
determining the Proportion / Percentage Overlay of one object over another.
IE the percentage of overlay of one polygon on another.
Many thanks
Regards
Peter Hatton
GIS Officer
Greater Taree City Council
PO Box 482
TAREE NSW 2430
Ph. 02 6591 3395
email-
[EMAIL PROTECTED]
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 3579
