• Home
  • Forums
  • FME Form
  • Transformers
  • In my workflows I have the problem with the elements "CompoundCurve" and "Curvepolygon" when writing to a postgresql / postgis database with default schemas for osm_point, osm_line and osm_polygon.
Question

In my workflows I have the problem with the elements "CompoundCurve" and "Curvepolygon" when writing to a postgresql / postgis database with default schemas for osm_point, osm_line and osm_polygon.

  • 1 August 2020
  • 3 replies
  • 79 views
E

Geometry type "CompoundCurve"

Because of the given schemas the postgis writer has problems with the geometry "CompoundCurve". I want to convert this in the process into a normal line element, which can be read in the osm_line table with the geometry "linestring". Today my process in the Workbench crashes with an element with the geometry "CompoundCurve".

 

Geometry type "Curvepolygon"

The second problem is the geometry type "Curvepolygon". This is written correctly into the postgis table osm_polygon. But then I have to delete these objects manually in pg_admin, so that the generated data can be read by the application software. Is there a possibility in FME to convert the elements with the geometry type "Curvepolygon" into a normal polygon?

 

With best thanks for your support!

 

Erido

3 replies

takashi
Rank
Userlevel 2
Badge +17

Hi @erido​ , such a situation could appear if the curve (including the boundary of a polygon) was a Path geometry containing Arc parts. Try using the ArcStroker and the GeometryRefiner to transform the curve to Line geometry before writing them into the PostGIS database table.

J
Badge

Hi @erido​ , such a situation could appear if the curve (including the boundary of a polygon) was a Path geometry containing Arc parts. Try using the ArcStroker and the GeometryRefiner to transform the curve to Line geometry before writing them into the PostGIS database table.

@Takashi Iijima​ 

I have tried using the combination of this transformers but the issue still persist..

I would like to find a way to discard o repair these geometry ("CompoundCurve".) to avoid the WB stops when I am inserting data to postgis table.

 

GeometryFilter

GeometryValidator

ArcStrokcer

GeometryRefiner

 

piertard
Rank
Badge

Hi @erido​ , such a situation could appear if the curve (including the boundary of a polygon) was a Path geometry containing Arc parts. Try using the ArcStroker and the GeometryRefiner to transform the curve to Line geometry before writing them into the PostGIS database table.

@Takashi Iijima​ 

I have tried using the combination of this transformers but the issue still persist..

I would like to find a way to discard o repair these geometry ("CompoundCurve".) to avoid the WB stops when I am inserting data to postgis table.

 

GeometryFilter

Hi @erido​ , such a situation could appear if the curve (including the boundary of a polygon) was a Path geometry containing Arc parts. Try using the ArcStroker and the GeometryRefiner to transform the curve to Line geometry before writing them into the PostGIS database table.

Mr Takashi's solution worked very well for me. I couldn't write my polygons in a GPKG and I got a curvepolygon error that couldn't be written.

GeometryValidator

Hi @erido​ , such a situation could appear if the curve (including the boundary of a polygon) was a Path geometry containing Arc parts. Try using the ArcStroker and the GeometryRefiner to transform the curve to Line geometry before writing them into the PostGIS database table.

 

ArcStrokcer

GeometryRefiner

 

 

 

Reply


Community Stats

28,717
Posts
109,495
Replies
36,561
Members
Terms & ConditionsCookie settings
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.