Changes between Version 9 and Version 10 of CookBook pgsql2shp

Timestamp:

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

Author:

cedric

Comment:

--

CookBook pgsql2shp

@@ -62 +62 @@
 == percentage urban ==
 {{{
-C:\"Program Files"\PostgreSQL\8.4\bin\pgsql2shp -f "C:\Documents and Settings\cedric\Mes documents\Migrateur\eda\exports_shape\p_surf_urb_up" -p 5433 -u postgres -P postgres -g the_geom -r -k eda2.0 select r.gid, c.gid as c_gid, up_art_11_13/up_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');
+C:\"Program Files"\PostgreSQL\8.4\bin\pgsql2shp -f "C:\Documents and Settings\cedric\Mes documents\Migrateur\eda\exports_shape\p_surf_urb_up" -p 5433 -u postgres -P postgres -g the_geom -r -k eda2.0 "select r.gid, 
+c.gid as c_gid, 
+CASE WHEN up_catchment_area=0 THEN 0
+WHEN up_catchment_area IS NULL THEN 0
+ELSE up_art_11_13/up_catchment_area 
+END 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')
+limit 100;";
 }}}