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 = '648034' 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 = '648034' 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 = '648034']
®
ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 648034 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= 648034]
SIIA Público
SISTEMA INTEGRAL DE INFORMACIÓN ACADÉMICA - PÚBLICO
Título del libro: 2023 Ieee International Conference On Aerospace Electronics And Remote Sensing Technology, Icares Título del capítulo: A Light-Weight ANN Model for Landslide Detection: A Case Study of Idukki, India
Frequency Ratio (FR); Landslide Inventory Map (LIM); Landslide Conditioning Factors (LCF); Landslide Susceptibility Mapping (LSM); Predictive Rate (PR)
Resumen:
This article presents a light-weight ANN model for the creation of a landslide susceptibility map (LSM) for the district of Idukki in the South Indian state of Kerala. The landslide conditioning factors (LCF) considered for the creation, training, validation and testing of the LSM are elevation, slope, aspect, curvature, topographic wetness index (TWI), stream power index (SPI), rainfall, topographic ruggedness index (TRI), geology, soil type and land use and land cover. The Frequency Ratio (FR) analysis has been carried out on the LCFs and those having the highest Predictive Rate (PR) have been determined as aspect, slope, rainfall and soil type. Once the LSM is created, it is tested using landslide and non-landslide points using the proposed ANN model which yields an accuracy of 83.5%. Future scope in this work is to improve the accuracy of the model by using metaheuristic algorithms for optimization of weights of the ANN model.
