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
Relationships Between Geometries
13. Additional exercise 2
ST_Distance and ST_Dwithin
Spatial joins practice
Summary

Instruction

Perfect! Let's do one more exercise of this kind.

Exercise

Find all restaurants in every district adjacent to the 'Golden Gate Park' district. Show name and coordinates from the sf_restaurants table.

Stuck? Here's a hint!

First, you have to join the table with itself and use the ST_Touches function to find all adjacent districts. Then you must join the sf_restaurants table and use the ST_Within or ST_Contains function to find all the restaurants that are inside these districts.