ERROR

Entschuldigung - obwohl wir unser Bestes getan haben: es ist ein Fehler aufgetreten
Typedatabase
MessageYou have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near "AND SUBSTRING(categories_id,4,1) != "0") AS cat4, (SELECT categorie..." at line 5
QuerySELECT (SELECT categories_id FROM categories_description WHERE language_id = 1 AND categories_id = 000) AS cat1, (SELECT categories_id FROM categories_description WHERE language_id = 1 AND categories_id = 00 AND SUBSTRING(categories_id,2,1) != "0") AS cat2, (SELECT categories_id FROM categories_description WHERE language_id = 1 AND categories_id = 0 AND SUBSTRING(categories_id,3,1) != "0") AS cat3, (SELECT categories_id FROM categories_description WHERE language_id = 1 AND categories_id = AND SUBSTRING(categories_id,4,1) != "0") AS cat4, (SELECT categories_name FROM categories_description WHERE language_id = 1 AND categories_id = 000) AS cat1name, (SELECT categories_name FROM categories_description WHERE language_id = 1 AND categories_id = 00 AND SUBSTRING(categories_id,2,1) != "0") AS cat2name, (SELECT categories_name FROM categories_description WHERE language_id = 1 AND categories_id = 0 AND SUBSTRING(categories_id,3,1) != "0") AS cat3name, (SELECT categories_name FROM categories_description WHERE language_id = 1 AND categories_id = AND SUBSTRING(categories_id,4,1) != "0") AS cat4name, (SELECT url_text FROM commerce_seo_url_without_language WHERE categories_id = 000) AS cat1url, (SELECT url_text FROM commerce_seo_url_without_language WHERE categories_id = 00 AND SUBSTRING(categories_id,2,1) != "0") AS cat2url, (SELECT url_text FROM commerce_seo_url_without_language WHERE categories_id = 0 AND SUBSTRING(categories_id,3,1) != "0") AS cat3url, (SELECT url_text FROM commerce_seo_url_without_language WHERE categories_id = AND SUBSTRING(categories_id,4,1) != "0") AS cat4url, (SELECT wod_count_products FROM categories WHERE categories_id = 000) AS cat1cnt, (SELECT wod_count_products FROM categories WHERE categories_id = 00 AND SUBSTRING(categories_id,2,1) != "0") AS cat2cnt, (SELECT wod_count_products FROM categories WHERE categories_id = 0 AND SUBSTRING(categories_id,3,1) != "0") AS cat3cnt, (SELECT wod_count_products FROM categories WHERE categories_id = AND SUBSTRING(categories_id,4,1) != "0") AS cat4cnt

Maria Soledad Garcia Ferrari & Harry Smith 
Waterfront Regeneration [PDF ebook] 
Experiences in City-building

Support

Waterfront regeneration and development represents a unique opportunity to spatially and visually alter cities worldwide. However, its multi-faceted nature entails city-building with all its complexity including the full range of organizations involved and how they interact. This book examines how more inclusive stakeholder involvement has been attempted in the nine cities that took part in the European Union funded Waterfront Communities Project. It focuses on analyzing the experience of creating new public realms through city-building activities. These public realms include negotiation arenas in which different discourses meet and are created – including those of planners, urban designers and architects, politicians, developers, landowners and community groups – as well as physical environments where the new city districts’ public life can take place, drawing lessons for waterfront regeneration worldwide. The book opens with an introduction to waterfront regeneration and then provides a framework for analyzing and comparing waterfront redevelopments, which is followed by individual case study chapters highlighting specific topics and issues including land ownership and control, decision making in planning processes, the role of planners in public space planning, visions for waterfront living, citizen participation, design-based waterfront developments, a social approach to urban waterfront regeneration and successful place making. Significant findings include the difficulty of integrating long term ‘sustainability’ into plans and the realization that climate change adaptation needs to be explicitly integrated into regeneration planning. The transferable insights and ideas in this book are ideal for practising and student urban planners and designers working on developing plans for long-term sustainable waterfront regeneration anywhere in the world.

€174.14
payment methods
Buy this ebook and get 1 more FREE!
Language English ● Format PDF ● Pages 256 ● ISBN 9781136479007 ● Editor Maria Soledad Garcia Ferrari & Harry Smith ● Publisher Taylor and Francis ● Published 2012 ● Downloadable 6 times ● Currency EUR ● ID 2359708 ● Copy protection Adobe DRM
Requires a DRM capable ebook reader

More ebooks from the same author(s) / Editor

21,363 Ebooks in this category