[NCUC E-team] Regions and genders

[Tapani Tarvainen]

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