Changes between Version 28 and Version 29 of CookBook join RHT-BDMAP

Timestamp:

Oct 13, 2011 12:30:46 PM (14 years ago)

Author:

cedric

Comment:

--

CookBook join RHT-BDMAP

@@ -106 +106 @@
 select count(*) from bdmap2009.station_bdmapv2_final stat inner join bd_carthage2011.troncon_hydrographique as bdc on bdc.code_hydro=stat.eh_codegen; --58875 ca ne marche pas du tout
 }}}
+
+
+reprojection de bdmap
+{{{
+alter table bdmap2009.station_bdmapv2_final drop constraint enforce_srid_the_geom;
+update bdmap2009.station_bdmapv2_final set the_geom=st_transform(the_geom,3035);
+alter table bdmap2009.station_bdmapv2_final add constraint enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);
+}}}