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

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

Título del libro: Proceedings Of The 16th International Association For Mathematical Geosciences - Geostatistical And Geospatial Approaches For The Characterization Of Natural Resources In The Environment: Challenges, Processes And Strategies, Iamg 2014
Título del capítulo: Control of deteriorating water quality in extracted boreholes by flow systems definition

Autores UNAM:
JOSE JOEL CARRILLO RIVERA;

---

Autores externos:

---

Idioma:
Inglés

---

Año de publicación:
2014

---

Palabras clave:

Aquifers; Chemical hazards; Climate change; Groundwater; Groundwater flow; Groundwater resources; Health hazards; Information management; Monitoring; Natural resources; Population statistics; Quality control; Water levels; Water quality; Aquifer thickness; Climatic conditions; Groundwater extraction; Groundwater flow systems; Groundwater monitoring; Maintenance cost; Quality change; Toxic elements; Extraction

---

Resumen:

Climate change could be blamed on observed water quality decline.This is an undesirable response in any supply project based on groundwater that could produce negative effects as health hazards for the population, undesirable impacts to infrastructure, and increases of maintenance costs for economic activities.Climate change has created recent concern, also the increase in groundwater extraction resulting in enhancement of salinity and/or toxic element content.Results are significant in regions where aquifer thickness is ~1, 000 m or more.Theobjective of this work is to propose the control of groundwater quality in extraction boreholes when the dynamics of the governing flow systems is defined by establishing their hierarchy as proposed by the Groundwater Flow Systems (GFS).Understanding GFS and their role in extracted groundwater provides adequatestrategies for efficient water use and its corresponding planning and management.Usually boreholes response to groundwater extraction is a mixture of flows of different hierarchy.Vertical inflows increase their importance as drawdown progresses with extraction time.Results suggest climatic conditions may affect local flows.A joint groundwater monitoring for adequate managing is highly satisfactory ie.hydraulic data (water-level), physical (temperature) and chemical (specific element) data may be used to monitor expected response due to extraction. © 2014, Capital Publishing Company.

---

Entidades citadas de la UNAM:

---

Fuente:


ISBN:
9789381891254
Editorial:
Capital Publishing Company

Tipo de producto:
Conference Paper