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

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

Título del libro: American Society For Photogrammetry And Remote Sensing - 20th Biennial Workshop On Aerial Photography, Videography, And High Resolution Digital Imagery For Resource Assessment 2005
Título del capítulo: Quantification of irregular settlements over conservation land in southern Mexico City

Autores UNAM:
ARMANDO PERALTA HIGUERA; CLEMENCIA SANTOS CERQUERA; JORGE PRADO MOLINA; ADRIAN GUILLERMO AGUILAR MARTINEZ;

---

Autores externos:

---

Idioma:

---

Año de publicación:
2006

---

Palabras clave:

Affected area; Atmospheric conditions; Classification methods; Conservation lands; Digital imagery; Extracting information; Mexico City; Multi-spectral; Multi-spectral analysis; Positional accuracy; Protected areas; Small area; Urban areas; Aerial photography; Conservation; Photographic equipment; Remote sensing; Video recording; Surveys

---

Resumen:

Two aerial digital surveys were performed in 2001 and 2005 over a 1,530 km2 area south of Mexico City, in order to detect and quantify invasion from settlements, agriculture and logging over conservation land and natural protected areas. In this work, we present the methodology used for extracting information by stereo interpretation and multispectral analysis, as well as for quantification and mapping of affected areas. We discuss the performance of multispectral digital imagery and the difficulties involved in dealing with large-area surveys. In the case study presented, images cover urban areas over flat ground as well as foothills and high-mountain forests, and each survey took several days. This variability together with local atmospheric conditions represent a challenge when trying to apply automated image classification methods and also to obtain mosaics with uniform appearance. Positional accuracy is also an issue, because it is necessary to correctly locate and measure numerous settlements, that individually may occupy a very small area, but nevertheless sum to a significant part of the total area affected. The results of this type of analysis produce large amounts of geocoded data that can only be managed, queried and further analyzed by means of a GIS.

---

Entidades citadas de la UNAM:

---

Fuente:


ISBN:
9781604236057
Editorial:

Tipo de producto:
Conference Paper