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 = '544451' 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 = '544451' 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 = '544451']
®
ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 544451 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= 544451]
SIIA Público
SISTEMA INTEGRAL DE INFORMACIÓN ACADÉMICA - PÚBLICO
Título del libro: Sustainable Development In Peripheral Regions Título del capítulo: A NATURAL ENVIRONMENT AND CULTURAL LANDSCAPE APPROACH TO COMMUNITY RURAL HERITAGE PRESERVATION
Autores UNAM: ALEJANDRO CABEZA PEREZ;
Autores externos: Idioma: Año de publicación: 2015Palabras clave:
natural and cultural heritage; vernacular architecture; native plants; community identity; landscape design
Resumen:
This paper focuses on natural and cultural heritage loss in small rural
communities in Central Mexico in order to find practical ways of
improving living conditions through design, related to environment care,
heritage preservation, and community identity. Due to rural urbanization
in the vicinity of metropolitan areas and emigration to the United
States, heritage values are significantly diminished in these areas,
having an impact on community identity. Finding a link between regional
ecosystems (native plants) and vernacular architecture could make people
conscious about their natural and cultural heritage and how this relates
to their sense of community identity. In this article traditional
dwellings and the surrounding indigenous vegetation in a Hidalgo State
community are being analyzed with a view to the selection of potential
native species to be used in an open landscape design. This selection
and its design potential are identified as an important link to prevent
heritage loss and to provide a sense of regional identity to rural
communities. Moreover, it is important to integrate heritage values into
the architectural design process which also should consider community
participation.
Entidades citadas de la UNAM:
Fuente:
ISBN: 9788323520573 Editorial: WARSAW UNIVERSITY PRESS