Book Image

Mastering Geospatial Development with QGIS 3.x - Third Edition

By : Shammunul Islam, Simon Miles, Kurt Menke, GISP, Richard Smith Jr., GISP, Luigi Pirelli, John Van Hoesen, GISP
Book Image

Mastering Geospatial Development with QGIS 3.x - Third Edition

By: Shammunul Islam, Simon Miles, Kurt Menke, GISP, Richard Smith Jr., GISP, Luigi Pirelli, John Van Hoesen, GISP

Overview of this book

QGIS is an open source solution to GIS and widely used by GIS professionals all over the world. It is the leading alternative to proprietary GIS software. Although QGIS is described as intuitive, it is also, by default, complex. Knowing which tools to use and how to apply them is essential to producing valuable deliverables on time. Starting with a refresher on the QGIS basics and getting you acquainted with the latest QGIS 3.6 updates, this book will take you all the way through to teaching you how to create a spatial database and a GeoPackage. Next, you will learn how to style raster and vector data by choosing and managing different colors. The book will then focus on processing raster and vector data. You will be then taught advanced applications, such as creating and editing vector data. Along with that, you will also learn about the newly updated Processing Toolbox, which will help you develop the advanced data visualizations. The book will then explain to you the graphic modeler, how to create QGIS plugins with PyQGIS, and how to integrate Python analysis scripts with QGIS. By the end of the book, you will understand how to work with all aspects of QGIS and will be ready to use it for any type of GIS work.
Table of Contents (18 chapters)
Title Page
Copyright and Credits
About Packt
Contributors
Preface
Index

Working with tables


Excited about actually working on databases? Well, let's start off with exploring how to work with a table. 

Creating a new table within an existing GeoPackage

There are chiefly two ways to create new tables within an existing GeoPackage in QGIS, that is via the Browser panel and via the DBManager: 

  1. In the Browser panel, find the GeoPackage that you want to create a new table/layer for
  2. Right-click on it and then choose Create a new table or layer
  3. Go through the process of giving your new table a table name, a geometry type, and fields

Note

When discussing databases, the term table is used to specify data that has geometry (point, lines, and polygons, for example) but also data that is simply a table without any geometry. Both GeoPackages and SpatiaLite contain both table types. You may have noticed that, when you create a new GeoPackage, you are asked about the type of table you are creating—No Geometry, Point, Line, and so on. 

You will note that you can't change the database...