Skip to main content

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 ?

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


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


Reply