Returns the mathematical centroid of an ST_Polygon or ST_MultiPolygon value.
Returns an ST_Point value.
ST_Polygon or ST_MultiPolygon.
Note: This method can be called on 3D geometries (those that include z coordinates). However, the z coordinate is dropped, and only x and y coordinates are returned.
SELECT cityName, cityShape.ST_Centroid()