Save up to $499! Grab all Python courses for $49 or all online courses we’ve ever launched for only $169. Only Feb 11-16. Happy Valentine's!
16. Exercise 15


You're almost at the finish line now. Don't give up!


Mark analyzes the bicycle routes in the Buena Vista district and prepares a plan for his next bicycle trip.

Show the id and course columns for each bicycle route that intersects with Buena Vista alongside the following columns related to the midpoint of each route (which must lie on the given route): latitude, longitude and coordinates as a geometry column. Order the results by midpoint longitude in ascending order. Analyze the results on the map.

Stuck? Here's a hint!

Use ST_PointOnSurface. To get the longitude of a point, use ST_X. To get the latitude, use ST_Y. Use a spatial join with ST_Intersects.