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

[Paul Ramsey]

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

P

On Feb 16, 2008, at 8:12 PM, Webb Sprague wrote:

> Hi all,
>
> Is there a recipe somewhere on how to get from decimal lat/ long into
> a specific SRID?  I assume that I need to go from decimal to a
> geometry column in the appropriate SRID, and from that into a new
> projection with transform?
>
> (42.9, -122.1) -> some geometry -> geometry w/ SRID=2992?
>
> I have no clue, I am embarrassed to confess
>
> Please help!
>
> -W
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users