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

More Information
  • 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

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

  • Understand numeric data types
  • Get up to speed with creating new data (UPDATE, INSERT, and DELETE functions)
  • Delve into Boolean and Character data types
Course Length 4 hours 40 minutes
ISBN 9781800203877
Date Of Publication 31 Mar 2020


Arthur Lembo

Arthur Lembo is an educator with a passion for GIS and almost 30 years of GIS industry experience. He has won numerous teaching awards, including the prestigious New York State Chancellors award for Excellence in Teaching (2006), and the Maryland Board of Regents Teaching Award (2018) - both of these awards are the highest awards in academia for both States. Currently, Dr. Lembo is a Professor in the Department of Geography and Geosciences at Salisbury University, where he is also the Technical Director of the Eastern Shore Regional GIS Cooperative. Dr. Lembo has published numerous academic papers on GIS, authored a leading textbook on Statistical Problem Solving in Geography, and conducted sponsored research for organizations like the National Science Foundation, NASA, the United States Department of Agriculture, and the Kellogg Foundation.