[postgis-users] Re: SRID for USA_Lambert_Conformal_Conic

[P Kishor]

On 8/20/06, Dylan Beaudette <dylan.beaudette at gmail.com> wrote:
> you are almost there, see the SetSRID() function !!
>

Humour me. SetSRID(geometry, integer) and Transform(geometry, integer)
seem/sound almost the same. Is SetSRID more permanent, while Transform
is more for on the fly retreival of data? That said, what do I do
here? Do I

UPDATE my_table
SET the_geom = SetSRID(the_geom, 102005)

or do I

UPDATE geometry_columns
SET srid = 102005
WHERE f_table_name = 'my_table'

> 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 my_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
> >
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>


-- 
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/