Skip to main content
Question

Extracting geomtry from Oracle 12c database to WKT


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 ?

4 replies

ebygomm
Influencer
Forum|alt.badge.img+38
  • 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+38
  • Influencer
  • June 26, 2020
kieranfitzsimmo wrote:

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


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