AnsweredAssumed Answered

Oracle Direct Connect 3D Geometry not selectable

Question asked by paul.d.austin on Feb 25, 2016

In ArcMap 10.2 and ArcMap 10.3 the select by rectangle, line etc do not work for layers that include a Z value. The database is Oracle 12c.

 

The two attached sql files create two tables, one with X,Y,Z and the other with X,Y. The scripts also create a single test record.

 

The select by rectangle function works for the 2D geometries but not 3D geometries.

 

The following Oracle SQL queries work in SQL Developer however.

 

select * from gba.test_2d_line where sdo_filter(geometry, sdo_geometry('LINESTRING(1222748.8 467740.7,1222595.168 467958.142)',3005),'querytype = WINDOW') = 'TRUE'

 

select * from gba.test_3d_line where sdo_filter(geometry, sdo_geometry('LINESTRING(1222748.8 467740.7,1222595.168 467958.142)',3005),'querytype = WINDOW') = 'TRUE'

Attachments

Outcomes