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 = '384737' 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 = '384737' 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 = '384737']
®
ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 384737 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= 384737]
SIIA Público
SISTEMA INTEGRAL DE INFORMACIÓN ACADÉMICA - PÚBLICO
Título del libro: 19th Imeko World Congress 2009 Título del capítulo: Absolute calibratoin of optical flats throgout the self comparison and image processing
Optical flats are required for spreading accuracy to mechanical and optical instruments, ordinarily by optical interference. Traceability of optical flats is ordinarily made by Fizeau interferometer. Traceability of this one requires higher accuracy flats, not available in secondary laboratories. These laboratories can accede to absolute self-calibration principles, by a method proposed by Bernard [1], who compares three flats among them through Zernike polynomials [2], representing these last their topographies. Two problems are found when the process is intended to set up: (a) the Zernike polynomials have not easy geometric meaning and direct equivalence with CAD entities; (b) neither fringes nor levels of gray of interferograms have direct equivalences with the shape of flats or virtual membranes. For modelling shapes we adopted the self calibration concept of Bernard, but using b-splines models with ring shape, instead Zernike. This substitution offer important algebraic simplifications and possibilities for exporting shapes to CAD; supporting validation. For converting interferograms to shapes of membranes, three major problems are present: the aspect of patterns, the ambiguity in inflection areas, and the adequate interpretation of gray scales. After applying low pass filters to brightness, two methods were applied: (a) heuristic genetic, (b) inverse sine correlation of gray for relief. Success in interpretation of shape have been by now better than 75%.