Hi Andrew,
The SQL Select syntax is:
select table1.IDcol , table2.IDcol , areaoverlap(table1.obj,table2.obj)
from table1,table2
where table1.obj intersects table2.obj
Note that the area returned will be in Mapinfo's current area units, so
you might want to set these by running the 'Set Area Units "sq km"'
statement in the MapBasic window beforehand.
To find proportion overlap, use the
proportionoverlap(table1.obj,table2.obj) function instead, but note that
the proportions returned will be those of the objects from the first
table listed in the function (table1).
Andrew
Andrew Tracey wrote:
I have two tables - 1 consisting of 70 polygons and 1 consisting of 20
polygons. Both tables cover the same area, what I want to do is work out what
area or percentage of each of the polygons that is within another.
Does anyone know the syntax to do this?
Thanks
Andrew Tracey
Information Support Officer (GIS)
Information Team
Chief Executive Office
South Tyneside Council
Westoe Road
South Shields
NE33 2RL
Tel: 0191 4247561
E-Mail : [EMAIL PROTECTED]
************************************************************************************************
Please do not print this e-mail if you can help it - and help protect the
environment.
************************************************************************************************
This email and any files transmitted with it are confidential and intended solely for
the named recipient. If you have received this e-mail in error, please immediately
notify the sender by e-mail and delete from your system, you are not permitted to
disseminate, store, disclose or copy. E-mail transmission cannot be guaranteed to be
secure or error-free as they could be intercepted, corrupted, lost, destroyed, arrive
late or incomplete, or contain viruses and therefore the Council accept no liability
for any such errors or omissions. Views or opinions expressed in this email are solely
those of the author and do not necessarily represent those of the Council.South
Tyneside Council, Town Hall & Civic Offices, Westoe Road, South Shields, Tyne &
Wear, NE33 2RL, Tel: 0191 427 1717, Website: www.southtyneside.info
************************************************************************************************
The Council's web site address is www.southtyneside.info
_______________________________________________
MapInfo-L mailing list
MapInfo-L@lists.directionsmag.com
http://www.directionsmag.com/mailman/listinfo/mapinfo-l
--
Andy Harfoot
GeoData Institute
University of Southampton
Southampton
SO17 1BJ
Tel: +44 (0)23 8059 2719
Fax: +44 (0)23 8059 2849
www.geodata.soton.ac.uk
---------------------------------------
For further information about GeoData's
Training Courses, please visit:
www.geodata.soton.ac.uk/training
---------------------------------------
_______________________________________________
MapInfo-L mailing list
MapInfo-L@lists.directionsmag.com
http://www.directionsmag.com/mailman/listinfo/mapinfo-l