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 = '266120' 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 = '266120' 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 = '266120' 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 = '266120' 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 = '266120']
SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = '266120'

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

Título del libro: Gistam 2015 - 1st International Conference On Geographical Information Systems Theory, Applications And Management, Proceedings
Título del capítulo: Local deforestation patterns in Mexico an approach using geographiccally weighted regression

Autores UNAM:
JEAN FRANCOIS RAYMOND MARIE MAS CAUSSEL; GABRIELA CUEVAS GARCIA;

---

Autores externos:

---

Idioma:
Inglés

---

Año de publicación:
2015

---

Palabras clave:

Deforestation; Forestry; Geographic information systems; Highway administration; Information systems; Regression analysis; Roads and streets; System theory; Deforestation patterns; Dependent variables; Economical parameters; Geographically weighted regression; Geographically weighted regression models; Me-xico; Spatial variations; Weighted regression; Information management; Data Bases; Deforestation; Mathematical Models; Mexico; Regression Analysis

---

Resumen:

This study identifies drivers of deforestation in Mexico by applying Geographically Weighted Regression (GWR) models to cartographic and statistical data. A wall-to-wall multitemporal GIS database was constructed incorporating digital data from Global Forest Change (2000-2012); along with ancillary data (road network, settlements, topography, socio-economical parameters and government policies). The database analysis allowed assessing the spatial distribution of deforestation at the municipal level. The statistical analysis of deforestation drivers presented here was focused on the rate of deforestation during the period 2007-2011 as dependent variable. In comparison with the global model, the use of GWR increased the goodness-of-fit (adjusted R2) from 0.46 (global model) to 0.58 (average R2 of GWR local models), with individual GWR models ranging from 0.52 to 0.64. The GWR model highlighted the spatial variation of the relationship between the rate of deforestation and its drivers. Factors identified as having a major impact on deforestation were related to topography (slope), accessibility (road and settlement density) and marginalization. Results indicate that some of the drivers explaining deforestation vary over space, and that the same driver can exhibit opposite effects depending on the region.

---

Entidades citadas de la UNAM:

---

Fuente:


ISBN:
9789897580994
Editorial:
SciTePress

Tipo de producto:
Conference Paper