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 = '614672' 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 = '614672' 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 = '614672']
®
ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 614672 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= 614672]
SIIA Público
SISTEMA INTEGRAL DE INFORMACIÓN ACADÉMICA - PÚBLICO
Título del libro: Second Latino-American Seminar On Radar Remote Sensing Image Processing Techniques Título del capítulo: A supervised classifier for multispectral and textured images based on an automated region growing algorithm
A couple of supervised classifiers to segment optical multispectral images and textured radar images have been developed. In both classifiers, an automated region-growing algorithm delineates the training sets. Optimum statistics for defined classes are derived from the training sets. This algorithm handles three parameters: an initial pixel seed, a window and a threshold for each class. A suitable pixel seed is manually implanted through visual inspection of the image classes. The optimum value for the window and the threshold are obtained from spectral or texture distances. These distances are calculated from mathematical models of spectral and textural separabilities. A pixel is incorporated into a region if a spectral or texture homogeneity criterion is satisfied in the pixel-centered window for a given threshold. In this scheme, a region grows as much as possible but maintains the overlap with other regions in a minimum . The homogeneity criterion is obtained from the models of spectral and texture distances. The set of pixels forming a region represents a statistically valid sample of a defined class signaled by the initial pixel seed. The grown regions constitute therefore optimum training sets for each class. The statistical behavior of these training sets is used to classify the pixels of the image in one member of a set of classes. Comparing the statistical behavior of a sliding window with that of each class does the classification. The size of this window is the same as the one employed in the region-growing algorithm. The centered pixel of the sliding window is labeled as belonging to a class if its spectral or texture distance is a minimum to the class. Such distance is evaluated using the statistical content of the class and the sliding window as input to the model of spectral or textural separability. A series of examples employing synthetic and natural images, are presented to show the value of this classifier. The goodness of the segmentation is evaluated by means of the Kappa coefficient and a matrix of distances derived from the mentioned model.