I have an ESRI File Geodatabase of data that I upload to PostGIS using FME. Seeing as I have to have the data in PostGIS for other purposes, it would be great to view the data in ArcMap straight from the PostGIS database, rather than having to use the file geodatabase. I dont need to edit the data in ArcMap.
If I open the data from the ESRI File Geodatabase in ArcMap or QGIS, the data displays fine.
If I load the PostGIS version in QGIS, it displays fine.
However, when I open the PostGIS version in ArcMap, I get the following error:
One or more layers failed to draw: Linestring or poly boundary is self-intersecting
In my FME workspace I am using a GeometryValidator transformer to check that the geometries are correct - I use the tests Fails OGC Simple and Fails OGC Valid and write only the valid geometries to PostGIS. At the moment I am only loading the valid geometries to PostGIS (I will deal with the invalid ones once I get get ArcMap to display the valid ones).
I have double checked that the data is valid in PostGIS by checking the data with ST_IsValid().
I am using ArcGIS 10.2.1 and what I believe is a supported version of PostgreSQL/PostGIS (PostgreSQL 9.2.4 64-bit and PostGIS 2.0.3). I also have the dll files on the client machine and have no problems connecting the the database.
I have also tried with a newer version of both PostgreSQL and PostGIS (which are not supported by ESRI) and they dont work either.