Methodology of association of cadastral and electrical information using GIS and SQL tools: Case study in Quito Ecuador
Metodología de asociación de información catastral y eléctrica mediante herramientas SIG y SQL: Caso de estudio Quito, Ecuador
How to Cite
Download Citation
Show authors biography
Similar Articles
- Graciela Colomé, Omar Ramos, Diego Echeverría, Identification Methodology of Oscillatory Modes in PMU Measurement Ambient Type Data , Revista Técnica "energía": Vol. 21 No. 1 (2024): Revista Técnica "energía", Edición No. 21, ISSUE I
- Alex Mullo, José Reinoso, Marlon Chamba, Carlos Lozada, Analysis and Characterization of Power Quality using Data Mining , Revista Técnica "energía": Vol. 22 No. 1 (2025): Revista Técnica "energía", Edición No. 22, ISSUE I
- Paulo Castro, Jaime Cepeda, Impact Analysis of Non-Dispatchable Renewable Energies Penetration in Power System Operational Security , Revista Técnica "energía": Vol. 22 No. 1 (2025): Revista Técnica "energía", Edición No. 22, ISSUE I
- Alex Villamarín Jácome, Miguel Saltos, Juan Echever, Optimal Sizing of Photovoltaic and Battery Energy Systems in Residential Environments to Reduce Dependence on Centralized Electricity Infrastructure , Revista Técnica "energía": Vol. 21 No. 2 (2025): Revista Técnica "energía", Edición No. 21, ISSUE II
- Wilson Pavón, Sandra Gualotuña, Droop control strategy for an isolated micro grid with distributed generation coupled to improve voltage stability , Revista Técnica "energía": Vol. 20 No. 2 (2024): Revista Técnica "energía", Edición No. 20, ISSUE II
- Luis Cruz, Cristian Gallardo, Optimization of Solar Capture Using a Dual-Axis Tracker Based on an Astronomical Algorithm in a Small-Scale Photovoltaic Station , Revista Técnica "energía": Vol. 22 No. 1 (2025): Revista Técnica "energía", Edición No. 22, ISSUE I
- Edison Novoa, Gabriel Salazar Yépez, Eliana Buitrón, Gabriel Salazar Pérez, Methodological Proposal for Targeting Electric Subsidy "Tarifa De La Dignidad" in Residential Users of the Electric Companies of Ecuador , Revista Técnica "energía": Vol. 20 No. 1 (2023): Revista Técnica "energía", Edición No. 20, ISSUE I
- Jorge Lara, Mauricio Samper, Graciela Colomé, Short-Term Prediction of Smart Metering Systems by Multivariable and Multistep Deep Learning Architectures , Revista Técnica "energía": Vol. 21 No. 1 (2024): Revista Técnica "energía", Edición No. 21, ISSUE I
- Gabriela Araujo, Andrés Robalino, Energy Subsidies and Urban Consumption in Ecuador: Distortions and Pathways for Transition , Revista Técnica "energía": Vol. 22 No. 2 (2026): Revista Técnica "energía", Edición No. 22 ISSUE II
- Daniel Orbe, Luis Salazar, Paúl Vásquez, Estimation and Sensitivity Analysis of Electric Buses Energy Consumption through Microscopic Simulations on Public Transport Lines , Revista Técnica "energía": Vol. 21 No. 1 (2024): Revista Técnica "energía", Edición No. 21, ISSUE I
You may also start an advanced similarity search for this article.
Most read articles by the same author(s)
- Catalina Vallejo, Luis Godoy, Francis Vásquez, Geovanna Villacreses, Marco Orozco, Santiago Navarro, Strategies for Enhancing Energy Efficiency in Public Service Buildings within a Hot and Humid Climatic Zone: A Case Study in Guayaquil, Ecuador , Revista Técnica "energía": Vol. 21 No. 1 (2024): Revista Técnica "energía", Edición No. 21, ISSUE I
- Francis Vásquez, Carlos Naranjo, Andrea Lobato, Evaluation of the effect of meteorological variables on the thermal performance of a residential building based on monitored data , Revista Técnica "energía": Vol. 19 No. 1 (2022): Revista Técnica "energía", Edición No. 19, ISSUE I
This study develops a methodology for the unification of electricity and cadastral data through the combined application of GIS and SQL tools. The main spatial joining techniques used are: spatial intersection, entity joining by attributes, and proximity analysis. In addition, mainly SQL algorithms for data comparison and selection were applied. As a case study, we used cadastral and electricity information of the customers regulated by Empresa Eléctrica Quito (EEQ) within the urban area of Quito. It was possible to join 25% of the total data. Furthermore, it was found that the spatial distribution of the unified data is homogeneous within the study area, and is quantitatively representative in most of the areas. Finally, the results were checked by means of an on-site validation, thus verifying the validity of the proposed methodology. According to the results obtained, the joining methodology presented in this study can be replicated in other areas with similar characteristics to the data used, thus obtaining an important input for the definition of energy indicators for energy qualification, comparison, or categorization of buildings.
Article visits 1389 | PDF visits 467














