[postgis-users] Re: SRID for USA_Lambert_Conformal_Conic

[P Kishor]

Well, I went ahead and inserted the following definition in my
spatial_ref_sys table. Now I want to update my existing geometries to
this new srs. Before I go ahead and clobber a few hundred thousand
records beyond recognition, I just wanted to confirm how to do this.
Do I

UPDATE table SET the_geom = Transform(the_geom, 102005)

or is there some other magic I have to do?

..
>
> # USA_Contiguous_Equidistant_Conic
> <102005> +proj=eqdc +lat_0=0.000000000 +lon_0=0.000000000
> +lat_1=33.000000000 +lat_2=45.000000000 +x_0=0.000 +y_0=0.000
> +ellps=GRS80 +datum=NAD83 +units=m
>
> Am I to assume the following for the above --
>
> srid: 102005 (is that what is inside the angle brackets)?
>
> auth_name: 'ESRI'
>
> auth_srid: 102005 (in the spatial_ref_sys table, srid seems to be the
> same as auth_srid.
>
> proj4text: +proj=eqdc +lat_0=0.000000000 +lon_0=0.000000000
> +lat_1=33.000000000 +lat_2=45.000000000 +x_0=0.000 +y_0=0.000
> +ellps=GRS80 +datum=NAD83 +units=m
>
> srtext: all the "PROJCS[..." nonsense I already have.
> >

-- 
Puneet Kishor http://punkish.eidesis.org/
Nelson Inst. for Env. Studies, UW-Madison http://www.ies.wisc.edu/
Open Source Geospatial Foundation https://edu.osgeo.org/