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 = '518589' 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 = '518589' 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 = '518589']
®
ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 518589 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= 518589]
SIIA Público
SISTEMA INTEGRAL DE INFORMACIÓN ACADÉMICA - PÚBLICO
Título del libro: Proceedings Of The Coastal Engineering Conference Título del capítulo: Morphodynamics of a caribbean beach fringed by a coral reef
Beach morphodynamics; Coral reef; Local hydrodynamics; Morphological response; Numerical results; Spectral wave models; Wave energy dissipation; Wave measurement; Acoustics; Beaches; Coastal engineering; Energy dissipation; Hydrographic surveys; Wave energy conversion; Reefs
Resumen:
The morphological response of two adjacent beaches, on the Mexican Caribbean coast, exposed to the same offshore wave climate is compared, where one of the beaches is fringed by a coral reef and the other is not. Detailed topographic and bathymetric measurements were collected from 2007 to 2011 using a differential GPS and double-frequency echo-sounder. Offshore waves were continuously measured by the NOAA 42056 directional buoy, and nearshore waves were measured from May to September 2007 using an acoustic wave and current profiler to validate the use of offshore waves in the analysis of beach morphodynamics. Investigations showed that the beach with the fringing coral reef was the more stable under the same offshore energetic wave conditions of different directions. The implications of the fringing reef on the local hydrodynamics and energy dissipation were evaluated with the SWAN third-generation spectral wave model. The model was first validated with wave measurements collected at intermediate (forereef) and shallow waters (reef lagoon) with Aquadop profilers. Numerical results indicate that during shore-normal energetic conditions, the fringing reef is capable of reducing the incoming wave energy by up to 65%.
