Mastering QGIS - Second Edition

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 is available at http://www.sqlite.org/lang.html. A full listing of the SpatialLite SQL extension ...