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.

Related Content you might be interested in

Current Title:

Small book image
Mastering Geospatial Development with QGIS 3.x - Third Edition
Shammunul Islam | Simon Miles | Kurt Menke, GISP | Richard Smith Jr., GISP | Luigi Pirelli | John Van Hoesen, GISP
Mar, 2019 | 466 pages
Small book image
Learn QGIS
Andrew Cutts | Anita Graser
Nov, 2018 | 272 pages
Small book image
QGIS Quick Start Guide
Andrew Cutts
Jan, 2019 | 164 pages
Small book image
QGIS Python Programming Cookbook, Second Edition
Joel Lawhead
Mar, 2017 | 464 pages
Table of Contents (18 chapters)
Title Page
Title Page
Copyright and Credits
Copyright and Credits
About Packt
About Packt
Contributors
Contributors
Preface
Preface
Free Chapter
1
A Refreshing Look at QGIS
A Refreshing Look at QGIS
Release schedules
QGIS downloading and installation
What's new?
A tour of QGIS
Working with CRS
Working with tables
Editing data
Composing maps
Adding functionality with plugins
Summary
2
Styling Raster and Vector Data
Styling Raster and Vector Data
Choosing and managing colors
Managing color ramps
Styling multiband rasters
Raster color rendering
Raster resampling
Styling vectors
Vector layer rendering
Using diagrams to display thematic data
Saving, loading, and setting default styles
Summary
3
Creating Spatial Databases
Creating Spatial Databases
Fundamental database concepts
Creating a spatial database
Connecting to a GeoPackage
Importing data into a GeoPackage
Working with tables
Exporting tables out of a GeoPackage
Creating queries and views
Summary
4
Preparing Vector Data for Processing
Preparing Vector Data for Processing
Merging vectors
Converting vector geometries
Adding geometry columns to an attribute table
Using basic vector Geoprocessing Tools
Defining coordinate reference systems
Advanced field calculations
Summary
5
Preparing Raster Data for Processing
Preparing Raster Data for Processing
Merging rasters
About converting raster files
Clipping a raster
Converting rasters into vectors
Converting from vector to raster (rasterize)
Reclassifying rasters 
Summary
6
Advanced Data Creation and Editing
Advanced Data Creation and Editing
What's new in editing?
Creating points from coordinate data
Geocoding address-based data
Georeferencing imagery
Checking the topology of vector data
Repairing topological errors via topological editing
Repairing an overlap between polygons
Example 3 – Repairing a gap between polygons
Summary
7
Advanced Data Visualization
Advanced Data Visualization
Using live layer effects
Creating beautiful effects with inverted polygon shapeburst fills
Using the 2.5D renderer
Creating 3D views 
Creating an Atlas
The power of geometry generators
Working with the Data Plotly plugin
Summary
8
The Processing Toolbox
The Processing Toolbox
Introducing the Processing Toolbox
What's new in the Processing Toolbox?
Configuring the Processing Toolbox
Viewing the Processing Toolbox
Using the Processing Toolbox
Performing raster analysis with GRASS
Performing analysis using SAGA
Exploring hydrologic analysis with SAGA
Summary
9
Automating Workflows with the Graphical Modeler
Automating Workflows with the Graphical Modeler
Introducing the graphical modeler
Working with your model
Executing model algorithms iteratively
Nesting models
Using batch processing with models
Converting a model into a Python script
Summary
10
Creating QGIS Plugins with PyQGIS and Problem Solving
Creating QGIS Plugins with PyQGIS and Problem Solving
Webography - where to get API information and PyQGIS help
The Python Console
My second PyQGIS code snippet - looping the layer features
Exploring iface and QGis
Exploring a QGIS API in the Python Console
Creating a plugin structure with Plugin Builder
A simple plugin example
Setting up a debugging environment
Debugging session example
Summary
11
PyQGIS Scripting
PyQGIS Scripting
Where to learn Python basics
How to load layers
Vector structure
Iterating over features
Editing features
Running Processing Toolbox algorithms
Interacting with the map canvas
Summary
Other Books You May Enjoy
Other Books You May Enjoy
Leave a review - let other readers know what you think
Index
Index

Creating queries and views

Unfortunately, in QGIS 3.2, the functionality to run SQL queries against GeoPakages has not been fully developed as of yet in the DBManager. To carry on exploring SQL queries, we are going to focus on SpatiaLite. To do this, we first need to connect to a SpatiaLite database, which can be found in your Chapter 3, Creating Spatial Databases, samples download.

In the Browser panel tab, right-click on SpatiaLite and choose New Connection. Navigate to open_data.sqlite from the Chapter 3, Creating Spatial Databases, samples.

Once connected, you can expand the open_data database and see the layers and tables stored within it.

Using select statements

Open the DBManager (Database | DBManager), navigate to SpatiaLite in the tree, find the open_data database, and then click on it and expand it so that you can see all of the tables within it. Click on the SQL Window icon. 

In the new tab called Query (open_data.sqlite), you can start to perform queries. 

Let's start with our first...

Previous Section
End of Section 8
Next Section