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