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 = '702890' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NOT NULL;]
SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '702890' 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 = '702890' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NULL;]
SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '702890' 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 = '702890']
SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = '702890'

ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 702890 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= 702890]
SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 702890 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= 702890

Título del libro: Arid And Semi-Arid Zones Of Mexico: A Comprehensive Exploration Of Biodiversity, Ecology, And Conservation
Título del capítulo: Participatory territorial planning: A knowledge management-based tool for socioecological analysis in arid zones

Autores UNAM:
VICTOR MANUEL SALAZAR ROJAS; HUMBERTO MACIAS CUELLAR; MAYRA MONICA HERNANDEZ MORENO; CESAR MATEO FLORES ORTIZ; PATRICIA DOLORES DAVILA ARANDA;

---

Autores externos:

---

Idioma:

---

Año de publicación:
2025

---

Palabras clave:

Arid regions; Ecology; Environmental management; Knowledge based systems; Knowledge management; Natural environment; Sustainable development; Arid zones; Community participation; Community territorial planning; Ecological resilience; Geographic information; Interdisciplinary collaborations; Mixtecum poblana region; Resource management; Socio-ecological; Territorial planning; Land use

---

Resumen:

This chapter examines participatory land use planning as a knowledge management tool for socioecological analysis in arid zones. It underscores the deep interdependence of social and ecological systems, advocating for an integrated management approach to tackle the complex challenges inherent in these environments. This approach is especially critical in Mexico's arid and semiarid regions, where the convergence of ecological fragility and social vulnerability makes sustainable management a pressing necessity. The Knowledge Management (KM) model is operationalized through the establishment of Citizen Science Nodes, which serve as platforms for collaboration among local stakeholders, academic researchers, and government agencies. These nodes enable a more inclusive and informed decisionmaking process by integrating diverse perspectives and various knowledge systems. The KM model uniquely merges traditional, locally rooted knowledge with contemporary scientific insights, fostering a comprehensive approach to community territorial planning to ensure thorough analysis and planning. Participatory methodologies, such as social mapping and community workshops, are employed. Accordingly, in this chapter, the construction process of an analytical model is derived from three case studies carried out in the Mixteca Poblana region and the accumulated field experience during the past nineteen years. In this model, traditional agricultural practices and ancestral knowledge are key factors in achieving ecological sustainability. Additionally, this chapter addresses modern challenges such as urbanization and globalization, which have a significant impact on the resilience of complex socioecological systems. The main findings suggest that integrating a socioecological approach with effective knowledge management not only strengthens community participation but also enhances resilience, offering a highly adaptable framework for sustainable natural resource management in arid zones. © 2025 Bentham Science Publishers. All rights reserved.

---

Entidades citadas de la UNAM:

---

Fuente:


ISBN:
9789815322460
Editorial:
Bentham Science Publishers

Tipo de producto:
Book chapter

DOI:
10.2174/9789815322460125010013