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
Points
Polygons
32. Exercise 2
Summary

Instruction

Let's do one more exercise.

Exercise

Find the average area for each district type in San Francisco. Show the type of district in the first column and the average area in the second column. Your results should be in square meters.

Stuck? Here's a hint!

Use a GROUP BY clause to get the averages for each type of district. Use the right SRID (26910).