sunlightlabs / opencongress

An open website for opening Congress.
http://www.opencongress.org
GNU General Public License v3.0
48 stars 16 forks source link

Group issue areas are PVS issues #97

Closed drinks closed 11 years ago

drinks commented 11 years ago

We could perhaps switch to top-level CRS issues; any desire to move away from votesmart data entirely? They're still integral in a few bits of the site

dvogel commented 11 years ago

Each group can be associated with a PVS category. Most groups are not actually associated with a specific category. Thus loss of fidelity from mapping these over to CRS subjects will be low. The only two groups that cannot be mapped at all are "Liberal" and "Conservative" and "Social Issues". There is only one user-created group in these categories and it is unused.

Furthermore, there is a pre-made group for each category that is owned by Donny. Most of these users have very few users. The group description promises that Donny will curate content for the group. That hasn't happened because most of these groups have very few posts. I will map these to CRS subjects but I think we should eliminate these.

Number of groups associated with each PVS category (categories with a single group have no user-created groups):

Group.group(:pvs_category_id).count
{
    nil => 509,
     43 => 2,
     34 => 1,
     25 => 10,
     32 => 1,
      8 => 2,
     12 => 1,
      1 => 5,
     10 => 4,
     42 => 3,
     26 => 1,
     11 => 4,
     18 => 5,
     16 => 1,
     39 => 1,
      3 => 3,
     13 => 2,
     22 => 3,
      9 => 8,
     24 => 1,
     14 => 1,
     45 => 2,
     46 => 1,
     27 => 3,
     17 => 1,
     28 => 2,
     36 => 2,
     15 => 2,
     38 => 1,
      4 => 5,
     30 => 1,
     33 => 1,
      6 => 1,
     40 => 1,
     19 => 3,
     29 => 2,
     21 => 4,
      2 => 2,
     23 => 3,
     41 => 1,
     31 => 6,
     35 => 1,
     20 => 1,
      5 => 2,
     44 => 1,
      7 => 3,
     37 => 2
}

Each category with it's pre-made group:

