Enhancing Urban Water Management: A Novel LoraWAN Platform Based on ChirpStack Integration with Node-Red for Efficient Data Hosting on the Google Cloud Platform

The Internet of Things has become an approach to facilitate real-time data collection and examination in various fields, such as urban water management. This paper presents a pioneering LoraWAN platform, which leverages the integration of ChirpStack with Node-Red and SQL databases to establish a robust and scalable urban water monitoring system. Specifically, Ecuador's cities need help managing urban water consumption due to today's traditional systems. The proposed solution is to implement an SWG Cuenca platform to manage urban water consumption based on the design of an informatic platform to manage urban water smart meters. The platform utilises Google Cloud Platform, which provides scalability and security features for the LoRaWAN network, long-short-term memory to predict urban water consumption, and Node-Red to develop the BackEnd and FrontEnd dashboards. The platform developed is also considered a Semantic Sensor Network Ontology. The conclusion is that improved urban water resource management, proactive decision-making, and increased operational efficiency for urban water utilities are necessary. Regarding urban water prediction, long- and short-term memory performance metrics showed a value of 94.3% for the correlation coefficient with a root mean square error value of 0.22. Finally, the SGW-CUENCA platform supports the operation from the final devices to the management of the LoraWAN network, such as gateways and smart urban water meters.