ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'CodigoInstitucion'. [20018] (severity 16) [SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '637736' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NOT NULL;]
SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '637736' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NOT NULL;

ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'CodigoInstitucion'. [20018] (severity 16) [SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '637736' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NULL;]
SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '637736' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NULL;

ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = '637736']
SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = '637736'

ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 637736 AND InstitucionPropia = 'S' UNION SELECT Adscripciones.Entidad FROM PublicacionesObras JOIN PublicObrasAutores ON PublicacionesObras.Identificador = PublicObrasAutores.RefPublicacion JOIN Adscripciones ON PublicObrasAutores.NumeroEmpleado = Adscripciones.NumeroEmpleado WHERE (PublicacionesObras.FechaPublicacion BETWEEN Adscripciones.FechaDesde AND Adscripciones.FechaHasta OR (PublicacionesObras.FechaPublicacion >= Adscripciones.FechaDesde AND Adscripciones.FechaHasta IS NULL)) AND PublicacionesObras.Identificador= 637736]
SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 637736 AND InstitucionPropia = 'S' UNION SELECT Adscripciones.Entidad FROM PublicacionesObras JOIN PublicObrasAutores ON PublicacionesObras.Identificador = PublicObrasAutores.RefPublicacion JOIN Adscripciones ON PublicObrasAutores.NumeroEmpleado = Adscripciones.NumeroEmpleado WHERE (PublicacionesObras.FechaPublicacion BETWEEN Adscripciones.FechaDesde AND Adscripciones.FechaHasta OR (PublicacionesObras.FechaPublicacion >= Adscripciones.FechaDesde AND Adscripciones.FechaHasta IS NULL)) AND PublicacionesObras.Identificador= 637736

Título del libro: 34th European Modeling And Simulation Symposium, Emss 2022
Título del capítulo: Geographical simulation-optimization system for solving subway complex emergency problems

Autores UNAM:
AIDA HUERTA BARRIENTOS;

---

Autores externos:

---

Idioma:

---

Año de publicación:
2022

---

Palabras clave:

Emergency services; Geographic information systems; Graph theory; Subway stations; ABMS; Dijkstra's algorithms; Mexico City; Optimisations; Optimization system; Optimization techniques; Short-path; Simulation and optimization; Simulation optimization; Simulation systems; Optimization

---

Resumen:

Complex emergency problems are presented in the Mexico City subway due to the breakdown in the train, specifically wheel flat causing the movement of emergency vehicles and firemen that need to select the shortest path from their location to the subway station where the incident is presented. A large number of existing studies in the broader literature have examined the use of optimization techniques to solve the problem of emergencies at subway stations applying the shortest path algorithm and integrating GIS. However, the contributions based on simulation optimization techniques with GIS for solving such problem are limited. This paper addresses the need to establish a framework for a geographical simulation and optimization system that integrates ABMS, GIS, and Dijkstra's algorithm for solving complex path optimization problems, such as the optimal route finding to support fire emergency service at subway stations and the movement of emergency vehicles, so far lacking in the scientific literature. This system can be used to optimize and simulate a variety of emergency situations at subway stations and design anticipatory scenarios to improve response. First, we present the literature review about the use of optimization algorithms for subway emergency and ABMS used to investigate the dynamic of subway in emergency cases. Second the framework for a geographical simulation and optimization system is formulated and implemented using NetlogoTM. Third, the simulation results are analyzed. Finally, the concluding remarks and directions for future research are drawn. © 2022 The Authors.

---

Entidades citadas de la UNAM:

---

Fuente:


ISBN:
9788885741737
Editorial:
Dime University of Genoa

Tipo de producto:
Conference Paper

DOI:
10.46354/i3m.2022.emss.005