Skip to main content
Question

Polygon Coordinates in Oracle Spatial

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?

5 replies

david_r
Evangelist
  • david_rEvangelist
  • 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
Evangelist
  • david_rEvangelist
  • 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
Evangelist
  • david_rEvangelist
  • 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

Reply


Most helpful members this week

Community Stats

30,847
Posts
116,941
Replies
38,670
Members
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.