I am connecting a PostgreSQL database to ArcGIS Pro and it connects but when I attempt to open the attribute table I receive a "Shape Integrity Error" and cannot view it.enter image description here

I am able to view the attribute table when I connect to the database through ArcMap.

  • Related you have bad data > gis.stackexchange.com/questions/240059/… – Mapperz Feb 27 '19 at 22:56
  • Is the PostgreSQL table readable in other software (like QGIS)? Have you installed PostGIS? Does your PostgreSQL and PostGIS release match the system requirements for ArcGIS Pro? Esri historically was very picky about the precise version that it would connect to. – Michael Stimson Feb 27 '19 at 23:31
  • 1
    Release of PostgreSQL (or PostGIS, for that matter) isn't likely to have anything to do with a "Shape integrity error". If you've gotten that far, it really is likely to be an invalid geometry. The difference between the Esri clients is likely to be in the default SpatialReference properties, especially with respect to XY precision. Therefore, please Edit the question to contain the SpatialReference properties in both clients. – Vince Feb 28 '19 at 0:26
  • 1
    Postgis and Arc use different geometry engines. I have run into this problem a lot. In Postgis the geometry is valid but according to arc standards it is not. Check out postgis functions st_makevalid, st_collectionextract – ziggy Feb 28 '19 at 1:14
  • 1

Your Answer

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

Browse other questions tagged or ask your own question.