prefix class: prefix dct: prefix owl: prefix property: prefix rdf: prefix rdfs: prefix xsd: select ?widget { # Cardinal study characteristics { ?property a owl:DatatypeProperty; dct:description ?description; rdfs:domain class:Study; rdfs:label ?label. # The specific cardinal study chracteristics that are selected. filter(?property in (property:meanAge, property:maleProportion)) { select ?property (str(min(?value)) as ?min) (str(avg(?value)) as ?avg) (str(max(?value)) as ?max) (str(count(distinct ?value)) as ?values0) (str(count(distinct ?study)) as ?studies) { ?study ?property ?value. } } bind('Cardinal' as ?type) bind(concat( '

№ unique values:

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

', '

Minimum:

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

', '

Average:

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

', '

Maximum:

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

') as ?values) } union { # Cardinal range study characteristic ?property a owl:DatatypeProperty; dct:description ?description; rdfs:domain class:Study; rdfs:label ?label. # The specific cardinal range study chracteristics that are selected. # The use of bind i.o. filter-in is due to a Virtuoso-specific bug. bind(property:ageRange as ?property) { select ?property (str(min(?low)) as ?lowMin) (str(avg(?low)) as ?lowAvg) (str(max(?low)) as ?lowMax) (str(min(?high)) as ?highMin) (str(avg(?high)) as ?highAvg) (str(max(?high)) as ?highMax) (str(count(distinct ?study)) as ?studies) { ?study ?property [ property:lowerInclusive ?low; property:higherInclusive ?high ]. } } bind('Cardinal range' as ?type) bind(concat( '

Lowest value:

', '

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

', '

Highest value:

', '

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

', '

') as ?values) } union { # Nominal study characteristics ?property dct:description ?description; rdfs:domain class:Study; rdfs:label ?label. # The specific nominal study chracteristics that are selected. filter(?property in (property:recruitmentMethod, property:studyAcademicDiscipline, property:studyStudentSample)) { select ?property (group_concat(concat('

',?valueHtml,':

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

');separator='') as ?values) (sum(?studies) as ?studies) { select ?property ?valueHtml ?valueLabel (count(?study) as ?studies) { { ?study ?property ?value. ?value rdfs:label ?valueLabel. bind(concat('',str(?valueLabel),'') as ?valueHtml) } union { ?study ?property ?value. 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(?label),1,1)),substr(str(?label),2),'

', '

',str(?description),'

', '

Properties

', '

Type:: ',str(?type),'
№ studies:: ',replace(?studies,'[0-9](?=(?:[0-9]{3})+(?![0-9]))','$0,'),'

', '

Values

', '

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

study-characteristics-overview-selection

API

Variables