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

[Carlos Gonçalves]

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.


On 7/4/05, Nicolas Ribot <nicky666 at gmail.com> wrote:
> 
> > Hi all.
> > As it is that I make in the POSTGIS, to change a projection UTM and 
> Datum
> > SAD 69. Zone 23 (south -), for the projection UTM and Datum WGS84?
> >
> > Help me.
> > Thank you.
> >
> 
> Hello Carlos.
> First identify the SRID corresponding to the target projection (UTM 23
> on Datum WGS84) (32723 for me for postgis 1.0, but check your SRID).
> Then, use the transform() function to reproject your data in the new
> Spatial Reference System:
> 
> select transform(geometry, target_srid) from your_table;
> 
> Nicolas
> 



-- 
-------------------------------------------------------------------------------
Carlos F. Gonçalves
"E não há salvação em nenhum outro; porque abaixo do céu não existe nenhum 
outro nome, dado entre os homens, pelo qual importa que sejamos salvos"(Atos 
4:12)
JESUS CRISTO

Center for Metropolitan Studies (Centro de Estudos da Metropole).

Know the Metropolitan Region of São Paulo (Conheça a Região Metropolitana
de São Paulo).
http://www.mapas.centrodametropole.org.br/servidormapas/html/index.html

For the good operation of this application, it is necessary to have
installed in yours computer the plug-in Adobe SVG Viewer (Para o bom
funcionamento deste aplicativo, é necessário ter instalado em seu
computador o plug-in Adobe SVG Viewer).

Português:
http://download.adobe.com/pub/adobe/magic/svgviewer/win/3.x/3.02/pt/SVGView.exe

http://www.adobe.com/svg/viewer/install/main.html
-------------------------------------------------------------------------------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20050705/f4bf8d90/attachment.html>