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

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

Título del libro: Asme International Mechanical Engineering Congress And Exposition, Proceedings (imece)
Título del capítulo: ENHANCING ACCESS TO WATER IN MEXICO CITY AND ITS PERI-URBAN AREA THROUGH USER CENTERED DESIGN

Autores UNAM:
ADRIELLY NAHOMEE RAMOS ALVAREZ; ALEJANDRO CUAUHTEMOC RAMIREZ REIVICH; MARIA DEL PILAR CORONA LIRA; VICENTE BORJA RAMIREZ; FRANCISCA IRENE SOLER ANGUIANO;

---

Autores externos:

---

Idioma:

---

Año de publicación:
2021

---

Palabras clave:

Filtration; Internet of things; Design thinking; Iot; Me-xico; Mexico City; Peri-urban areas; Pipeline networks; Rainwater harvesting; Services network; Water service; Water trucks; User centered design

---

Resumen:

Lack of water in Mexico City and its peri-urban area has been an increasingly worrying matter in the last few years and has been addressed through multiple government and NGO initiatives such as supplemental delivery via water trucks, rainwater harvesting, intermittence in water services and pipeline network maintenance. However, the rapid and unstructured development of the urban spot has exacerbated the problem, rendering these solutions ineffective. Due to the complexity of the problem, solutions may be more impactful if they focus on fixing or creating effective interactions among the elements of the system-interactions in which the main element is the user. This paper presents a design proposal created from the observations made in Mexico City. Design Thinking was used by understanding the users' needs and the interactions between the agents through three main phases: Approach and definition of the problem, Prototyping stage and Final proposal explanation. The proposal and research results could be used and extrapolated to other cities and communities around the world, as water availability and quality are a global challenge and can be tackled in similar ways. Copyright © 2021 by ASME.

---

Entidades citadas de la UNAM:

---

Fuente:


ISBN:
9780791885604
Editorial:
American Society of Mechanical Engineers (ASME)

Tipo de producto:
Conference Paper

DOI:
10.1115/IMECE2021-72090