Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
25. Getting to know the table sf_planning_districts


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.


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.