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
更多Oracle相关信息见 专题页面