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 = '496073' 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 = '496073' 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 = '496073']
®
ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 496073 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= 496073]
SIIA Público
SISTEMA INTEGRAL DE INFORMACIÓN ACADÉMICA - PÚBLICO
Título del libro: Advancing Culture Of Living With Landslides Título del capítulo: Multi-temporal Landslide Evaluation by Using UAV: Some Insights on Disaster Risk in Teziutlan, Puebla Mexico
This paper aimed at analyzing some insights related to landslide
disaster risk at local scale in a mountain region of Mexico by using an
Unmanned Aerial Vehicle (UAV). The developed methodology to produce UAV
derived imagery is presented. Point cloud LiDAR, the Digital Surface
Model (DSM) derivative, and the orthophoto generated have a resolution
of 0.05 m. Moreover, an analysis of the growth of human settlements at
local scale was carried out from 1942 to 2016, and related to landslide
exposure. The latter resulted from a landslide susceptibility map
produced with the DSM using the weight of evidence method. According to
the results, at the present time the France vicinity (Teziutlan, Puebla)
covers an area of 67.85 ha, although the inhabited surface is of 35.46
ha. In seven and a half decades, the size of the expansion of the
dwellings was increased seven-fold. The 54% of total surface can be
characterized as moderately or highly susceptible to landslides.
Likewise, estimations suggested that 52.27% (35.46 ha) of the total
surface of the neighborhood is occupied by households; out of which,
18.74 ha, the equivalent of 50.81% of the total inhabited area is
situated in the high and moderate landslide susceptibility zones.
