I loaded spatial data in ms sqlserver. Most data are in WGS 84 coordinates, but some are in Pulkovo 42. WGS 84 objects are visible well in QGIS. I checked it in 2.4 and 2.16 versions. But Pulkovo 42 features are invisible. It depends only on value of [geometry_columns].[srid] field. When I change value from 4284 to 4326, features became visible. Records in [spatial_ref_sys] don't affect the result.

  • did you set the layer SRS correctly in QGIS? – Ian Turton Jan 30 '18 at 14:45
  • Yes, when I set it to 4326 (WGS84) in QGIS and SQLSERVER geometry_columns table, feature is visible. Changing it to another value in both places makes feature invisible in QGIS. – S.Chernyshov Jan 30 '18 at 15:40
  • if the data is in EPSG:4284 then you should set it in SQLServer and let QGIS reproject it to 4326 if that is what the project is in – Ian Turton Jan 30 '18 at 15:43
  • Sure, when I set coordinates to 4284 in SQLServer and in QGIS both, features became hidden. Coordinate system of QGIS project don't affect – S.Chernyshov Jan 30 '18 at 15:52
  • are you sure your data is actually in 4286? does it show up when added on it's own with no other data – Ian Turton Jan 30 '18 at 15:53

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.