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

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

Título del libro: Proceedings From International Conference: Soil - The Non-Renewable Environmental Resource
Título del capítulo: SOFTWARE FOR LAND EVALUATION (SOIL, WATER AND CLIMATE)

Autores UNAM:
FRANCISCO BAUTISTA ZUÑIGA;

---

Autores externos:

---

Idioma:

---

Año de publicación:
2016

---

Palabras clave:

environmental soil functions; soil profile; water quality; climate change; agroclimatic analysis

---

Resumen:

Given the global environmental crisis and its association with soil degradation, climate change and water scarcity, there is a need for better decision making processes regarding agricultural land management. This in turn creates the need for systems that are able to manage, process and analyze large amounts of information. The aim of this study was to describe the creation and use of three different softwares. They were designed and developed using Eclipse as programming interface, Derby as database management system and Java as programming language. The Soils and Environment (S&E) software uses a few soil properties to perform environmental assessments of soil profiles. These assessments are performed qualitatively, considering Human life, Flora and fauna, Natural Archive and Cultural Archive, and quantitatively, considering Water Cycle (associated with field capacity and hydraulic capacity), Nutrient Cycle (cation exchange capacity), Heavy Metals (ph, cec, texture and structure), Means of Transformation (organic pollutants), Food and Biomass (field capacity, aeration capacity and effective cation exchange capacity), Filtration and Infiltration, and Organic carbon Stock. The software for evaluation of water quality for agriculture (Agriwater) was designed to evaluate the quality of irrigation water (salinity, sodicity, chlorine toxicity) and to identify water families. The transformation of units is done automatically. The Climate Change with Monthly Data (Clic-MD) software was designed to analyze climate change trends at the local level using monthly data; with Click-MD, we can make up to 432 graphs of indicators of climate change per weather station. S&E, Agriwater and Clic-MD facilitate the management of large databases, which in turn improves staff productivity and related data management, and reduces the time of analysis by more than 90%.

---

Entidades citadas de la UNAM:

---

Fuente:


ISBN:
9788075094131
Editorial:
MENDEL UNIV BRNO

Tipo de producto:
Proceedings Paper