Loading spatial data using QGIS

QGIS is a very common open source tool for GIS analysts, geographers, civil engineers, and many other professionals for creating maps and editing, viewing, and analyzing geospatial data. PostGIS is open source for PostgreSQL databases only, whereas QGIS is a wider open source spatial tool for many other databases, such as MSSQL, Oracle, and DB2. Hence, many developers have chosen QGIS as their GIS tool. In the following steps, we will see how PostGIS can be integrated into QGIS by setting a connection between them:

1. Right-click on PostGIS in the list under the Browser panel, as shown in the following screenshot, and select New Connection:

Figure 5.18 – QGIS main window

2. Fill in the RDS information, as shown in the following screenshot, click on the Basic tab for authentication, and then enter the following PostgreSQL database credentials:

• User name: dba
• Password: bookdemo

Figure 5.19 – Connecting QGIS to PostGIS

...