Smarter Cities: Cleaning Electricity, Gas and Water Metered Consumption Data for Social and Urban Research

Abstract

It is claimed that 'Big Data' could help cities become 'smart', utilise resources more efficiently, and improve inhabitants' quality of life. Metered consumption data of electricity, gas and water are collected and stored for each household in Australia and provide a valuable source of information for researchers hoping to understand the patterns of consumption and improve resource utilisation. This work tests the assumption that these datasets are sufficiently 'clean' to allow interrogation and details the common errors encountered. An inspection of 1-7 years of meter readings of electricity, gas and water for ~60,000 households in Canberra, Australia as well as all datasets of the local government's energy and water efficiency programs, found this not to be the case. Common errors found include: missing data, biases in erroneous data, errors generated by the data custodians, duplicate entries, the effect of different custodian objectives and of poor data constraints (free flowing text).

Managing Sustainable Urban Tourism Development: The Case of Ljubljana

“…Annual budgets are needed to perform different activities in urban areas to protect the environment and tourism management, ranging from employing professionals to do maintenance and cleaning, surveillance, visitor assistance, and information, limitation of vehicle access, as well as investments in infrastructure and equipment for public use and conservation of local wealth and landmarks [57]. Recent study shows that city governors should also invest in the Big Data and eliminate common errors in big data databases (missing data, duplicate entries, errors generated by the data custodians and others), which can then help cities to become smart, utilize resources more efficiently and improve inhabitants' quality of life [58]. Quality of life affects urban growth and competitiveness [59].…”

Environmental Carrying Capacity Analysis Based on Water Resources (Case Study of East Surabaya Area)

“…This is primarily to obtain data from the water balance analysis and use them as reference for the future development and water governance of East Surabaya. Such data is important because, according to Talent [13], the expanding need for resources which are otherwise scarce -such as drinkable water -emphasizes the necessity of efficient use and urban 'sustainability'. Improper use of natural sources, e.g.…”