Skip to main content
Question

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


Forum|alt.badge.img

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

caracadrian
Contributor
Forum|alt.badge.img+23
  • Contributor
  • May 4, 2023

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.


Forum|alt.badge.img

@caracadrian​ 

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

GeometryFilter

GeometryValidator

ArcStrokcer

GeometryRefiner

Deaggregator 


caracadrian
Contributor
Forum|alt.badge.img+23
  • Contributor
  • May 4, 2023

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😁


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