How do I insert coordinates of aggregate polygons in oracle sptial. Do I need to worry about polygon orientation?
Regards,
John
Question
How do I insert co-ordinates from aggregate polygon
Hello,
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
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
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
+15- Contributor
We work with OracleSpatial.
No problems with aggregates.
We are just now migrating to 11.