Save up to $499! Grab all Python courses for $49 or all online courses we’ve ever launched for only $169. Only Feb 11-16. Happy Valentine's!
Introduction
Points
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.