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 = '615465' 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 = '615465' 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 = '615465']
®
ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 615465 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= 615465]
SIIA Público
SISTEMA INTEGRAL DE INFORMACIÓN ACADÉMICA - PÚBLICO
Título del libro: Seas At The Millennium - An Environmental Evaluation - Volume 1 Título del capítulo: Southern Gulf of Mexico
coral reef; environmental assessment; pollution; sustainability; Gulf of Mexico
Resumen:
The southern, Mexican, coast of the Gulf of Mexico supports fishing, extensive cattle ranching, crop production, and industrial and oil production activities. Along the Mexican coast there are several different ecological regions. There are semi-arid, dry and humid coastal plains and hills (north west plain of the Yucatan Peninsula), large and mostly brackish lagoons (Madre, Tamiahua, Alvarado, Terminos) and several rivers (Grande, Panuco, Coatzacoalcos, Grijalva-Usumacinta). Along this long coastline there are extreme wet and dry climates. In September and October hurricanes occur, several in the past being very damaging. North winds blow from September to March when the temperature decreases to about 6°C, and this carries rain to most of the Gulf coast. There are extensive mangrove areas and a few areas of offshore coral reefs in the Gulf (Lobos in Tamaulipas State; Isla Verde in Veracruz State; Cayo Arcas in Campeche Sound). Wetland and marsh areas are also extensive, especially around the coastal lagoons and estuaries, while extensive seagrass beds occur off the coast. For many groups of organisms, including mammals and birds, the region has a high biodiversity. However, development pressures have resulted in several problems. The activities of the extensive livestock industry which requires large areas of pasture has resulted in extensive deforestation along the Gulf coast with consequent problems of run-off. Rivers carry sediment, metals and pesticides into the Gulf waters, and over-fishing is evident for several species and in several areas of this coast. The addition of fecal coliforms to rivers, lagoons and seawater is also a great problem. New government initiatives are being developed which aim to tackle the problems of sustainable development in a region which has inadequate financial resources.