Changes between Initial Version and Version 1 of POSE EDA Report

Timestamp:

Jul 29, 2011 10:22:15 AM (14 years ago)

Author:

celine

Comment:

--

POSE EDA Report

@@ +1 @@
+back to first page [..][[BR]]
+
+== 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'))"
+}}}