back to first page ..

Station and district for mapfond and mapstation

C:\"Program Files"\PostgreSQL\8.4\bin\pgsql2shp -f "D:\CelineJouanin\exports_shape\station_Western" -p 5432 -u postgres -P noisette16! -g the_geom -r -k eda2.0 wrbd.wrbd_station_ccm_500

C:\"Program Files"\PostgreSQL\8.4\bin\pgsql2shp -f "D:\CelineJouanin\exports_shape\district_Western" -p 5432 -u postgres -P noisette16! -g the_geom -r -k eda2.0 "select * from rbd_f1v3.emu where name_engl='Western'"


C:\"Program Files"\PostgreSQL\8.4\bin\pgsql2shp -f "D:\CelineJouanin\exports_shape\district_Bretagne" -p 5432 -u postgres -P noisette16! -g the_geom -r -k eda2.0 "select * from uga2010.uga where libelle='Bretagne'"


C:\"Program Files"\PostgreSQL\8.4\bin\pgsql2shp -f "D:\CelineJouanin\exports_shape\district_Rhone" -p 5432 -u postgres -P noisette16! -g the_geom -r -k eda2.0 "select * from uga2010.uga where libelle='Rhone-Mediterranee'"


C:\"Program Files"\PostgreSQL\8.4\bin\pgsql2shp -f "D:\CelineJouanin\exports_shape\station_Bretagne" -p 5432 -u postgres -P noisette16! -g the_geom -r -k eda2.0 "select * from bd_map.bdmap_ccm_gid b where gid in (select gid from ccm21.riversegments where wso1_id in (select wso1_id from europe.wso1 where area='Bretagne'))"

C:\"Program Files"\PostgreSQL\8.4\bin\pgsql2shp -f "D:\CelineJouanin\exports_shape\station_Rhone" -p 5432 -u postgres -P noisette16! -g the_geom -r -k eda2.0 "select * from bd_map.bdmap_ccm_gid b where gid in (select gid from ccm21.riversegments where wso1_id in (select wso1_id from europe.wso1 where area='RhoneMediterranee'))"

C:\"Program Files"\PostgreSQL\8.4\bin\pgsql2shp -f "D:\CelineJouanin\exports_shape\station_Anglian" -p 5432 -u postgres -P noisette16! -g the_geom -r -k eda2.0 anglian.anglian_station_ccm_500

C:\"Program Files"\PostgreSQL\8.4\bin\pgsql2shp -f "D:\CelineJouanin\exports_shape\district_Anglian" -p 5432 -u postgres -P noisette16! -g the_geom -r -k eda2.0 "select * from rbd_f1v3.emu where name_engl='Anglian'"