PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/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/doc/refman/8.0/en/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/doc/refman/8.0/en/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/doc/refman/8.0/en/cast-functions.html
Conditions for Casts to LineString When the cast result type is LineString, these conditions apply: If the expression to cast is a well-formed geometry of type LineString, the function result is that LineString. If the expression to cast is a ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-operator-functions.html
An ER_WRONG_ARGUMENTS error occurs for ST_Buffer() with a negative distance for Point, MultiPoint, LineString, and MultiLineString values, and for geometry collections not containing any Polygon or MultiPolygon values. An end or join strategy is ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-relation-functions-object-shapes.html
For example, given two LineString arguments, only the points explicitly mentioned in the geometries are considered. ST_FrechetDistance() handles its geometry arguments as described in the introduction to this section, with these exceptions: The ...
https://dev.mysql.com/doc/refman/8.0/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 14.2, “Loadable Function Reference”. ->> Return value ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-function-reference.html
The following table lists each spatial function and provides a short description of each one.
https://dev.mysql.com/doc/refman/8.0/en/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/doc/refman/8.0/en/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 ...