ST_geometry等函数对arcgis空间库的操作

1.ST_Geometry

创建并查询点、线串和面要素

这些示例将创建表 (geoms)，并将点、线串以及面值插入其中。

Oracle

CREATE TABLE geoms ( id integer, geometry sde.st_geometry);

INSERT INTO GEOMS (id, geometry) VALUES ( 1901, sde.st_geometry ('point (1 2)', 4326));--To insert the same point using optimized point construction:INSERT INTO GEOMS (id, geometry) VALUES ( 1901, sde.st_geometry (1,2,null,null,4326));INSERT INTO GEOMS (id, geometry) VALUES ( 1902, sde.st_geometry ('linestring (33 2, 34 3, 35 6)', 4326));INSERT INTO GEOMS (id, geometry) VALUES ( 1903, sde.st_geometry ('polygon ((3 3, 4 6, 5 3, 3 3))', 4326));

2.ST_X,ST_Y

 select sde.st_x(shape) as x,sde.st_y(shape) as y from TABLENAME

参考文档，见http://resources.arcgis.com/zh-cn/help/main/10.2/#/na/006z0000003n000000/