Hello FME Community
We are using PostGIS as our data repository for users of both QGIS and StatMap. To provide the same data experience in both, data sets are polygon or multipolygon where possible. There have been some differences between the number of features in the two views.
The first check was to use the Geometry filter in FME to see if any non-polygon geometry was present. The original dataset contained 3228 features. These all filtered as Area.
Following reading some of the questions asked previously, I tried the deaggregator, geometry filter, aggregator, still with an end result of 3228 Area features.
Next I tried setting the writer to multi_polygon for PostGIS but this just dropped the 9 Collections that PGAdmin is returning.
Just not sure why the Geometry collections aren't being picked up by the Geometry Filter?
Thank you in advance and sorry if I have missed anything obvious, this is an issue we've not come across before.
Writer Set Up for mulipolygon
Original Dataset Return
Post PostGIS multipolgon writer return.