AnsweredAssumed Answered

Problem with PostGreSQL Tables

Question asked by crazymatt on Dec 4, 2014
Latest reply on Dec 5, 2014 by vangelo-esristaff

I have something very strange happening. There are two particular spatial tables in a PostGreSQL database that I cannot get to function 100% correctly in ArcGIS. Basically I can get them into ArcMap as query layers like all the others, but I can't open the attribute tables of these two in particular.

 

When I try to open the attribute table of one I get "The number of points is less than required for feature" and the other says "Linestring or poly boundary is self-intersecting". The table opens with the correct number of columns and rows, but it is completely blank. I know the data is in there because I can change symbology to be dependent on an attribute in the table, I just cannot get the table to open. If I export them and add them as shapefiles, they work fine. It's mind boggling that only two layers would behave this way.

 

Any ideas how I might fix them?

Outcomes