[postgis-users] converting decimal lat/ long (GNIS) to Oregon Lambert (SRID 2992)

Michael Fuhr mike at fuhr.org
Sun Feb 17 01:07:09 PST 2008

On Sat, Feb 16, 2008 at 08:25:05PM -0800, Paul Ramsey wrote:
> select astext(transform(makepoint(lon,lat,4326),2922))

The 3-argument variant of makepoint() takes (x, y, z).  I think you

select astext(transform(setsrid(makepoint(lon,lat),4326),2922));

Michael Fuhr

More information about the postgis-users mailing list