prefix class: prefix dct: prefix measure: prefix owl: prefix property: prefix rdf: prefix rdfs: prefix xsd: select ?widget { { # Cardinal sample characteristic ?property a owl:DatatypeProperty; dct:description ?description; rdfs:domain class:Observation; rdfs:label ?characteristic; rdfs:range ?range. filter(?range in (xsd:double, xsd:gYear, xsd:integer)) { select ?property (str(min(?valueD)) as ?minD) (str(avg(?valueD)) as ?avgD) (str(max(?valueD)) as ?maxD) (str(count(distinct ?valueD)) as ?valuesD0) (str(count(distinct ?effectD)) as ?effectsD) (str(min(?valueR)) as ?minR) (str(avg(?valueR)) as ?avgR) (str(max(?valueR)) as ?maxR) (str(count(distinct ?valueR)) as ?valuesR0) (str(count(distinct ?effectR)) as ?effectsR) { { ?effectD ?property ?valueD; property:eSmeasure measure:d. ?property rdfs:label ?characteristic. } union { ?effectR ?property ?valueR; property:eSmeasure measure:r. ?property rdfs:label ?characteristic. } } } bind('Cardinal' as ?type) bind(concat( '

№ unique values:

',replace(?valuesD0,'[0-9](?=(?:[0-9]{3})+(?![0-9]))','$0,'),'

', '

Minimum:

',concat(replace(if(strbefore(?minD,'.')='',?minD,strbefore(?minD,'.')),'[0-9](?=(?:[0-9]{3})+(?![0-9]))','$0,'),if(strbefore(?minD,'.')='','',concat('.',if(strlen(strafter(?minD,'.'))<=2,strafter(?minD,'.'),substr(strafter(?minD,'.'),1,2))))),'

', '

Average:

',concat(replace(if(strbefore(?avgD,'.')='',?avgD,strbefore(?avgD,'.')),'[0-9](?=(?:[0-9]{3})+(?![0-9]))','$0,'),if(strbefore(?avgD,'.')='','',concat('.',if(strlen(strafter(?avgD,'.'))<=2,strafter(?avgD,'.'),substr(strafter(?avgD,'.'),1,2))))),'

', '

Maximum:

',concat(replace(if(strbefore(?maxD,'.')='',?maxD,strbefore(?maxD,'.')),'[0-9](?=(?:[0-9]{3})+(?![0-9]))','$0,'),if(strbefore(?maxD,'.')='','',concat('.',if(strlen(strafter(?maxD,'.'))<=2,strafter(?maxD,'.'),substr(strafter(?maxD,'.'),1,2))))),'

') as ?valuesD) bind(concat( '

№ unique values:

',replace(?valuesR0,'[0-9](?=(?:[0-9]{3})+(?![0-9]))','$0,'),'

', '

Minimum:

',concat(replace(if(strbefore(?minR,'.')='',?minR,strbefore(?minR,'.')),'[0-9](?=(?:[0-9]{3})+(?![0-9]))','$0,'),if(strbefore(?minR,'.')='','',concat('.',if(strlen(strafter(?minR,'.'))<=2,strafter(?minR,'.'),substr(strafter(?minR,'.'),1,2))))),'

', '

Average:

',concat(replace(if(strbefore(?avgR,'.')='',?avgR,strbefore(?avgR,'.')),'[0-9](?=(?:[0-9]{3})+(?![0-9]))','$0,'),if(strbefore(?avgR,'.')='','',concat('.',if(strlen(strafter(?avgR,'.'))<=2,strafter(?avgR,'.'),substr(strafter(?avgR,'.'),1,2))))),'

', '

Maximum:

',concat(replace(if(strbefore(?maxR,'.')='',?maxR,strbefore(?maxR,'.')),'[0-9](?=(?:[0-9]{3})+(?![0-9]))','$0,'),if(strbefore(?maxR,'.')='','',concat('.',if(strlen(strafter(?maxR,'.'))<=2,strafter(?maxR,'.'),substr(strafter(?maxR,'.'),1,2))))),'

') as ?valuesR) } union { # Nominal sample characteristic { ?property a owl:DatatypeProperty; dct:description ?description; rdfs:domain class:Observation; rdfs:label ?characteristic; rdfs:range xsd:boolean. } union { ?property a owl:ObjectProperty; dct:description ?description; rdfs:domain class:Observation; rdfs:label ?characteristic. } { select ?property (str(sum(?effectsD0)) as ?effectsD) (str(sum(?effectsR0)) as ?effectsR) (group_concat(concat('

',str(?valueHtml),':

',replace(str(?effectsD0),'[0-9](?=(?:[0-9]{3})+(?![0-9]))','$0,'),' effects

');separator='') as ?valuesD) (group_concat(concat('

',str(?valueHtml),':

',replace(str(?effectsR0),'[0-9](?=(?:[0-9]{3})+(?![0-9]))','$0,'),' effects

');separator='') as ?valuesR) { # ?valueLabel is only exposed for ordering the results. select ?property ?valueHtml ?valueLabel (count(?effectD) as ?effectsD0) (count(?effectR) as ?effectsR0) { ?property rdfs:label ?characteristic. { # Object property values { ?effectD ?property ?value; property:eSmeasure measure:d. } union { ?effectR ?property ?value; property:eSmeasure measure:r. } ?value rdfs:label ?valueLabel. bind(concat('',str(?valueLabel),'') as ?valueHtml) } union { # Boolean datatype property values { ?effectD ?property ?value; property:eSmeasure measure:d. } union { ?effectR ?property ?value; property:eSmeasure measure:r. } filter not exists { ?value rdfs:label []. } bind(str(?value) as ?valueHtml) bind(str(?value) as ?valueLabel) } } order by ?valueLabel } } bind('Nominal' as ?type) } bind(strdt(concat( '

',ucase(substr(str(?characteristic),1,1)),substr(str(?characteristic),2),' (',str(?type),')

', '

',str(?description),'

', '

Values

', '

D

', '

№ effects:: ',replace(?effectsD,'[0-9](?=(?:[0-9]{3})+(?![0-9]))','$0,'),'

', '

R

', '

№ effects:: ',replace(?effectsR,'[0-9](?=(?:[0-9]{3})+(?![0-9]))','$0,'),'

'),rdf:HTML) as ?widget) }

Documentation

Triply