Demo6 Diagrams - statnett/Talk2PowerSystem GitHub Wiki
Table of Contents
- Q6.1 Diagram Kinds
- Q6.2 cim:Diagram vs cimd:Diagram
- Q6.3 Interactivity
- Q6.4 Area Diagrams Count
- Q6.5 Area Diagrams
- Q6.6 Count Diagrams
- Q6.7 List Diagrams
- Q6.8 List Diagrams of ARENDAL
- Q6.9 SLD of ARENDAL
- Q6.10 SLD of ARENDAL and another substation
- Q6.11 VizGraph of Arendal
- Q6.12 Diagram Configurations
- Q6.13 Class Diagram
- Q6.14 VizGraph of Substations and Lines
- Q6.15 VizGraph of Selected Substation and its Lines
- Q6.16 Diagrams of HVDC Substations
- Q6.17 Diagrams of 135 kV substations
Q6.1 Diagram Kinds
- What diagrams can you display?
- What is the difference between NAD and SLD?
- Compare a network area diagram to a single-line diagram
No SPARQL needed since that is in the cimd ontology
Q6.2 cim:Diagram vs cimd:Diagram
- Are there diagrams that you cannot display?
- Which are the diagrams that you cannot display?
- What is the difference between
cimdiagrams andcimddiagrams? - What is the
cimdontology?
No SPARQL needed since that is in the cimd ontology vs cim:Diagram class
(there is a pragmatics that the bot follows closely)
Q6.3 Interactivity
- Which predefined diagrams can be explored interactively by clicking on an element?
Show a list with kind, name, description
- TODO: we need to add a flag
DiagramKind.isClickable, see https://github.com/statnett/Talk2PowerSystem_PM/issues/308
- TODO: we need to add a flag
select * {
?d a cimd:Diagram; cim:IdentifiedObject.name ?name; cim:IdentifiedObject.description ?descr; cimd:Diagram.kind ?kind.
?kind DiagramKind.isClickable true
}
Q6.4 Area Diagrams Count
- What kinds of electrical areas can you show on a diagram, and how many do you have per kind of area?
- There are diagrams about NO1 SGR but also NO1 SLA and NO LA
select ?areaType (count(*) as ?c) {
values ?areaType {cim:SubGeographicalRegion cim:LoadArea cim:SubLoadArea}
?x a cimd:Diagram; cimd:Diagram.PowerSystemResource ?area.
?area a ?areaType
} group by ?areaType
Q6.5 Area Diagrams
- Which sub-load areas can you show? Show the first one in alphabetic order by area name
select * {
?x a cimd:Diagram; cimd:Diagram.PowerSystemResource ?area; cim:IdentifiedObject.name ?name; cim:IdentifiedObject.description ?descr.
?area a cim:SubLoadArea; cim:IdentifiedObject.name ?areaName
} order by ?areaName
Q6.6 Count Diagrams
- Give me a count of predefined diagrams per rdf:type and kind
PREFIX cim: <https://cim.ucaiug.io/ns#>
PREFIX cimd: <https://cim.ucaiug.io/diagrams#>
select ?type ?kind (count(*) as ?c) {
values ?type {cim:Diagram cimd:Diagram}
?d a ?type
optional {?d cimd:Diagram.kind ?kind}
} group by ?type ?kind
Q6.7 List Diagrams
- List all diagrams, with name, description, type, kind, and whether they can be visualized
PREFIX cim: <https://cim.ucaiug.io/ns#>
PREFIX cimd: <https://cim.ucaiug.io/diagrams#>
select * {
values ?type {cim:Diagram cimd:Diagram}
?d a ?type; cim:IdentifiedObject.name ?name
optional {?d cim:IdentifiedObject.description ?descr}
optional {?d cimd:Diagram.kind ?kind}
bind(?type=cimd:Diagram as ?canDisplay)
}
Q6.8 List Diagrams of ARENDAL
- What diagrams do yo have of ARENDAL?
Q6.9 SLD of ARENDAL
- Show a SLD diagram of ARENDAL
Q6.10 SLD of ARENDAL and another substation
- What diagrams cover ARENDAL, and a second neighboring substation? Show the first of these diagrams
Q6.11 VizGraph of Arendal
- Show RDF graph depicting ARENDAL and all its related PSRs
Q6.12 Diagram Configurations
- What diagram configurations are there?
- Which diagram configurations can be used to display substations?
- Which configurations can be used to display classes?
Q6.13 Class Diagram
- Display the subclasses of class Switch, all their relations, and the related classes
Q6.14 VizGraph of Substations and Lines
- Show an RDF graph of some substations and lines with links between them, but no other PSRs
Q6.15 VizGraph of Selected Substation and its Lines
- Show a visual graph of ARENDAL substation and connected lines, but no other PSRs
Q6.16 Diagrams of HVDC Substations
- What diagrams show HVDC substations? List them with name, description and kind
Q6.17 Diagrams of 135 kV substations
- What diagrams show substations with a voltage level of 135 kV?
PREFIX cimd: <https://cim.ucaiug.io/diagrams#>
PREFIX cim: <https://cim.ucaiug.io/ns#>
select * {
?sub cim:Substation.VoltageLevels/cim:VoltageLevel.BaseVoltage/cim:BaseVoltage.nominalVoltage ?v;
cim:IdentifiedObject.name ?substation
filter(?v=135)
?d cimd:Diagram.PowerSystemResource ?sub;
cim:IdentifiedObject.name ?diagram
}