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

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

Título del libro: Soil Improvement And Water Conservation Biotechnology
Título del capítulo: Water in the arid and semi-arid zones of Mexico

Autores UNAM:
ELVIA MANUELA GALLEGOS NEYRA; FRANCISCO JOSE TORNER MORALES; CESAR ALEJANDRO ZAMORA BARRIOS; IVAN ANDRES ARREDONDO FRAGOSO; ISRAEL VALENCIA QUIROZ;

---

Autores externos:

---

Idioma:

---

Año de publicación:
2025

---

Palabras clave:

Fluoridation; Global warming; Industrial water treatment; International cooperation; Irrigation; Wastewater treatment; Arid zones; Groundwater aquifer; Hydroclimatic; Hydroclimatic characteristic; Me-xico; Rainwater harvesting; Semiarid zone; Water scarcity; Water use; Waters managements; Aquifers

---

Resumen:

This chapter analyzes the current situation and challenges faced by water management in the arid and semi-arid zones of Mexico. It examines the hydroclimatic characteristics of these regions, highlighting the importance of water for maintaining their unique ecosystems and supporting the rural populations that depend on it. Various water sources are studied, including groundwater aquifers, surface waters, rainwater harvesting, and treated wastewater. Each source is vital but presents distinct challenges for sustainable management, including the need for regulatory measures and innovative conservation techniques. Climate change and its effects, such as altered rainfall patterns, prolonged droughts, and rising temperatures, exacerbate water scarcity and threaten ecosystem stability, necessitating targeted adaptation and mitigation strategies tailored to local conditions. Innovative technologies and practices for water conservation and efficient use are discussed, such as advanced irrigation systems, water reuse, and real-time management through artificial intelligence and the Internet of Things. The chapter addresses the complexities of water use in agricultural, domestic, urban, and industrial sectors, with a focus on issues like overexploitation, pollution, climate change impacts, and conflicts over water use. It also underscores the significance of community-based approaches and the need for local engagement in achieving sustainable water management. Finally, the chapter provides an overview of strategies, policies, and legal frameworks aimed at promoting sustainable water management, drawing lessons from successful case studies and emphasizing the importance of integrated resource management, community participation, and international cooperation to tackle the multiple water challenges faced by these regions of Mexico. © 2025 Bentham Science Publishers.

---

Entidades citadas de la UNAM:

---

Fuente:


ISBN:
9789815322439
Editorial:
Bentham Science Publishers

Tipo de producto:
Book chapter

DOI:
10.2174/9789815322439125010006