Summary

This chapter provided you with the steps to handle databases in QGIS. While QGIS can handle multiple databases, we used SpatiaLite as it provides a good amount of functionality with little overhead or administration.

Using the DB Manager you can perform a number of operations on databases. Operations of note are: creating indices, spatial and aspatial views, importing and exporting, and performing queries. From the introduction to DB Manager and SpatiaLite in this chapter, you are now well-equipped to write more complex queries that take full advantage of the SQL commands and SpatiaLite SQL extension commands. A full listing of SQLite SQL commands are available at http://www.sqlite.org/lang.html. A full listing of the SpatialLite SQL extension commands are available at http://www.gaia-gis.it/gaia-sins/spatialite-sql-4.2.0.html.

The next chapter moves us from the storage of geospatial data to the display of geospatial data. The styling capabilities of QGIS will be covered for both vector and raster files. Additionally, the rendering options that were first introduced in QGIS 2.6 will be covered.