Changes between Version 16 and Version 17 of CookBook join ROE_CCM

Timestamp:

Mar 16, 2010 10:32:23 AM (15 years ago)

Author:

cedric

Comment:

--

CookBook join ROE_CCM

@@ -19 +19 @@
 == We have to reproject our data ==
 The constraint CONSTRAINT enforce_srid_ref_position_locale CHECK (srid(ref_position_locale) = 27572)
-will make it impossible to change the srid from the roe
+will make it impossible to change the srid from the roe (is that right ?)
 We will create a new column a new constraint and fill this column with reprojected data
 {{{
@@ -25 +25 @@
 -- this function also creates constraint « enforce_srid_ref_position_etrs89 
 select SRID (ref_position_locale) FROM geobs.obstacle_referentiel; -- all lines 27572 (Lambert II)
-SELECT ST_Transform(ref_position_locale,3035) FROM geobs.obstacle_referentiel;
+update geobs.obstacle_referentiel set ref_position_etrs89 =ST_Transform(ref_position_locale,3035);
 }}}