Display Oracle Spatial geometry

Question

Hi all,

I have some geometries (about 5,000) that is store in Oracle Spatial as SDO_GEOMETRY
What will be the best and fastest way to get those geometries from oracle and display them in the map (ArcObjects).

I think of WKT,WKB, GML, UDT (user define type that represent sdo_geometry).

BTW
I don't have SDE and I don't want to use SDE.

Any help?

amirshauli · Answer

Thanks.
It's good to know ESRI have this functionality.
But actually I need something little different.
I can't let the client access the DB directly (security), So I have a server that pulls the geographic data for the clients and pass it on to them. I want to be able to take this data (UDT is the best way I think) and display it on the map.

How can I do it?
Can ESRI know how to read the SDO_GEOMETRY (UDT) type?
Should I need to cast the UDT to something else that ESRI can read?

nicogis · Answer

use query layer

http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/What_is_a_query_layer/00s50000000n000000/

http://blogs.esri.com/Dev/blogs/geodatabase/archive/2010/04/14/Query-Layers-_4000_-ArcGIS-10.aspx

amirshauli · Answer

maybe It will be faster to use WKT because ESRI is familiar with the UDT format?

I meant maybe It will be faster to use WKT because ESRI is NOT familiar with the UDT format?

any help here?