Question
how to convert (x And y) data table in oracle to shapefile and save it in the oracle database?
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.
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.
You can read the table using the Oracle Non-Spatial reader, then use the VertexCreator transformer to convert the X,Y values to a point geometry and send it to the Shape file writer.
+52- Celebrity
Hi @eslamgis90,
How is the structure your information x and y in Oracle?
Thanks,
Danilo
+13- Safer
You can read the table using the Oracle Non-Spatial reader, then use the VertexCreator transformer to convert the X,Y values to a point geometry and send it to the Shape file writer.
+13- Safer
Just to clarify... If I understand correctly, you want to read out some tabular data (Oracle Non-Spatial Reader) that contains x and y coordinate values, create a shape file (Shape Writer) and then create a new table in Oracle with the geometry (Oracle Spatial Writer)?
Hi @eslamgis90,
How is the structure your information x and y in Oracle?
Thanks,
Danilo
This is exactly what I want to do.
Just be aware that the license for FME Desktop Database Edition is required to create a workspace that contains the Oracle Spatial Object Writer.