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/