• Spatial SQL
  • Overview
    • 0.1 Workshop Description
      • 0.1.1 Learning Objectives
      • 0.1.2 Prerequisites
  • 1 Concepts
    • 1.1 What is a relational database?
    • 1.2 What is a Spatial Database?
    • 1.3 What is Spatial SQL?
    • 1.4 Why should you learn to work with spatial databases and spatial SQL?
    • 1.5 What makes this challenging?
    • 1.6 Databases that support Spatial SQL:
  • 2 Data
  • 3 Creating a Database
    • 3.1 Start QGIS
    • 3.2 Starting the DB Manager Plugin
    • 3.3 Make a Database
  • 4 Load Data
  • 5 SQL Window
  • 6 Review Non-spatial Queries
    • 6.1 Let’s look at the whole table:
    • 6.2 Add a WHERE clause:
    • 6.3 Add a function:
    • 6.4 Summarize Data
  • 7 Spatial Queries
    • 7.1 Basic Spatial Query Examples:
      • 7.1.1 View Geometry
      • 7.1.2 Length
      • 7.1.3 Area
    • 7.2 Projections:
      • 7.2.1 Set the Projection
      • 7.2.2 Reproject
    • 7.3 Spatial Join
  • 8 Viewing a Query to QGIS
  • 9 Spatial Analysis
    • 9.0.1 Distance
    • 9.0.2 Buffer & Nesting Functions
  • 10 Conclusion
  • 11 Additional Resources:
    • 11.1 More about Databases with DataLab
    • 11.2 General SQL Resources:
    • 11.3 Spatial SQL Resources:
    • 11.4 General Slides & Tutorials:
  • 12 Assessment
  • CC BY-SA 4.0

Spatial SQL

11 Additional Resources:

11.1 More about Databases with DataLab

Introduction to Databases and Data Storage Technologies

Intro to SQL for Querying Databases

11.2 General SQL Resources:

W3 Schools’ SQL Reference

11.3 Spatial SQL Resources:

QGIS Training Manual on DB Manager

SpatiaLite Function Reference List

SpatiaLite Cookbook

11.4 General Slides & Tutorials:

Todd Barr’s Slides

Mike Miller’s Spatialite Tutorial