Changes between Version 11 and Version 12 of CookBook pgsql2shp

Timestamp:

Nov 4, 2010 5:41:20 PM (14 years ago)

Author:

cedric

Comment:

--

CookBook pgsql2shp

@@ -36 +36 @@
 == ccm21.riversegments_bretagne ==
 {{{
-C:\"Program Files"\PostgreSQL\8.4\bin\pgsql2shp -f "C:\Documents and Settings\cedric\Mes documents\Migrateur\eda\exports_shape\riversegments_bretagne" -p 5433 -u postgres -P postgres -g the_geom -r -k eda2.0 ccm21.riversegments_bretagne
+C:\"Program Files"\PostgreSQL\8.4\bin\pgsql2shp -f "C:\eda\exports_shape\riversegments_bretagne" -p 5433 -u postgres -P postgres -g the_geom -r -k eda2.0 ccm21.riversegments_bretagne
 }}}
 == ccm21.catchments_bretagne ==
 {{{
-C:\"Program Files"\PostgreSQL\8.4\bin\pgsql2shp -f "C:\Documents and Settings\cedric\Mes documents\Migrateur\eda\exports_shape\catchments_bretagne" -p 5433 -u postgres -P postgres -g the_geom -r -k eda2.0 ccm21.catchments_bretagne
+C:\"Program Files"\PostgreSQL\8.4\bin\pgsql2shp -f "C:\eda\exports_shape\catchments_bretagne" -p 5433 -u postgres -P postgres -g the_geom -r -k eda2.0 ccm21.catchments_bretagne
 }}}
 == clc.clipped_bretagne1 ==
 {{{
-C:\"Program Files"\PostgreSQL\8.4\bin\pgsql2shp -f "C:\Documents and Settings\cedric\Mes documents\Migrateur\eda\exports_shape\clipped_bretagne1" -p 5433 -u postgres -P postgres -g the_geom -r -k eda2.0 clc.clipped_bretagne1
+C:\"Program Files"\PostgreSQL\8.4\bin\pgsql2shp -f "C:\eda\exports_shape\clipped_bretagne1" -p 5433 -u postgres -P postgres -g the_geom -r -k eda2.0 clc.clipped_bretagne1
 }}}
 == ccm21.riversegments_france ==
 A query selecting a reduced area
 {{{
-C:\"Program Files"\PostgreSQL\8.4\bin\pgsql2shp -f "C:\Documents and Settings\cedric\Mes documents\Migrateur\eda\exports_shape\riversegments_france" -p 5433 -u postgres -P postgres -g the_geom -r -k eda2.0 "select * from ccm21.riversegments where wso_id in (select wso_id from france.wso where area='France');"
+C:\"Program Files"\PostgreSQL\8.4\bin\pgsql2shp -f "C:\eda\exports_shape\riversegments_france" -p 5433 -u postgres -P postgres -g the_geom -r -k eda2.0 "select * from ccm21.riversegments where wso_id in (select wso_id from france.wso where area='France');"
 }}}
 == ccm21.catchments_france ==
 
 {{{
-C:\"Program Files"\PostgreSQL\8.4\bin\pgsql2shp -f "C:\Documents and Settings\cedric\Mes documents\Migrateur\eda\exports_shape\catchments_france" -p 5433 -u postgres -P postgres -g the_geom -r -k eda2.0 "select * from ccm21.catchments where wso_id in (select wso_id from france.wso where area='France');"
+C:\"Program Files"\PostgreSQL\8.4\bin\pgsql2shp -f "C:\eda\exports_shape\catchments_france" -p 5433 -u postgres -P postgres -g the_geom -r -k eda2.0 "select * from ccm21.catchments where wso_id in (select wso_id from france.wso where area='France');"
 }}}
 == clc.surf_area_final ==
 {{{
-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
+C:\"Program Files"\PostgreSQL\8.4\bin\pgsql2shp -f "C:\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 ==
 {{{
-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');"
+C:\"Program Files"\PostgreSQL\8.4\bin\pgsql2shp -f "C: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');"
 }}}
+
+== roe_ccm_300 ==
+{{{
+C:\"Program Files"\PostgreSQL\8.4\bin\pgsql2shp -f "C:\eda\exports_shape\roe_ccm_300" -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');"
+}}}
+