PvsCategory.all.map{ |c| g = Group.find_by_name("The #{c.name} Group") and { :name => c.name, :group => { :name => g.name, :users => g.users.count, :posts => g.political_notebook.notebook_items.count } } }
[
    [ 0] {
         :name => "Foreign Aid and Policy Issues",
        :group => {
             :name => "The Foreign Aid and Policy Issues Group",
            :users => 9,
            :posts => 1
        }
    },
    [ 1] {
         :name => "Women's Issues",
        :group => {
             :name => "The Women's Issues Group",
            :users => 8,
            :posts => 1
        }
    },
    [ 2] {
         :name => "Housing and Property Issues",
        :group => {
             :name => "The Housing and Property Issues Group",
            :users => 1,
            :posts => 0
        }
    },
    [ 3] {
         :name => "Arts and Humanities",
        :group => {
             :name => "The Arts and Humanities Group",
            :users => 4,
            :posts => 0
        }
    },
    [ 4] {
         :name => "Employment and Affirmative Action",
        :group => {
             :name => "The Employment and Affirmative Action Group",
            :users => 3,
            :posts => 0
        }
    },
    [ 5] {
         :name => "Technology and Communication",
        :group => {
             :name => "The Technology and Communication Group",
            :users => 12,
            :posts => 0
        }
    },
    [ 6] {
         :name => "Transportation Issues",
        :group => {
             :name => "The Transportation Issues Group",
            :users => 4,
            :posts => 0
        }
    },
    [ 7] {
         :name => "Energy Issues",
        :group => {
             :name => "The Energy Issues Group",
            :users => 9,
            :posts => 0
        }
    },
    [ 8] {
         :name => "Environmental Issues",
        :group => {
             :name => "The Environmental Issues Group",
            :users => 13,
            :posts => 1
        }
    },
    [ 9] {
         :name => "Congressional and Legislative Affairs",
        :group => {
             :name => "The Congressional and Legislative Affairs Group",
            :users => 4,
            :posts => 0
        }
    },
    [10] {
         :name => "Family and Children Issues",
        :group => {
             :name => "The Family and Children Issues Group",
            :users => 4,
            :posts => 0
        }
    },
    [11] {
         :name => "Gambling and Gaming",
        :group => {
             :name => "The Gambling and Gaming Group",
            :users => 1,
            :posts => 0
        }
    },
    [12] {
         :name => "Government Reform",
        :group => {
             :name => "The Government Reform Group",
            :users => 12,
            :posts => 1
        }
    },
    [13] {
         :name => "Executive Branch",
        :group => {
             :name => "The Executive Branch Group",
            :users => 4,
            :posts => 0
        }
    },
    [14] {
         :name => "Conservative",
        :group => {
             :name => "The Conservative Group",
            :users => 8,
            :posts => 0
        }
    },
    [15] {
         :name => "Drug Issues",
        :group => {
             :name => "The Drug Issues Group",
            :users => 10,
            :posts => 1
        }
    },
    [16] {
         :name => "Death Penalty",
        :group => {
             :name => "The Death Penalty Group",
            :users => 4,
            :posts => 0
        }
    },
    [17] {
         :name => "Liberal",
        :group => {
             :name => "The Liberal Group",
            :users => 12,
            :posts => 0
        }
    },
    [18] {
         :name => "Federal, State, and Local Relations",
        :group => {
             :name => "The Federal, State, and Local Relations Group",
            :users => 3,
            :posts => 0
        }
    },
    [19] {
         :name => "Senior and Social Security Issues",
        :group => {
             :name => "The Senior and Social Security Issues Group",
            :users => 7,
            :posts => 0
        }
    },
    [20] {
         :name => "Animal Rights and Wildlife Issues",
        :group => {
             :name => "The Animal Rights and Wildlife Issues Group",
            :users => 7,
            :posts => 0
        }
    },
    [21] {
         :name => "Science and Medical Research",
        :group => {
             :name => "The Science and Medical Research Group",
            :users => 11,
            :posts => 0
        }
    },
    [22] {
         :name => "Sexual Orientation and Gender Identity",
        :group => {
             :name => "The Sexual Orientation and Gender Identity Group",
            :users => 9,
            :posts => 0
        }
    },
    [23] {
         :name => "Social Issues",
        :group => {
             :name => "The Social Issues Group",
            :users => 4,
            :posts => 0
        }
    },
    [24] {
         :name => "Stem Cell Research",
        :group => {
             :name => "The Stem Cell Research Group",
            :users => 4,
            :posts => 0
        }
    },
    [25] {
         :name => "Legal Issues",
        :group => {
             :name => "The Legal Issues Group",
            :users => 2,
            :posts => 0
        }
    },
    [26] {
         :name => "Veterans Issues",
        :group => {
             :name => "The Veterans Issues Group",
            :users => 8,
            :posts => 0
        }
    },
    [27] {
         :name => "Trade Issues",
        :group => {
             :name => "The Trade Issues Group",
            :users => 2,
            :posts => 0
        }
    },
    [28] {
         :name => "Budget, Spending and Taxes",
        :group => {
             :name => "The Budget, Spending and Taxes Group",
            :users => 11,
            :posts => 1
        }
    },
    [29] {
         :name => "Campaign Finance and Election Issues",
        :group => {
             :name => "The Campaign Finance and Election Issues Group",
            :users => 3,
            :posts => 0
        }
    },
    [30] {
         :name => "Health Issues",
        :group => {
             :name => "The Health Issues Group",
            :users => 13,
            :posts => 0
        }
    },
    [31] {
         :name => "Business and Consumers",
        :group => {
             :name => "The Business and Consumers Group",
            :users => 2,
            :posts => 0
        }
    },
    [32] {
         :name => "Civil Liberties and Civil Rights",
        :group => {
             :name => "The Civil Liberties and Civil Rights Group",
            :users => 16,
            :posts => 0
        }
    },
    [33] {
         :name => "Crime Issues",
        :group => {
             :name => "The Crime Issues Group",
            :users => 3,
            :posts => 0
        }
    },
    [34] {
         :name => "National Security Issues",
        :group => {
             :name => "The National Security Issues Group",
            :users => 9,
            :posts => 0
        }
    },
    [35] {
         :name => "Defense",
        :group => {
             :name => "The Defense Group",
            :users => 11,
            :posts => 0
        }
    },
    [36] {
         :name => "Labor",
        :group => {
             :name => "The Labor Group",
            :users => 4,
            :posts => 2
        }
    },
    [37] {
         :name => "Military Issues",
        :group => {
             :name => "The Military Issues Group",
            :users => 9,
            :posts => 0
        }
    },
    [38] {
         :name => "Abortion Issues",
        :group => {
             :name => "The Abortion Issues Group",
            :users => 23,
            :posts => 0
        }
    },
    [39] {
         :name => "Education",
        :group => {
             :name => "The Education Group",
            :users => 13,
            :posts => 0
        }
    },
    [40] {
         :name => "Reproductive Issues",
        :group => {
             :name => "The Reproductive Issues Group",
            :users => 4,
            :posts => 0
        }
    },
    [41] {
         :name => "Agriculture Issues",
        :group => {
             :name => "The Agriculture Issues Group",
            :users => 3,
            :posts => 0
        }
    },
    [42] {
         :name => "Indigenous Peoples",
        :group => {
             :name => "The Indigenous Peoples Group",
            :users => 3,
            :posts => 0
        }
    },
    [43] {
         :name => "Gun Issues",
        :group => {
             :name => "The Gun Issues Group",
            :users => 21,
            :posts => 1
        }
    },
    [44] {
         :name => "Immigration",
        :group => {
             :name => "The Immigration Group",
            :users => 6,
            :posts => 0
        }
    },
    [45] {
         :name => "Welfare and Poverty",
        :group => {
             :name => "The Welfare and Poverty Group",
            :users => 7,
            :posts => 0
        }
    }
]
dvogel commented 11 years ago

Fixed in 3841ae32b1307e9c3e9f84e4212ce0320fdfb131.