MySQL Geometric 38 codes

  1. Home
  2. MySQL
  3. Geometric
1 Alter table to add SPATIAL INDEX
2 Assembling of the MULTIPOINT string
3 Bounding Box Functions
4 Calculate the area
5 Calculates the actual distances and excludes the cities that are too far away
6 Calculation of the length of a route
7 Cariable @mp is assigned a Multipoint object with three points
8 Collect several geometric columns of a table into a GEOMETRYCOLLECTION
9 Determine the length of the outer polygon with EXTERIORRING function
10 Find the most westerly and easterly points
11 Functions for All Geometric Objects in MySQL
12 Functions for Converting MySQL Geometric Data
13 Functions for Point Objects
14 Geometric Functions for GeometryCollection Objects
15 Geometric Functions for Line Objects
16 Geometric Functions for Polygon Objects
17 Geometric Functions List
18 Geometric Types in MySQL That Store Exactly One Object
19 Geometric Types in MySQL That Store Several Objects in a Single Cell
20 Get the bounding box of each geometric object
21 Get the Total length
22 In calculating areas (AREA), all holes in a polygon are subtracted out
23 Indexing Geometric Data
24 Length of a LineString is sought
25 POINT type column
26 Point type column with default value
27 POLYGON type column
28 Query the length of the lines
29 Querying geometric data is with the asText function
30 Search for a certain distance
31 That the two geometric objects touch is shown by the TOUCHES function
32 The ASTEXT function specifies the bounding box in WKT format
33 To specify the start and terminal points in Well-Known Text format, a simple SELECT query will suffice
34 Total area with POLYGON
35 Use ASTEXT with point value
36 Use X(), Y() functions with point type
37 Using GEOMFROMTEXT function
38 Using the POLYGON object in the variable