I would like to be able to compare features in Layer 1 (source) to features in Layer 2 (updates to source) in order to see if any of the features geometry and/or attributes have changed. I would also then like have a "report" generated stating what has changed.
Edit for Clarification: Changes in geometry also include finding features that have been added to the new data layer. Deletions might be interesting to have, but additions are more important.
I've been looking through the PostGIS functions and can't seem to find any tools that are designed to compare and report differences between 2 layers features, both geometry and attributes.
I am looking for something similar to the ArcGIS "Feature Compare" tool.
If there is nothing like this in PostGIS, are there other open-source tools that will answer these types of questions? Thanks.