[postgis-users] Geography type: centroids and distance?

fork forkandwait at gmail.com
Fri Mar 11 22:28:53 PST 2011

I have successfully loaded all the PUMA geographies in the US, and would like to
calculate their distance matrix.  Since st_distance on a polygon of these sizes
is sort of a nightmare, I thought I would calculate the centroid and then get
the distances between those.  However, st_centroid(geography, geography) is not

So, is there a better way?  Should I reproject to 4326 and use
st_distance_sphere?  Or ???

Thanks to all the folks that have made such a cool thing as PostGIS happen!

More information about the postgis-users mailing list