Skip to main content
Question

Make non spatial data spatial

  • February 20, 2020
  • 5 replies
  • 34 views

Hello

I am attempting to make non spatial Oracle table data spatial, I have created the FME workbench no problem but when it comes to writing the results to an Oracle table using Oracle Spatial table no points are displayed just the data.

Basically I am missing the accompanying spatial data to the points.

I am sorry if my post makes no sense and please ask any further questions.

 

Many thanks

Sy

 

 

5 replies

david_r
Celebrity
  • February 20, 2020

Can you show us how the writer was configured? Some screenshots or a copy of the workspace (simplified, if necessary) would be helpful.


ebygomm
Influencer
Forum|alt.badge.img+38
  • Influencer
  • February 20, 2020

Do you have attributes containing coordinates in your non-spatial table? If so you will need to create your points using these values with a vertexcreator


Hi, I've added a copy of the writer and in the translation log it cannot write any spatial data due to lack of a spatial column. Capture.PNG

The points are created using the VertexCreator.

 


ebygomm
Influencer
Forum|alt.badge.img+38
  • Influencer
  • February 21, 2020

Try changing the table handling to drop and create rather than truncate


ebygomm - that has worked, thank you very much - something so simple!


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