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
Spatial SQL
12
Assessment