Join Sheeri Cabral for an in-depth discussion in this video Using GIS in MySQL, part of Advanced Topics in MySQL and MariaDB.
- Using Geographical Information Systems…is a bit easier than understanding…all of the different conventions…used in Geographical Information Systems.…One of the most used functions relating…to geometry is the geometry from text function.…Each of the classes I have described is a parameter that can…be given to this function along with a set of points.…For example, the geometry from text function can be given…the point class, and then an X and Y coordinate pair.…
Here the X coordinate is one and the Y coordinate is five.…The output of this function is a geometry data type…that is a point, this can be inserted…into a table, or set as a user variable.…Let's create a table for our geometry example.…Let's call our table name geometry example,…and give it an ID that's an integer…not null auto increment primary key.…Then we'll give it a name, and let's have it…be a varchar 64 not null, and then a shape…which is gonna be the data type of geometry, also not null.…
Let's now create a point temporarily…storing the value in a user variable.…
Want more information about MariaDB? Check out Understanding MariaDB for MySQL Users.
- Comparing MariaDB and MySQL
- Creating and using virtual columns in MariaDB
- Building Sphinx tables
- Installing HandlerSocket
- Setting up GTIDs in MariaDB and MySQL
- Audit logging in MariaDB and MySQL
- Using GIS in MariaDB and MySQL