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

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

Título del libro: Drought: Research And Science-Policy Interfacing - Proceedings Of The International Conference On Drought: Research And Science-Policy Interfacing
Título del capítulo: Drought monitoring in a transboundary river basin in North America

Autores UNAM:
JOSE AGUSTIN BREÑA NARANJO; PEDRO ALEJANDRO DE JESUS MAGAÑA MELGOZA; ADRIAN PEDROZO ACUÑA;

---

Autores externos:

---

Idioma:
Inglés

---

Año de publicación:
2015

---

Palabras clave:

Balloons; Deforestation; Digital storage; Food supply; Moisture; National security; Rivers; Soil moisture; Soils; Watersheds; Assessment and monitoring; Drought monitoring; Environmental governances; Hydrological system; Observational data; Soil water storage; Space-time variability; Trans-boundary rivers; Drought; Coefficients; Drought; Moisture Content; North America; Rivers

---

Resumen:

Droughts can cover extensive areas with durations ranging from months to years and having devastating impacts such as massive migration, high fatality rates and forest fires, among others. Also, drought can threaten water and food security, and in transboundary regions, this can become a national security issue due to their implications for socio-economic and environmental governance. For the assessment and monitoring of drought, several methodologies have been proposed, with drought indexes being a common approach. Drought indexes can include a broad spectrum of meteorological, hydrological and vegetation observational data, and therefore, can provide insights about its intensity, duration, and spatial extent. This work tests 4 different drought severity indexes based on soil moisture and total water storage deficits across the Rio Bravo/Grande river basin, which is commonly shared between Mexico and the USA. The drought indexes are estimated using datasets of assimilated soil water storage, observed shallow soil moisture, observed variation of total water storage and a combination of them. Although the four methods are able to detect an increase in the water deficit, the indexes calculated with satellite-based data underestimate the severity and spatial extent that occurred during the exceptional 2011 drought, when compared to the North American Drought Monitor. Possible causes for this underestimation are the lack of consideration of irrigation activities, the attenuation of drought severity throughout the hydrological system and the space-time variability of drought propagation across the river basin. © 2015 Taylor & Francis Group, London.

---

Entidades citadas de la UNAM:

---

Fuente:


ISBN:
9781138027794
Editorial:
CRC Press/Balkema

Tipo de producto:
Conference Paper

DOI:
10.1201/b18077-36