Skip to main content
Question

Extracting geomtry from Oracle 12c database to WKT

  • June 25, 2020
  • 4 replies
  • 52 views

I have a 12c Oracle database that has a line feature class and a point feature class that contains geometries , i want to know how i convert to OGC wkt and extract to a .csv file, i have tried to use the Geometry extractor and write to CSV , but when i view the file within the data inspector , no geomtry is present and no values to depcit the geomtry are present either, is there something that I am missing in my workbench ?

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.

4 replies

ebygomm
Influencer
Forum|alt.badge.img+46
  • Influencer
  • June 25, 2020

If you read the Oracle table in and display the output in an inspector do you see the geometries?

 


Yes i opened the inspector and can see the geometries within the window


ebygomm
Influencer
Forum|alt.badge.img+46
  • Influencer
  • June 26, 2020

Yes i opened the inspector and can see the geometries within the window

So you've used the geometry extractor to get the geometry as well known text in an attribute called _geometry (or whatever you've chosen), written this field into the csv and the field is blank?


please see above , I can see the geometry in the data inspector