back to first page ..
back to UGA

Data in RGF93_Lambert_93 srid=2154 --> transformed into ETRS 1989 LAEA srid=3035

--Celine
d:
cd D:\CelineJouanin\UGA2010_L93
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 2154 -I UGA2010_L93v2.shp uga > uga.sql

--Cedric
cd C:\Documents and Settings\cedric\Mes documents\Migrateur\eda\UGA2010_L93
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 2154 -I UGA2010_L93v2.shp uga > uga.sql

• We have to convert it into utf8 (as the database is posgis), in notepad, open the uga.sql file and convert it to utf8
  

  Encodage>convertir en utf8
  

And save the file as : ugautf8

--Céline
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5432 -f ugautf8.sql 
--Cédric
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f ugautf8.sql 

• Create schema uga2010 et changement de schéma de la table uga (qui est sous public)

  --- In sql editor 
  CREATE SCHEMA uga2010;
  ALTER TABLE uga SET SCHEMA uga2010;
  

• Changement du type de projection : RGF93_Lambert_93 (srid 2154) --> ETRS1989-LAEA (srid 3035) (Nouvelle projection sans doute avec la version v2 !!! Je regarde !)

ALTER TABLE uga2010.uga DROP CONSTRAINT enforce_srid_the_geom;
UPDATE uga2010.uga SET the_geom = ST_transform(the_geom, 3035); 
ALTER TABLE uga2010.uga ADD CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);