https://dev.mysql.com/gis-linestring-property-functions.html
You can extract particular points of a LineString, count the number of points that it contains, or obtain its length. These functions are available for obtaining linestring properties: ST_EndPoint(ls) Returns the Point that is the endpoint of the ...
https://dev.mysql.com/gis-class-linestring.html
A LineString is a Curve with linear interpolation between points. LineString Examples On a world map, LineString objects could represent rivers. LineString Properties A LineString has coordinates of segments, defined by each consecutive pair of ...
https://dev.mysql.com/using-spatial-indexes.html
The following query finds all objects that are in the given rectangle: mysql> SET @poly = -> 'Polygon((30000 15000, 31000 15000, 31000 16000, 30000 16000, 30000 15000))'; mysql> SELECT fid,ST_AsText(g) FROM geom WHERE -> ... The optimizer ...
https://dev.mysql.com/func-op-summary-ref.html
GTID_SUBTRACT() Return all GTIDs in set that are not in subset. JSON_CONTAINS() Whether JSON document contains specific object at path JSON_CONTAINS_PATH() Whether JSON document contains any data at path JSON_DEPTH() Maximum depth of JSON document ...
https://dev.mysql.com/spatial-function-reference.html
The following table lists each spatial function and provides a short description of each one.
https://dev.mysql.com/spatial-convenience-functions.html
mysql> SET @ls1 = ST_GeomFromText('LINESTRING(0 0)'); mysql> SET @ls2 = ST_GeomFromText('LINESTRING(0 0, 1 1)'); mysql> SELECT ST_AsText(ST_Validate(@ls1)); +------------------------------+ | ST_AsText(ST_Validate(@ls1)) | ... The functions in this ...
https://dev.mysql.com/gis-format-conversion-functions.html
mysql> SET @g = 'LineString(1 1,2 2,3 3)'; mysql> SELECT ST_AsText(ST_GeomFromText(@g)); +--------------------------------+ | ST_AsText(ST_GeomFromText(@g)) | +--------------------------------+ | LINESTRING(1 1,2 2,3 3) | ... MySQL supports the ...
https://dev.mysql.com/gis-general-property-functions.html
mysql> SELECT ST_Dimension(ST_GeomFromText('LineString(1 1,2 2)')); +------------------------------------------------------+ | ST_Dimension(ST_GeomFromText('LineString(1 1,2 2)')) | +------------------------------------------------------+ | 1 | ...
https://dev.mysql.com/spatial-operator-functions.html
ST_Buffer() handles its arguments as described in the introduction to this section, with these exceptions: For a negative distance for Point, MultiPoint, LineString, and MultiLineString values, and for geometry collections not containing any Polygon ... OpenGIS proposes a number of functions that can produce ...
https://dev.mysql.com/gis-data-formats.html
mysql> SELECT ST_X(Point(15, 20)); +---------------------+ | ST_X(POINT(15, 20)) | +---------------------+ | 15 | +---------------------+ mysql> SELECT ST_X(ST_GeomFromText('POINT(15 20)')); +---------------------------------------+ | ... Two ...
