People who want to learn how to utilize the power of SQL in working with spatial data. Previous GIS and SQL experience is recommended but not required.
Introductory course to using Structured Query Language (SQL) for working with spatial data. By the end of the training, you should be familiar with performing common spatial analysis processes with SQL in SpatiaLite and QGIS. You should be able to explain relational database concepts, execute basic SQL commands, and perform spatial SQL queries like joins, interesects, among others.
Approximately 8 hours (1 day)
SQLite and SpatiaLite
Data Management in SQLite
Viewing Spatial Tables & Views in QGIS
QGIS DB Manager
This work and its contents by Ben Hur S. Pintor is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
Other works (software, source code, etc.) referenced in this website are under their own respective licenses.
This site is powered by Jekyll and hosted on Github (view source)