[Osmf-talk] Membership statistics

[Martin Koppenhoefer]

2017-05-05 16:55 GMT+02:00 Christoph Hormann <chris_hormann at gmx.de>:

> I know this is probably a bit of work (although not that much probably
> considering Martin just did this casually for a diary post)
>



as long as you are only making country lists it is a one-liner:

cat Normal_OSMF_members_6month-notpaid.csv|cut -d'|' -f9|sort|uniq -c|sort
-r

Before I had sorted the list in calc by "membership expired" and resaved
the paid up plus those not paid up for less than 6 months as csv with | as
separator (because of the commas in the values).
If you want to aggregate by continents or regions, you will need something
more complex or a little bit of manual work. Our members are currently from
47 different countries.

Cheers,
Martin
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/osmf-talk/attachments/20170505/0274cefe/attachment.html>