topic Display Oracle Spatial geometry in ArcObjects SDK Questions

Display Oracle Spatial geometry

amirshauli — Wed, 16 Jun 2010 13:45:55 GMT

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?

Display Oracle Spatial geometry (SDO_GEOMETRY)

amirshauli — Thu, 17 Jun 2010 09:13:19 GMT

I want to change my question.
I checked and the fastest way to query those geometries from oracle spatial is UDT (User Defined Type).
The question is can ESRI read the UDT (oracle SDO_GEOMETRY)?
Or should I do some parsing in order to display it?

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

Re: Display Oracle Spatial geometry (SDO_GEOMETRY)

amirshauli — Sun, 20 Jun 2010 07:28:18 GMT

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?

Re: Display Oracle Spatial geometry

nicogis — Sun, 20 Jun 2010 16:11:36 GMT

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

Re: Display Oracle Spatial geometry

amirshauli — Mon, 21 Jun 2010 05:42:04 GMT

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?