presentation title: using sqls for model audits in ... › 2018 › 07 ›...
TRANSCRIPT
![Page 1: Presentation Title: Using SQLs for Model Audits in ... › 2018 › 07 › 2018-synopsis-v2-paper-10.pdfSR depth and volume tables etc. Or running a valve diameter check against the](https://reader034.vdocuments.us/reader034/viewer/2022042407/5f21262e43d4473e5701ef62/html5/thumbnails/1.jpg)
‘Putting the Customer First’
Paper 10 Synopsis
Presentation Title: Using SQLs for Model Audits in InfoWorks
WS Pro
Presenter: Duncan Allen (Scottish Water)
As hydraulic modellers we do not always find ourselves in direct contact with the customers, indeed
from a consultant point the ‘customer’ is often the water company and from the water company point
of view the ‘customer’ is often other teams within the water company that we provide the required
support for etc.
However, what we output from the models can potentially have significant impacts and implications
for customers, therefore Scottish Water think that having high quality models, ensuring that they
adhere to the model specifications provided by the water company etc. is important and that model
audits help ensure that the customer is being put first.
In order to try and speed up the process of auditing the models built for SW (both internally and
externally) Scottish Water has developed a number of SQL queries which have been combined into a
single large SQL to simplify a large number of the audit checks. Although generally specific to the
Scottish Water Model Specifications and InfoWorks WS, the general approach could be beneficial to
others.
One of the advantages is that we no longer tend to check a random selection of items but can usually
check 100% of items (e.g. running an SQL against a shape file to check that all valve asset IDs have
![Page 2: Presentation Title: Using SQLs for Model Audits in ... › 2018 › 07 › 2018-synopsis-v2-paper-10.pdfSR depth and volume tables etc. Or running a valve diameter check against the](https://reader034.vdocuments.us/reader034/viewer/2022042407/5f21262e43d4473e5701ef62/html5/thumbnails/2.jpg)
‘Putting the Customer First’
been correctly imported). Other benefits noted have included being able to create grid views with
field not typically shown (acknowledge there may be other ways of doing this that we are not aware
of) e.g. creating a grid view of all nodes with something on the notes tab or information regarding the
SR depth and volume tables etc.
Or running a valve diameter check against the pipe diameters upstream and downstream to within a
specified tolerance (below example all >25mm).
Although still under development a decision was made to pass these audit SQLs out to our supplying
consultants to allow them to run the checks themselves and hopefully speed up audit checks etc.
minimising the errors that we pick up etc.
Although perhaps not the most exciting of topics, one of the things that we have discovered at Scottish
Water is the overall flexibility of using SQLs expanding out significantly what we are able to do within
InfoWorks WS.