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

Timestamp:

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

Author:

cedric

Comment:

--

CookBook join RHT-BDMAP

@@ -340 +340 @@
 
 
-
-
-
+{{{
+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;
+---update bdmap2009.station_geography set the_geom =ST_Transform(the_geom,3035);
+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
+}}}
+
+