Skip to main content
Question

Make non spatial data spatial

  • February 20, 2020
  • 5 replies
  • 43 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

 

 

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
  • 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+46
  • 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


  • Author
  • February 21, 2020

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+46
  • Influencer
  • February 21, 2020

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


  • Author
  • February 21, 2020

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