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 = '518718' 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 = '518718' 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 = '518718']
®
ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 518718 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= 518718]
SIIA Público
SISTEMA INTEGRAL DE INFORMACIÓN ACADÉMICA - PÚBLICO
Título del libro: Proceedings Of The Iasted International Conference On Signal And Image Processing, Sip 2009 Título del capítulo: Toward automated detection of oil drops in images of multiphase dispersions
Autores UNAM: GABRIEL ISAAC CORKIDI BLANCO;
Autores externos: Idioma: InglésAño de publicación: 2009Palabras clave:
Automated detection; Circle detection; Detection of circles; Detection technique; Fast radial symmetry; Generalized Hough transform; Gradient orientations; Ground truth; Multiphase dispersion; Oil drops; Radial symmetry operator; Radial symmetrys; Digital image storage; Dispersions; Drops; Hough transforms; Image segmentation; Imaging systems; Internet protocols; Mathematical transformations; Signal detection; Template matching; Wavelet transforms; Image matching
Resumen:
The performance of three different circle-detection techniques is compared in the context of automated detection of oil drops in images obtained from a stirring tank containing a simple multiphase dispersion. The techniques compared are: the generalized Hough transform for detection of circles, the Fast Radial Symmetry operator proposed by Loyd & Zelinski, and a Template Matching procedure based on gradient orientation. A ground truth set formed by 1459 oil drops extracted from 241 images was used to compare the performance of the mentioned methods. The results reported indicate that Fast Radial Symmetry is superior in the task.
