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
14. Exercise 13
Summary

Instruction

That's right! A few more exercises, and then we're done!

Exercise

How many tram stops can be found within 1000 meters of each hotel in San Francisco? Show the hotel name and the number of trams in the vicinity. Order the results by count in descending order.

Stuck? Here's a hint!

Use a spatial join with ST_DWithin. Remember to use ST_Transform with an SRID of 26910.