Changes between Version 38 and Version 39 of CLC Join

Timestamp:

Jun 1, 2010 12:27:32 PM (15 years ago)

Author:

cedric

Comment:

--

CLC Join

@@ -95 +95 @@
 UPDATE clc.clipped_bretagne1 set area=ST_Area(the_geom); -- 9s
 }}}
+
+
+So now we have a dataset looking like the following one
+{{{
+#!sql
+SELECT gid,code_00, id,round(area) as area FROM clc.clipped_Bretagne1 order by gid, code_00 limit 10;
+}}}
+||225124||"211"||7598;9331309||
+||225124||"231"||7093;2890840||
+||225124||;"242"||10662;2825609||
+||225124||"243"||6489;1462960||
+||225124||"311"||4595;1081844||
+||225124||"313"||198;427439||
+||225133||"112"||7295;1413001||
+||225133||"211"||9950;1273065||
+||225133||"231"||1022;751347||
+||225133||"242"||6079;720638||