Detect changes to object geometry
James Harvie
Uffe Kousgaard
There is no easy query, but a generic solution would be something like this:
1) Sort both tables according to ID
2) Loop through the tables, while you check if objects exist in table1, but not table2 and vice versa.
3) If they exist in both tables, check if they are the same object type, PLINE.
4) Check if they have the same number of nodes
5) Finally check if the coordinates are the same.
6) Move to next object(s).
Regards
Uffe Kousgaard
I need to compare two versions of the same road network file to determine which records have had a change in their object geometry between the two versions. Is there a query that can do this quickly? I do not need to know what the change was, just that there was a change. Both tables have a corresponding unique ID.
James Harvie
--
--
You received this message because you are subscribed to the
Google Groups "MapInfo-L" group.To post a message to this group, send
email to mapi...@googlegroups.com
To unsubscribe from this group, go to:
http://groups.google.com/group/mapinfo-l/subscribe?hl=en
For more options, information and links to MapInfo resources (searching
archives, feature requests, to visit our Wiki, visit the Welcome page at
http://groups.google.com/group/mapinfo-l?hl=en
---
You received this message because you are subscribed to the Google Groups "MapInfo-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mapinfo-l+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/mapinfo-l/09abeee2-4575-41b4-bab1-1053789f8a2fn%40googlegroups.com.
Peter Horsbøll Møller
You could also chose to update a text column with some spatial characteristics of the spatial object.
That could be the length, the centroid X and Y values, the number of nodes and maybe the coordinates of the start and end nodes.
Divide these values with a spatial character like “|” or “#”.
If these values are identical, there is a good chance the objects are identical too.
If you want to be completely sure, you will have to inspect the individual nodes.
From: mapi...@googlegroups.com <mapi...@googlegroups.com>
On Behalf Of Uffe Kousgaard
Sent: 3. marts 2021 08:18
To: mapi...@googlegroups.com
Subject: Re: [MI-L] Detect changes to object geometry
|
This message originated Externally. Use proper judgement and caution with attachments, links, or responses. |
To view this discussion on the web visit https://groups.google.com/d/msgid/mapinfo-l/c1aca906-0379-3c6c-ea86-053195264b65%40routeware.dk.