Introduction
ST_Equals
Relationships Between Geometries
ST_Distance and ST_Dwithin
Spatial joins practice
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.
