mssql Vectorlayer import have no Coordinatesystem Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern) Announcing the arrival of Valued Associate #679: Cesar Manara Unicorn Meta Zoo #1: Why another podcast?Why is Spatialite delivering “Invalid SRID” error messageMSSQL spatial layer import errorGet default values from PostGIS DB in QGIS 2.4 editorPostGIS - interfacing with CADCORP 7.1 and QGIS - user 'postgres' can import, but no other roles canPostgreSQL trouble editing points / lines / polygons in QGISWhy would FME imported data into SQL Server not being found by QGIS?QGIS -> Add VectorLayer DXF import fails: “invalid”Loading layer from ArcSDE for SQL Server Database using PyQGIS?How to backup QGIS (3.2.1) layer to independent PostGIS table?Is a PK required for GeoPackage vector layers?

Co-worker has annoying ringtone

What is the role of と after a noun when it doesn't appear to count or list anything?

Why are vacuum tubes still used in amateur radios?

Relating to the President and obstruction, were Mueller's conclusions preordained?

Nose gear failure in single prop aircraft: belly landing or nose-gear up landing?

Caught masturbating at work

How much damage would a cupful of neutron star matter do to the Earth?

Why not send Voyager 3 and 4 following up the paths taken by Voyager 1 and 2 to re-transmit signals of later as they fly away from Earth?

Is it dangerous to install hacking tools on my private linux machine?

Why complex landing gears are used instead of simple,reliability and light weight muscle wire or shape memory alloys?

Moving a wrapfig vertically to encroach partially on a subsection title

How to change the tick of the color bar legend to black

Sally's older brother

Rationale for describing kurtosis as "peakedness"?

Does silver oxide react with hydrogen sulfide?

what is the log of the PDF for a Normal Distribution?

How can god fight other gods?

What does the writing on Poe's helmet say?

Did Mueller's report provide an evidentiary basis for the claim of Russian govt election interference via social media?

Tips to organize LaTeX presentations for a semester

Why not use the yoke to control yaw, as well as pitch and roll?

Why datecode is SO IMPORTANT to chip manufacturers?

Is multiple magic items in one inherently imbalanced?

One-one communication



mssql Vectorlayer import have no Coordinatesystem



Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern)
Announcing the arrival of Valued Associate #679: Cesar Manara
Unicorn Meta Zoo #1: Why another podcast?Why is Spatialite delivering “Invalid SRID” error messageMSSQL spatial layer import errorGet default values from PostGIS DB in QGIS 2.4 editorPostGIS - interfacing with CADCORP 7.1 and QGIS - user 'postgres' can import, but no other roles canPostgreSQL trouble editing points / lines / polygons in QGISWhy would FME imported data into SQL Server not being found by QGIS?QGIS -> Add VectorLayer DXF import fails: “invalid”Loading layer from ArcSDE for SQL Server Database using PyQGIS?How to backup QGIS (3.2.1) layer to independent PostGIS table?Is a PK required for GeoPackage vector layers?



.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;








0















Hi I'am using QGIS Version 3.4.6. If I add a Vectorlayer out of my mssql database a CRS dialog pops up for choosing a coordinatesystem. Like loading layer without CRS.



uri = QgsDataSourceUri()

uri.setConnection(host, "5432",database, user, pw)

uri.setDataSource(schema, table,"the_geom", sql_script)

uri.setKeyColumn(key)

uri.setSrid("3068")

vlayer = QgsVectorLayer(uri.uri(), table, "mssql")



The layer is loading but after adding, the CRS dialog pops up. Has somebody an idea why this not working correctly?










