Changes between Version 32 and Version 33 of CookBook join RHT-BDMAP

Timestamp:

Oct 18, 2011 12:01:47 PM (14 years ago)

Author:

cedric

Comment:

--

CookBook join RHT-BDMAP

@@ -286 +286 @@
 {{{
 #!sql 
+-- script qui fonctionne uniquement chez Laurent (lien à la table "SIG"
 UPDATE station_geography
-        SET id_bdcarthage_troncon = id_bdcarth, id_bdcarthage_cours_d_eau = c_hyd_cdo, nom_cours_d_eau = toponyme1
-        FROM "SIG".troncon_hydrographique, (SELECT sg_id, MIN(ST_Distance(troncon_hydrographique.the_geom, station_geography.the_geom)) AS min FROM station_geography, "SIG".troncon_hydrographique WHERE ST_Expand(station_geography.the_geom, 300) && troncon_hydrographique.the_geom GROUP BY sg_id) min_dist
-        WHERE station_geography.sg_id = min_dist.sg_id AND ST_Expand(station_geography.the_geom, 300) && troncon_hydrographique.the_geom AND ST_Distance(troncon_hydrographique.the_geom, station_geography.the_geom) = min_dist.min}}}
+        SET id_bdcarthage_troncon = id_bdcarth, 
+        id_bdcarthage_cours_d_eau = c_hyd_cdo, 
+        nom_cours_d_eau = toponyme1
+        FROM "SIG".troncon_hydrographique, 
+        (SELECT sg_id, MIN(ST_Distance(troncon_hydrographique.the_geom, station_geography.the_geom)) AS min 
+        FROM station_geography, "SIG".troncon_hydrographique
+         WHERE ST_Expand(station_geography.the_geom, 300) && troncon_hydrographique.the_geom GROUP BY sg_id) min_dist
+        WHERE station_geography.sg_id = min_dist.sg_id 
+        AND ST_Expand(station_geography.the_geom, 300) && troncon_hydrographique.the_geom 
+        AND ST_Distance(troncon_hydrographique.the_geom, station_geography.the_geom) = min_dist.min
+-- test de cédric
+/*
+e:
+cd E:\IAV\eda\bdmap
+psql -h localhost -U postgres --verbose  --file "station_geography.sql" eda2.0_RHT
+alter table station_geography set schema bdmap2009;
+*/
+SET search_path TO bdmap2009, public; -- vous la connaissez celle là ?
+SELECT * FROM station_geography; --11379
+select  * from station_geography sg join station st on st.st_codecsp=sg.st_codecsp; --11379 c'est effectivement la même chose....
+}}}