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

Michael Fuhr mike at fuhr.org
Sun Feb 17 15:58:13 PST 2008

On Sun, Feb 17, 2008 at 03:08:47PM -0800, Webb Sprague wrote:
> > select astext(transform(setsrid(makepoint(lon,lat),4326),2922));
> Is 4326 the default SRID for longitude, latitude always?

There is no default -- you need to specify an SRID that's appropriate for
the data.  4326 is common; in North America 4267 is another possibility.

Michael Fuhr

More information about the postgis-users mailing list