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 = '541453' 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 = '541453' 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 = '541453']
®
ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 541453 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= 541453]
SIIA Público
SISTEMA INTEGRAL DE INFORMACIÓN ACADÉMICA - PÚBLICO
Título del libro: Handbook On Sustainability Transition And Sustainable Peace Título del capítulo: Sustainability Transition in a Vulnerable River Basin in Mexico
Sustainable development; engendered and sustainable peace; Anthropocene; peace concept; patriarchy; civilization; empowerment; equity; values; cultural identity
Resumen:
This chapter examines a transition process in a river basin in the
central part of Mexico that is highly affected by climate change, social
deterioration and the drugs war. The Yautepec River Basin is
particularly prone to climate impacts because of its abrupt slopes,
numerous affluents, and high population density in its floodplain, which
is frequently exposed to hurricane impacts. Taking into account
laissez-faire policies, illegality, government corruption, and public
insecurity in a region with high levels of dual vulnerability
(environmental and social), as well as subject to hazard impacts, the
chapter reviews the constraints of the process of transition towards
sustainability, especially when the goals of the people and of the
government are not identical. People organized themselves regionally in
order to simultaneously increase public security and freedom from hazard
impacts, which both directly affect life and livelihood. Using original
survey data, the study examines the risks perceived by the people and
the ways in which they reduce these risks of extreme events, as well as
how they cooperate with the authorities to improve environmental
conditions, to enhance disaster risk reduction activities and to reduce
the impact of criminal acts. The transition process requires the
integration of numerous social, economic, political, environmental,
judicial, cultural and mental factors in order to develop processes and
resilience from the bottom up to deal with this complex emergency, as
well as to force the different levels of government to enhance all four
aspects of the human security of the people: `freedom from fear',
`freedom from want' `freedom from hazard impacts', and `freedom to live
in dignity'.
Entidades citadas de la UNAM:
Fuente:
ISBN: 9783319438849 Editorial: SPRINGER INTERNATIONAL PUBLISHING AG