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
ST_Equals
2. Get to know sf_restaurants
Relationships Between Geometries
ST_Distance and ST_Dwithin
Spatial joins practice
Summary

Instruction

Before we begin, there's one more table we'd like you to know: sf_restaurants. Let's take a look at this table now.

Exercise

Select all information from the sf_restaurants table.

As you can see, this table has the following 7 columns:

  • id — the id of a given restaurant,
  • name — the name of a given restaurant,
  • food_type — the type of food served at a given restaurant,
  • smoking_area — denotes whether there is an area for smokers in a given restaurant,
  • rating — the rating of a given restaurant,
  • avg_price — the average price that a customer pays per visit,
  • coordinates — a geometry column with location of a given restaurant.