[openspending-dev] CAP and fisheries data

[Stefan Wehrmeyer]

Hi,

the data inside farmsubsidy.openspending.org is based on the CSV files by Nils Mulvad.
I cleaned them up to allow a direct import into a Postgres database.

The cleaned up data per country is currently available here:
http://data.farmsubsidy.org/

If someone cares to move this to the best place, I'd appreciate.

The fixes are documented in this script: 
https://gist.github.com/stefanw/39375774d1d304353624

Cheers
Stefan

On 02.07.2013, at 21:26 , Friedrich Lindenberg <friedrich.lindenberg at okfn.org> wrote:

> Chatted with Anders, now uploading this stuff to data.openspending.org/datasets/eu-cap (rest of the world has farm subsidies, too :)
> 
> - Friedrich 
> 
> 
> On Tue, Jul 2, 2013 at 4:45 PM, Rufus Pollock <rufus.pollock at okfn.org> wrote:
> In terms of download any way we could partition the data and push to s3 (data.openspending.org/datasets/farmsubsidy seems the natural location).
> 
> Partitioning may not be necessary but it has the attraction that we don't have to replace the one big file each time there are updates ...
> 
> Rufus
> 
> 
> On 2 July 2013 14:36, Anders Pedersen <anders.pedersen at okfn.org> wrote:
> Hi David, 
> 
> Thanks for your email. We just recently completed the transfer of the farmsubsidy data to farmsubsidy.openspending.org. 
> 
> I have created an issue ticket for the missing download option:
> https://github.com/openspending/farmsubsidy.org/issues/1
> 
> If anyone on the list would want to have a look at farm subsidy, let know!
> 
> I'm not currently aware of alternative ways to make the data available, but agree that this is unfortunate. 
> 
> The CAP data on farmsubsidy.openspending.org does not include fish subsidies. These are available over at our friends at: 
> fishsubsidy.org
> 
> Best,
> Anders
> 
> On 2 July 2013 08:25, Evers, David <David.Evers at pbl.nl> wrote:
> I’m a researcher working for a national government institute and have made a map of all kinds of EU policies in the Netherlands (Natura2000, air quality directive, structural funds, serveso, WFD, etc.). I have data from my own country on  CAP, but I’d like to check it with yours, and see how the Netherlands stands in comparison with some other countries. I don’t have information on fisheries, so that is something which will definitely improve my map.
> 
>  
> 
> Unfortunately after registering, I was not given a link to the database.
> 
> Could you please send that to me? I of course agree to your terms & conditions.
> 
>  
> 
> Kind regards,
> 
>  
> 
>  
> 
>  
> 
> David Evers, PhD
> Senior Reseacher Spatial Planning
> 
> .................................................................................................
> Department of Spatial Planning and Environmental Quality (ROL)
> Netherlands Environmental Assessment Agency
> Oranjebuitensingel 6 | 2511 VE  | The Hague| Room 223
> 
> Postbus 30314  | 2500 GH | The Hague | The Netherlands
> ..................................................................................................
> Tel +31 (0)70 - 328 8773
> 
> Fax +31 (0)70 - 328 8799
> 
> Cell +31 (0)6 24 090 173
> 
>  
> 
>  
> 
> 
> 
>  
> 
>  
> 
> 
> 
> 
> -- 
> Anders Pedersen
> Community Coordinator  |  skype: anpehej  |  @anpe
> The Open Knowledge Foundation
> Empowering through Open Knowledge
> http://okfn.org/  |  @okfn  |  OKF on Facebook  |  Blog  |  Newsletter
> 
> OpenSpending | http://openspending.org | @openspending 
> School of Data | http://schoolofdata.org | @schoolofdata
> 
> 
> 
> 
> 
> _______________________________________________
> openspending-dev mailing list
> openspending-dev at lists.okfn.org
> http://lists.okfn.org/mailman/listinfo/openspending-dev
> Unsubscribe: http://lists.okfn.org/mailman/options/openspending-dev
> 
> 
> 
> 
> -- 
> Rufus Pollock
> Founder and Co-Director  |  skype: rufuspollock  |  @rufuspollock
> The Open Knowledge Foundation
> Empowering through Open Knowledge
> http://okfn.org/  |  @okfn  |  OKF on Facebook  |  Blog  |  Newsletter
> 
> 
> 
> _______________________________________________
> openspending-dev mailing list
> openspending-dev at lists.okfn.org
> http://lists.okfn.org/mailman/listinfo/openspending-dev
> Unsubscribe: http://lists.okfn.org/mailman/options/openspending-dev
> 
> 
> _______________________________________________
> openspending-dev mailing list
> openspending-dev at lists.okfn.org
> http://lists.okfn.org/mailman/listinfo/openspending-dev
> Unsubscribe: http://lists.okfn.org/mailman/options/openspending-dev

-- 
Stefan Wehrmeyer
Projektleiter FragDenStaat.de
stefan.wehrmeyer at okfn.org
+49 151 15550559
Open Knowledge Foundation Deutschland e.V.
Gneisenaustr. 52 
10961 Berlin
http://www.okfn.de

Spenden Sie für FragDenStaat.de:
https://fragdenstaat.de/hilfe/spenden/