Abstract
In order to ensure the safety of water use and the stability of enterprise production, water affairs experts need to analyze the water supply data in time and make timely decisions on abnormal conditions. However, experts are faced with great challenges in decision-making, because with the continuous development of Internet of things technology, the amount of water affairs data and the types of related data is increasing rapidly, which makes decision-making require many human resources and time. This situation prompted us to cooperate with experts and put forward a visualization system based on data analysis of urban water supply network system. There are three main challenges in developing such a system: (1) deep analysis of complex supply water data generated by the water supply network; (2) interactive generation of data comparison scheme; (3) effective methods for analyzing the abnormal causes. For challenge 1, we use customizable visual views from the whole to the details, which can customize and stratify the complex water structure system, so as to effectively explore the abnormal facilities and equipment. For challenge 2, we provide rich interaction methods to facilitate exploring water data according to users’ interests. For challenge 3, we introduce the strategy of influence degree parameter to help users analyze the influence degree of different factors on water affairs data, and help users find the causes of anomalies. Based on the actual business needs of the water supply industry and the data of the water supply network, we evaluated the WaterExcVA system through case studies, proved the applicability and practicability of the system, and communicated with water experts, obtaining positive feedback.
Graphical abstract

This is a preview of subscription content, access via your institution.















References
Abdullaev I, Rakhmatullaev S (2014) Data management for integrated water resources management in central asia. J Hydroinf 16(6):1425–1440. https://doi.org/10.2166/hydro.2014.097
Alves C, Cota MP, Castro M (2020) MLV-viewer: Data mining visualizations in decision support system. In: 2020 15th Iberian conference on information systems and technologies (CISTI). https://doi.org/10.23919/CISTI49556.2020.9140825
Anzaldi G, Rubion E, Corchero A et al (2014) Towards an enhanced knowledge-based decision support system (DSS) for integrated water resource management (IWRM). Procedia Eng 89:1097–1104. https://doi.org/10.1016/j.proeng.2014.11.230
Brehmer M, Ng J, Tate K et al (2015) Matches, mismatches, and methods: multiple-view workflows for energy portfolio analysis. IEEE Trans Visual Comput Graph 22(1):449–458. https://doi.org/10.1109/TVCG.2015.2466971
Bryan C, Ma KL, Woodring J (2017) Temporal summary images: an approach to narrative visualization via interactive annotation generation and placement. IEEE Trans Vis Comput Graph 23(1):511–520. https://doi.org/10.1109/TVCG.2016.2598876
Byska J, Muzic ML, Groller ME et al (2015) Animoaminominer: exploration of protein tunnels and their properties in molecular dynamics. IEEE Trans Visual Comput Graph 22(1):747–756. https://doi.org/10.1109/TVCG.2015.2467434
Cover TM, Hart PE (1953) Nearest neighbor pattern classification. IEEE Trans Inf Theory 13(1):21–27. https://doi.org/10.1109/TIT.1967.1053964
Cuenca E, Sallaberry A, Wang FY et al (2018) Multistream: a multiresolution streamgraph approach to explore hierarchical time series. IEEE Trans Visual Comput Graph. https://doi.org/10.1109/TVCG.2018.2796591
Dong W, Yang Q et al (2019) Data-driven solution for optimal pumping units scheduling of smart water conservancy. IEEE Internet Things J 7(3):1919–1926. https://doi.org/10.1109/JIOT.2019.2963250
Eichner C, Schumann H, Tominski C (2019) Making parameter dependencies of time—series segmentation visually understandable. Comput Graph Forum. https://doi.org/10.1111/cgf.13894
Gleicher M (2018) Considerations for visualizing comparison. IEEE Trans Visual Comput Graph 24(1):413. https://doi.org/10.1109/TVCG.2017.2744199
Han H, Oikonomou K, Chalapathi N, et al (2020) Interactive visualization of interdependent power and water infrastructure operation. In: 2020 IEEE power and energy society innovative smart grid technologies conference (ISGT). https://doi.org/10.1109/ISGT45199.2020.9087680
Jeurkar V, Inamdar M, Kale P et al (2020) IoT based water management system. In: 2020 international conference on industry 4.0 technology (I4Tech). https://doi.org/10.1109/I4Tech48345.2020.9102686
Ke X, Guo S, Nan C et al (2018) Ecglens: Interactive visual exploration of large scale ECG data for arrhythmia detection. In: Chi conference. https://doi.org/10.1145/3173574.3174237
Li J, Chen S, Zhang K et al (2019) Cope: Interactive exploration of co-occurrence patterns in spatial time series. IEEE Trans Visual Comput Graph 25(8):2554–2567. https://doi.org/10.1109/TVCG.2018.2851227
Lim H, Kim W, Jung J (2018) Integrated water cycle management system for smart cities. In: 2018 2nd international conference on green energy and applications (ICGEA). https://doi.org/10.1109/ICGEA.2018.8356311
Liu C, Li Y, Yang C et al (2020) Event-based exploration and comparison on time-varying ensembles. J Visual 23(1):111–123
Lu Q, Chai B, Zhang H (2017) Evaluation on visualization methods of dynamic collaborative relationships for project management. Vis Comput 33(46):1–12. https://doi.org/10.1007/s00371-017-1409-2
Lu Q, Xu W, Zhang H et al (2020) Electricvis: visual analysis system for power supply data of smart city. J Supercomput 76(2):793–813. https://doi.org/10.1007/s11227-019-02924-4
Morrow B, Manz T, Chung AE, et al (2019) Periphery plots for contextualizing heterogeneous time-based charts. In: 2019 IEEE visualization conference (VIS), pp 1–5. https://doi.org/10.1109/VISUAL.2019.8933582
Pablo J, Pajigal CJ, Palileo C et al (2020) Developing a web-based water incident management system with decision support. In: 2020 IEEE 7th international conference on industrial engineering and applications (ICIEA). https://doi.org/10.1109/ICIEA49774.2020.9101965
Page A, Soyata T, Couderc JP et al (2017) An open source ECG clock generator for visualization of long-term cardiac monitoring data. IEEE Access 3:2704–2714. https://doi.org/10.1109/ACCESS.2015.2509426
Pincus SM (1991) Approximate entropy as a measure of system complexity. Proc Natl Acad Sci USA 88(6):2297–2301. https://doi.org/10.1073/pnas.88.6.2297
Qiu Y, Xie H, Sun J, et al (2019) A novel spatiotemporal data model for river water quality visualization and analysis. IEEE Access 7:155,455–155,461. https://doi.org/10.1109/ACCESS.2019.2949034
Ren D, Amershi S, Lee B et al (2016) Squares: supporting interactive performance analysis for multiclass classifiers. IEEE Trans Visual Comput Graph 23(1):61–70. https://doi.org/10.1109/TVCG.2016.2598828
Ryan G, Mosca A, Chang R et al (2018) At a glance: pixel approximate entropy as a measure of line chart complexity. IEEE Trans Visual Comput Graph 25(1):872–881. https://doi.org/10.1109/TVCG.2018.2865264
Skoulikaris C, Filali-Meknassi Y, Aureli A et al (2018) Information-communication technologies as an integrated water resources management (IWRM) tool for sustainable development. Achiev Challenges Integrated River Basin Manag. https://doi.org/10.5772/intechopen.74700
Tang H, Wei S, Zhou Z et al (2019) Treeroses: outlier-centric monitoring and analysis of periodic time series data. J Visual 22(5):1005–1019
Walker J, Borgo R, Jones MW (2016) Timenotes: a study on effective chart visualization and interaction techniques for time-series data. IEEE Trans Visual Comput Graph. https://doi.org/10.1109/TVCG.2015.2467751
Wang Y, Yu M, Shan G et al (2019) Vispubcompas: a comparative analytical system for visualization publication data. J Visual. https://doi.org/10.1007/s12650-019-00585-2
Wu Y, Pitipornvivat N, Zhao J et al (2015) egoslider: Visual analysis of egocentric network evolution. IEEE Trans Visual Comput Graph 22(1):260–269. https://doi.org/10.1109/TVCG.2015.2468151
Wu Y, Chen Z, Sun G et al (2018) Streamexplorer: a multi-stage system for visually exploring events in social streams. IEEE Trans Visual Comput Graph 24(10):2758–2772. https://doi.org/10.1109/TVCG.2017.2764459
Xiong F, Wang Q, Du Z, et al (2019) Reconstruction of historical data and analysis on three-dimensional tourism climate resources in fanjing mountain scenic spot. In: 2019 international conference on meteorology observations (ICMO). https://doi.org/10.1109/ICMO49322.2019.9025961
Xu K, Wang Y, Yang L et al (2020) Clouddet: Interactive visual analysis of anomalous performances in cloud computing systems. IEEE Trans Visual Comput Graph 26(1):1107–1117. https://doi.org/10.1109/TVCG.2019.2934613
Yue X, Bai J, Liu Q et al (2019) sportfolio: Stratified visual analysis of stock portfolios. IEEE Trans Visual Comput Graph 26(1):601–610. https://doi.org/10.1109/TVCG.2019.2934660
Zecchini M, Griesi AA, Chatzigiannakis I, et al (2021) Identifying water consumption patterns in education buildings before, during and after Covid-19 lockdown periods. In: 2021 IEEE international conference on smart computing (SMARTCOMP). IEEE, pp 335–340
Zhang J, Wei C (2018) The problems and optimal countermeasures of water resources supply and demand in Jilin city. In: International conference on engineering simulation and intelligent control. https://doi.org/10.1109/ESAIC.2018.00103
Zhang Y, Kartik C, Cody D (2018) Idmvis: Temporal event sequence visualization for type 1 diabetes treatment decision support. IEEE Trans Visual Comput Graph 25(1):512–522. https://doi.org/10.1109/TVCG.2018.2865076
Zhao X, Wu Y, Cui W et al (2018) Skylens: Visual analysis of skyline on multi-dimensional data. IEEE Trans Visual Comput Graph 24(1):246–255. https://doi.org/10.1109/TVCG.2017.2744738
Zhou Y, Jiang R, Qin H, et al (2022) Representation and analysis of time-series data via deep embedding and visual exploration. J Visual 1–18
Zuloaga S, Khatavkar P, Vittal V et al (2019) Interdependent electric and water infrastructure modeling, optimization and control. IET Energy Syst Integr. https://doi.org/10.1049/iet-esi.2019.0039
Acknowledgements
This work was supported in part by Provincial Key Research and Development Program of Anhui of China (201904d07020010), the Science and Technology Program of Huangshan of China (2019KN-05), the Anhui Key Laboratory of Intelligent Building and Building Energy Conservation of Anhui Jianzhu University (IBES2021KF05), and the Scientific and Technological Achievement Cultivation Project of Intelligent Manufacturing Research Institute of Hefei University of Technology (IMIPY2021022).
Author information
Authors and Affiliations
Corresponding author
Ethics declarations
Conflict of interest
The authors declare that they have no known competing financial interests or personal relationships that could have appeared to influence the work reported in this paper.
Ethics approval
This study does not contain any studies with Human or animal subjects performed by any of the authors.
Additional information
Publisher's Note
Springer Nature remains neutral with regard to jurisdictional claims in published maps and institutional affiliations.
Rights and permissions
Springer Nature or its licensor (e.g. a society or other partner) holds exclusive rights to this article under a publishing agreement with the author(s) or other rightsholder(s); author self-archiving of the accepted manuscript version of this article is solely governed by the terms of such publishing agreement and applicable law.
About this article
Cite this article
Lu, Q., Ge, Y., Rao, J. et al. WaterExcVA: a system for exploring and visualizing data exception in urban water supply. J Vis (2023). https://doi.org/10.1007/s12650-023-00911-9
Received:
Revised:
Accepted:
Published:
DOI: https://doi.org/10.1007/s12650-023-00911-9
Keywords
- Visual analysis
- Graphic design
- Intelligent water affairs
- Visualization