delete: <a href="http://www.w3.org/"> delete: <img width="72" height="48" src="https://www.w3.org/Icons/w3c_home" alt="W3C"> insert: <a class="logo" href="http://www.w3.org/"> insert: <img src="https://www.w3.org/Icons/w3c_home" alt="W3C" height="48" width="72">
Please check the insert: <a href="http://www.w3.org/2013/csvw/errata/"> insert: <strong> errata insert: </strong> insert: </a> for any errors or issues reported since publication. insert: </p>
insert: <p>This document is also available in this non-normative format: insert: <a rel="alternate" href="csv2rdf.epub"> ePub insert: </a> insert: </p>
insert: <p>The English version of this specification is the only normative version. Non-normative insert: <a href="http://www.w3.org/Consortium/Translation/"> translations insert: </a> may also be available. insert: </p>
Copyright © 2015 W3C ® ( MIT , ERCIM , Keio , Beihang ). W3C liability , trademark and document use rules apply.
delete: <hr> insert: <hr title="Separator for header">This document defines the procedures and rules to be applied when converting tabular data into RDF. Tabular data may be complemented with metadata annotations that describe its structure, the meaning of its content and how it may form part of a collection of interrelated tabular data. This document specifies the effect of this metadata on the resulting RDF.
This section describes the status of this document at the time of its publication. Other documents may supersede this document. A list of current W3C publications and the latest revision of this technical report can be found in the W3C technical reports index at http://www.w3.org/TR/.
The CSV on the Web Working Group was chartered to produce a recommendation "Access methods for CSV Metadata" as well as recommendations for "Metadata vocabulary for CSV data" and "Mapping mechanism to transforming CSV into various formats (e.g., RDF, JSON, or XML)". This document aims to satisfy the RDF variant of the mapping recommendation.
This document was published by the CSV on the Web Working Group as a Proposed Recommendation. If you wish to make comments regarding this document, please send them to insert: <a href="mailto:public-csv-wg@w3.org"> public-csv-wg@w3.org insert: </a> ( insert: <a href="mailto:public-csv-wg-request@w3.org?subject=subscribe"> subscribe insert: </a> , insert: <a href="http://lists.w3.org/Archives/Public/public-csv-wg/"> archives insert: </a> ). All comments are welcome. insert: </p>
insert: <p>Please see the Working Group's insert: <a href="http://www.w3.org/2013/csvw/implementation_report.html"> implementation report insert: </a> . insert: </p>
insert: <p>This document has been reviewed by insert: <abbr title="World Wide Web Consortium"> W3C insert: </abbr> Members, by software developers, and by other insert: <abbr title="World Wide Web Consortium"> W3C insert: </abbr> groups and interested parties, and is intended to become endorsed by the Director as a W3C Recommendation. The delete: <abbr title="World Wide Web Consortium"> W3C delete: </abbr> Membership and other interested parties are invited to review the document and send comments to delete: <a rel="discussion" href="mailto:public-csv-wg@w3.org"> public-csv-wg@w3.org delete: </a> ( delete: <a href="mailto:public-csv-wg-request@w3.org?subject=subscribe"> subscribe delete: </a> , delete: <a href="http://lists.w3.org/Archives/Public/public-csv-wg/"> archives delete: </a> ) through 15 December 2015. Advisory Committee Representatives should consult their delete: <a href="https://www.w3.org/2002/09/wbs/myQuestionnaires"> WBS questionnaires delete: </a> . Note that substantive technical comments were expected during the Last Call review period that ended 30 October 2015. delete: </p> delete: <p> Please see the Working Group's delete: <a href="http://www.w3.org/2013/csvw/implementation_report.html"> implementation report delete: </a> . delete: </p> delete: <p> Publication as a Proposed Recommendation does not imply endorsement by the delete: <abbr title="World Wide Web Consortium"> W3C delete: </abbr> Membership. This It is a draft stable document and may be updated, replaced used as reference material or obsoleted by other documents at any time. It cited from another document. insert: <abbr title="World Wide Web Consortium"> W3C insert: </abbr> 's role in making the Recommendation is inappropriate to cite this document as other than work in progress. draw attention to the specification and to promote its widespread deployment. This enhances the functionality and interoperability of the Web.
This document was produced by a group operating under the 5 February 2004 W3C Patent Policy . W3C maintains a public list of any patent disclosures made in connection with the deliverables of the group; that page also includes instructions for disclosing a patent. An individual who has actual knowledge of a patent which the individual believes contains Essential Claim(s) must disclose the information in accordance with section 6 of the W3C Patent Policy .
This document is governed by the 1 September 2015 W3C Process Document .
This document describes the processing of delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-tabular-data" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-tabular-data" class="externalDFN"> tabular data to create an RDF subject-predicate-object triples [ delete: <a class="bibref" href="#bib-rdf11-concepts"> insert: <a href="#bib-rdf11-concepts" class="bibref"> rdf11-concepts ]. Since RDF is an abstract syntax , these triples delete: <em class="rfc2119" title="MAY"> insert: <em title="MAY" class="rfc2119"> MAY be serialized in a concrete RDF syntax such as N-Triples [ delete: <a class="bibref" href="#bib-n-triples"> insert: <a href="#bib-n-triples" class="bibref"> n-triples ], Turtle [ delete: <a class="bibref" href="#bib-turtle"> insert: <a href="#bib-turtle" class="bibref"> turtle ], RDFa [ delete: <a class="bibref" href="#bib-rdfa-primer"> insert: <a href="#bib-rdfa-primer" class="bibref"> rdfa-primer ], JSON-LD [ delete: <a class="bibref" href="#bib-json-ld"> insert: <a href="#bib-json-ld" class="bibref"> json-ld ], or TriG [ delete: <a class="bibref" href="#bib-trig"> insert: <a href="#bib-trig" class="bibref"> trig ]. The RDF serializations offered by a conversion application is implementation defined.
The [ delete: <a class="bibref" href="#bib-tabular-data-model"> insert: <a href="#bib-tabular-data-model" class="bibref"> tabular-data-model ] defines an delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-annotated-tabular-data-model" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-annotated-tabular-data-model" class="externalDFN"> annotated tabular data model consisting of delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-table" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-table" class="externalDFN"> tables , delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-column" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-column" class="externalDFN"> columns , delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-row" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-row" class="externalDFN"> rows , and delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-cell" class="externalDFN"> cells , enriched with delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-annotations" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-annotation" class="externalDFN"> annotations that describe the structure of the delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-tabular-data" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-tabular-data" class="externalDFN"> tabular data and the meaning of its content. A delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-group-of-tables" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-group-of-tables" class="externalDFN"> group of tables is a collection of delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-table" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-table" class="externalDFN"> tables published as a single atomic unit.
The conversion procedure described in this specification operates on the delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-annotated-tabular-data-model" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-annotated-tabular-data-model" class="externalDFN"> annotated tabular data model . This specification does not specify the processes needed to convert CSV-encoded data into tabular data form. Please refer to [ delete: <a class="bibref" href="#bib-tabular-data-model"> insert: <a href="#bib-tabular-data-model" class="bibref"> tabular-data-model ] for details of delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#parsing"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#parsing"> parsing tabular data .
Conversion applications delete: <em class="rfc2119" title="MUST"> insert: <em title="MUST" class="rfc2119"> MUST provide at least two modes of operation: delete: <a href="#dfn-standard-mode" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-standard-mode"> standard and delete: <a href="#dfn-minimal-mode" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-minimal-mode"> minimal .
delete: <dfn data-dfn-type="dfn" id="dfn-standard-mode"> insert: <dfn id="dfn-standard-mode" data-dfn-type="dfn"> Standard mode conversion frames the information gleaned from the delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-cell" class="externalDFN"> cells of the delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-tabular-data" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-tabular-data" class="externalDFN"> tabular data with details of the delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-row" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-row" class="externalDFN"> rows , delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-table" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-table" class="externalDFN"> tables , and a delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-group-of-tables" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-group-of-tables" class="externalDFN"> group of tables within which that information is provided.
delete: <dfn data-dfn-type="dfn" id="dfn-minimal-mode"> insert: <dfn id="dfn-minimal-mode" data-dfn-type="dfn"> Minimal mode conversion includes only the information gleaned from the delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-cell" class="externalDFN"> cells of the delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-tabular-data" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-tabular-data" class="externalDFN"> tabular data .
delete: <a href="#dfn-standard-mode" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-standard-mode"> Standard and delete: <a href="#dfn-minimal-mode" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-minimal-mode"> minimal conversion are described normatively below .
Conversion applications delete: <em class="rfc2119" title="MAY"> insert: <em title="MAY" class="rfc2119"> MAY offer additional implementation specific conversion modes.
delete: <a href="http://www.w3.org/TR/2015/PR-tabular-metadata-20151117/#dfn-transformation-definition" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-metadata-20151217/#dfn-transformation-definition" class="externalDFN"> Transformation definitions , as defined in [ delete: <a class="bibref" href="#bib-tabular-metadata"> insert: <a href="#bib-tabular-metadata" class="bibref"> tabular-metadata ] delete: <em class="rfc2119" title="MAY"> insert: <em title="MAY" class="rfc2119"> MAY be used to specify how delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-tabular-data" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-tabular-data" class="externalDFN"> tabular data can be transformed into another format using a script or template. Such delete: <a href="http://www.w3.org/TR/2015/PR-tabular-metadata-20151117/#dfn-transformation-definition" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-metadata-20151217/#dfn-transformation-definition" class="externalDFN"> transformation definitions delete: <em class="rfc2119" title="MAY"> insert: <em title="MAY" class="rfc2119"> MAY use the RDF output described in this specification as input.
There is no requirement on conversion applications to check the semantic consistency of the data during the conversion, nor to validate the triples against RDF schema. Downstream applications delete: <em class="rfc2119" title="SHOULD"> insert: <em title="SHOULD" class="rfc2119"> SHOULD be aware of the potential for inconsistencies and take appropriate action.
As well as sections marked as non-normative, all authoring guidelines, diagrams, examples, and notes in this specification are non-normative. Everything else in this specification is normative.
The key words MAY , MUST , and SHOULD are to be interpreted as described in [ delete: <a class="bibref" href="#bib-RFC2119"> insert: <a href="#bib-RFC2119" class="bibref"> RFC2119 ].
delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-tabular-data" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-tabular-data" class="externalDFN"> Tabular data delete: <em class="rfc2119" title="MUST"> insert: <em title="MUST" class="rfc2119"> MUST conform to the description from [ delete: <a class="bibref" href="#bib-tabular-data-model"> insert: <a href="#bib-tabular-data-model" class="bibref"> tabular-data-model ]. In particular note that each delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-row" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-row" class="externalDFN"> row delete: <em class="rfc2119" title="MUST"> insert: <em title="MUST" class="rfc2119"> MUST contain the same number of delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-cell" class="externalDFN"> cells (although some of these delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-cell" class="externalDFN"> cells may be empty).
Not all CSV-encoded data can be parsed into a tabular data model. An algorithm for parsing CSV-based files is described in [ delete: <a class="bibref" href="#bib-tabular-data-model"> insert: <a href="#bib-tabular-data-model" class="bibref"> tabular-data-model ].
This specification makes use of the delete: <dfn data-dfn-type="dfn" id="dfn-compact-iri-syntax"> insert: <dfn id="dfn-compact-iri-syntax" data-dfn-type="dfn"> compact IRI Syntax ; please refer to the Compact IRIs from [ delete: <a class="bibref" href="#bib-json-ld"> insert: <a href="#bib-json-ld" class="bibref"> json-ld ].
This specification makes use of the following namespaces:
csvw
: http://www.w3.org/ns/csvw#
rdf
: http://www.w3.org/1999/02/22-rdf-syntax-ns#
xsd
: http://www.w3.org/2001/XMLSchema#
The following typographic conventions are used in this specification:
markup
markup definition reference
markup external definition reference
Notes are in light green boxes with a green left border and with a "Note" header in green. Notes are normative or informative depending on the whether they are in a normative or informative section, respectively.
Examples are in light khaki boxes, with khaki left border, and with a numbered "Example" header in khaki. Examples are always informative. The content of the example is in monospace font and may be syntax colored.
The procedures for converting delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-tabular-data" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-tabular-data" class="externalDFN"> tabular data into RDF are described below for both delete: <a href="#dfn-standard-mode" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-standard-mode"> standard and delete: <a href="#dfn-minimal-mode" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-minimal-mode"> minimal modes.
delete: <section id="algorithm-terms" typeof="bibo:Chapter" resource="#algorithm-terms" property="bibo:hasPart"> delete: <h3 id="h-algorithm-terms" resource="#h-algorithm-terms"> insert: <section property="bibo:hasPart" resource="#algorithm-terms" typeof="bibo:Chapter" id="algorithm-terms"> null
or a sequence of values. notes
property. This may be an empty list. prefix : name
. See delete: <a href="http://www.w3.org/TR/2015/PR-tabular-metadata-20151117/#names-of-common-properties"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-metadata-20151217/#names-of-common-properties"> Names of Common Properties in [ delete: <a class="bibref" href="#bib-tabular-metadata"> insert: <a href="#bib-tabular-metadata" class="bibref"> tabular-metadata ] for information on expansion. null
. A conformant RDF conversion application delete: <em class="rfc2119" title="MUST"> insert: <em title="MUST" class="rfc2119"> MUST emit triples conforming to those described in this algorithm according to the chosen mode of conversion: delete: <a href="#dfn-standard-mode" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-standard-mode"> standard or delete: <a href="#dfn-minimal-mode" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-minimal-mode"> minimal .
Unless specified otherwise, the steps in the algorithm defined herein apply to both delete: <a href="#dfn-standard-mode" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-standard-mode"> standard and delete: <a href="#dfn-minimal-mode" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-minimal-mode"> minimal modes.
Where an delete: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-annotated-table"> annotated table is defined in isolation (e.g. in the absence of a delete: <a href="#dfn-group-of-tables" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-group-of-tables"> group of tables ), a default delete: <a href="#dfn-group-of-tables" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-group-of-tables"> group of tables is provided with a single delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-table-group-tables" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-table-group-tables" class="externalDFN"> tables annotation that refers to the given delete: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-annotated-table"> table .
The [ delete: <a class="bibref" href="#bib-tabular-data-model"> insert: <a href="#bib-tabular-data-model" class="bibref"> tabular-data-model ] specifies that string values within delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-tabular-data" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-tabular-data" class="externalDFN"> tabular data (such as delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-column-titles" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-column-titles" class="externalDFN"> column titles or delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-string-value" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-cell-string-value" class="externalDFN"> cell string values ) delete: <em class="rfc2119" title="MUST"> insert: <em title="MUST" class="rfc2119"> MUST contain only Unicode characters. No Unicode normalization (as specified in [ delete: <a class="bibref" href="#bib-UAX15"> insert: <a href="#bib-UAX15" class="bibref"> UAX15 ]) is applied to these string values during the conversion to RDF.
If a CSV file is originally encoded as UTF-8, it should not go through Unicode normalization during parsing, nor in conversion to RDF. This can result in RDF literals that are not in Normal Form C as they should be according to [ delete: <a class="bibref" href="#bib-rdf11-concepts"> insert: <a href="#bib-rdf11-concepts" class="bibref"> rdf11-concepts ].
null
, then delete: <a href="#dfn-node" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-node"> node G delete: <em class="rfc2119" title="MUST"> insert: <em title="MUST" class="rfc2119"> MUST be a new delete: <a href="#dfn-blank-node" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-blank-node"> blank node . In delete: <a href="#dfn-standard-mode" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-standard-mode"> standard mode only, specify the type of delete: <a href="#dfn-node" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-node"> node G as csvw:TableGroup
; emit the following triple:
rdf:type
csvw:TableGroup
In delete: <a href="#dfn-standard-mode" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-standard-mode"> standard mode only, emit the triples generated by running the algorithm specified in section 6. JSON-LD to RDF over any delete: <a href="#dfn-notes" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-notes"> notes and delete: <a href="#dfn-non-core-annotations" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-non-core-annotations"> non-core annotations specified for the delete: <a href="#dfn-group-of-tables" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-group-of-tables"> group of tables , with delete: <a href="#dfn-node" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-node"> node G as an initial subject , the delete: <a href="#dfn-notes" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-notes"> notes or delete: <a href="#dfn-non-core-annotations" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-non-core-annotations"> non-core annotation as property , and the value of the delete: <a href="#dfn-notes" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-notes"> notes or delete: <a href="#dfn-non-core-annotations" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-non-core-annotations"> non-core annotation as value .
For each delete: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-annotated-table"> table where the delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-table-suppress-output" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-table-suppress-output" class="externalDFN"> suppress output annotation is false
:
In delete: <a href="#dfn-standard-mode" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-standard-mode"> standard mode only, establish a new delete: <a href="#dfn-node" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-node"> node T which represents the current delete: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-annotated-table"> table .
If the delete: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-annotated-table"> table has an delete: <a data-lt="table identifier" href="#dfn-table-identifier" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-table-identifier" data-lt="table identifier"> identifier then delete: <a href="#dfn-node" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-node"> node T delete: <em class="rfc2119" title="MUST"> insert: <em title="MUST" class="rfc2119"> MUST be identified accordingly; else if delete: <a data-lt="table identifier" href="#dfn-table-identifier" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-table-identifier" data-lt="table identifier"> identifier is null
, then delete: <a href="#dfn-node" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-node"> node T delete: <em class="rfc2119" title="MUST"> insert: <em title="MUST" class="rfc2119"> MUST be a new delete: <a href="#dfn-blank-node" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-blank-node"> blank node .
In delete: <a href="#dfn-standard-mode" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-standard-mode"> standard mode only, relate the delete: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-annotated-table"> table to the delete: <a href="#dfn-group-of-tables" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-group-of-tables"> group of tables ; emit the following triple:
csvw:table
In delete: <a href="#dfn-standard-mode" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-standard-mode"> standard mode only, specify the type of delete: <a href="#dfn-node" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-node"> node T as csvw:Table
; emit the following triple:
rdf:type
csvw:Table
In delete: <a href="#dfn-standard-mode" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-standard-mode"> standard mode only, specify the source tabular data file URL for the current delete: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-annotated-table"> table based on the delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-url" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-table-url" class="externalDFN"> url annotation; emit the following triple:
csvw:url
In delete: <a href="#dfn-standard-mode" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-standard-mode"> standard mode only, emit the triples generated by running the algorithm specified in section 6. JSON-LD to RDF over any delete: <a href="#dfn-notes" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-notes"> notes and delete: <a href="#dfn-non-core-annotations" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-non-core-annotations"> non-core annotations specified for the delete: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-annotated-table"> table , with delete: <a href="#dfn-node" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-node"> node T as an initial subject , the delete: <a href="#dfn-notes" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-notes"> notes or delete: <a href="#dfn-non-core-annotations" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-non-core-annotations"> non-core annotation as property , and the value of the delete: <a href="#dfn-notes" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-notes"> notes or delete: <a href="#dfn-non-core-annotations" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-non-core-annotations"> non-core annotation as value .
All other delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-core-annotations" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-core-annotations" class="externalDFN"> core annotations for the delete: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-annotated-table"> table are ignored during the conversion; including information about delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-schema" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-table-schema" class="externalDFN"> table schemas and their delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-column" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-column" class="externalDFN"> columns , delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-foreign-keys" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-table-foreign-keys" class="externalDFN"> foreign keys , delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-table-direction" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-table-direction" class="externalDFN"> table direction , delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-transformations" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-table-transformation" class="externalDFN"> transformations , etc.
For each delete: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-row"> row in the current delete: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-annotated-table"> table :
In delete: <a href="#dfn-standard-mode" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-standard-mode"> standard mode only, establish a new delete: <a href="#dfn-blank-node" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-blank-node"> blank node R which represents the current delete: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-row"> row .
In delete: <a href="#dfn-standard-mode" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-standard-mode"> standard mode only, relate the delete: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-row"> row to the delete: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-annotated-table"> table ; emit the following triple:
csvw:row
In delete: <a href="#dfn-standard-mode" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-standard-mode"> standard mode only, specify the type of delete: <a href="#dfn-node" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-node"> node R as csvw:Row
; emit the following triple:
rdf:type
csvw:Row
In delete: <a href="#dfn-standard-mode" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-standard-mode"> standard mode only, specify the delete: <a href="#dfn-row-number" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-row-number"> row number n for the delete: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-row"> row ; emit the following triple:
csvw:rownum
xsd:integer
In delete: <a href="#dfn-standard-mode" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-standard-mode"> standard mode only, specify the delete: <a href="#dfn-row-source-number" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-row-source-number"> row source number n source for the delete: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-row"> row within the source tabular data file URL using a fragment-identifier as specified in [ delete: <a class="bibref" href="#bib-RFC7111"> insert: <a href="#bib-RFC7111" class="bibref"> RFC7111 ]; if delete: <a href="#dfn-row-source-number" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-row-source-number"> row source number is not null
, emit the following triple:
csvw:url
#row=
n source In delete: <a href="#dfn-standard-mode" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-standard-mode"> standard mode only, if delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-row-titles" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-row-titles" class="externalDFN"> row titles is not null
, insert any delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-row-titles" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-row-titles" class="externalDFN"> titles specified for the delete: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-row"> row . For each value, t v , of the delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-row-titles" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-row-titles" class="externalDFN"> row titles annotation, emit the following triple:
csvw:title
In delete: <a href="#dfn-standard-mode" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-standard-mode"> standard mode only, emit the triples generated by running the algorithm specified in section 6. JSON-LD to RDF over any delete: <a href="#dfn-non-core-annotations" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-non-core-annotations"> non-core annotations specified for the delete: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-row"> row , with delete: <a href="#dfn-node" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-node"> node R as an initial subject , the delete: <a href="#dfn-non-core-annotations" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-non-core-annotations"> non-core annotation as property , and the value of the delete: <a href="#dfn-non-core-annotations" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-non-core-annotations"> non-core annotation as value .
Establish a new delete: <a href="#dfn-blank-node" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-blank-node"> blank node S def to be used as the default subject for delete: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-cell"> cells where delete: <a href="#dfn-about-url" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-about-url"> about URL is undefined.
A delete: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-row"> row delete: <em class="rfc2119" title="MAY"> insert: <em title="MAY" class="rfc2119"> MAY describe multiple interrelated delete: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-subject"> subjects ; where the delete: <a href="#dfn-value-url" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-value-url"> value URL annotation on one delete: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-cell"> cell matches the delete: <a href="#dfn-about-url" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-about-url"> about URL annotation on another delete: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-cell"> cell in the same delete: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-row"> row .
For each delete: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-cell"> cell in the current delete: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-row"> row where the delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-column-suppress-output" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-column-suppress-output" class="externalDFN"> suppress output annotation for the delete: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-column"> column associated with that delete: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-cell"> cell is false
:
Establish a delete: <a href="#dfn-node" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-node"> node S from delete: <a href="#dfn-about-url" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-about-url"> about URL if set, or from S def otherwise as the current delete: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-subject"> subject .
In delete: <a href="#dfn-standard-mode" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-standard-mode"> standard mode only, relate the current delete: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-subject"> subject to the current delete: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-row"> row ; emit the following triple:
csvw:describes
If the value of delete: <a href="#dfn-property-url" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-property-url"> property URL for the delete: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-cell"> cell is not null
, then predicate P takes the value of delete: <a href="#dfn-property-url" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-property-url"> property URL .
Else, delete: <a href="#dfn-predicate" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-predicate"> predicate P is constructed by appending the value of the delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-name" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-column-name" class="externalDFN"> name annotation for the delete: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-column"> column associated with the delete: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-cell"> cell to the the tabular data file URL as a fragment identifier.
null
, then delete: <a href="#dfn-value-url" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-value-url"> value URL identifies a delete: <a href="#dfn-node" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-node"> node V url that is related the current delete: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-subject"> subject using the delete: <a href="#dfn-predicate" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-predicate"> predicate P ; emit the following triple: true
, then the delete: <a href="#dfn-cell-value" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-cell-value"> cell value provides an ordered sequence of delete: <a href="#dfn-literal-node" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-literal-node"> literal nodes for inclusion within the RDF output using an instance of rdf:List
V list as defined in [ delete: <a class="bibref" href="#bib-rdf-schema"> insert: <a href="#bib-rdf-schema" class="bibref"> rdf-schema ]. This instance is related to the delete: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-subject"> subject using the delete: <a href="#dfn-predicate" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-predicate"> predicate P ; emit the triples defining list V list plus the following triple: null
, then the delete: <a href="#dfn-cell-value" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-cell-value"> cell value provides a single delete: <a href="#dfn-literal-node" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-literal-node"> literal node V literal for inclusion within the RDF output that is related the current delete: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-subject"> subject using the delete: <a href="#dfn-predicate" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-predicate"> predicate P ; emit the following triple: The delete: <a href="#dfn-literal-node" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-literal-node"> literal nodes derived from the delete: <a href="#dfn-cell-value" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-cell-value"> cell values delete: <em class="rfc2119" title="MUST"> insert: <em title="MUST" class="rfc2119"> MUST be expressed according to the delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-value-datatype" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-cell-value-datatype" class="externalDFN"> cell value's datatype as defined below: Interpreting datatypes .
In the case when a delete: <a href="#dfn-cell-value" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-cell-value"> cell value does not have a delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-value-datatype" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-cell-value-datatype" class="externalDFN"> datatype , the conversion delete: <em class="rfc2119" title="SHOULD"> insert: <em title="SHOULD" class="rfc2119"> SHOULD default to string
.
In the case where a sequence of values is provided, each value in the list has its own delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-value-datatype" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-cell-value-datatype" class="externalDFN"> datatype ; the datatype may be different for different items in the sequence.
delete: <a href="#dfn-cell-value" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-cell-value"> Cell values are expressed in the RDF output according to the delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-value-datatype" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-cell-value-datatype" class="externalDFN"> cell value's datatype . The relationship between the value of the delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-value-datatype" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-cell-value-datatype" class="externalDFN"> cell value's datatype and the datatype IRI used in the RDF output is as follows:
null
, then its value delete: <em class="rfc2119" title="MUST"> insert: <em title="MUST" class="rfc2119"> MUST be used as the RDF datatype IRI ; datatype | RDF datatype IRI | Remarks |
---|---|---|
anyAtomicType | xsd:anyAtomicType | |
anyURI | xsd:anyURI | |
base64Binary | xsd:base64Binary | |
boolean | xsd:boolean | |
date | xsd:date | |
dateTime | xsd:dateTime | |
dateTimeStamp | xsd:dateTimeStamp | |
decimal | xsd:decimal | |
integer | xsd:integer | |
long | xsd:long | |
int | xsd:int | |
short | xsd:short | |
byte | xsd:byte | |
nonNegativeInteger | xsd:nonNegativeInteger | |
positiveInteger | xsd:positiveInteger | |
unsignedLong | xsd:unsignedLong | |
unsignedInt | xsd:unsignedInt | |
unsignedShort | xsd:unsignedShort | |
unsignedByte | xsd:unsignedByte | |
nonPositiveInteger | xsd:nonPositiveInteger | |
negativeInteger | xsd:negativeInteger | |
double | xsd:double | |
duration | xsd:duration | |
dayTimeDuration | xsd:dayTimeDuration | |
yearMonthDuration | xsd:yearMonthDuration | |
float | xsd:float | |
gDay | xsd:gDay | |
gMonth | xsd:gMonth | |
gMonthDay | xsd:gMonthDay | |
gYear | xsd:gYear | |
gYearMonth | xsd:gYearMonth | |
hexBinary | xsd:hexBinary | |
QName | xsd:QName | |
string | xsd:string or rdf:langString | Choice depends on whether or not the value has an associated language |
normalizedString | xsd:normalizedString | |
token | xsd:token | |
language | xsd:language | |
Name | xsd:Name | |
NMTOKEN | xsd:NMTOKEN | |
xml | rdf:XMLLiteral | |
html | rdf:HTML | |
json | csvw:JSON | csvw:JSON is a sub-class of xsd:string |
time | xsd:time |
A datatype's delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-format" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-datatype-format" class="externalDFN"> format annotation is irrelevant to the conversion procedure defined in this specification; the delete: <a href="#dfn-cell-value" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-cell-value"> cell value has already been parsed from the contents of the delete: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-cell"> cell according to the delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-format" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-datatype-format" class="externalDFN"> format annotation.
delete: <a href="#dfn-cell-errors" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-cell-errors"> Cell errors delete: <em class="rfc2119" title="MUST"> insert: <em title="MUST" class="rfc2119"> MUST be recorded by applications where the contents of a delete: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-cell"> cell cannot be parsed or validated (see delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#parsing-cells"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#parsing-cells"> Parsing Cells and delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#validating-tables"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#validating-tables"> Validating Tables in [ delete: <a class="bibref" href="#bib-tabular-data-model"> insert: <a href="#bib-tabular-data-model" class="bibref"> tabular-data-model ] respectively). In cases where delete: <a href="#dfn-cell-errors" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-cell-errors"> cell errors are recorded, applications may attempt to determine the appropriate RDF datatype IRI during the subsequent conversion process according to local rules.
In the case of rdf:langString
, the appropriate language tag (as defined in [ delete: <a class="bibref" href="#bib-rdf11-concepts"> insert: <a href="#bib-rdf11-concepts" class="bibref"> rdf11-concepts ]) delete: <em class="rfc2119" title="MUST"> insert: <em title="MUST" class="rfc2119"> MUST be provided for the string, based on the value of delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-language" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-cell-value-language" class="externalDFN"> cell value's language . (See section on Graph Literals in [ delete: <a class="bibref" href="#bib-rdf11-concepts"> insert: <a href="#bib-rdf11-concepts" class="bibref"> rdf11-concepts ] for further details on language tagged literals.)
According to [ delete: <a class="bibref" href="#bib-rdf11-concepts"> insert: <a href="#bib-rdf11-concepts" class="bibref"> rdf11-concepts ] language tags cannot be combined with other xsd
datatypes. If a cell has any datatype other than string
, the value of lang
delete: <em class="rfc2119" title="MUST"> insert: <em title="MUST" class="rfc2119"> MUST be ignored. Also, all literals have a datatype; however, specific serializations, like [ delete: <a class="bibref" href="#bib-turtle"> insert: <a href="#bib-turtle" class="bibref"> turtle ], delete: <em class="rfc2119" title="MAY"> insert: <em title="MAY" class="rfc2119"> MAY provide a special syntax for literals with datatype xsd:string
or rdf:langString
.
This section is non-normative.
In addition to the namespaces defined above , the following namespace is used in this section:
prov
: http://www.w3.org/ns/prov#
Conversion applications delete: <em class="rfc2119" title="MAY"> insert: <em title="MAY" class="rfc2119"> MAY include provenance information in the RDF output describing how and when the output was created; e.g., using terms from the PROV Ontology [ delete: <a class="bibref" href="#bib-prov-o"> insert: <a href="#bib-prov-o" class="bibref"> prov-o ]. Information that may be of interest to downstream applications includes:
In order to facilitate providing such information, this specification introduces two instances of prov:Role
:
csvw:csvEncodedTabularData
csvw:tabularMetadata
http://example.org/my-csv2rdf-application
: @prefix csvw : < http : //www.w3.org/ns/csvw#> . @prefix prov : < http : //www.w3.org/ns/prov#> . @prefix xsd : < http : //www.w3.org/2001/XMLSchema#> . <> prov : wasGeneratedBy [ a prov : Activity ; prov : wasAssociatedWith < http : //example.org/my-csv2rdf-application> ; prov : startedAtTime "2015-02-13T15:12:44" ^^ xsd : dateTime ; prov : endedAtTime "2015-02-13T15:12:46" ^^ xsd : dateTime ; prov : qualifiedUsage [ a prov : Usage ; prov : entity < http : //example.org/csv/data.csv> ; prov : hadRole csvw : csvEncodedTabularData ]; prov : qualifiedUsage [ a prov : Usage ; prov : entity < http : //example.org/csv/data.csv-metadata.json> , < http : //example.org/csv/csv-metadata.json> ; prov : hadRole csvw : tabularMetadata ]; ]
This section defines a mechanism for transforming the [ delete: <a class="bibref" href="#bib-json-ld"> insert: <a href="#bib-json-ld" class="bibref"> json-ld ] delete: <a href="http://www.w3.org/TR/2015/PR-tabular-metadata-20151117/#json-ld-dialect"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-metadata-20151217/#json-ld-dialect"> dialect used for delete: <a href="#dfn-non-core-annotations" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-non-core-annotations"> non-core annotations and delete: <a href="#dfn-notes" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-notes"> notes originating from the processing of metadata (as defined in [ delete: <a class="bibref" href="#bib-tabular-metadata"> insert: <a href="#bib-tabular-metadata" class="bibref"> tabular-metadata ]) into RDF in a manner consistent with the Deserialize JSON-LD to RDF Algorithm defined in [ delete: <a class="bibref" href="#bib-json-ld-api"> insert: <a href="#bib-json-ld-api" class="bibref"> json-ld-api ]. Converters delete: <em class="rfc2119" title="MAY"> insert: <em title="MAY" class="rfc2119"> MAY use any algorithm which results in equivalent triples.
Conversion applications may have other means to create delete: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-annotated-table"> annotated tables , e.g. through some application specific APIs. In such cases the exact format for non-core annotations or notes may be different. Specifications for such annotation processes should specify how these annotations are converted into RDF.
Given a subject , property and value in delete: <a href="http://www.w3.org/TR/2015/PR-tabular-metadata-20151117/#normalization" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-metadata-20151217/#normalization" class="externalDFN"> normalized form:
@value
, create an RDF Literal lit using the string value of @value
and language from @language
, or datatype from @type
if present, expanding @type
as necessary using the procedure outlined for property , and emit the following triple: If neither @language
nor @type
is present, the literal lit has the datatype xsd:string
.
@id
if defined, or else as a delete: <a href="#dfn-blank-node" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-blank-node"> blank node , and emit the following triple: @type
, either a term defined in the [ delete: <a class="bibref" href="#bib-csvw-context"> insert: <a href="#bib-csvw-context" class="bibref"> csvw-context ], a delete: <a href="#dfn-prefixed-name" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-prefixed-name"> prefixed name , or an absolute URL; establish a new node T i by expanding the value to an absolute URL by replacing a term with the URI from the term definition in [ delete: <a class="bibref" href="#bib-csvw-context"> insert: <a href="#bib-csvw-context" class="bibref"> csvw-context ] or a delete: <a href="#dfn-prefixed-name" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-prefixed-name"> prefixed name with its expanded value. For each T i , emit the following triple: rdf:type
@
( U+0040
) generate RDF by running this algorithm using S for subject , key for property and val for value . true
or false
, create an RDF Literal lit using the strings "true" or "false", accordingly with datatype xsd:boolean
. xsd:double
. xsd:integer
. xsd:string
. Emit the following triple:
This section is non-normative.
In addition to the namespaces defined above , the examples provided here make use of the following namespaces:
dc
: http://purl.org/dc/terms/
foaf
: http://xmlns.com/foaf/0.1/
oa
: http://www.w3.org/ns/oa#
org
: http://www.w3.org/ns/org#
schema
: http://schema.org/
Furthermore, these examples also make use of the Turtle syntax @base
declaration (as defined in [ delete: <a class="bibref" href="#bib-turtle"> insert: <a href="#bib-turtle" class="bibref"> turtle ]). Where a single tabular data file is used in the example, the @base
declaration is set to the URL of that tabular data file.
Each of the examples expresses more complex conversions - it is recommended that readers of this specification work through the examples in sequential order.
This example comprises a single delete: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-annotated-table"> annotated table containing information attributes about countries; country code, position (latitude, longitude) and name. Whilst the input tabular data file, published at http://example.org/countries.csv
, includes a delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-header-line" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-header-line" class="externalDFN"> header line , no further metadata annotations are given. The tabular data file is provided below:
countryCode,latitude,longitude,name AD,42.5,1.6,Andorra AE,23.4,53.8,"United Arab Emirates" AF,33.9,67.7,Afghanistan
The delete: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-annotated-table"> annotated table generated from parsing the tabular data file is shown below and provides the basis for the conversion to RDF.
Annotations for the resulting delete: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-annotated-table"> table T , with 4 columns and 3 rows, are shown below:
id | core annotations | ||
---|---|---|---|
url | columns | rows | |
T | http://example.org/countries.csv | C1 , C2 , C3 , C4 | R1 , R2 , R3 |
Annotations for the delete: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-column"> columns , delete: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-row"> rows and delete: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-cell"> cells in delete: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-annotated-table"> table T are shown in the tables below:
delete: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-column"> Column annotations:
id | core annotations | |||||
---|---|---|---|---|---|---|
table | number | source number | cells | name | titles | |
C1 | T | 1 | 1 | C1.1 , C2.1 , C3.1 | countryCode | countryCode |
C2 | T | 2 | 2 | C1.2 , C2.2 , C3.2 | latitude | latitude |
C3 | T | 3 | 3 | C1.3 , C2.3 , C3.3 | longitude | longitude |
C4 | T | 4 | 4 | C1.4 , C2.4 , C3.4 | name | name |
delete: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-row"> Row annotations:
id | core annotations | |||
---|---|---|---|---|
table | number | source number | cells | |
R1 | T | 1 | 2 | C1.1 , C1.2 , C1.3 , C1.4 |
R2 | T | 2 | 3 | C2.1 , C2.2 , C2.3 , C2.4 |
R3 | T | 3 | 4 | C3.1 , C3.2 , C3.3 , C3.4 |
delete: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-cell"> Cell annotations:
id | core annotations | |||||
---|---|---|---|---|---|---|
table | column | row | string value | value | property URL | |
C1.1 | T | C1 | R1 | "AD" | "AD" | null |
C1.2 | T | C2 | R1 | "42.5" | "42.5" | null |
C1.3 | T | C3 | R1 | "1.6" | "1.6" | null |
C1.4 | T | C4 | R1 | "Andorra" | "Andorra" | null |
C2.1 | T | C1 | R2 | "AE" | "AE" | null |
C2.2 | T | C2 | R2 | "23.4" | "23.4" | null |
C2.3 | T | C3 | R2 | "53.8" | "53.8" | null |
C2.4 | T | C4 | R2 | "United Arab Emirates" | "United Arab Emirates" | null |
C3.1 | T | C1 | R3 | "AF" | "AF" | null |
C3.2 | T | C2 | R3 | "33.9" | "33.9" | null |
C3.3 | T | C3 | R3 | "67.7" | "67.7" | null |
C3.4 | T | C4 | R3 | "Afghanistan" | "Afghanistan" | null |
delete: <a href="#dfn-minimal-mode" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-minimal-mode"> Minimal mode output for this example is provided in [ delete: <a class="bibref" href="#bib-turtle"> insert: <a href="#bib-turtle" class="bibref"> turtle ] syntax below:
@base < http : //example.org/countries.csv> . _ : 8228a149 - 8efe - 448d - b15f - 8abf92e7bd17 <# countryCode > "AD" ; <# latitude > "42.5" ; <# longitude > "1.6" ; <# name > "Andorra" . _ : ec59dcfc - 872a - 4144 - 822b - 9ad5e2c6149c <# countryCode > "AE" ; <# latitude > "23.4" ; <# longitude > "53.8" ; <# name > "United Arab Emirates" . _ : e8f2e8e9 - 3d02 - 4bf5 - b4f1 - 4794ba5b52c9 <# countryCode > "AF" ; <# latitude > "33.9" ; <# longitude > "67.7" ; <# name > "Afghanistan" .
The delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-about-url" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-cell-about-url" class="externalDFN"> about URL annotation has not been set for cells in table T ( { "url": "http://example.org/countries.csv"}
); delete: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-cell"> cells in a given delete: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-row"> row where delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-about-url" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-cell-about-url" class="externalDFN"> about URL has not been specified are assumed to refer to the same delete: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-subject"> subject . This unspecified delete: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-subject"> subject is treated as a delete: <a href="#dfn-blank-node" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-blank-node"> blank node .
Given that the delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-property-url" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-cell-property-url" class="externalDFN"> property URL is null
for cells in table T ( { "url": "http://example.org/countries.csv"}
), the property URL defaults to the URI Template (see [ delete: <a class="bibref" href="#bib-RFC6570"> insert: <a href="#bib-RFC6570" class="bibref"> RFC6570 ]) #{ [column-name] }
, where [column-name]
is the value of the delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-name" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-column-name" class="externalDFN"> name annotation of the column associated with the cell. For example, the value of the delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-property-url" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-cell-property-url" class="externalDFN"> property URL annotation for all delete: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-cell"> cells in delete: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-column"> column C1 ( "name": "countryCode"
) is http://example.org/countries.csv#countryCode
.
delete: <a href="#dfn-standard-mode" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-standard-mode"> Standard mode output for this example is provided in [ delete: <a class="bibref" href="#bib-turtle"> insert: <a href="#bib-turtle" class="bibref"> turtle ] syntax below:
@base < http : //example.org/countries.csv> . @prefix csvw : < http : //www.w3.org/ns/csvw#> . @prefix xsd : < http : //www.w3.org/2001/XMLSchema#> . _ : d4f8e548 - 9601 - 4e41 - aadb - 09a8bce32625 a csvw : TableGroup ; csvw : table [ a csvw : Table ; csvw : url < http : //example.org/countries.csv> ; csvw : row [ a csvw : Row ; csvw : rownum "1" ^^ xsd : integer ; csvw : url <# row = 2 > ; csvw : describes _ : 8228a149 - 8efe - 448d - b15f - 8abf92e7bd17 ], [ a csvw : Row ; csvw : rownum "2" ^^ xsd : integer ; csvw : url <# row = 3 > ; csvw : describes _ : ec59dcfc - 872a - 4144 - 822b - 9ad5e2c6149c ], [ a csvw : Row ; csvw : rownum "3" ^^ xsd : integer ; csvw : url <# row = 4 > ; csvw : describes _ : e8f2e8e9 - 3d02 - 4bf5 - b4f1 - 4794ba5b52c9 ] ] . _ : 8228a149 - 8efe - 448d - b15f - 8abf92e7bd17 <# countryCode > "AD" ; <# latitude > "42.5" ; <# longitude > "1.6" ; <# name > "Andorra" . _ : ec59dcfc - 872a - 4144 - 822b - 9ad5e2c6149c <# countryCode > "AE" ; <# latitude > "23.4" ; <# longitude > "53.8" ; <# name > "United Arab Emirates" . _ : e8f2e8e9 - 3d02 - 4bf5 - b4f1 - 4794ba5b52c9 <# countryCode > "AF" ; <# latitude > "33.9" ; <# longitude > "67.7" ; <# name > "Afghanistan" .
Even though the delete: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-annotated-table"> table was defined in isolation, the delete: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-annotated-table"> annotated table is wrapped in a delete: <a href="#dfn-group-of-tables" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-group-of-tables"> group of tables .
The type of both delete: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-annotated-table"> table and delete: <a href="#dfn-group-of-tables" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-group-of-tables"> group of tables objects is explicitly stated; csvw:TableGroup
and csvw:Table
respectively.
The csvw:url
property provides reference to the original tabular data file and to specific delete: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-row"> rows therein - noting the need to escape the Turtle-syntax reserved character =
( U+003D
) within the fragment identifier.
The delete: <a href="#dfn-row-number" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-row-number"> row number is provided for each delete: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-row"> row using csvw:rownum
property.
A delete: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-subject"> subject and delete: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-row"> row are related using the csvw:describes
property.
This example is based on Use Case #11 - City of Palo Alto Tree Data and comprises a single delete: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-annotated-table"> annotated table describing an inventory of tree maintenance operations. The input tabular data file, published at http://example.org/tree-ops-ext.csv
, and the associated metadata description http://example.org/tree-ops-ext.csv-metadata.json
are provided below:
GID,On Street,Species,Trim Cycle,Diameter at Breast Ht,Inventory Date,Comments,Protected,KML 1,ADDISON AV,Celtis australis,Large Tree Routine Prune,11,10/18/2010,,,"<Point><coordinates>-122.156485,37.440963</coordinates></Point>" 2,EMERSON ST,Liquidambar styraciflua,Large Tree Routine Prune,11,6/2/2010,,,"<Point><coordinates>-122.156749,37.440958</coordinates></Point>" 6,ADDISON AV,Robinia pseudoacacia,Large Tree Routine Prune,29,6/1/2010,cavity or decay; trunk decay; codominant leaders; included bark; large leader or limb decay; previous failure root damage; root decay; beware of BEES,YES,"<Point><coordinates>-122.156299,37.441151</coordinates></Point>"
{ "@context" : [ "http://www.w3.org/ns/csvw" , { "@language" : "en" }], "@id" : "http://example.org/tree-ops-ext" , "url" : "tree-ops-ext.csv" , "dc:title" : "Tree Operations" , "dcat:keyword" : [ "tree" , "street" , "maintenance" ], "dc:publisher" : [{ "schema:name" : "Example Municipality" , "schema:url" : { "@id" : "http://example.org" } }], "dc:license" : { "@id" : "http://opendefinition.org/licenses/cc-by/" }, "dc:modified" : { "@value" : "2010-12-31" , "@type" : "xsd:date" }, "notes" : [{ "@type" : "oa:Annotation" , "oa:hasTarget" : { "@id" : "http://example.org/tree-ops-ext" }, "oa:hasBody" : { "@type" : "oa:EmbeddedContent" , "rdf:value" : "This is a very interesting comment about the table; it's a table!" , "dc:format" : { "@value" : "text/plain" } } }], "dialect" : { "trim" : true }, "tableSchema" : { "columns" : [{ "name" : "GID" , "titles" : [ "GID" , "Generic Identifier" ], "dc:description" : "An identifier for the operation on a tree." , "datatype" : "string" , "required" : true , "suppressOutput" : true }, { "name" : "on_street" , "titles" : "On Street" , "dc:description" : "The street that the tree is on." , "datatype" : "string" }, { "name" : "species" , "titles" : "Species" , "dc:description" : "The species of the tree." , "datatype" : "string" }, { "name" : "trim_cycle" , "titles" : "Trim Cycle" , "dc:description" : "The operation performed on the tree." , "datatype" : "string" , "lang" : "en" }, { "name" : "dbh" , "titles" : "Diameter at Breast Ht" , "dc:description" : "Diameter at Breast Height (DBH) of the tree (in feet), measured 4.5ft above ground." , "datatype" : "integer" }, { "name" : "inventory_date" , "titles" : "Inventory Date" , "dc:description" : "The date of the operation that was performed." , "datatype" : { "base" : "date" , "format" : "M/d/yyyy" } }, { "name" : "comments" , "titles" : "Comments" , "dc:description" : "Supplementary comments relating to the operation or tree." , "datatype" : "string" , "separator" : ";" }, { "name" : "protected" , "titles" : "Protected" , "dc:description" : "Indication (YES / NO) whether the tree is subject to a protection order." , "datatype" : { "base" : "boolean" , "format" : "YES|NO" }, "default" : "NO" }, { "name" : "kml" , "titles" : "KML" , "dc:description" : "KML-encoded description of tree location." , "datatype" : "xml" }], "primaryKey" : "GID" , "aboutUrl" : "http://example.org/tree-ops-ext#gid-{GID}" } }
The delete: <a href="#dfn-notes" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-notes"> notes annotation in the metadata description uses the Open Annotation data model currently under development within the Web Annotations Working Group . This is purely illustrative; no constraints are placed on the value of the delete: <a href="#dfn-notes" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-notes"> notes annotation.
The delete: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-annotated-table"> annotated table generated from parsing the tabular data file and associated metadata is shown below and provides the basis for the conversion to RDF.
Core annotations for the resulting delete: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-annotated-table"> table T , with 9 delete: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-column"> columns and 3 delete: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-row"> rows , are shown below:
id | core annotations | ||||
---|---|---|---|---|---|
id | url | columns | rows | notes | |
T | <http://example.org/tree-ops-ext> | http://example.org/tree-ops-ext.csv | C1 , C2 , C3 , C4 , C5 , C6 , C7 , C8 , C9 | R1 , R2 , R3 | [{ "@type": "oa:Annotation", ... }] |
Non-core annotations for the delete: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-annotated-table"> table T are:
dc:title
"Tree Operations"
dcat:keyword
["tree", "street", "maintenance"]
dc:publisher
[{ "schema:name": "Example Municipality", "schema:url": { "@id": "http://example.org" } }]
dc:license
{ "@id": "http://opendefinition.org/licenses/cc-by/" }
dc:modified
"2010-12-31"
The value of the delete: <a href="#dfn-notes" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-notes"> notes annotation has been shortened for clarity in the table above.
Annotations for the delete: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-column"> columns , delete: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-row"> rows and delete: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-cell"> cells in delete: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-annotated-table"> table T are shown in the tables below:
delete: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-column"> Column annotations:
id | core annotations | annotations | |||||||
---|---|---|---|---|---|---|---|---|---|
table | number | source number | cells | name | titles | required | suppress output | dc:description | |
C1 | T | 1 | 1 | C1.1 , C2.1 , C3.1 | GID | GID , Generic Identifier | true | true | An identifier for the operation on a tree. |
C2 | T | 2 | 2 | C1.2 , C2.2 , C3.2 | on_street | On Street | The street that the tree is on. | ||
C3 | T | 3 | 3 | C1.3 , C2.3 , C3.3 | species | Species | The species of the tree. | ||
C4 | T | 4 | 4 | C1.4 , C2.4 , C3.4 | trim_cycle | Trim Cycle | The operation performed on the tree. | ||
C5 | T | 5 | 5 | C1.5 , C2.5 , C3.5 | dbh | Diameter at Breast Ht | Diameter at Breast Height (DBH) of the tree (in feet), measured 4.5ft above ground. | ||
C6 | T | 6 | 6 | C1.6 , C2.6 , C3.6 | inventory_date | Inventory Date | The date of the operation that was performed. | ||
C7 | T | 7 | 7 | C1.7 , C2.7 , C3.7 | comments | Comments | Supplementary comments relating to the operation or tree. | ||
C8 | T | 8 | 8 | C1.8 , C2.8 , C3.8 | protected | Protected | Indication (YES / NO) whether the tree is subject to a protection order. | ||
C9 | T | 9 | 9 | C1.9 , C2.9 , C3.9 | kml | KML | KML-encoded description of tree location. |
In this example, output for delete: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-column"> column C1 ( GID
) is not required; note the delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-column-suppress-output" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-column-suppress-output" class="externalDFN"> suppress output annotation on this delete: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-column"> column .
delete: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-row"> Row annotations:
id | core annotations | ||||
---|---|---|---|---|---|
table | number | source number | cells | primary key | |
R1 | T | 1 | 2 | C1.1 , C1.2 , C1.3 , C1.4 , C1.5 , C1.6 , C1.7 , C1.8 , C1.9 | C1.1 |
R2 | T | 2 | 3 | C2.1 , C2.2 , C2.3 , C2.4 , C2.5 , C2.6 , C2.7 , C2.8 , C2.9 | C2.1 |
R3 | T | 3 | 4 | C3.1 , C3.2 , C3.3 , C3.4 , C3.5 , C3.6 , C3.7 , C3.8 , C3.9 | C3.1 |
delete: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-cell"> Cell annotations:
id | core annotations | |||||
---|---|---|---|---|---|---|
table | column | row | string value | value | about URL | |
C1.1 | T | C1 | R1 | "1" | "1" | http://example.org/tree-ops-ext#gid-1 |
C1.2 | T | C2 | R1 | "ADDISON AV" | "ADDISON AV" | <http://example.org/tree-ops-ext#gid-1> |
C1.3 | T | C3 | R1 | "Celtis australis" | "Celtis australis" | <http://example.org/tree-ops-ext#gid-1> |
C1.4 | T | C4 | R1 | "Large Tree Routine Prune" | "Large Tree Routine Prune" (English) | <http://example.org/tree-ops-ext#gid-1> |
C1.5 | T | C5 | R1 | "11" | 11 | <http://example.org/tree-ops-ext#gid-1> |
C1.6 | T | C6 | R1 | "10/18/2010" | 2010-10-18 | <http://example.org/tree-ops-ext#gid-1> |
C1.7 | T | C7 | R1 | "" | null | <http://example.org/tree-ops-ext#gid-1> |
C1.8 | T | C8 | R1 | "" | false | <http://example.org/tree-ops-ext#gid-1> |
C1.9 | T | C9 | R1 | "<Point><coordinates>-122.156485,37.440963</coordinates></Point>" | "<Point><coordinates>-122.156485,37.440963</coordinates></Point>" (XML) | <http://example.org/tree-ops-ext#gid-1> |
C2.1 | T | C1 | R2 | "2" | "2" | <http://example.org/tree-ops-ext#gid-2> |
C2.2 | T | C2 | R2 | "EMERSON ST" | "EMERSON ST" | <http://example.org/tree-ops-ext#gid-2> |
C2.3 | T | C3 | R2 | "Liquidambar styraciflua" | "Liquidambar styraciflua" | <http://example.org/tree-ops-ext#gid-2> |
C2.4 | T | C4 | R2 | "Large Tree Routine Prune" | "Large Tree Routine Prune" (English) | <http://example.org/tree-ops-ext#gid-2> |
C2.5 | T | C5 | R2 | "11" | 11 | <http://example.org/tree-ops-ext#gid-2> |
C2.6 | T | C6 | R2 | "6/2/2010" | 2010-06-02 | <http://example.org/tree-ops-ext#gid-2> |
C2.7 | T | C7 | R2 | "" | null | <http://example.org/tree-ops-ext#gid-2> |
C2.8 | T | C8 | R2 | "" | false | <http://example.org/tree-ops-ext#gid-2> |
C2.9 | T | C9 | R2 | "<Point><coordinates>-122.156749,37.440958</coordinates></Point>" | "<Point><coordinates>-122.156749,37.440958</coordinates></Point>" (XML) | <http://example.org/tree-ops-ext#gid-2> |
C3.1 | T | C1 | R3 | "6" | "6" | <http://example.org/tree-ops-ext#gid-6> |
C3.2 | T | C2 | R3 | "ADDISON AV" | "ADDISON AV" | <http://example.org/tree-ops-ext#gid-6> |
C3.3 | T | C3 | R3 | "Robinia pseudoacacia" | "Robinia pseudoacacia" | <http://example.org/tree-ops-ext#gid-6> |
C3.4 | T | C4 | R3 | "Large Tree Routine Prune" | "Large Tree Routine Prune" (English) | <http://example.org/tree-ops-ext#gid-6> |
C3.5 | T | C5 | R3 | "29" | 29 | <http://example.org/tree-ops-ext#gid-6> |
C3.6 | T | C6 | R3 | "6/1/2010" | 2010-06-01 | <http://example.org/tree-ops-ext#gid-6> |
C3.7 | T | C7 | R3 | "cavity or decay; trunk decay; codominant leaders; included bark; large leader or limb decay; previous failure root damage; root decay; beware of BEES" | "cavity or decay" , "trunk decay" , "codominant leaders" , "included bark" , "large leader or limb decay" , "previous failure root damage" , "root decay" , "beware of BEES" | <http://example.org/tree-ops-ext#gid-6> |
C3.8 | T | C8 | R3 | "YES" | true | <http://example.org/tree-ops-ext#gid-6> |
C3.9 | T | C9 | R3 | "<Point><coordinates>-122.156299,37.441151</coordinates></Point>" | "<Point><coordinates>-122.156299,37.441151</coordinates></Point>" (XML) | <http://example.org/tree-ops-ext#gid-6> |
The lists of values from delete: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-cell"> cells in delete: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-column"> column C7 ( "name": "comments"
) are assumed to be unordered as the boolean delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-ordered" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-cell-ordered" class="externalDFN"> ordered annotation, which defaults to false
, has not be set within the metadata description.
delete: <a href="#dfn-minimal-mode" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-minimal-mode"> Minimal mode output for this example is provided in [ delete: <a class="bibref" href="#bib-turtle"> insert: <a href="#bib-turtle" class="bibref"> turtle ] syntax below:
@base < http : //example.org/tree-ops-ext.csv> . @prefix rdf : < http : //www.w3.org/1999/02/22-rdf-syntax-ns#> . @prefix xsd : < http : //www.w3.org/2001/XMLSchema#> . < http : //example.org/tree-ops-ext#gid-1> <# on_street > "ADDISON AV" ; <# species > "Celtis australis" ; <# trim_cycle > "Large Tree Routine Prune" @en ; <# dbh > 11 ; <# inventory_date > "2010-10-18" ^^ xsd : date ; <# protected > false ; <# kml > "<Point><coordinates>-122.156485,37.440963</coordinates></Point>" ^^ rdf : XMLLiteral . < http : //example.org/tree-ops-ext#gid-2> <# on_street > "EMERSON ST" ; <# species > "Liquidambar styraciflua" ; <# trim_cycle > "Large Tree Routine Prune" @en ; <# dbh > 11 ; <# inventory_date > "2010-06-02" ^^ xsd : date ; <# protected > false ; <# kml > "<Point><coordinates>-122.156749,37.440958</coordinates></Point>" ^^ rdf : XMLLiteral . < http : //example.org/tree-ops-ext#gid-6> <# on_street > "ADDISON AV" ; <# species > "Robinia pseudoacacia" ; <# trim_cycle > "Large Tree Routine Prune" @en ; <# dbh > 29 ; <# inventory_date > "2010-06-01" ^^ xsd : date ; <# comments > "cavity or decay" , "trunk decay" , "codominant leaders" , "included bark" , "large leader or limb decay" , "previous failure root damage" , "root decay" , "beware of BEES" ; <# protected > true ; <# kml > "<Point><coordinates>-122.156299,37.441151</coordinates></Point>" ^^ rdf : XMLLiteral .
The delete: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-subject"> subject described by each delete: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-row"> row is explicitly defined using the delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-about-url" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-cell-about-url" class="externalDFN"> about URL annotation; e.g. the delete: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-subject"> subject of delete: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-row"> row R1 is http://example.org/tree-ops-ext#gid-1
.
Output for delete: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-column"> column C1 ( { "name": "GID" }
) is not included as the delete: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-column"> column delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-column-suppress-output" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-column-suppress-output" class="externalDFN"> suppress output annotation is true
.
A language tag is specified for delete: <a data-lt="cell value" href="#dfn-cell-value" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-cell-value" data-lt="cell value"> values of delete: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-column"> column C4 ( { "name": "trim_cycle" }
) as the delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-language" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-cell-value-language" class="externalDFN"> cell value language annotation is en
.
The delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-column-datatype"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-column-datatype"> datatype
annotation is set on delete: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-column"> columns C5 , C6 , C8 and C9 ( { "name": "dbh"}
, { "name": "inventory_date" }
, { "name": "protected" }
and { "name": "kml" }
); as integer
, date
, boolean
and xml
respectively. The delete: <a href="http://www.w3.org/TR/2015/PR-tabular-metadata-20151117/#cell-datatype"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-metadata-20151217/#cell-datatype"> datatype
property is inherited by all delete: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-cell"> cells in each of those delete: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-column"> columns , therefore the RDF output for those delete: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-cell"> cells includes the appropriate datatype IRI .
delete: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-cell"> Cells C1.7 and C2.7 ( delete: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-row"> rows R1 and R2 ; delete: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-column"> column , { "name": "comments" }
) have null
delete: <a data-lt="cell value" href="#dfn-cell-value" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-cell-value" data-lt="cell value"> values - no output is included for these delete: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-cell"> cells .
delete: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-cell"> Cell C3.7 ( delete: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-row"> row R3 ; delete: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-column"> column , { "name": "comments" }
) contains an unordered sequence of values; the set of values are included as a simple set of triples as opposed to an instance of rdf:List
as the delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-ordered" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-cell-ordered" class="externalDFN"> ordered annotation has defaulted to false
.
delete: <a href="#dfn-standard-mode" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-standard-mode"> Standard mode output for this example is provided in [ delete: <a class="bibref" href="#bib-turtle"> insert: <a href="#bib-turtle" class="bibref"> turtle ] syntax below:
@base < http : //example.org/tree-ops-ext.csv> . @prefix csvw : < http : //www.w3.org/ns/csvw#> . @prefix dc : < http : //purl.org/dc/terms/> . @prefix dcat : < http : //www.w3.org/ns/dcat#> . @prefix oa : < http : //www.w3.org/ns/oa#> . @prefix rdf : < http : //www.w3.org/1999/02/22-rdf-syntax-ns#> . @prefix schema : < http : //schema.org/> . @prefix xsd : < http : //www.w3.org/2001/XMLSchema#> . _ : 68fc08e5 - 56a0 - 47e2 - a784 - 3a644d8257c4 a csvw : TableGroup ; csvw : table < http : //example.org/tree-ops-ext> . < http : //example.org/tree-ops-ext> a csvw:Table ; csvw : url < http : //example.org/tree-ops-ext.csv> ; dc : title "Tree Operations" @en ; dcat : keyword "tree" @en , "street" @en , "maintenance" @en ; dc : publisher [ schema : name "Example Municipality" @en ; schema : url < http : //example.org> ] ; dc : license < http : //opendefinition.org/licenses/cc-by/> ; dc : modified "2010-12-31" ^^ xsd : date ; csvw : note [ a oa : Annotation ; oa : hasTarget < http : //example.org/tree-ops-ext> ; oa : hasBody [ a oa : EmbeddedContent ; rdf : value "This is a very interesting comment about the table; it's a table!" @en ; dc : format "text/plain" ] ] ; csvw : row [ a csvw : Row ; csvw : rownum 1 ; csvw : url <# row = 2 > ; csvw : describes < http : //example.org/tree-ops-ext#gid-1> ], [ a csvw : Row ; csvw : rownum 2 ; csvw : url <# row = 3 > ; csvw : describes < http : //example.org/tree-ops-ext#gid-2> ], [ a csvw : Row ; csvw : rownum 3 ; csvw : url <# row = 4 > ; csvw : describes < http : //example.org/tree-ops-ext#gid-6> ] . < http : //example.org/tree-ops-ext#gid-1> <# on_street > "ADDISON AV" ; <# species > "Celtis australis" ; <# trim_cycle > "Large Tree Routine Prune" @en ; <# dbh > 11 ; <# inventory_date > "2010-10-18" ^^ xsd : date ; <# protected > false ; <# kml > "<Point><coordinates>-122.156485,37.440963</coordinates></Point>" ^^ rdf : XMLLiteral . < http : //example.org/tree-ops-ext#gid-2> <# on_street > "EMERSON ST" ; <# species > "Liquidambar styraciflua" ; <# trim_cycle > "Large Tree Routine Prune" @en ; <# dbh > 11 ; <# inventory_date > "2010-06-02" ^^ xsd : date ; <# protected > false ; <# kml > "<Point><coordinates>-122.156749,37.440958</coordinates></Point>" ^^ rdf : XMLLiteral . < http : //example.org/tree-ops-ext#gid-6> <# on_street > "ADDISON AV" ; <# species > "Robinia pseudoacacia" ; <# trim_cycle > "Large Tree Routine Prune" @en ; <# dbh > 29 ; <# inventory_date > "2010-06-01" ^^ xsd : date ; <# comments > "cavity or decay" , "trunk decay" , "codominant leaders" , "included bark" , "large leader or limb decay" , "previous failure root damage" , "root decay" , "beware of BEES" ; <# protected > true ; <# kml > "<Point><coordinates>-122.156299,37.441151</coordinates></Point>" ^^ rdf : XMLLiteral .
delete: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-annotated-table"> Table T ( { "url": "http://example.org/tree-ops-ext.csv"}
) has been explicitly identified: { "@id": "<http://exmple.org/tree-ops-ext>"}
.
delete: <a href="#dfn-non-core-annotations" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-non-core-annotations"> Non-core annotations and delete: <a href="#dfn-notes" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-notes"> notes specified for delete: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-annotated-table"> table T ( { "url": "http://example.org/tree-ops-ext.csv"}
) are included in the output.
As the metadata description file http://example.org/tree-ops-ext.csv-metadata.json
defines a default language within the context ( "@context": ["http://www.w3.org/ns/csvw", {"@language": "en"}]
), all delete: <a href="#dfn-non-core-annotations" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-non-core-annotations"> non-core annotations of type string
(e.g. dc:title
, dcat:keyword
, dc:publisher
, dc:license
and dc:modified
) are expressed in the RDF output using the the appropriate language tag .
This example uses a single delete: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-annotated-table"> annotated table describing a listing of music events. Each delete: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-row"> row from the tabular data file corresponds to three resources; the music event itself, the location where that event occurs and the offer to sell tickets for that event. The goal is to convert the CSV content into schema.org markup that a search engine such as Google can use to index music events. Details of how Google expects this information to be structured can be found here .
The input tabular data file, published at http://example.org/events-listing.csv
, and the associated metadata description http://example.org/events-listing.csv-metadata.json
are provided below:
Name, Start Date, Location Name, Location Address, Ticket Url B.B. King,2014-04-12T19:30,"Lupo’s Heartbreak Hotel","79 Washington St., Providence, RI",https://www.etix.com/ticket/1771656 B.B. King,2014-04-13T20:00,"Lynn Auditorium","Lynn, MA, 01901",http://frontgatetickets.com/venue.php?id=11766
{ "@context" : [ "http://www.w3.org/ns/csvw" , { "@language" : "en" }], "url" : "events-listing.csv" , "dialect" : { "trim" : true }, "tableSchema" : { "columns" : [{ "name" : "name" , "titles" : "Name" , "aboutUrl" : "#event-{_row}" , "propertyUrl" : "schema:name" }, { "name" : "start_date" , "titles" : "Start Date" , "datatype" : { "base" : "datetime" , "format" : "yyyy-MM-ddTHH:mm" }, "aboutUrl" : "#event-{_row}" , "propertyUrl" : "schema:startDate" }, { "name" : "location_name" , "titles" : "Location Name" , "aboutUrl" : "#place-{_row}" , "propertyUrl" : "schema:name" }, { "name" : "location_address" , "titles" : "Location Address" , "aboutUrl" : "#place-{_row}" , "propertyUrl" : "schema:address" }, { "name" : "ticket_url" , "titles" : "Ticket Url" , "datatype" : "anyURI" , "aboutUrl" : "#offer-{_row}" , "propertyUrl" : "schema:url" }, { "name" : "type_event" , "virtual" : true , "aboutUrl" : "#event-{_row}" , "propertyUrl" : "rdf:type" , "valueUrl" : "schema:MusicEvent" }, { "name" : "type_place" , "virtual" : true , "aboutUrl" : "#place-{_row}" , "propertyUrl" : "rdf:type" , "valueUrl" : "schema:Place" }, { "name" : "type_offer" , "virtual" : true , "aboutUrl" : "#offer-{_row}" , "propertyUrl" : "rdf:type" , "valueUrl" : "schema:Offer" }, { "name" : "location" , "virtual" : true , "aboutUrl" : "#event-{_row}" , "propertyUrl" : "schema:location" , "valueUrl" : "#place-{_row}" }, { "name" : "offers" , "virtual" : true , "aboutUrl" : "#event-{_row}" , "propertyUrl" : "schema:offers" , "valueUrl" : "#offer-{_row}" }] } }
The CSV to RDF translation is limited to providing one statement, or triple, per delete: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-column"> column in the delete: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-annotated-table"> table . The target schema.org markup requires 10 statements to describe each event. As the base tabular data file contains 5 columns, an additional 5 virtual delete: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-column"> columns have been added in order to provide for the full complement of statements—including the relationships between the 3 resources (event, location, and offer) described by each delete: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-row"> row of the delete: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-annotated-table"> table . Note that the delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-virtual" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-column-virtual" class="externalDFN"> virtual annotation is set to true
for these virtual delete: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-column"> columns .
Furthermore, note that no attempt is made to reconcile between locations or offers that may be associated with more than one event; every delete: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-row"> row in the delete: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-annotated-table"> table will create both a new location resource and offer resource in addition to the event resource. If considered necessary, applications such as OpenRefine may be used to identify and reconcile duplicate location resources once the RDF output has been generated.
The delete: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-annotated-table"> annotated table generated from parsing the tabular data file and associated metadata is shown below and provides the basis for the conversion to RDF.
Annotations for the resulting delete: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-annotated-table"> table T , with 10 delete: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-column"> columns and 2 delete: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-row"> rows , are shown below:
id | core annotations | ||
---|---|---|---|
url | columns | rows | |
T | http://example.org/events-listing.csv | C1 , C2 , C3 , C4 , C5 , C6 , C7 , C8 , C9 , C10 | R1 , R2 |
Annotations for the delete: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-column"> columns , delete: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-row"> rows and delete: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-cell"> cells in delete: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-annotated-table"> table T are shown in the tables below:
delete: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-column"> Column annotations:
C1 | T | 1 | 1 | C1.1 , C2.1 | name | Name | |
C2 | T | 2 | 2 | C1.2 , C2.2 | start_date | Start Date | |
C3 | T | 3 | 3 | C1.3 , C2.3 | location_name | Location Name | |
C4 | T | 4 | 4 | C1.4 , C2.4 | location_address | Location Address | |
C5 | T | 5 | 5 | C1.5 , C2.5 | ticket_url | Ticket Url | |
C6 | T | 6 | 6 | C1.6 , C2.6 | type_event | true | |
C7 | T | 7 | 7 | C1.7 , C2.7 | type_place | true | |
C8 | T | 8 | 8 | C1.8 , C2.8 | type_offer | true | |
C9 | T | 9 | 9 | C1.9 , C2.9 | location | true | |
C10 | T | 10 | 10 | C1.10 , C2.10 | offers | true |
delete: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-row"> Row annotations:
id | core annotations | |||
---|---|---|---|---|
table | number | source number | cells | |
R1 | T | 1 | 2 | C1.1 , C1.2 , C1.3 , C1.4 , C1.5 , C1.6 , C1.7 , C1.8 , C1.9 , C1.10 |
R2 | T | 2 | 3 | C2.1 , C2.2 , C2.3 , C2.4 , C2.5 , C2.6 , C2.7 , C2.8 , C2.9 , C2.10 |
delete: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-cell"> Cell annotations:
id | core annotations | |||||||
---|---|---|---|---|---|---|---|---|
table | column | row | string value | value | about URL | property URL | value URL | |
C1.1 | T | C1 | R1 | "B.B. King" | "B.B. King" | <http://example.org/events-listing.csv#event-1> | schema:name | |
C1.2 | T | C2 | R1 | "2014-04-12T19:30" | 2014-04-12T19:30:00 | <http://example.org/events-listing.csv#event-1> | schema:startDate | |
C1.3 | T | C3 | R1 | "Lupo’s Heartbreak Hotel" | "Lupo’s Heartbreak Hotel" | <http://example.org/events-listing.csv#place-1> | schema:name | |
C1.4 | T | C4 | R1 | "79 Washington St., Providence, RI" | "79 Washington St., Providence, RI" | <http://example.org/events-listing.csv#place-1> | schema:address | |
C1.5 | T | C5 | R1 | "https://www.etix.com/ticket/1771656" | <https://www.etix.com/ticket/1771656> | <http://example.org/events-listing.csv#offer-1> | schema:url | |
C1.6 | T | C6 | R1 | "" | null | <http://example.org/events-listing.csv#event-1> | rdf:type | schema:MusicEvent |
C1.7 | T | C7 | R1 | "" | null | <http://example.org/events-listing.csv#place-1> | rdf:type | schema:Place |
C1.8 | T | C8 | R1 | "" | null | <http://example.org/events-listing.csv#offer-1> | rdf:type | schema:Offer |
C1.9 | T | C9 | R1 | "" | null | <http://example.org/events-listing.csv#event-1> | schema:location | <http://example.org/events-listing.csv#place-1> |
C1.10 | T | C10 | R1 | "" | null | <http://example.org/events-listing.csv#event-1> | schema:offers | <http://example.org/events-listing.csv#offer-1> |
C2.1 | T | C1 | R2 | "B.B. King" | "B.B. King" | <http://example.org/events-listing.csv#event-2> | schema:name | |
C2.2 | T | C2 | R2 | "2014-04-13T20:00" | 2014-04-13T20:00:00 | <http://example.org/events-listing.csv#event-2> | schema:startDate | |
C2.3 | T | C3 | R2 | "Lynn Auditorium" | "Lynn Auditorium" | <http://example.org/events-listing.csv#place-2> | schema:name | |
C2.4 | T | C4 | R2 | "Lynn, MA, 01901" | "Lynn, MA, 01901" | <http://example.org/events-listing.csv#place-2> | schema:address | |
C2.5 | T | C5 | R2 | "http://frontgatetickets.com/venue.php?id=11766" | <http://frontgatetickets.com/venue.php?id=11766> | <http://example.org/events-listing.csv#offer-2> | schema:url | |
C2.6 | T | C6 | R2 | "" | null | <http://example.org/events-listing.csv#event-2> | rdf:type | schema:MusicEvent |
C2.7 | T | C7 | R2 | "" | null | <http://example.org/events-listing.csv#place-2> | rdf:type | schema:Place |
C2.8 | T | C8 | R2 | "" | null | <http://example.org/events-listing.csv#offer-2> | rdf:type | schema:Offer |
C2.9 | T | C9 | R2 | "" | null | <http://example.org/events-listing.csv#event-2> | schema:location | <http://example.org/events-listing.csv#place-2> |
C2.10 | T | C10 | R2 | "" | null | <http://example.org/events-listing.csv#event-2> | schema:offers | <http://example.org/events-listing.csv#offer-2> |
delete: <a href="#dfn-minimal-mode" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-minimal-mode"> Minimal mode output for this example is provided in [ delete: <a class="bibref" href="#bib-turtle"> insert: <a href="#bib-turtle" class="bibref"> turtle ] syntax below:
@base < http : //example.org/events-listing.csv> . @prefix schema : < http : //schema.org/> . @prefix xsd : < http : //www.w3.org/2001/XMLSchema#> . <# event - 1 > a schema : MusicEvent ; schema : name "B.B. King" ; schema : startDate "2014-04-12T19:30:00" ^^ xsd : dateTime ; schema : location <# place - 1 > ; schema : offers <# offer - 1 > . <# place - 1 > a schema : Place ; schema : name "Lupo’s Heartbreak Hotel" ; schema : address "79 Washington St., Providence, RI" . <# offer - 1 > a schema : Offer ; schema : url "https://www.etix.com/ticket/1771656" ^^ xsd : anyURI . <# event - 2 > a schema : MusicEvent ; schema : name "B.B. King" ; schema : startDate "2014-04-13T20:00:00" ^^ xsd : dateTime ; schema : location <# place - 2 > ; schema : offers <# offer - 2 > . <# place - 2 > a schema : Place ; schema : name "Lynn Auditorium" ; schema : address "Lynn, MA, 01901" . <# offer - 2 > a schema : Offer ; schema : url "http://frontgatetickets.com/venue.php?id=11766" ^^ xsd : anyURI .
Three resources are defined for each row within the table; event, location, and offer.
Each delete: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-column"> column description in the metadata explicitly defines both delete: <a href="http://www.w3.org/TR/2015/PR-tabular-metadata-20151117/#cell-aboutUrl"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-metadata-20151217/#cell-aboutUrl"> aboutUrl
and delete: <a href="http://www.w3.org/TR/2015/PR-tabular-metadata-20151117/#cell-propertyUrl"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-metadata-20151217/#cell-propertyUrl"> propertyUrl
properties which are used to create the delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-about-url" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-cell-about-url" class="externalDFN"> about URL and delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-property-url" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-cell-property-url" class="externalDFN"> property URL annotations on the column's delete: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-cell"> cells .
delete: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-column"> Columns C6 , C7 and C8 ( { "name": "type_event"}
, { "name": "type_place"}
and { "name": "type_offer"}
) define the semantic types of the resources described by each delete: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-row"> row : schema:MusicEvent
, schema:Place
and schema:Offer
respectively.
delete: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-column"> Column C9 ( { "name": "location"}
) uses the delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-about-url" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-cell-about-url" class="externalDFN"> about URL , delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-property-url" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-cell-property-url" class="externalDFN"> property URL and delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-value-url" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-cell-value-url" class="externalDFN"> value URL to assert the relationship between the event and location resources.
delete: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-column"> Column C10 ( { "name": "offer"}
) uses the delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-about-url" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-cell-about-url" class="externalDFN"> about URL , delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-property-url" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-cell-property-url" class="externalDFN"> property URL and delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-value-url" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-cell-value-url" class="externalDFN"> value URL to assert the relationship between the event and offer resources.
delete: <a href="#dfn-standard-mode" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-standard-mode"> Standard mode output for this example is provided in [ delete: <a class="bibref" href="#bib-turtle"> insert: <a href="#bib-turtle" class="bibref"> turtle ] syntax below:
@base < http : //example.org/events-listing.csv> . @prefix csvw : < http : //www.w3.org/ns/csvw#> . @prefix schema : < http : //schema.org/> . @prefix xsd : < http : //www.w3.org/2001/XMLSchema#> . _ : 95cc7970 - ce99 - 44b0 - 900c - e2c2c028bbd3 a csvw : TableGroup ; csvw : table [ a csvw : Table ; csvw : url < http : //example.org/events-listing.csv> ; csvw : row [ a csvw : Row ; csvw : rownum 1 ; csvw : url <# row = 2 > ; csvw : describes <# event - 1 >, <# place - 1 >, <# offer - 1 > ], [ a csvw : Row ; csvw : rownum 2 ; csvw : url <# row = 3 > ; csvw : describes <# event - 2 >, <# place - 2 >, <# offer - 2 > ] ] . <# event - 1 > a schema : MusicEvent ; schema : name "B.B. King" ; schema : startDate "2014-04-12T19:30:00" ^^ xsd : dateTime ; schema : location <# place - 1 > ; schema : offers <# offer - 1 > . <# place - 1 > a schema : Place ; schema : name "Lupo’s Heartbreak Hotel" ; schema : address "79 Washington St., Providence, RI" . <# offer - 1 > a schema : Offer ; schema : url "https://www.etix.com/ticket/1771656" ^^ xsd : anyURI . <# event - 2 > a schema : MusicEvent ; schema : name "B.B. King" ; schema : startDate "2014-04-13T20:00:00" ^^ xsd : dateTime ; schema : location <# place - 2 > ; schema : offers <# offer - 2 > . <# place - 2 > a schema : Place ; schema : name "Lynn Auditorium" ; schema : address "Lynn, MA, 01901" . <# offer - 2 > a schema : Offer ; schema : url "http://frontgatetickets.com/venue.php?id=11766" ^^ xsd : anyURI .
The resources described by each delete: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-row"> row are explicitly defined using the delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-about-url" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-cell-about-url" class="externalDFN"> about URL annotation this case three resources per delete: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-row"> row (event, location, and offer). The relationship between the delete: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-row"> row and each delete: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-subject"> subject resource is asserted using the csvw:describes
property; e.g. for delete: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-row"> row R1 , a delete: <a href="#dfn-blank-node" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-blank-node"> blank node , we state the following triples:
csvw:describes
t1:event-1
csvw:describes
t1:place-1
csvw:describes
t1:offer-1
This example is based on Use Case #4 - Publication of public sector roles and salaries and uses four delete: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-annotated-table"> annotated tables published as a delete: <a href="#dfn-group-of-tables" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-group-of-tables"> group of tables . Information about senior roles and junior roles within a government department or organization are published in CSV format by each department. These are validated against a centrally published delete: <a href="http://www.w3.org/TR/2015/PR-tabular-metadata-20151117/#dfn-schema" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-metadata-20151217/#dfn-schema" class="externalDFN"> schema to ensure that all the data published by departments is consistent. Additionally, lists of organizations and professions are also published centrally, providing controlled vocabularies against which departmental submissions are validated.
Information published about junior and senior roles provides summary information for each post within the government department or organization. Whilst the junior role information is anonymous, providing only an indication of the number of full-time-equivalent (FTE) staff occupying a given post, the senior role information specifies the named individual occupying each post. As such, each delete: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-row"> row from the tabular data file describing senior roles corresponds to two resources; the post and the person occupying that post.
This example is concerned only with converting the information provided by each government department or organization rather than the centrally published information listing organizations and professions.
The input tabular data files and associated metadata descriptions are provided below:
Organization Unique Reference,Organization Name,Department Reference hefce.ac.uk,Higher Education Funding Council for England,bis.gov.uk bis.gov.uk,"Department for Business, Innovation and Skills",xx
Profession Finance Information Technology Operational Delivery Policy
Post Unique Reference,Name,Grade,Job Title,Reports to Senior Post,Profession,Organization Reference 90115,Steve Egan,SCS1A,Deputy Chief Executive,90334,Finance,hefce.ac.uk 90334,Sir Alan Langlands,SCS4,Chief Executive,xx,Policy,hefce.ac.uk
Reporting Senior Post,Grade,Payscale Minimum (£),Payscale Maximum (£),Generic Job Title,Number of Posts (FTE),Profession,Organization Reference 90115,4,17426,20002,Administrator,8.67,Operational Delivery,hefce.ac.uk 90115,5,19546,22478,Administrator,0.5,Operational Delivery,hefce.ac.uk
{ "@type" : "TableGroup" , "@context" : [ "http://www.w3.org/ns/csvw" , { "@language" : "en" }], "tables" : [{ "url" : "gov.uk/data/organizations.csv" , "tableSchema" : "gov.uk/schema/organizations.json" , "suppressOutput" : true }, { "url" : "gov.uk/data/professions.csv" , "tableSchema" : "gov.uk/schema/professions.json" , "suppressOutput" : true }, { "url" : "senior-roles.csv" , "tableSchema" : "gov.uk/schema/senior-roles.json" }, { "url" : "junior-roles.csv" , "tableSchema" : "gov.uk/schema/junior-roles.json" }] }
{ "@id" : "http://example.org/gov.uk/schema/organizations.json" , "@context" : "http://www.w3.org/ns/csvw" , "columns" : [{ "name" : "ref" , "titles" : "Organization Unique Reference" , "datatype" : "string" , "required" : true , "propertyUrl" : "dc:identifier" }, { "name" : "name" , "titles" : "Organization Name" , "datatype" : "string" , "propertyUrl" : "foaf:name" }, { "name" : "department" , "titles" : "Department Reference" , "datatype" : "string" , "null" : "xx" , "propertyUrl" : "org:subOrganizationOf" , "valueUrl" : "http://example.org/organization/{department}" }], "primaryKey" : "ref" , "aboutUrl" : "http://example.org/organization/{ref}" , "foreignKeys" : [{ "columnReference" : "department" , "reference" : { "schemaReference" : "http://example.org/gov.uk/schema/organizations.json" , "columnReference" : "ref" } }] }
{ "@id" : "http://example.org/gov.uk/schema/professions.json" , "@context" : "http://www.w3.org/ns/csvw" , "columns" : [{ "name" : "name" , "titles" : "Profession" , "datatype" : "string" , "required" : true }], "primaryKey" : "name" }
{ "@id" : "http://example.org/gov.uk/schema/senior-roles.json" , "@context" : "http://www.w3.org/ns/csvw" , "columns" : [{ "name" : "ref" , "titles" : "Post Unique Reference" , "datatype" : "string" , "required" : true , "propertyUrl" : "dc:identifier" }, { "name" : "name" , "titles" : "Name" , "datatype" : "string" , "aboutUrl" : "http://example.org/organization/{organizationRef}/person/{_row}" , "propertyUrl" : "foaf:name" }, { "name" : "grade" , "titles" : "Grade" , "datatype" : "string" , "propertyUrl" : "http://example.org/gov.uk/def/grade" }, { "name" : "job" , "titles" : "Job Title" , "datatype" : "string" , "propertyUrl" : "http://example.org/gov.uk/def/job" }, { "name" : "reportsTo" , "titles" : "Reports to Senior Post" , "datatype" : "string" , "null" : "xx" , "propertyUrl" : "org:reportsTo" , "valueUrl" : "http://example.org/organization/{organizationRef}/post/{reportsTo}" }, { "name" : "profession" , "titles" : "Profession" , "datatype" : "string" , "propertyUrl" : "http://example.org/gov.uk/def/profession" }, { "name" : "organizationRef" , "titles" : "Organization Reference" , "datatype" : "string" , "propertyUrl" : "org:postIn" , "valueUrl" : "http://example.org/organization/{organizationRef}" , "required" : true }, { "name" : "post_holder" , "virtual" : true , "propertyUrl" : "org:heldBy" , "valueUrl" : "http://example.org/organization/{organizationRef}/person/{_row}" }], "primaryKey" : "ref" , "aboutUrl" : "http://example.org/organization/{organizationRef}/post/{ref}" , "foreignKeys" : [{ "columnReference" : "reportsTo" , "reference" : { "schemaReference" : "http://example.org/gov.uk/schema/senior-roles.json" , "columnReference" : "ref" } }, { "columnReference" : "profession" , "reference" : { "schemaReference" : "http://example.org/gov.uk/schema/professions.json" , "columnReference" : "name" } }, { "columnReference" : "organizationRef" , "reference" : { "schemaReference" : "http://example.org/gov.uk/schema/organizations.json" , "columnReference" : "ref" } }] }
{ "@id" : "http://example.org/gov.uk/schema/junior-roles.json" , "@context" : "http://www.w3.org/ns/csvw" , "columns" : [{ "name" : "reportsToSenior" , "titles" : "Reporting Senior Post" , "datatype" : "string" , "propertyUrl" : "org:reportsTo" , "valueUrl" : "http://example.org/organization/{organizationRef}/post/{reportsToSenior}" , "required" : true }, { "name" : "grade" , "titles" : "Grade" , "datatype" : "string" , "propertyUrl" : "http://example.org/gov.uk/def/grade" }, { "name" : "min_pay" , "titles" : "Payscale Minimum (£)" , "datatype" : "integer" , "propertyUrl" : "http://example.org/gov.uk/def/min_pay" }, { "name" : "max_pay" , "titles" : "Payscale Maximum (£)" , "datatype" : "integer" , "propertyUrl" : "http://example.org/gov.uk/def/max_pay" }, { "name" : "job" , "titles" : "Generic Job Title" , "datatype" : "string" , "propertyUrl" : "http://example.org/gov.uk/def/job" }, { "name" : "number" , "titles" : "Number of Posts (FTE)" , "datatype" : "number" , "propertyUrl" : "http://example.org/gov.uk/def/number_of_posts" }, { "name" : "profession" , "titles" : "Profession" , "datatype" : "string" , "propertyUrl" : "http://example.org/gov.uk/def/profession" }, { "name" : "organizationRef" , "titles" : "Organization Reference" , "datatype" : "string" , "propertyUrl" : "org:postIn" , "valueUrl" : "http://example.org/organization/{organizationRef}" , "required" : true }], "foreignKeys" : [{ "columnReference" : "reportsToSenior" , "reference" : { "schemaReference" : "http://example.org/gov.uk/schema/senior-roles.json" , "columnReference" : "ref" } }, { "columnReference" : "profession" , "reference" : { "schemaReference" : "http://example.org/gov.uk/schema/professions.json" , "columns" : "name" } }, { "columnReference" : "organizationRef" , "reference" : { "schemaReference" : "http://example.org/gov.uk/schema/organizations.json" , "columns" : "ref" } }] }
This example makes extensive use of the example.org
domain. As described in [ delete: <a class="bibref" href="#bib-RFC6761"> insert: <a href="#bib-RFC6761" class="bibref"> RFC6761 ], this domain is used for illustrative examples within documentation. In reality, the resources described here with the URL path /gov.uk
would be centrally published by the UK Government at, say, the domain data.gov.uk
.
Given that these resources are centrally published with an aspiration for reuse, the delete: <a href="http://www.w3.org/TR/2015/PR-tabular-metadata-20151117/#dfn-schema-description" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-metadata-20151217/#dfn-schema-description" class="externalDFN"> schema descriptions have been factored out into separate resources. As such, the top-level metadata description resource metadata.json
simply provides the list of delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-table" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-table" class="externalDFN"> tables and binds each of them to the appropriate delete: <a href="http://www.w3.org/TR/2015/PR-tabular-metadata-20151117/#dfn-schema" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-metadata-20151217/#dfn-schema" class="externalDFN"> schema that is defined elsewhere.
Finally, note that because the centrally published metadata descriptions are intended to be reused across many government departments and organizations, extra consideration has been given to defining URIs for the person and post resources defined in each row of the senior roles tabular data and subsequently referenced from the junior roles tabular data. To ensure that naming clashes are avoided, the unique reference for the organization to which the person or post belongs has been included in a path segment of the identifier. For example, the delete: <a href="http://www.w3.org/TR/2015/PR-tabular-metadata-20151117/#dfn-uri-template-properties"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-metadata-20151217/#dfn-uri-template-property"> URI template property delete: <a href="http://www.w3.org/TR/2015/PR-tabular-metadata-20151117/#cell-aboutUrl"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-metadata-20151217/#cell-aboutUrl"> aboutUrl
used to identify the senior post is specified as http://example.org/organization/{organizationRef}/post/{ref}
, thus yielding the URI http://example.org/organization/hefce.ac.uk/post/90115
for the post described in the first delete: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-row"> row of the senior roles tabular data.
The delete: <a href="#dfn-group-of-tables" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-group-of-tables"> group of tables generated from parsing the tabular data files and associated metadata is shown below and provides the basis for the conversion to RDF.
Annotations for the delete: <a href="#dfn-group-of-tables" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-group-of-tables"> group of tables G and the four delete: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-annotated-table"> tables Ta , Tb , Tc , and Td are shown below:
delete: <a href="#dfn-group-of-tables" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-group-of-tables"> Group of Tables annotations:
id | core annotations |
---|---|
tables | |
G | Ta , Tb , Tc , Td |
delete: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-annotated-table"> Table annotations:
id | core annotations | ||||
---|---|---|---|---|---|
url | columns | rows | suppress output | foreign keys | |
Ta | http://example.org/gov.uk/data/organizations.csv | Ca1 , Ca2 , Ca3 | Ra1 , Ra2 | true | Fa1 |
Tb | http://example.org/gov.uk/professions.csv | Cb1 | Rb1 , Rb2 , Rb3 , Rb4 | true | |
Tc | http://example.org/senior-roles.csv | Cc1 , Cc2 , Cc3 , Cc4 , Cc5 , Cc6 | Rc1 , Rc2 | false | Fc1 , Fc2 , Fc3 |
Td | http://example.org/junior-roles.csv | Cd1 , Cd2 , Cd3 , Cd4 , Cd5 , Cd6 , Cd7 | Rd1 , Rd2 | false | Fd1 , Fd2 , Fd3 |
In this example, output for the centrally published lists of organizations and professions, tables Ta and Tb ( http://example.org/gov.uk/data/organizations.csv
and http://example.org/gov.uk/data/professions.csv
respectively), are not required; only information from the departmental submissions is to be translated to RDF. Note the delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-table-suppress-output" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-table-suppress-output" class="externalDFN"> suppress output annotation on this delete: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-annotated-table"> table .
The following foreign keys are defined:
id | columns in table | columns in referenced table |
---|---|---|
Fa1 | Ca3 | Ca1 |
Fc1 | Cc5 | Cc1 |
Fc2 | Cc6 | Cb1 |
Fc3 | Cc7 | Ca1 |
Fd1 | Cd1 | Cc1 |
Fd2 | Cd7 | Cb1 |
Fd3 | Cd8 | Ca1 |
Annotations for the delete: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-column"> columns , delete: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-row"> rows and delete: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-cell"> cells in delete: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-annotated-table"> table T are shown in the tables below:
delete: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-column"> Column annotations:
id | core annotations | |||||||
---|---|---|---|---|---|---|---|---|
table | number | source number | cells | name | titles | required | virtual | |
Ca1 | Ta | 1 | 1 | Ca1.1 , Ca2.1 | ref | Organization Unique Reference | true | |
Ca2 | Ta | 1 | 1 | Ca1.2 , Ca2.2 | name | Organization Name | ||
Ca3 | Ta | 1 | 1 | Ca1.3 , Ca2.3 | department | Department Reference | ||
Cb1 | Tb | 1 | 1 | Cb1.1 , Cb2.1 , Cb3.1 , Cb4.1 | name | Profession | true | |
Cc1 | Tc | 1 | 1 | Cc1.1 , Cc2.1 | ref | Post Unique Reference | true | |
Cc2 | Tc | 2 | 2 | Cc1.2 , Cc2.2 | name | Name | ||
Cc3 | Tc | 3 | 3 | Cc1.3 , Cc2.3 | grade | Grade | ||
Cc4 | Tc | 4 | 4 | Cc1.4 , Cc2.4 | job | Job Title | ||
Cc5 | Tc | 5 | 5 | Cc1.5 , Cc2.5 | reportsTo | Reports to Senior Post | ||
Cc6 | Tc | 6 | 6 | Cc1.6 , Cc2.6 | profession | Profession | ||
Cc7 | Tc | 7 | 7 | Cc1.7 , Cc2.7 | organizationRef | Organization Reference | true | |
Cc8 | Tc | 8 | 8 | Cc1.8 , Cc2.8 | post_holder | true | ||
Cd1 | Td | 1 | 1 | Cd1.1 , Cd2.1 | reportsToSenior | Reporting Senior Post | true | |
Cd2 | Td | 2 | 2 | Cd1.2 , Cd2.2 | grade | Grade | ||
Cd3 | Td | 3 | 3 | Cd1.3 , Cd2.3 | min_pay | Payscale Minimum (£) | ||
Cd4 | Td | 4 | 4 | Cd1.4 , Cd2.4 | max_pay | Payscale Maximum (£) | ||
Cd5 | Td | 5 | 5 | Cd1.5 , Cd2.5 | job | Generic Job Title | ||
Cd6 | Td | 6 | 6 | Cd1.6 , Cd2.6 | number | Number of Posts (FTE) | ||
Cd7 | Td | 7 | 7 | Cd1.7 , Cd2.7 | profession | Profession | ||
Cd8 | Td | 8 | 8 | Cd1.8 , Cd2.8 | organizationRef | Organization Reference | true |
delete: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-column"> Column Cc8 , with the delete: <a href="http://www.w3.org/TR/2015/PR-tabular-metadata-20151117/#column-virtual"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-metadata-20151217/#column-virtual"> virtual
annotation specified as true
, is used to relate the person resource, whose name is provided in delete: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-column"> column Cc2 , to the associated post resource within the current delete: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-row"> row of delete: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-annotated-table"> table Tc ( { "url": "http://example.org/senior-roles.csv" }
).
delete: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-row"> Row annotations:
id | core annotations | |||
---|---|---|---|---|
table | number | source number | cells | |
Ra1 | Ta | 1 | 2 | Ca1.1 , Ca1.2 , Ca1.3 |
Ra2 | Ta | 2 | 3 | Ca2.1 , Ca2.2 , Ca2.3 |
Rb1 | Tb | 1 | 2 | Cb1.1 |
Rb2 | Tb | 2 | 3 | Cb2.1 |
Rb3 | Tb | 3 | 4 | Cb3.1 |
Rb4 | Tb | 4 | 5 | Cb4.1 |
Rc1 | Tc | 1 | 2 | Cc1.1 , Cc1.2 , Cc1.3 , Cc1.4 , Cc1.5 , Cc1.6 , Cc1.7 , Cc1.8 |
Rc2 | Tc | 2 | 3 | Cc2.1 , Cc2.2 , Cc2.3 , Cc2.4 , Cc2.5 , Cc2.6 , Cc2.7 , Cc2.8 |
Rd1 | Td | 1 | 2 | Cd1.1 , Cd1.2 , Cd1.3 , Cd1.4 , Cd1.5 , Cd1.6 , Cd1.7 , Cd1.8 |
Rd2 | Td | 2 | 3 | Cd2.1 , Cd2.2 , Cd2.3 , Cd2.4 , Cd2.5 , Cd2.6 , Cd2.7 , Cd2.8 |
delete: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-cell"> Cell annotations:
id | core annotations | |||||||
---|---|---|---|---|---|---|---|---|
table | column | row | string value | value | about URL | property URL | value URL | |
Ca1.1 | Ta | Ca1 | Ra1 | "hefce.ac.uk" | "hefce.ac.uk" | <http://example.org/organization/hefce.ac.uk> | dc:identifier | |
Ca1.2 | Ta | Ca2 | Ra1 | "Higher Education Funding Council for England" | "Higher Education Funding Council for England" | <http://example.org/organization/hefce.ac.uk> | foaf:name | |
Ca1.3 | Ta | Ca3 | Ra1 | "bis.gov.uk" | "bis.gov.uk" | <http://example.org/organization/hefce.ac.uk> | org:subOrganizationOf | <http://example.org/organization/bis.gov.uk> |
Ca2.1 | Ta | Ca1 | Ra2 | "bis.gov.uk" | "bis.gov.uk" | <http://example.org/organization/bis.gov.uk> | dc:identifier | |
Ca2.2 | Ta | Ca2 | Ra2 | "Department for Business, Innovation and Skills" | "Department for Business, Innovation and Skills" | <http://example.org/organization/bis.gov.uk> | foaf:name | |
Ca2.3 | Ta | Ca3 | Ra2 | "xx" | null | <http://example.org/organization/bis.gov.uk> | org:subOrganizationOf | |
Cb1.1 | Tb | Cb1 | Rb1 | "Finance" | "Finance" | |||
Cb2.1 | Tb | Cb1 | Rb2 | "Information Technology" | "Information Techology" | |||
Cb3.1 | Tb | Cb1 | Rb3 | "Operational Delivery" | "Operational Delivery" | |||
Cb4.1 | Tb | Cb1 | Rb4 | "Policy" | "Policy" | |||
Cc1.1 | Tc | Cc1 | Rc1 | "90115" | "90115" | <http://example.org/organization/hefce.ac.uk/post/90115> | dc:identifier | |
Cc1.2 | Tc | Cc2 | Rc1 | "Steve Egan" | "Steve Egan" | <http://example.org/organization/hefce.ac.uk/person/1> | foaf:name | |
Cc1.3 | Tc | Cc3 | Rc1 | "SCS1A" | "SCS1A" | <http://example.org/organization/hefce.ac.uk/post/90115> | <http://example.org/gov.uk/def/grade> | |
Cc1.4 | Tc | Cc4 | Rc1 | "Deputy Chief Executive" | "Deputy Chief Executive" | <http://example.org/organization/hefce.ac.uk/post/90115> | <http://example.org/gov.uk/def/job> | |
Cc1.5 | Tc | Cc5 | Rc1 | "90334" | "90334" | <http://example.org/organization/hefce.ac.uk/post/90115> | org:reportsTo | <http://example.org/organization/hefce.ac.uk/post/90334> |
Cc1.6 | Tc | Cc6 | Rc1 | "Finance" | "Finance" | <http://example.org/organization/hefce.ac.uk/post/90115> | <http://example.org/gov.uk/def/profession> | |
Cc1.7 | Tc | Cc7 | Rc1 | "hefce.ac.uk" | "hefce.ac.uk" | <http://example.org/organization/hefce.ac.uk/post/90115> | org:postIn | <http://example.org/organization/hefce.ac.uk> |
Cc1.8 | Tc | Cc8 | Rc1 | "" | null | <http://example.org/organization/hefce.ac.uk/post/90115> | org:heldBy | <http://example.org/organization/hefce.ac.uk/person/1> |
Cc2.1 | Tc | Cc1 | Rc2 | "90334" | "90334" | <http://example.org/organization/hefce.ac.uk/post/90334> | dc:identifier | |
Cc2.2 | Tc | Cc2 | Rc2 | "Sir Alan Langlands" | "Sir Alan Langlands" | <http://example.org/organization/hefce.ac.uk/person/2> | foaf:name | |
Cc2.3 | Tc | Cc3 | Rc2 | "SCS4" | "SCS4" | <http://example.org/organization/hefce.ac.uk/post/90334> | <http://example.org/gov.uk/def/grade> | |
Cc2.4 | Tc | Cc4 | Rc2 | "Chief Executive" | "Chief Executive" | <http://example.org/organization/hefce.ac.uk/post/90334> | <http://example.org/gov.uk/def/job> | |
Cc2.5 | Tc | Cc5 | Rc2 | "xx" | null | <http://example.org/organization/hefce.ac.uk/post/90334> | org:reportsTo | |
Cc2.6 | Tc | Cc6 | Rc2 | "Policy" | "Policy" | <http://example.org/organization/hefce.ac.uk/post/90334> | <http://example.org/gov.uk/def/profession> | |
Cc2.7 | Tc | Cc7 | Rc2 | "hefce.ac.uk" | "hefce.ac.uk" | <http://example.org/organization/hefce.ac.uk/post/90334> | org:postIn | <http://example.org/organization/hefce.ac.uk> |
Cc2.8 | Tc | Cc8 | Rc2 | "" | null | <http://example.org/organization/hefce.ac.uk/post/90334> | org:heldBy | <http://example.org/organization/hefce.ac.uk/person/2> |
Cd1.1 | Td | Cd1 | Rd1 | "90115" | "90115" | org:reportsTo | <http://example.org/organization/hefce.ac.uk/post/90115> | |
Cd1.2 | Td | Cd2 | Rd1 | "4" | "4" | <http://example.org/gov.uk/def/grade> | ||
Cd1.3 | Td | Cd3 | Rd1 | "17426" | 17426 | <http://example.org/gov.uk/def/min_pay> | ||
Cd1.4 | Td | Cd4 | Rd1 | "20002" | 20002 | <http://example.org/gov.uk/def/max_pay> | ||
Cd1.5 | Td | Cd5 | Rd1 | "Administrator" | "Administrator" | <http://example.org/gov.uk/def/job> | ||
Cd1.6 | Td | Cd6 | Rd1 | "8.67" | 8.67 | <http://example.org/gov.uk/def/number_of_posts> | ||
Cd1.7 | Td | Cd7 | Rd1 | "Operational Delivery" | "Operational Delivery" | <http://example.org/gov.uk/def/profession> | ||
Cd1.8 | Td | Cd8 | Rd1 | "hefce.ac.uk" | "hefce.ac.uk" | org:postIn | <http://example.org/organization/hefce.ac.uk> | |
Cd2.1 | Td | Cd1 | Rd2 | "90115" | "90115" | org:reportsTo | <http://example.org/organization/hefce.ac.uk/post/90115> | |
Cd2.2 | Td | Cd2 | Rd2 | "5" | "5" | <http://example.org/gov.uk/def/grade> | ||
Cd2.3 | Td | Cd3 | Rd2 | "19546" | 19546 | <http://example.org/gov.uk/def/min_pay> | ||
Cd2.4 | Td | Cd4 | Rd2 | "22478" | 22478 | <http://example.org/gov.uk/def/max_pay> | ||
Cd2.5 | Td | Cd5 | Rd2 | "Administrator" | "Administrator" | <http://example.org/gov.uk/def/job> | ||
Cd2.6 | Td | Cd6 | Rd2 | "0.5" | 0.5 | <http://example.org/gov.uk/def/number_of_posts> | ||
Cd2.7 | Td | Cd7 | Rd2 | "Operational Delivery" | "Operational Delivery" | <http://example.org/gov.uk/def/profession> | ||
Cd2.8 | Td | Cd8 | Rd2 | "hefce.ac.uk" | "hefce.ac.uk" | org:postIn | <http://example.org/organization/hefce.ac.uk> |
Notice that delete: <a href="#dfn-value-url" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-value-url"> value URL is not specified for delete: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-cell"> cells Ca2.3 and Cc2.5 because in each case the delete: <a href="#dfn-cell-value" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-cell-value"> cell value is null
and the delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-virtual" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-column-virtual" class="externalDFN"> virtual annotation of delete: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-column"> column Cb5 is not defined.
delete: <a href="#dfn-minimal-mode" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-minimal-mode"> Minimal mode output for this example is provided in [ delete: <a class="bibref" href="#bib-turtle"> insert: <a href="#bib-turtle" class="bibref"> turtle ] syntax below:
@prefix dc : < http : //purl.org/dc/terms/> . @prefix foaf : < http : //xmlns.com/foaf/0.1/> . @prefix org : < http : //www.w3.org/ns/org#> . @prefix xsd : < http : //www.w3.org/2001/XMLSchema#> . < http : //example.org/organization/hefce.ac.uk/post/90115> dc : identifier "90115" ; org : heldBy < http : //example.org/organization/hefce.ac.uk/person/1> ; < http : //example.org/gov.uk/def/grade> "SCS1A" ; < http : //example.org/gov.uk/def/job> "Deputy Chief Executive" ; org : reportsTo < http : //example.org/organization/hefce.ac.uk/post/90334> ; < http : //example.org/gov.uk/def/profession> "Finance" ; org : postIn < http : //example.org/organization/hefce.ac.uk> . < http : //example.org/organization/hefce.ac.uk/person/1> foaf : name "Steve Egan" . < http : //example.org/organization/hefce.ac.uk/post/90334> dc : identifier "90334" ; org : heldBy < http : //example.org/organization/hefce.ac.uk/person/2> ; < http : //example.org/gov.uk/def/grade> "SCS4" ; < http : //example.org/gov.uk/def/job> "Chief Executive" ; < http : //example.org/gov.uk/def/profession> "Policy" ; org : postIn < http : //example.org/organization/hefce.ac.uk> . < http : //example.org/organization/hefce.ac.uk/person/2> foaf : name "Sir Alan Langlands" . _ : d8b8e40c - 8c74 - 458b - 99f7 - 64d1cf5c65f2 org : reportsTo < http : //example.org/organization/hefce.ac.uk/post/90115> ; < http : //example.org/gov.uk/def/grade> "4" ; < http : //example.org/gov.uk/def/min_pay> "17426"^^xsd:integer ; < http : //example.org/gov.uk/def/max_pay> "20002"^^xsd:integer ; < http : //example.org/gov.uk/def/job> "Administrator" ; < http : //example.org/gov.uk/def/number_of_posts> "8.67"^^xsd:double ; < http : //example.org/gov.uk/def/profession> "Operational Delivery" ; org : postIn < http : //example.org/organization/hefce.ac.uk> . _ : fa1fa954 - dd5f - 4aa1 - b2bc - 20bf9867fac6 org : reportsTo < http : //example.org/organization/hefce.ac.uk/post/90115> ; < http : //example.org/gov.uk/def/grade> "5" ; < http : //example.org/gov.uk/def/min_pay> "19546"^^xsd:integer ; < http : //example.org/gov.uk/def/max_pay> "22478"^^xsd:integer ; < http : //example.org/gov.uk/def/job> "Administrator" ; < http : //example.org/gov.uk/def/number_of_posts> "0.5"^^xsd:double ; < http : //example.org/gov.uk/def/profession> "Operational Delivery" ; org : postIn < http : //example.org/organization/hefce.ac.uk> .
Output for delete: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-annotated-table"> tables Ta and Tb ( { "url": "http://example.org/gov.uk/data/organizations.csv" }
and { "url": "http://example.org/gov.uk/data/professions.csv" }
) are not included as the delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-table-suppress-output" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-table-suppress-output" class="externalDFN"> suppress output annotation is true
.
The delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-property-url" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-cell-property-url" class="externalDFN"> property URL is specified for all delete: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-cell"> cells in delete: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-annotated-table"> tables Tc and Td .
delete: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-column"> Columns Cc5 and Cd1 ( { "name": "reportsTo" }
and { "name": "reportsToSenior" }
) use the delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-about-url" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-cell-about-url" class="externalDFN"> about URL , delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-property-url" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-cell-property-url" class="externalDFN"> property URL and delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-value-url" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-cell-value-url" class="externalDFN"> value URL annotations to assert the relationship between the post described by a given delete: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-row"> row and the senior post to which it reports.
Similarly, delete: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-column"> columns Cc7 and Cd8 (both with { "name": "organizationRef" }
) use the delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-about-url" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-cell-about-url" class="externalDFN"> about URL , delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-property-url" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-cell-property-url" class="externalDFN"> property URL and delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-value-url" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-cell-value-url" class="externalDFN"> value URL annotations to assert the relationship between the post described by a given delete: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-row"> row and the organization to which it belongs.
Finally, note that two resources are created for each delete: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-row"> row within delete: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-annotated-table"> table Tc ( { "url": "http://example.org/senior-roles.csv" }
): the person and the post they occupy. The relationship between these resources is specified via virtual delete: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-column"> column Cc8 ( { "name": "post_holder" }
) using the delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-about-url" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-cell-about-url" class="externalDFN"> about URL , delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-property-url" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-cell-property-url" class="externalDFN"> property URL and delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-value-url" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-cell-value-url" class="externalDFN"> value URL annotations.
delete: <a href="#dfn-standard-mode" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-standard-mode"> Standard mode output for this example is provided in [ delete: <a class="bibref" href="#bib-turtle"> insert: <a href="#bib-turtle" class="bibref"> turtle ] syntax below:
@prefix csvw : < http : //www.w3.org/ns/csvw#> . @prefix dc : < http : //purl.org/dc/terms/> . @prefix foaf : < http : //xmlns.com/foaf/0.1/> . @prefix org : < http : //www.w3.org/ns/org#> . @prefix xsd : < http : //www.w3.org/2001/XMLSchema#> . _ : 3d36cfbb - d2d5 - 4573 - a1a7 - 3bf817062db8 a csvw : TableGroup ; csvw : table [ a csvw : Table ; csvw : url < http : //example.org/senior-roles.csv> ; csvw : row [ a csvw : Row ; csvw : rownum "1" ^^ xsd : integer ; csvw : url < http : //example.org/senior-roles.csv#row=2> ; csvw : describes < http : //example.org/organization/hefce.ac.uk/post/90115>, <http://example.org/organization/hefce.ac.uk/person/1> ], [ a csvw : Row ; csvw : rownum "2" ^^ xsd : integer ; csvw : url < http : //example.org/senior-roles.csv#row=3> ; csvw : describes < http : //example.org/organization/hefce.ac.uk/post/90334>, <http://example.org/organization/hefce.ac.uk/person/2> ] ], [ a csvw : Table ; csvw : url < http : //example.org/junior-roles.csv> ; csvw : row [ a csvw : Row ; csvw : rownum "1" ^^ xsd : integer ; csvw : url < http : //example.org/junior-roles.csv#row=2> ; csvw : describes _ : d8b8e40c - 8c74 - 458b - 99f7 - 64d1cf5c65f2 ], [ a csvw : Row ; csvw : rownum "2" ^^ xsd : integer ; csvw : url < http : //example.org/junior-roles.csv#row=3> ; csvw : describes _ : fa1fa954 - dd5f - 4aa1 - b2bc - 20bf9867fac6 ] ] . < http : //example.org/organization/hefce.ac.uk/post/90115> dc : identifier "90115" ; org : heldBy < http : //example.org/organization/hefce.ac.uk/person/1> ; < http : //example.org/gov.uk/def/grade> "SCS1A" ; < http : //example.org/gov.uk/def/job> "Deputy Chief Executive" ; org : reportsTo < http : //example.org/organization/hefce.ac.uk/post/90334> ; < http : //example.org/gov.uk/def/profession> "Finance" ; org : postIn < http : //example.org/organization/hefce.ac.uk> . < http : //example.org/organization/hefce.ac.uk/person/1> foaf : name "Steve Egan" . < http : //example.org/organization/hefce.ac.uk/post/90334> dc : identifier "90334" ; org : heldBy < http : //example.org/organization/hefce.ac.uk/person/2> ; < http : //example.org/gov.uk/def/grade> "SCS4" ; < http : //example.org/gov.uk/def/job> "Chief Executive" ; < http : //example.org/gov.uk/def/profession> "Policy" ; org : postIn < http : //example.org/organization/hefce.ac.uk> . < http : //example.org/organization/hefce.ac.uk/person/2> foaf : name "Sir Alan Langlands" . _ : d8b8e40c - 8c74 - 458b - 99f7 - 64d1cf5c65f2 org : reportsTo < http : //example.org/organization/hefce.ac.uk/post/90115> ; < http : //example.org/gov.uk/def/grade> "4" ; < http : //example.org/gov.uk/def/min_pay> "17426"^^xsd:integer ; < http : //example.org/gov.uk/def/max_pay> "20002"^^xsd:integer ; < http : //example.org/gov.uk/def/job> "Administrator" ; < http : //example.org/gov.uk/def/number_of_posts> "8.67"^^xsd:double ; < http : //example.org/gov.uk/def/profession> "Operational Delivery" ; org : postIn < http : //example.org/organization/hefce.ac.uk> . _ : fa1fa954 - dd5f - 4aa1 - b2bc - 20bf9867fac6 org : reportsTo < http : //example.org/organization/hefce.ac.uk/post/90115> ; < http : //example.org/gov.uk/def/grade> "5" ; < http : //example.org/gov.uk/def/min_pay> "19546"^^xsd:integer ; < http : //example.org/gov.uk/def/max_pay> "22478"^^xsd:integer ; < http : //example.org/gov.uk/def/job> "Administrator" ; < http : //example.org/gov.uk/def/number_of_posts> "0.5"^^xsd:double ; < http : //example.org/gov.uk/def/profession> "Operational Delivery" ; org : postIn < http : //example.org/organization/hefce.ac.uk> .
delete: <a data-lt="group of tables" href="#dfn-group-of-tables" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-group-of-tables" data-lt="group of tables"> Table group G was explicitly defined, but has not been explicitly identified; the table group and table resources are treated as delete: <a href="#dfn-blank-node" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-blank-node"> blank nodes .
The person and post resources described by each delete: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-row"> row of delete: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-annotated-table"> table Tc ( { "url": "http://example.org/senior-roles.csv"}
) are explcitly defined using the delete: <a href="http://www.w3.org/TR/2015/PR-tabular-metadata-20151117/#cell-aboutUrl"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-metadata-20151217/#cell-aboutUrl"> aboutUrl
property; therefore, say, for delete: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-row"> row Rc1 we state the following triples:
csvw:describes
<http://example.org/organization/hefce.ac.uk/post/90115>
csvw:describes
<http://example.org/organization/hefce.ac.uk/person/1>
Conversely, the delete: <a href="http://www.w3.org/TR/2015/PR-tabular-metadata-20151117/#cell-aboutUrl"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-metadata-20151217/#cell-aboutUrl"> aboutUrl
property has not been defined for resources described by each delete: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-row"> row of delete: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-annotated-table"> table Td ( { "url": "http://example.org/junior-roles.csv"}
); therefore delete: <a href="#dfn-blank-node" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-blank-node"> blank nodes are used, e.g. for delete: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-row"> row Rd1 we state the following triple:
csvw:describes
_:d8b8e40c-8c74-458b-99f7-64d1cf5c65f2
This section is non-normative.
The "Direct Mapping of Relational Data to RDF" W3C Recommendation [ delete: <a class="bibref" href="#bib-rdb-direct-mapping"> insert: <a href="#bib-rdb-direct-mapping" class="bibref"> rdb-direct-mapping ] defines a simple transformation (referred to as delete: <dfn data-dfn-type="dfn" id="dfn-direct-mapping"> insert: <dfn id="dfn-direct-mapping" data-dfn-type="dfn"> direct mapping ) from a relational representation of data to RDF. The direct mapping takes as input a relational database (data and schema), and generates an RDF graph called the delete: <dfn data-dfn-type="dfn" id="dfn-direct-graph"> insert: <dfn id="dfn-direct-graph" data-dfn-type="dfn"> direct graph . Tables in a relational databases bear a strong resemblance to tabular data as defined in [ delete: <a class="bibref" href="#bib-tabular-data-model"> insert: <a href="#bib-tabular-data-model" class="bibref"> tabular-data-model ]; this section highlights the similarities and differences between the delete: <a href="#dfn-direct-mapping" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-direct-mapping"> direct mapping and the delete: <a href="#dfn-tabular-data-mapping" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-tabular-data-mapping"> tabular data mapping defined by this document. The following statements summarize the relationships:
The rest of this section will provide some examples. These are somewhat simplified forms of the examples as used in the [ delete: <a class="bibref" href="#bib-rdb-direct-mapping"> insert: <a href="#bib-rdb-direct-mapping" class="bibref"> rdb-direct-mapping ] document.
delete: <section typeof="bibo:Chapter" resource="#rdb-single" property="bibo:hasPart"> delete: <h3 id="rdb-single" resource="#rdb-single"> insert: <section property="bibo:hasPart" resource="#rdb-single" typeof="bibo:Chapter"> Consider a simple table in a relational database, called People
:
PK | ||
ID | fname | addr |
---|---|---|
7 | Bob | 18 |
A relational table always has a schema that the delete: <a href="#dfn-direct-mapping" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-direct-mapping"> direct mapping makes use of. In this example, the schema defines that:
ID
, fname
, and addr
. ID
are the primary keys in the table, and the corresponding cells contain integers. fname
column contain strings. addr
column contain integers. Using the schema information, the delete: <a href="#dfn-direct-graph" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-direct-graph"> direct graph is as follows (see [ delete: <a class="bibref" href="#bib-rdb-direct-mapping"> insert: <a href="#bib-rdb-direct-mapping" class="bibref"> rdb-direct-mapping ] for further details):
<http://foo.example.org/DB/People/ID=7> rdf:type <http://foo.example.org/DB/People>; <http://foo.example.org/DB/People/#ID> 7; <http://foo.example.org/DB/People/#fname> "Bob"; <http://foo.example.org/DB/People/#addr> 18.
where http://foo.example.org/DB/
is the URL for the database containing the People
table.
When exporting the table into CSV the column names would naturally be mapped on the titles of the respective columns. The ( delete: <a href="#dfn-minimal-mode" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-minimal-mode"> minimal ) delete: <a href="#dfn-tabular-data-mapping" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-tabular-data-mapping"> tabular data mapping yields:
[ <http://foo.example.org/CSV/People/#ID> "7"; <http://foo.example.org/CSV/People/#fname> "Bob"; <http://foo.example.org/CSV/People/#addr> "18"; ]
where http://foo.example.org/CSV/People
is the URL of the CSV file exported from the relational database.
Comparing the two conversion results:
rdf:type
to the delete: <a href="#dfn-direct-graph" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-direct-graph"> direct graph . However, by default (e.g., without additional annotation), the delete: <a href="#dfn-tabular-data-mapping" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-tabular-data-mapping"> tabular data mapping has insufficient information to make such an assertion. It is, however, possible to add annotation to the tabular data so that the two graphs would be semantically equivalent. Indeed, consider the following metadata using the definitions of the [ delete: <a class="bibref" href="#bib-tabular-metadata"> insert: <a href="#bib-tabular-metadata" class="bibref"> tabular-metadata ] specification:
{ "@context" : "http://www.w3.org/ns/csvw" , "tableSchema" : { "url" : "http://foo.example.org/CSV/People" , "aboutUrl" : "http://foo.example.org/CSV/People/ID={ID}" , "columns" : [{ "name" : "ID" , "datatype" : "integer" }, { "name" : "fname" , }, { "name" : "addr" , "datatype" : "integer" }, { "name" : "type" , "virtual" : true , "propertyUrl" : "rdf:type" , "valueUrl" : "http://foo.example.org/CSV/People" }], } }
The metadata adds annotations on datatypes, adds the RDF typing triple explicitly (using a delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-virtual-columns" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-column-virtual" class="externalDFN"> virtual column ), and uses the delete: <a href="http://www.w3.org/TR/2015/PR-tabular-metadata-20151117/#cell-aboutUrl" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-metadata-20151217/#cell-aboutUrl" class="externalDFN"> aboutUrl
URL template property to provide the common subject. Essentially, the metadata provides the information that the delete: <a href="#dfn-direct-mapping" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-direct-mapping"> direct mapping retrieves from the table schema.
The [ delete: <a class="bibref" href="#bib-tabular-metadata"> insert: <a href="#bib-tabular-metadata" class="bibref"> tabular-metadata ] specification includes an annotation for delete: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-primary-key" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-data-model-20151217/#dfn-row-primary-key" class="externalDFN"> primary keys . However, that annotation is used for validation and does not influence the delete: <a href="#dfn-tabular-data-mapping" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-tabular-data-mapping"> tabular data mapping , hence it is not included in the example metadata.
A processor exporting the table into a CSV file may be able to automatically generate the metadata to complement the CSV file.
Consider a two interrelated simple tables in a relational database, called People
and Addresses
, respectively:
PK | → Addresses(ID) | |
ID | fname | addr |
---|---|---|
7 | Bob | 18 |
PK | ||
ID | city | state |
---|---|---|
18 | Cambridge | MA |
Beyond what is already specified for the People
table the corresponding relational schema also specifies that:
Addresses
table has three columns named ID
, city
, and state
. ID
are primary keys in the Addresses
table, and the corresponding cells contain integers. city
and state
columns in the Addresses
table contain strings. addr
column of the People
table are foreign keys that reference the ID
field of the Addresses
table. Using the schema information, the delete: <a href="#dfn-direct-graph" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-direct-graph"> direct graph is as follows (see [ delete: <a class="bibref" href="#bib-rdb-direct-mapping"> insert: <a href="#bib-rdb-direct-mapping" class="bibref"> rdb-direct-mapping ] for further details):
<http://foo.example.org/DB/People/ID=7> rdf:type <http://foo.example.org/DB/People>; <http://foo.example.org/DB/People#ID> 7; <http://foo.example.org/DB/People#fname> "Bob"; <http://foo.example.org/DB/People#addr> 18; <http://foo.example.org/DB/People#ref-addr> <http://foo.example.org/DB/Addresses/ID=18> . <http://foo.example.org/DB/Addresses/ID=18> rdf:type <http://foo.example.org/DB/Addresses>; <http://foo.example.org/DB/Addresses#ID> 18; <http://foo.example.org/DB/Addresses#city> "Cambridge"; <http://foo.example.org/DB/Addresses#state> "MA".
Note the highlighted RDF triple linking to the relevant row of the Addresses
table; this corresponds to the foreign key in the schema.
Using the following metadata the delete: <a href="#dfn-tabular-data-mapping" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-tabular-data-mapping"> tabular data mapping yields a semantically equivalent result:
{ "@context" : "http://www.w3.org/ns/csvw" , "resources" : [{ "url" : "http://foo.example.org/CSV/People" , "aboutUrl" : "http://foo.example.org/CSV/People/ID={ID}" , "tableSchema" : { "columns" : [{ "name" : "ID" , "datatype" : "integer" }, { "name" : "fname" , }, { "name" : "addr" , "datatype" : "integer" }, { "name" : "ref" , "virtual" : true , "propertyUrl" : "http://foo.example.org/CSV/People#ref-addr" , "valueUrl" : "http://foo.example.org/CSV/Addresses/ID={addr}" }, { "name" : "type" , "virtual" : true , "propertyUrl" : "rdf:type" , "valueUrl" : "http://foo.example.org/CSV/People" }], } }, { "url" : "http://foo.example.org/CSV/Addresses" , "aboutUrl" : "http://foo.example.org/CSV/Addresses/ID={ID}" , "tableSchema" : [{ "columns" : [{ "name" : "ID" , "datatype" : "integer" }, { "name" : "city" , }, { "name" : "state" , }, { "name" : "type" , "virtual" : true , "propertyUrl" : "rdf:type" , "valueUrl" : "http://foo.example.org/CSV/Addresses" }], }] }
Consider a case with three, interrelated simple tables in a relational database, called People
, Addresses
, and Departments
, respectively:
PK | → Addresses(ID) | → Department(name,city) | ||
ID | fname | addr | deptName | deptCity |
---|---|---|---|---|
7 | Bob | 18 | accounting | Cambridge |
PK | ||
ID | city | state |
---|---|---|
18 | Cambridge | MA |
PK | Unique Key | |
ID | name | city |
---|---|---|
23 | accounting | Cambridge |
The corresponding relational schema specifies that:
People
table ID
, name
, addr
, deptName
, and deptCity
. ID
are the primary keys in the table, and the corresponding cells contain integers. name
, deptName
, and deptCity
columns contain strings. addr
columns contains integers. Addresses
table ID
, city
, and state
. ID
are the primary keys in the table, and the corresponding cells contain integers. city
and state
columns contain strings. Departments
table ID
, name
, and city
. ID
are the primary keys in the table, and the corresponding cells contain integers. name
and city
columns contain strings. name
and city
are unique keys. addr
column of the People
table are foreign keys that reference the ID
field of the Addresses
table. deptName
and deptCity
columns in the People
table are combined foreign keys referencing candidate keys for the name
and city
pairs of the Departments
table. Using the schema information, the delete: <a href="#dfn-direct-graph" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-direct-graph"> direct graph is as follows (see [ delete: <a class="bibref" href="#bib-rdb-direct-mapping"> insert: <a href="#bib-rdb-direct-mapping" class="bibref"> rdb-direct-mapping ] for further details):
<http://foo.example.org/DB/People/ID=7> rdf:type <http://foo.example.org/DB/People>; <http://foo.example.org/DB/People/#ID> 7; <http://foo.example.org/DB/People/#fname> "Bob"; <http://foo.example.org/DB/People/#addr> 18; <http://foo.example.org/DB/People/#ref-addr> <http://foo.example.org/DB/Addresses/ID=18>; <http://foo.example.org/DB/People/#deptName> "accounting"; <http://foo.example.org/DB/People/#deptCity> "Cambridge"; <http://foo.example.org/DB/People/#ref-deptName;deptCity> <http://foo.example.org/DB/Department/ID=23>. <http://foo.example.org/DB/Addresses/ID=18> rdf:type <http://foo.example.org/DB/Addresses>; <http://foo.example.org/DB/Addresses/#ID> 18; <http://foo.example.org/DB/Addresses/#city> "Cambridge"; <http://foo.example.org/DB/Addresses/#addr> "MA". <http://foo.example.org/DB/Departments/ID=23> rdf:type <http://foo.example.org/DB/Addresses>; <http://foo.example.org/DB/Departments/#ID> 23; <http://foo.example.org/DB/Departments/#name> "accounting"; <http://foo.example.org/DB/Departments/#city> "Cambridge".
The major difference, compared to the simpler example with foreign keys is the usage of unique keys.
To generate the correct object URI in the highlighted statement of the delete: <a href="#dfn-direct-graph" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-direct-graph"> direct graph ( above ) the processor has to:
deptName
and deptCity
for the current row in the People
table in order to determine the value of the compound unique key to the Departments
table for that row. Departments
table that matches that compound unique key value and determine the subject for that row. This can be done because the delete: <a href="#dfn-direct-mapping" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-direct-mapping"> direct mapping processor has simultaneous access to several tables within the same relational database. It is therefore straightforward to access all the tables in parallel and establish the necessary relationships to generate the triples.
However, this combination cannot be handled by the delete: <a href="#dfn-tabular-data-mapping" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-tabular-data-mapping"> tabular data mapping . The situation for tabular data is indeed different: tables are typically generated from single and, potentially, very large CSV files, meaning that a delete: <a href="#dfn-tabular-data-mapping" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-tabular-data-mapping"> tabular data mapping processor cannot be expected to handle several tables in parallel. That is the reason why the [ delete: <a class="bibref" href="#bib-tabular-data-model"> insert: <a href="#bib-tabular-data-model" class="bibref"> tabular-data-model ] does not include features that would require such parallel access. As a consequence, the output of the delete: <a href="#dfn-direct-mapping" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-direct-mapping"> direct mapping for such tables cannot be reproduced by the delete: <a href="#dfn-tabular-data-mapping" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-tabular-data-mapping"> tabular data mapping .
Note that the [ delete: <a class="bibref" href="#bib-tabular-data-model"> insert: <a href="#bib-tabular-data-model" class="bibref"> tabular-data-model ] includes an annotation for delete: <a href="http://www.w3.org/TR/2015/PR-tabular-metadata-20151117/#transformation-definitions"> insert: <a href="http://www.w3.org/TR/2015/REC-tabular-metadata-20151217/#transformation-definitions"> transformations ; implementations may include scripts or templates to transform the output of the delete: <a href="#dfn-tabular-data-mapping" class="internalDFN" data-link-type="dfn"> insert: <a data-link-type="dfn" class="internalDFN" href="#dfn-tabular-data-mapping"> tabular data mapping and generate the required RDF graph.
@id
annotation in the model. The document has undergone substantial changes since the first public working draft . Below are some of the changes made: