MySQL is an open-source, relational database management system. Place you question on MySQL Spatial Extensions here.
Questions tagged [mysql]
279 questions
1
vote
0 answers
Calculating miles between two points using Vincenty formula
I have the following MySQL function:
DELIMITER $$
DROP FUNCTION IF EXISTS `fn_vincenty_distance`$$
CREATE FUNCTION `fn_vincenty_distance` (
lat1 FLOAT, lon1 FLOAT,
lat2 FLOAT, lon2 FLOAT
) RETURNS FLOAT
NO SQL
…
Kermit
- 111
- 2
1
vote
1 answer
Check whether a point is inside a polygon or not in MySQL
I am trying to get the points those are within the shapefile. I have tried the Spatial functions and it's showing an error:
3033 - Binary geometry function st_contains given two geometries of different srids: 4326 and 0, which should have been…
Saroj
- 111
- 1
- 5
0
votes
1 answer
Migration of running MySQL 5.7 geo query to MySQL 8
We are testing a migration from MySQL 5.7 to MySQL 8 and have identified some queries that no longer work and was hoping to get insight into the most appropriate changes. I am not a geo expert and am trying to just get the 5.7 query working. If this…
timpone
- 103
- 2
0
votes
1 answer
Seeking MySQL alternative to PostgreSQL ST_SimplifyPolygonHull
I need to optimize the timezones GeoJSON from https://github.com/evansiroky/timezone-boundary-builder/releases/tag/2022f (timezones-with-oceans.geojson.zip) to be stored in database.
There are some MySQL alternative to PostgreSQL…
Lito
- 101
0
votes
1 answer
Accessing x and y coordinates of a POLYGON in MySQL
In my database. I have a spatial column called coordinates which is of datatype POLYGON. so for example. The lunch room has coordinates POLYGON(0 2, 1 2, 3 2, 5 2, 0 2). That's just a hypothetical example.
How do I access the individual x and y…
