Oracle spatial function example
Display the area of the computing Oracle spatial Space Object
Select mdsys. sdo_geom.sdo_area (shape, 0.005) from jbnt_xzq;
// Calculate the area of the geometric object based on the coordinates of the Surface object
/2003 = Surface object
// Srid = 2359 projection Xian80 3d 35
// CoorValueSet = 35123456.123456, 4312345.123456, 35123456.123457, 4312345.123457 ,...
Select mdsys. sdo_geom.sde_area (mdsys. sdo_geometry (2007,2359, null,
Mdsys. sdo_elem_info_array (1,1003, 1 ),
Mdsys. sdo_ordinate_array (CoorValueSet)
), 0.005) from dual;
// Obtain the method for storing the area of a geometric object in the fields of the database table
Update jbnt_xzq set jbntmj = mdsys. sdo_geom.sdo_area (shape, 0.005 );
Obtains the maximum outer envelope rectangle of a geometric object.
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
For more information about Oracle, see Oracle topics page http://www.bkjia.com/topicnews.aspx? Tid = 12