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 = '323629' 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 = '323629' 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 = '323629' 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 = '323629' 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 = '323629']
SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = '323629'

ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 323629 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= 323629]
SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 323629 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= 323629

Título del libro: Landslides: Global Risk Preparedness
Título del capítulo: Landslide monitoring and warning systems in Mexico

Autores UNAM:
IRASEMA ALCANTARA AYALA; RICARDO JAVIER GARNICA PEÑA;

---

Autores externos:

---

Idioma:
Inglés

---

Año de publicación:
2013

---

Palabras clave:

Landslides; Monitoring; Precipitation; Warning systems

---

Resumen:

Landslides are one of the major hazards in Mexico. Either triggered by earthquakes, volcanic activity or precipitation, their consequences have been quite significant. Casualties from landslides disasters have varied over the years from just a few to many thousands of people. There has been a considerable economic impact as well. However, in comparison with other hazards such as volcanoes, earthquakes, hurricanes and floods, landslides have not captured yet the full attention of civil protection authorities or even of a large group of academicians. Not surprisingly, there is a lack of a well-structured national strategy to prevent, confront, cope with and mitigate the catastrophic consequences of landslides taking place in vulnerable communities in both rural and urban areas. In recent years, the frequency of mass movement processes has increased as a result of high-magnitude rainfall events. Therefore, in the light of changes in climatic conditions which involve an increase of precipitation in tropical and subtropical regions, the necessity of designing and establishing monitoring and warning systems for rainfall-triggered landslides in Mexico is rather urgent. This does not imply that monitoring and warning systems for landslides associated with seismicity and volcanic activity are not significant, but based on historical accounts detailed in literature and on field observations, it is clear that rainfallinduced landslides represent the largest mass-movement hazard in the Mexican territory. Accordingly, the aim of this chapter is to provide a preliminary analysis of the impact of landslides triggered by precipitation in order to set up a framework for developing integrated monitoring and warning systems. © 2013 Springer-Verlag Berlin Heidelberg. All rights are reserved.

---

Entidades citadas de la UNAM:

---

Fuente:


ISBN:
9783642220876
Editorial:
Springer-Verlag Berlin Heidelberg Nombre de la publicación:
Landslide monitoring and warning systems in Mexico
Página inicial:
299
Página final:
314

Tipo de producto:
Capítulo de un Libro

DOI:
10.1007/978-3-642-22087-6_21