Hi John,

 

 

If you mean Oracle Spatial Relational format, it seems not to support aggregate geometry type.

 

http://docs.safe.com/fme/html/FME_ReadersWriters/Default.htm#oracle/Oracle_Spatial_Relationa.htm%3FTocPath%3DFME%20Readers%20and%20Writers%20(formats%20supported%20by%20FME%202014)%7COracle%20Spatial%20Relational%20Reader%2FWriter%7C_____1

 

 

I think you will have to de-aggregate the features before writing.

 

Consider using the Deaggregator transformer.

 

 

Takashi

---

Thanks Takashi.

 

I am intend to use Oracle Sptial Object. I think it supports aggregate feature. Currently my Oracle Spatial Object writer is disabled but it will soon get activated. For this reason I am not able to try this writer. What I need to understand is do I need to anything with multi-part polygons or it's straight forward ie. just specify the table name and geom column and writer will do all necessary things. I could not find any example which uses Oracle Spatial Writer.

 

John

---

Also I am more interested in polygons with centroids.

---

In my environment, cannot try Oracle Spatial Object format unfortunately. But according to the help documentation, the format supports aggregate geometry type as you mentioned.

 

In general, you can write multi-part polygons directly into a dataset whose format supports aggregate.

 

 

Regarding centroids, FME can create 3 kinds of representative points of geometry with these transformers:

 

CenterPointReplacer

 

CenterOfGravityReplacer

 

InsidePointReplacer

 

About differences among them, see help documentations.

---

Hi,

 

 

unless you're using a very old version of Oracle Spatial, you should not use the Oracle Spatial Relational writer, it exists only for historical reasons and has been deprecated since Oracle 9g. So you using the Oracle Spatial Object reader is probably correct.

 

 

There shouldn't be any problems writing aggregate geometries using this writer, just make sure that your aggregated geometries are homogenous. That is, any aggregate should ideally only contain one type of geometry, e.g. only polygons, only lines, etc. If you need to store both polygons and centroids (points) it might not work, but it will probably depend on several factors, so you should really try it out before making a final decision.

 

 

David

---

Thanks everyone. I will try Oracle Spatial Object once it's activated. Will post issues if any.

---

We work with OracleSpatial.

 

 

No problems with aggregates.

 

We are just now migrating to 11.

---