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 = '323186' 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 = '323186' 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 = '323186']
®
ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 323186 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= 323186]
SIIA Público
SISTEMA INTEGRAL DE INFORMACIÓN ACADÉMICA - PÚBLICO
Título del libro: Species Diversity And Extinction Título del capítulo: Threatened temperate plant species: Contributions to their biogeography and conservation in Mexico
Autores UNAM: MERCEDES ISOLDA LUNA VEGA;
Autores externos: Idioma: InglésAño de publicación: 2011Resumen:
Many species of vascular plants inhabiting the Mexican temperate forests are threatened by continuous environmental impact, mainly due to human activities. Some are recorded in some risk category in the Mexican official publication named 'Norma Oficial Mexicana 059' (NOM-059-ECOL-2001), in the IUCN red lists (the World Conservation Union) or in CITES (Convention on International Trade in Endangered Species). Distribution maps of 31 threatened species of vascular plants were generated or updated with information obtained from institutional databases, herbarium specimens, field work, and specialized literature; with this information, we analyzed species richness, endemism and distributional patterns. Mexican territory was divided using a grid system based on a chart index (scale 1:50,000 composed system by grids of 15' x 20'). Factors that represent a threat for these species, to their current habitats and natural populations are discussed, and some strategies are proposed to prevent their extinction. Regarding conservation, we evaluated their geographic distribution based on current Mexican National Protected Areas (NPAs) and Mexican Priority Terrestrial Regions for Conservation (PTRs). We also suggest the urgent incorporation of some of these species in the recent IUCN Red Data List of Threatened Species (2009) and in the NOM-059. Most of the grid-cells with high diversity and endemism are located in eastern Mexico, and are especially associated with mountain landscapes. Among the factors that represent a threat, we concluded that the main problem for all species is habitat destruction, due to increase in agricultural areas, forest exploitation, and animal husbandry, followed by expansion of human settlements, illicit extraction, and traffic of plants. Most of the species studied require special policies for their conservation due to problems that affect their natural populations. Conservation strategies include: (1) demographic and ecological studies of these species; (2) collection of seeds and vegetative propagation for ex situ conservation in botanical gardens; (3) targeting of specific areas where these species inhabit, in order to include them in future conservation plans. With few exceptions, these species are underrepresented in the current Mexican System of Natural Protected Area
Entidades citadas de la UNAM:
Fuente:
ISBN: 9781616683436 Editorial: Nova Science Publishers, Inc.Nombre de la publicación: Threatened temperate plant species: Contributions to their biogeography and conservation in Mexico Página inicial: 318 Página final: 339