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/spatial-relation-functions-mbr.html
MySQL provides several MySQL-specific functions that test the relationship between minimum bounding rectangles (MBRs) of two geometries g1 and g2. The return values 1 and 0 indicate true and false, respectively. The bounding box of a point is ...
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. Unless otherwise specified, functions in this section handle their geometry arguments as follows: If any argument is NULL or any ...
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/gis-geometrycollection-property-functions.html
Unless otherwise specified, functions in this section handle their geometry arguments as follows: If any argument is NULL or any geometry argument is an empty geometry, the return value is NULL. If any geometry argument is not a syntactically ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-aggregate-functions.html
MySQL supports aggregate functions that perform a calculation on a set of values. For general information about these functions, see Section 14.19.1, “Aggregate Function Descriptions”. ST_Collect() can be used as a window function, as signified ...
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 ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-types.html
The Open Geospatial Consortium (OGC) is an international consortium of more than 250 companies, agencies, and universities participating in the development of publicly available conceptual solutions that can be useful with all kinds of applications ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-geojson-functions.html
This section describes functions for converting between GeoJSON documents and spatial values. Feature and FeatureCollection objects are not supported, except that geometry objects are extracted from them. MySQL also supports a native JSON data type ...
https://dev.mysql.com/doc/refman/8.0/en/gis-point-property-functions.html
A Point consists of X and Y coordinates, which may be obtained using the ST_X() and ST_Y() functions, respectively. These functions also permit an optional second argument that specifies an X or Y coordinate value, in which case the function result ...
https://dev.mysql.com/doc/refman/8.0/en/creating-spatial-indexes.html
For InnoDB and MyISAM tables, MySQL can create spatial indexes using syntax similar to that for creating regular indexes, but using the SPATIAL keyword. For storage engines that support nonspatial indexing of spatial columns, the engine creates a ...