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

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

Título del libro: 18th International Conference On Soil Mechanics And Geotechnical Engineering: Challenges And Innovations In Geotechnics, Icsmge 2013
Título del capítulo: Pioneer application of a dynamic penetrometer and horoscope in archeological prospecting

Autores UNAM:
LUIS ALBERTO BARBA PINGARRON; EFRAIN OVANDO SHELLEY; GABRIEL YVES ARMAND AUVINET GUICHARD; ENRIQUE IBARRA RAZO;

---

Autores externos:

---

Idioma:
Inglés

---

Año de publicación:
2013

---

Palabras clave:

Cracks; Deposits; Floors; Geophysical prospecting; Geotechnical engineering; Mechanical properties; Soil mechanics; Soils; Stratigraphy; Structures (built objects); Walls (structural partitions); Archaeological prospecting; Archeological prospecting; Archeology; Boroscopes; Dynamic penetrometers; Georadars; Geotechnical information; Mechanical characteristics; Dynamics

---

Resumen:

This paper presents a pioneer application of a geotechnical technique in archaeological prospecting. A light dynamic penetrometer, georadar and geo-boroscope were applied to determine the superficial stratigraphic profile at the Cacaxtla Gran Basamento archeological zone, in Mexico, in areas where walls and floors present important cracks. From the geotechnical point of view, the Gran Basamento is an artificial platform conformed by heterogeneous fills (mainly tuff rock fragments, silty and sandy soils) where pre-hispanic structures were built (from 450 bC to 900 aC). There is an important lack of knowledge about the mechanical characteristics and position of the soil deposits or buried archeological structures. The interpretation of the results shows that it is not only possible to obtain a very good idea of the characteristics and distribution of the superficial soil deposits, and to evaluate the origin of cracks and their mechanisms to avoid slope and wall instabilities, but that it is also possible to identify stages of construction of the pyramid for the hypothetical reconstruction of the layers and structures that conform this archeological monument. Based on the geotechnical information, pre-hispanic floors at different construction stages were correlated with high dynamic cone resistance and very loose granular material with low dynamic cone resistance, which was a risk condition in slope stabilization. Both conditions were verified visually with a geo-boroscope.

---

Entidades citadas de la UNAM:

---

Fuente:


ISBN:
9782859784782
Editorial:
IOS Press

Tipo de producto:
Conference Paper