[postgis-users] Computing a centroid on GEOGRAPHY objects

[Michal Zimmermann]

You can try to cast geography to geometry with
ST_Centroid(geography_column::geometry).

On 12/6/12, Ed Linde <edolinde at gmail.com> wrote:
> Hi All,
> I have a huge bunch of scattered lat/long coordinates stored as GEOGRAPHY
> type. I would now like to cluster some of them and
> compute their centroids.
> I know there is a centroid computation function in Postgis, but it seems to
> only work on a geometry type.
> The lat/long coordinates are spread all across the globe and hence I cannot
> convert it to local UTM formats because there is a discrepancy when going
> across different zones!
> Any workarounds?
>
> Thanks,
> Ed
>


-- 
Michal Zimmermann (zimmi)
WWW: http://www.zimmi.cz