Analysis of quality of life across Tehran districts based on designated indicators and relational database management system

Tehran's demography and urbanization have undergone dramatic changes since its designation as the capital city over two centuries ago. Currently, the city possesses 22 districts and a few associated regions (cemetery and southern suburbs).We considered and developed 11 indicators to evaluate th...

Full description

Bibliographic Details
Main Author: Farshad Amiraslani
Format: Article
Language:English
Published: Elsevier 2021-12-01
Series:Urban Governance
Subjects:
Online Access:http://www.sciencedirect.com/science/article/pii/S2664328621000036
_version_ 1811246977379205120
author Farshad Amiraslani
author_facet Farshad Amiraslani
author_sort Farshad Amiraslani
collection DOAJ
description Tehran's demography and urbanization have undergone dramatic changes since its designation as the capital city over two centuries ago. Currently, the city possesses 22 districts and a few associated regions (cemetery and southern suburbs).We considered and developed 11 indicators to evaluate the quality of life of Tehran using Structured Query Language (SQL) algorithms. Indicators were classified into two large groups: ‘population characteristics’ and ‘city features’. Except for literacy, sharp differences existed between the minimum and maximum values for each indicator. Noticeable differences in public transport were shown among districts. Comparison of the housing units with over 220 square meters size area among districts also revealed a difference between maximum and minimum values with a factor of 31, the per capita of greenery spaces and car parking capacities with a factor of 23.Each indicator was considered individually to select districts having the most optimum condition. Between two and four indicators were also combined to nominate those districts with a higher number of indicators with optimum conditions. Our proposed approach and selected indicators showed high relevancy and appropriateness to assess quality of life in a typical large city.Finally, we concluded the paper with practical and political remarks that may help streamline theories of urban governance into the actual conditions of urban dwellers across the world.
first_indexed 2024-04-12T15:01:36Z
format Article
id doaj.art-d47b20d955d14f9a9c9854d61a45a0a7
institution Directory Open Access Journal
issn 2664-3286
language English
last_indexed 2024-04-12T15:01:36Z
publishDate 2021-12-01
publisher Elsevier
record_format Article
series Urban Governance
spelling doaj.art-d47b20d955d14f9a9c9854d61a45a0a72022-12-22T03:28:04ZengElsevierUrban Governance2664-32862021-12-0112107114Analysis of quality of life across Tehran districts based on designated indicators and relational database management systemFarshad Amiraslani0Faculty of Life and Health Sciences, School of Geography and Environmental Sciences, Ulster University, Coleraine BT52 1SA, UKTehran's demography and urbanization have undergone dramatic changes since its designation as the capital city over two centuries ago. Currently, the city possesses 22 districts and a few associated regions (cemetery and southern suburbs).We considered and developed 11 indicators to evaluate the quality of life of Tehran using Structured Query Language (SQL) algorithms. Indicators were classified into two large groups: ‘population characteristics’ and ‘city features’. Except for literacy, sharp differences existed between the minimum and maximum values for each indicator. Noticeable differences in public transport were shown among districts. Comparison of the housing units with over 220 square meters size area among districts also revealed a difference between maximum and minimum values with a factor of 31, the per capita of greenery spaces and car parking capacities with a factor of 23.Each indicator was considered individually to select districts having the most optimum condition. Between two and four indicators were also combined to nominate those districts with a higher number of indicators with optimum conditions. Our proposed approach and selected indicators showed high relevancy and appropriateness to assess quality of life in a typical large city.Finally, we concluded the paper with practical and political remarks that may help streamline theories of urban governance into the actual conditions of urban dwellers across the world.http://www.sciencedirect.com/science/article/pii/S2664328621000036Quality of lifeTehranSQL
spellingShingle Farshad Amiraslani
Analysis of quality of life across Tehran districts based on designated indicators and relational database management system
Urban Governance
Quality of life
Tehran
SQL
title Analysis of quality of life across Tehran districts based on designated indicators and relational database management system
title_full Analysis of quality of life across Tehran districts based on designated indicators and relational database management system
title_fullStr Analysis of quality of life across Tehran districts based on designated indicators and relational database management system
title_full_unstemmed Analysis of quality of life across Tehran districts based on designated indicators and relational database management system
title_short Analysis of quality of life across Tehran districts based on designated indicators and relational database management system
title_sort analysis of quality of life across tehran districts based on designated indicators and relational database management system
topic Quality of life
Tehran
SQL
url http://www.sciencedirect.com/science/article/pii/S2664328621000036
work_keys_str_mv AT farshadamiraslani analysisofqualityoflifeacrosstehrandistrictsbasedondesignatedindicatorsandrelationaldatabasemanagementsystem