W3C home > Mailing lists > Public > public-csvw@w3.org > May 2021

Re: Seeking someone to who is using W3C CSVW

From: Jeff de La Beaujardiere <jeffdlb@ucar.edu>
Date: Tue, 25 May 2021 10:32:46 -0600
Message-ID: <CACBJxOmr3OwmAn0_5Pazca1VK5JQNVC=1iVYh4tMG3pMbZFdXw@mail.gmail.com>
To: Paolo Starace <paolo@sciamlab.com>
Cc: Jakub Klímek <jakub@jakubklimek.com>, public-csvw@w3.org, Alessio Dragoni <ad@sciamlab.com>
Ciao Paolo-

Thank you for your response and your example. We are also using CKAN, so
this is doubly helpful. It seems you have at least 16 datasets that have an
associated CSVW description:
http://dati.mit.gov.it/catalog/dataset?q=csvw

Grazie mille,
J-F


On Tue, May 25, 2021 at 3:43 AM Paolo Starace <paolo@sciamlab.com> wrote:

> Hi Jeff we also applied that approach for publishing data of Italian
> Transportation Ministry (dati.mit.gov.it) using CKAN (currently in
> production since 2016). As an example look at "Certified Airports" dataset
> at http://dati.mit.gov.it/catalog/dataset/aeroporti-certificati
>
> [image: image.png]
>
> We uploaded a JSON resource to store column metadata and linked the CSV to
> it. As per the standard, downloading the CSV you get the reference to the
> JSON file in the Link response header.
>
> $ curl -I
> http://dati.mit.gov.it/catalog/dataset/4c6f7318-05d5-4361-b83e-7de05ab2d512/resource/bbdebc60-a96b-4702-810b-62092f14de0c/download/anagrafica-aereoporti-nuovo-dataset.csv
>
> HTTP/1.1 200 OK
> Date: Tue, 25 May 2021 09:30:17 GMT
> Server: Apache/2.4.7 (Ubuntu)
> Pragma: no-cache
> Cache-Control: no-cache
>
> *Link:
> http://dati.mit.gov.it/catalog/dataset/4c6f7318-05d5-4361-b83e-7de05ab2d512/resource/b4759e84-0ea7-48c9-997d-4d3eaa41e55c/download/metadata.json
> <http://dati.mit.gov.it/catalog/dataset/4c6f7318-05d5-4361-b83e-7de05ab2d512/resource/b4759e84-0ea7-48c9-997d-4d3eaa41e55c/download/metadata.json>;
> rel="describedBy"; type="application/csvm+json"*Accept-Ranges: bytes
> Last-Modified: Tue, 03 Dec 2019 08:50:19 GMT
> Content-Range: bytes 0-15828/15829
> ETag: "1575363019.81-15829"
> Content-Length: 15829
> Content-Type: text/csv
> Set-Cookie: cookiesession1=678B2877JKLMNOPRSTUVWXYZABCD6DB0;Expires=Wed,
> 25 May 2022 09:30:17 GMT;Path=/;HttpOnly
>
> Ciao,
> Paolo
>
> On Tue, May 25, 2021 at 10:22 AM Jakub Klímek <jakub@jakubklimek.com>
> wrote:
>
>> Hello,
>>
>> We are using CSVW in the following contexts:
>>
>>    1. Ministry of the Interior of the Czech Republic recommends CSVW as
>>    a way of adding a schema and RDF mappings to CSV files published as open
>>    data in the Czech Republic. It publishes code lists in this way (
>>    https://data.gov.cz/datasets?publisher=https%3A%2F%2Frpp-opendata.egon.gov.cz%2Fodrpp%2Fzdroj%2Forgán-veřejné-moci%2F00007064&keywords=codelist
>>    <https://data.gov.cz/datasets?publisher=https%3A%2F%2Frpp-opendata.egon.gov.cz%2Fodrpp%2Fzdroj%2Forg%C3%A1n-ve%C5%99ejn%C3%A9-moci%2F00007064&keywords=codelist>
>>    )
>>    2. at Charles University, Prague, Czech Republic bachelor students
>>    are taught to use CSVW for schemas and RDF mappings in the Data Formats
>>    course (https://www.youtube.com/watch?v=0jmPhwbvpOY)
>>    3. CSVW default mapping is used in the LinkedPipes ETL tabular
>>    component (https://etl.linkedpipes.com/components/t-tabular) and uses
>>    in many CSV to RDF data transformation pipelines
>>
>> It is true, however, that proper implementations are missing, with
>> https://github.com/ruby-rdf/rdf-tabular being the only usable tool for
>> me at the moment.
>>
>> Best regards,
>>
>> Jakub Klímek
>>
>> On Tue, May 25, 2021 at 10:01 AM Jeff de La Beaujardiere <
>> jeffdlb@ucar.edu> wrote:
>>
>>> Hello-
>>>
>>> My group at the US National Center for Atmospheric Research (NCAR) is
>>> considering using W3C's CSV on the Web recommendation as a means of
>>> documenting the internal structure of  observational data files
>>> provided to us in ASCII CSV format. CSVW seems like a good choice, but
>>> I am concerned that the mailing list seems very quiet and that perhaps
>>> nobody is using this approach. Do any of you work with, or know of,
>>> any groups or data centers using CSVW routinely?
>>>
>>> Many thanks,
>>> Jeff DLB
>>>
>>> J-F de La Beaujardiere, PhD
>>> Director, NCAR/CISL Information Systems Division
>>> https://staff.ucar.edu/users/jeffdlb
>>> https://orcid.org/0000-0002-1001-9210
>>>
>>>
>>>

image.png
(image/png attachment: image.png)

Received on Tuesday, 25 May 2021 16:34:24 UTC

This archive was generated by hypermail 2.4.0 : Tuesday, 25 May 2021 16:34:27 UTC