Introduction
Points
Linestrings
Polygons
25. Getting to know the table sf_planning_districts
Summary

Instruction

Great, let's move on. We are about to introduce the last subtype of geometry. First, however, you'll get to know the some new tables.

Exercise

Select all the information from the table sf_planning_districts.

Each planning district has:

  • a unique identifier (id),
  • a name (name),
  • the polygon that defines it (boundaries),
  • a type (type): recreational, residential or commercial.

Take a look at the MAP tab. Do you see anything different? Instead of points or linestrings, there are now a few colored areas on the map. If you hover your mouse over a given colored area, you can actually see the name of a district!

Stuck? Here's a hint!

Use the SELECT * FROM ... expression.

Console

Code editor

Result

TableConsoleMap