Introduction
1. Introduction
ST_Equals
Relationships Between Geometries
ST_Distance and ST_Dwithin
Spatial joins practice
Summary

Instruction

Welcome back! In the previous part of our course, you learned about the basic geometries of points, linestrings and polygons. You also learned how to check their basic features, such as X and Y coordinates perimeter, and area. In this part of our course, we'll compare various geometric objects from the same table. With the concepts you learn here, you'll be able to determine which districts neighbor each other, how many ATMs can be found in a certain vicinity, and much more. To that end, we'll get to know some new spatial functions. As usual, the knowledge you gain here has many real-world applications. Let's get started!

Exercise

Click the Next exercise to continue.

Console

Code editor

Result

TableConsole