[postgis-users] Computing a centroid on GEOGRAPHY objects

Michal Zimmermann zimmicz at gmail.com
Thu Dec 6 12:40:34 PST 2012

You can try to cast geography to geometry with

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

More information about the postgis-users mailing list