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, 2018 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.
    – RainForest
    Jan 30, 2018 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, 2018 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
    – RainForest
    Jan 30, 2018 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, 2018 at 15:53


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.