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 = '548979' 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 = '548979' 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 = '548979']
®
ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 548979 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= 548979]
SIIA Público
SISTEMA INTEGRAL DE INFORMACIÓN ACADÉMICA - PÚBLICO
Título del libro: Geotechnical Engineering In The Xxi Century: Lessons Learned And Future Challenges Título del capítulo: Seismic Vulnerability of the Water System in Mexico City
Autores UNAM: ENRIQUE MARTINEZ HERNANDEZ;
Autores externos: Idioma: Año de publicación: 2019Palabras clave:
Water system; earthquakes; resilience; vulnerability; hazards
Resumen:
Cities must provide services and resources in optimal conditions for
their inhabitants to live in harmony. The primal ones are the lifelines
systems that furnish services such as water, energy, transportation,
etc. If the territory is heavy populated these systems are composed by
complex networks that comprise extended distances hence making them more
vulnerable to many different kind of risks, particularly the natural
ones. The water system is one of the most fundamental lifelines and it
is often subjected to natural hazards, especially flooding and
earthquakes. Mexico City, being one of the most populated cities in the
world requires a colossal water network that is often subjected to
seismic forces. Moreover, the complex soil conditions in the basin and
the problem of regional subsidence, make the system more vulnerable.
This paper presents a brief background of the water system in the city
and its damage during the 1985 Michoacan Earthquake and the 2017
Puebla-Morelos Earthquake. It also compiles the measures taken after
these earthquakes to restore the system. The extent of damage and the
geotechnical conditions are described. The fundamental of seismic
vulnerability and some countermeasures that can be implemented to turn
the Mexico City water network into a more resilient system are
discussed, as well the challenges that large urban water supply systems
have to deal to overcome their vulnerability to seismic hazards and
increase its resilience.