Book Image

Hands-On Geospatial Analysis with R and QGIS

By : Shammunul Islam, Brad Hamson
Book Image

Hands-On Geospatial Analysis with R and QGIS

By: Shammunul Islam, Brad Hamson

Overview of this book

Managing spatial data has always been challenging and it's getting more complex as the size of data increases. Spatial data is actually big data and you need different tools and techniques to work your way around to model and create different workflows. R and QGIS have powerful features that can make this job easier. This book is your companion for applying machine learning algorithms on GIS and remote sensing data. You’ll start by gaining an understanding of the nature of spatial data and installing R and QGIS. Then, you’ll learn how to use different R packages to import, export, and visualize data, before doing the same in QGIS. Screenshots are included to ease your understanding. Moving on, you’ll learn about different aspects of managing and analyzing spatial data, before diving into advanced topics. You’ll create powerful data visualizations using ggplot2, ggmap, raster, and other packages of R. You’ll learn how to use QGIS 3.2.2 to visualize and manage (create, edit, and format) spatial data. Different types of spatial analysis are also covered using R. Finally, you’ll work with landslide data from Bangladesh to create a landslide susceptibility map using different machine learning algorithms. By reading this book, you’ll transition from being a beginner to an intermediate user of GIS and remote sensing data in no time.
Table of Contents (12 chapters)
GRASS, Graphical Modelers, and Web Mapping

Working with databases

Using QGIS, we can work with various databases, such as SpatiaLite, PostGIS, MSSQL, and Oracle Spatial. We'll learn here how to create a SpatiaLite database. We'll also learn to import shapefiles into such databases.

Creating a SpatiaLite database

The steps for creating a SpatiaLite database are as follows:

  1. We need to right-click on SpatiaLite in the Browser panel and then click on Create Database.
  2. We browse to the folder where we want to create the database, give it a name (I named it Chapter3_test), and save it.
  3. We see an arrow to the left of SpatiaLite. Click on this arrow:
  1. We'll see the newly created database under SpatiaLite:
  1. Use the DB Manager plugin under Database to check...