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 = '498031' 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 = '498031' 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 = '498031']
®
ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 498031 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= 498031]
SIIA Público
SISTEMA INTEGRAL DE INFORMACIÓN ACADÉMICA - PÚBLICO
Título del libro: International Geoscience And Remote Sensing Symposium (igarss) Título del capítulo: Generation and assessment of MODIS time series using quality information
Autores UNAM: RENE ROLAND COLDITZ;
Autores externos: Idioma: InglésAño de publicación: 2006Palabras clave:
Africa; Biomass; Data reduction; Radar imaging; Radiometers; Time series analysis; Vegetation; Data quality; Land surface processes; Vegetation dynamics; Western Africa; Image quality
Resumen:
Monitoring and modeling extensive Earth surface processes for regional to global applications such as carbon budgeting or biomass estimation requires time series derived from remotely sensed imagery. Time series are also needed for discrimination of long-term land cover change from short-term variations, mapping of vegetation dynamics and improved land cover mapping and update. The results of these applications, however, clearly depend on the quality of the time series. Cloud coverage, high aerosol content, adverse view and illumination angles, or sensor defects affect and corrupt the data and may lead to false conclusions. Value-added MODIS data contain detailed pixel level quality information. This source of meta-data highly suits for data analysis or generation of time series. A software package, called Time Series Generator (TiSeG), has been developed to analyze data quality and estimate the quality of time series to be generated. TiSeG meets the challenge to weight the data quality against the quantity of available data for meaningful time series construction.
