Urban Climate Data Sensing, Warehousing, and Analysis: A Case Study in the City of Abu Dhabi, United Arab Emirates

With the ever increasing observations and measurements of geo-sensor networks, satellite imageries, geo-spatial data of location based services (LBS) and location-based social networks has become a serious challenge for data management and analysis systems. In urban micro-climate, we need to deal with various types of data such as: environmental data measurements, Wi-Fi data and so on. The format and the nature of data coming from different sensors such as temperature, humidity, thermal cameras, wind sensors, and others within an urban area varies. Therefore, there is a need for a unified platform to store these data efficiently using new technologies for which, we have come up with implementation of OLAP cubes. Furthermore, additional analytics for assessing urban thermal comfort can also be derived based on behavioural patterns of people. Therefore, outdoor Wi-Fi usage statistics is used as a proxy for the amount of time people spend outdoors, to correlate outdoor thermal conditions to perceived thermal comfort. Some interesting obervations are made in our study.

[1]  Hai Liu,et al.  Fast and Robust Data Association Using Posterior Based Approximate Joint Compatibility Test , 2014, IEEE Transactions on Industrial Informatics.

[2]  Rick Cattell,et al.  Scalable SQL and NoSQL data stores , 2011, SGMD.

[3]  Erik Johansson,et al.  Instruments and methods in outdoor thermal comfort studies – The need for standardization , 2014 .

[4]  Tzu-Ping Lin,et al.  Thermal perception, adaptation and attendance in a public square in hot and humid regions , 2009 .

[5]  Lida Xu,et al.  Data Cleaning for RFID and WSN Integration , 2014, IEEE Transactions on Industrial Informatics.

[6]  Julien Freudiger,et al.  How talkative is your mobile device?: an experimental study of Wi-Fi probe requests , 2015, WISEC.

[7]  Markus Schneider,et al.  On the Requirements for User-Centric Spatial Data Warehousing and SOLAP , 2011, DASFAA Workshops.

[8]  Andres Sevtsuk Mapping the MIT Campus in Real Time Using WiFi , 2009, Handbook of Research on Urban Informatics.

[9]  Liang Chen,et al.  Outdoor thermal comfort and outdoor activities: A review of research in the past decade , 2012 .

[10]  Armin Zimmermann,et al.  Flexible On-Board Stream Processing for Automotive Sensor Data , 2010, IEEE Transactions on Industrial Informatics.

[11]  Hongming Cai,et al.  An IoT-Oriented Data Storage Framework in Cloud Computing Platform , 2014, IEEE Transactions on Industrial Informatics.

[12]  Wei Song,et al.  An implementation approach to store GIS spatial data on NoSQL database , 2014, 2014 22nd International Conference on Geoinformatics.

[13]  Jan Gehl “Three Types of Outdoor Activities,” “Life Between Buildings,” and “Outdoor Activities and the Quality of Outdoor Space”: from Life Between Buildings: Using Public Space (1987) , 2011 .

[14]  Joseph Ferreira,et al.  Activity-Based Human Mobility Patterns Inferred from Mobile Phone Data: A Case Study of Singapore , 2017, IEEE Transactions on Big Data.

[15]  Jan Gehl,et al.  Life Between Buildings: Using Public Space , 2003 .

[16]  Chaobin Zhou,et al.  Outdoor thermal environments and activities in open space: An experiment study in humid subtropical climates , 2016 .

[17]  Yvan Bédard,et al.  SOLAP technology: Merging business intelligence with geospatial technology for interactive spatio-temporal exploration and analysis of data , 2005 .

[18]  Lida Xu,et al.  Compressed Sensing Signal and Data Acquisition in Wireless Sensor Networks and Internet of Things , 2013, IEEE Transactions on Industrial Informatics.