Question

Bulk copy failed on table 'mytablet' using delimiter. Error was 'ERROR: Geometry type (CompoundCurve) does not match column type (LineString)

  • 3 May 2023
  • 3 replies
  • 24 views

Badge

I have tried using the combination of this transformers to discard or filter out compoundCurve geometry but the issue still persist

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

 

GeometryFilter

GeometryValidator

ArcStrokcer

GeometryRefiner


3 replies

Badge +20

CompoundCurve is a tipe of aggregate.

Use Deaggregator (flatten one level or all levels, whichever suites you better) followed by GeometryRefiner and, if necessary, ArcStroker, in this order.

Badge

@caracadrian​ 

I have used Deaggregator  one level and all level and the issues persist , this is the combination used

GeometryFilter

GeometryValidator

ArcStrokcer

GeometryRefiner

Deaggregator 

Badge +20

Can you post some sample data?

This usually is tricky but has a stupid easy solution. The order of the transformers matters (GeometryRefiner then Deaggregator or viceversa), the validity of the geometry also is particularly important, but it's always a different solution.

Also, keep in mind we are in opposite time zones. It's almost bedtime in Bucharest😁

Reply