{"id":5167,"date":"2019-02-22T02:46:52","date_gmt":"2019-02-22T02:46:52","guid":{"rendered":"https:\/\/max-drake.cc\/?p=5167"},"modified":"2019-02-22T02:46:52","modified_gmt":"2019-02-22T02:46:52","slug":"qgis-madeira-basic-conns-to-maps-csvs-databases","status":"publish","type":"post","link":"https:\/\/max-drake.cc\/?p=5167","title":{"rendered":"QGis Madeira Basic conns to Maps\/.csv&#8217;s\/Databases"},"content":{"rendered":"<p>I thought I&#8217;d have a look at QGis again now that it has been updated.<br \/>\nI&#8217;m always wow&#8217;d by what people can do with the GIS mapping. Unfortunately for me I&#8217;m an amateur playing in this area. I did a cartography course at Uni way back and enjoy exploring some mapping tools.<\/p>\n<p>As QGis and other mapping programmes are not my everyday tools, a bit like GIMP\u00a0 the <span class=\"js-about-item-abstr\">raster graphics editor used for image retouching and editing<\/span> tool, I struggle to become familiar and comfortable with the programmes and productive with them.<\/p>\n<p>That does not stop me being interested and trying to learn a bit more about them. Becoming a little familiar with them and their capabilities allow me to think of using them as a possible tool in the future.<\/p>\n<p>I have been YouTubing some of its newer features and came across a few interesting things.<\/p>\n<p>A basic tutorial on creating a map:<\/p>\n<p><iframe data-src=\"https:\/\/www.youtube.com\/embed\/4rRHQEWLZT4\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" data-load-mode=\"1\"><\/iframe><\/p>\n<p><strong>Printable Map (to PDF)<\/strong><\/p>\n<p>What I quite liked about the video above is he creates a printable map at the end. I tried doing that too, and found, if you zoomed out too far it took ages for the map to render, only when in was down at block scale did I find that it rendered the map in a reasonable time.<\/p>\n<h2>BACKGROUND Google, Bing, OSM and other maps<\/h2>\n<p>Another couple of videos show how to bring in underlay maps such as Google, Open Street Map &amp; Bing using the\u00a0 <strong>XYZ Connection.<\/strong><\/p>\n<p><img decoding=\"async\" class=\"alignnone wp-image-5174 lazyload\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/02\/2019-02-22-14_17_08-RocketDock-250x300.jpg\" alt=\"\" width=\"1351\" height=\"1621\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/02\/2019-02-22-14_17_08-RocketDock-250x300.jpg 250w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/02\/2019-02-22-14_17_08-RocketDock-768x921.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/02\/2019-02-22-14_17_08-RocketDock-853x1024.jpg 853w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/02\/2019-02-22-14_17_08-RocketDock.jpg 1296w\" data-sizes=\"(max-width: 1351px) 100vw, 1351px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1351px; --smush-placeholder-aspect-ratio: 1351\/1621;\" \/><br \/>\n<iframe data-src=\"https:\/\/www.youtube.com\/embed\/pXWDxZ3osk8\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" data-load-mode=\"1\"><\/iframe><\/p>\n<p>With his link to his website for URL strings <a href=\"https:\/\/www.hatarilabs.com\/ih-en\/how-to-add-a-google-map-in-qgis-3-tutorial\" target=\"_blank\" rel=\"noopener\"><strong>HERE<\/strong><\/a>.<\/p>\n<h2>Also, there is this video that has other OSM and Bing ones too:<br \/>\n<iframe data-src=\"https:\/\/www.youtube.com\/embed\/67ZruLlGdJs\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" data-load-mode=\"1\"><\/iframe><\/h2>\n<h2>Linking to Datasets (spreadsheets)\u00a0 &amp; Databases<\/h2>\n<p>My databases are normal tables, I have generally uses MySQL, MS SQL &amp; PostGres. I know that Postgres has a GIS add in for Spatial Data (<em> I was trying to add GIS data into OpenMaint<\/em>). There is also a link for connections to a MS SQL database, although I was not aware that they had any special spacial tables, but found this link to a page on it <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/spatial\/spatial-data-sql-server?view=sql-server-2017\" target=\"_blank\" rel=\"noopener\"><strong>here<\/strong><\/a>.<\/p>\n<h3>Spreadsheet import<\/h3>\n<p>I have a couple of QGis maps with data from Excel files, imported as .CSV files. I have just been re-importing some of that data in as a CSV file.<\/p>\n<p>I saw a pre- V3 QGis video on <a href=\"https:\/\/youtu.be\/9fjuUgZ7aso\" target=\"_blank\" rel=\"noopener\"><strong>uploading from a Spreadsheet<\/strong> <\/a>here, where the presented created a .CSV and a .CSVT file (this managed file column types as it imported all columns in as type &#8220;strings&#8221; so coulddn&#8217;t read the Lat\/Long columns as it saw it as text, not numbers.<\/p>\n<p>I just tried the process with a CSV file and as long as you bring it in as a CSV it formats column types (String, integer, etc) correctly, so no need of the 2nd file .csvt.<\/p>\n<p><img decoding=\"async\" class=\"wp-image-5176 aligncenter lazyload\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/02\/2019-02-22-14_31_54-RocketDock-271x300.jpg\" alt=\"\" width=\"1296\" height=\"1435\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/02\/2019-02-22-14_31_54-RocketDock-271x300.jpg 271w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/02\/2019-02-22-14_31_54-RocketDock-768x851.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/02\/2019-02-22-14_31_54-RocketDock-924x1024.jpg 924w\" data-sizes=\"(max-width: 1296px) 100vw, 1296px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1296px; --smush-placeholder-aspect-ratio: 1296\/1435;\" \/><\/p>\n<h2>Database- Postgres<\/h2>\n<p>At this point I just wanted to link to a database. I would have preferred to be able to link to data but have not got tables set up for it. I&#8217;m just pleased to be able to connect to the DB (<em>I have had major issues with other programmes such as Knime with connecting to DB&#8217;s<\/em>) .<\/p>\n<p>Selecting PostGIS you can select a Postgres DB with a GIS addin. (I&#8217;d done this previously and will have to refer back to my OpenMaint posts to see how I added this in). The actual tables highlighted in yellow are GIS tables but are all empty.<\/p>\n<p>The &#8220;SERVICE&#8221; input box flumoxed me, but leaving it empty works. Testing the connection works too. On my PostGres Database I had to have a login and these were used here.<\/p>\n<p><img decoding=\"async\" class=\"alignnone wp-image-5177 lazyload\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/02\/2019-02-22-14_40_53-RocketDock-259x300.jpg\" alt=\"\" width=\"1495\" height=\"1732\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/02\/2019-02-22-14_40_53-RocketDock-259x300.jpg 259w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/02\/2019-02-22-14_40_53-RocketDock-768x890.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/02\/2019-02-22-14_40_53-RocketDock-883x1024.jpg 883w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/02\/2019-02-22-14_40_53-RocketDock.jpg 1174w\" data-sizes=\"(max-width: 1495px) 100vw, 1495px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1495px; --smush-placeholder-aspect-ratio: 1495\/1732;\" \/><\/p>\n<h2>MS SQL login to Database<\/h2>\n<p>I&#8217;m not sure about specific tables that meet the spacial Data requirements for this database, but I got the connection to the database working, but no tables as I have no spacial Data tables. I&#8217;d need to do some research on these.<\/p>\n<p><img decoding=\"async\" class=\"wp-image-5178 aligncenter lazyload\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/02\/2019-02-22-14_48_46--300x224.jpg\" alt=\"\" width=\"1262\" height=\"942\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/02\/2019-02-22-14_48_46--300x224.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/02\/2019-02-22-14_48_46--768x574.jpg 768w\" data-sizes=\"(max-width: 1262px) 100vw, 1262px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1262px; --smush-placeholder-aspect-ratio: 1262\/942;\" \/><\/p>\n<p>Leaving the Provider\/DSN input box seems to work as when I checked List Databases all the databases showed up, so the connection was working. <img decoding=\"async\" class=\"wp-image-5179 aligncenter lazyload\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/02\/2019-02-22-14_49_24-RocketDock-300x256.jpg\" alt=\"\" width=\"1316\" height=\"1123\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/02\/2019-02-22-14_49_24-RocketDock-300x256.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/02\/2019-02-22-14_49_24-RocketDock-768x655.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/02\/2019-02-22-14_49_24-RocketDock-1024x874.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/02\/2019-02-22-14_49_24-RocketDock.jpg 1479w\" data-sizes=\"(max-width: 1316px) 100vw, 1316px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1316px; --smush-placeholder-aspect-ratio: 1316\/1123;\" \/><\/p>\n<p>This Server was also running under Windows Authentication and worked fine. I had trouble with Knime connecting with Win Authentication, but no trouble at all with QGIS. <img decoding=\"async\" class=\"wp-image-5180 aligncenter lazyload\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/02\/2019-02-22-14_51_30-RocketDock-300x238.jpg\" alt=\"\" width=\"1252\" height=\"993\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/02\/2019-02-22-14_51_30-RocketDock-300x238.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/02\/2019-02-22-14_51_30-RocketDock-768x609.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/02\/2019-02-22-14_51_30-RocketDock.jpg 998w\" data-sizes=\"(max-width: 1252px) 100vw, 1252px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1252px; --smush-placeholder-aspect-ratio: 1252\/993;\" \/><\/p>\n<h2><strong>End comment<\/strong><\/h2>\n<p>There is also the 3D Views that can be explored. I&#8217;m still trying to get my head around how the Z component is created to be able to do this.<\/p>\n<p>I thought this was a smart bit of mapping, calculating Catchment.<\/p>\n<p><iframe data-src=\"https:\/\/www.youtube.com\/embed\/xfjg_jpgiTE\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" data-load-mode=\"1\"><\/iframe><\/p>\n<p>I&#8217;m pleased with the preliminary revisit to QGis, its definitely got faster and also importing\/connecting to maps, other data sources seems easier.<\/p>\n<p>I was a bit surprised how slow the rendering took for the map, although it is doing an awful lot of work. I like, in Revit, that you can send that to the cloud so that it does all that processing up there.<\/p>\n<p>This video would be something I&#8217;d be interested in replicating, showing buildings in 3D. It would be good to only show selected ones that I was working with.<\/p>\n<p><iframe data-src=\"https:\/\/www.youtube.com\/embed\/D37OsYLTsuU\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" data-load-mode=\"1\"><\/iframe><\/p>\n<p>Another thing I&#8217;d like to explore with QGis is being able to share info I have created, similar to the Google Maps stuff I have worked on.So being able to post it to the web would be interesting. I need to research that. Maybe the next post.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I thought I&#8217;d have a look at QGis again now that it has been updated. I&#8217;m always wow&#8217;d by what people can do with the GIS mapping. Unfortunately for me I&#8217;m an amateur playing in this area. I did a cartography course at Uni way back and enjoy exploring some mapping tools. As QGis and [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":5181,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[40,36,32,6,12],"tags":[],"class_list":["post-5167","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-analysis","category-databases","category-power-bi","category-maps","category-visualisation"],"featured_image_src":"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/02\/2019-02-22-15_14_51-_Well-Prop1-QGIS.jpg","featured_image_src_square":"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/02\/2019-02-22-15_14_51-_Well-Prop1-QGIS.jpg","author_info":{"display_name":"Max Drake","author_link":"https:\/\/max-drake.cc\/?author=1"},"_links":{"self":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/posts\/5167","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5167"}],"version-history":[{"count":0,"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/posts\/5167\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/media\/5181"}],"wp:attachment":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5167"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5167"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5167"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}