X-Git-Url: https://git.openstreetmap.org./rails.git/blobdiff_plain/d34bc8cb52749eb039edbe5b86ed47b5c7fa143d..740511066fcfaa910e0d9a9d86f6fefce85af343:/script/statistics diff --git a/script/statistics b/script/statistics index 47c18312d..e76028114 100755 --- a/script/statistics +++ b/script/statistics @@ -18,18 +18,15 @@ begin user_count = User.count(:conditions => "active = true") tracepoint_count = Tracepoint.count() node_count = Node.count(:conditions => "visible = true") - segment_count = Segment.count(:conditions => "visible = true") way_count = Way.count(:conditions => "visible = true") - tagged_way_count = Way.count(:conditions => "current_ways.visible = true AND current_way_tags.k <> 'created_by'", - :joins => "INNER JOIN current_way_tags ON current_way_tags.id = current_ways.id") + relation_count = Relation.count(:conditions => "visible = true") puts "" puts "" puts "" puts "" - puts "" puts "" - puts "" + puts "" puts "
Number of users#{user_count}
Number of uploaded GPS points#{tracepoint_count}
Number of nodes#{node_count}
Number of segments#{segment_count}
Number of ways#{way_count}
Number of ways with tags#{tagged_way_count}
Number of relations#{relation_count}
" puts "

Top 50 users for uploads of GPS data

" @@ -81,9 +78,13 @@ begin SyncEnumerator.new(day_users, week_users, month_users).each do |row| puts "" row.each do |column| - display_name = User.find(column[0]).display_name.gsub('@', ' at ').gsub('.', ' dot ') - count = column[1] - puts "#{count} #{display_name}" + if column.nil? + puts "" + else + display_name = User.find(column[0]).display_name.gsub('@', ' at ').gsub('.', ' dot ') + count = column[1] + puts "#{count} #{display_name}" + end end puts "" end