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/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. If any argument is geometrically invalid, either the result is true or false (it is undefined which), ...The return values 1 and 0 indicate true and false, ...
https://dev.mysql.com/doc/refman/8.0/en/gis-linestring-property-functions.html
If the geometry is geometrically invalid, either the result is an undefined length (that is, it can be any number), or an error occurs. If a unit is not specified, the result is in the unit of the SRS of the geometries, whether Cartesian or ...You ...
https://dev.mysql.com/doc/refman/8.0/en/gis-data-formats.html
For the WKB part, these MySQL-specific considerations apply: The byte-order indicator byte is 1 because MySQL stores geometries as little-endian values. Two standard spatial data formats are used to represent geometry objects in queries: Well-Known ...
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
Another meaning comes from cartography, referring to the geometric features that cartographers use to map the world. The Open Geospatial Consortium (OGC) is an international consortium of more than 250 companies, agencies, and universities ...
https://dev.mysql.com/doc/refman/8.0/en/gis-geometrycollection-property-functions.html
mysql> SET @gc = 'GeometryCollection(Point(1 1),LineString(2 2, 3 3))'; mysql> SELECT ST_AsText(ST_GeometryN(ST_GeomFromText(@gc),1)); +-------------------------------------------------+ | ST_AsText(ST_GeometryN(ST_GeomFromText(@gc),1)) | ...Unless ...
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-geojson-functions.html
options, if given, describes how to handle GeoJSON documents that contain geometries with coordinate dimensions higher than 2. If geometries with coordinate dimensions higher than 2 are supported in the future, you can expect these values to produce ... This section describes functions for converting between GeoJSON documents and spatial ...
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/mysql-nutshell.html
This section summarizes what has been added to, deprecated in, and removed from MySQL 8.0. A companion section lists MySQL server options and variables that have been added, deprecated, or removed in MySQL 8.0; see Section 1.4, “Server and Status ...