Changes between Version 98 and Version 99 of CookBook join BDMAP_CCM

Timestamp:

May 24, 2010 10:07:24 PM (15 years ago)

Author:

cedric

Comment:

--

CookBook join BDMAP_CCM

@@ -230 +230 @@
 {{{
 #!sql
--- creation de la table correspondance, je rajoute un the_geom a la requete pour pouvoir voir la table dans Qgis  
-DROP TABLE IF EXISTS bd_map.correspondance;
-CREATE TABLE bd_map.correspondance as (
+-- creation de la table bdmap_ccm, je rajoute un the_geom a la requete pour pouvoir voir la table dans Qgis  
+DROP TABLE IF EXISTS bd_map.bdmap_ccm;
+CREATE TABLE bd_map.bdmap_ccm as (
         SELECT distinct on (st_codecsp) st_codecsp, gid, min(distance) as distance, the_geom FROM (
                SELECT st_codecsp, gid ,CAST(distance(r.the_geom, s.the_geom) as  decimal(15,1)) as distance,s.the_geom 
@@ -241 +241 @@
         GROUP BY st_codecsp, distance,gid, the_geom
 );
-alter table bd_map.correspondance add column id serial;
+alter table bd_map.bdmap_ccm add column id serial;
 -- mise à jour de la table geometry_columns
 INSERT INTO geometry_columns(f_table_catalog, f_table_schema, f_table_name, f_geometry_column, coord_dimension, srid, "type")
-SELECT '', 'bd_map', 'correspondance', 'the_geom', ST_CoordDim(the_geom), ST_SRID(the_geom), GeometryType(the_geom)
-FROM bd_map.correspondance LIMIT 1;
+SELECT '', 'bd_map', 'bdmap_ccm', 'the_geom', ST_CoordDim(the_geom), ST_SRID(the_geom), GeometryType(the_geom)
+FROM bd_map.bdmap_ccm LIMIT 1;
 
 -- creation d'index, clé primaire, et constraintes qui vont bien
-alter table bd_map.correspondance add CONSTRAINT enforce_dims_the_geom CHECK (ndims(the_geom) = 2);
-alter table bd_map.correspondance add  CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) = 'POINT'::text OR the_geom IS NULL);
-alter table bd_map.correspondance add  CONSTRAINT enforce_srid_the_geom CHECK (srid(the_geom) = 3035);
-alter table bd_map.correspondance ADD CONSTRAINT pk_id PRIMARY KEY(id);
-CREATE INDEX indexcorrespondance ON bd_map.correspondance
+alter table bd_map.bdmap_ccm add CONSTRAINT enforce_dims_the_geom CHECK (ndims(the_geom) = 2);
+alter table bd_map.bdmap_ccm add  CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) = 'POINT'::text OR the_geom IS NULL);
+alter table bd_map.bdmap_ccm add  CONSTRAINT enforce_srid_the_geom CHECK (srid(the_geom) = 3035);
+alter table bd_map.bdmap_ccm ADD CONSTRAINT pk_id PRIMARY KEY(id);
+CREATE INDEX indexbdmap_ccm ON bd_map.bdmap_ccm
   USING GIST ( the_geom GIST_GEOMETRY_OPS );
 
@@ -259 +259 @@
 {{{
 #!sql
-select count(*) from bd_map.correspondance ;--9272 -- 8884 a 300m
+select count(*) from bd_map.bdmap_ccm ;--9272 -- 8884 a 300m
 select count(*) from bd_map.stationsp2 ;--10203
 select 100*9272 /10203::float
 select 100*8884 /10203::float--87.07
-alter table bd_map.correspondance add column id serial;
-}}}
-Below in red old stations not in bd_map.correspondance, green new stations without correspondance, purple correspondance successfull, the map is centered on the Vilaine...
+alter table bd_map.bdmap_ccm add column id serial;
+}}}
+Below in red old stations not in bd_map.bdmap_ccm, green new stations without correspondance, purple correspondance successfull, the map is centered on the Vilaine...
 [[Image(source:data/Docs/trac/jointure_ccm_eda.jpg,600px)]]