Data integration for quantitative analysis of sustainability

Fu, Changfeng ORCID: and Aouad, Ghassan (2009) Data integration for quantitative analysis of sustainability. Proceedings of the ICE - Urban Design and Planning, 162 (3). pp. 131-140. ISSN 1755-0793

[thumbnail of Data integration for quantitative analysis of sustainability.pdf]
Data integration for quantitative analysis of sustainability.pdf - Published Version

Download (1MB) | Preview


The development of an integrated data repository for urban sustainability analysis is presented; it aims to enhance quantitative analysis of urban sustainability on real statistical data with relevant geographic references. The method is complementary to qualitative and quantitative analyses of sample data, which are the main approaches adopted in conventional urban sustainability analysis. The paper highlights the background and importance of using statistical data for urban planning and analysis. Selected statistics sources and various geospatial objects relevant to the geo-references of the statistical data are reviewed. The conceptual model of the integrated data repository is described and the logical integration of statistics from different sources is illustrated. The detailed geospatial conceptual model shows the geospatial classes, main attributes and relationships between these geospatial classes. The paper details the procedure of setting up a server-based database to host both geospatial and non-geospatial data, and uses PostGIS query to interrogate geospatial information in the database, including how to convert the database tables from other formats. A geographic information system (GIS) is introduced as a user-side tool to reveal geospatial and non-geospatial data. Case studies of application of the database for urban sustainability analysis are described. Data maps generated for these case studies can assist planning and design professionals in analysing some urban sustainability issues. Potential applications in various sustainability analyses, barriers and future improvements are also discussed.

Item Type: Article
Identifier: 10.1680/udap.2009.162.3.131
Additional Information: © 2009 ICE Publishing. All rights reserved.
Keywords: information technology; mathematical modelling; sustainability
Subjects: Construction and engineering > Built environment
Depositing User: Charlie Fu
Date Deposited: 24 Feb 2017 09:27
Last Modified: 06 Feb 2024 15:51


Downloads per month over past year

Actions (login required)

View Item View Item