Bug report #8326
MSSQL Import doesn't set SRID recognizable to ArcGIS
| Status: | Closed | ||
|---|---|---|---|
| Priority: | Normal | ||
| Assignee: |  Tamas Szekeres | ||
| Category: | Data Provider/MSSQL | ||
| 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 |
Description
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.
History
#1
Updated by Matthew Baker over 11 years ago
Note this loading data is done by 'drag and drop' into the MSSQL Database.
#2
Updated by Matthew Baker over 11 years ago
Just noticed that this is also an issue in QGIS - when they layer is dragged to the map canvas, QGIS will ask for the SRID.
#3
Updated by Nathan Woodrow over 11 years ago
Do you have a spatial_ref_sys table in your database. The MS SQL provider will look in there for projections.
#4
Updated by Giovanni Manghi almost 11 years ago
- Priority changed from Normal to High
#5
Updated by Giovanni Manghi about 10 years ago
- Status changed from Open to Closed
- Priority changed from High to Normal
- Crashes QGIS or corrupts data changed from Yes to No
#6
Updated by Giovanni Manghi about 10 years ago
- Resolution set to invalid
closing for lack of feedback.