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 = '614772' 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 = '614772' 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 = '614772']
®
ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 614772 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= 614772]
SIIA Público
SISTEMA INTEGRAL DE INFORMACIÓN ACADÉMICA - PÚBLICO
Título del libro: American Society For Photogrammetry And Remote Sensing Annual Conference 2010: Opportunities For Emerging Geospatial Technologies Título del capítulo: Assessing simulated land use/cover maps using similarity and fragmentation indices
Fragmentation index; Fuzzy similarity; Global environmental change; Land use/cover; Land use/cover change; Landscape pattern; Model assessment; Simulation procedures; Spatial patterns; Biodiversity; Fuzzy logic; Photogrammetry; Remote sensing; Computer simulation
Resumen:
Land use/cover changes (LUCC) are significant to a range of issues central to the study of global environmental change. Over the last decades, a variety of models of LUCC have been developed to predict the location and patterns of land use/cover dynamics. The simulation procedures of most computational LUCC models can be sub-divided into three basic steps, 1) a non-spatial procedure which calculates the quantity of each transition, 2) a spatial procedure which allocates changes to the more likely locations and eventually replicates the patterns of the landscape and, 3) an evaluation procedure which compares a simulated land use/cover map with the true map of the same date. However, most of the evaluation techniques are focused in assessing the location of the simulated changes in comparison with the true changes and do not assess the ability of the model to simulate the landscape patterns (e.g. size, shape and distribution of patches). This study aims at evaluating simulated land use/cover maps obtained by two models (DINAMICA and Land Change Modeler). Simulated maps were evaluated using a fuzzy similarity index which takes into account the fuzziness of location within a cell neighborhood and fragmentation indices. Results show that more realistic simulated landscapes are often obtained at the expense of the location coincidence. When patterns of landscape are important (e.g. when considering fragmentation effects on biodiversity), it is important to incorporate indices that take into account the spatial patterns, and not merely location, during the model assessment procedure.