[ckan-dev] Resource formats on the DataHub

Thu Jun 14 17:02:00 UTC 2012

Thanks!

-Tim

On Thu, Jun 14, 2012 at 5:12 AM, Adrià Mercader <amercadero at gmail.com> wrote:
> 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
>
> _______________________________________________
> ckan-dev mailing list
> ckan-dev at lists.okfn.org
> http://lists.okfn.org/mailman/listinfo/ckan-dev