[postgis-users] Unit for length(geometry) function

Michael Fuhr mike at fuhr.org
Fri Aug 25 22:14:25 PDT 2006

On Sat, Aug 26, 2006 at 11:06:17AM +0800, leewse at stee.stengg.com wrote:
> > On Fri, Aug 25, 2006 at 05:37:54PM +0800, Lee Wai See wrote:
> >> I would like to know what the unit returned by the length(geometry)
> >> function is. Thanks in advance.
> >
> > Same units as the input geometry.
> How can I find out the unit for the input geometry? Is there any way or
> function for doing that? Thanks.

You could use srid() to get the geometry's SRID and then look up
that SRID in spatial_ref_sys.

Michael Fuhr

More information about the postgis-users mailing list