This document defines the procedures and rules to be applied when converting tabular data into JSON. 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 JSON.
Status of This Document
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 insert: <a href="http://www.w3.org/2013/csvw"> CSV on the Web Working Group insert: </a> was insert: <a href="http://www.w3.org/2013/05/lcsv-charter.html"> chartered insert: </a> to produce Recommendations for a recommendation "Access methods for CSV Metadata", Metadata" as well as recommendations for "Metadata vocabulary for CSV data" and "Mapping mechanism to transforming CSV into various Formats formats (e.g., RDF, JSON, or XML)". This document aims to satisfy the JSON variant of the mapping Recommendation. recommendation.
This document was published by the CSV on the Web Working Group as a Candidate Proposed Recommendation. This document is intended to become a W3C Recommendation. If you wish The insert: <abbr title="World Wide Web Consortium">W3C insert: </abbr>Membership and other interested parties are invited to make review the document and send comments regarding this document, please send them to delete: <a href="mailto:public-csv-wg@w3.org">insert: <a rel="discussion" href="mailto:public-csv-wg@w3.org"> public-csv-wg@w3.org ( subscribe , archives ). delete: <abbr title="World Wide Web Consortium">W3C delete: </abbr>publishes a Candidate Recommendation to indicate ) through 15 December 2015. Advisory Committee Representatives should consult their insert: <a href="https://www.w3.org/2002/09/wbs/myQuestionnaires">WBS questionnaires insert: </a>. Note that the document is believed to be stable and to encourage implementation by the developer community. This Candidate Recommendation is substantive technical comments were expected to advance to Proposed Recommendation no earlier than during the Last Call review period that ended 30 October 2015. All comments are welcome.
Please see the Working Group's delete: <a href="http://www.w3.org/2013/csvw/tests/reports/index.html">insert: <a href="http://www.w3.org/2013/csvw/implementation_report.html"> implementation report .
Publication as a Candidate Proposed Recommendation does not imply endorsement by the W3C Membership. This is a draft document and may be updated, replaced or obsoleted by other documents at any time. It is inappropriate to cite this document as other than work in progress.
This document is governed by the delete: <a id="w3c_process_revision" href="http://www.w3.org/2014/Process-20140801/">insert: <a id="w3c_process_revision" href="http://www.w3.org/2015/Process-20150901/"> 1 August 2014 September 2015 W3C Process Document .
This document describes the processing of delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-tabular-data">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-tabular-data"> tabular data to create a set of nested objects that MUST be serialized as JSON [ RFC7159 ].
Note
The conversion of CSV content to JSON is intended for web developers who need not care about the complexities of RDF [ rdf11-concepts ]. Where the formality of RDF is required, [ csv2rdf ] provides the procedures for mapping from CSV content to RDF which may be serialized to [ json-ld ].
The [ tabular-data-model ] defines an delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-annotated-tabular-data-model" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-annotated-tabular-data-model" class="externalDFN"> annotated tabular data model consisting of delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-table" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-table" class="externalDFN"> tables , delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-column" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-column" class="externalDFN"> columns , delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-row" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-row" class="externalDFN"> rows , and delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell" class="externalDFN"> cells , enriched with delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-annotation" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-annotations" class="externalDFN"> annotations that describe the structure of the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-tabular-data" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-tabular-data" class="externalDFN"> tabular data and the meaning of its content. A delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-group-of-tables" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-group-of-tables" class="externalDFN"> group of tables is a collection of delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-table" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#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/CR-tabular-data-model-20150716/#dfn-annotated-tabular-data-model" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#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 [ tabular-data-model ] for details of delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#parsing">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#parsing"> parsing tabular data .
Conversion applications MUST provide at least two modes of operation: delete: <a title="standard mode" href="#dfn-standard-mode" class="internalDFN">insert: <a href="#dfn-standard-mode" class="internalDFN" data-link-type="dfn"> standard and delete: <a title="minimal mode" href="#dfn-minimal-mode" class="internalDFN">insert: <a href="#dfn-minimal-mode" class="internalDFN" data-link-type="dfn"> minimal .
delete: <dfn title="standard mode" id="dfn-standard-mode">insert: <dfn data-dfn-type="dfn" id="dfn-standard-mode"> Standard mode conversion frames the information gleaned from the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell" class="externalDFN"> cells of the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-tabular-data" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-tabular-data" class="externalDFN"> tabular data with details of the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-row" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-row" class="externalDFN"> rows , delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-table" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-table" class="externalDFN"> tables , and a delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-group-of-tables" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-group-of-tables" class="externalDFN"> group of tables within which that information is provided.
delete: <dfn title="minimal mode" id="dfn-minimal-mode">insert: <dfn data-dfn-type="dfn" id="dfn-minimal-mode"> Minimal mode conversion includes only the information gleaned from the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell" class="externalDFN"> cells of the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-tabular-data" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-tabular-data" class="externalDFN"> tabular data within the output.
delete: <a title="standard mode" href="#dfn-standard-mode" class="internalDFN">insert: <a href="#dfn-standard-mode" class="internalDFN" data-link-type="dfn"> Standard and delete: <a title="minimal mode" href="#dfn-minimal-mode" class="internalDFN">insert: <a href="#dfn-minimal-mode" class="internalDFN" data-link-type="dfn"> minimal conversion are described normatively below .
Conversion applications MAY offer additional implementation specific conversion modes.
delete: <a href="http://www.w3.org/TR/2015/CR-tabular-metadata-20150716/#dfn-transformation-definition" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-metadata-20151117/#dfn-transformation-definition" class="externalDFN"> Transformation definitions , as defined in [ tabular-metadata ] MAY be used to specify how delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-tabular-data" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#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/CR-tabular-metadata-20150716/#dfn-transformation-definition" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-metadata-20151117/#dfn-transformation-definition" class="externalDFN"> transformation definitions MAY use the JSON output described in this specification as input.
2. Conformance
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 and , MUST insert: </em>, and insert: <em class="rfc2119" title="SHOULD">SHOULD are to be interpreted as described in [ RFC2119 ].
delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-tabular-data" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-tabular-data" class="externalDFN"> Tabular data MUST conform to the description from [ tabular-data-model ]. In particular note that each delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-row" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-row" class="externalDFN"> row MUST contain the same number of delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell" class="externalDFN"> cells (although some of these delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell" class="externalDFN"> cells may be empty).
Note
Not all CSV-encoded data can be parsed into a tabular data model. An algorithm for parsing CSV-based files is described in [ tabular-data-model ].
3. Typographical conventions
The following typographic conventions are used in this specification:
markup
Markup (elements, attributes, properties), machine processable values (string, characters, media types), property name, or a file name is in red-orange monospace font.
variable
A variable in pseudo-code or in an algorithm description is in italics.
A references to a definition in this document , when the reference itself is also a markup, is underlined, red-orange monospace font, and is also an active link to the definition itself.
A reference to a definition in another document , when the reference itself is also a markup, is underlined, in italics red-orange monospace font, and is also an active link to the definition itself.
A document reference (normative or informative) is enclosed in square brackets and links to the references section.
Note
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.
Example 1
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.
4. Converting Tabular Data to JSON
The procedures for converting delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-tabular-data" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-tabular-data" class="externalDFN"> tabular data into JSON are described below for both delete: <a title="standard mode" href="#dfn-standard-mode" class="internalDFN">insert: <a href="#dfn-standard-mode" class="internalDFN" data-link-type="dfn"> standard and delete: <a title="minimal mode" href="#dfn-minimal-mode" class="internalDFN">insert: <a href="#dfn-minimal-mode" class="internalDFN" data-link-type="dfn"> minimal modes.
4.1 Algorithm terms
delete: <dfn id="dfn-about-url">insert: <dfn data-dfn-type="dfn" id="dfn-about-url"> about URL
The delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-about-url" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-about-url" class="externalDFN"> about URL annotation on the current delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell" class="externalDFN"> cell . As defined in [ tabular-data-model ].
The delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-annotated-table" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-annotated-table" class="externalDFN"> annotated table is defined in [ tabular-data-model ] as describing a particular delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-table" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-table" class="externalDFN"> table and its annotations.
An delete: <a href="#dfn-array" class="internalDFN">insert: <a href="#dfn-array" class="internalDFN" data-link-type="dfn"> array is defined in JSON ([ RFC7159 ]) as an ordered sequence of zero or more values, where a value is a string, number, boolean, null, delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object , or delete: <a href="#dfn-array" class="internalDFN">insert: <a href="#dfn-array" class="internalDFN" data-link-type="dfn"> array .
A delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell" class="externalDFN"> cell is defined in [ tabular-data-model ] as the intersection of a delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row and a delete: <a href="#dfn-column" class="internalDFN">insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> column within a delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN">insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table .
delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-errors" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-errors" class="externalDFN"> Cell errors are defined in [ tabular-data-model ] as a (possibly empty) list of validation errors generated while parsing the literal content of a delete: <a href="#dfn-cell" class="internalDFN">insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cell to generate the delete: <a title="cell value" href="#dfn-cell-value" class="internalDFN">insert: <a data-lt="cell value" href="#dfn-cell-value" class="internalDFN" data-link-type="dfn"> semantic value .
delete: <dfn id="dfn-cell-value">insert: <dfn data-dfn-type="dfn" id="dfn-cell-value"> cell value
A delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-value" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-value" class="externalDFN"> cell value is defined in [ tabular-data-model ] as the semantic value of the delete: <a href="#dfn-cell" class="internalDFN">insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cell ; this MAY be null or a sequence of values.
A delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-column" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-column" class="externalDFN"> column is defined in [ tabular-data-model ] as a vertical arrangement of delete: <a title="cell" href="#dfn-cell" class="internalDFN">insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cells within a delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN">insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table .
delete: <dfn id="dfn-group-of-tables">insert: <dfn data-dfn-type="dfn" id="dfn-group-of-tables"> group of tables
A delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-group-of-tables" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-group-of-tables" class="externalDFN"> group of tables is defined in [ tabular-data-model ] as comprising a set of delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN">insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> annotated tables and a set of annotations that relate to that group.
delete: <dfn id="dfn-group-of-tables-identifier">insert: <dfn data-dfn-type="dfn" id="dfn-group-of-tables-identifier"> group of tables identifier
The group of tables identifier is the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-table-group-id" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-table-group-id" class="externalDFN"> id annotation on a delete: <a href="#dfn-group-of-tables" class="internalDFN">insert: <a href="#dfn-group-of-tables" class="internalDFN" data-link-type="dfn"> group of tables . As defined in [ tabular-data-model ].
delete: <dfn id="dfn-name">insert: <dfn data-dfn-type="dfn" id="dfn-name"> name
In the context of this specification, delete: <a href="#dfn-name" class="internalDFN">insert: <a href="#dfn-name" class="internalDFN" data-link-type="dfn"> name is used as defined in JSON ([ RFC7159 ]); that is, that delete: <a href="#dfn-name" class="internalDFN">insert: <a href="#dfn-name" class="internalDFN" data-link-type="dfn"> name is a string that provides a unique key within a set of name-value pairs within a JSON delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object .
Core annotations are listed in [ tabular-data-model ]; delete: <a title="group of tables" href="#dfn-group-of-tables" class="internalDFN">insert: <a data-lt="group of tables" href="#dfn-group-of-tables" class="internalDFN" data-link-type="dfn"> groups of tables and delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN">insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> tables may also have other annotations that are not defined in that specification; these are known as delete: <a href="#dfn-non-core-annotations" class="internalDFN">insert: <a href="#dfn-non-core-annotations" class="internalDFN" data-link-type="dfn"> non-core annotations .
A list of delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-table-notes" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-notes" class="externalDFN"> notes , as defined in [ tabular-data-model ], attached to an delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN">insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> annotated table or delete: <a href="#dfn-group-of-tables" class="internalDFN">insert: <a href="#dfn-group-of-tables" class="internalDFN" data-link-type="dfn"> group of tables using the notes property. This may be an empty list.
An delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object is defined in JSON ([ RFC7159 ]) as an unordered collection of zero or more name-value pairs, where a insert: <var> name insert: </var> is a string and a insert: <var> value insert: </var> is a string, number, boolean, null, delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object , or delete: <a href="#dfn-array" class="internalDFN">insert: <a href="#dfn-array" class="internalDFN" data-link-type="dfn"> array .
The delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-property-url" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-property-url" class="externalDFN"> property URL annotation on the current delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell" class="externalDFN"> cell . As defined in [ tabular-data-model ].
The delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-row" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-row" class="externalDFN"> row is defined in [ tabular-data-model ] as a horizontal arrangement of delete: <a title="cell" href="#dfn-cell" class="internalDFN">insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cells within a delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN">insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table .
delete: <dfn id="dfn-row-number">insert: <dfn data-dfn-type="dfn" id="dfn-row-number"> row number
A delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-row-number" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-row-number" class="externalDFN"> row number is defined in [ tabular-data-model ] as the position of the delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row within the delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN">insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table , starting from 1.
delete: <dfn id="dfn-row-source-number">insert: <dfn data-dfn-type="dfn" id="dfn-row-source-number"> row source number
A delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-row-source-number" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-row-source-number" class="externalDFN"> row source number is defined in [ tabular-data-model ] as the position of the delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row within the source delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-tabular-data-file" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-tabular-data-files" class="externalDFN"> tabular data file . Provision of the delete: <a href="#dfn-row-source-number" class="internalDFN">insert: <a href="#dfn-row-source-number" class="internalDFN" data-link-type="dfn"> row source number is dependent on parsing applications and may be reported as null .
Within this algorithm, a delete: <a href="#dfn-subject" class="internalDFN">insert: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> subject is the resource that the value of a given delete: <a href="#dfn-cell" class="internalDFN">insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cell refers to. This may be specified using delete: <a href="#dfn-about-url" class="internalDFN">insert: <a href="#dfn-about-url" class="internalDFN" data-link-type="dfn"> about URL .
The table identifier is the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-table-id" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-table-id" class="externalDFN"> id annotation on an delete: <a href="#dfn-annotated-table" class="internalDFN">insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> annotated table . As defined in [ tabular-data-model ].
delete: <dfn id="dfn-value-url">insert: <dfn data-dfn-type="dfn" id="dfn-value-url"> value URL
The delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-value-url" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-value-url" class="externalDFN"> value URL annotation on the current delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell" class="externalDFN"> cell . As defined in [ tabular-data-model ].
4.2 Generating JSON
A conformant JSON conversion application MUST produce output conforming to this algorithm according to the chosen mode of conversion: delete: <a title="standard mode" href="#dfn-standard-mode" class="internalDFN">insert: <a href="#dfn-standard-mode" class="internalDFN" data-link-type="dfn"> standard or delete: <a title="minimal mode" href="#dfn-minimal-mode" class="internalDFN">insert: <a href="#dfn-minimal-mode" class="internalDFN" data-link-type="dfn"> minimal .
Note
Where an delete: <a href="#dfn-annotated-table" class="internalDFN">insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> annotated table is defined in isolation (e.g. in the absence of a delete: <a href="#dfn-group-of-tables" class="internalDFN">insert: <a href="#dfn-group-of-tables" class="internalDFN" data-link-type="dfn"> group of tables ), a default delete: <a href="#dfn-group-of-tables" class="internalDFN">insert: <a href="#dfn-group-of-tables" class="internalDFN" data-link-type="dfn"> group of tables is provided with a single delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-table-group-tables" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-table-group-tables" class="externalDFN"> tables annotation that refers to the given delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN">insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table .
The [ tabular-data-model ] specifies that string values within delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-tabular-data" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-tabular-data" class="externalDFN"> tabular data (such as delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-column-titles" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-column-titles" class="externalDFN"> column titles or delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-string-value" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-string-value" class="externalDFN"> cell string values ) MUST contain only Unicode characters. No Unicode normalization (as specified in [ UAX15 ]) is applied to these string values during the conversion to JSON.
4.2.1 Minimal mode
The steps in the algorithm defined here apply to delete: <a title="minimal mode" href="#dfn-minimal-mode" class="internalDFN">insert: <a href="#dfn-minimal-mode" class="internalDFN" data-link-type="dfn"> minimal mode.
Insert an empty delete: <a href="#dfn-array" class="internalDFN">insert: <a href="#dfn-array" class="internalDFN" data-link-type="dfn"> array A into the JSON output. The delete: <a title="object" href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> objects containing the name-value pairs associated with the delete: <a title="cell value" href="#dfn-cell-value" class="internalDFN">insert: <a href="#dfn-cell-value" class="internalDFN" data-link-type="dfn"> cell values will be subsequently inserted into this delete: <a href="#dfn-array" class="internalDFN">insert: <a href="#dfn-array" class="internalDFN" data-link-type="dfn"> array .
Each delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN">insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table is processed sequentially in the order they are referenced in the delete: <a href="#dfn-group-of-tables" class="internalDFN">insert: <a href="#dfn-group-of-tables" class="internalDFN" data-link-type="dfn"> group of tables . For each delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN">insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table where the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-table-suppress-output" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-table-suppress-output" class="externalDFN"> suppress output annotation is false :
Each delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row within the delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN">insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table is processed sequentially in order. For each delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row in the current delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN">insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table :
Generate a sequence of delete: <a title="object" href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> objects , S 1 to S n , each of which corresponds to a delete: <a href="#dfn-subject" class="internalDFN">insert: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> subject described by the current delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row , as described in 4.3 Generating Objects .
Note
The delete: <a title="subject" href="#dfn-subject" class="internalDFN">insert: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> subject(s) described by each delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row are determined according to the delete: <a href="#dfn-about-url" class="internalDFN">insert: <a href="#dfn-about-url" class="internalDFN" data-link-type="dfn"> about URL annotation for each delete: <a href="#dfn-cell" class="internalDFN">insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cell in the current delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row . Where delete: <a href="#dfn-about-url" class="internalDFN">insert: <a href="#dfn-about-url" class="internalDFN" data-link-type="dfn"> about URL is undefined, a default delete: <a href="#dfn-subject" class="internalDFN">insert: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> subject for the delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row is used.
As described in 4.4 Generating Nested Objects , process the sequence of delete: <a title="object" href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> objects , S 1 to S n , to produce a new sequence of root delete: <a title="object" href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> objects , S R 1 to S R m , that MAY include nested delete: <a title="object" href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> objects .
Note
A delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row MAY describe multiple interrelated delete: <a title="subject" href="#dfn-subject" class="internalDFN">insert: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> subjects ; where the delete: <a href="#dfn-value-url" class="internalDFN">insert: <a href="#dfn-value-url" class="internalDFN" data-link-type="dfn"> value URL annotation on one delete: <a href="#dfn-cell" class="internalDFN">insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cell matches the delete: <a href="#dfn-about-url" class="internalDFN">insert: <a href="#dfn-about-url" class="internalDFN" data-link-type="dfn"> about URL annotation on another delete: <a href="#dfn-cell" class="internalDFN">insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cell in the same delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row .
Insert each root delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object , S R 1 to S R m , into delete: <a href="#dfn-array" class="internalDFN">insert: <a href="#dfn-array" class="internalDFN" data-link-type="dfn"> array A .
4.2.2 Standard mode
The steps in the algorithm defined here apply to delete: <a title="standard mode" href="#dfn-standard-mode" class="internalDFN">insert: <a href="#dfn-standard-mode" class="internalDFN" data-link-type="dfn"> standard delete: </a>mode. mode insert: </a>.
Insert an empty delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object G into the JSON output which is associated with the delete: <a href="#dfn-group-of-tables" class="internalDFN">insert: <a href="#dfn-group-of-tables" class="internalDFN" data-link-type="dfn"> group of tables .
If the delete: <a href="#dfn-group-of-tables" class="internalDFN">insert: <a href="#dfn-group-of-tables" class="internalDFN" data-link-type="dfn"> group of tables has an delete: <a title="group of tables identifier" href="#dfn-group-of-tables-identifier" class="internalDFN">insert: <a data-lt="group of tables identifier" href="#dfn-group-of-tables-identifier" class="internalDFN" data-link-type="dfn"> identifier I G ; insert the following name-value pair into delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object G :
name
@id
value
I G
Insert any delete: <a href="#dfn-notes" class="internalDFN">insert: <a href="#dfn-notes" class="internalDFN" data-link-type="dfn"> notes and delete: <a href="#dfn-non-core-annotations" class="internalDFN">insert: <a href="#dfn-non-core-annotations" class="internalDFN" data-link-type="dfn"> non-core annotations specified for the delete: <a href="#dfn-group-of-tables" class="internalDFN">insert: <a href="#dfn-group-of-tables" class="internalDFN" data-link-type="dfn"> group of tables into delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object G according to the rules provided in 5. JSON-LD to JSON .
Insert the following name-value pair into delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object G :
name
tables
value
A T
where A T is an delete: <a href="#dfn-array" class="internalDFN">insert: <a href="#dfn-array" class="internalDFN" data-link-type="dfn"> array into which the delete: <a title="object" href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> objects describing the delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN">insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> annotated tables will be subsequently inserted.
Each delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN">insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table is processed sequentially in the order they are referenced in the delete: <a href="#dfn-group-of-tables" class="internalDFN">insert: <a href="#dfn-group-of-tables" class="internalDFN" data-link-type="dfn"> group of tables .
For each delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN">insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table where the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-table-suppress-output" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-table-suppress-output" class="externalDFN"> suppress output annotation is false :
Insert an empty delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object T into the delete: <a href="#dfn-array" class="internalDFN">insert: <a href="#dfn-array" class="internalDFN" data-link-type="dfn"> array A T to represent the delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN">insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table .
If the delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN">insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table has an delete: <a title="table identifier" href="#dfn-table-identifier" class="internalDFN">insert: <a data-lt="table identifier" href="#dfn-table-identifier" class="internalDFN" data-link-type="dfn"> identifier I T ; insert the following name-value pair into delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object T :
name
@id
value
I T
Specify the source tabular data file URL for the current table based on the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-table-url" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-url" class="externalDFN"> url annotation; insert the following name-value pair into delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object T :
name
url
value
URL
Insert any delete: <a href="#dfn-notes" class="internalDFN">insert: <a href="#dfn-notes" class="internalDFN" data-link-type="dfn"> notes and delete: <a href="#dfn-non-core-annotations" class="internalDFN">insert: <a href="#dfn-non-core-annotations" class="internalDFN" data-link-type="dfn"> non-core annotations specified for the delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN">insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table into delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object T according to the rules provided in 5. JSON-LD to JSON .
Note
All other delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-core-annotations" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-core-annotations" class="externalDFN"> core annotations for the delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN">insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table are ignored during the conversion; including information about delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-table-schema" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-schema" class="externalDFN"> table schemas and delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-column" class="externalDFN">their insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-column" class="externalDFN"> columns specified therein, delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-table-foreign-keys" class="externalDFN">, insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-foreign-keys" class="externalDFN"> foreign keys , delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-table-direction" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-table-direction" class="externalDFN"> table direction , delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-table-transformations" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-transformations" class="externalDFN"> transformations , etc.
Insert the following name-value pair into delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object T :
name
row
value
A R
where A R is an delete: <a href="#dfn-array" class="internalDFN">insert: <a href="#dfn-array" class="internalDFN" data-link-type="dfn"> array into which the delete: <a title="object" href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> objects describing the delete: <a title="row" href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> rows will be subsequently inserted.
Each delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row within the delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN">insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table is processed sequentially in order. For each delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row in the current delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN">insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table :
Insert an empty delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object R into the delete: <a href="#dfn-array" class="internalDFN">insert: <a href="#dfn-array" class="internalDFN" data-link-type="dfn"> array A R to represent the delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row .
Specify the delete: <a href="#dfn-row-number" class="internalDFN">insert: <a href="#dfn-row-number" class="internalDFN" data-link-type="dfn"> row number n for the delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row ; insert the following name-value pair into delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object R :
name
rownum
value
n
Specify the delete: <a href="#dfn-row-source-number" class="internalDFN">insert: <a href="#dfn-row-source-number" class="internalDFN" data-link-type="dfn"> row source number n source for the delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row within the source tabular data file URL using a fragment-identifier as specified in [ RFC7111 ]; if delete: <a href="#dfn-row-source-number" class="internalDFN">insert: <a href="#dfn-row-source-number" class="internalDFN" data-link-type="dfn"> row source number is not null , insert the following name-value pair into delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object R :
name
url
value
URL #row= n source
Specify any delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-row-titles" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-row-titles" class="externalDFN"> titles for the delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row ; if delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-row-titles" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-row-titles" class="externalDFN"> row titles is not null , insert the following name-value pair into delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object R :
name
titles
value
t
where t is the single value or array of values provided by the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-row-titles" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-row-titles" class="externalDFN"> row titles annotation.
Note
JSON has no native support for expressing language information; therefore any such information associated with the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-row-titles" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-row-titles" class="externalDFN"> row titles is ignored.
Insert any delete: <a href="#dfn-non-core-annotations" class="internalDFN">insert: <a href="#dfn-non-core-annotations" class="internalDFN" data-link-type="dfn"> non-core annotations specified for the delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row into delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object R according to the rules provided in 5. JSON-LD to JSON .
Insert the following name-value pair into delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object R :
name
describes
value
A
where A is an delete: <a href="#dfn-array" class="internalDFN">insert: <a href="#dfn-array" class="internalDFN" data-link-type="dfn"> array . The delete: <a title="object" href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> objects containing the name-value pairs associated with the delete: <a title="cell value" href="#dfn-cell-value" class="internalDFN">insert: <a href="#dfn-cell-value" class="internalDFN" data-link-type="dfn"> cell values will be subsequently inserted into this delete: <a href="#dfn-array" class="internalDFN">insert: <a href="#dfn-array" class="internalDFN" data-link-type="dfn"> array .
Generate a sequence of delete: <a title="object" href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> objects , S 1 to S n , each of which corresponds to a delete: <a href="#dfn-subject" class="internalDFN">insert: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> subject described by the current delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row , as described in 4.3 Generating Objects .
Note
The delete: <a title="subject" href="#dfn-subject" class="internalDFN">insert: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> subject(s) described by each delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row are determined according to the delete: <a href="#dfn-about-url" class="internalDFN">insert: <a href="#dfn-about-url" class="internalDFN" data-link-type="dfn"> about URL annotation for each delete: <a href="#dfn-cell" class="internalDFN">insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cell in the current delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row . Where delete: <a href="#dfn-about-url" class="internalDFN">insert: <a href="#dfn-about-url" class="internalDFN" data-link-type="dfn"> about URL is undefined, a default delete: <a href="#dfn-subject" class="internalDFN">insert: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> subject for the delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row is used.
As described in 4.4 Generating Nested Objects , process the sequence of delete: <a title="object" href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> objects , S 1 to S n , to produce a new sequence of root delete: <a title="object" href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> objects , S R 1 to S R m , that MAY include nested delete: <a title="object" href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> objects .
Note
A delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row MAY describe multiple interrelated delete: <a title="subject" href="#dfn-subject" class="internalDFN">insert: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> subjects ; where the delete: <a href="#dfn-value-url" class="internalDFN">insert: <a href="#dfn-value-url" class="internalDFN" data-link-type="dfn"> value URL annotation on one delete: <a href="#dfn-cell" class="internalDFN">insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cell matches the delete: <a href="#dfn-about-url" class="internalDFN">insert: <a href="#dfn-about-url" class="internalDFN" data-link-type="dfn"> about URL annotation on another delete: <a href="#dfn-cell" class="internalDFN">insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cell in the same delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row .
Insert each root delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object , S R 1 to S R m , into delete: <a href="#dfn-array" class="internalDFN">insert: <a href="#dfn-array" class="internalDFN" data-link-type="dfn"> array A .
4.3 Generating Objects
The steps in the algorithm defined here apply to both delete: <a title="standard mode" href="#dfn-standard-mode" class="internalDFN">insert: <a href="#dfn-standard-mode" class="internalDFN" data-link-type="dfn"> standard and delete: <a title="minimal mode" href="#dfn-minimal-mode" class="internalDFN">insert: <a href="#dfn-minimal-mode" class="internalDFN" data-link-type="dfn"> minimal modes.
This algorithm generates a sequence of delete: <a title="object" href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> objects , S 1 to S n , each of which corresponds to a delete: <a href="#dfn-subject" class="internalDFN">insert: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> subject described by the current delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row . The algorithm inserts name-value pairs into S i depending on the cell values as outlined in the following steps.
Determine the unique delete: <a title="subject" href="#dfn-subject" class="internalDFN">insert: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> subjects for the current delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row . The delete: <a title="subject" href="#dfn-subject" class="internalDFN">insert: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> subject(s) described by each delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row are determined according to the delete: <a href="#dfn-about-url" class="internalDFN">insert: <a href="#dfn-about-url" class="internalDFN" data-link-type="dfn"> about URL annotation for each delete: <a href="#dfn-cell" class="internalDFN">insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cell in the current delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row . A default delete: <a href="#dfn-subject" class="internalDFN">insert: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> subject for the delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row is used for any delete: <a title="cell" href="#dfn-cell" class="internalDFN">insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cells where delete: <a href="#dfn-about-url" class="internalDFN">insert: <a href="#dfn-about-url" class="internalDFN" data-link-type="dfn"> about URL is undefined.
For each delete: <a href="#dfn-subject" class="internalDFN">insert: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> subject that the current delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row describes where at least one of the delete: <a title="cell" href="#dfn-cell" class="internalDFN">insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cells that refers to that delete: <a href="#dfn-subject" class="internalDFN">insert: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> subject has a delete: <a title="cell value" href="#dfn-cell-value" class="internalDFN">insert: <a data-lt="cell value" href="#dfn-cell-value" class="internalDFN" data-link-type="dfn"> value or delete: <a href="#dfn-value-url" class="internalDFN">insert: <a href="#dfn-value-url" class="internalDFN" data-link-type="dfn"> value URL that is not null , and is associated with a delete: <a href="#dfn-column" class="internalDFN">insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> column where delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-column-suppress-output" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-column-suppress-output" class="externalDFN"> suppress output annotation is false :
Create an empty delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object S i to represent the delete: <a href="#dfn-subject" class="internalDFN">insert: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> subject i .
( i is the index number with values from 1 to n , where n is the number of delete: <a title="subject" href="#dfn-subject" class="internalDFN">insert: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> subjects for the delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row )
delete: <a title="subject" href="#dfn-subject" class="internalDFN">insert: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> Subject i is identified according to the delete: <a href="#dfn-about-url" class="internalDFN">insert: <a href="#dfn-about-url" class="internalDFN" data-link-type="dfn"> about URL annotation of its associated delete: <a title="cell" href="#dfn-cell" class="internalDFN">insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cells : I S . For a default delete: <a href="#dfn-subject" class="internalDFN">insert: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> subject where delete: <a href="#dfn-about-url" class="internalDFN">insert: <a href="#dfn-about-url" class="internalDFN" data-link-type="dfn"> about URL is not specified by its delete: <a title="cell" href="#dfn-cell" class="internalDFN">insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cells , I S is null .
If the identifier for delete: <a href="#dfn-subject" class="internalDFN">insert: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> subject i , I S , is not null , then insert the following name-value pair into delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object S i :
name
@id
value
I S
Each delete: <a href="#dfn-cell" class="internalDFN">insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cell referring to delete: <a href="#dfn-subject" class="internalDFN">insert: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> subject i is then processed sequentially according to the order of the delete: <a title="column" href="#dfn-column" class="internalDFN">insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> columns .
For each delete: <a href="#dfn-cell" class="internalDFN">insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cell referring to delete: <a href="#dfn-subject" class="internalDFN">insert: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> subject i , where the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-column-suppress-output" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-column-suppress-output" class="externalDFN"> suppress output annotation for the delete: <a href="#dfn-column" class="internalDFN">insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> column associated with that delete: <a href="#dfn-cell" class="internalDFN">insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cell is false , insert a name-value pair into delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object S i as described below:
If the value of delete: <a href="#dfn-property-url" class="internalDFN">insert: <a href="#dfn-property-url" class="internalDFN" data-link-type="dfn"> property URL for the delete: <a href="#dfn-cell" class="internalDFN">insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cell is not null , then delete: <a href="#dfn-name" class="internalDFN">insert: <a href="#dfn-name" class="internalDFN" data-link-type="dfn"> name N takes the value of delete: <a href="#dfn-property-url" class="internalDFN">insert: <a href="#dfn-property-url" class="internalDFN" data-link-type="dfn"> property URL compacted according to the rules as defined in delete: <a href="http://www.w3.org/TR/2015/CR-tabular-metadata-20150716/#url-compaction">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-metadata-20151117/#url-compaction"> URL Compaction in [ tabular-metadata ].
Else, delete: <a href="#dfn-name" class="internalDFN">insert: <a href="#dfn-name" class="internalDFN" data-link-type="dfn"> name N takes the URI decoded value of the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-column-name" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-name" class="externalDFN"> name annotation for the delete: <a href="#dfn-column" class="internalDFN">insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> column associated with the delete: <a href="#dfn-cell" class="internalDFN">insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cell . (URI decoding is necessary as delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-column-name" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-name" class="externalDFN"> name may have been encoded if it was taken from a supplied title.)
If the delete: <a href="#dfn-value-url" class="internalDFN">insert: <a href="#dfn-value-url" class="internalDFN" data-link-type="dfn"> value URL for the current delete: <a href="#dfn-cell" class="internalDFN">insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cell is not null , then insert the following name-value pair into delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object S i :
name
N
value
V url
where V url is the value of delete: <a href="#dfn-value-url" class="internalDFN">insert: <a href="#dfn-value-url" class="internalDFN" data-link-type="dfn"> value URL annotation for the current delete: <a href="#dfn-cell" class="internalDFN">insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cell expressed as a string in the JSON output. If N is @type , compact V url according to the rules as defined in delete: <a href="http://www.w3.org/TR/2015/CR-tabular-metadata-20150716/#url-compaction">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-metadata-20151117/#url-compaction"> URL Compaction in [ tabular-metadata ].
Else, if the delete: <a href="#dfn-cell-value" class="internalDFN">insert: <a href="#dfn-cell-value" class="internalDFN" data-link-type="dfn"> cell value is a delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-value-list" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-list" class="externalDFN"> list that is not empty, then the delete: <a href="#dfn-cell-value" class="internalDFN">insert: <a href="#dfn-cell-value" class="internalDFN" data-link-type="dfn"> cell value provides a sequence of values for inclusion within the JSON output; insert an delete: <a href="#dfn-array" class="internalDFN">insert: <a href="#dfn-array" class="internalDFN" data-link-type="dfn"> array A v containing each value V of the sequence into delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object S i :
name
N
value
A v
Each of the values V derived from the sequence MUST be expressed in the JSON output according to the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-value-datatype" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-value-datatype" class="externalDFN"> datatype of V as defined below in section 4.5 Interpreting datatypes .
Note
Since delete: <a title="array" href="#dfn-array" class="internalDFN">insert: <a href="#dfn-array" class="internalDFN" data-link-type="dfn"> arrays are implicitly ordered in JSON, the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-ordered" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-ordered" class="externalDFN"> ordered annotation has no effect on the JSON output.
Else, if the delete: <a href="#dfn-cell-value" class="internalDFN">insert: <a href="#dfn-cell-value" class="internalDFN" data-link-type="dfn"> cell value is not null , then the delete: <a href="#dfn-cell-value" class="internalDFN">insert: <a href="#dfn-cell-value" class="internalDFN" data-link-type="dfn"> cell value provides a single value V for inclusion within the JSON output; insert the following name-value pair into delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object S i :
name
N
value
V
Value V derived from the delete: <a title="cell value" href="#dfn-cell-value" class="internalDFN">insert: <a href="#dfn-cell-value" class="internalDFN" data-link-type="dfn"> cell values MUST be expressed in the JSON output according to the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-value-datatype" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-value-datatype" class="externalDFN"> datatype of the value as defined in section 4.5 Interpreting datatypes .
If delete: <a href="#dfn-name" class="internalDFN">insert: <a href="#dfn-name" class="internalDFN" data-link-type="dfn"> name N occurs more than once within delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object S i , the name-value pairs from each occurrence of delete: <a href="#dfn-name" class="internalDFN">insert: <a href="#dfn-name" class="internalDFN" data-link-type="dfn"> name N MUST be compacted to form a single name-value pair with delete: <a href="#dfn-name" class="internalDFN">insert: <a href="#dfn-name" class="internalDFN" data-link-type="dfn"> name N and whose value is an array containing all values from each of those name-value pairs. Where the value from one or more contributing name-value pairs is of type array, the values from contributing arrays are included directly to the resulting array (i.e. arrays of values are flattened).
4.4 Generating Nested Objects
The steps in the algorithm defined herein apply to both delete: <a title="standard mode" href="#dfn-standard-mode" class="internalDFN">insert: <a href="#dfn-standard-mode" class="internalDFN" data-link-type="dfn"> standard and delete: <a title="minimal mode" href="#dfn-minimal-mode" class="internalDFN">insert: <a href="#dfn-minimal-mode" class="internalDFN" data-link-type="dfn"> minimal modes.
Where the current delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row describes multiple delete: <a title="subject" href="#dfn-subject" class="internalDFN">insert: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> subjects , it MAY be possible to organise the delete: <a title="object" href="#dfn-object" class="internalDFN">organize the insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> objects associated with those delete: <a title="subject" href="#dfn-subject" class="internalDFN">insert: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> subjects such that some delete: <a title="object" href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> objects are nested within others; e.g. where the delete: <a href="#dfn-value-url" class="internalDFN">insert: <a href="#dfn-value-url" class="internalDFN" data-link-type="dfn"> value URL annotation for one delete: <a href="#dfn-cell" class="internalDFN">insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cell matches the delete: <a href="#dfn-about-url" class="internalDFN">insert: <a href="#dfn-about-url" class="internalDFN" data-link-type="dfn"> about URL annotation for another delete: <a href="#dfn-cell" class="internalDFN">insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cell in the same delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row . This algorithm considers a sequence of delete: <a title="object" href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> objects generated according to 4.3 Generating Objects , S 1 to S n , each of which corresponds to a delete: <a href="#dfn-subject" class="internalDFN">insert: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> subject described by the current delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row . It generates a new sequence of delete: <a href="#dfn-root" class="internalDFN">insert: <a href="#dfn-root" class="internalDFN" data-link-type="dfn"> root delete: <a title="object" href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> objects , S R 1 to S R m , that MAY include nested delete: <a title="object" href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> objects .
Note
Where the current delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row describes only a single delete: <a href="#dfn-subject" class="internalDFN">insert: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> subject , this algorithm may be bypassed as no nesting is possible. In such a case, the delete: <a href="#dfn-root" class="internalDFN">insert: <a href="#dfn-root" class="internalDFN" data-link-type="dfn"> root delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object S R 1 is identical to the original delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object S 1 .
Note
This nesting algorithm is based on the interrelationships between delete: <a title="subject" href="#dfn-subject" class="internalDFN">insert: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> subjects described within a given delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row that are specified using the delete: <a href="#dfn-value-url" class="internalDFN">insert: <a href="#dfn-value-url" class="internalDFN" data-link-type="dfn"> value URL annotation. delete: <a title="cell value" href="#dfn-cell-value" class="internalDFN">insert: <a href="#dfn-cell-value" class="internalDFN" data-link-type="dfn"> Cell values expressing the identity of a delete: <a href="#dfn-subject" class="internalDFN">insert: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> subject in the current delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row (i.e., as a simple literal) will be ignored by this algorithm.
If two delete: <a title="vertex" href="#dfn-vertex" class="internalDFN">insert: <a href="#dfn-vertex" class="internalDFN" data-link-type="dfn"> vertices are connected in a delete: <a href="#dfn-tree" class="internalDFN">insert: <a href="#dfn-tree" class="internalDFN" data-link-type="dfn"> tree , the one which is further away from the delete: <a href="#dfn-root" class="internalDFN">insert: <a href="#dfn-root" class="internalDFN" data-link-type="dfn"> root of the delete: <a href="#dfn-tree" class="internalDFN">insert: <a href="#dfn-tree" class="internalDFN" data-link-type="dfn"> tree is referred to as the child of the other.
A delete: <a href="#dfn-vertex" class="internalDFN">insert: <a href="#dfn-vertex" class="internalDFN" data-link-type="dfn"> vertex N is a descendant of a delete: <a href="#dfn-vertex" class="internalDFN">insert: <a href="#dfn-vertex" class="internalDFN" data-link-type="dfn"> vertex M if either N is the delete: <a href="#dfn-child" class="internalDFN">insert: <a href="#dfn-child" class="internalDFN" data-link-type="dfn"> child M , or there are delete: <a title="vertex" href="#dfn-vertex" class="internalDFN">insert: <a href="#dfn-vertex" class="internalDFN" data-link-type="dfn"> vertices V 1 ,…,V k , such that V 1 =M , V k =N , and V k+1 is a delete: <a href="#dfn-child" class="internalDFN">insert: <a href="#dfn-child" class="internalDFN" data-link-type="dfn"> child of V k .
One of the main constituents of delete: <a title="graph" href="#dfn-graph" class="internalDFN">insert: <a href="#dfn-graph" class="internalDFN" data-link-type="dfn"> graphs ; in such data structures edges are used to establish relationships among delete: <a title="vertex" href="#dfn-vertex" class="internalDFN">insert: <a href="#dfn-vertex" class="internalDFN" data-link-type="dfn"> vertices . In the context of this algorithm, edges are expressed in JSON using a name-value pair whose value is another delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object or an delete: <a href="#dfn-array" class="internalDFN">insert: <a href="#dfn-array" class="internalDFN" data-link-type="dfn"> array of delete: <a title="object" href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> objects .
A collection of disjoint delete: <a title="tree" href="#dfn-tree" class="internalDFN">insert: <a href="#dfn-tree" class="internalDFN" data-link-type="dfn"> trees . For the purpose of this algorithm, the order of the delete: <a title="tree" href="#dfn-tree" class="internalDFN">insert: <a href="#dfn-tree" class="internalDFN" data-link-type="dfn"> trees are is important, i.e., forests can also be viewed as a an ordered sequence of delete: <a title="root" href="#dfn-root" class="internalDFN">insert: <a href="#dfn-root" class="internalDFN" data-link-type="dfn"> roots .
Data structure consisting of delete: <a title="vertex" href="#dfn-vertex" class="internalDFN">insert: <a href="#dfn-vertex" class="internalDFN" data-link-type="dfn"> vertices (or "nodes") and delete: <a title="edge" href="#dfn-edge" class="internalDFN">insert: <a href="#dfn-edge" class="internalDFN" data-link-type="dfn"> edges . See, for example, [ Knuth ] for further details.
A dedicated delete: <a href="#dfn-vertex" class="internalDFN">insert: <a href="#dfn-vertex" class="internalDFN" data-link-type="dfn"> vertex in a delete: <a href="#dfn-tree" class="internalDFN">insert: <a href="#dfn-tree" class="internalDFN" data-link-type="dfn"> tree ; a insert: <em> root insert: </em> is not the delete: <a href="#dfn-child" class="internalDFN">insert: <a href="#dfn-child" class="internalDFN" data-link-type="dfn"> child of any delete: <a href="#dfn-vertex" class="internalDFN">insert: <a href="#dfn-vertex" class="internalDFN" data-link-type="dfn"> vertex .
delete: <dfn id="dfn-tree">insert: <dfn data-dfn-type="dfn" id="dfn-tree"> tree
A tree (or rooted tree ) is a connected, acyclic delete: <a href="#dfn-graph" class="internalDFN">insert: <a href="#dfn-graph" class="internalDFN" data-link-type="dfn"> graph where one delete: <a href="#dfn-vertex" class="internalDFN">insert: <a href="#dfn-vertex" class="internalDFN" data-link-type="dfn"> vertex has been designated as the delete: <a href="#dfn-root" class="internalDFN">insert: <a href="#dfn-root" class="internalDFN" data-link-type="dfn"> root , in which case the delete: <a title="edge" href="#dfn-edge" class="internalDFN">insert: <a href="#dfn-edge" class="internalDFN" data-link-type="dfn"> edges have a natural orientation towards or away from the delete: <a href="#dfn-root" class="internalDFN">insert: <a href="#dfn-root" class="internalDFN" data-link-type="dfn"> root .
One of the main constituents of delete: <a title="graph" href="#dfn-graph" class="internalDFN">insert: <a href="#dfn-graph" class="internalDFN" data-link-type="dfn"> graphs ; in such data structures a vertex usually holds further information or data. In the context of this algorithm, vertices are used to represent the JSON delete: <a title="object" href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> objects .
The nesting algorithm is defined as follows:
For all delete: <a title="cell" href="#dfn-cell" class="internalDFN">insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cells in the current delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row , determine the delete: <a title="value URL" href="#dfn-value-url" class="internalDFN">insert: <a href="#dfn-value-url" class="internalDFN" data-link-type="dfn"> value URLs , V url , that occur only once . The list of these uniquely occurring delete: <a title="value URL" href="#dfn-value-url" class="internalDFN">insert: <a href="#dfn-value-url" class="internalDFN" data-link-type="dfn"> value URLs is referred to as the URL-list .
Create an empty delete: <a href="#dfn-forest" class="internalDFN">insert: <a href="#dfn-forest" class="internalDFN" data-link-type="dfn"> forest F . delete: <a title="vertex" href="#dfn-vertex" class="internalDFN">insert: <a href="#dfn-vertex" class="internalDFN" data-link-type="dfn"> Vertices in the delete: <a title="tree" href="#dfn-tree" class="internalDFN">insert: <a href="#dfn-tree" class="internalDFN" data-link-type="dfn"> trees of this delete: <a href="#dfn-forest" class="internalDFN">insert: <a href="#dfn-forest" class="internalDFN" data-link-type="dfn"> forest represent the delete: <a title="subject" href="#dfn-subject" class="internalDFN">insert: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> subjects described by the current delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row .
For each delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object S i in the sequence S 1 to S n :
Determine the identity of delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object S i : I S . If present in delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object S i , the name-value pair with delete: <a href="#dfn-name" class="internalDFN">insert: <a href="#dfn-name" class="internalDFN" data-link-type="dfn"> name @id provides the value of I S . Else, delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object S i is not explicitly identified and I S is null .
Check whether there is a delete: <a href="#dfn-vertex" class="internalDFN">insert: <a href="#dfn-vertex" class="internalDFN" data-link-type="dfn"> vertex N in delete: <a href="#dfn-forest" class="internalDFN">insert: <a href="#dfn-forest" class="internalDFN" data-link-type="dfn"> forest F that represents delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object S i . If none of the existing delete: <a title="vertex" href="#dfn-vertex" class="internalDFN">insert: <a href="#dfn-vertex" class="internalDFN" data-link-type="dfn"> vertices in delete: <a href="#dfn-forest" class="internalDFN">insert: <a href="#dfn-forest" class="internalDFN" data-link-type="dfn"> forest F represent delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object S i , then insert a new delete: <a href="#dfn-tree" class="internalDFN">insert: <a href="#dfn-tree" class="internalDFN" data-link-type="dfn"> tree into delete: <a href="#dfn-forest" class="internalDFN">insert: <a href="#dfn-forest" class="internalDFN" data-link-type="dfn"> forest F whose delete: <a href="#dfn-root" class="internalDFN">insert: <a href="#dfn-root" class="internalDFN" data-link-type="dfn"> root is a delete: <a href="#dfn-vertex" class="internalDFN">insert: <a href="#dfn-vertex" class="internalDFN" data-link-type="dfn"> vertex N that represents delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object S i and has identity I S .
For all delete: <a title="cell" href="#dfn-cell" class="internalDFN">insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cells associated with the current delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object S i (e.g. whose delete: <a href="#dfn-about-url" class="internalDFN">insert: <a href="#dfn-about-url" class="internalDFN" data-link-type="dfn"> about URL annotation matches I S ):
If the delete: <a href="#dfn-value-url" class="internalDFN">insert: <a href="#dfn-value-url" class="internalDFN" data-link-type="dfn"> value URL annotation of the current delete: <a href="#dfn-cell" class="internalDFN">insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cell is defined and its value, V url , appears in the URL-list , then check each of the other delete: <a title="object" href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> objects in the sequence S 1 to S n to determine if V url identifies one of those delete: <a title="object" href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> objects .
For delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object S j , if the name-value pair with delete: <a href="#dfn-name" class="internalDFN">insert: <a href="#dfn-name" class="internalDFN" data-link-type="dfn"> name @id is present and its value matches V url , then:
If the delete: <a href="#dfn-root" class="internalDFN">insert: <a href="#dfn-root" class="internalDFN" data-link-type="dfn"> root of the delete: <a href="#dfn-tree" class="internalDFN">insert: <a href="#dfn-tree" class="internalDFN" data-link-type="dfn"> tree containing delete: <a href="#dfn-vertex" class="internalDFN">insert: <a href="#dfn-vertex" class="internalDFN" data-link-type="dfn"> vertex N is a delete: <a href="#dfn-vertex" class="internalDFN">insert: <a href="#dfn-vertex" class="internalDFN" data-link-type="dfn"> vertex that represents delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object S j , then delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object S i is already a delete: <a href="#dfn-descendant" class="internalDFN">insert: <a href="#dfn-descendant" class="internalDFN" data-link-type="dfn"> descendant of delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object S j ; no further action should insert: <em class="rfc2119" title="SHOULD">SHOULD insert: </em> be taken for this instance of V url .
Note
This clause in the algorithm prevents circular loops from being created.
Furthermore, because the URL-list contains delete: <a title="value URL" href="#dfn-value-url" class="internalDFN">insert: <a href="#dfn-value-url" class="internalDFN" data-link-type="dfn"> value URLs that occur only once for the current delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row , delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object S i cannot be a delete: <a href="#dfn-descendant" class="internalDFN">insert: <a href="#dfn-descendant" class="internalDFN" data-link-type="dfn"> descendant of an intermediate delete: <a title="vertex" href="#dfn-vertex" class="internalDFN">insert: <a href="#dfn-vertex" class="internalDFN" data-link-type="dfn"> vertices in the delete: <a href="#dfn-tree" class="internalDFN">insert: <a href="#dfn-tree" class="internalDFN" data-link-type="dfn"> tree .
Else, if there is a delete: <a href="#dfn-root" class="internalDFN">insert: <a href="#dfn-root" class="internalDFN" data-link-type="dfn"> root delete: <a href="#dfn-vertex" class="internalDFN">insert: <a href="#dfn-vertex" class="internalDFN" data-link-type="dfn"> vertex M in delete: <a href="#dfn-forest" class="internalDFN">insert: <a href="#dfn-forest" class="internalDFN" data-link-type="dfn"> forest F that represents delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object S j , then set delete: <a href="#dfn-vertex" class="internalDFN">insert: <a href="#dfn-vertex" class="internalDFN" data-link-type="dfn"> vertex M as a delete: <a href="#dfn-child" class="internalDFN">insert: <a href="#dfn-child" class="internalDFN" data-link-type="dfn"> child of delete: <a href="#dfn-vertex" class="internalDFN">insert: <a href="#dfn-vertex" class="internalDFN" data-link-type="dfn"> vertex N and remove delete: <a href="#dfn-vertex" class="internalDFN">insert: <a href="#dfn-vertex" class="internalDFN" data-link-type="dfn"> vertex M from the list of delete: <a title="root" href="#dfn-root" class="internalDFN">insert: <a href="#dfn-root" class="internalDFN" data-link-type="dfn"> roots in delete: <a href="#dfn-forest" class="internalDFN">insert: <a href="#dfn-forest" class="internalDFN" data-link-type="dfn"> forest F (i.e., the delete: <a href="#dfn-tree" class="internalDFN">insert: <a href="#dfn-tree" class="internalDFN" data-link-type="dfn"> tree rooted by M becomes a sub-tree of N ).
Else, create a new delete: <a href="#dfn-vertex" class="internalDFN">insert: <a href="#dfn-vertex" class="internalDFN" data-link-type="dfn"> vertex M that represents delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object S j as a delete: <a href="#dfn-child" class="internalDFN">insert: <a href="#dfn-child" class="internalDFN" data-link-type="dfn"> child of delete: <a href="#dfn-vertex" class="internalDFN">insert: <a href="#dfn-vertex" class="internalDFN" data-link-type="dfn"> vertex N .
Each delete: <a href="#dfn-vertex" class="internalDFN">insert: <a href="#dfn-vertex" class="internalDFN" data-link-type="dfn"> vertex in delete: <a href="#dfn-forest" class="internalDFN">insert: <a href="#dfn-forest" class="internalDFN" data-link-type="dfn"> forest F represents an object in the original sequence of delete: <a title="object" href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> objects S 1 to S n and is associated with a delete: <a href="#dfn-subject" class="internalDFN">insert: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> subject described by the current delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row . Rearrange delete: <a title="object" href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> objects S 1 to S n such that they mirror the structure of the delete: <a title="tree" href="#dfn-tree" class="internalDFN">insert: <a href="#dfn-tree" class="internalDFN" data-link-type="dfn"> trees in delete: <a href="#dfn-forest" class="internalDFN">insert: <a href="#dfn-forest" class="internalDFN" data-link-type="dfn"> forest F as follows: If delete: <a href="#dfn-vertex" class="internalDFN">insert: <a href="#dfn-vertex" class="internalDFN" data-link-type="dfn"> vertex M , representing delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object S i , is a delete: <a href="#dfn-child" class="internalDFN">insert: <a href="#dfn-child" class="internalDFN" data-link-type="dfn"> child of delete: <a href="#dfn-vertex" class="internalDFN">insert: <a href="#dfn-vertex" class="internalDFN" data-link-type="dfn"> vertex N , representing delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object S j , then the name-value pair in delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object S j associated with the delete: <a href="#dfn-edge" class="internalDFN">insert: <a href="#dfn-edge" class="internalDFN" data-link-type="dfn"> edge relating M and N MUST be modifed modified such that the (literal) value, V url , from that name-value pair is replaced by delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object S i thus creating a nested delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object .
Return the sequence of delete: <a href="#dfn-root" class="internalDFN">insert: <a href="#dfn-root" class="internalDFN" data-link-type="dfn"> root delete: <a title="object" href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> objects , S R 1 to S R m .
Note
An implementation may be able to optimize the algorithm by skipping branches (e.g. if URL-list is empty) or by other means.
4.5 Interpreting datatypes
delete: <a title="cell value" href="#dfn-cell-value" class="internalDFN">insert: <a href="#dfn-cell-value" class="internalDFN" data-link-type="dfn"> Cell values are expressed in the JSON output according to the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-value-datatype" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-value-datatype" class="externalDFN"> cell value's datatype . The relationship between the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-datatype-base" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-base" class="externalDFN"> base annotation value of the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-value-datatype" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-value-datatype" class="externalDFN"> cell value's datatype and the primitive types supported by JSON (as specified in [ RFC7159 ]) is provided in the table below. below:
Instances of JSON reserved characters within string values MUST be escaped as defined in [ RFC7159 ].
JSON has no native support for expressing language information; therefore the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-value-language" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-lang" class="externalDFN"> language of a value has no effect on the JSON output.
Note
Only the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-datatype-base" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-base" class="externalDFN"> base annotation value is used to determine the primitive type used wihtin within the JSON output. Additional restrictions to the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-value-datatype" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-value-datatype" class="externalDFN"> cell value's datatype , such as the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-datatype-id" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-datatype-id" class="externalDFN"> id annotation, are ignored for the purposes of conversion to JSON.
Note
A delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-value-datatype" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-value-datatype" class="externalDFN"> datatype's delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-datatype-format" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-format" class="externalDFN"> format is irrelevant to the conversion procedure defined in this specification; the delete: <a href="#dfn-cell-value" class="internalDFN">insert: <a href="#dfn-cell-value" class="internalDFN" data-link-type="dfn"> cell value has already been parsed from the contents the delete: <a href="#dfn-cell" class="internalDFN">of the insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cell according to the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-datatype-format" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-format" class="externalDFN"> format annotation.
Where insert: <a href="#dfn-cell-errors" class="internalDFN" data-link-type="dfn">Cell errors insert: </a>insert: <em class="rfc2119" title="MUST">MUST insert: </em>be recorded by applications where the contents of the delete: <a href="#dfn-cell" class="internalDFN">a insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cell cannot be parsed, parsed or other validation errors occur, delete: <a href="#dfn-cell-errors" class="internalDFN">validated (see insert: <cite>insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#parsing-cells">Parsing Cells insert: </a>insert: </cite>and insert: <cite>insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#validating-tables">Validating Tables insert: </a>insert: </cite>in [ insert: <cite>insert: <a class="bibref" href="#bib-tabular-data-model">tabular-data-model insert: </a>insert: </cite>] respectively). In cases where insert: <a href="#dfn-cell-errors" class="internalDFN" data-link-type="dfn"> cell errors will be provided. It is an implementation decision are recorded, applications may attempt to determine how the appropriate JSON primitive type during the subsequent conversion applications should proceed in the event that delete: <a href="#dfn-cell-errors" class="internalDFN">cell errors delete: </a>are encountered. process according to local rules.
This section defines a mechanism for transforming the [ json-ld ] delete: <a href="http://www.w3.org/TR/2015/CR-tabular-metadata-20150716/#json-ld-dialect">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-metadata-20151117/#json-ld-dialect"> dialect used for delete: <a href="#dfn-non-core-annotations" class="internalDFN">insert: <a href="#dfn-non-core-annotations" class="internalDFN" data-link-type="dfn"> non-core annotations and delete: <a href="#dfn-notes" class="internalDFN">insert: <a href="#dfn-notes" class="internalDFN" data-link-type="dfn"> notes originating from the processing of metadata (as defined in [ tabular-metadata ]) into JSON.
Note
Conversion applications may have other means to create delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN">insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> annotated tables , e.g., e.g. through some application specific API-s. 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 should be are converted into RDF. JSON.
Name-value pairs from delete: <a href="#dfn-notes" class="internalDFN">insert: <a href="#dfn-notes" class="internalDFN" data-link-type="dfn"> notes and delete: <a href="#dfn-non-core-annotations" class="internalDFN">insert: <a href="#dfn-non-core-annotations" class="internalDFN" data-link-type="dfn"> non-core annotations annotations are generally copied verbatim from the metadata description subject to the exceptions below:
Name-value pairs whose value is an delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object using the [ json-ld ] keyword @value , for example:
name
N
value
{ "@value": " V " }
are transformed to:
name
N
value
V
Name-value pairs occurring within the value object that use [ json-ld ] keywords @language and @type are ignored.
Name-value pairs whose value is an delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object using the [ json-ld ] keyword @id to coerce a string-value to be interpreted as an IRI, for example:
name
N
value
{ "@id": " V url " }
are transformed to:
name
N
value
V url
In addition to compacting values of delete: <a title="property URL" href="#dfn-property-url" class="internalDFN">insert: <a href="#dfn-property-url" class="internalDFN" data-link-type="dfn"> property URLs , URLs which ware were the value of insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn">objects insert: </a>using the [ insert: <cite>insert: <a class="bibref" href="#bib-json-ld">json-ld insert: </a>insert: </cite>] keyword @type used within the delete: <a href="#dfn-notes" class="internalDFN">notes delete: </a>and delete: <a href="#dfn-non-core-annotations" class="internalDFN">non-core annotations delete: </a> are compacted according to the rules as defined in delete: <a href="http://www.w3.org/TR/2015/CR-tabular-metadata-20150716/#url-compaction">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-metadata-20151117/#url-compaction"> URL Compaction in [ tabular-metadata ].
6. Examples
This section is non-normative.
Note
Each of the examples expresses more complex conversions - it is recommended that readers of this specification work through the examples in sequential order.
6.1 Simple example
This example comprises a single delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN">insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> 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/CR-tabular-data-model-20150716/#dfn-header-line" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-header-line" class="externalDFN"> header line , no further metadata annotations are given. The tabular data file is provided below:
Example 2 : http://example.org/countries.csv
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">insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> annotated table generated from parsing the tabular data file is shown below and provides the basis for the conversion to JSON.
Annotations for the resulting delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN">insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> 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 title="column" href="#dfn-column" class="internalDFN">insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> columns , delete: <a title="row" href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> rows and delete: <a title="cell" href="#dfn-cell" class="internalDFN">insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cells in delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN">insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table T are shown in the tables below. below:
delete: <a title="minimal mode" href="#dfn-minimal-mode" class="internalDFN">insert: <a href="#dfn-minimal-mode" class="internalDFN" data-link-type="dfn"> Minimal mode output for this example is provided below:
Example 3 : http://example.org/countries-minimal.json
The delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-about-url" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#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 title="cell" href="#dfn-cell" class="internalDFN">insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cells in a given delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row where delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-about-url" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#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">insert: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> subject and so the name-value pairs associated with the delete: <a title="cell value" href="#dfn-cell-value" class="internalDFN">insert: <a href="#dfn-cell-value" class="internalDFN" data-link-type="dfn"> cell values of that delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row occur within the same delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object .
Given that the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-property-url" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-property-url" class="externalDFN"> property URL is null for cells in table T ( { "url": "http://example.org/countries.csv"} ), the simplified delete: <a href="#dfn-name" class="internalDFN">insert: <a href="#dfn-name" class="internalDFN" data-link-type="dfn"> name is used in the name-value pairs; e.g. countryCode rather than http://example.org/countries.csv#countryCode
delete: <a title="standard mode" href="#dfn-standard-mode" class="internalDFN">insert: <a href="#dfn-standard-mode" class="internalDFN" data-link-type="dfn"> Standard mode output for this example is provided below:
Example 4 : http://example.org/countries-standard.json
Even though the delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN">insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table was defined in isolation, the delete: <a href="#dfn-annotated-table" class="internalDFN">insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> annotated table is wrapped in a delete: <a href="#dfn-group-of-tables" class="internalDFN">insert: <a href="#dfn-group-of-tables" class="internalDFN" data-link-type="dfn"> group of tables .
The name-value pair with delete: <a href="#dfn-name" class="internalDFN">insert: <a href="#dfn-name" class="internalDFN" data-link-type="dfn"> name url provides reference to the original tabular data file and to specific delete: <a title="row" href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> rows therein.
The delete: <a href="#dfn-row-number" class="internalDFN">insert: <a href="#dfn-row-number" class="internalDFN" data-link-type="dfn"> row number is provided for each delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row using name-value pair with delete: <a href="#dfn-name" class="internalDFN">insert: <a href="#dfn-name" class="internalDFN" data-link-type="dfn"> name rownum .
The delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object containing the name-values pairs associated with the delete: <a title="cell value" href="#dfn-cell-value" class="internalDFN">insert: <a href="#dfn-cell-value" class="internalDFN" data-link-type="dfn"> cell values of a delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row are related to the delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object for that delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row using the name-value pair with delete: <a href="#dfn-name" class="internalDFN">insert: <a href="#dfn-name" class="internalDFN" data-link-type="dfn"> name describes .
6.2 Example with single table and rich annotations
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">insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> 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:
Example 5 : http://example.org/tree-ops-ext.csv
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>"
Example 6 : http://example.org/tree-ops-ext.csv-metadata.json
{ "@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}" } }
Note
The delete: <a href="#dfn-notes" class="internalDFN">insert: <a href="#dfn-notes" class="internalDFN" data-link-type="dfn"> 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">insert: <a href="#dfn-notes" class="internalDFN" data-link-type="dfn"> notes annotation.
The delete: <a href="#dfn-annotated-table" class="internalDFN">insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> annotated table generated from parsing the tabular data file and associated metadata is shown below and provides the basis for the conversion to JSON.
Core annotations for the resulting delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN">insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table T , with 9 delete: <a title="column" href="#dfn-column" class="internalDFN">insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> columns and 3 delete: <a title="row" href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> 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 title="annotated table" href="#dfn-annotated-table" class="internalDFN">insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table T are:
The value of the delete: <a href="#dfn-notes" class="internalDFN">insert: <a href="#dfn-notes" class="internalDFN" data-link-type="dfn"> notes annotation has been shortened for clarity in the table above.
Annotations for the delete: <a title="column" href="#dfn-column" class="internalDFN">insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> columns , delete: <a title="row" href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> rows and delete: <a title="cell" href="#dfn-cell" class="internalDFN">insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cells in delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN">insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table T are shown in the tables below. below:
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.
Note
In this example, output for delete: <a href="#dfn-column" class="internalDFN">insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> column C1 ( GID ) is not required; note the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-column-suppress-output" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-column-suppress-output" class="externalDFN"> suppress output annotation on this delete: <a href="#dfn-column" class="internalDFN">insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> column .
"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"
The lists of values from delete: <a title="cell" href="#dfn-cell" class="internalDFN">insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cells in delete: <a href="#dfn-column" class="internalDFN">insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> column C7 ( "name": "comments" ) are assumed to be unordered as the boolean delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-ordered" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-ordered" class="externalDFN"> ordered annotation, which defaults to false , has not be set within the metadata description.
delete: <a title="minimal mode" href="#dfn-minimal-mode" class="internalDFN">insert: <a href="#dfn-minimal-mode" class="internalDFN" data-link-type="dfn"> Minimal mode output for this example is provided below:
Example 7 : http://example.org/tree-ops-ext-minimal.json
The delete: <a href="#dfn-subject" class="internalDFN">insert: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> subject described by each delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row is explicitly defined using the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-about-url" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-about-url" class="externalDFN"> about URL annotation; e.g. the delete: <a href="#dfn-subject" class="internalDFN">insert: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> subject of delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row R1 is http://example.org/tree-ops-ext#gid-1 .
Output for delete: <a href="#dfn-column" class="internalDFN">insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> column C1 ( { "name": "GID" } ) is not included as delete: <a href="#dfn-column" class="internalDFN">insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> column delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-column-suppress-output" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-column-suppress-output" class="externalDFN"> suppress output annotation is true .
delete: <a title="cell" href="#dfn-cell" class="internalDFN">insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> Cells C1.7 and C2.7 ( delete: <a title="row" href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> rows R1 and R2 ; delete: <a href="#dfn-column" class="internalDFN">insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> column , { "name": "comments" } ) have null delete: <a title="cell value" href="#dfn-cell-value" class="internalDFN">insert: <a data-lt="cell value" href="#dfn-cell-value" class="internalDFN" data-link-type="dfn"> values - no output is included for these delete: <a title="cell" href="#dfn-cell" class="internalDFN">insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cells .
delete: <a title="cell" href="#dfn-cell" class="internalDFN">insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> Cell C3.7 ( delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row R3 ; delete: <a href="#dfn-column" class="internalDFN">insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> column , { "name": "comments" } ) contains a sequence of values; the set of values are included in an delete: <a href="#dfn-array" class="internalDFN">insert: <a href="#dfn-array" class="internalDFN" data-link-type="dfn"> array .
delete: <a title="standard mode" href="#dfn-standard-mode" class="internalDFN">insert: <a href="#dfn-standard-mode" class="internalDFN" data-link-type="dfn"> Standard mode output for this example is provided below:
Example 8 : http://example.org/tree-ops-ext-standard.json
delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN">insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> Table T ( { "url": "http://example.org/tree-ops-ext.csv"} ) has been explicitly identified: { "@id": "<http://exmple.org/tree-ops-ext>"} .
delete: <a title="non-core annotations" href="#dfn-non-core-annotations" class="internalDFN">insert: <a href="#dfn-non-core-annotations" class="internalDFN" data-link-type="dfn"> Non-core annotations and delete: <a href="#dfn-notes" class="internalDFN">insert: <a href="#dfn-notes" class="internalDFN" data-link-type="dfn"> notes specified for delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN">insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table T ( { "url": "http://example.org/tree-ops-ext.csv"} ) are included in the output.
6.3 Example with single table and using virtual columns to produce multiple subjects per row
This example uses a single delete: <a href="#dfn-annotated-table" class="internalDFN">insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> annotated table describing a listing of music events. Each delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> 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:
The CSV to JSON translation is limited to providing one statement, or triple, per delete: <a href="#dfn-column" class="internalDFN">insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> column in the delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN">insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> 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 title="column" href="#dfn-column" class="internalDFN">insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> 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">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row of the delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN">insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table . Note that the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-column-virtual" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-virtual" class="externalDFN"> virtual annotation is true for these virtual delete: <a title="column" href="#dfn-column" class="internalDFN">insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> 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">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row in the delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN">insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> 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 JSON output has been generated.
The delete: <a href="#dfn-annotated-table" class="internalDFN">insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> annotated table generated from parsing the tabular data file and associated metadata is shown below and provides the basis for the conversion to JSON.
Annotations for the resulting delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN">insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table T , with 10 delete: <a title="column" href="#dfn-column" class="internalDFN">insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> columns and 2 delete: <a title="row" href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> 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 title="column" href="#dfn-column" class="internalDFN">insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> columns , delete: <a title="row" href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> rows and delete: <a title="cell" href="#dfn-cell" class="internalDFN">insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cells in delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN">insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table T are shown in the tables below. below:
delete: <a title="minimal mode" href="#dfn-minimal-mode" class="internalDFN">insert: <a href="#dfn-minimal-mode" class="internalDFN" data-link-type="dfn"> Minimal mode output for this example is provided below:
Example 11 : http://example.org/events-listing-minimal.json
Three resources are defined for each row within the table; event, location and offer. Therefore three delete: <a title="object" href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> objects are created for each delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row .
Each delete: <a href="#dfn-column" class="internalDFN">insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> column description explicitly defines both delete: <a href="http://www.w3.org/TR/2015/CR-tabular-metadata-20150716/#cell-aboutUrl">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-metadata-20151117/#cell-aboutUrl"> aboutUrl and delete: <a href="http://www.w3.org/TR/2015/CR-tabular-metadata-20150716/#cell-propertyUrl">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-metadata-20151117/#cell-propertyUrl"> propertyUrl properties which are used to create the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-about-url" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-about-url" class="externalDFN"> about URL and delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-property-url" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-property-url" class="externalDFN"> property URL annotations on the column's delete: <a title="cell" href="#dfn-cell" class="internalDFN">insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cells .
delete: <a title="column" href="#dfn-column" class="internalDFN">insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> 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">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row : schema:MusicEvent , schema:Place and schema:Offer respectively—noting that the use of rdf:type is converted to the delete: <a href="#dfn-name" class="internalDFN">insert: <a href="#dfn-name" class="internalDFN" data-link-type="dfn"> name @type (as used in [ json-ld ]) by this conversion application.
delete: <a title="column" href="#dfn-column" class="internalDFN">insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> Column C9 ( { "name": "location"} ) uses the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-about-url" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-about-url" class="externalDFN"> about URL , delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-property-url" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-property-url" class="externalDFN"> property URL and delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-value-url" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-value-url" class="externalDFN"> value URL to assert the relationship between the event and location resources.
delete: <a title="column" href="#dfn-column" class="internalDFN">insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> Column C10 ( { "name": "offer"} ) uses the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-about-url" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-about-url" class="externalDFN"> about URL , delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-property-url" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-property-url" class="externalDFN"> property URL and delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-value-url" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-value-url" class="externalDFN"> value URL to assert the relationship between the event and offer resources.
delete: <a title="standard mode" href="#dfn-standard-mode" class="internalDFN">insert: <a href="#dfn-standard-mode" class="internalDFN" data-link-type="dfn"> Standard mode output for this example is provided below:
Example 12 : http://example.org/events-listing-standard.json
The resources described by each delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row are explicitly defined using the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-about-url" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-about-url" class="externalDFN"> about URL annotation—in this case three resources per delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row (event, location, and offer). The delete: <a title="object" href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> objects containing the name-values pairs associated with the delete: <a title="cell value" href="#dfn-cell-value" class="internalDFN">insert: <a href="#dfn-cell-value" class="internalDFN" data-link-type="dfn"> cell values of a delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row are related to the delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object for each delete: <a href="#dfn-subject" class="internalDFN">insert: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> subject in that delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row using the name-value pair with delete: <a href="#dfn-name" class="internalDFN">insert: <a href="#dfn-name" class="internalDFN" data-link-type="dfn"> name describes .
6.4 Example with table group comprising four interrelated tables
This example is based on Use Case #4 - Publication of public sector roles and salaries and uses four delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN">insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> annotated tables published as a delete: <a href="#dfn-group-of-tables" class="internalDFN">insert: <a href="#dfn-group-of-tables" class="internalDFN" data-link-type="dfn"> 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/CR-tabular-metadata-20150716/#dfn-schema" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-metadata-20151117/#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">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> 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 not rather than the centrally published information listing organizations and professions.
The input tabular data files and associated metadata descriptions are provided below:
Example 13 : http://example.org/gov.uk/data/organizations.csv
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
Example 14 : http://example.org/gov.uk/data/professions.csv
Profession Finance Information Technology Operational Delivery Policy
Example 15 : http://example.org/senior-roles.csv
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
Example 16 : http://example.org/junior-roles.csv
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
This example makes extensive use of the example.org domain. As described in [ 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/CR-tabular-metadata-20150716/#dfn-schema-description" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-metadata-20151117/#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/CR-tabular-data-model-20150716/#dfn-table" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-table" class="externalDFN"> tables and binds each of them to the appropriate delete: <a href="http://www.w3.org/TR/2015/CR-tabular-metadata-20150716/#dfn-schema" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-metadata-20151117/#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/CR-tabular-metadata-20150716/#dfn-uri-template-property">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-metadata-20151117/#dfn-uri-template-properties"> URI template property delete: <a href="http://www.w3.org/TR/2015/CR-tabular-metadata-20150716/#cell-aboutUrl">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-metadata-20151117/#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">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row of the senior roles tabular data.
The delete: <a href="#dfn-group-of-tables" class="internalDFN">insert: <a href="#dfn-group-of-tables" class="internalDFN" data-link-type="dfn"> group of tables generated from parsing the tabular data files and associated metadata is shown below and provides the basis for the conversion to JSON.
Annotations for the delete: <a href="#dfn-group-of-tables" class="internalDFN">insert: <a href="#dfn-group-of-tables" class="internalDFN" data-link-type="dfn"> group of tables G and the four delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN">insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> tables Ta , Tb , Tc , and Td are shown below. below:
delete: <a href="#dfn-group-of-tables" class="internalDFN">insert: <a href="#dfn-group-of-tables" class="internalDFN" data-link-type="dfn"> Group of Tables annotations:
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/CR-tabular-data-model-20150716/#dfn-table-suppress-output" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-table-suppress-output" class="externalDFN"> suppress output annotation on this delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN">insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> 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 title="column" href="#dfn-column" class="internalDFN">insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> columns , delete: <a title="row" href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> rows and delete: <a title="cell" href="#dfn-cell" class="internalDFN">insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cells in delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN">insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table T are shown in the tables below. below:
delete: <a title="column" href="#dfn-column" class="internalDFN">insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> Column Cc8 , with the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-metadata-20150716/#column-virtual">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-metadata-20151117/#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">insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> column Cc2 , to the associated post resource within the current delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row of delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN">insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table Tc ( { "url": "http://example.org/senior-roles.csv" } ).
Notice that delete: <a href="#dfn-value-url" class="internalDFN">insert: <a href="#dfn-value-url" class="internalDFN" data-link-type="dfn"> value URL is not specified for delete: <a title="cell" href="#dfn-cell" class="internalDFN">insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cells Ca2.3 and Cc2.5 because in each case the delete: <a href="#dfn-cell-value" class="internalDFN">insert: <a href="#dfn-cell-value" class="internalDFN" data-link-type="dfn"> cell value is null and the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-column-virtual" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-virtual" class="externalDFN"> virtual annotation of delete: <a href="#dfn-column" class="internalDFN">insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> column Cb5 is not defined.
delete: <a title="minimal mode" href="#dfn-minimal-mode" class="internalDFN">insert: <a href="#dfn-minimal-mode" class="internalDFN" data-link-type="dfn"> Minimal mode output for this example is provided below:
Example 22 : http://example.org/public-sector-roles-and-salaries-minimal.json
Output for delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN">insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> 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/CR-tabular-data-model-20150716/#dfn-table-suppress-output" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-table-suppress-output" class="externalDFN"> suppress output annotation has the value true for each of the delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN">insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> tables .
The delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-property-url" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-property-url" class="externalDFN"> property URL is specified for all delete: <a title="cell" href="#dfn-cell" class="internalDFN">insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cells in delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN">insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> tables Tc and Td .
delete: <a title="column" href="#dfn-column" class="internalDFN">insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> Columns Cc5 and Cd1 ( { "name": "reportsTo" } and { "name": "reportsToSenior" } ) use the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-about-url" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-about-url" class="externalDFN"> about URL , delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-property-url" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-property-url" class="externalDFN"> property URL and delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-value-url" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-value-url" class="externalDFN"> value URL annotations to assert the relationship between the post described by a given post insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn">row insert: </a> and the senior post to which it reports to for the delete: <a title="cell" href="#dfn-cell" class="internalDFN">cells delete: </a>therein. reports. However, since senior posts and junior posts are described in different tables it is not possible to create nested delete: <a title="object" href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> objects for this particular case.
Similarly, delete: <a title="column" href="#dfn-column" class="internalDFN">insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> columns Cc7 and Cd8 (both with { "name": "organizationRef" } ) use the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-about-url" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-about-url" class="externalDFN"> about URL , delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-property-url" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-property-url" class="externalDFN"> property URL and delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-value-url" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-value-url" class="externalDFN"> value URL annotations to assert the relationship between the post described by a given post insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn">row insert: </a> and the organization to which it belongs for the delete: <a title="cell" href="#dfn-cell" class="internalDFN">cells delete: </a>those delete: <a title="column" href="#dfn-column" class="internalDFN">columns delete: </a>. belongs.
Finally, note that two resources are created for each delete: <a href="#dfn-row" class="internalDFN">insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row within delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN">insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> 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">insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> column Cc8 ( { "name": "post_holder" } ) using the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-about-url" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-about-url" class="externalDFN"> about URL , delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-property-url" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-property-url" class="externalDFN"> property URL and delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-value-url" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-value-url" class="externalDFN"> value URL annotations. The person delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object provides the value of the name-value pair with corresponding delete: <a href="#dfn-name" class="internalDFN">insert: <a href="#dfn-name" class="internalDFN" data-link-type="dfn"> name org:heldBy , thus nesting the person delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object within the post delete: <a href="#dfn-object" class="internalDFN">insert: <a href="#dfn-object" class="internalDFN" data-link-type="dfn"> object .
delete: <a title="standard mode" href="#dfn-standard-mode" class="internalDFN">insert: <a href="#dfn-standard-mode" class="internalDFN" data-link-type="dfn"> Standard mode output for this example is provided below:
Example 23 : http://example.org/public-sector-roles-and-salaries-standard.json
At the time of publication, the following individuals had participated in the Working Group, in the order of their first name: Adam Retter, Alf Eaton, Anastasia Dimou, Andy Seaborne, Axel Polleres, Christopher Gutteridge, Dan Brickley, Davide Ceolin, Eric Stephan, Erik Mannens, Gregg Kellogg, Ivan Herman, Jeni Tennison, Jeremy Tandy, Jürgen Umbrich, Rufus Pollock, Stasinos Konstantopoulos, William Ingram, and Yakov Shafranovich.
Clarification of behaviour when creating JSON output from a row where multiple cells that share the same insert: <a href="#dfn-property-url" class="internalDFN" data-link-type="dfn">property URL insert: </a>annotation and contain lists of values. The JSON output will contain a name-value pair whose name is derived from the insert: <a href="#dfn-property-url" class="internalDFN" data-link-type="dfn">property URL insert: </a>annotation and whose value is a single array containing the values from all contributing cells. (See insert: <a href="https://github.com/w3c/csvw/issues/755">issue 755 insert: </a>) insert: </li>
insert: </ul>
insert: </section>
B.1 B.2 Changes since the working draft of 16 April 2015
The delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-column-name" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-name" class="externalDFN"> name annotation is URI decoded before used as a property.
A note has been added to the section on datatype making it clear that the new @id annotation in the model is ignored for JSON.
The section on generating JSON in standard mode has been amended to include the provision of delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-row-titles" class="externalDFN">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-row-titles" class="externalDFN"> row title annotation values.
The section on generating JSON has been amended to include a note on the fact that no Unicode normalization is applied on string values.
The table and title properties have been changed to tables and titles , respectively, to be consistent in the usage of plural forms.
B.2 B.3 Changes since the first public working draft of 08 January 2015
The document has undergone substantial changes since the first public working draft . Below are some of the changes made:
Removed the separate section on "Mapping Core Tabular Data" (to be in line with the latest version of the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/"> tabular model specification).
Reformulated the mappings in terms of table "annotations" (i.e., based on the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/"> tabular model ) rather than table "properties" (i.e., not based on the specificities of the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/"> metadata vocabulary ).
Provided a set of standard mappings from the general datatypes and the corresponding JSON types.
Jeremy Tandy; Ivan Herman; Gregg Kellogg. delete: <a href="http://www.w3.org/TR/2015/CR-csv2rdf-20150716/" property="dc:requires">insert: <a href="http://www.w3.org/TR/2015/PR-csv2rdf-20151117/" property="dc:requires"> Generating RDF from Tabular Data on the Web . W3C Working Draft. Proposed Recommendation. URL: delete: <a href="http://www.w3.org/TR/2015/CR-csv2rdf-20150716/" property="dc:requires">http://www.w3.org/TR/2015/CR-csv2rdf-20150716/ insert: <a href="http://www.w3.org/TR/2015/PR-csv2rdf-20151117/" property="dc:requires">http://www.w3.org/TR/2015/PR-csv2rdf-20151117/
Jeni Tennison; Gregg Kellogg. delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/" property="dc:requires">insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/" property="dc:requires"> Model for Tabular Data and Metadata on the Web . W3C Working Draft. Proposed Recommendation. URL: delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/" property="dc:requires">http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/ insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/" property="dc:requires">http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/