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 = '346891' 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 = '346891' 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 = '346891']
®
ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 346891 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= 346891]
SIIA Público
SISTEMA INTEGRAL DE INFORMACIÓN ACADÉMICA - PÚBLICO
Título del libro: Advances In Air Pollution Título del capítulo: Modelling air pollution in an industrial area using GIS as an assessment tool
Autores UNAM: MIRNA GUEVARA GARCIA;
Autores externos: Idioma: Año de publicación: 2001Palabras clave:
Emission inventory; Industrial areas; Source inventories; Spatial data; Computer simulation; Contamination; Environmental impact; Gas emissions; Geographic information systems; Inventory control; Sampling; Air pollution
Resumen:
To asses the air pollution impact to the city of Mendoza, from a nearby industrial park, a model was developed based on a Geographical Information System (GIS). This system is used to evaluate the emission-immission patterns due to its ability to handle spatial data, source inventories, measurements and meteorology data. To evaluate the industrial park environmental data was gathered from a) continuous monitoring of NOx, O 3, CO and total particles (TSP) at different sites in the area, b) several, fixed stations of 24 h measurements of NOx, SO 2, TSP and Pb, c) samples of particulate matter using a high volume pump at several measuring points, d) local meteorology and e) an emission inventory of the industrial park. The results of the model for different conditions will be presented for the main contaminants. Emission from vehicles where also considered in the urban area which permits a comparative evaluation of the impact of fixed sources to mobile sources.
