In my previous post I overviewed some important issues concerning st_geometry. You saw all kind of cool things you can do in simple sql queries. In order to use these queries you need to do some additional configurations to your database after you install sde. In here you can find instructions of how to do this. Example of Net configuration of st_geometry in linux: listener.ora: LSNR_MYDB = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = myDbSeverUrl)(PORT =...
In the last couple of months we have been using the new st_geometry type of the ArcSDE geodatabase. St_geometry allows us to use simple queries in order to retrieve and manipulate geographic layers. For example: 1: select * from buildings b 2: where sde.st_intersects(b.shape,st_point( 'POINT (35.122 32.999)' ,1) = 1; This query will return all the buildings that intersects the point (35.122,32.999). St_geometry is available from version 9.2 of ArcSDE (ESRI recommends to use st_geometry from...