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

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

Título del libro: 19th Symposium On The Application Of Geophysics To Engineering And Environmental Problems, Sageep 2006: Geophysical Applications For Environmental And Engineering Hazzards - Advances And Constraints
Título del capítulo: The wigner-ville transform, an approach to interpret GPR data: The Mexico City case

Autores UNAM:
MARTHA ANGELICA ELIZONDO SAMANO; RENE EFRAIN CHAVEZ SEGURA; ANDRES TEJERO ANDRADE; ELSA LETICIA FLORES MARQUEZ;

---

Autores externos:

---

Idioma:

---

Año de publicación:
2006

---

Palabras clave:

Geophysics; Spectrum analysis; Stratigraphy; Structural geology; Wigner-Ville distribution; Cross correlations; Statistical approach; Stratigraphic columns; Structural anomaly; Time and frequencies; Time frequency analysis; Wigner-Ville transform; WignerVille distribution (WVD); Geophysical prospecting

---

Resumen:

In this investigation, a time-frequency analysis is performed, based in the decomposition of the GPR signal in high- and low-frequencies. This process is combined with a statistical approach to detect signal changes in time and frequency simultaneously. The spectral analysis is carried out through the Wigner-Ville distribution (WVD). A cross-correlation can be computed between the original signal and the time-frequency components to obtain structural anomalies in the GPR observations, and to perform a correlation with the available geology. An example of this methodology is presented, where a series of traces where analyzed from a GPR profile surveyed in an eastern area of Mexico City. This is a heavily urbanized region built on the bottom of an ancient lake. The sediments are poorly consolidated and the extraction water rate has increased the areas of subsidence. Nowadays, most of family homes and public buildings, mainly schools have started to suffer heavy damages. The geophysical study carried out in the area permitted to detect areas of high risk. The data analysis combined with previous geological studies, which included stratigraphic columns allowed to identify the geophysical characteristics of the area, which will allow to the authorities to plan the future development of the area.

---

Entidades citadas de la UNAM:

---

Fuente:


ISBN:
9781622760657
Editorial:
Environmental and Engineering Geophysical Society (EEGS)

Tipo de producto:
Conference Paper

DOI:
10.4133/1.2923686