Changes between Version 36 and Version 37 of CookBook join RHT-BDMAP

Timestamp:

Oct 26, 2011 4:10:54 PM (14 years ago)

Author:

cedric

Comment:

--

CookBook join RHT-BDMAP

@@ -341 +341 @@
 
 {{{
+E:\IAV\eda\bdmap\geolocalisation
+E:
+CD E:\IAV\eda\bdmap\geolocalisation
+psql -d eda2.0_RHT -h localhost -U postgres -p 5432 -f station_geography.sql
+-- psql erreur la fonction geom_update n'existe pas (ca tu n'avais pas=> je n'ai pas le trigger)
 alter table station_geography set schema bdmap2009;
----Some station outside of France
 ---Changement du système de projection  RGF93_Lambert_93 (srid 2154) --> ETRS LAEA (srid 3035)
 alter table bdmap2009.station_geography drop constraint enforce_srid_the_geom;
@@ -348 +352 @@
 update bdmap2009.station_geography set the_geom =ST_Transform(ST_SetSRID(the_geom,2154),3035);--11379 lignes
 -- pour moi geom_update n'a pas marché, il doit bien s'agir d'un problem de trigger, fait drop trigger
-
 alter table bdmap2009.station_geography add  CONSTRAINT enforce_srid_the_geom CHECK (srid(the_geom) = 3035);
 CREATE INDEX index_station_geography ON bdmap2009.station_geography
   USING btree ( id_bdcarthage_troncon);
-
-select * from bdmap2009.station_geography where a_conserver = true; --9323
-}}}
-
-
+select * from bdmap2009.station_geography where a_conserver = true
+}}}
+
+