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

Timestamp:

Oct 26, 2011 11:40:48 AM (14 years ago)

Author:

celine

Comment:

--

CookBook join RHT-BDMAP

@@ -309 +309 @@
 select  * from station_geography sg join station st on st.st_codecsp=sg.st_codecsp; --11379 c'est effectivement la même chose....
 }}}
+
+BDMAP - Projection Laurent
+{{{
+d:
+cd D:\CelineJouanin\EDA20RHT\BDMAP\geolocalisation
+C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0_RHT -h localhost -U postgres -p 5432 -f station_geography.sql
+
+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);
+
+alter table bdmap2009.station_geography add CONSTRAINT enforce_dims_the_geom CHECK (ndims(the_geom) = 2);
+alter table bdmap2009.station_geography add  CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) = 'POINT'::text OR the_geom IS NULL);
+alter table bdmap2009.station_geography add  CONSTRAINT enforce_srid_the_geom CHECK (srid(the_geom) = 3035);
+alter table bdmap2009.station_geography ADD CONSTRAINT pk_id PRIMARY KEY(id);
+CREATE INDEX indexstatgeo ON bdmap2009.station_geography
+  USING GIST ( the_geom GIST_GEOMETRY_OPS );
+}}}
+
+
+
+
+