Changes between Version 10 and Version 11 of CookBook pgsql2shp


Ignore:
Timestamp:
Jun 18, 2010 9:26:16 AM (15 years ago)
Author:
cedric
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • CookBook pgsql2shp

    v10 v11  
    6262== percentage urban == 
    6363{{{ 
    64 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,  
    65 c.gid as c_gid,  
    66 CASE WHEN up_catchment_area=0 THEN 0 
    67 WHEN up_catchment_area IS NULL THEN 0 
    68 ELSE up_art_11_13/up_catchment_area  
    69 END as psurf, 
    70 c.the_geom  
    71 from ccm21.riversegments r 
    72 join ccm21.catchments c on c.wso1_id=r.wso1_id 
    73 where r.wso_id in (select wso_id from france.wso where area='France') 
    74 limit 100;"; 
     64C:\"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');" 
    7565}}}