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>
Table of Contents (7 chapters)
Chapter 1
Loading our Software and Data
Content Locked
Section 7
Setting up our system
One our data is in the database; we can start accessing it with different applications. For this class, we'll use QGIS to access the data. However, we could just as easily have used ArcGIS, ArcPro, Manifold GIS, MapInfo, or a whole host of other products. So, for this lecture we'll connect QGIS to our database and start visualizing the data.