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

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

Título del libro: Coastal Zone: Proceedings Of The Symposium On Coastal And Ocean Management
Título del capítulo: Fate of the Nichupte lagoon system in the planning of Cancun, Mexico as an international tourism center

Autores UNAM:
MARTIN MERINO IBARRA;

---

Autores externos:

---

Idioma:

---

Año de publicación:
1993

---

Palabras clave:

Coastal zones; Dredging; Marine pollution; Restoration; Cancun; Eutrophic soup; Nichupte lagoon system; Tourism development; Regional planning

---

Resumen:

Many books and articles on tourism development of pristine and attractive areas conclude with the metaphor of cancer killing its host body. Cancun, in fact was a response to the perceived death - in international tourism circles - of Acapulco. To many, Cancun now appears to becoming another Acapulco. The tourism development of Cancun, like Acapulco, has both degraded the original spectacular attractions of the site and has motivated residents and tourists to live or vacation elsewhere. The paper traces the history of Cancun from its conception in 1969 to its present status as in international tourism center. In 1969, the Cancun area was a pristine coastal landscape, inhabited by approximately 400 people. By 1990 it was a city of over 200,000 residents that attracted over 1.5 million visitors a year to 18,000 hotel and condominium rooms. Cancun's most distinguishing natural feature is the Nichupte Lagoon system. It was the largest clear lagoon with a white sandy bottom in the wider Caribbean and Mexico. Over the last 24 years the shallow Lagoon system with its very restricted circulation has been battered by the development of Cancun. Filling, dredging, the direct discharge of pollutants, and additional restrictions in the circulation have turned part of the Lagoon system from an attractive jewel to a eutrophic soup, accentuated with floating and submerged mats of macroalgae. Unfortunately, the planners and managers of Cancun's tourism development have not yet responded to the stressed situation in the Lagoon system with an appropriate set of administrative procedures and restoration strategies.

---

Entidades citadas de la UNAM:

---

Fuente:


ISBN:
0872629597
Editorial:
Publ by ASCE, New York, NY, United States

Tipo de producto:
Conference Paper