Changes between Version 52 and Version 53 of CookBook join BDMAP_CCM

Timestamp:

Mar 1, 2010 1:41:24 PM (15 years ago)

Author:

cedric

Comment:

--

CookBook join BDMAP_CCM

@@ -38 +38 @@
 }}}
   * we use shp2pgsql to create sql file, see also  ["CookBook shptopostgres"] for more details and links on the procedure. Gdal does not work as easily so just stick to this recipe.
-{{{
-C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 27572 bdmapv2_vf2 stationsp > stationsp.sql
-}}}
-  * We have to convert it into utf8 (as the database is posgis), in notepad, open the stationsp.sql file and convert it to utf8[[BR]]
-If you don't have notepad, download it at http://sourceforge.net/projects/notepad-plus/files/notepad%2B%2B%20releases%20binary/
-{{{
-Encodage>convertir en utf8
-}}}
-And save the file as : stationsputf8
-  * then we use psql to restore the file while connecting to BDMAP ... change the port if necessary (celine : 5432)
   '' notes ''
   * use SRID 27572 if you want to keep Posgis informed of the projection you are in, basically it creates and populates the geometry tables with the specified SRID. [[BR]]
     so if you want to use the srid 27572 put : 
+{{{
+C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 27572 bdmapv2_vf2 stationsp > stationsp.sql
+}}}
+  * We have to convert it into utf8 (as the database is posgis), in notepad, open the stationsp.sql file and convert it to utf8[[BR]]
+If you don't have notepad, download it at http://sourceforge.net/projects/notepad-plus/files/notepad%2B%2B%20releases%20binary/
+{{{
+Encodage>convertir en utf8
+}}}
+And save the file as : stationsputf8
+  * then we use psql to restore the file while connecting to BDMAP ... change the port if necessary (celine : 5432)
 {{{
 C:\"Program Files"\PostgreSQL\8.4\bin\psql -d BDMAP -h localhost -U postgres -p 5433 -s 27572 -f stationsputf8.sql