English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 4h 40m | 1.14 GB
Learn Spatial SQL: The language for geographers
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.
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.
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.
Learn
- Understand how to conduct spatial analysis with Postgres 11 and PostGIS
- Create spatial functions with SQL
- Become well-versed with creating geographic models with SQL
Table of Contents
Loading our Software and Data
1 Introduction
2 Installing Postgres 11
3 Installing QGIS 3.8
4 Our Data
5 Loading our data
6 Important!!! – Fixing the .qgs file if you cannot connect to Postgres
7 Setting up our system
Overview of SQL
8 The case for SQL
SQL Data Types
9 Numeric data types
10 Boolean and Character data types
11 Date and Time data types
12 Spatial data types
Traditional SQL
13 SELECT Statements (and their variants)
14 Aggregate and GROUP BY functions
15 Creating new data (UPDATE, INSERT, and DELETE functions)
16 Conditional statements with SQL – CASE
Spatial SQL
17 Coordinate Systems and SQL
18 Spatial (and non-spatial) indexes and SQL
19 Spatial Commands – part 1 (A-C)
20 Spatial Commands – part 2 (D-U)
Geographic Models with Spatial SQL
21 Basic Problems in Geography
22 Variogram modeling with SQL
23 The tools of spatial analysis – Distance, adjacency, and Interaction
Real World Applications with Spatial SQL
24 Creating functions with Postgres and PostGIS
25 Summarizing parcel data with a watershed and floodzone
Resolve the captcha to access the links!