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/