I have a File Geodatabase that has some polygons in it. I am using append to copy them to an Oracle SDE 10.2 database. However there are some polygons that when imported have a null value for shape in the SDE. An example is shown below. Why is this happening, why is is valid in the file and not in Oracle, and more importantly, how do I get the polygon in to Oracle?

enter image description here

The red polygon is from the File Geodatabase, the blue is one previously imported in to Oracle. Below is a close up of the hole / intersection enter image description here

  • 1
    Did you run Check Geometry? If so, you might add those results. desktop.arcgis.com/en/arcmap/10.3/tools/data-management-toolbox/… – Richard Morgan Aug 7 '17 at 17:10
  • 1
    The vertices look like they've been snapped to a grid, maybe through something that is limiting precision. It might be worth it to go back through the history of the data to see if you can find what's introducing this, instead of fixing just the geometries that have been corrupted to the point of becoming invalid. – Marc Pfister Aug 7 '17 at 17:33

In addition to Check Geometry, try running repair geometry on your polygons before appending to the SDE:


It is happening because Oracle stores a different type of geometry than a file geodatabase. It could be from self intersections, or null geometry. Repair will fix some of this

  • 1
    Thanks, yes. Check geometry was identifying ring ordering, which repair was able to resolve. I need to check now whether this works for the rest of the dataset. – Bryan Aug 8 '17 at 2:42
  • 1
    This helped tremendously in visualizing data and allowing me to perform operations on the data to improving the odds of successful importing. Combined with the function at gist.github.com/mpetroff/5530329 and info from geospatial.commons.gc.cuny.edu/2013/11/04/… it seems that I'm able to gracefully handle all the source data. – Bryan Aug 15 '17 at 20:09

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.