Maarten Dammers wrote:

Hi everyone,

I just noticed
https://secure.wikimedia.org/wikipedia/commons/wiki/Commons:Village_pump#User_preferences
so I wondered where the data comes from. I checked the commonswiki_p
database and it looks like user_properties is visible now. I always
considered the user_properties information privacy sensitive
information. It contains the gender, language and timezone of every
user. Information I'm sure a lot of people don't want to have exposed.
Please remove this table from the view.

Maarten


Please look at the table contents.

The public view of user_properties on the Toolserver only contains gender,
nothing else.

In addition to user_properties, Toolserver also features a custom view,
named "user_properties_anonym".

That view contains all (if not, most) preferneces, but without the user-id.
This is were the commons-page got it's information from.

--
Timo