RES: [postgis-users] changing SRID?

[Gustavo Henrique Sberze Ribas]

Hallo,

  If the SRID 31497 from 0.8 is equivalent to SRID 31467 in 1.0
then you could just replace the old SRID in the dump file with 
the new one. 
 
  If it's a new system, you could restore your data to a 
temporary table and use something like 

   INSERT INTO new_table(id,...,geom)  
     SELECT 
        id,
        ...,
        transform(geom,31467)
     FROM temp_table;

   
Gruß,
Gustavo 


> -----Mensagem original-----
> De: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net]Em nome de Achim
> Weßling
> Enviada em: terça-feira, 28 de junho de 2005 10:42
> Para: PostGIS Users Discussion
> Assunto: [postgis-users] changing SRID?
> 
> 
> Hallo,
> 
> I have one older postgis install with version 0.8 (Postgre 7.4) and a
> newer one with version 1.0 (Postgre 8.0).
> 
> Under postgis 0.8 I used SRID 31497, on postgis 1.0 I use SRID 31467. 
> 
> Now I have to migrate the data from the older installation to 
> the newer
> one. Can someone give any hints? Espacially for the migration of the
> SRID?
> 
> Thanks!
> 
> -- 
> 
> Achim Weßling
> ===========================================
> INFOKOM Gütersloh AöR
> Fachbereich II - Technische Anwendungen
> Herzebrocker Str. 140
> 33334 Gütersloh
> Tel.: 05241/85-2926
> Achim.Wessling at gt-net.de
> http://www.infokom-gt.de
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>