Changes between Version 8 and Version 9 of ROE download and load

Timestamp:

May 4, 2010 10:25:02 AM (15 years ago)

Author:

cedric

Comment:

--

ROE download and load

@@ -5 +5 @@
 == Download and load the ROE database ==
 
-You can download the ROE data and add it into Postgres with the geobs_sans_image_2010_01_08.backup (EDAData/dataEDAcommun/barrage/geobs_sans_image_2010_01_08.backup).
+latest file roe_2010_03_01.backup
 
-
-Add data into Postgres 
-
-[[Color(,red,A VERIFIER !)]]
 {{{
 REM================================================
@@ -34 +30 @@
 REM correspond au point 1 de http://62.160.92.241:8066/trac/wiki/CookBook%20shptopostgres
 C:\"Program Files"\PostgreSQL\8.4\bin\psql -p 5432 -U postgres -c "CREATE DATABASE ROE  WITH OWNER = postgres  template=postgis ENCODING = 'UTF8'  LC_COLLATE = 'French_France.1252'  LC_CTYPE = 'French_France.1252' CONNECTION LIMIT = -1;"
+REM il faut repasser la base en majuscule sinon la connec
 cd C:\Program Files\PostgreSQL\8.4\bin\pg_restore.exe --host localhost --port 5432 --username postgres --dbname "ROE" --verbose "C:\Celine Jouanin\workspace\EDAData\dataEDAcommun\barrage\geobs_sans_image_2010_01_08.backup"
 }}}
@@ -57 +54 @@
 pg_restore.exe --host localhost --port 5432 --username postgres --dbname "ROE2010" --verbose "D:\Celine Jouanin\ROE2010\roe_2010_03_01.backup"
 }}}
+{{{
+REM================================================
+REM Script pour Cédric (la connexion change - p 5433)
+REM================================================
+REM script pour cedric créé le 4 mai 2010
 
+C:\"Program Files"\PostgreSQL\8.4\bin\psql -p 5433 -U postgres -c "CREATE DATABASE "ROE  WITH OWNER = postgres  template=postgis ENCODING = 'UTF8'  LC_COLLATE = 'French_France.1252'  LC_CTYPE = 'French_France.1252' CONNECTION LIMIT = -1;"
+C:\"Program Files"\PostgreSQL\8.4\bin\psql -p 5433 -U postgres -c "COMMENT ON DATABASE ROE IS 'database 01/03/2010'" 
+C:\"Program Files"\PostgreSQL\8.4\bin\pg_restore.exe --host localhost --port 5433 --username postgres --dbname "ROE" --verbose "C:\Documents and Settings\cedric\Mes documents\Migrateur\eda\Barrages\roe_2010_03_01.backup"
+}}}
 A new table has been added in this new database in public : departements_www with two projections : WGS84 et l2e (Lambert II étendu).
 New obstacles have been added in Corse, in the South, Charente, Meurthe et Moselle...