oracle sde函数,Oracle spatial函数示例

Oracle spatial函数示例

显示计算Oracle spatial 空间对象面积

select mdsys.sdo_geom.sdo_area(shape,0.005) from jbnt_xzq;

//根据面对象的坐标对计算面的几何对象面积

/2003=面对象

//srid=2359  投影Xian80 3d 35

//CoorValueSet=35123456.123456,4312345.123456,35123456.123457,4312345.123457,…

select mdsys.sdo_geom.sde_area(mdsys.sdo_geometry(2003,2359,null,

mdsys.sdo_elem_info_array(1,1003,1),

mdsys.sdo_ordinate_array(CoorValueSet)

),0.005) from dual;

//获取几何对象面积并存入到数据库表的字段中的方法

update   jbnt_xzq  set jbntmj=mdsys.sdo_geom.sdo_area(shape,0.005);

获取几何对象的最大外包络矩形对象

select MDSYS.SDO_GEOM.SDO_MBR(SHAPE)

from “CDBFSGDB”.”JBNT_XZQ”

MDSYS.SDO_GEOM.sdo_union

.relate

.sdo_difference

.sdo_xor

.sdo_intersection

.sdo_poly_union

.sdo_area

.sdo_length

.sdo_distance

.validate_geometry

…

MDSYS.SDO_SAM.simplity_geometry

.simplity_layer

…

MDSYS.SDO_TOPO.create_topology

.drop_topology

…

MDSYS.SDO_UTIL.truncate_number

.polygontoline

.convert_distance

.convert_unit

.reverse_linestring

…

MDSYS.SDO_CS.transform_layer

.validate_wkt(srid)

.transform

…

…

//–the–end—

//vp:hsg

//create date:2012-05-25

转载自：https://blog.csdn.net/hsg77/article/details/7610143