# Package org.h2gis.functions.spatial.properties

package org.h2gis.functions.spatial.properties

Classes
Class
Description
ST_3DArea
Compute the 3D area of a polygon or a multiolygon.
ST_3DLength
ST_3DLength returns the 3D length (of a LineString) or the 3D perimeter (of a Polygon).
ST_3DPerimeter
ST_3DPerimeter returns the 3D perimeter of a polygon or a multipolygon.
ST_Area
Compute geometry area
ST_Boundary
Get geometry boundary as geometry.
ST_Centroid
Computes the centroid of this Geometry.
ST_CompactnessRatio
ST_CompactnessRatio computes the perimeter of a circle whose area is equal to the given polygon's area, and returns the ratio of this computed perimeter to the given polygon's perimeter.
ST_CoordDim
ST_CoordDim returns the dimension of the coordinates of the given geometry.
ST_Dimension
Get dimension of a geometry 0 for a Point, 1 for a line and 2 for a polygon.
ST_Distance
For geometry type returns the 2-dimensional minimum Cartesian distance between two geometries in projected units (spatial ref units)
ST_DistanceSphere
For geometry type returns minimum distance in meters between two geometries
ST_EndPoint
Returns the last coordinate of a Geometry as a POINT, given that the Geometry is a LINESTRING or a MULTILINESTRING containing only one LINESTRING; Returns NULL for all other Geometries.
ST_Envelope
Get geometry envelope as geometry.
ST_EstimatedExtent
Estimated extent function based on the internal H2 ESTIMATED_ENVELOPE
ST_Explode
This table function explode Geometry Collection into multiple geometries
ST_Explode.ExplodeResultSet
Explode fields only on request
ST_Explode.ExplodeResultSetQuery
Explode fields only on request The input data must be a SELECT expression that contains a geometry column
ST_Extent
ST_Extent returns an `Envelope` that cover all aggregated geometries.
ST_ExteriorRing
Returns a LinearRing instance or Null if parameter is not a Polygon.
ST_GeometryN
Return Geometry number n from the given GeometryCollection.
ST_GeometryType
Return the type of geometry : ST_POINT, ST_LINESTRING, ST_POLYGON...
ST_GeometryTypeCode
Returns the OGC SFS `GeometryTypeCodes` of a Geometry.
ST_InteriorRingN
Returns a LinearRing instance or Null if parameter is not a Polygon.
ST_Is3D
Returns 1 if a geometry has a z-coordinate, otherwise 0.
ST_IsClosed
Return TRUE if the provided geometry is a closed LINESTRING or MULTILINESTRING, null otherwise.
ST_IsEmpty
Test if the provided geometry is empty.
ST_IsRectangle
ST_IsRectangle returns true if the given geometry is a rectangle.
ST_IsRing
Return TRUE if the provided geometry is a closed and simple LINESTRING or MULTILINESTRING; NULL otherwise.
ST_IsSimple
Test if the provided geometry is simple.
ST_IsValid
ST_IsValid returns true if the given geometry is valid.
ST_IsValidDetail
Returns a valid_detail (valid,reason,location) as an array of objects.
ST_IsValidReason
Returns text stating if a geometry is valid or not an if not valid, a reason why
ST_Length
Compute the geometry length.
ST_M
Get the first M(easure) coordinate
ST_MemSize
Compute the amount of memory space (in bytes) for the input value
ST_MinimumDiameter
Compute a minimum diameter for a given geometry
ST_NPoints
ST_NumGeometries
Get the number of geometries inside a geometry collection
ST_NumInteriorRing
Alias for ST_NumInteriorRings.
ST_NumInteriorRings
Return the number of holes in a geometry
ST_NumPoints
Get the number of points inside a geometry
ST_Perimeter
ST_Perimeter returns the perimeter of a polygon or a multipolygon.
ST_PointN
Returns the nth point of a LINESTRING or a MULTILINESTRING containing exactly one LINESTRING; NULL otherwise.
ST_PointOnSurface
Get a Point that lie on the surface of a Surface Geometry.
ST_SRID
Retrieve the SRID from an EWKB encoded geometry.
ST_StartPoint
Returns the first coordinate of a Geometry as a POINT, given that the Geometry is a LINESTRING or a MULTILINESTRING containing only one LINESTRING; Returns NULL for all other Geometries.
ST_X
Get the first X coordinate
ST_XMax
ST_XMax returns the maximal x-value of the given geometry.
ST_XMin
ST_XMin returns the minimal x-value of the given geometry.
ST_Y
Get the first Y coordinate
ST_YMax
ST_YMax returns the maximal y-value of the given geometry.
ST_YMin
ST_YMin returns the minimal y-value of the given geometry.
ST_Z
Get the first Z coordinate
ST_ZMax
ST_ZMax returns the maximal z-value of the given geometry.
ST_ZMin
ST_ZMin returns the minimal z-value of the given geometry.