List of Oracle Spatial Calculations
You can use this list of spatial functions from the Oracle Analytics Calculation Library when you work with the geometry data type.
| Spacial Function | Syntax | Description |
|---|---|---|
| GeometryArea | GeometryArea(shape_expr) | Calculates the area that a shape occupies. |
| GeometryLength | GeometryLength(shape_expr) | Calculates the circumference of a shape. |
| GeometryAsText | GeometryAsText(shape_expr) | Converts the longvarbinary values of the geometry column into Well-Known Text (WKT) format, a standard format for representing geometry objects. |
| GeometryDistance | GeometryDistance(shape_expr1,shape_expr2) | Calculates the distance between two shapes. |
| GeometryRelate | GeometryRelate(shape_expr1,shape_expr2) | Determines whether one shape is inside another shape. |
| GeometryWithinDistance | GeometryWithinDistance(shape_expr1, shape_expr2,distance_expr) | Determines whether two shapes are within a specified distance of each other. |
Descriptions of the arguments that you can use with the geometry data type:
- shape_expr - Represents any valid geometry column or shape expression.
- shape_expr1,shape_expr2 - Represents any valid geometry column or shape expression.
- distance_expr - Represents any expression that evaluates to a numeric value in meters.