PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/spatial-index-optimization.html
MySQL permits creation of SPATIAL indexes on NOT NULL geometry-valued columns (see Section 13.4.10, “Creating Spatial Indexes”). The optimizer checks the SRID attribute for indexed columns to determine which spatial reference system (SRS) to ...
https://dev.mysql.com/doc/refman/9.7/en/spatial-relation-functions-mbr.html
row *************************** ST_Contains(@g1, @p3): 0 ST_Within(@p3, @g1): 0 MBRContains(@g1, @p3): 0 MBRCovers(@g1, @p3): 0 MBRCoveredBy(@p3, @g1): 0 ST_Disjoint(@g1, @p3): 1 ST_Intersects(@g1, @p3): 0 1 row in set (0.00 sec) The function ...
https://dev.mysql.com/doc/refman/9.7/en/drop-spatial-reference-system.html
DROP SPATIAL REFERENCE SYSTEM [IF EXISTS] srid srid: 32-bit unsigned integer This statement removes a spatial reference system (SRS) definition from the data dictionary. Example: DROP SPATIAL REFERENCE SYSTEM 4120; If no SRS definition with the ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/en/spatial-convenience-functions.html
If any geometry argument is a syntactically well-formed geometry in an undefined spatial reference system (SRS), an ER_SRS_NOT_FOUND error occurs. If both geometry parameters are valid Point or MultiPoint values in a geographic spatial reference ...
https://dev.mysql.com/doc/refman/9.7/en/spatial-analysis-functions.html
MySQL provides functions to perform various operations on spatial data.
https://dev.mysql.com/doc/refman/9.7/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/9.7/en/fetching-spatial-data.html
Fetching spatial data in internal format: Fetching geometry values using internal format can be useful in table-to-table transfers: CREATE TABLE geom2 (g GEOMETRY) SELECT g FROM geom; Fetching spatial data in WKT format: The ST_AsText() function ...
https://dev.mysql.com/doc/refman/9.7/en/spatial-geojson-functions.html
This section describes functions for converting between GeoJSON documents and spatial values. If srid refers to an undefined spatial reference system (SRS), an ER_SRS_NOT_FOUND error occurs. Feature and FeatureCollection objects are not supported, ...
https://dev.mysql.com/doc/refman/9.7/en/spatial-aggregate-functions.html
If any geometry argument is a syntactically well-formed geometry in an undefined spatial reference system (SRS), an ER_SRS_NOT_FOUND error occurs. MySQL supports aggregate functions that perform a calculation on a set of values. For general ...