Changes between Initial Version and Version 1 of Ticket #44


Ignore:
Timestamp:
Mar 2, 2010 3:32:11 PM (15 years ago)
Author:
cedric
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #44

    • Property Status changed from new to accepted

  • Ticket #44 – Description

    initial v1  
     1Nos distances sont écrites dans la base CCM table riversegments 
     2Ci dessous une requete pour les comparer 
     3 
     4{{{ 
     5select cum_len_sea,len_tom from rivernodes 
     6 inner join riversegments on riversegments.tonode=rivernodes.id  
     7limit 100 
     8}}} 
     9{{{ 
     10select count(*) from( 
     11select cum_len_sea,len_tom from rivernodes 
     12 inner join riversegments on riversegments.tonode=rivernodes.id  
     13where cum_len_sea != len_tom) as sub 
     14-- 30384 
     15}}} 
     16{{{ 
     17select count(*) from( 
     18select cum_len_sea,len_tom from rivernodes 
     19 inner join riversegments on riversegments.tonode=rivernodes.id  
     20where cum_len_sea != len_tom) as sub 
     21-- 86380 
     22}}}