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 = '615443' 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 = '615443' 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 = '615443']
®
ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 615443 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= 615443]
SIIA Público
SISTEMA INTEGRAL DE INFORMACIÓN ACADÉMICA - PÚBLICO
Título del libro: Simultech 2012 - Proceedings Of The 2nd International Conference On Simulation And Modeling Methodologies, Technologies And Applications Título del capítulo: Simple fuzzy logic models to estimate the global temperature change due to GHG emissions
Atmospheric concentration; Climate sensitivity; Concentration values; Emission level; Fuzzy inference model; Fuzzy logic model; Fuzzy models; GHG emission; Global climate changes; Global temperature change; Input variables; Intergovernmental panel on climate changes; Linguistic rules; Radiative forcings; Temperature changes; Temperature increase; Atmospheric radiation; Atmospheric temperature; Climate change; Climate models; Fuzzy logic; Greenhouse gases
Resumen:
Future scenarios (through 2100) developed by the Intergovernmental Panel on Climate Change (IPCC) indicate a wide range of concentrations of greenhouse gases (GHG) and aerosols, and the corresponding range of temperatures. These data, allow inferring that higher temperature increases are directly related to higher emission levels of GHG and to the increase in their atmospheric concentrations. It is evident that lower temperature increases are related to smaller amounts of emissions and, to lower GHG concentrations. In this work, simple linguistic rules are extracted from results obtained through the use of simple linear scenarios of emissions of GHG in the Magicc model. These rules describe the relations between the GHG, their concentrations, the radiative forcing associated with these concentrations, and the corresponding temperature changes. These rules are used to build a fuzzy model, which uses concentration values of GHG as input variables and gives, as output, the temperature increase projected for year 2100. A second fuzzy model is presented on the temperature increases obtained from the same model but including a second source of uncertainty: climate sensitivity. Both models are very attractive because their simplicity and capability to integrate the uncertainties to the input (emissions, sensitivity) and the output (temperature).