O'Reilly logo

Mastering QGIS - Second Edition by GISP Dr. John Van Hoesen, Dr. Luigi Pirelli, GISP Dr. Richard Smith Jr., GISP Kurt Menke

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 2. Creating Spatial Databases

This chapter covers the creation and editing of spatial databases using QGIS. The core concepts of databases will be briefly reviewed; however, we have assumed that you are generally familiar with database concepts and SQL for most of the content covered in this chapter. The topics that we will cover in this chapter are as follows:

  • Core concepts of database construction
  • Creating spatial databases
  • Importing and exporting data
  • Editing databases
  • Creating queries
  • Creating views

Fundamental database concepts

A database is a structured collection of data. Databases provide multiple benefits over data stored in a flat file format, such as a shapefile or KML. These benefits include complex queries, complex relationships, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required