Learning the FOSS4G Stack: Spatial SQL with Postgres/PostGIS

您将从 Postgres 的基础开始，探索作为空间插件的 PostGIS，然后继续使用 SQL 解决空间问题。该课程使用来自纽约汤普金斯县的真实数据，并与其他 gisadvisor 课程无缝集成，这些课程将教你 QGIS、GDAL、GeoServer 和 Python。您还将探索 SQL 的功能，处理栅格、矢量和属性数据。学习 SQL 和空间 SQL 后，您将了解如何模拟 GIS 项目和空间分析的真实示例。

Video: .MP4, AVC, 1280×720, 15 fps | Audio: English, AAC, 44.1 KHz, 2 Ch | Duration: 4h 40m | 1.13 GB

Instructor: Arthur Lembo

Learn Spatial SQL: The language for geographers

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

About

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.

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

Features

Understand numeric data types
Get up to speed with creating new data (UPDATE, INSERT, and DELETE functions)
Delve into Boolean and Character data types