[ckan-dev] Resource formats on the DataHub

Thu Jun 14 09:12:51 UTC 2012

Hi Timothy,

This is the command I run to get the CSV file:

$ echo "copy (select format, count(*) from resource group by format
order by count(*) desc) to stdout with CSV HEADER" | psql -d
<your-database> -h <your-host> -o 'tdh_resource_formats.csv'

Hope this helps,

Adrià

On 12 June 2012 14:13, Timothy Lebo <lebot at rpi.edu> wrote:
> Adrià.
>
> Thanks for the survey of formats.
> What is the easiest way to reproduce these results?
>
> Thanks,
> Tim
>
> On May 30, 2012, at 11:38 AM, Adrià Mercader wrote:
>
>> Hi,
>>
>> I wanted to know the current resource formats on TDH for my current
>> work, but I'm sending the stats here in case anyone is interested.
>> Maybe they are useful for some of the current discussions.
>>
>> Extract of the first 10 rows:
>>
>> format,count
>> "",1745
>> example/rdf+xml,558
>> api/sparql,417
>> text/csv,329
>> application/rdf+xml,289
>> CSV,229
>> XLS,220
>> application/pdf,204
>> meta/void,199
>> Spreadsheet,197
>>
>>
>> Adrià
>> <tdh_resource_formats.csv>_______________________________________________
>> ckan-dev mailing list
>> ckan-dev at lists.okfn.org
>> http://lists.okfn.org/mailman/listinfo/ckan-dev
>
>
> _______________________________________________
> ckan-dev mailing list
> ckan-dev at lists.okfn.org
> http://lists.okfn.org/mailman/listinfo/ckan-dev