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
Quiz
5. Question 4
Congratulations

Instruction

Good. How about question number 4?

Exercise

For each district, show its:

  • name,
  • centroid as a geometry,
  • point on the surface as a geometry,
  • the distance (in meters) between its centroid and its point on surface.

Sort the results by the last column in descending order.

Note: in order to get the expected results, first transform the polygons to the proper SRID (26910), find the center points, and then calculate the distance between the centroid and point on the surface.