Changes between Version 103 and Version 104 of CookBook join BDMAP_CCM

Timestamp:

Sep 1, 2010 3:19:04 PM (15 years ago)

Author:

cedric

Comment:

--

CookBook join BDMAP_CCM

@@ -7 +7 @@
 {{{
 SELECT AddGeometryColumn('bdmap', 'station','the_geom', 27572,'POINT',2) 
-UPDATE bdmap SET the_geom=PointFromText('POINT(' || st_abcisse || ' ' || st_ordonnee || ')',27572);
+UPDATE bdmap.station SET the_geom=PointFromText('POINT(' || st_abcisse || ' ' || st_ordonnee || ')',27572);
 ALTER TABLE bdmap.station ADD CONSTRAINT geometry_valid_check CHECK (isvalid(the_geom)); 
 SELECT ST_Transform(the_geom,3035) FROM bdmap.station;