Introduction
Practice
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.
