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

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

Título del libro: Technological And Digital Risk: Research Issues
Título del capítulo: Perception and communication of environmental risks in big cities

Autores UNAM:
EVA LETICIA ORTIZ AVALOS;

---

Autores externos:

---

Idioma:

---

Año de publicación:
2020

---

Resumen:

Eva Leticia Ortiz ?The way of life in cities has become the cornerstone of environmental issues in modern times. Cities have been rapidly reproduced throughout the world in recent times. The proportion of the population that lives in urban areas has increased from 5 % to 50 % during the last two centuries? (Mitchell 2001, pp. 1-14). The human population is in the process of- irremediable urban transformation. Cities have historically been associated with the evolution and advancement of technology, economy and society. Paradoxically, in large cities, its inhabitants face different types of risks: from space saturation and traffic accidents to noise and air pollution. But urban life also offers benefits to its society; the urban environment displays enormous diversity, constitutes stimulating environments, and offers numerous opportunities. In our increasingly urban society, we ask ourselves if the population considers urban-architectural aspects of the city as environmental risks, and so we consider the possibility of adding them to the original list defined in the literature for civil protection, where only the hydrological and meteorological factors, geological factors, physical-chemical factors, health factors, and socio-organizational factors are recorded The urban-architectural factors, from our point of view, were not contemplated in any of the existing categories; but, due to their impact, they should form an independent category, a separate group. We integrate it with spectacular advertisements, visual contamination, buildings with structural damage, poor drainage, high buildings, lack of green spaces, underground gas networks, noise from cars,?. © Peter Lang GmbH Internationaler Verlag der Wissenschaften Berlin 2020.

---

Entidades citadas de la UNAM:

---

Fuente:


ISBN:
9783631827093
Editorial:
Peter Lang Publishing Group Nombre de la publicación:
Perception and communication of environmental risks in big cities
Página inicial:
289
Página final:
299

Tipo de producto:
Capítulo de un Libro