Bug report #10411

Geography 4326 polygon points stored in reverse for in MSSQL Server

Added by Carlos da Ponte over 10 years ago. Updated over 5 years ago.

Status:Closed
Priority:Normal
Assignee:Nathan Woodrow
Category:Data Provider/MSSQL
Affected QGIS version:2.2.0 Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:end of life
Crashes QGIS or corrupts data:No Copied to github as #:18827

Description

Looks to be that QGIS is storing the points for Geography 4326 polygons in REVERSE. When the coordinates are corrected in MS SQL Server the shape shows up in QGIS without an issue.
This issue does not occur with 4326 as Geometry. Posted as a bug per Nathan Woodrow.

Background info: http://social.msdn.microsoft.com/Forums/sqlserver/en-US/e2cdccce-46e3-4941-a491-37fbe0e7a1f2/sql-server-20082012-polygon-with-some-near-points-covers-the-whole-world?forum=sqlspatial

Link to original thread at osgeo
http://osgeo-org.1560.x6.nabble.com/QGIS-not-displaying-MSSQL-Server-4326-Geography-polygons-td5142783.html#a5142950

Thanks!
C

History

#1 Updated by Jürgen Fischer over 10 years ago

  • Category set to Data Provider/MSSQL

#2 Updated by Giovanni Manghi over 7 years ago

  • Easy fix? set to No
  • Regression? set to No

#3 Updated by Giovanni Manghi over 5 years ago

  • Resolution set to end of life
  • Status changed from Open to Closed

Also available in: Atom PDF