How do I write a MYSQL spatial query to find all polygons (rectangle) that contain any points in a table?
Something like: SELECT * from polygons WHERE bounds CONTAINS(SELECT geom_point from points) Can someone help me out with the syntax? Bounds will always be a rectangular polygon and everything is in ...
Is it possible to add a Point at the end of a Linestring in MySql? For example I have a Linestring as Linestring(1 2, 1 4, 1 6) and I want to add a Point Point(1 7) at the end (output should ...
I have designed a polygon in a web page and the coordinates are stored in the database of the type polygon. However when I check the database, I find GEOMETRY - 120B under polygon field. What does ...