ST_geometry import to Geometry

[Kim-Kam]

Hi Everyone,
i have ST_geometry column in oracle db, and i want to read this column and convert the st_gemetry to Geometry for further processing. is it possible with geometry-api.

on accessing data Oracle does return the ST_geometry in correct format , however i am not able to convert ST_GEOMETRY to some usable java object to get individual attributes.
OperatorImportFromESRIShape does not work.
i cannot use sde.ST_AStext method , since my middle tier does not allow it.
Thanks for any help,
Kim

[stolstov]

@Kim-Kam The formats that this library understands are Esri shape, REST JSON, WKT, WKB, and Geojson. Can you use ST_AsBinary to extract WKB?

[Kim-Kam]

Thanks for the response.
No unluckily i cannot use ST_AsBinary either. is there any other known API that does it.
Thanks,
Kamran

[randallwhitman]

Seems that options would be to change the middle tier to allow AsWkt/AsText, or write custom OperatorImportFromSomething capabilities.