Timeline for Extract top, bottom, left, and right (as numeric values) from a polygon in MariaDB?
Current License: CC BY-SA 4.0
19 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 4 at 21:08 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jun 3 at 13:02 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jan 30 at 6:03 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Sep 30, 2023 at 20:08 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| May 29, 2023 at 15:08 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jan 21, 2023 at 17:01 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Sep 15, 2022 at 7:03 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| May 17, 2022 at 0:05 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jan 16, 2022 at 4:05 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Sep 16, 2021 at 22:04 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| May 19, 2021 at 11:06 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Dec 26, 2020 at 5:03 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Nov 19, 2020 at 13:02 | history | edited | rosscova | CC BY-SA 4.0 |
Moving my solution to an answer
|
| Nov 19, 2020 at 12:58 | answer | added | rosscova | timeline score: 0 | |
| Nov 19, 2020 at 10:29 | comment | added | user30184 | Please write your solution as an answer, it is certainly useful for other MariaDB and MySQL users. | |
| Nov 19, 2020 at 10:27 | comment | added | user30184 | The winding order of the rings of polygons is fixed so your method should be reliable. I do not know how far MariaDB is from MySQL nowadayd, but it looks that MySQL does not have any better spatial functions for your need dev.mysql.com/doc/refman/8.0/en/spatial-function-reference.html. SpatiaLite has the direct ST_MinX function what you were after gaia-gis.it/gaia-sins/spatialite-sql-latest.html. | |
| Nov 19, 2020 at 2:04 | history | edited | rosscova | CC BY-SA 4.0 |
Adding a solution I think might work
|
| Nov 19, 2020 at 1:51 | review | First posts | |||
| Nov 19, 2020 at 12:03 | |||||
| Nov 19, 2020 at 1:45 | history | asked | rosscova | CC BY-SA 4.0 |