[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: RES: [postgis-users] changing SRID?
From: "Gustavo Henrique Sberze Ribas" <gribas () cpqd ! com ! br>
Date: 2005-06-28 13:08:29
Message-ID: E6F2049DCBE10840B22DC64587E6F3EC0DAF04 () MAILSRV1 ! aquarius ! cpqd ! com ! br
[Download RAW message or body]
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@postgis.refractions.net
> [mailto:postgis-users-bounces@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@gt-net.de
> http://www.infokom-gt.de
>
> _______________________________________________
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic