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 = '514747' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NOT NULL;]
SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '514747' 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 = '514747' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NULL;]
SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '514747' 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 = '514747']
SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = '514747'

ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 514747 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= 514747]
SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 514747 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= 514747

Título del libro: Ieee Ica-Acca 2018 - Ieee International Conference On Automation/23rd Congress Of The Chilean Association Of Automatic Control: Towards An Industry 4.0 - Proceedings
Título del capítulo: Robotic vision assembly using FPGA

Autores UNAM:
JUAN MARIO PEÑA CABRERA; ROMAN VICTORIANO OSORIO COMPARAN; VICTOR MANUEL LOMAS BARRIE;

---

Autores externos:

---

Idioma:
Español

---

Año de publicación:
2019

---

Palabras clave:

Assembly; Automation; Computer vision; Field programmable gate arrays (FPGA); Industry 4.0; Manipulators; Process control; Robotic assembly; Vision; Acquisition device; Assembly process; Comparison result; Embedded; Feature recognition; Processor element; Real-time image acquisitions; Robot manipulator; Computer hardware description languages

---

Resumen:

An artificial visión system based in the BOF method implemented in a FPGA device is presented to locate and recognize rigid work pieces within an experimental workspace area, previous location is not known by a manipulator robotized element in order to grasp it and perform an assembly process (peg in hole) in real time. As the processor element a Nexys 4 development electronic FPGA card is used with Hardware Description Language (HDL) platform for its programming, and the OV7670 camera from OmniVision is used as the imaege acquisition device. Data is acquired, conditioned and processed to get information about location and feature recognition characteristics for the assembly process within an experimental manufacturing cell environment containing an educative robot manipulator of 6DOF. Two methods were used for comparison results resulting 50% success assembly for the first one when only using primitive descriptors of area an centroid and 96% success when BOF method was using. An assembly process was performed integrating the method in a single FPGA device. Having performed real time image acquisition and processing actions, the results shows the possibility of using this method for concurrent and fast assembly applications. © 2018 IEEE.

---

Entidades citadas de la UNAM:

---

Fuente:


ISBN:
9781538655863
Editorial:
Institute of Electrical and Electronics Engineers Inc.

Tipo de producto:
Conference Paper

DOI:
10.1109/ICA-ACCA.2018.8609764