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

Class STArea

java.lang.Object

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

public class STArea
extends java.lang.Object

Returns the area of a polygon or multipolygon geometry. Format: ST_Area(geometry ST_Geometry, tolerance NUMBER) - returns the area of a polygon or multi polygon geometry The tolerance is optional. By default the tolerance is 0.05 for geodetic geometries and 0 for non geodetic. For projected data, the area is in the same unit as the unit of projection. For Geodetic, the area is in square meters Return -1 in case of error. Example: select ST_Area( ST_Polygon('{"type": "Polygon","coordinates": [[[1, 2], [5, 2], [5, 7], [1, 7], [1, 2]]]}', 0)) from table LIMIT 1; -- return 20

Constructor Summary

Constructors

Constructor and Description
STArea()

Method Summary

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

Methods inherited from class java.lang.Object

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

Constructor Detail

STArea

public STArea()

Method Detail

call

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

Execution call for Area UDF

Parameters:

geometry - Geometry parameter

BigDecimal - tolerance for sdo operation

Returns:

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

Throws:

java.lang.Exception