Changes between Version 4 and Version 5 of CookBook join Corine Land Cover-RHT

Timestamp:

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

Author:

celine

Comment:

--

CookBook join Corine Land Cover-RHT

@@ -164 +164 @@
 USING btree (reach_number);
 }}}
+
+{{{
+#!sql
+SELECT AddGeometryColumn ( 'clc2000','area_clc','the_geom',3035,'MULTILINESTRING',2);
+update clc2000.area_clc set the_geom=rhtvs2.the_geom from rht.rhtvs2
+ where rhtvs2.id_drain=area_clc.reach_number; 
+
+SELECT AddGeometryColumn ( 'clc2000','uparea_clc','the_geom',3035,'MULTILINESTRING',2);
+update clc2000.uparea_clc set the_geom=rhtvs2.the_geom from rht.rhtvs2
+ where rhtvs2.id_drain=uparea_clc.reach_number; 
+}}}