Changes between Version 3 and Version 4 of CookBook EpA

Timestamp:

Mar 30, 2010 2:03:54 PM (15 years ago)

Author:

cedric

Comment:

--

CookBook EpA

@@ -6 +6 @@
 {{{
 CD C:\Documents and Settings\cedric\Mes documents\Migrateur\eda\peche_electrique_bretagne\Cédric_Stations IA ANG\Cédric_Stations IA ANG
-C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 2154 Sta_IA_ANG_Bret_L93_CB ia.iabret > ia.sql
+C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 2154 -W LATIN1 Sta_IA_ANG_Bret_L93_CB ia.iabret > ia.sql
 }}}
 using psql to load the file
 {{{
+C:\"Program Files"\PostgreSQL\8.4\bin\psql -d ccm21_eda -h localhost -U postgres -p 5433 -c "CREATE SCHEMA ia;"
 C:\"Program Files"\PostgreSQL\8.4\bin\psql -d ccm21_eda -h localhost -U postgres -p 5433 -f ia.sql 
 }}}
+We have to reproject our data
+{{{
+select SRID (the_geom) FROM ia.iabret--2154
+}}}
+
+{{{
+ALTER TABLE ia.iabret DROP CONSTRAINT enforce_srid_the_geom;
+UPDATE ia.iabret set the_geom=ST_Transform(the_geom,3035) ;
+ALTER TABLE ia.iabret ADD CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);
+}}}
+{{{
+select SRID (the_geom) FROM ia.iabret--3035
+}}}
+