MySQL 8 - How do I create Spatial Tables with the Workbench

preview_player
Показать описание
Hello to everyone,
Two years ago, I have published a video about how to create a SPATIAL TABLE, using the version 5.7, of MySQL. I decided to update that explanation to the version 8.x, because there is a “little” big difference among the two versions, on the way how to do this task.
So, this means that a user can create a SPATIAL TABLE with the MySQL, version 8.x, that can be used inside the QGIS. The task is relatively simple and similar as creating a shapefile layer with QGIS. So, this task will not be unfamiliar to a QGIS user.
Just to remind, the SPATIAL TABLES are based on the shapefiles' characteristics, where each shapefile only allows the storage of one of the three types of geometries: polygons, lines, or points.
Because the procedures are similar, and the difference are only in the moment when I choose the geometry type of the table, in this video I will only demonstrate how to create a SPATIAL TABLE to store POLYGONS.
Let's see, step by step, how to accomplish the task.

Software used to build this video:
Cartographic base used in this exercise:
Рекомендации по теме
Комментарии
Автор

Caríssimo professor, sou aluno do IPVC e estou cursando o mestrado de engenharia informática. Para a disciplina de SIG decidi utilizar QGIS para digitalização e o MySQL como banco de dados. Suas dicas foram essenciais. Parabéns pelo trabalho!

WendersonWanzeller
Автор

thanks you for this video,

I want juste ask you how can I get the table of geometry columns for my different prpjects in France and what kind of CRS i need in France.?

Thank you

soulbroken
welcome to shbcf.ru