Skip to main content
Question

FME automatically converts oracle arc segment into linear segment

  • December 20, 2017
  • 5 replies
  • 11 views

converting oracle geometry from one projection to other using FME desktop 2014 sp2 version.

While doing so ,some of the arc segments (3 vertices) automatically gets converted to linear segments with (~ 30 to 40 vertices) . How can we avoid this ?Is there any parameter to disable these type transformations ? (req : Arcs segment need to be maintained)

5 replies

david_r
Evangelist
  • December 20, 2017

You may want to retry using a more current version of FME, there was a lot of work done in how arcs are handled around FME 2016.

You can download and install a more recent version in a separate directory on your pc, thereby preserving your "official" version while you test.

You'll find the most recent versions of FME here: https://www.safe.com/support/support-resources/fme-downloads/


  • Author
  • December 21, 2017
david_r wrote:

You may want to retry using a more current version of FME, there was a lot of work done in how arcs are handled around FME 2016.

You can download and install a more recent version in a separate directory on your pc, thereby preserving your "official" version while you test.

You'll find the most recent versions of FME here: https://www.safe.com/support/support-resources/fme-downloads/

Thanks david for your information. But we have only licenced version of desktop 2014 sp2 as part of our assignment. We cant change the verion of FME.

 

 


david_r
Evangelist
  • December 21, 2017
philip5050 wrote:
Thanks david for your information. But we have only licenced version of desktop 2014 sp2 as part of our assignment. We cant change the verion of FME.

 

 

If you're on track with your license maintenance, you're allowed to install more recent versions of FME without any further costs. Just saying :-)

 


steveatsafe
Safer
Forum|alt.badge.img+12
  • Safer
  • December 27, 2017

You might want to consider doing the projection in the database when reading the data (using a function). This would impact the read performance for sure but if it is a small amount of records it would be barely noticeable. Check out SDO_CS.TRANSFORM and SDO_CS.TRANSFORM_LAYER.

If it is involving a large number of records you might consider creating a materialized view (vs a view which would still impact read performance). The materialized view would maintain read performance but would require some backend database effort (more physical storage).

As David_R has correctly indicated, a never version of FME could get you past this issue. Let us know if you can test with a newer version of FME.

On behalf of Safe Software & the community, we would appreciate the update on this.


steveatsafe
Safer
Forum|alt.badge.img+12
  • Safer
  • December 27, 2017
steveatsafe wrote:

You might want to consider doing the projection in the database when reading the data (using a function). This would impact the read performance for sure but if it is a small amount of records it would be barely noticeable. Check out SDO_CS.TRANSFORM and SDO_CS.TRANSFORM_LAYER.

If it is involving a large number of records you might consider creating a materialized view (vs a view which would still impact read performance). The materialized view would maintain read performance but would require some backend database effort (more physical storage).

As David_R has correctly indicated, a never version of FME could get you past this issue. Let us know if you can test with a newer version of FME.

On behalf of Safe Software & the community, we would appreciate the update on this.

Another thought, if this second coordinate system is your typical go to, you might consider altering the table and adding a second geometry column (SDO_GEOMETRY datatype) that can permanently store the with the new SRID. FME can be instructed to read multiple geometry columns... Here's an article for reference. click here

 

 


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