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
26. Getting to know the table sf_hotels
Summary

Instruction

Now, let's get to know the other table.

Exercise

Select all the information from the table sf_hotels.

Each hotel has:

  • a unique identifier (id),
  • a name (name),
  • the polygon that defines it (boundaries),
  • a rating on a scale from 1 to 5,
  • the average price for a double room (double_avg_room).

Also, take a look at the MAP tab. If you zoom in close enough, you will see that each hotel is presented on the map not as a point but rather as a some kind of shape. What's this all about?

Stuck? Here's a hint!

Use the SELECT * FROM ... expression.