Changes between Version 18 and Version 19 of CookBook join BDMAP_CCM

Timestamp:

Feb 9, 2010 9:31:51 PM (15 years ago)

Author:

cedric

Comment:

--

CookBook join BDMAP_CCM

@@ -107 +107 @@
 COMMENT ON TABLE stationsp2 is 'table BDMAP extraite janvier 2010 et mise à jour avec les coordonnées reprojetées par Hélène'
 }}}
-  * 
+  * ah, and now if you want to display the new stations using Qgis, adding a further column saying whether or not the column X is filled is usefull
+{{{
+ALTER TABLE stationsp2 ADD COLUMN newstation boolean;
+UPDATE stationsp2 set newstation=TRUE where x is null;
+UPDATE stationsp2 set newstation=FALSE where x is not null;
+}}}
+  * now some results ...
+{{{
+select count(*) from stationsp2 --10203
+select count(*) from bdmap.station --10203 
+select count(*) from stationsp --8741
+select * from stationsp2 limit 1000 -- this is if you want to have a look at the data
+}}}
+  * those are the wrong stations  [screenshot:5]
+{{{
+
+select * from stationsp2 where st_codecsp IN ('03890162','062B0086','01620140','03270062','03270061','03270063','03270064','062160126','06420055','06070241')
+}}}
   '' note ''
-  * the result is displayed there : [screenshot:4], [screenshot:5]
+  * the result is displayed there : [screenshot:4],
   * this work corresponds to ticket : #22