Using column templates
Column templates are pre-configured column definitions which speed up creating linked data.
This page aims to introduce column template functionality, show you how to make use of it in a qube-config.json configuration file and list common templates you might wish to use yourself.
How to use templates
To use a column template in the qube-config.json configuration file set the
from_template property on the
column definition to one the available templates, for example with a column representing year:
Overriding template configuration
It is possible to override the configuration inherited from the template; do this by manually specifying individual properties you wish to override within the column definition, e.g. with a column representing year:
In the above example, we have reused the
year template, but given the dimension created the label of
The templates are currently in version 1.0; with future development planned. You can see the entire list of the templates inline below or on csvcubed GitHub. The
from_template functionality fetches the most recent version of our templates from the web.
Date/Time period template
|The calendar period of year
|The calendar period of half-year (January-June, July-December)
|The calendar period of quarter (January-March, April-June, July-September, October-December)
|The calendar period of month
|The ISO-8601 definition of calendar week
|The calendar period of day
|The calendar period of hour
|The calendar period of minute
|The calendar period of second
|The UK Government calendar period of year starting in April
|The UK Government calendar period of half-year starting in April (April-September, October-March)
|The UK Government calendar period of quarter starting in April (April-June, July-September, October-December, January-March)
|The UK Government calendar period of week as defined at reference.data.gov.uk.
|Template allows the definition of mixed time periods within a single dimension, e.g.
Date/Time instant/interval templates
|The gregorian-instant expressed in ISO-8601 format
|The gregorian-interval expressed in ISO-8601 format
Geographical area templates
|ONS Geography codes for statistical geographies
|A template which describes the status of the observed value
Units used, have to match the terminal part of the URI exactly including case sensitivity.
|A template which contains units of measurement