Desarrollo de un sistema de geolocalización y cálculos de redes eléctricas basado en Google Maps. Caso práctico LYREC (Líneas y Redes Eléctricas del Centro).

Abstract

The objective of the present degree work was to develop an informatic system for the Geo-location and Electric Network calculus based on Google Maps for the enterprise LYREC of the city of Riobamba. SQL Server 2008 R2 as Data Base Manager, ASP.NET, Entity Framework, LinQ, and Boostrap for the codification the IIS system as web server and API Google Maps as tool of location and visualization of electric networks were used as development tools. This system of Geo-location controls the entrance of authorized users, manages electric networks, such as: structures, meters, conductors, materials, poles, among others; it locates an electric pole and shows its characteristics, determines distances from one pole to another to calculate voltage drops among nodes. For the development of the system the agile methodology of development SCRUM was used, this allowed to organize the development form, to plan the records of user required and estimate each of them, according to the difficulty level of every user record. Eight technical records were determined and 19 user records, all of them were analyzed with engineering task and acceptance tests. To verify the implementing impact of the system was evaluated eight main factors have improved their percentages, figuring out that the factor mostly optimized has been the data flow within the departments in the Enterprise since before the study, it had a valuation of 10.2% and afterwards a valuation of 17%, by obtaining a difference of 6.8% in optimizing at the moment of using the application, the factor that at least has improved is of the necessary resources to make the calculus of voltage drop, the same that had previously, a valuation of 11.5% and later a valuation of 7% by obtaining a difference of 4.5% in non-optimized resources by using the application. Finally, it is concluded that were optimized resources, tasks, staff, and processes to collect the information that formerly obtained a value of 71.7% and subsequently a value of 80% by obtaining a difference of 8.3% in Project improvements. It is recommended to use the system in the Enterprise LYREC, in addition to this optimizes the information collection of electric networks.