- From: Jeni Tennison <jeni@jenitennison.com>
- Date: Tue, 17 Jun 2014 09:59:09 +0100
- To: CSV on the Web Working Group <public-csv-wg@w3.org>, Tandy, Jeremy <jeremy.tandy@metoffice.gov.uk>
Jeremy, As currently specced, the ‘columns’ array in the metadata document (‘fields’ is used in datapackage.json) is an ordered list and the columns are matched by position. See [1]. As currently specced, the ‘title’ property [2] is a natural language property [3] which means that you can use the JSON-LD pattern for @type: @language properties, like this: "title": { "en": "Date-time", "fr": "Date et l’heure" } Jeni [1] http://w3c.github.io/csvw/metadata/#schema-columns [2] http://w3c.github.io/csvw/metadata/#column-title [3] http://w3c.github.io/csvw/metadata/#dfn-natural-language-property ------------------------------------------------------ From: Tandy, Jeremy jeremy.tandy@metoffice.gov.uk Reply: Tandy, Jeremy jeremy.tandy@metoffice.gov.uk Date: 16 June 2014 at 09:35:00 To: Jeni Tennison jeni@jenitennison.com, CSV on the Web Working Group public-csv-wg@w3.org Subject: RE: Names & Titles (Was: Re: Attempted example CSV metadata document and template) > Hi Jeni - > > Thanks for the clarification; I've updated the example (see below) ... and changed the > filename to ".json". > > One question: is the "fields" array in the metadata document an ordered list, or do we > expect parsers to match against the titles? > > Regarding the updated example [1], I've been a bit provocative and used JSON-LD syntax > to provide the titles in both English and French. Presumably this is OK too? > > > "schema": {"fields": [ > { > "name": "datetime", > "title": [ > {"@value": "Date-time", "@language": "en"}, > {"@value": "Date et l'heure", "@language": "fr"} > ], > "description": "Date-time that the observation occurred.", > "type": "dateTime", > "format": "YYYY-MM-DDThh:mm:ssZ", > "constraints": { > "required": true > } > }, > { > "name": "air-temp", > "title": [ > {"@value": "Air temperature (Cel)", "@language": "en"}, > {"@value": "La température d'air (C)", "@language": "fr"} > ], > "description": "Air temperature quantity value expressed in Celsius.", > "type": "double", > "constraints": {"required": true} > }, > { > "name": "dew-point-temp", > "title": [ > {"@value": "Dew-point temperature (Cel)", "@language": "en"}, > {"@value": "Température du point de rosée (C)", "@language": "fr"} > ], > "description": "Dew-point temperature quantity value expressed in Celsius.", > "type": "double", > "constraints": {"required": true} > } > ]} > > Jeremy > > > [1]: https://github.com/w3c/csvw/blob/gh-pages/examples/csv-metadata-and-template-for-simple-weather-obs-example.md > > > -----Original Message----- > > From: Jeni Tennison [mailto:jeni@jenitennison.com] > > Sent: 15 June 2014 12:32 > > To: CSV on the Web Working Group; Tandy, Jeremy > > Subject: Names & Titles (Was: Re: Attempted example CSV metadata > > document and template) > > > > Jeremy, thanks for doing this. It’s always good to have a worked > > example. > > > > Regarding names and titles (and ‘short names’ that you’ve introduced). > > The intention in the metadata document is for the `name` property to be > > the equivalent to the `short-name` in your example: the canonical, > > unique, column name that can be used as the basis for conversions. See > > [1]. > > > > The `title` property is for human-readable names. If there are several > > of these in a particular language then you can use an array. For > > example, you could have: > > > > { > > "name": "dew-point-temp", > > "title": [ > > "Dew-point temperature (Cel)", > > "Dew-point temperature (Celsius)" > > ], > > ... > > } > > > > to indicate that both "Dew-point temperature (Cel)" and "Dew-point > > temperature (Celsius)" are acceptable titles (to appear in the header > > line of a CSV file that adheres to the schema) but that the name `dew- > > point-temp` is the one to use in references to the column (eg within > > the metadata file), and in conversions into other formats. > > > > Does that seem reasonable? > > > > Cheers, > > > > Jeni > > > > [1] http://w3c.github.io/csvw/metadata/#column-name > > > > ------------------------------------------------------ > > From: Tandy, Jeremy jeremy.tandy@metoffice.gov.uk > > Reply: Tandy, Jeremy jeremy.tandy@metoffice.gov.uk > > Date: 12 June 2014 at 13:02:43 > > To: CSV on the Web Working Group public-csv-wg@w3.org > > Subject: Attempted example CSV metadata document and template > > > > > All - > > > > > > I've just uploaded to [GitHub][1] a rework of the "Simple Weather > > Observation" example. > > > I've tried to create a CSV metadata document following the rules in > > > the [Metadata Vocabulary for Tabular Data][2] and [Generating RDF > > from Tabular Data on the Web][3] documents. > > > > > > I would be particularly interested in: > > > > > > - corrections to errors! > > > - comments on additional proposed properties in the metadata document > > > ("short-name", "template", "microsyntax") > > > - use of "hasFormat" to specify the Content-Type associated with a > > > Template > > > - use of a REGEXP within a URI Template to convert ISO 8601 syntax to > > > a simplified form > > > - thoughts about a way to describe that microsyntax format within the > > > metadata document (see CellMicrosyntax requirement][4]), e.g. to > > > define the sub-elements within the microsyntax that may be extracted > > for use later - see [Parsing cell microsyntax][5]. > > > > > > Comments welcome. > > > > > > Jeremy > > > > > > > > > [1]: > > > https://github.com/w3c/csvw/blob/gh-pages/examples/csv-metadata-and- > > te > > > mplate-for-simple-weather-obs-example.md > > > [2]: http://w3c.github.io/csvw/metadata/index.html > > > [3]: http://w3c.github.io/csvw/csv2rdf/ > > > [4]: > > > http://w3c.github.io/csvw/use-cases-and-requirements/#R- > > CellMicrosynta > > > x > > > [5]: > > > https://github.com/w3c/csvw/blob/gh-pages/examples/csv-metadata-and- > > te > > > mplate-for-simple-weather-obs-example.md#parsing-cell-microsyntax > > > > > > > > > > > > > -- > > Jeni Tennison > > http://www.jenitennison.com/ > -- Jeni Tennison http://www.jenitennison.com/
Received on Tuesday, 17 June 2014 08:59:38 UTC