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 = '362190' 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 = '362190' 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 = '362190']
®
ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 362190 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= 362190]
SIIA Público
SISTEMA INTEGRAL DE INFORMACIÓN ACADÉMICA - PÚBLICO
Título del libro: Coastal Dynamics 2005 - Proceedings Of The Fifth Coastal Dynamics International Conference Título del capítulo: A storm classification based on the beach erosion potential in the catalonian Coast
Storms along the Catalonian coast previously classified in terms of their energy content are re-analyzed to take into account their erosion potential effects on the coast. This was done in two-step procedure. The first step consists in modeling their effects on two representative beach profiles by using SBEACH. The coastal response was characterized through two bulk erosion parameters, beach retreat and eroded volume. In the second step, the effort was devoted to look for a parametric way to estimate the storm erosion potential in such a way that by simply using synthetic information on storm characteristics, similar bulk erosion values to the obtained by using SBEACH be obtained. To do this, several beach profile change dimensionless predictors were tested. Although the use of some of these predictors gave reasonable predictions, it was found that the inclusion of the storm duration was a key variable to reduce the scatter in the response. Moreover, to properly reproduce reflective and dissipative beach profile erosion, predictors explicitly including beach slope have to be used. Here we propose to use the JA parameter multiplied by the storm duration. Using the JA t parameter a final 5-classes scale based on the erosion potential and beach retreat ranging from I (lowest erosion potential) to V (highest erosion potential) was obtained. Copyright ASCE 2006.
