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
12. Exercise 11
Summary

Instruction

Precisely so. Looks like you really know what you're doing.

Exercise

What are the average lengths among the bicycle routes that start in each district? Show each district's name alongside the average length in kilometers.

Stuck? Here's a hint!

You'll have to use AVG() with ST_Length and ST_Transform. Use an SRID of 26910 for San Francisco. Divide by 1000 to get kilometers. In order to get the highest precision for your final answer, first calculate the average in meters, and only then divide it by 1000.