Methodology of association of cadastral and electrical information using GIS and SQL tools: Case study in Quito Ecuador

Main Article Content

Lisseth Jami
https://orcid.org/0000-0002-4203-7448
Catalina Vallejo
https://orcid.org/0000-0003-2065-0484
Francis Vásquez
https://orcid.org/0000-0002-8556-4838
Luis Condo
https://orcid.org/0000-0002-2649-8893
Luis Godoy
https://orcid.org/0000-0002-2878-5175

Abstract

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.

Downloads

Download data is not yet available.

Article Details

How to Cite
Jami, L., Vallejo, C., Vásquez, F., Condo, L., & Godoy, L. (2022). Methodology of association of cadastral and electrical information using GIS and SQL tools: Case study in Quito Ecuador. Revista Técnica "energía", 19(1), PP. 158–168. https://doi.org/10.37116/revistaenergia.v19.n1.2022.532
Section
TECNOLÓGICOS E INNOVACIÓN