Skip to main content
Question

Missing polygons when writing to PostGIS?


Forum|alt.badge.img

I am having issues where some polygons are not being written to my PostGIS schema when running a workspace.

Attached are two screenshots, one from directly before the PostGIS feature writer and one of the same features being read back in from PostGIS.

I've checked the geometries are valid, are not too complex and have also written it out to a FGDB where all polygons are written fine.

Has anyone experienced this or have any potential solutions/suggestions?

 

 

 

 

 

2 replies

david_r
Celebrity
  • August 15, 2019

Have you verified the FME log for warnings after writing the polygons? I've had instances where some warnings weren't "properly" highlighted in the FME log, so I recommend that you really check thoroughly for anything in the log that could explain why the polygons weren't written.

You could also insert a GeometryValidator with basic OGC checks before the writer, to see if there are any issues.


itay
Supporter
Forum|alt.badge.img+17
  • Supporter
  • August 15, 2019
david_r wrote:

Have you verified the FME log for warnings after writing the polygons? I've had instances where some warnings weren't "properly" highlighted in the FME log, so I recommend that you really check thoroughly for anything in the log that could explain why the polygons weren't written.

You could also insert a GeometryValidator with basic OGC checks before the writer, to see if there are any issues.

yep, lesson from the very beginning always use a GeometryValidator before writing to a database.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings