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 = '520560' 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 = '520560' 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 = '520560' 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 = '520560' 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 = '520560']
SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = '520560'

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

Título del libro: 13th European Conference On Antennas And Propagation, Eucap 2019
Título del capítulo: Impact of Heavy Rain on Signal Propagation in the UK and Mexican 4G and 5G Networks

Autores UNAM:
VICTOR RANGEL LICEA;

---

Autores externos:

---

Idioma:
Inglés

---

Año de publicación:
2019

---

Palabras clave:

Application programs; Developing countries; Floods; Internet of things; Mobile telecommunication systems; Numerical methods; Queueing networks; Rain; Ray tracing; Surface waters; Wireless sensor networks; Cellular network; Connected objects (IoT and WSN); Experimental methods; Flood warning system; Internet of Things (IOT); Mobile phone networks; Ray tracing simulation; Simulation technique; 5G mobile communication systems

---

Resumen:

Wireless sensor networks are a current area of interest for many researchers, however surprisingly few have actually been deployed. In this paper we present preliminary results from a series of experiments designed to assess the viability of using existing mobile phone networks in developing countries to create flood warning systems. Creation of a flood warning network involves placing wirelessly connected nodes on all significant tributaries of a river system often over several hundreds of square kilometres. Rain is one of the principal causes of signal change in mobile networks. To assess the effect of the above on associated Internet of Things (IoT) flood alert systems, measurements were conducted in the UK and Mexico to determine the attenuation of line of sight (LOS) and ground multipath propagation due to either rain or excess surface water. Both components are analysed using ray tracing simulation software in addition to the real-time field measurements with the mobile hand set 'app' G-NetTrack Pro. Measurement experience gleaned from the UK campaign has been used to formulate a more comprehensive hand set based strategy in the Colima flood zone in Mexico, the results of which are also summarized in this paper. It is believed that both the above measurement and ray trace modelling exercises may be used to further optimize protocols required to address the propagation needs of future 4G/5G networks. © 2019 European Association on Antennas and Propagation.

---

Entidades citadas de la UNAM:

---

Fuente:


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

Tipo de producto:
Conference Paper