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

更多Oracle相關資訊見Oracle 專題頁面 http://www.bkjia.com/topicnews.aspx?tid=12