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

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

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: Identification of archaeological sites in ancient agricultural terraces in Teotihuacán, Mexico

Autores UNAM:
ARMANDO PERALTA HIGUERA; JORGE PRADO MOLINA;

---

Autores externos:

---

Idioma:

---

Año de publicación:
2006

---

Palabras clave:

Aerial images; Agricultural soils; Archaeological site; Balloon flights; Domestic activity; Low altitudes; Me-xico; Near Infrared; Pixel size; Potential sites; Scientific information; Underground radar; Aerial photography; Electric conductivity; Landforms; Photographic equipment; Remote sensing; Video recording; Agriculture

---

Resumen:

The analysis of color and near-infrared aerial images of a hill shaped with ancient agricultural terraces, allowed for the identification of dwellings from Aztec and early colonial times, and also from much older Teotihuacán-age settlements. Spots with regular shapes could be detected under the current agricultural soil, which guided further studies with underground radar and electric conductivity, from which the extents of foundations were determined. This led to the excavation of a house, that most probably was occupied by artisans specialized in the processing of maguey fibers. The recovery of large amounts of household items, food and tools of the trade, provides an insight of the everyday life of common people, which has been much less studied than the monumental and ceremonial sites. The results are considered an important step towards the study of agriculture, industry and domestic activities in the Teotihuacán Valley, which has been highly populated for centuries. Aerial images with varying pixel sizes were obtained from airplanes and low altitude balloon flights, between 1999 and 2005. The analysis has shown several other potential sites that will be investigated in the mid-term, as interest and scientific information build up.

---

Entidades citadas de la UNAM:

---

Fuente:


ISBN:
9781604236057
Editorial:

Tipo de producto:
Conference Paper