APPLIED DATA ANALYSIS FOR URBAN PLANNING AND MANAGEMENT RRaaee--AAWW..iinndddd 22 1155//0044//22002211 1155::4444 0000__RRAAEE__WWOONNGG__FFMM..iinndddd 11 1199--AAuugg--2211 1122::1122::2299 PPMM Sara Miller McCune founded SAGE Publishing in 1965 to support the dissemination of usable knowledge and educate a global community. SAGE publishes more than 1000 journals and over 800 new books each year, spanning a wide range of subject areas. Our growing selection of library products includes archives, data, case studies and video. SAGE remains majority owned by our founder and after her lifetime will become owned by a charitable trust that secures the company’s continued independence. Los Angeles | London | New Delhi | Singapore | Washington DC | Melbourne 0000__RRAAEE__WWOONNGG__FFMM..iinndddd 22 1199--AAuugg--2211 1122::1122::2299 PPMM APPLIED DATA ANALYSIS FOR URBAN PLANNING AND MANAGEMENT Alasdair Rae Cecilia Wong RRaaee--AAWW..iinndddd 33 1155//0044//22002211 1155::4444 0000__RRAAEE__WWOONNGG__FFMM..iinndddd 33 1199--AAuugg--2211 1122::1122::2299 PPMM SAGE Publications Ltd Editorial arrangement  Alasdair Rae and Cecilia Wong 2021 1 Oliver’s Yard Chapter 1  Alasdair Rae 2021 55 City Road Chapter 2  Elisabete A. Silva, Lun Liu, London EC1Y 1SP Heeseo Rain Kwon, Haifeng Niu, Yiqiao Chen and Jose Reis 2021 SAGE Publications Inc. Chapter 3  Cecilia Wong 2021 2455 Teller Road Chapter 4  Adipandang Yudono 2021 Thousand Oaks, California 91320 Chapter 5  Duncan A. Smith 2021 Chapter 6  Oliver Dawkins, Rob Kitchin, Gareth W. Young SAGE Publications India Pvt Ltd and Tomasz Zawadzki 2021 B 1/I 1 Mohan Cooperative Industrial Area Chapter 7  Chao Ren, Edward Ng, Jason Wai Po Tse, Pak Mathura Road Shing Yeung, Jimmy Chi Hung Fung, Gerald Mills, Jason New Delhi 110 044 Ching, Benjamin Bechtel and Linda See 2021 Chapter 8  Lei Wang 2021 SAGE Publications Asia-Pacific Pte Ltd Chapter 9  Zheng Wang 2021 3 Church Street Chapter 10  Cecilia Wong 2021 #10-04 Samsung Hub Singapore 049483 Apart from any fair dealing for the purposes of research, private study, or criticism or review, as permitted under the Copyright, Designs and Patents Act, 1988, this publication may not be reproduced, stored or transmitted in any form, or by any means, without the prior permission in writing of the publisher, or in the case of reprographic reproduction, in accordance with the terms of licences issued by the Copy- right Licensing Agency. Enquiries concerning reproduction outside those terms should be sent to the publisher. Editor: Alysha Owen Library of Congress Control Number: 2020950419 Assistant editor: Charlotte Bush Production editor: Martin Fox British Library Cataloguing in Publication data Copyeditor: Catja Pafort Proofreader: Rebecca Storr A catalogue record for this book is available from Indexer: Silvia Benvenuto the British Library Cover design: Shaun Mercier Typeset by: C&M Digitals (P) Ltd, Chennai, India Printed in the UK ISBN 978-1-5264-9700-0 ISBN 978-1-5264-9699-7 (pbk) At SAGE we take sustainability seriously. Most of our products are printed in the UK using responsibly sourced papers and boards. When we print overseas we ensure sustainable papers are used as measured by the PREPS grading system. We undertake an annual audit to monitor our sustainability. 0000__RRAAEE__WWOONNGG__FFMM..iinndddd 44 1199--AAuugg--2211 1122::1122::2299 PPMM CONTENTS About the Editors vii About the Contributors ix 1 Introduction: The Promises and Pitfalls of Data for Urban Planning 1 Alasdair Rae 2 What’s New in Urban Data Analytics? 11 Elisabete A. Silva, Lun Liu, Heeseo Rain Kwon, Haifeng Niu, Yiqiao Chen and Jose Reis 3 Indicators and Urban Planning: The Big Data Opportunities and Challenges 29 Cecilia Wong 4 Crowdsourced Geographic Information for Urban Planning and Management 49 Adipandang Yudono 5 Design and Narrative Techniques for Urban Data Visualisation 67 Duncan A. Smith 0000__RRAAEE__WWOONNGG__FFMM..iinndddd 55 1199--AAuugg--2211 1122::1122::2299 PPMM vi APPLIED DATA ANALYSIS FOR URBAN PLANNING AND MANAGEMENT 6 City Dashboards and 3D Geospatial Technologies for Urban Planning and Management 83 Oliver Dawkins, Rob Kitchin, Gareth W. Young and Tomasz Zawadzki 7 Data Analytics, Urban Form and Climate Change: The Urban Climate Map 103 Chao Ren, Edward Ng, Jason Wai Po Tse, Pak Shing Yeung, Jimmy Chi Hung Fung, Gerald Mills, Jason Ching, Benjamin Bechtel and Linda See 8 Data Analytics and Modelling Accessibility Change of High-Speed Rail Network Development: A Door-to-Door Approach 127 Lei Wang 9 Understanding Migrant–Local Neighbourly Relations in Shanghai: Empirical Urban Research in a Data-Sparse Setting 143 Zheng Wang 10 Conclusion: Beyond Analytics: Planning-Led or Planning-Lag? 161 Cecilia Wong Index 171 0000__RRAAEE__WWOONNGG__FFMM..iinndddd 66 1199--AAuugg--2211 1122::1122::2299 PPMM ABOUT THE EDITORS Alasdair Rae is the founder of Automatic Knowledge Ltd, a UK-based data and insights company, focusing on spatial data analysis and the built environment. Prior to that, he was a Professor of Urban Studies and Planning at the University of Sheffield. He is a Fellow of the Royal Scottish Geographical Society, a recipient of the Royal Town Planning Institute’s Sir Peter Hall Award for Wider Engagement, a former Commissioner of the UK2070 Commission, and a winner of the Royal Statistical Society’s ‘Stat of the Year’. His most recent academic work has focused on spatial analysis, deprivation, housing markets and megaregions, and his work frequently appears in the national and interna- tional media. He has a PhD from the University of Liverpool, an MA from The Ohio State University and a BA from the University of Strathclyde. Cecilia Wong is Professor of Spatial Planning and Director of Spatial Policy and Analysis Lab of the Manchester Urban Institute, the University of Manchester. She is Fellow of the UK Academy of Social Sciences; Fellow of the Royal Town Planning Institute; and Chair of the UK 2021 Research Excellence Framework ‘Architecture, Built Environment and Planning’ sub-panel. She has research expertise in strategic spatial planning, policy monitoring and analysis, urban and regional development, and housing and infrastruc- ture planning, and urban planning in China. She was a commissioner of the UK2070 Commission on Regional Inequalities, a commissioner of the Labour Party’s Lyons 0000__RRAAEE__WWOONNGG__FFMM..iinndddd 77 1199--AAuugg--2211 1122::1122::2299 PPMM viii APPLIED DATA ANALYSIS FOR URBAN PLANNING AND MANAGEMENT Independent Housing Review, a member of Department for Communities and Local Government’s expert panel on housing and planning, an expert panel member of the European Commission’s Urban Audit II, and an expert group member of the UN-Habitat City Prosperity Index. 0000__RRAAEE__WWOONNGG__FFMM..iinndddd 88 1199--AAuugg--2211 1122::1122::2299 PPMM ABOUT THE CONTRIBUTORS Benjamin Bechtel holds a professorship in Urban Climatology at the Ruhr-University Bochum, Germany. He serves as board member of the International Association for Urban Climate, Associate Editor for Frontiers in Remote Sensing and as a reviewer and guest editor for several international journals. Yiqiao Chen is a PhD Candidate in the Department of Land Economy, University of Cambridge. Yiqiao’s research focuses on utilisation of multi-sourced data in the big data era, and integration of complexity theory, urban data analytics and smart city govern- ance, with a special focus on smart transport. Jason Ching has had joint appointments as a Meteorologist/Physical Scientist with the US National Oceanographic and Atmospheric Administration (NOAA) and the US Environmental Protection Agency (EPA) from 1970 to 2010; he led the development of the EPA’s prototypic Community Multiscale Air Quality (CMAQ) modelling system. Dr Ching is currently a senior research scientist at University of North Carolina Institute for the Environment in Chapel Hill, NC, and is a lead for the WUDAPT (World Urban Database and Access Portal Tool), an IAUC Initiative (2012–present). Oliver Dawkins is a researcher on the Connected Environments project at the Bartlett Centre for Advanced Spatial Analysis (CASA), University College London, and formerly 0000__RRAAEE__WWOONNGG__FFMM..iinndddd 99 1199--AAuugg--2211 1122::1122::2299 PPMM