[wdmmg-discuss] CSV schema of user uploaded spending data

Tue Mar 1 12:23:22 UTC 2011

Hi Chris,

> I'm not sure whether this is directly connected, but one thing I wanted to say about the datadump (I downloaded, but couldn't find a list of the headings) is that it doesn't seem to have full provenance information for the data. As a potential reuser, I'd always want to know where the data came from, so I could get additional info, so I could verify the data, and so that problems with the data are notifiable to the original publisher. 
> On the OpenlyLocal spending data, when financial_transactions are imported of the spending data there is full provenance, with not just the URL of the CSV file but also the line number the transaction was imported from (as well of course as the creation date). This has helped the publishers of the information discover probelms in their data, or with the importing of the data, and also provides the attribution that the OGL requires.

Thanks for raising the issue. We will keep track of the CSV file line in the imported entry and we also store additional meta data with the dataset. We collect meta data about the dataset from the user in a form. If you have a list in mind of what we should ask the uploader to provide in addition to 
name, description, license, origin URL, copyright holder
please share here or in the wiki.

Cheers,
Stefan

> 
> Would be great if we could establish this as a standard.
> 
> Cheers
> Chris
> 
> On 1 March 2011 11:48, Stefan Wehrmeyer <stefanwehrmeyer at gmail.com> wrote:
> Hi everybody,
> 
> based on the Technical Format (http://wiki.openspending.org/Technical_Format) I have written a user guide to creating a conforming CSV file for user uploaded datasets.
> The article is addressed to users who have data to contribute and who can make our work easier by transforming the data into the exact schema that is defined in here:
> 
> http://wiki.openspending.org/CSV_Schema
> 
> This is the first iteration and a simple loader that can read it will be implemented. Please have a look and give feedback.
> 
> Cheers,
> Stefan
> _______________________________________________
> wdmmg-discuss mailing list
> wdmmg-discuss at lists.okfn.org
> http://lists.okfn.org/mailman/listinfo/wdmmg-discuss
> 
> 
> 
> -- 
> -------------------------------------------------------
> OpenCorporates :: The Open Database of the Corporate World http://opencorporates.com
> OpenlyLocal :: Making Local Government More Transparent http://openlylocal.com
> Blog: http://countculture.wordpress.com
> Twitter: http://twitter.com/CountCulture