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

Re: Seeking someone to who is using W3C CSVW

From: Paolo Starace <paolo@sciamlab.com>
Date: Tue, 25 May 2021 11:43:39 +0200
Message-ID: <CAJTPHYNBjVWEu5uGVWg=RehRGXDt=ywwTb3fZOn_2eayKF4S_g@mail.gmail.com>
To: Jakub Klímek <jakub@jakubklimek.com>
Cc: Jeff de La Beaujardiere <jeffdlb@ucar.edu>, public-csvw@w3.org, Alessio Dragoni <ad@sciamlab.com>
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 09:45:39 UTC

This archive was generated by hypermail 2.4.0 : Tuesday, 25 May 2021 09:45:40 UTC