Bug report #8326
MSSQL Import doesn't set SRID recognizable to ArcGIS
|Affected QGIS version:||1.8.0||Regression?:||No|
|Operating System:||Windows||Easy fix?:||No|
|Pull Request or Patch supplied:||No||Resolution:||invalid|
|Crashes QGIS or corrupts data:||No||Copied to github as #:||17117|
This issue only affects a table imported through a QGIS SQL Server connection that is consumed in ArcMap v10.x
The issue is that ArcGIS doesn't understand the spatial reference of the table imported through QGIS, though the SRID is recognized just fine in QGIS.
The error in ArcMap is: "Unknown Spatial Reference - the following data sources you added are missing spatial reference information. This data can be drawn in ArcMap, but cannot be projected".
QGIS is a valuable editing tool for our workflow, but we need to support ArcGIS users.
If this bug was addressed, it would be the superior data loading tool for SQL Server 2012.