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

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

Título del libro: American Society For Photogrammetry And Remote Sensing Annual Conference, Asprs 2013
Título del capítulo: Trophic state determination by multispectral satellite images: Chapala lake, Mexico

Autores UNAM:
ROSA MARIA PROL LEDESMA;

---

Autores externos:

---

Idioma:
Inglés

---

Año de publicación:
2013

---

Palabras clave:

Chlorophyll a; Fresh water resources; Governmental institution; Herbicide application; Multi variate analysis; Multispectral satellite image; Nutrient concentrations; Waterbodies; Agriculture; Chlorophyll; Economics; Eutrophication; Fertilizers; Herbicides; Photogrammetry; Remote sensing; River pollution; Turbidity; Vegetation; Water resources; Weed control; Lakes

---

Resumen:

The Chapala Lake is the largest fresh water resource in Mexico and it provides more than 50% of the water consumed by the second largest city-Guadalajara. Agriculture represents the most important economic activity in the basin and, as a consequence, soils are degraded and require larger amounts of fertilizers. A large proportion of the nutrient-rich fertilizers used in the agricultural areas within the basin are transported by the Lerma River, which is the main tributary to the Chapala Lake. As a result, eutrophication of the lake has been a problem for many years and aquatic vegetation has been the main manifestation of this problem; therefore, the governmental institutions response has been to remove the vegetation using herbicides that affect the calculation of an actual value of Trophic State Index (TSI) by the traditional methods. Here, we present the results obtained by application of three different TSI models to the Chapala Lake: Carlson, Wezernak and Brezonik. Carlson's model is based on data of transparency, chlorophyll-a or total phosphorus, while the last two models utilize multivariate analysis of several parameters that include: nutrient concentration, primary productivity and the optic properties of water disturbed by eutrophication and are commonly expressed as a turbidity increase. The input data for the models were obtained by processing multispectral satellite images and the results were subjected to field verification that was carried away in the same date that images were acquired. Obtained results show that the chlorophyll-based model yield low TSI values due to the herbicide application, while the turbidity models provide big TSI values. Copyright © (2013) by the American Society for Photogrammetry & Remote Sensing.

---

Entidades citadas de la UNAM:

---

Fuente:


ISBN:
9781629930718
Editorial:

Tipo de producto:
Conference Paper