Niklas,
This is a multi-step process using MapInfo whereby you need to select all
objects intersecting using an attribute of 3 and then delete where
appropriate. Next, you would have to locate all overlaps and then select
those of attribute 3.
This involves writing SQL statements. If you're not familiar with SQL or
want to take a few short cuts you may like to use our product, Data
Assistant. I'll outline the steps required and in parenthesis give the
corresponding utility to use in Data Assistant. You can download Data
Assistant for evaluation from our web site www.datadirections.com.au You get
50 usages of the fully-functional MBX prior to timeout. In addition, a
detailed 91 page PDF User Manual is also installed.
1. Filter your current table, I'll call it TableA, to those with associated
attribute=3. ('Data Assistant' > 'Quick Sort' > 'Filter-Sort Table'). Save
this query result as a table, TableB.
2. Open TableB.
3. Select objects in TableB that intersect objects in TableA. ('Data
Assistant' > 'Select Objects' > 'From Objects In 2nd Table')
4. For the current selection, select the corresponding records in TableA.
('Data Assistant' > 'Quick Queries' > 'Select Records Matching Data In 2nd
Table'). Note: This assumes you have an ID column in your table. (If this
doesn't exist you can create and populate an ID column by using 'Data
Assistant ' > 'Quick Updates' > 'Using Row Number'.)
5. Delete the current selection contained in TableA.
6. Delete TableB using Table > Maintenance > Delete TableB as it refers to
objects that no longer exist in the original table, TableA.
7. Perform an Objects > Check Regions and view the overlapping regions of
all objects. Select objects with attribute = 3, and visually compare it to
the overlapping regions displayed, deleting objects as they are found! (Use
'Data Assistant' > 'Data Validation' > 'Overlapping Objects' and save the
result as a table, TableC. Then use 'Data Assistant' > 'Select Objects' >
'From Objects In 2nd Table' filtering TableA to objects with attribute = 3.
Delete the current selection in TableA, and then save TableA.)
8. You can then pack TableA, if desired, but this will change RowId's which
may or may not be an issue in your instance.
If you have any additional queries about this process, or queries about Data
Assistant, I'll be pleased to respond.
Regards,
Lorraine Donaldson
GIS Applications Developer
Data Directions
ABN 79 691 875 655
240 Jersey Street
Wembley, WA 6014
Australia
phone: 08 9284 1889
fax: 08 9387 1265
mobile: 0401 67 1889
email: [EMAIL PROTECTED]
web: www.datadirections.com.au
-----Original Message-----
From: Karlsson Niklas [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 16 May 2002 10:06
To: [EMAIL PROTECTED]
Subject: MI-L removing overlapping / intersecting objects
Hi,
I need to remove all objects were an associated attribute = 3 and it
overlaps or intersects with another object.
Everything is stored in one table.
How would I do this?
BR // Niklas
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
