MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 11 to 20 of 25 total results

12.16.9.1 Spatial Relation Functions That Use Object Shapes

https://dev.mysql.com/doc/refman/5.7/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 for ST_Distance() and ...

12.16.9.2 Spatial Relation Functions That Use Minimum Bounding Rectangles

https://dev.mysql.com/doc/refman/5.7/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. A corresponding set of MBR functions ...

12.16.5 MySQL-Specific Functions That Create Geometry Values

https://dev.mysql.com/doc/refman/5.7/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 ...

11.4.2.1 The Geometry Class Hierarchy

https://dev.mysql.com/doc/refman/5.7/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) ...

12.16.7.1 General Geometry Property Functions

https://dev.mysql.com/doc/refman/5.7/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. Dimension() is deprecated; expect it to be removed in a future MySQL release. Envelope() is deprecated; expect it to be removed in a future ...

11.4.6 Populating Spatial Columns

https://dev.mysql.com/doc/refman/5.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 ...

12.16.7 Geometry Property Functions

https://dev.mysql.com/doc/refman/5.7/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 ...

12.16.2 Argument Handling by Spatial Functions

https://dev.mysql.com/doc/refman/5.7/en/spatial-function-argument-handling.html

Spatial values, or geometries, have the properties described in Section 11.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 ...

11.4.1 Spatial Data Types

https://dev.mysql.com/doc/refman/5.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 11.4.2, “The OpenGIS Geometry Model”. Some spatial data types hold single geometry values: GEOMETRY POINT LINESTRING POLYGON ...

12.16.4 Functions That Create Geometry Values from WKB Values

https://dev.mysql.com/doc/refman/5.7/en/gis-wkb-functions.html

These functions take as arguments a BLOB containing a Well-Known Binary (WKB) representation and, optionally, a spatial reference system identifier (SRID). ST_GeomFromWKB() accepts a WKB value of any geometry type as its first argument. Other ...

Displaying 11 to 20 of 25 total results