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/gis-polygon-property-functions.html
ST_Area() handles its arguments as described in the introduction to this section, with these exceptions: If the geometry is geometrically invalid, either the result is an undefined area (that is, it can be any number), or an error occurs. Functions ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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 ...