share|improve this question




























    0















    Hi I'am using QGIS Version 3.4.6. If I add a Vectorlayer out of my mssql database a CRS dialog pops up for choosing a coordinatesystem. Like loading layer without CRS.



    uri = QgsDataSourceUri()

    uri.setConnection(host, "5432",database, user, pw)

    uri.setDataSource(schema, table,"the_geom", sql_script)

    uri.setKeyColumn(key)

    uri.setSrid("3068")

    vlayer = QgsVectorLayer(uri.uri(), table, "mssql")



    The layer is loading but after adding, the CRS dialog pops up. Has somebody an idea why this not working correctly?










    share|improve this question
























      0












      0








      0








      Hi I'am using QGIS Version 3.4.6. If I add a Vectorlayer out of my mssql database a CRS dialog pops up for choosing a coordinatesystem. Like loading layer without CRS.



      uri = QgsDataSourceUri()

      uri.setConnection(host, "5432",database, user, pw)

      uri.setDataSource(schema, table,"the_geom", sql_script)

      uri.setKeyColumn(key)

      uri.setSrid("3068")

      vlayer = QgsVectorLayer(uri.uri(), table, "mssql")



      The layer is loading but after adding, the CRS dialog pops up. Has somebody an idea why this not working correctly?










      share|improve this question














      Hi I'am using QGIS Version 3.4.6. If I add a Vectorlayer out of my mssql database a CRS dialog pops up for choosing a coordinatesystem. Like loading layer without CRS.



      uri = QgsDataSourceUri()

      uri.setConnection(host, "5432",database, user, pw)

      uri.setDataSource(schema, table,"the_geom", sql_script)

      uri.setKeyColumn(key)

      uri.setSrid("3068")

      vlayer = QgsVectorLayer(uri.uri(), table, "mssql")



      The layer is loading but after adding, the CRS dialog pops up. Has somebody an idea why this not working correctly?







      qgis sql-server vector-layer






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Apr 12 at 11:24









      RickJamesRickJames

      326




      326




















          0






          active

          oldest

          votes












          Your Answer








          StackExchange.ready(function()
          var channelOptions =
          tags: "".split(" "),
          id: "79"
          ;
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function()
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled)
          StackExchange.using("snippets", function()
          createEditor();
          );

          else
          createEditor();

          );

          function createEditor()
          StackExchange.prepareEditor(
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: false,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: null,
          bindNavPrevention: true,
          postfix: "",
          imageUploader:
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          ,
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          );



          );













          draft saved

          draft discarded


















          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f318596%2fmssql-vectorlayer-import-have-no-coordinatesystem%23new-answer', 'question_page');

          );

          Post as a guest















          Required, but never shown

























          0






          active

          oldest

          votes








          0






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes















          draft saved

          draft discarded
















































          Thanks for contributing an answer to Geographic Information Systems Stack Exchange!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid …


          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.

          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f318596%2fmssql-vectorlayer-import-have-no-coordinatesystem%23new-answer', 'question_page');

          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          Export of reprojected layer from GEE fails Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern) Announcing the arrival of Valued Associate #679: Cesar Manara Unicorn Meta Zoo #1: Why another podcast?Iterate over features and years to export images for each feature-yearEarth engine reproject: why does reprojecting a pixel at 30m scale gives me pixels with an area of ~550?Exporting slope raster for entire country in GEEGEE Landsat SR year composite // mask cloud / shadow out w/ other method than quality pixel"export region contains no valid (un-masked) pixels - Google Earth EgineGoogle Earth Engine, how to distinguish between rivers/streams and ponds/lakes in a water maskPython script tool fails when processing rainfall data from Google Earth EngineGoogle Earth Engine Error: Number of pixels requested from Image.load exceeds the maximum allowedCloudfree images in small area from Sentinel-2Using Image exportToDrive in Google Earth Engine?

          Magento 1.9 observer on only new product added ( no updated product )Admin Create New Order ObserverObserver checkout_cart_product_add_after get product quantity in cartHow can I differentiate between product creation and saving existing products?How to get the original price Product SaveBeforeMagento Observer for Admin Sales order Address updateHow do i get quantity in a product_save_after event observer magento2?Using observer event to get updated customer infoSave product observer - detect availabilityEvent not triggered when new product added in admin : Magento 2magento 1.9 observer on quantity product change

          Crop image to path created in TikZ? Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)Crop an inserted image?TikZ pictures does not appear in posterImage behind and beyond crop marks?Tikz picture as large as possible on A4 PageTransparency vs image compression dilemmaHow to crop background from image automatically?Image does not cropTikzexternal capturing crop marks when externalizing pgfplots?How to include image path that contains a dollar signCrop image with left size given