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

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

Título del libro: Sustainability Of Integrated Water Resources Management: Water Governance, Climate And Ecohydrology
Título del capítulo: Water-resource management in Mexico under climate change

Autores UNAM:
CARLOS GAY Y GARCIA; MARIA INES JOSEFINA NAVARRO GONZALEZ;

---

Autores externos:

---

Idioma:
Inglés

---

Año de publicación:
2015

---

Palabras clave:

Flood control; Floods; Population statistics; Resource allocation; Water management; Water quality; Water supply; Adaptation; Economic system; Flood management; Future climate scenarios; Me-xico; Population growth; Water use; Waterresource management; Climate change

---

Resumen:

In Mexico, pressure on water resources exists in all sectors. This, coupled with population growth and the consequent increase in demand for water, could drive communities and cities whose water supply is limited to become more vulnerable in the future. Also, the effects of climate change have been felt through a series of hydrometeorological disasters, such as floods and droughts, that have produced impacts on the economic system and the safety of the population. The country studies that have addressed the impact of climate change on supply systems and flood management are reduced. It is therefore urgent to give attention to areas of the country that are most vulnerable. But it is also important to address other aspects of water resources that will be affected by the effects of climate change. This chapter presents some of the studies that have addressed the effect of climate change on water resources. It includes studies examining the effects at the country level and at the local level such as a city. An analysis to determine the future demand and vulnerability of a city due to local scale effects and the feasibility of capturing rainwater as a potential adaptation are presented. The studies focus on the quality and quantity of water that could be expected under future climate scenarios for Mexico. Other studies consider urban, rural, and coastal areas. Some adaptation measures that could be implemented in the country are suggested in this document. © Springer International Publishing Switzerland (outside the USA) 2015. All rights reserved.

---

Entidades citadas de la UNAM:

---

Fuente:


ISBN:
9783319121949
Editorial:
Springer International Publishing Nombre de la publicación:
Water-resource management in Mexico under climate change
Página inicial:
215
Página final:
241

Tipo de producto:
Capítulo de un Libro

DOI:
10.1007/978-3-319-12194-9_13