Implementación de un prototipo de sistema electrónico para la administración de canchas sintéticas municipales de la ciudad de Riobamba.

Abstract

In this titling work, a prototype of an electronic system was implemented for the administration of municipal synthetic fields of the city of Riobamba, which is made up of four modules. The first one, for communication, which structures a hierarchical network under the IEEE 802.11 protocol, and establishes a connection to remote servers through the internet. The second, of automatic access, which employs a quick response code in the access, and verifies the eviction using digital image processing. The third refers to the lighting control, which dims the light considering the occupation of the field. The fourth, an electronic scoreboard, which manages reservation schedules, with automatic timer settings and goal counting through the application. In addition, it incorporates a database hosted in the cloud that connects with the mobile application to allow the user to book, and a desktop application that allows you to show hours of availability of the courts and alerts. Performance tests were performed, which allowed determining the maximum wireless connection distance of the modules at 34.7m. In tests of transmission of 200 datagrams between the database with the applications and the communication module, and between the modules of the network, an efficiency of 100% and 97% was obtained. The system is capable of storing data concerning the current demand of 13 courts, with the limitation of 100 simultaneous connections and 10GB per month in data download. It is concluded that the prototype allows an administration of municipal sports spaces, recording data for statistical use and speeding up the reservation process. For future projects it is recommended to incorporate artificial vision systems to improve the detection of objects on the field.