Changes between Version 7 and Version 8 of CookBook pgsql2shp

Timestamp:

Jun 18, 2010 9:15:59 AM (15 years ago)

Author:

cedric

Comment:

--

CookBook pgsql2shp

@@ -60 +60 @@
 C:\"Program Files"\PostgreSQL\8.4\bin\pgsql2shp -f "C:\Documents and Settings\cedric\Mes documents\Migrateur\eda\exports_shape\surf_area_final" -p 5433 -u postgres -P postgres -g the_geom -r -k eda2.0 select clc.surf_area_final
 }}}
+== percentage urban ==
+{{{
+select r.gid, c.gid as c_gid, art_11_13/catchment_area as psurf, c.the_geom 
+from ccm21.riversegments r
+join ccm21.catchments c on c.wso1_id=r.wso1_id
+where r.wso_id in (select wso_id from france.wso where area='France');
+}}}