Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

PostGIS

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.