oracle.spatial.spark.vector.sql.udf.function

Class STVolume

java.lang.Object

oracle.spatial.spark.vector.sql.udf.function.STVolume

public class STVolume
extends java.lang.Object

Returns the area of a multipolygon 3D geometry. The multipolygon is handled as a solid. Format: ST_Volume(multiPolygon ST_MultiPolygon, tolerance NUMBER) - returns the volume of a 3D MultiPolygon. The MultiPolygon is handled as solid
The tolerance is optional. By default the tolerance is 0.05 for geodetic geometries and 0 for non geodetic. For projected data, the volume is in the same unit as the unit of projection. For geodetic data, the volume is in cubic meters. Return -1 in case of error. Example: select select ST_Volume( ST_MultiPolygon (' { "type": "MultiPolygon", "coordinates": [[[[0, 0, 0], [0, 0, 1], [0, 1, 1], [0, 1, 0], [0, 0, 0]]], [[[0, 0, 0], [0, 1, 0], [1, 1, 0], [1, 0, 0], [0, 0, 0]]], [[[0, 0, 0], [1, 0, 0], [1, 0, 1], [0, 0, 1], [0, 0, 0]]], [[[1, 1, 0], [1, 1, 1], [1, 0, 1], [1, 0, 0], [1, 1, 0]]], [[[0, 1, 0], [0, 1, 1], [1, 1, 1], [1, 1, 0], [0, 1, 0]]], [[[0, 0, 1], [1, 0, 1], [1, 1, 1], [0, 1, 1], [0, 0, 1]]]]}', 0)) from table LIMIT 1; -- return 1.0

Constructor Summary

Constructors

Constructor and Description
STVolume()

Method Summary

Modifier and Type	Method and Description
java.lang.Double	call(java.lang.String geometry, java.math.BigDecimal inputTolerance) Execution call for Volume UDF

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

STVolume

public STVolume()

Method Detail

call

public java.lang.Double call(java.lang.String geometry,
                             java.math.BigDecimal inputTolerance)
                      throws java.lang.Exception

Execution call for Volume UDF

Parameters:

geometry - Geometry parameter

tolerance - for sdo operation

Returns:

Double the volume for the geometry, -1 if there is an error

Throws:

java.lang.Exception