Skip to main content
  • EN

Dear FME community.

I've to extract geometries from ORACLE SDO GEOMETRY for insert them into Postgis DataBase.

The geometries in Postgis must be with type 'MULTILINESTRING' but my ORACLE SDO GEOMETRY are in 'LINESTRING'.

I try this solutions :

In postgis : to make a trigger for transform geometries before integration with postgis function ST_Multi but that don't work.

In FME : to use GeometryCoercer but all geometries are untouched

In FME : to use GeometryRefiner without success

In ORACLE : to transform the source geometry but that doesn't works

Any idea ?

Have you tried to use the Aggregator transformer?

In the "Group By" you should put the primary key field.

Have you tried to use the Aggregator transformer?

In the "Group By" you should put the primary key field.

Yes I tried it, but it doesn't work

 

Maybe I'm missing something, but have you tried reading them from Oracle and directly writing them to PostGIS? (in other words: let the writer sort it out without tinkering with it)

Maybe I'm missing something, but have you tried reading them from Oracle and directly writing them to PostGIS? (in other words: let the writer sort it out without tinkering with it)

It's not better : ERROR: Geometry type (LineString) does not match column type (MultiLineString)

 

 

Community Stats

31,951
Posts
121,336
Replies
39,562
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.