PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/gis-data-formats.html
Two standard spatial data formats are used to represent geometry objects in queries: Well-Known Text (WKT) format Well-Known Binary (WKB) format Internally, MySQL stores geometry values in a format that is not identical to either WKT or WKB format.
https://dev.mysql.com/doc/refman/8.0/en/using-spatial-indexes.html
The optimizer investigates whether available spatial indexes can be involved in the search for queries that use a function such as MBRContains() or MBRWithin() in the WHERE clause. The following query finds all objects that are in the given ...
https://dev.mysql.com/doc/refman/8.0/en/gis-mysql-specific-functions.html
MySQL provides a set of useful nonstandard functions for creating geometry values. The functions described in this section are MySQL extensions to the OpenGIS specification. These functions produce geometry objects from either WKB values or ...
https://dev.mysql.com/doc/refman/8.0/en/gis-geometry-class-hierarchy.html
The geometry classes define a hierarchy as follows: Geometry (noninstantiable) Point (instantiable) Curve (noninstantiable) LineString (instantiable) Line LinearRing Surface (noninstantiable) Polygon (instantiable) GeometryCollection (instantiable) ...
https://dev.mysql.com/doc/refman/8.0/en/gis-general-property-functions.html
The functions listed in this section do not restrict their argument and accept a geometry value of any type. Unless otherwise specified, functions in this section handle their geometry arguments as follows: If any argument is NULL, the return value ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-function-argument-handling.html
Spatial values, or geometries, have the properties described in Section 13.4.2.2, “Geometry Class”. Specific functions or groups of functions may have additional or different argument-handling characteristics, as discussed in the sections where ...
https://dev.mysql.com/doc/refman/8.0/en/gis-property-functions.html
Each function that belongs to this group takes a geometry value as its argument and returns some quantitative or qualitative property of the geometry. Such functions return NULL if the argument is of an incorrect geometry type. For example, the ...
https://dev.mysql.com/doc/refman/8.0/en/populating-spatial-columns.html
After you have created spatial columns, you can populate them with spatial data. Values should be stored in internal geometry format, but you can convert them to that format from either Well-Known Text (WKT) or Well-Known Binary (WKB) format. For ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-relation-functions-object-shapes.html
The OpenGIS specification defines the following functions to test the relationship between two geometry values g1 and g2, using precise object shapes. The return values 1 and 0 indicate true and false, respectively, except that distance functions ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-type-overview.html
MySQL has spatial data types that correspond to OpenGIS classes. The basis for these types is described in Section 13.4.2, “The OpenGIS Geometry Model”. Some spatial data types hold single geometry values: GEOMETRY POINT LINESTRING POLYGON ...