Changes between Version 42 and Version 43 of CookBook join RHT-BDMAP

Timestamp:

Oct 3, 2012 4:53:58 PM (13 years ago)

Author:

celine

Comment:

--

CookBook join RHT-BDMAP

@@ -39 +39 @@
 {{{
 #!sql
-select count(*) from bd_map.stationsp2  --10193 lignes
-select count(*) from rht.rht  --114601 lignes
-select count(*) from rht.bdmap_rht  -- 9650 lignes
+select count(*) from bd_map.stationsp2  --10193 lines
+select count(*) from rht.rht  --114601 lines
+select count(*) from rht.bdmap_rht  -- 9650 lines
 }}}
 
@@ -48 +48 @@
 {{{
 #!sql
-select count(*) from bd_map.bdmap_ccm_gid  --8188 lignes
+select count(*) from bd_map.bdmap_ccm_gid  --8188 lines
 }}}
 Soit 80% des stations projetées sur la CCM
@@ -65 +65 @@
 delete from rht.bdmap_rht_id where st_codecsp in ('05400178','05400044','0547C020','06040033','06040206','06070217','06840018','03600120','03910037','03910021','04450005','04181015','04181000','03510116','06390254','06250304','06730233','02880208','06700020','02550268','02080064','02080065','03510111','03520110','02670261','02670202','02670203');  -- 27 stations supprimées
 delete from rht.bdmap_rht_id where st_codecsp in ('04420483','04420401','04420181','04420190','04430154','03890102','03890135','04630032','04420437'); -- 9 stations supprimées
-delete from rht.bdmap_rht_id where st_codecsp in ('06260192','06380273','02880051','02670109','02670055','02670176','02670177','02670143','02670178','02670141','02670082','02670039','02570237','02540023','02570203');  --14 lignes
+delete from rht.bdmap_rht_id where st_codecsp in ('06260192','06380273','02880051','02670109','02670055','02670176','02670177','02670143','02670178','02670141','02670082','02670039','02570237','02540023','02570203');  --14 lines
 delete from rht.bdmap_rht_id where st_codecsp in ('06880149','02880048','04420458','02680085','02680039','02670004','02670053','06520051','03080085','02080027','06840052');  -- 11 stations
 
@@ -130 +130 @@
 
 Est ce que station_bdmapv2_final correspond à stationsp2 ? => NON IL FAUT LA REFAIRE
-Pourquoi est ce que dans station_bdmapv2_final ? -- 8759 alors que céline select count(*) from bd_map.stationsp2  --10193 lignes
+Pourquoi est ce que dans station_bdmapv2_final ? -- 8759 alors que céline select count(*) from bd_map.stationsp2  --10193 lines
 => PARCE QUE STATIONSP2 EST UNE JOINTURE RIGHT JOIN ENTRE DEUX TABLES
 */
@@ -154 +154 @@
 
 --select st_transform(PointFromText('POINT(' || st_abcisse || ' ' || st_ordonnee || ')',27572),3035) from bdmap2009.station;
---select * from bdmap2009.station where st_abcisse_l93>0 -- 0 lignes on en peut pas utiliser
+--select * from bdmap2009.station where st_abcisse_l93>0 -- 0 lines on en peut pas utiliser
 
 SELECT AddGeometryColumn('bdmap2009', 'station','the_geom', 3035,'POINT',2); 
@@ -350 +350 @@
 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
+update bdmap2009.station_geography set the_geom =ST_Transform(ST_SetSRID(the_geom,2154),3035);--11379 lines
 -- 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);