St_geometry introduction
Posted
Friday, May 15, 2009 3:49 PM
by
ysa
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 service pack 4).
More information on st_geometry is found here and here.
In my next posts I will describe this feature, how to use it, how we use it today with .Net, tips and problems we encountered while starting to use st_geometry in our systems.