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

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

Título del libro: Proceedings Of 6th International Conference On Recent Advances In Space Technologies (rast 2013)
Título del capítulo: Satellite project Quetzal UNAM-MIT

Autores UNAM:
CARLOS ROMO FUENTES; SAUL DANIEL SANTILLAN GUTIERREZ; JOSE ALBERTO RAMIREZ AGUILAR; SAUL DE LA ROSA NIEVES; MICHEL ALEXANDRE GRUTTER DE LA MORA; EMILIO ATAULFO SANCHEZ MEDINA; JORGE PRADO MOLINA; JORGE ALFREDO FERRER PEREZ;

---

Autores externos:

---

Idioma:

---

Año de publicación:
2013

---

Palabras clave:

collaboration; satellite project; pollution; COTs

---

Resumen:

The proposed project is related to the development of a microsatellite platform (50-70 kg) for research purposes. The first stage in the collaboration between the National Autonomous University of Mexico (UNAM) and the Massachusetts Institute of Technology (MIT) included the technical specification and conceptual design through the definition of mission requirements and early-stage development of spacecraft subsystems. The mission is to monitor air pollutant concentrations in urban areas from LEO orbit. Air pollution is one of the main problems urban environments face today. A key aspect in mitigating negative effects of pollution on society, in particular in highly populated areas such as Mexico City, resides in understanding how contaminants accumulate and disperse under diverse conditions, through modeling and tracking of different pollutants in the air. Currently, this task is performed by ground systems, and missions from NASA and ESA, which does not provide coverage on frequency and timing needed for Mexico City and other urban concentrations in Latin-America. Furthermore, the information processing is sometimes cumbersome and the development cost is prohibitive for non-space fairing nations in a mission like ENVISAT. Project proposal contributes methodological and systems approach for a microsatellite platform of Mexican design for scientific research. Project is joint collaboration with MIT and funding will be obtained from Mexican sources. Further institutions from Mexico will be involved. The goal is to speed up collaboration by student exchange, mirroring groups in a dedicated task force. The timing of this collaboration is ideal, since Mexico will organize and start to operate its recently created space agency.

---

Entidades citadas de la UNAM:

---

Fuente:


ISBN:
9781467363969
Editorial:
IEEE

Tipo de producto:
Proceedings Paper