Changes between Version 1 and Version 2 of CookBook join Corine Land Cover-RHT

Timestamp:

Sep 21, 2011 5:40:34 PM (14 years ago)

Author:

celine

Comment:

--

CookBook join Corine Land Cover-RHT

@@ -5 +5 @@
 
 A layer is available from Hervé #81
+
+'''Version 2000'''.
+ - pour chaque identifiant RHT (id_drain), la surface unitaire (catchment_area en m²) et la surface pour chacune des 44 classes de Corine land Cover.  à  voir fichiers _clc
+ - pour chaque identifiant RHT (id_drain), la surface amont (m²) et la surface pour chacune des 44 classes de Corine Land Cover à voir fichiers _clcacc  (attention dans ces fichiers il manque les deux premiers noms de colonnes).
+
+Import data ag_clc.txt from access into Postgre.
+
+{{{
+create schema clc2000;
+alter table ag_clc set schema clc2000;
+
+
+create schema clc2000;
+alter table ag_clc set schema clc2000;
+ALTER TABLE clc.ag_clc RENAME COLUMN "Reach Number" TO 
+ALTER TABLE clc.ag_clc RENAME COLUMN "Catchment_area(m2)" TO 
+ALTER TABLE clc.ag_clc RENAME COLUMN "111" TO art_111
+ALTER TABLE clc.ag_clc RENAME COLUMN "112" TO art_112
+ALTER TABLE clc.ag_clc RENAME COLUMN "121" TO art_121
+ALTER TABLE clc.ag_clc RENAME COLUMN "122" TO art_122
+ALTER TABLE clc.ag_clc RENAME COLUMN "123" TO art_123
+ALTER TABLE clc.ag_clc RENAME COLUMN "131" TO art_131
+ALTER TABLE clc.ag_clc RENAME COLUMN "132" TO art_132
+ALTER TABLE clc.ag_clc RENAME COLUMN "133" TO art_133
+ALTER TABLE clc.ag_clc RENAME COLUMN "141" TO art_141
+ALTER TABLE clc.ag_clc RENAME COLUMN "142" TO art_142
+ALTER TABLE clc.ag_clc RENAME COLUMN "211" TO arable_211
+ALTER TABLE clc.ag_clc RENAME COLUMN "212" TO arable_212
+ALTER TABLE clc.ag_clc RENAME COLUMN "213" TO arable_213
+ALTER TABLE clc.ag_clc RENAME COLUMN "221" TO permcrop_221
+ALTER TABLE clc.ag_clc RENAME COLUMN "222" TO permcrop_222
+ALTER TABLE clc.ag_clc RENAME COLUMN "223" TO permcrop_223
+ALTER TABLE clc.ag_clc RENAME COLUMN "231" TO pasture_231
+ALTER TABLE clc.ag_clc RENAME COLUMN "241" TO hetagr_242
+ALTER TABLE clc.ag_clc RENAME COLUMN "242" TO hetagr_243
+ALTER TABLE clc.ag_clc RENAME COLUMN "244" TO hetagr_244
+ALTER TABLE clc.ag_clc RENAME COLUMN "311" TO forest_311
+ALTER TABLE clc.ag_clc RENAME COLUMN "312" TO forest_312
+ALTER TABLE clc.ag_clc RENAME COLUMN "313" TO forest_313
+ALTER TABLE clc.ag_clc RENAME COLUMN "321" TO natural_321
+ALTER TABLE clc.ag_clc RENAME COLUMN "322" TO natural_322
+ALTER TABLE clc.ag_clc RENAME COLUMN "323" TO natural_323
+ALTER TABLE clc.ag_clc RENAME COLUMN "324" TO natural_324
+ALTER TABLE clc.ag_clc RENAME COLUMN "331" TO natural_331
+ALTER TABLE clc.ag_clc RENAME COLUMN "332" TO natural_332
+ALTER TABLE clc.ag_clc RENAME COLUMN "333" TO natural_333
+ALTER TABLE clc.ag_clc RENAME COLUMN "334" TO natural_334
+ALTER TABLE clc.ag_clc RENAME COLUMN "335" TO natural_335
+ALTER TABLE clc.ag_clc RENAME COLUMN "411" TO wetlands_411
+ALTER TABLE clc.ag_clc RENAME COLUMN "412" TO wetlands_412
+ALTER TABLE clc.ag_clc RENAME COLUMN "421" TO wetlands_421
+ALTER TABLE clc.ag_clc RENAME COLUMN "422" TO wetlands_422
+ALTER TABLE clc.ag_clc RENAME COLUMN "423" TO wetlands_423
+ALTER TABLE clc.ag_clc RENAME COLUMN "511" TO inwat_511
+ALTER TABLE clc.ag_clc RENAME COLUMN "512" TO inwat_512
+ALTER TABLE clc.ag_clc RENAME COLUMN "521" TO marwat_521
+ALTER TABLE clc.ag_clc RENAME COLUMN "522" TO marwat_522
+ALTER TABLE clc.ag_clc RENAME COLUMN "523" TO marwat_523
+
+--- le copy ne fonctionne pas, problème dans le fichier
+
+create schema clc2000;
+drop table if exists clc2000.area_clc;
+CREATE TABLE clc2000.area_clc
+(
+  Reach_Number integer,
+  Catchment_area double precision,
+  art_111 double precision,
+  art_112 double precision,
+  art_121 double precision,
+  art_122 double precision,
+  art_123 double precision,
+  art_124 double precision,
+  art_131 double precision,
+  art_132 double precision,
+  art_133 double precision,
+  art_141 double precision,
+  art_142 double precision,
+  arable_211 double precision,
+  arable_212 double precision,
+  arable_213 double precision,
+  permcrop_221 double precision,
+  permcrop_222 double precision,
+  permcrop_223 double precision,
+  pasture_231 double precision,
+  hetagr_241 double precision,
+  hetagr_242 double precision,
+  hetagr_243 double precision,
+  hetagr_244 double precision,
+  forest_311 double precision,
+  forest_312 double precision,
+  forest_313 double precision,
+  natural_321 double precision,
+  natural_322 double precision,
+  natural_323 double precision,
+  natural_324 double precision,
+  natural_331 double precision,
+  natural_332 double precision,
+  natural_333 double precision,
+  natural_334 double precision,
+  natural_335 double precision,
+  wetlands_411 double precision,
+  wetlands_412 double precision,
+  wetlands_421 double precision,
+  wetlands_422 double precision,
+  wetlands_423 double precision,
+  inwat_511 double precision,
+  inwat_512 double precision,
+  marwat_521 double precision,
+  marwat_522 double precision,
+  marwat_523 double precision
+);
+copy clc2000.area_clc from 'D:/CelineJouanin/RHT_Estimkart/clc/ag_clc.csv' with csv delimiter as ';' header; 
+}}}