Changes between Version 127 and Version 128 of CookBook join BDMAP_CCM

Timestamp:

May 25, 2012 1:38:13 PM (13 years ago)

Author:

celine

Comment:

--

CookBook join BDMAP_CCM

@@ -6 +6 @@
 == 1. Load the BDMAP database, it will be saved by Laurent using a Talend work ==
 {{{
+#!sql
 SELECT AddGeometryColumn('bdmap', 'station','the_geom', 27572,'POINT',2) 
 UPDATE bdmap.station SET the_geom=PointFromText('POINT(' || st_abcisse || ' ' || st_ordonnee || ')',27572);
@@ -97 +98 @@
 We could also have used (instead of -s in shp2psql)
 {{{
+#!sql
 update station set ST_SetSRID(the_geom, 27252); REM 27572
 }}}