Skip to main content
Question

Polygon Coordinates in Oracle Spatial

  • July 3, 2014
  • 5 replies
  • 87 views
J
Hello,

 

 

I need to extract polygon coordinates from various sources like shape, tab, kml etc. I am using generic reader to read source dataset. I want to know which is there any transformer which will do this job. I know CoordinateConcatenator is not suitable for aggrgates. So what is alternative to this. Anything I need to take care of in regards to how polygons are stored in Oracle Spatial. I need to handle all types og polygons simpe, donuts, aggregates/collections.

 

 

What is the best way to achieve this?
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.

5 replies

david_r
Celebrity
  • david_rCelebrity
  • July 3, 2014
Hi,

 

 

you might want to decompose your complex geometries first, etc. Look at the Deaggregator, DonutholeExtractor, etc.

 

 

If you need to re-assemble the parts later on, consider introducing a Counter just after the Reader and you can then later use this value as a Group By for the Aggregator, DonutBuilder, etc.

 

 

David
J
  • johng
  • Author
  • July 3, 2014
Is there any other writer other than Oracle Spatial Object to write into Oralce Spatial table?
david_r
Celebrity
  • david_rCelebrity
  • July 3, 2014
Hi,

 

 

not really, but if your geometries are small you can convert them to WKB and use the SQLExecutor in stead.

 

 

What is the reason for wanting something else?

 

 

David
J
  • johng
  • Author
  • July 4, 2014
I am just want to know the difference between Oracle Spatial Relational and Oracle Spatial Object. Which one I should use?
david_r
Celebrity
  • david_rCelebrity
  • July 4, 2014
Hi,

 

 

the Oracle Spatial Relational is there for backwards compatibility with Oracle versions 9iR2 and earlier. The relational model has been deprecated by Oracle in favor of the object-relational model (called Oracle Spatial Object in FME).

 

 

More info in chapter 1.2 here: http://docs.oracle.com/html/A88805_01/sdo_intr.htm

 

 

David

Community Stats

32,665
Posts
123,961
Replies
41,099
Members
Terms & ConditionsAccessibility 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.