Bug #98614 Lat/Lon swapped on Spatial View
Submitted: 15 Feb 2020 0:36 Modified: 15 May 2020 6:52
Reporter: NOT_FOUND NULL ! Email Updates:
Status: No Feedback Impact on me:
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:8.0.19 OS:MacOS (macOS 10.15.x Catalina x86_64)
Assigned to: MySQL Verification Team CPU Architecture:Any
Tags: WBBugReporter

[15 Feb 2020 0:36] NOT_FOUND NULL !
The lat/lon is flipped in the Spatial View. And there is no apparent way to fix this other than to change the database table data (which is not an option).

How to repeat:
Load a table with polygons ordered with latitude first.

Suggested fix:
1) Detect lat/lon ordering automatically (not hard to do). 2) Provide an option to swap the lat/lon in the view.
[15 Feb 2020 0:37] NOT_FOUND NULL !
Spatial View screenshot

Attachment: Screen Shot 2020-02-14 at 4.37.10 PM.png (image/png, text), 1.08 MiB.

[15 Apr 2020 6:52] MySQL Verification Team

Thank you for the bug report.
Please provide us sample data demonstrating the problem, table with insert statements. Thanks.

Ashwini Patil
[16 May 2020 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".