The functions listed in this section do not restrict their argument and accept a geometry value of any type.
ST_Dimension()
andDimension()
are synonyms. For more information, see the description ofST_Dimension()
.ST_Envelope()
andEnvelope()
are synonyms. For more information, see the description ofST_Envelope()
.ST_GeometryType()
andGeometryType()
are synonyms. For more information, see the description ofST_GeometryType()
.ST_IsEmpty()
andIsEmpty()
are synonyms. For more information, see the description ofST_IsEmpty()
.ST_IsSimple()
andIsSimple()
are synonyms. For more information, see the description ofST_IsSimple()
.ST_SRID()
andSRID()
are synonyms. For more information, see the description ofST_SRID()
.Returns the inherent dimension of the geometry value
g
, orNULL
if the argument isNULL
. The dimension can be −1, 0, 1, or 2. The meaning of these values is given in Section 11.4.2.2, “Geometry Class”.mysql> SELECT ST_Dimension(ST_GeomFromText('LineString(1 1,2 2)')); +------------------------------------------------------+ | ST_Dimension(ST_GeomFromText('LineString(1 1,2 2)')) | +------------------------------------------------------+ | 1 | +------------------------------------------------------+
ST_Dimension()
andDimension()
are synonyms.Returns the minimum bounding rectangle (MBR) for the geometry value
g
, orNULL
if the argument isNULL
. The result is returned as aPolygon
value that is defined by the corner points of the bounding box:POLYGON((MINX MINY, MAXX MINY, MAXX MAXY, MINX MAXY, MINX MINY))
mysql> SELECT ST_AsText(ST_Envelope(ST_GeomFromText('LineString(1 1,2 2)'))); +----------------------------------------------------------------+ | ST_AsText(ST_Envelope(ST_GeomFromText('LineString(1 1,2 2)'))) | +----------------------------------------------------------------+ | POLYGON((1 1,2 1,2 2,1 2,1 1)) | +----------------------------------------------------------------+
ST_Envelope()
andEnvelope()
are synonyms.Returns a binary string indicating the name of the geometry type of which the geometry instance
g
is a member, orNULL
if the argument isNULL
. The name corresponds to one of the instantiableGeometry
subclasses.mysql> SELECT ST_GeometryType(ST_GeomFromText('POINT(1 1)')); +------------------------------------------------+ | ST_GeometryType(ST_GeomFromText('POINT(1 1)')) | +------------------------------------------------+ | POINT | +------------------------------------------------+
ST_GeometryType()
andGeometryType()
are synonyms.This function is a placeholder that returns 0 for any valid geometry value, 1 for any invalid geometry value, or
NULL
if the argument isNULL
.MySQL does not support GIS
EMPTY
values such asPOINT EMPTY
.ST_IsEmpty()
andIsEmpty()
are synonyms.Returns 1 if the geometry value
g
has no anomalous geometric points, such as self-intersection or self-tangency.ST_IsSimple()
returns 0 if the argument is not simple, andNULL
if the argument isNULL
.The descriptions of the instantiable geometric classes given under Section 11.4.2, “The OpenGIS Geometry Model” includes the specific conditions that cause class instances to be classified as not simple.
ST_IsSimple()
andIsSimple()
are synonyms.Returns an integer indicating the spatial reference system ID associated with the geometry value
g
, orNULL
if the argument isNULL
.mysql> SELECT ST_SRID(ST_GeomFromText('LineString(1 1,2 2)',101)); +-----------------------------------------------------+ | ST_SRID(ST_GeomFromText('LineString(1 1,2 2)',101)) | +-----------------------------------------------------+ | 101 | +-----------------------------------------------------+