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

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

Título del libro: Advances In Drinking Water Purification: Small Systems And Emerging Issues
Título del capítulo: Advances in the development of adequate, affordable, and sustainable treatment alternatives to drinking water contamination by arsenic, heavy metals, and nitrates in Mexico

Autores UNAM:
MARIA AURORA ARMIENTA HERNANDEZ;

---

Autores externos:

---

Idioma:

---

Año de publicación:
2024

---

Palabras clave:

adsorption; Arsenic; heavy metals; nature-based options; nitrates; phytoremediation

---

Resumen:

Inorganic contaminants, mainly arsenic, fluoride, and nitrates, are present in many drinking water sources in the Mexican territory. Besides, metals such as chromium, manganese, and iron reach levels above the drinking water standards have been detected in specific zones. The geological, hydrogeological, and social complexity of the country poses difficulty regarding the identification of the specific contaminant sources and implement adequate solutions to protect the population?s health. Although arsenic comes mainly from natural sources, anthropogenic actions may worsen the problem by adding other sources or promoting the increase of the concentrations; a similar situation is also present in some sites for the other contaminants. Traditional treatment procedures have been established in some areas; however, their continuous operation faces various problems related to funding and technical issues exacerbated in low-income populations. To solve this problem, research groups have developed innovative methods such as using low-cost adsorption materials, including minerals such as zeolites, calcite, and Fe-oxides, the establishment of wetlands to treat polluted water, and the application of phytoremediation to refrain the impact of solid wastes. This chapter will give an overview of the state of the art regarding identifying contamination sources, knowledge of the environmental chemistry, and efforts developed in Mexico to remove arsenic, heavy metals, and nitrates from drinking water sources using innovative procedures. © 2024 Elsevier Inc. All rights reserved.

---

Entidades citadas de la UNAM:

---

Fuente:


ISBN:
9780323917339
Editorial:
Elsevier Nombre de la publicación:
Advances in the development of adequate, affordable, and sustainable treatment alternatives to drinking water contamination by arsenic, heavy metals, and nitrates in Mexico
Página inicial:
421
Página final:
456

Tipo de producto:
Capítulo de un Libro

DOI:
10.1016/B978-0-323-91733-9.00019-2