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

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

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: Groundwater sources in semi-arid regions and their vulnerability to climate change: Drâa catchment, Morocco

Autores UNAM:
JOSE JOEL CARRILLO RIVERA; GUILLERMO DE JESUS HERNANDEZ GARCIA; MIGUEL ANGEL RAMIREZ BELTRAN;

---

Autores externos:

---

Idioma:
Inglés

---

Año de publicación:
2014

---

Palabras clave:

Aquifers; Catchments; Climate change; Groundwater; Groundwater flow; Natural resources; Rain; Water management; 3D modelling; Flow systems; Groundwater dynamics; Groundwater flow systems; Groundwater sources; Hydraulic properties; Isotopic properties; Recharge; Groundwater resources

---

Resumen:

Water availability in Drâa basin (surface area~115, 000 km2) depends on rainfall, melting snow in the High Atlas mountains and groundwater. The region has strong evidence of groundwater flow presence whose functioning is required to be fully understood to achieve an adequate water management for an expected rainfall reduction. Previous objectives of carried out studies in the region included the aquifer unit theory and water-balance, lacking a 3D groundwater flow understanding. A regional approach allowing a clearer perspective of groundwater dynamics in its geological context was applied: the Groundwater Flow Systems Theory, which identifies local, intermediate and regional flows hierarchy. The conceptual 3D model included: hydraulic heads, hydraulic properties of rock units, soil type, vegetation, and geomorphology which are in agreement with the physical, chemical and isotopic properties of groundwater. This model was implemented, calibrated and validated using Visual Modflow. Obtained initial-heads were subjected to different recharge conditions; results show that change in recharge is more affecting local flows. However, in the Middle Drâa sub-basin where intermediate flows were identified, the simulated heads lack immediate response to the variation of recharge. Results suggest that local flows are more likely to be affected by climate conditions than those of intermediate and regional nature. © 2014, Capital Publishing Company.

---

Entidades citadas de la UNAM:

---

Fuente:


ISBN:
9789381891254
Editorial:
Capital Publishing Company

Tipo de producto:
Conference Paper