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


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.


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.