[postgis-users] UTM/Datum SAD 69 to UTM/Datum WGS84???

[strk at refractions.net]

On Wed, Jul 06, 2005 at 01:40:46AM +0200, Nicolas Ribot wrote:
> > Hi Nicolas.
> >  Thank you.
> >  Very good.
> >  My problem now is that I am receiving the following message:
> >  SELECT Transform(the_geom,32723) FROM tb_my;
> >  ERROR:  Input geometry has unknown (-1) SRID
> >  Observing the table geometry_columns, the field srid=-1
> >  Help me.
> > 
> >  
> 
> (hmm, my answer will look exactly like the one I sent to Mark on June, 29th...)
> 
> So, geometries in your table tb_my have no SRID (-1).
> You have to explicity set an SRID for these data:
> 
> First change the SRID in the postgis metadata
> (geometry_columns table):
> 
> select updateGeometrySRID('tb_my', 'the_geom', <source_srid>);

This is enough, the setSRID() call below is not needed.
--strk;

> 
> Second, use setSRID() to change internal geometries' SRID in the
> geometric table:
> 
> select setSRID(the_geom, <source_srid>) from tb_my.
> 
> Then you should be able to reproject data from tb_my to another
> spatial reference system using transform(...).
> 
> Nicolas
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users