Tesella: aplicación para la evaluación espacial de impacto de fenómenos urbanos

Pardo Russi, Wady Millett

doi:https://doi.org/10.48713/10336_47134

Ítem

Acceso Abierto

Tesella: aplicación para la evaluación espacial de impacto de fenómenos urbanos

Mostrar el registro sencillo de la publicación

dc.contributor.advisor	Camargo Salamanca, Guibor
dc.creator	Pardo Russi, Wady Millett
dc.creator.degree	Magíster en Ciudades Inteligentes y Sostenibles
dc.creator.degreeLevel	Maestría
dc.date.accessioned	2025-12-15T13:12:55Z
dc.date.available	2025-12-15T13:12:55Z
dc.date.created	2025-12-12
dc.description	Este proyecto presenta una aplicación replicable para la evaluación exploratoria del impacto de intervenciones urbanas, que integra el procesamiento de datos espaciales y la estimación econométrica en un flujo de trabajo desarrollado en R y Shiny. La herramienta opera sobre teselas hexagonales de 5 y 10 hectáreas; el tratamiento se define por la intersección entre el proyecto y la tesela (t), y los efectos de derrame se modelan mediante anillos de vecindad topológicos (n1…n5). Aunque el caso demostrativo se centra en impactos sobre el tejido económico, la herramienta está diseñada para evaluar una amplia gama de efectos urbanos (económicos, sociales, espaciales o ambientales), según las bases de datos que se integren. El caso de estudio analiza el intercambiador deprimido de la Calle 94 con la NQS (año de intervención 2017), utilizando un panel 2010–2023 construido a partir del Censo Inmobiliario y de los registros empresariales de la Cámara de Comercio de Bogotá. Estas fuentes se emplean exclusivamente para demostrar la funcionalidad del prototipo con datos reales, sin constituir su núcleo metodológico. En el escenario de 10 hectáreas, los efectos promedio son cercanos a cero y no significativos; en 5 hectáreas, los resultados se mantienen nulos para t vs. n1, pero se observa una señal positiva y significativa para las empresas medianas en anillos más lejanos (t vs. n2…n5), coherente con procesos de difusión espacial del impacto. Entre las principales limitaciones se encuentran la automatización parcial del prototipo y la necesidad de ampliar su escalabilidad para uso institucional. En conjunto, Tesella ofrece un protocolo estandarizado, transparente y replicable para el monitoreo de proyectos urbanos y la toma de decisiones basadas en evidencia.
dc.description.abstract	This project introduces a reproducible tool for exploratory impact evaluation of urban interventions, integrating spatial data processing and econometric estimation within an R+Shiny workflow. The tool operates on 5- and 10-hectare hexagonal tiles; treatment is defined by Project-tile intersection (t), and spillovers are modeled through topological neighbor rings (n1…n5). Identification relies on a two-way fixed-effects difference-in-differences (TWFE) design with pre-trend checks and placebo tests, producing fully auditable outputs. While the demonstrative application focuses on economic outcomes, the tool is designed to evaluate a broad range of urban impacts (economic, social, spatial or environmental), depending on the datasets provided. The case study analyzes the depressed interchange at Calle 94–NQS (intervention year 2017) using a 2010–2023 panel built from Bogotá’s Censo Inmobiliario and Cámara de Comercio de Bogotá business registry. These sources were used solely to illustrate the tool’s functionality under real data conditions. In the 10-ha baseline, average effects on core economic outcomes are near zero and statistically insignificant for the t vs. n1 comparison. At 5 ha, null results persist for t vs. n1, while a positive and statistically significant signal emerges for medium-sized firms when controls are moved to more distant rings (t vs. n2…n5), consistent with first-ring contamination and fine-scale spatial diffusion. The contribution is a standardized, transparent and replicable protocol for institutional monitoring of projects. While its current implementation emphasizes geographic and econometric modules, it operates as a flexible prototype that can be adapted to diverse datasets and outcome domains. Limitations include the partial automation of the current version and the need to scale up for institutional use. The framework is designed for extensibility, enabling its application to multiple types of urban interventions across different contexts worldwide.
dc.format.extent	64 pp
dc.format.mimetype	application/pdf
dc.identifier.doi	https://doi.org/10.48713/10336_47134
dc.identifier.uri	https://repository.urosario.edu.co/handle/10336/47134
dc.language.iso	spa
dc.publisher	Universidad del Rosario
dc.publisher.department	Escuela de Ciencias e Ingeniería
dc.publisher.department	Facultad de Estudios Internacionales, Políticos y Urbanos
dc.publisher.program	Maestría en Ciudades Inteligentes y Sostenibles
dc.rights.accesRights	info:eu-repo/semantics/openAccess
dc.rights.acceso	Abierto (Texto Completo)
dc.source.bibliographicCitation	P. Cheshire y E. S. Mills, “Introduction: Applied Urban Economics,” in Handbook of Regional and Urban Economics, vol. 3, 1999.
dc.source.bibliographicCitation	R. W. Eberts y D. P. McMillen, “Agglomeration Economies and Urban Public Infrastructure,” in Handbook of Regional and Urban Economics, vol. 4, 1999.
dc.source.bibliographicCitation	P. C. Melo, D. J. Graham y R. B. Noland, “The Impact of Transport Infrastructure on Firm Formation: Evidence from Portuguese Municipalities,” Transportation Research Record, vol. 2163, pp. 133–143, 2010.
dc.source.bibliographicCitation	R. Bernal y X. Peña, Guía práctica para la evaluación de impacto. Bogotá: Universidad de los Andes, 2011.
dc.source.bibliographicCitation	L. Anselin, Spatial Econometrics: Methods and Models. Dordrecht: Kluwer, 1988. doi: 10.1007/978-94-015-7799-1.
dc.source.bibliographicCitation	G. Camargo, Slum management effects on informal and formal urban expansion: A comparative impact evaluation between neighborhood legalization and comprehensive neighborhood improvement–MIB programs in Bogotá, Colombia, Master’s thesis, Universidad de los Andes, Bogotá, 2022.
dc.source.bibliographicCitation	K. Butts, “Difference-in-Differences with Spatial Spillovers,” Working Paper, University of Colorado Boulder, Department of Economics, Jun. 2023.
dc.source.bibliographicCitation	S. Gibbons, H. G. Overman y E. Resende, “Spatial Methods in Econometrics: Theory and Applications,” Journal of Economic Geography, 2015.
dc.source.bibliographicCitation	J. P. Elhorst, Spatial Econometrics: From Cross-Sectional Data to Spatial Panels. Berlin: Springer, 2014. doi: 10.1007/978-3-642-40340-8.
dc.source.bibliographicCitation	S. J. Redding y E. Rossi-Hansberg, “Quantitative Spatial Economics,” Annual Review of Economics, vol. 9, 2017. doi: 10.1146/annurev-economics-063016-103713.
dc.source.bibliographicCitation	G. Duranton y M. A. Turner, “The Fundamental Law of Road Congestion,” American Economic Review, vol. 101, no. 6, 2011. doi: 10.1257/aer.101.6.2616.
dc.source.bibliographicCitation	D. Donaldson, “Railroads of the Raj,” Quarterly Journal of Economics, 2016. doi: 10.1093/qje/qjw002.
dc.source.bibliographicCitation	“The Economic Impact of Transport Infrastructure: A Review of Project-Level vs Aggregate-Level Evidence,” Transport Reviews, 2025. doi: 10.1080/01441647.2025.2476012.
dc.source.bibliographicCitation	“Luas Finglas – Delivering a Sustainable Infrastructure: Sustainability, Circular Economy, Active Mobility,” in Springer (cap./vol.), 2025. doi: 10.1007/978-3-031-95284-5.
dc.source.bibliographicCitation	“One belt, one road, one way? Where European exporters benefit from the New Silk Road,” Review of World Economics, 2023. doi: 10.1007/s10290-022-00467-0.
dc.source.bibliographicCitation	S. Gutman y M. Malashenko, “The Impact of Transport Infrastructure on Sustainable Economic Development of Russian Regions,” Sustainability, 2025. doi: 10.3390/su17093776.
dc.source.bibliographicCitation	D. Purwar, J. Flacke, E. A. Guzmán y R. Sliuzas, “A qualitative analysis of cascading effects of critical infrastructure service failure post torrential floods in formal & informal settlement: the study-case of Medellin city, Colombia,” Sustainable and Resilient Infrastructure, vol. 9, no. 5, pp. 496-512, 2024, doi: 10.1080/23789689.2024.2340924.
dc.source.bibliographicCitation	M. Haryanto y M. Mahsun, “Business and Politics in Urban Indonesia: Patrimonialism, Oligarchy and the State in Two Towns,” Journal of Current Southeast Asian Affairs, vol. 43, no. 2, pp. 177-197, 2024, doi: 10.1177/18681034241264574.
dc.source.bibliographicCitation	R. A. Hall, “National–Local Synergies for Development: How a Local Political Machine Delivered Infrastructure Results in Iloilo City,” Journal of Current Southeast Asian Affairs, vol. 43, no. 2, 2024, doi: 10.1177/18681034241265724.
dc.source.bibliographicCitation	B. Antonić y A. Stupar, “Urban Regeneration through Cultural–Tourism Entrepreneurship… Sombor, Serbia,” Land, 2024. doi: 10.3390/land13091379.
dc.source.bibliographicCitation	B. Callaway y P. H. C. Sant’Anna, “Difference-in-Differences with Multiple Time Periods,” Journal of Econometrics, 2021. doi: 10.1016/j.jeconom.2020.12.001.
dc.source.bibliographicCitation	T. Conley, “GMM Estimation with Cross-Sectional Dependence,” Journal of Econometrics, 1999. doi: 10.1016/S0304-4076(98)00084-0.
dc.source.bibliographicCitation	A. Abadie, A. Diamond y J. Hainmueller, “Synthetic Control Methods for Comparative Case Studies,” JASA, 2010. doi: 10.1198/jasa.2009.ap08746.
dc.source.bibliographicCitation	J. P. LeSage y R. K. Pace, Introduction to Spatial Econometrics. CRC Press, 2009.
dc.source.bibliographicCitation	[Camagni] R. Camagni, Economía urbana, trad. V. Galletto. Barcelona, España: Antoni Bosch Editor, 2005.
dc.source.instname	instname:Universidad del Rosario
dc.source.reponame	reponame:Repositorio Institucional EdocUR
dc.subject	Econometría espacial
dc.subject	Diferencias en diferencias
dc.subject	Intervenciones urbanas en Bogotá
dc.subject	Teselaciones Hexagonales
dc.subject	Efectos de derrame
dc.subject	R Shiny
dc.subject	Problema de la unidad espacial modificable (MAUP)
dc.subject.keyword	Spatial econometrics
dc.subject.keyword	Difference-in-differences
dc.subject.keyword	Urban interventions in Bogotá
dc.subject.keyword	Hexagonal tessellations
dc.subject.keyword	Spillovers
dc.subject.keyword	R Shiny
dc.subject.keyword	MAUP
dc.title	Tesella: aplicación para la evaluación espacial de impacto de fenómenos urbanos
dc.type	masterThesis
dc.type.hasVersion	info:eu-repo/semantics/acceptedVersion
dc.type.spa	Trabajo de grado
local.department.report	Escuela de Ciencias e Ingeniería
local.department.report	Facultad de Estudios Internacionales, Políticos y Urbanos
local.regiones	Bogotá