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

          រឿង រ៉ូមេអូ និង ហ្ស៊ុយលីយេ សង្ខេបរឿង តួអង្គ បញ្ជីណែនាំ

          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

          QGIS export composer to PDF scale the map [closed] 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?Print Composer QGIS 2.6, how to export image?QGIS 2.8.1 print composer won't export all OpenCycleMap base layer tilesSave Print/Map QGIS composer view as PNG/PDF using Python (without changing anything in visible layout)?Export QGIS Print Composer PDF with searchable text labelsQGIS Print Composer does not change from landscape to portrait orientation?How can I avoid map size and scale changes in print composer?Fuzzy PDF export in QGIS running on macSierra OSExport the legend into its 100% size using Print ComposerScale-dependent rendering in QGIS PDF output