Vissarion Fysikopoulos
Senior software engineer
Recent Blogs
Analyzing the Similarity of Spatial Trajectories in MySQL
In this blog post, we will explore how to use MySQL's spatial features to analyze the similarity of trajectories. We will focus on key metrics such as Frechet distance, which measures the similarity between two trajectories, and other geometric operations that help quantify how closely different paths align. This functionality is available in MySQL Community and Enterprise Editions and HeatWave MySQL.
Transforming GPS data into trajectories using MySQL
Transforming GPS coordinates into trajectories in MySQL involves organizing raw GPS points (as POINT geometries) into ordered paths and converting them into LINESTRING geometries. This process uses MySQL's spatial functions like ST_Collect to aggregate points and requires ensuring proper ordering (e.g., by timestamp or sequence) to construct accurate routes.
Transformations between Spatial Reference Systems in MySQL
This blog post explores how to transform spatial data between different Spatial Reference Systems (SRS) in MySQL using the ST_Transform function. It covers the syntax and usage of ST_Transform, and its practical applications in mapping and spatial analysis by using demonstrative examples. Whether you're visualizing geographic data or integrating datasets from various sources, understanding SRS transformation is key to accurate spatial analysis.
Introducing the new CREATE_SPATIAL_REFERENCE_SYSTEM privilege in MySQL
MySQL 9.2.0 has introduced a new dynamic privilege: CREATE_SPATIAL_REFERENCE_SYSTEM. This privilege enables users to create, replace, and drop custom spatial reference systems (SRS), allowing for greater spatial data customization across MySQL environments without needing SUPER access. In this post, we’ll explain the use of this privilege and provide an example to demonstrate its application. The new privilege is available in MySQL Community and Enterprise Editions and HeatWave MySQL.