Section 2: SQL for Spatial Analytics

In Part 2, readers will learn about spatial data types and how to abstract and encapsulate spatial structures such as boundaries and dimensions. Finally, large datasets are then enabled for local analyses. Open source GIS, combined with plugins that expand QGIS functionality, have made QGIS an important tool for analyzing spatial information.

This section has the following chapters:

• Chapter 5, Using SQL Functions – Spatial and Non-Spatial
• Chapter 6, Building SQL Queries Visually in a Graphical Query Builder
• Chapter 7, Exploring PostGIS for Geographic Analysis
• Chapter 8, Integrating SQL with QGIS