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 = '633699' 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 = '633699' 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 = '633699']
®
ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 633699 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= 633699]
SIIA Público
SISTEMA INTEGRAL DE INFORMACIÓN ACADÉMICA - PÚBLICO
Título del libro: Earth Observation Advancements In A Changing World Título del capítulo: MONITORING THE GROWTH DYNAMICS OF WATER HYACINTH (EICHHORNIA CRASSIPES)
Monitoring; Water hyacinth; Eichhornia crassipes; Invasive species
Resumen:
The water hyacinth (Eichhornia crassipes) is a a highly invasive aquatic
plant which has negative impacts in bodies of water as declines in pH,
temperature, oxygen, nutrient levels and an increase of
evapotranspiration. In this study, multispectral images from the
PlanetScope constellation were used to assess the growth of the water
hyacinth in the dam of Cointzio, in central Mexico. The analysis showed
that, after the mechanical removal of the weeds in June 2017,
re-invasion began to emerge in September. In a period of three months,
the area covered by E. crassipes increased from 40 to 200 ha, which
corresponds to a relative increase of 400%, with an average growth of
1.5 ha/day. Based on the field measurements, a density of 200 tons of
fresh biomass per hectare was found, corresponding to 23.2 t/ha of dry
matter. These water hyacinth infestations are likely related with
pollution from agricultural run-off and rural and urban drainage. Due to
its high temporal and spatial resolutions, PlanetScope imagery enabled
the monitoring of the growth of the water hyacinth cover in a small
reservoir with a large number of observations. The data obtained can be
used to support water management actions and validate models.
Entidades citadas de la UNAM:
Fuente:
ISBN: 9788894468717 Editorial: ITALIAN SOC REMOTE SENSING
