[Qgis-psc] Analysis of donations/sponsorship 2016

[Andreas Neumann]

Hi,

The Geopackage can be downloaded from here:

https://drive.google.com/open?id=0B0h3PAH5uoY6R1NwcmpTRTNGd1U

The individual payments are in the table 
"donations_and_sponsorships_detailed_2016" - the column "postal_code" 
links to the column "iso_a2" in the "countries" table.

There are 4 payment types:

PP - donation PayPal
WT - donation wire transfer
SPP - sponsorship PayPal
SWT - sponsorship wire transfer

I can imagine that one could flash at the centroid of a country whenever 
a donation happens and have categories for donations vs. sponsorships or 
according to the size of the contribution. Perhaps with a "glow effect" 
similar to 
http://www.spiegel.de/wissenschaft/natur/gewitter-atlas-so-haeufig-sind-blitze-in-deutschland-a-1104658.html 
Not sure if there is enough data for such a visualization like the 
flashes in Germany.

But I assume you got your own ideas.

Only if you have time though ... not a high priority thing.

Thanks,
Andreas


On 14.02.2017 13:53, Anita Graser wrote:
> Thank you Andreas! That's a really great analysis of our donor and 
> sponsor environment.
>
> If you could mail me the Geopackage with timestamped geodata, I'll see 
> what I can do with TimeManager.
>
> Best wishes,
> Anita
>
>
>
> On Tue, Feb 14, 2017 at 10:30 AM, Andreas Neumann <a.neumann at carto.net 
> <mailto:a.neumann at carto.net>> wrote:
>
>     Hi,
>
>     Please find a little analysis of the sponsorships and donations in
>     2016. Spatial and temporal distributions.
>
>     https://docs.google.com/document/d/1wfn1cL9Ix5hCrVLF5WTZ8ZAJNY_PPYxIMgne4P-6jLM/edit#
>     <https://docs.google.com/document/d/1wfn1cL9Ix5hCrVLF5WTZ8ZAJNY_PPYxIMgne4P-6jLM/edit#>
>
>     @Tim and @Anita - feel free to use this material for your planned
>     blog post.
>
>     If you are interested in the raw data (LibreOffice and Geopackage)
>     please let me know.
>
>     Each contribution has a date attached - so maybe someone wants to
>     play with this data in Timemanager for a small animation?
>
>     Greetings,
>
>     Andreas
>
>     _______________________________________________
>     Qgis-psc mailing list
>     Qgis-psc at lists.osgeo.org <mailto:Qgis-psc at lists.osgeo.org>
>     https://lists.osgeo.org/mailman/listinfo/qgis-psc
>     <https://lists.osgeo.org/mailman/listinfo/qgis-psc>
>
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-psc/attachments/20170214/7e404550/attachment.html>