Introduction
Functions returning geometries
Collections
Summary
16. Exercise 1

Instruction

Let's start with something easy.

Exercise

For each planning district, show its id, name and the centroid of that district in the internal PostGIS format.

Once you have the right query, you may want to take a look at the map to visually verify your results.

Console

Code editor

Result

TableConsoleMap