Development of a business intelligence solution to integrate census and survey data in GIS

Authors

  • R Cornejo Universidad de Tarapacá
  • M Navarrete Universidad de Tarapacá.
  • R Valdivia Universidad de Tarapacá
  • P Aroca Universidad Adolfo Ibáñez
  • S Aracena Universidad de Tarapacá.

DOI:

https://doi.org/10.5377/ce.v8i2.2083

Keywords:

Spatial Matching, Spatial Data Base, Business Intelligence Solution, Geographic Information System

Abstract

In this paper we present the development of a Business Intelligence solution to manage the large volume of data generated from two data collection instruments, such as the National Census of people, households and housing and the Household Survey with the aim to develop a platform management integrated of databases for consultation of socioeconomic variables microterritorial with cartographic visualization. This solution involves the implementation of an Intermediate Data Warehouse that allows an overview of both data sources. Data integration is done by Spatial Matching technique that requires homogeneity conditions between the two instruments on the sample characteristics, the administrative units of spatial disaggregation and the answer or questions in the data. Using spatial location codes incorporated in a Spatial Database a through Geographic Information System (GIS), are added cartographic visualization tools, which facilitates the observation and analysis of spatial relationships between administrative geographical units and as observation and analysis of intra-regional particularities. In the application, we present the distribution of income per capita household in intracommunal units, information that has not been achieved so far as the data of household income in the household survey does not allow one disaggregation less than the Commune.

Revista Ciencias Espaciales, Volumen 8, Número 2 Otoño, 2015; 287-303

Downloads

Download data is not yet available.
Abstract
1337
PDF (Español (España)) 1268

Published

2015-08-30

How to Cite

Cornejo, R., Navarrete, M., Valdivia, R., Aroca, P., & Aracena, S. (2015). Development of a business intelligence solution to integrate census and survey data in GIS. Ciencias Espaciales, 8(2), 287–303. https://doi.org/10.5377/ce.v8i2.2083

Issue

Section

Analysis methods with Geographic Information Technologies