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

If g1 is a Polygon or a MultiPolygon, or if g2 is a Point or a MultiPoint, the return value is NULL. For example, it returns 0 if the first argument is a Polygon or MultiPolygon and/or the second argument is a Point or MultiPoint. Returns NULL if g1 ... The OpenGIS specification defines the following functions to test the relationship between two geometry values g1 and g2, using precise object ...

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> SET @g1 = ST_GeomFromText('Polygon((0 0,0 3,3 3,3 0,0 0))'); mysql> SET @g2 = ST_GeomFromText('Point(1 1)'); mysql> SELECT MBRContains(@g1,@g2), MBRWithin(@g2,@g1); +----------------------+--------------------+ | MBRContains(@g1,@g2) | ...

12.16.5 MySQL-Specific Functions That Create Geometry Values

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

MultiPolygon(poly [, poly] ...) Constructs a MultiPolygon value from a set of Polygon or WKB Polygon arguments. Polygon(ls [, ls] ...) Constructs a Polygon value from a number of LineString or WKB LineString arguments. MySQL provides a set of ...

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) ...All classes have properties, and instantiable classes may also have assertions (rules that define valid class ...

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

For example, the ST_Area() polygon function returns NULL if the object type is neither Polygon nor MultiPolygon. Each function that belongs to this group takes a geometry value as its argument and returns some quantitative or qualitative property ...

12.16.2 Argument Handling by Spatial Functions

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

The Open Geospatial Consortium guidelines require that input polygons already be closed, so unclosed polygons are rejected as invalid rather than being closed. Spatial values, or geometries, have the properties described in Section 11.4.2.2, ...

11.4.1 Spatial Data Types

https://dev.mysql.com/doc/refman/5.7/en/spatial-type-overview.html

Some spatial data types hold single geometry values: GEOMETRY POINT LINESTRING POLYGON GEOMETRY can store geometry values of any type. The other single-value types (POINT, LINESTRING, and POLYGON) restrict their values to a particular geometry type.

12.16.4 Functions That Create Geometry Values from WKB Values

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

MPolyFromWKB(wkb [, srid]), MultiPolygonFromWKB(wkb [, srid]) ST_MPolyFromWKB(), ST_MultiPolygonFromWKB(), MPolyFromWKB(), and MultiPolygonFromWKB() are synonyms. MPolyFromWKB() and MultiPolygonFromWKB() are deprecated; expect them to be removed in ... These functions take as arguments a BLOB containing a Well-Known Binary (WKB) representation and, optionally, a spatial reference system identifier ...

Displaying 11 to 20 of 25 total results