[postgis-users] Re: SRID for USA_Lambert_Conformal_Conic

[Dylan Beaudette]

you are almost there, see the SetSRID() function !!


Dylan

On 8/19/06, P Kishor <punkish at eidesis.org> wrote:
> 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/
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>