Apart from the ESRI declared...position that the SDE is self-correcting itself, does anybody know how to repair the Features in the SDE Feature Classes with the problems listed in the Check Geometry tool, particularly self-intersecting polygons? Need to automate the process through a Python script and clearly the Repair Geometry does not work either on the SDE data sources. Repairing the Features off-line still leaves the task to go back to replace them in the versioned Featured Class. Any bright ideas would be greatly appreciated. Thank you.
Hi Costas,
You could create a geodatabase topology with the rule that the polygons must not self-intersect.