Changes between Version 101 and Version 102 of CookBook join BDMAP_CCM

Timestamp:

Sep 1, 2010 3:05:03 PM (15 years ago)

Author:

cedric

Comment:

--

CookBook join BDMAP_CCM

@@ -5 +5 @@
 
 == 1. Load the BDMAP database, it will be saved by Laurent using a Talend work ==
+{{{
+SELECT AddGeometryColumn('bdmap', 'station','the_geom', 27572,'POINT',2) 
+UPDATE bdmap 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;
+}}}
+
 == 2. Load the codier_csp table (it is also necessary for R treatments),the following code will create the table and copy it from the csv file (here located in base) ==
     I had to make a utf8 file