geometry-api-java icon indicating copy to clipboard operation
geometry-api-java copied to clipboard

Published 20 hours ago • verified publisher icon Esri

ST_geometry import to Geometry

Open Kim-Kam opened this issue 6 years ago • 3 comments

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

Kim-Kam avatar Feb 27 '18 12:02 Kim-Kam

@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?

stolstov avatar Feb 27 '18 18:02 stolstov

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

Kim-Kam avatar Feb 28 '18 07:02 Kim-Kam

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

randallwhitman avatar Mar 02 '18 21:03 randallwhitman