[NCUC E-team] Regions and genders

[William Drake]

This is fabulous Tapani, thanks much for your help.  When Maryam is back from vac let’s walk her through it. If other e-team folks have any thoughts or assistance to offer please do.

Best

Bill

> On Aug 6, 2015, at 8:32 AM, Tapani Tarvainen <ncuc at TAPANI.TARVAINEN.INFO> wrote:
> 
> Dear all,
> 
> In order to get member counts per region Bill wanted,
> I added a region table to the database like this:
> 
> create table regions (code text, country text, physregion text, icannregion text);
> 
> I picked the data from here:
> 
> https://meetings.icann.org/en/regions
> 
> and added a few aliases (pesky unitedstatesians insist
> on writing their country as "USA" instead of ICANN-approved
> "United States", likewise unitedkingdomites as "UK",
> russianfederationists as mere "Russia" &c)
> as well as an entry for Serbia.
> (Other such additions may be needed later, but those covered
> our current membership.)
> 
> I also fixed some inconsistent capitalizations &c.
> 
> Now regional distribution can be obtained like this:
> 
> ncuc=> select count(*), icannregion from (select name, n.country, icannregion from ncucers n left outer join regions r on (n.country=r.country) where state<3 and role!='AddRep') as x group by icannregion;
> count | icannregion
> -------+-------------
>    21 |
>    44 | LAC
>    76 | AF
>    99 | NA
>   103 | EUR
>    85 | AP
> (6 rows)
> 
> I also put that in PHP here:
> http://www.ncuc.org/members/diversity.php
> 
> That is intended to be temporary, should be moved inside the
> regular about/members page, but first it'd be nice to clean
> up the 21 unknowns and think a bit about formatting it prettier.
> Suggestions for the format would be welcome.
> 
> Also, especially veteran NCUCers might want to help by taking
> a look at the unknowns, who've mostly been around since forever.
> You can see them by looking at blanks in country column here:
> http://www.ncuc.org/about/members/
> or ask me privately for a list.
> 
> Gender is harder, as there's no similar means for determining it
> automatically. I guess the easiest solution is adding a new column to
> ncucers with allowed values "m", "f" and "o" (for other) and have
> someone (...) fill it manually.
> Gender should then also be added to the membership application form.
> 
> -- 
> Tapani Tarvainen
> _______________________________________________
> E-team mailing list
> E-team at lists.ncuc.org
> http://lists.ncuc.org/cgi-bin/mailman/listinfo/e-team

*********************************************************
William J. Drake
International Fellow & Lecturer
  Media Change & Innovation Division, IPMZ
  University of Zurich, Switzerland
Chair, Noncommercial Users Constituency, 
  ICANN, www.ncuc.org
william.drake at uzh.ch (direct), wjdrake at gmail.com (lists),
  www.williamdrake.org
Internet Governance: The NETmundial Roadmap http://goo.gl/sRR01q
*********************************************************

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ncuc.org/pipermail/e-team/attachments/20150806/cf48bddf/attachment-0002.html>