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
Practice
17. Exercise 16
Summary

Instruction

Finally! Here's the last exercise.

Exercise

Mark's trip was a success. However, it's been a long day, and he would now like to return to his apartment in the Mission district. Find all bicycle routes that link the Buena Vista and Mission districts.

Show the course column only.

Stuck? Here's a hint!

This is a tricky one! To retrieve only these routes that intersect with both of these districts you'll have to join the sf_bicycle_routes and sf_planning_districts...twice!

First you check whether a given route intersects with the Mission district, and then check whether a given route also intersects with the Buena Vista district.