Changes between Version 48 and Version 49 of CookBook join BDMAP_CCM

Timestamp:

Mar 1, 2010 1:26:16 PM (15 years ago)

Author:

cedric

Comment:

--

CookBook join BDMAP_CCM

@@ -154 +154 @@
 C:\base>C:\"Program Files"\PostgreSQL\8.4\bin\psql -d CCM_EDA -p 5433 -U postgres -f stationsp2.sql
 }}}
- At this point if you have followed the instruction, you will be in the wrong projection if you want to display both the station and stationsp2 layer, you can change this :
+Don't forget to change the port into 5432 (celine)
+[[BR]] 
+At this point if you have followed the instruction, you will be in the wrong projection if you want to display both the station and stationsp2 layer, you can change this :
 {{{
 update stationsp2 set the_geom=ST_Transform(the_geom, 3035) ;
 }}}
-[[BR]] Don't forget to change the port into 5432 (celine)
 
  6. Joining the riversegments layer with the stationsp2 layer
 
-  * first create two index to speed up queries [[BR]]
+  
+ * first create two index to speed up queries [[BR]]
 riversegments comes from the CCM_EDA database, so put the sql code in the sql consol : CCM_EDA sur postgres@localhost