Skip to main content
Question

PostGIS polygon turns into Geopackage multisurface in dynamic mode


arnovananrooij
Contributor
Forum|alt.badge.img+5

Hi all,

I see some strange behaviour when converting a simple 2D box from PostGIS to Geopackage in a dynamic mode (using schema). 

I have attached a simple workspace which demonstrates the strange behaviour. A simple box is created in 2D and writen to PostGIS as a postgis_polygon. I ckecked the table in the database and is has the correct definition for  the geometry (geometry(Polygon, 28992)). After the creation the table is read wit a FeatureReader of type PostGIS with the same connection parameters. It is set to read the schema and the features. The result is directly written to a geopackage with a FeatureWriter. Geometry is from schema definition. When i open the result in the Data Inspector i see the geometry type has become geopackage_multisurface where i would expect it to be of type geopackage_polygon.

 

At the moment we are upgrading our FME environment (Form and Flow) from FME 2021.2.6 to 2023.1.2 and ran into this problem. In FME 2021.2.6 i did not see this behaviour. This particular problem is part of a huge workspace which generates a lot of tables in PostgreSQL/PostGIS and at the end of the workspace all of these tables need to be exported to a desired format where Geopackage is one of the options.

Does anyone have a solution or an idea how to solve it?

2 replies

arnovananrooij
Contributor
Forum|alt.badge.img+5

I found out this problem is fix in newer releases:

 

FME 2023.2.0.0 b23727 20231004
[Fix] Geopackage Writer: mapping areas to surface instead of polygon

braggken
Supporter
Forum|alt.badge.img+6
  • Supporter
  • November 25, 2024

Glad to see this is fixed. 

Anyone found a work-around for this issue for earlier versions of FME?


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