Skip to main content
Question

Transform simple geometry to multiple geometry before postgis integration

geo-x
Participant
Forum|alt.badge.img
  • geo-xParticipant
  • Participant

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 ?

4 replies

oscard
Influencer
Forum|alt.badge.img+21
  • oscardInfluencer
  • Influencer
  • July 27, 2018

Have you tried to use the Aggregator transformer?

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

geo-x
Participant
Forum|alt.badge.img
  • geo-xParticipant
  • Author
  • Participant
  • July 27, 2018
oscard wrote:

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

 

redgeographics
Celebrity
Forum|alt.badge.img+49

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)

geo-x
Participant
Forum|alt.badge.img
  • geo-xParticipant
  • Author
  • Participant
  • July 27, 2018
redgeographics wrote:

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)

 

 

Reply


Helpful Members This Week

Community Stats

30,985
Posts
117,432
Replies
38,764
Members

Latest FME

Terms & ConditionsCookie settings

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
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.