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.