Book Image

Learning the FOSS4G Stack: Spatial SQL with Postgres/PostGIS [Video]

By : Arthur Lembo
4 (1)
Book Image

Learning the FOSS4G Stack: Spatial SQL with Postgres/PostGIS [Video]

4 (1)
By: Arthur Lembo

Overview of this book

<p>This course is part of an entire curriculum based on free and open source GIS (FOSS4g) software. The curriculum is grouped into different categories of the FOSS4g stack - Desktop, Server, and Developer. As part of this course, you will learn the most popular open source database - Postgres 11. </p><p>You’ll start with the basics of Postgres, explore PostGIS as a spatial plugin, and then go on to solve spatial problems using SQL. The course uses real data from Tompkins County, New York, and seamlessly integrates with other gisadvisor courses that will teach you QGIS, GDAL, GeoServer, and Python. You'll also explore the capabilities of SQL, working with raster, vector, and attribute data. After you’ve learned SQL and spatial SQL, you’ll understand how to simulate real-world examples of GIS projects and spatial analysis. </p><p>By the end of this course, you will be well-versed with the FOSS4g stack and be equipped with the skills you need for everything from conducting spatial analysis to solving spatial problems using SQL. </p><p>All the codes and supporting files for this course are available at: https://github.com/PacktPublishing/Learning-the-FOSS4g-Stack-Spatial-SQL-with-Postgres-PostGIS</p>

Related Content you might be interested in

Current Title:

Small book image
Learning the FOSS4G Stack: Spatial SQL with Postgres/PostGIS [Video]
Arthur Lembo
Mar, 2020 | 5 hours 0 minutes
No titles found
Table of Contents (7 chapters)
Free Chapter
1
Loading our Software and Data
Introduction
Installing Postgres 11
Installing QGIS 3.8
Our Data
Loading our data
Important!!! - Fixing the .qgs file if you cannot connect to Postgres
Setting up our system
2
Overview of SQL
The case for SQL
3
SQL Data Types
Numeric data types
Boolean and Character data types
Date and Time data types
Spatial data types
4
Traditional SQL
SELECT Statements (and their variants)
Aggregate and GROUP BY functions
Creating new data (UPDATE, INSERT, and DELETE functions)
Conditional statements with SQL: CASE
5
Spatial SQL
Coordinate Systems and SQL
Spatial (and non-spatial) indexes and SQL
Spatial Commands - part 1 (A-C)
Spatial Commands - part 2 (D-U)
6
Geographic Models with Spatial SQL
Basic Problems in Geography
Variogram modeling with SQL
The tools of spatial analysis: Distance, adjacency, and Interaction
7
Real World Applications with Spatial SQL
Creating functions with Postgres and PostGIS
Summarizing parcel data with a watershed and floodzone
Chapter 4
Traditional SQL
Content Locked
Section 4
Conditional statements with SQL: CASE
Oftentimes we'll want more control over the queries that we perform. In programming languages, this takes the form of if/then and while clauses. SQL has its own ability to evaluate conditions. In this lecture we'll explore the use of CASE statements in SQL. We'll look at basic CASE statements, CASE statements with spatial data, and CASE statements that span multiple tables.
Previous Section
End of Chapter 4
Next Chapter