Issues such as climate change, ecological conservation and sustainable energy have received a great deal of attention in the last decade. Studies have shown that cities are responsible for major energy use and waste emissions. In dealing with the growing environmental problems, people have to look to the cities they live in. Today, urbanisation is still accelerating worldwide which heralds a potentially huge opportunity to improve the environment by increasing the energy sustainability of cities.

To address the energy sustainability of cities, policymakers and urban planners are looking for ways to control energy consumption in buildings. Faced with a large number of urban buildings and complex climate factors, the measurement of building energy consumption has to be done with the help of relevant simulation software. Luckily, software and data formats associated with the calculation of building energy consumption have matured over the years through the efforts of academics and research institutions. This largely helps to solve the complex problem mentioned above. However, these elements still need to be optimized and improved. In this thesis, the research will focus on one of the urban energy simulation software CitySim, the 3D city database 3DCityDB and the 3D city model data format CityGML. Although it is currently possible to rely on these elements for urban energy simulation, the whole simulation process is complex. The main reason for this problem is the number of data extractions, data conversions and data storage required throughout the whole process. Also, the lack of proficiency in data formats, software usage and data storage can be a difficult problem for potential users. Therefore, this research will focus on developing a python-based interface to achieve the goal of well connecting the entire urban energy simulation process.

This approach simplifies the process of urban energy simulation from the preparation of a complete database related to urban energy simulation, to the full process of data extraction, conversion and simulation in python, to the final storage of simulation results back to the database. In addition to this, several user-friendly customised operations are also developed in python. In this way, I hope to help more users to conduct urban energy simulation analysis conveniently.