Viewing tables as layers is great for creating maps or for simply working on a copy of the database outside the database. In this tutorial, we will establish a connection to our PostGIS database in order to add a table as a layer in QGIS (formerly known as Quantum GIS).
Please navigate to the following site to install the latest version LTR of QGIS.
On this page, click on Download Now and you will be able to choose a suitable operating system and the relevant settings. QGIS is available for Android, Linux, macOS X, and Windows. You might also be inclined to click on Discover QGIS to get an overview of basic information about the program along with features, screenshots, and case studies.
To begin, create the schema for this tutorial then, download data from the U.S. Census Bureau’s FTP site:
The shapefile is All Lines for Cuyahoga county in Ohio, which consist of roads and streams among other line features.
Use the following command to generate the SQL to load the shapefile:
Now it’s time to give the data we downloaded a look using QGIS. We must first create a connection to the database in order to access the table. Get connected and add the table as a layer by following the ensuing steps:
Make sure the name of your PostGIS connection appears in the drop-down menu and then click on the Connect button. If you choose not to store your username and password, you will be asked to submit this information every time you try to access the database.
Once connected, all schemas within the database will be shown and the tables will be made visible by expanding the target schema.
The same holds true the other way around. Changes to the table in the database will have no effect on the layer in QGIS.
If needed, you can save the temporary layer in a variety of formats, such as DXF, GeoJSON, KML, or SHP. Simply right-click on the layer name in the Layers panel and click on Save As. This will then create a file, which you can recall at a later time or share with others.
The following screenshot shows the Cuyahoga county road network:
You may also use the QGIS Browser Panel to navigate through the now connected PostGIS database and list the schemas and tables. This panel allows you to double-click to add spatial layers to the current project, providing a better user experience not only of connected databases, but on any directory of your machine:
You have added a PostGIS layer into QGIS using the built-in Add PostGIS Table GUI. This was achieved by creating a new connection and entering your database parameters.
Any number of database connections can be set up simultaneously. If working with multiple databases is more common for your workflows, saving all of the connections into one XML file and would save time and energy when returning to these projects in QGIS.
To explore more on 3D capabilities of PostGIS, including LiDAR point clouds, read PostGIS Cookbook – Second Edition.
Using R to implement Kriging – A Spatial Interpolation technique for Geostatistics data
Top 7 libraries for geospatial analysis
Learning R for Geospatial Analysis
Monthly digest of what's new and exciting from us.
© 2023 Company, Inc. All rights reserved.
Cookie Policy and Privacy Policy
source
