Introduction
The following dashboard is designed to demonstrate the queries that answer the competency questions to validate the ontology and linked data sources for people and departments within the University of Twente (UT). Concretely, this data source is made up of 6 different datasets from across the UT, including:
- UT departments and sections associated with particular buildings from peoplepagesopenapi
- Areas of expertise for each employee based on their HTML profile pages, for example
- Building names and addresses in excel format,
- Building coordinates from buildings API
- Building occupancy based on the CampusCrowd Map
The underlying ontology which supports the linking of these data sources can be explored as a live graphical representation here.
The following SPARQL queries serve to show the results for the competency questions regarding UT people and their expertise, organisations (departments and sections), buildings and their occupancy. The underlying question being answered and the exact content of each query is defined below. First the competency questions regarding buildings are answered. Secondly, the competency questions about persons are answered. Lastly, the competency questions about organisations are answered.
Competency Question 1: What is the name and address of a given building?
Competency Question 2: What is the location and geomtery of a building?
Competency Question 3: What rooms are located within a building?
Competency Question 4: Which organisations (departments/sections) are located in a given building?
Competency Question 5: What is the occupancy rate of a given building for a given time period?
Competency Question 6: What is the contact information for a given persion?
Competency Question 7: For a given person, which building and room are they located in?
Competency Question 8: For a given person, which areas of expertise do they have?
Competency Question 9: For a given person, which department/section do they belong to?
Competency Question 10: What is the name of an organisation (department/section)?
Competency Question 11: For a given department, what people are part of that department?
Competency Question 12: What areas of expertise are associated with a given organisation/department/section?
Three queries are shown for organisation, department, and section, respectively.
Remark: for the organisation query it is not possible to query a specific organisation name because we had to use the STRAFTER function to get the organisation name from the URI.