Hi Ayman
I would create a new Char(254) column in the two tables and update this column with some spatial attributes from the objects.
These attributes could be information like:
- Centroid X & Y
- Area
- Length
- Perimeter
- Minimum X & Y
- Maximum X & Y
- Number of Nodes
- Number of Segments
Which of the above you use, depends on the object type in your table
Here's an example for (p)lines where I extract the coordinates for the MBR and the cartesian object length:
Set CoordSys Table Roads
Update Roads Set SpatialFootPrint = Format$(ObjectGeography(OBJ, 1), "0.00") & " | " & Format$(ObjectGeography(OBJ, 2), "0.00")
& " | " & Format$(ObjectGeography(OBJ, 3), "0.00") & " | " & Format$(ObjectGeography(OBJ, 4), "0.00")
& " | " & Format$(CartesianObjectLen(OBJ, "m"), "0.00") & " m"
The result looks like this:
You can use the "0.00"
in the Format$()
to control the precision of the values and thereby how "equal" you want the data to be. More decimals give you a higher precision, fewer or none gives you a lower precision.
Once you have the columns updated, you can join the two tables through these two columns to find matches.
------------------------------
Peter Horsbøll Møller
Principal Presales Consultant | Distinguished Engineer
Precisely | Trust in Data
------------------------------
Original Message:
Sent: 08-27-2023 21:02
From: Ayman Hamzeh
Subject: A tool to find identical features between 2 layers
Greetings;
Is there a tool to find identical features between 2 layers in MapInfo?
Thank you.
------------------------------
Ayman Hamzeh
Cassowary Coast Regional Council
INNISFAIL QLD
------------------------------