Estructuración de la base de datos geográfica Sisben para el departamento de Cundinamarca

Abstract

The Geographic Databases Structuring project for Cundinamarca sought to relate the data from the SISBEN (Beneficiary Information System) survey geographically to each of the municipalities of the department at the level of the populated center and verdal, making it possible to visualize them spatially In an easier way. To achieve this, geodatabases were used because they have a comprehensive information model to represent and manage the information; And in addition, it is implemented as a series of tables that store entity classes, raster datasets, and attributes. The project was carried out under 4 stages: Creation of databases, Structuring of databases, Analysis Information and Generation cartography and documents. Following the previous stages was obtained that 2056558 records of the SISBEN survey could be stored geographically 1977208, for which a map was drawn that shows the behavior of the variable score in the department; To finish a statistical analysis of the result of the map and the data recorded in the survey was carried out. With this The Secretary of Planning specifically the Office of Geographic Information Systems, Analysis and Statistics hopes to make a web application on ArcGis Online, which will allow different users to obtain information from each of the surveys of the municipalities at the level and center populated. As a recommendation to the entity it was suggested an update, revision and unification of the base cartography since it was found that the geographic data used by the government differs from those used by the DANE and those published by the municipalities since some information that is in The official pages of the municipalities did not coincide in some cases with the base cartography used.