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

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

Título del libro: Spe Latin American And Caribbean Health, Safety, Environment, And Sustainability Conference 2015
Título del capítulo: Modeling the optimal trajectory of a skimmer ship to clean oil spills in the open sea

Autores UNAM:
SUSANA GOMEZ GOMEZ;

---

Autores externos:

---

Idioma:
Inglés

---

Año de publicación:
2015

---

Palabras clave:

Advection; Diffusion; Linear equations; Models; Oil spills; Sustainable development; Trajectories; Absorbing boundary condition; Advection-diffusion-reaction equations; Advection-reaction-diffusion equations; Computational domains; Diffusion and transport; Environmental disasters; Finite volume approximation; Optimal trajectories; Ships

---

Resumen:

Oil spill contamination in the open sea has been at the origin of some of the worst environmental disasters. One of the major cleaning techniques is the use of skimmer ships that contain various pumps distributed along its waterline to suck the oil from the surface of the water directly into storage units. We want to improve this process. We developed a model to simulate the effect of the skimmer ship on the evolution of the oil spill. This model, based on a finite volume approximation of an advection-diffusion-reaction equation, considers: The motion of oil spots resulting from the movement of the source of contamination; the diffusion and transport by wind and sea currents; and the phenomena associated with the action of the skimmer ship, assuming that it follows a pre-assigned trajectory. We introduce a nonlinear diffusion term to obtain finite speed diffusion. Also, we use an absorbing boundary condition, to account for the oil exiting the computational domain. To reduce numerical artificial diffusion, we use second order numerical schemes to discretize the advection terms. We also apply splitting schemes to decrease the computational complexity. To improve the whole process, we optimize the trajectory of a skimmer ship to maximize the amount of recovered oil during a fixed period of time, using an optimization method. The novel approach we advocate here is validated by comparing our numerical results with real life measurements from the Prestige spill, which took place in Spain in 2002. We were able to reproduce the satellite image of the spot after 4 days of pollution. We also prove that the optimal trajectory we get cleans the area near the coast up to 55 percent before the Prestige ship broke up. This percentage was improved to 88 percent by using a second ship on the entire area. Copyright 2015, Society of Petroleum Engineers.

---

Entidades citadas de la UNAM:

---

Fuente:


ISBN:
9781510811669
Editorial:
Society of Petroleum Engineers

Tipo de producto:
Conference Paper