Changes between Version 3 and Version 4 of BDCarthage2011

Timestamp:

Sep 7, 2011 5:39:49 PM (14 years ago)

Author:

celine

Comment:

--

BDCarthage2011

@@ -51 +51 @@
 select count(largeur), largeur from troncon_hydrographique group by largeur
 
-select count(id_bdcarthage), id_bdcarthage from noeuds group by id_bdcarthage order by count(id_bdcarthage)  ---606 doublons
+select count(id_bdcarthage), id_bdcarthage from noeuds group by id_bdcarthage order by count(id_bdcarthage)  --ancienne version (Cédric) pas de doublons
+select count(id_bdcarth), id_bdcarth from troncon_hydrographique group by id_bdcarth order by count(id_bdcarth)  ---527817-527212+1=606 segments avec un doublon
+select count(gid), gid from troncon_hydrographique group by gid order by count(gid)
+
+---example
+select * from troncon_hydrographique where id_bdcarth in ('409000825','605000402','427000399') order by id_bdcarth
 }}}