Especialización en Sistemas de Información Geográfica
URI permanente para esta colecciónhttp://hdl.handle.net/11349/2033
Examinar
Envíos recientes
Ítem ‘Mawé’: Prototipo de App móvil para el fortalecimiento de circuitos cortos agroalimentarios(Universidad Distrital Francisco José de Caldas) Múñoz Peña, Karen Julieth; Sarmiento Martínez , Laura Andrea; Ramírez Fernández, Salomón EisteinThe project “Mawé: Prototype of a Mobile App for the Strengthening of Short Agri-Food Circuits” develops a technological proposal aimed at improving food security and sovereignty in Bogotá through the design of a mobile application prototype that directly connects producers and consumers of urban, peri-urban, and agroecological gardens. The initiative seeks to reduce intermediation, promote fair trade, recover traditional practices such as bartering, and foster community participation around responsible food production and consumption. The prototype was designed under the User-Centered Design (UCD) methodology, which made it possible to identify the real needs of stakeholders and translate them into key functionalities such as profile management, product catalogs, user messaging, and a georeferenced map of gardens. The interface was conceived to be accessible on low-range devices, culturally relevant, and aligned with local and national food security policies. The usability evaluation, based on the ISO/IEC 25010 standard, showed high levels of effectiveness, efficiency, and user satisfaction, validating its relevance as a tool for community and environmental strengthening. Looking ahead, the project envisions developing the functional code, carrying out pilot tests in the field, incorporating environmental and agroecological education modules, and integrating geospatial analytics to support local food system planning.Ítem GEOGRAI - PLUGIN de QGIS para generar mapas coropléticos municipales para el análisis del conflicto colombiano(Universidad Distrital Francisco José de Caldas) Zaraza Martínez, Laura Andrea; Ramírez, Salomón EinsteinThe thesis proposes the development of GEOGRAI, a QGIS plugin that facilitates the geographic analysis of information on the Colombian armed conflict, supporting the GRAI of the JEP in systematizing data on municipalities, years, and documented events. The plugin allows the visualization of the temporal evolution of events across the territory, identifying patterns of occupation and actions by the FARC-EP prior to the Peace Agreement. The project addresses its formulation, design, implementation, and evaluation under the 4+1 architecture model and an agile approach, including background, objectives, requirements, and software validation, aiming to improve report production and support the JEP’s mission of clarifying events and ensuring victims’ rights.Ítem Geosoacha: Geovisor para evaluar el estado de la malla vial del municipio de Soacha, Cundinamarca, caso de estudio Comuna 5 “San Mateo”Díaz Barrera, Jorge Daniel; Boada Rodríguez, Alberto; Vera Parra, Danilo AlvertoThe importance of understanding the territory in order to make the best possible technical decisions is fundamental for any entity that manages geographic information. Social and environmental issues, as well as access to fundamental rights, are often directly influenced by geographic location. Soacha, Cundinamarca, is one of the municipalities with the highest levels of social inequality in Colombia and faces multiple challenges related to security, public services coverage, and deficiencies in road infrastructure, among others. The creation of the GeoSoacha geovisor was driven by the need to represent and diagnose one of these issues: the condition of the municipality's road network. The development of the geovisor involved the design of a field data collection methodology, the structuring of a geospatial database, and the web-based visualization of the final results. Initially, the case study focused on Commune 5 "San Mateo", but the ultimate goal is to expand the project to include all communes of the municipality.Ítem Propuesta metodológica para el análisis espacial de datos de resistividad eléctrica del Occidente de la Sabana de Bogotá(Universidad Distrital Francisco José de Caldas) Cordoba Sanabria, Jeanie Valeria; Bustos, Diana Patricia; Boada Rodríguez, AlbertoThis degree project focused on the western part of the Bogotá Savannah and aimed to design a methodological proposal for the integration, analysis, and spatial visualization of electrical resistivity data from the subsoil through the application of interpolation methods in a GIS environment. The information used was provided by a company in the sector and compiled from various geophysical projects. These data were organized, structured, and weighted to facilitate their geospatial processing. A spatial database was generated from vertical electrical soundings (VES), which allowed different interpolation methods to be applied to create isoresistivity maps at different depths. These maps facilitated the identification of trends in subsoil behavior, contributing to the location of areas with aquifer potential. The results obtained allow for the standardization of geophysical data processing and the recognition of the most appropriate interpolation methods in the study area. The proposed methodology seeks to optimize decision-making for companies in the hydrogeological sector, research projects, and the preparation of scientific publications on the region's underground water potential.Ítem Desarrollo de herramienta de web scraping para obtención y análisis espacial de datos del mercado inmobiliario: Caso de La Mesa, Cundinamarca(Universidad Distrital Francisco José de Caldas) García Cotrino, Karol Natalia; Gómez Gómez, Jeyson Santiago; Boada Rodríguez, Alberto; Vera Parra, Danilo AlvertoThis project develops a tool based on web scraping techniques to collect real estate market data, aiming to generate inputs that support the spatial analysis of property listings in the municipality of La Mesa, Cundinamarca. The initiative addresses the lack of cadastral updates in the municipality and the need for current information to improve territorial planning. A quantitative and exploratory approach was applied, implementing an automated workflow for extracting, cleaning, normalizing, and analyzing data obtained from real estate websites, specifically from Finca Raíz. The data were processed using statistical and spatial techniques such as weighted Kernel density estimation, employing the Haversine metric and algorithms suitable for geographic information. As a result, a thematic map was generated to represent the spatial distribution of market property values, identifying areas with higher concentration and appreciation. The proposed tool stands out for being replicable, adaptable, and useful for municipalities with limited technical capacities, offering an efficient and low-cost alternative to strengthen territorial management and the strategic use of open data.Ítem Análisis espacial de exposición y vulnerabilidad de infraestructura frente al aumento del nivel del mar bajo escenarios climáticos en San Andrés(Universidad Distrital Francisco José de Caldas) Neira Álvarez, William David; Boada Rodriguez, Alberto; Vera Parra, Danilo AlbertoSea level rise (SLR) is one of the most significant threats faced by island territories in the context of climate change, particularly due to its potential impact on critical infrastructure and coastal settlements. This research aimed to conduct a spatial analysis of the exposure and vulnerability of strategic infrastructure on San Andrés Island, Colombia, under six projected sea level rise scenarios for the years 2030 and 2050, based on IPCC data. To achieve this, an automated model was developed in ArcGIS Pro 3.3 using ModelBuilder, simulating potential flood surfaces through the reclassification of a Digital Elevation Model (DEM) and assessing their intersection with infrastructure layers such as buildings, roads, and energy distribution points. Geoprocessing tools were used to quantify the affected elements. In addition, a methodology was adapted to classify territorial vulnerability into three levels—high, medium, and not vulnerable—based on flood zones and a buffer. Results show a progressive increase in both the flooded area and the number of affected infrastructure elements, particularly in the 2050 scenarios, even with minimal sea level rise increments. This study offers a replicable and accessible methodology that can support decision-making processes in risk management, spatial planning, and the development of climate change adaptation strategies in insular contexts.Ítem Herramienta para la detección de inconsistencias gráficas (omisiones y comisiones) de las bases de datos catastrales del IGAC basado en Model Builder. Caso de estudio: Municipio de agua de Dios, Cundinamarca(Universidad distrital Francisco Jose de Caldas) Robles Mondragon , David Ricardo; Peña Ramos , Jonatan Stiven; Boada Rodríguez, AlbertoThis project focuses on addressing inconsistencies found in the cadastral databases of the municipality of Agua de Dios, Cundinamarca, which negatively affect territorial management, tax collection, and tax equity. A need has been identified for an efficient tool and/or model capable of resolving issues such as parcel duplication, omission of constructions, and errors in the delimitation of cadastral units. To this end, a model was developed using the “Model Builder” tool, which generates reports on graphical inconsistencies and alphanumeric inconsistencies (Record 1 - R1 database) through spatial analysis and data queries. One of the main objectives in creating this tool is to support quality control during the digitization process, facilitate the detection and spatial localization of inconsistencies, and enable the generation of detailed reports on the state of geospatial information.Ítem Geovisor interactivo del análisis espacial del abstencionismo en las elecciones presidenciales del 2022 para los departamentos de Antioquia y Boyacá(Universidad Distrital Francisco José de Caldas) Rodríguez Quiroga, Andrés; Yomayusa Velásquez , Angie; Boada Rodriguez, Alberto; Vera Parra, DaniloThis project proposes the implementation of a geovisor voter turnout in the 2022 Colombian presidential elections, with the aim of providing a useful tool for decision-making and citizen analysis. It arose from the need to understand the territorial dynamics that explain low voter turnout, allowing for the identification of the factors influencing this phenomenon. The research applied spatial statistical techniques to sociodemographic and economic data at the municipal level, in order to select the most influential variables and construct an explanatory model of electoral behavior. Based on the results, a web-based geovisor was designed and implemented with features geared toward territorial exploration of the data, ensuring ease of use and accessibility for users. The tool allows visualization of spatial patterns of voter turnout, facilitating the identification of critical areas and the planning of targeted interventions. In conclusion, the value of spatial analysis is highlighted as an input for strengthening citizen participation and supporting institutions such as the National Registry and electoral observation organizations in developing strategies to mitigate abstention and promote a more representative democracy.Ítem Desarrollo de un geovisor web para la consulta y visualización de inmuebles gestionados por la Inmobiliaria Clavijo Ltda. En Bogotá.(Universidad Distrital Francisco José de Caldas) Vargas Rey, Cyndi Camila; Boada Rodríguez, Alberto; Vera Parra, Danilo AlvertoThis project aims to design an interactive web-based geovisor focused on the geospatial management of properties available for sale or rent, managed by Inmobiliaria Clavijo Ltda. in the city of Bogotá. The proposed technological solution is based on the use of open-source tools, which helps avoid high licensing costs and ensures system scalability. Currently, the company faces limitations in its commercial processes due to its reliance on traditional methods, such as physical signage. This scenario has hindered its growth and visibility in an increasingly competitive and digital real estate market. Through the integration of Geographic Information Systems (GIS) components, the geovisor will allow spatial location of the properties, application of filters based on relevant criteria, and easy access to property attributes. This will promote the modernization of internal processes and enhance the experience of both users and potential clients. The tool seeks to strengthen the digital presence of the company, optimize decision-making in commercial processes, and expand its reach in Bogotá’s real estate market.Ítem Análisis comparativo de la criminalidad en Bogotá utilizando un geovisor: (años 2023 y 2024)(Universidad Distrital Francisco José de Caldas) Rodríguez Caicedo, Wilson Fabian; Higuera Torrijos, Darien; Boada Rodríguez, Alberto; Vera Parra, Danilo AlvertoThe purpose of this research is to comparatively examine the spatial distribution of crime in Bogotá during 2023 and 2024, through the creation of an interactive geovisor. The study focuses on detecting crime patterns, critical areas, and variations in insecurity linked to the administrations of Mayors Claudia López and Carlos Fernando Galán. To achieve this, statistical and geospatial data provided by official sources such as the Bogotá Open Data Portal and the National Police's SIEDCO system were used. The approach used was quantitative and descriptive, utilizing spatial analysis and interactive visualization methods. The results showed significant fluctuations in the prevalence of crimes such as theft from individuals, homes, and businesses, as well as homicides and sexual offenses. Areas with a higher incidence of crime were identified, and variations in spatial patterns were noted during both years. The main conclusion highlights the importance of the geovisor as a tool for data-informed decision-making, maximizing security resources, and achieving clarity in public administration. This project contributes to strengthening public security policies and promoting a data culture in Bogotá.Ítem Airebogotá: geovisor para el monitoreo histórico y espacial de PM2.5, PM10 y ozono (O3) orientado a evaluar la calidad del aire en Bogotá(Universidad Distrital Francisco José de Caldas) Quijano Hoyos, Santiago Arturo; Becerra Puerto, Andrés Felipe; Boada Rodríguez, AlbertoAir quality in Bogotá is a major environmental concern, especially due to the long-term exposure of the population to pollutants such as PM2.5, PM10, and Ozone (O3). However, public access to detailed spatial data and tools for analyzing changes over time is still limited on current official platforms. In response to this issue, this research aimed to develop a web-based geographic viewer to monitor the historical and spatial behavior of these pollutants. The project combined geographic information systems (GIS), geostatistical analysis tools, and open standards to ensure broad compatibility. The work involved collecting, transforming, and cleaning data from official monitoring stations, organizing them in a geographic database, and applying spatial analysis through ordinary and universal kriging methods. The system’s architecture followed the 4+1 view model and was built using tools such as GeoServer, PostgreSQL/PostGIS, and interoperable services like WMS. As a result, an interactive tool was developed that allows users to explore time series of pollutant variables, view interpolation maps for all of Bogotá and for each Zonal Planning Unit (UPZ), and download station data. The system helps identify critical periods and areas that lack direct monitoring and supports decision-making in urban environmental management. It is concluded that using open-source technologies, geostatistical methods, and geospatial visualization can significantly improve access to, analysis of, and communication about urban air quality.Ítem Desarrollo de un geovisor para identificar zonas compatibles entre café y cultivos estratégicos en el departamento de Quindío(Universidad Distrital Francisco José de Caldas) León Espinosa , Carlos Eduardo; Sosa León , Inés María; Boada Rodríguez , Alberto; Vera Parra, Danilo AlvertoThis project aims development of a web-based geovisor that compares agricultural suitability layers published by the Information System for Rural Agricultural Planning (SIPRA), in order to identify optimal areas for the cultivation of coffee (Coffea arabica L.) and strategic crops (avocado, cacao, banana, and maize) in the department of Quindío. This initiative addresses the lack of structured information to determine the compatibility between two crops and the need for planning tools that integrate technical criteria related to rural land use. To achieve this, a zoning process will be carried out through the combined analysis of the available suitability layers. This procedure will allow for the delineation of geographic areas that simultaneously present favorable conditions for the cultivation of coffee alongside various other crops. The suitability layers will be processed and combined using specific spatial operations, enabling the generation of integrated maps that reflect potential areas of productive overlap within the department. The implementation will follow the 4+1 architectural model, combining the use case view to define functional requirements, the logical view to structure components, the development view to organize the codebase, the process view to address concurrency and performance, and the physical view for deployment. This approach ensures an organized, scalable, and adaptable development process for future crops and evolving needs.Ítem Propuesta metodológica para un aplicativo web de análisis de cambios catastrales físicos y económicos (SAVIC): caso de estudio Tabio, Cundinamarca, vigencia 2025.Naranjo Orjuela, Laura Catherin; Uribe Olarte, Karen Geraldin; Boada Rodríguez, Alberto; Vera Parra, Danilo AlvertoThis paper proposes a methodology for developing a web-based application for analyzing physical and economic cadastral variations, providing technical support for property tax update processes using a multipurpose cadastre approach. Based on a diagnosis of current challenges in cadastral management in Colombia such as the lack of automation, limited use of geospatial tools, and difficulty interpreting large volumes of information the creation of the Cadastral Variation Analysis System (SAVIC) is proposed. This is a technological solution that allows for efficient comparison of data between two cadastral periods. SAVIC was developed using an agile methodology and validated in the municipality of Tabio, Cundinamarca, with information corresponding to the 2025 cadastral period. The application allows users to upload standardized files, identify increases and decreases in appraisal, area, and property classification, and visualize these changes using interactive maps and automated reports. In addition, it offers individual analysis by property, integrating physical, legal, and economic variables, as well as their relationship to homogeneous physical and geoeconomic zones. The results demonstrate that SAVIC is an effective tool for reducing the operational burden on analysts, improving the traceability of property changes, and strengthening decision-making based on territorial evidence. Its implementation contributes to modernizing municipal cadastral management, in line with the principles of the multipurpose cadastre defined in national public policies.Ítem Diseño de un sistema para la gestión y visualización de información geográfica en el proyecto de Titulación Colectiva de Comunidades Negras(Universidad Distrital Francisco José de Caldas) Basto García, Andrés Felipe; Villar Rojas, Cristian David; Boada Rodríguez, Alberto; Vera Parra, DaniloThis work describes the design and implementation of a system for the management and visualization of geographic information within the framework of the Collective Land Titling Project for Black Communities in Colombia. The proposed solution integrates Business Intelligence (BI) tools with spatial databases to consolidate, analyze, and present multi-thematic information distributed across 158 geographic layers, later organized into 40 unified layers. The system, named Afroterritorio Observa, employs a modular architecture based on PostgreSQL/PostGIS, Metabase, and Mapbox, enabling efficient execution of CRUD operations, generation of interactive dashboards, application of custom filters, and export of reports. Furthermore, spatial and hierarchical relationships were established to link geographic information with territorial entities, ensuring traceability, interoperability, and an ethnic-differentiated approach. The adopted methodology includes thematic segmentation, relational modeling, and use case design under UML and the Rational Unified Process (RUP). This tool strengthens the autonomy of Afro-descendant community councils by facilitating access to and analysis of data for informed decision-making, territorial defense, and participatory planning.Ítem Propuesta metodológica para la identificación de señales de tránsito horizontales en ciclorrutas, caso práctico parque El Tunal, Bogotá.(Universidad Distrital Francisco José de Caldas) García Galindo, Leidy Dajhanna; Jaime Támara , Oscar Fabián; Boada Rodríguez, Alberto; Vera Parra, Danilo AlbertoThis monograph develops an artificial intelligence-based methodological proposal for the automated identification of horizontal traffic signs on urban cycle paths, using El Tunal Park in Bogotá as a case study. The proposed methodology includes data capture in geolocated video format, frame preprocessing, training of a detection model using the YOLOv5n architecture (nano version), and its subsequent evaluation using geospatial tools. The workflow integrates technical components of computer vision and spatial analysis, making use of the Full Motion Video feature of ArcGIS Pro to validate the model's performance in the terrain. The results show that the model correctly identifies several horizontal signs, although it also reveals areas with missing or deteriorated signage, demonstrating the tool's usefulness for urban diagnostic processes. Opportunities for improvement are identified in the quality and quantity of the dataset used for training, as well as in the diversification of the evaluated environments, in order to strengthen the model's generalization capacity. The main conclusion is that the proposed methodology is viable, replicable, and provides an innovative approach to road sign monitoring, combining artificial intelligence and geospatial analysis applied to bicycle infrastructure management.Ítem Propuesta de captura de información en campo para generar informes de inspecciones en control fiscal a partir de un dispositivo electrónico(Universidad Distrital Francisco José de Caldas) Vásquez Mina , Juan José; Sterling Gaitán , Brigitte Alejandra; Boada Rodríguez, Alberto; Vera Parra, Danilo AlvertoThis project addresses the operational challenges faced by officials from the Office of the Comptroller General of the Republic during field inspections, such as adverse weather conditions, loss of physical records, inadequate photographic documentation, and logistical limitations. In the absence of an institutional technological solution, a web-based application was developed to capture structured and georeferenced information in real time, attach photographic evidence, and export data in formats like Excel, KMZ, and GeoJSON. The main objective was to develop an application in Python that allows data to be recorded directly in the field, improving the traceability, accuracy, and efficiency of the process. The tool includes a user-friendly web interface, automatic geolocation features, and customizable fields tailored to the specific needs of each fiscal control activity. An agile Scrum methodology was adopted, and two surveys were conducted: the first to assess initial perceptions regarding the use of technology in fieldwork, and the second to evaluate the application’s usefulness and user acceptance after practical application. The results revealed that 54.2% of the officials frequently encounter difficulties when using physical formats, while 100% considered the application to be very useful. Additionally, 79.2% expressed willingness to use the tool in future inspections, highlighting the benefits of automatic georeferencing and photographic support. In conclusion, this technological solution is innovative, relevant, and feasible, showing a high level of acceptance and strong potential to be institutionalized as an official tool to enhance the efficiency and transparency of field-based fiscal oversight.Ítem INFOPOINTREPORT: Plugin de QGIS para el apoyo de generación de informes de capas prediales(Universidad Distrital Francisco José de Caldas) Palacios Yate, David Esteban; Rubiano Moreno, Sergio Esteban; Boada Rodríguez, Alberto; Vera Parra, Danilo AlvertoThe GIS team is facing a heavy workload because attribute queries within spatial layers are carried out manually. To mitigate this issue, a QGIS plugin was developed to automate the cadastral layer-query process, shortening response times and reducing errors, thereby improving the operational efficiency of GIS professionals. The project followed the agile Scrum methodology through the analysis, design, implementation, and evaluation phases. During analysis, functional requirements were identified, such as reading Shape layers, accepting coordinates in DMS/DD, and generating a CSV report. In the design phase, UML diagrams were produced according to the 4 + 1 View Model. Implementation of the plugin—InfoPointReport—was carried out with PyQGIS and QtDesigner. In the evaluation phase, the plugin was tested against a cadastral database of 2.5 million records. Query times varied depending on the relationship between the input coordinate and the target polygon: where a direct intersection existed, the query took no more than half a second, whereas when the coordinate lay far from any polygon, the query could take up to 20 seconds. Using such a large test layer made it possible to confirm that the plugin is stable, reliable, and fault-tolerant.Ítem GeoICAR: geovisor para realizar seguimiento a la calidad del recurso hídrico en la jurisdicción de la CAR Cundinamarca(Universidad Distrital Francisco José de Caldas) Quitián González, Valeria; Vargas Vega, Martín Alfonso; Ramírez Fernández, Salomón EinsteinThe geoviewer tool for consultation of the Water Quality Index was born from the need to reduce the gap that exists between public entities and users who are interested in or affected by the definitions of an environmental authority; In addition to continue contributing to transparency and the right of access to national public information, this is how, taking into account the information of the Corporación Autónoma Regional de Cundinamarca, the functionalities of the system were generated; in the planning and development phase, all the necessary inputs were taken into account to generate the correct operation, within a friendly environment and a simple usability for all users. The result of the project is GeoICAR, a geoviewer in which the information of Water Quality Indexes can be consulted, for a hydrographic basin and a defined monitoring point, within the jurisdiction of the CAR Cundinamarca, the users will be able to visualize and consult the available information; besides having roles for workers that allow the registration of information and calculation of the index in the interface of the geoviewer.Ítem Huecapp: aplicación móvil para generar rutas, reportar y visualizar reportes de huecos en la ciudad de BogotáRamirez, Oscar Arturo; Ramirez Rodriguez, Juan Esteban; Ramirez Fernandez, Salomon EinsteinThe advanced deterioration of the road network in Bogotá represents a significant challenge for the mobility and safety of citizens, affecting not only drivers, but also motorcyclists, cyclists and pedestrians. In response to this problem, HuecApp was developed, a mobile application for Android that combines advanced technologies such as Firebase, Ionic, Capacitor and the Google Maps API. Its objective is to allow the generation of optimized routes and the visualization of potholes in the roads reported by users in real time. The Rapid Application Development (RAD) methodology guided the process, prioritizing an agile and adaptive development within a period of four months. The application includes key functionalities such as collaborative reporting of potholes and interactive visualization on maps, supported by a modular architecture that facilitates its scalability. The tests carried out with users highlighted its effectiveness in functionality and usability, although they pointed out areas for improvement in the accessibility and accuracy of the reports. HuecApp is positioned as an innovative solution that promotes citizen participation and improves the management of road infrastructure, contributing to safer and more efficient urban mobility.Ítem Geocantera : geovisor para la ayuda en la trazabilidad de compra de materiales de construcción(Universidad Distrital Francisco José de Caldas) Casilimas Cautiva, Javier; Cifuentes Contreras, GermánThis research seeks to design a geographic viewer that helps traceability of a construction material derived from open pit mining through geographic location instead of collection and loading such as river sand, gravel and its derivatives in real time where Its extraction location can be identified through geolocation available through a web access platform.