Changes between Version 1 and Version 2 of CookBook Eda

Timestamp:

Jan 22, 2010 3:26:37 PM (15 years ago)

Author:

cedric

Comment:

--

CookBook Eda

@@ -3 +3 @@
 In this section we will report "how to" procedures to do the differents tasks in EDA
 
-== How to create a postgres database from a shape file"
+== How to create a postgres database from a shape file" PostgresSQl 8.4 ==
 
-Il faut d'abord ouvrir un batch de commande exécuter> cmd
-Changer de répertoire de travail pour atteindre le fichier à importer
+The following example applies to the creation of a database from the CCM
+
+[http://www.bostongis.com/?content_name=postgis_tut01]
+is the usefull to read next if the following does not work
+
+=== 1- Install postgres and postgis ===
+(Use stack builder application in postgres command menu) 
+
+=== 2- create database CCM ===
+
+In PgAdmin, connect to the serveur
+ right clic, create new database, use template postgis to that the database is a geodatabase
+[[Image(source:EDA/data/Docs/trac/PgAmin_create_gis_database.jpg)]]
+
+=== 3- Figure out SRID of the data ===
+We'll need to match this descriptive projection to an SRID (the id field of a spatial ref record in the spatial_ref_sys table) if we ever want to reproject our data. 
+Open up your PgAdmin III query tool and type in the following statement, use the green arrow to launch the command
+ {{{
+select srid, srtext, proj4text from spatial_ref_sys where srtext ILIKE '%ETRS89%';
+}}}
+Now we have to find the good line, it seems to be srid='3035' since it refers to the Eu system and equal area
+=== 4- Create sql database === 
+Open a command batch > execute> cmd
+Change directory to get to the working directory where the shapes are stored
+example :
  {{{
 cd C:\Documents and Settings\cedric\Mes documents\Migrateur\eda\w2000a18
 }}}
-Dans PgAdmin, se connecter au serveur
-> clic droit creation d'une base de donnee 
-PgAmin_create_gis_database.jpg
-#* à partir du programme shp2pqsql création d'un fichier sql (ci dessous un exemple)
-C:\PostgresPlus\8.3\bin\shp2pgsql -? 
-C:\PostgresPlus\8.3\bin\shp2pgsql -s 26986 TOWNS_POLY towns > towns.sql
-C:\PostgresPlus\8.3\bin\shp2pgsql -s 3035 CATCHMENT_W catchment_w > catchment_w.sql
+The program shp2pqsql installed along postgris allows to transform from shape to .sql
+type in 
+ {{{
+C:\program files\postgres\8.4\bin\shp2pgsql -s 3035 COAST coast > coast.sql
+}}}
+The file will be created at ''C:\program files\postgres\8.4\bin\shp2pgsql''
+to create the coast.sql file from the COAST shape file
+warning these files are very big and won't open in pgAdmin, use the command batch to lauch the sql file
+{{{
+C:\program files\postgres\8.4\bin\psql -d CCM -h localhost -U postgres -f catchment_w.sql 
+}}}
+where: -d database -h host -U user -f the sql file.
+Check at the end of the process if the database is created
 
-
-C:\PostgresPlus\8.3\bin\psql -d CCM -h localhost -U postgres -f catchment_w.sql