Skip to main content
Question

Convert multi-part polygon to single-part to load in PostGIS

  • March 15, 2018
  • 2 replies
  • 974 views
A
Forum|alt.badge.img

Dear All,

I have an issue while using Dissolver and Aggregator I get multiarea of 5 polygons, which look merged in the Inspector. But when writing to PostGIS, aggregated geometry is split again into separate polygons. PostGIS is accepting only polygons as geometry. I know that if the PostGIS accepts only single polygon, but writer attempts to load a collection, then a collection will be split. The question is if there's a way to aggregate multiple polygons into one without collection. Single polygon needed only to set the extent of the layer, so envelope like feature will do as well.

Thanks a lot for your answer.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

redgeographics
Celebrity
Forum|alt.badge.img+62

You can use the Deaggregator to split aggregate polygons. However, according to the docs PostGIS should support aggregates so I'm really curious about those polygons. Any chance you can post a sample here?

FME rocks! \m/
lars_de_vries
Forum|alt.badge.img+10

You can use the Deaggregator to split aggregate polygons. However, according to the docs PostGIS should support aggregates so I'm really curious about those polygons. Any chance you can post a sample here?

It might has to do with the geometry settings in PostGIS. There is a seperate geometry type for multipolygon. Maybe the issue lies in there.

 

 

Community Stats

32,275
Posts
122,521
Replies
39,982
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.