Spatial Web-Interactive Impact Assessment Tool: Affordable Smart City Real Estate
Abstract
:1. Introduction
2. Materials and Methods
2.1. Methodological Flowchart
2.1.1. Data Environment
- Data collection: This involves the selection and collection of both georeferenced and non-georeferenced information. The spatial (georeferenced) data consist of all territory information including green areas, lots, service locations, and so on. Moreover, they include the geometrical information of the built and future building stock. This information is derived from the digital cartographic of the master plan, technical map, and technical catalogs of Planet Smart City (e.g., perimeter, number of floors, heated volume, and area). On the other hand, the non-georeferenced data such as the necessary energy consumption of buildings, the number of residents, and all of the necessary information to calculate the indicators are to be collected in this step [20].
- Data analysis: This involves the processing and analysis of the gathered data to produce an initial thematic depiction of the fundamental data. The data should be analyzed and pre-processed for the upcoming communication procedures and indicators after they have been collected.
- Database creation: This comprises data integration and database creation using QGIS version 3.16. Finally, to create a supportive and strong GIS database, it is necessary to integrate all of the data collected at two levels: (a) the individual lots and (b) the territory information [20]. This GIS database consists of all data and information describing each territory and building as a basis for estimating the related indicators, such as energy consumption, accessibility to public services, and water consumption. This stage is fundamental since it is the foundation of the entire calculation process and other substantial actions [20]. In this phase, the stakeholders’ involvement should also be integrated to obtain the existing data and determine the relevant sustainable objectives for future planning.
- The relevance of the indicator with respect to the analysis scale.
- The availability of data.
- The possibility of calculating and measuring the indicators.
- Intent: explains the goal of studying this indicator.
- Assessment methodology:
- Description: the descriptive text of the indicator.
- Data requirements: the smart solutions that can be applied, the unit that is being used, the data source, and the references.
- Assessment method: how to characterize the indicator’s value.
2.1.2. Application Environment
- Planning and architecture: this combines architectural solutions to produce high-quality, affordable dwellings surrounded by public areas that develop communities, foster relationships, and provide long-term value for inhabitants [27].
- Technological systems: residents’ quality of life will be improved through technological solutions related to networks, home automation, air quality control, security, and more [27].
- Environment: from drought-resistant plants to solar bricks and intelligent irrigation, innovations in sustainable solutions are implemented to create long-lasting value for future generations.
- Social innovation: This aims to create communities that are smart, sustainable, and socially inclusive and empower citizens to be effective in their local community. There are six key qualities for a real estate project to be defined as smart: attractive, healthy, inclusive, efficient, informative, and digital [27].
2.2. Case Study
3. Results
3.1. Database Environment
3.1.1. Smart Solutions
3.1.2. Indicators
Ecosystem Resources
- The baseline values were determined (e.g., residential electricity usage was found from the national energy provider, while smart lighting values were taken from real measurements).
- The impact of the smart solutions was measured using the following:
- Data derived from the literature (e.g., smart appliances and smart electricity metering);
- Real measured data (e.g., smart lighting).
- The data were verified, when possible, by comparing values with different sources.
- The impact of the smart solutions was determined by comparing the calculated values with a baseline to measure the percent reduction in electrical energy usage.
Indicators | Smart Solution | Calculation |
---|---|---|
Energy Usage | Energy reduction due to smart appliances | 1—Value: residential energy considered (%) × energy reduction possible (%) × baseline residential electricity use per home (kWh/home/yr) = energy reduction due to upgraded appliances (kWh/home/yr) |
2—Percentage: energy reduction due to upgraded appliances (kWh/home/yr)/baseline residential electricity use per home (kWh/home/yr) = energy reduction due to upgraded appliances (%) | ||
Percentage of energy reduction due to smart electricity metering | 1—Value: energy reduction by smart metering (%) × baseline residential electricity use per home (kWh/home/yr) = energy reduction due to smart metering (kWh/home/yr) | |
2—Percentage: 5% = energy reduction due to smart electricity metering based on European Environmental Service [36] | ||
Percentage of energy reduction due to smart lighting (LED lighting) | 1—Installed capacity (kW)/lighting area of phase 1 (m2) × hours per day of operation (hrs/day) × days per year of operation (days/yr) = estimated public lighting electricity use (kWh/m2/yr) | |
2—Percentage: 1— (actual public lighting electricity use/baseline public lighting electricity use) = percent reduction in energy usage due to smart lighting |
- The impact of the smart solutions was measured using the following:
- Data derived from the literature (e.g., innovative materials for potable water distribution networks, smart irrigation, and smart water metering);
- A baseline value (e.g., domestic water usage per capita was found from the national water provider).
- The data were verified, when possible, by comparing values with various sources.
Indicators | Smart Solution | Calculation |
---|---|---|
Water Usage | Water usage reduction due to innovative materials for potable water distribution networks (IMPWDNs) | 1—Value: (baseline for domestic water usage per capita (L/cap/day)/(1—losses in distribution in Ceara (%))) × (losses in distribution in Ceara (%)—estimated losses that will remain in distribution (%)) × occupants per home (people/home) × conversion (L to m3) × days per year (days/yr) = domestic water usage reduction (m3/home/yr) |
2—Percentage: losses in distribution in Ceara (%)—estimated losses that will remain in distribution (%) = water usage reduction due to IMPWDNs (%) | ||
Water usage reduction due to smart irrigation | Value 1 (L/garden/unit/yr): average water demand per harvest (L/m2/yr) × size of one garden unit (m2) × water reduction due to smart irrigation (%) × conversion (L to m3) = water usage reduction due to smart irrigation (m3/garden unit/yr) | |
Value 2 (L/cap/day): size of one garden unit (m2) × gardens (number) × average water demand for harvest (L/m2/harvest) × smart irrigation water reduction (%)/population of Laguna (number)/days in a year (days/yr) = water reduction averaged over entire year per capita (L/cap/day) | ||
Water reduction due to smart water metering | 1—Value: energy reduction by smart metering (%) × baseline residential electricity (L/cap/day) × occupants per home (people/home) × conversion (L to m3) × days per year (days/yr) = water reduction due to smart water metering (m3/home/yr) | |
2—Percentage: water usage reduction % due to smart water metering = 5% based on European Environmental Service [36] |
Built Environment
- The master plan of the development was transferred to QGIS.
- QGIS was used to measure the area in meters squared (m2) of all outdoor public spaces (e.g., urban forestation, urban gardens, urban ecological network, parks and squares, shopping streets, youth cinemas, fitness areas, and smart gyms).
- The areas were divided by the population of the development (i.e., 17,792 residents in Laguna) to determine the extension of public and green outdoor spaces per capita.
Technological Systems
- The impact of the smart solution is measured using data derived from the literature (e.g., structured cabling infrastructure). The number of fixed broadband internet connections per one hundred people is calculated as the percentage of residents with internet connections in the city multiplied by one hundred. The result is expressed as the number of internet connections per one hundred people.
- The data should be verified, when possible, by comparing values with various sources.
Indicators | Smart Solution | Calculation |
---|---|---|
Internet Connections | Structured cabling infrastructure | Brazilian homes with internet connection (%) × 100 = number of residents with internet connection per 100 people |
Society
- The locations of key services offered by Planet Smart City in the local area using the eight service types as a guide (e.g., healthy corner, fitness area, smart gym, outdoor cinema, bookcrossing, urban forestation, urban gardens, urban ecological network, control center for local administration, and innovation hub) are identified.
- The locations of key services offered by the public administration in the local area using the eight service types as a guide (e.g., schools, health clinics, theatre/churches/cultural spaces, squares and public spaces, commercial lots, fire/police stations) are identified.
- The percentage of inhabitants that are within an 800m walking distance from each service individually is calculated.
- A baseline value was determined (e.g., net adjusted disposable income).
- The impact of the smart solutions was measured using the following:
- Data derived from the literature (e.g., all solutions);
- Real measured data (e.g., smart lighting).
- The data were verified, when possible, by comparing values with several sources.
- Solutions were only considered if they have the potential to generate economic savings for residents.
- Some solutions resulted in economic savings for residents (e.g., smart appliances), while other solutions could benefit the public administration (e.g., smart lighting) and, therefore, a distinction was made between the two categories.
Indicators | Smart Solution | Calculation |
---|---|---|
Economic savings for residents | Economic savings due to the use of smart appliances | energy reduction due to smart appliances (kWh/home/yr) × cost of electricity (USD/kWh/yr) = economic savings due to smart appliances (USD/home/yr) |
Economic savings due to the use of a fitness area | frequency of equipment usage (users/hr) × peak hours of usage (hr/day) × days per month of usage (days/month)/frequency of repeated use by users (number/month) = unique regular users/yr/fitness area unique regular users/yr/fitness area × cost of fitness club membership (BRL/yr/user) × exchange (USD/BRL) = economic savings (USD/yr/fitness area) | |
Economic savings due to the use of carpooling | average expenses for commuting with car per month (BRL/month) − [average expenses for commuting with car per month (BRL/month)/people in carpool (number)] = cost savings for commuters (BRL/month) cost savings for commuters (BRL/month) × commuters in each family (number) × months in a year (month/yr) × conversion (USD/BRL) = economic savings due to carpooling (USD/family/yr) economic savings due to carpooling (USD/family/yr) × homes in Laguna (number) × homes carpooling (%) = economic savings due to carpooling (USD/Laguna/yr) | |
Economic savings due to a healthy corner | average per capita out-of-pocket health spending (USD/capita/yr) × occupants per home (people/home) × reduction in fees (%) = economic savings due to healthy corner (USD/home/yr) | |
Economic savings due to free WiFi | avg cost of fixed-line high-speed internet (BRL/month/home) × months in a year (months/yr) × exchange rate (BRL to USD) × population that gains access to the internet (%) = economic savings due to free WiFi (USD/home/yr) | |
Economic savings due to smart energy metering | energy reduction due to use of energy meter (kWh/home/yr) × cost of electricity (USD/kWh) = economic savings due to smart energy meter (USD/home/yr) | |
Economic savings due to smart water metering | volume of water reduced (L/home/day) × days in a year (days/yr) × conversion (m3 to 1000 L) × cost of water (USD/m3) = economic savings due to smart water meter (USD/home/yr) | |
Economic savings due to smart irrigation | cost of water (USD/m3) × water reduction due to smart irrigation (L/garden unit/yr)/unit conversion (m3 to L) = economic savings due to smart irrigation (USD/garden unit/yr) | |
Economic savings due to urban gardens | total value produced by 20 m2 urban garden ($BRL) × conversion rate (BRL to USD) = total value produced by 20 m2 urban garden (USD) total value produced by 20 m2 urban garden (USD) × [size of garden unit (m2)/size of example garden (m2)] = economic savings for a 48 m2 garden (USD/garden unit/yr) | |
Economic savings for public administrations | Economic savings due to IMPWDNs | domestic water usage reduction (m3/home/yr) × cost of water (USD/m3) = economic savings due to IMPWDNs (USD/home/yr) |
Economic savings due to smart public lighting | (baseline public lighting electricity use (kWh/m2/yr)—installed public lighting capacity (kWh/m2/yr)) × total area of roads lit in Laguna (m2) × cost of electricity for public lighting (USD/kWh)/homes in Laguna (number) = economic savings due to smart lighting (USD/home/yr) |
3.2. Application Environment
- Maps: The maps of the smart solution intervention make it possible to visualize the location of the solutions on the territory and the number of them. Moreover, the maps help identify the most critical hotspot zones to avoid unnecessary investments.
- Sliders for each smart solution: this allows the decision-makers to choose the number of smart solutions that must be inserted into the project.
- Indicators: Formula-driven analysis results are updated automatically while the analysis is performed. The indicators can show the outcome of one or several dynamic attributes.
4. Discussion
5. Conclusions
- Data Environment: This section included the data, indicators, and smart solutions. First, different types of data were collected, including spatial data for the territory and residents, data for the smart solutions that are implemented in the project, and data for the indicators. This was accomplished through data collection, data analysis, and database creation. Then, through the indicators, the selection of KPIs and how they are connected to the smart solutions were detailed.
- Application Environment: Within this section, the interactive tool was modeled based on four macro-areas connected to planning and architecture, technological systems, the environment, and social innovation. This was accomplished through the usage of the Tableau software, which helps in spatially visualizing the data and shows the relationship between different data types.
Author Contributions
Funding
Institutional Review Board Statement
Informed Consent Statement
Data Availability Statement
Acknowledgments
Conflicts of Interest
References
- Mahtta, R.; Fragkias, M.; Güneralp, B.; Mahendra, A.; Reba, M.; Wentz, E.A.; Seto, K.C. Urban Land Expansion: The Role of Population and Economic Growth for 300+ Cities. npj Urban Sustain. 2022, 2, 5. [Google Scholar] [CrossRef]
- Elbalki, M.; Shaaban, M.; Osman, A.; Pietrasanta, A.; Kamil, M.; Ali, A. Optimizing Integrated Water and Electrical Networks through a Holistic Water–Energy Nexus Approach. Sustainability 2024, 16, 3783. [Google Scholar] [CrossRef]
- Urbanization Causes and Impacts|National Geographic. Available online: https://www.nationalgeographic.com/environment/article/urban-threats (accessed on 29 October 2023).
- Rahangmetan, R. Sustainable Development in Developing Countries—Circle of Sustainable Europe. Available online: https://cose-eu.org/2021/10/11/sustainable-development-in-developing-countries/ (accessed on 29 October 2023).
- Moumen, N.; Radoine, H.; Nahiduzzaman, K.M.; Jarar Oulidi, H. Contextualizing the Smart City in Africa: Balancing Human-Centered and Techno-Centric Perspectives for Smart Urban Performance. Smart Cities 2024, 7, 712–734. [Google Scholar] [CrossRef]
- Xiao, M.; Zhou, Y.; Li, B.; Song, M.; Xiao, Y.; Zhou, Y. How Does the Smart City Policy Influence Digital Infrastructure? Spatial Evidence from China. Land 2023, 12, 1381. [Google Scholar] [CrossRef]
- Zhang, A.; Nankpan, M.N.; Zhou, B.; Forson, J.A.; Nkrumah, E.N.K.; Adjavon, S.E. A COP28 Perspective: Does Chinese Investment and Fintech Help to Achieve the SDGs of African Economies? Sustainability 2024, 16, 3084. [Google Scholar] [CrossRef]
- Calzada, I. Smart Rural Communities: Action Research in Colombia and Mozambique. Sustainability 2023, 15, 9521. [Google Scholar] [CrossRef]
- Liu, X.; Zhang, X.; Baziar, A. Hybrid Machine Learning and Modified Teaching Learning-Based English Optimization Algorithm for Smart City Communication. Sustainability 2023, 15, 11535. [Google Scholar] [CrossRef]
- Ren, S.; Li, Y.; Peng, Z.; Yin, M.; Liu, X. Developing an Urban Environment Examination System by Incorporating Construction, Economic, Environmental, Cultural and Development Dimensions. Sustainability 2024, 16, 3065. [Google Scholar] [CrossRef]
- Albino, V.; Berardi, U.; Dangelico, R.M. Smart Cities: Definitions, Dimensions, Performance, and Initiatives. J. Urban Technol. 2015, 22, 3–21. [Google Scholar] [CrossRef]
- Komeily, A.; Srinivasan, R.S. A Need for Balanced Approach to Neighborhood Sustainability Assessments: A Critical Review and Analysis. Sustain. Cities Soc. 2015, 18, 32–43. [Google Scholar] [CrossRef]
- WEF. Making Affordable Housing a Reality in Cities. Available online: https://www.weforum.org/publications/making-affordable-housing-a-reality-in-cities (accessed on 29 October 2023).
- Pignatelli, M.; Torabi Moghadam, S.; Genta, C.; Lombardi, P. Spatial Decision Support System for Low-Carbon Sustainable Cities Development: An Interactive Storytelling Dashboard for the City of Turin. Sustain. Cities Soc. 2023, 89, 104310. [Google Scholar] [CrossRef]
- Yi, W. Planning Urban Cities Smartly With Digital Twins. 2022. Available online: https://www.govtech.com/sponsored/planning-urban-cities-smartly-with-digital-twins/ (accessed on 12 June 2023).
- Laskowski, N. What is Artificial Intelligence and How Does AI Work? Available online: https://www.techtarget.com/searchenterpriseai/definition/AI-Artificial-Intelligence (accessed on 29 August 2023).
- Ly, D. On The Horizon For Smart Cities: How AI and IoT Are Transforming Urban Living. Available online: https://www.forbes.com/sites/forbestechcouncil/2023/04/07/on-the-horizon-for-smart-cities-how-ai-and-iot-are-transforming-urban-living/ (accessed on 11 July 2024).
- Popelka, S. A Guide to Urban Artificial Intelligence; Urban AI: Worcester, UK, 2023. [Google Scholar]
- Planet Smart City. Planet Smart City—An Innovative Proptech Company. Available online: https://planetsmartcity.com/ (accessed on 29 October 2023).
- Lombardi, P.; Abastante, F.; Torabi Moghadam, S.; Toniolo, J. Multicriteria Spatial Decision Support Systems for Future Urban Energy Retrofitting Scenarios. Sustainability 2017, 9, 1252. [Google Scholar] [CrossRef]
- Angelakoglou, K.; Nikolopoulos, N.; Giourka, P.; Svensson, I.-L.; Tsarchopoulos, P.; Tryferidis, A.; Tzovaras, D. A Methodological Framework for the Selection of Key Performance Indicators to Assess Smart City Solutions. Smart Cities 2019, 2, 269–306. [Google Scholar] [CrossRef]
- International Organization for Standardization. ISO 37124; Sustainable Cities and Communities—Guidance on Resilience and Smartness. ISO: Geneva, Switzerland, 2022.
- International Organization for Standardization. ISO 37122; Sustainable Cities and Communities—Indicators for Smart Cities. ISO: Geneva, Switzerland, 2019.
- Dezidério Souto, R. Indicadores de Desenvolvimento Sustentável—Brasil: Análise e Contribuições. Estatística Soc. 2013, 56–70. Available online: https://www.researchgate.net/publication/275524508_Indicadores_de_Desenvolvimento_Sustentavel_-_Brasil_analise_e_contribuicoes (accessed on 20 June 2023).
- Casula, M.; Rangarajan, N.; Shields, P. The Potential of Working Hypotheses for Deductive Exploratory Research. Qual. Quant. 2021, 55, 1703–1725. [Google Scholar] [CrossRef] [PubMed]
- Yuan, J.; Wang, C.; Skibniewski, M.J.; Li, Q. Developing Key Performance Indicators for Public-Private Partnership Projects: Questionnaire Survey and Analysis. J. Manag. Eng. 2012, 28, 252–264. [Google Scholar] [CrossRef]
- Planet Smart City. Experience Smarter Living with Our Solutions. Available online: https://planetsmartcity.in/smart-solutions/ (accessed on 12 July 2024).
- Batt, S.; Grealis, T.; Harmon, O.; Tomolonis, P. Learning Tableau: A Data Visualization Tool. J. Econ. Educ. 2020, 51, 317–328. [Google Scholar] [CrossRef]
- Planet IDEA. Available online: https://planetsmartcity.com/projects/smart-city-laguna-the-worlds-first-affordable-smart-city/ (accessed on 17 May 2024).
- European Environment Agency. Achieving Energy Efficiency through Behaviour Change: What Does It Take? Publications Office of the European Union: Luxembourg, 2013; Available online: https://www.eea.europa.eu/publications/achieving-energy-efficiency-through-behaviour (accessed on 24 June 2023).
- Teston, A.; Geraldi, M.S.; Colasio, B.M.; Ghisi, E. “Rainwater Harvesting in Buildings in Brazil: A Literature Review”. ResearchGate (April 2018). Available online: https://www.researchgate.net/publication/324482772_Rainwater_Harvesting_in_Buildings_in_Brazil_A_Literature_Review (accessed on 24 June 2021).
- Statista. “Internet Usage in Brazil: Statistics & Facts”. Last Modified September 2023. Available online: https://www.statista.com/topics/2045/internet-usage-in-brazil/ (accessed on 20 June 2023).
- Enel Brasil. “Enel Distribuição Brasil”. Available online: https://www.enel.com.br/ (accessed on 20 June 2023).
- Savio, G.; De Luca, S.; Quaranta, G.; Roccella, G.; Russolillo, D.; Savio, M.; Schiavello, B. Planet Makes It Smarter. Available online: https://www.planetidea.it/wp-content/uploads/2017/11/Flyer.pdf (accessed on 24 June 2023).
- ISO 37120; Sustainable Cities and Communities—Indicators for City Services and Quality of Life. ISO: Geneva, Switzerland, 2018.
- Anca-Diana, B.; Nigel, G.; Gareth, M. Achieving Energy Efficiency through Behaviour Change: What Does It Take? Publications Office of the European Union: Luxembourg, 2013. [Google Scholar]
- Singh, K. All You Need to Know about the Implementation of AI. Available online: https://www.talentica.com/blogs/implementation-of-ai/ (accessed on 11 July 2023).
# | Step | Method | Output |
---|---|---|---|
1 | Preliminary | Literature/standards/assessment tools | Pre-selection |
2 | Exploratory | Work meetings/focus groups | Feedback |
3 | Hierarchy | Questionnaires | First selection |
4 | Validation | Focus groups | Final selection |
Planet Smart City Macro-Area | Solution |
---|---|
Ecosystem Resources | ○ Smart appliances ○ Smart electricity metering ○ Smart lighting |
○ Innovative material for potable water distribution network ○ Smart irrigation systems ○ Smart water metering | |
Built Environment | ○ Urban forestation ○ Urban gardens ○ Urban ecological network ○ Parks and squares ○ Shopping street ○ Youth cinema ○ Fitness area ○ Smart gym |
Technological Systems | ○ Structured cabling infrastructure |
Society | ○ Control center for local administration ○ Innovation hub ○ Bookcrossing ○ Healthy corner ○ Urban forestation ○ Urban gardens ○ Urban ecological network ○ Youth cinema ○ Fitness area ○ Smart gym |
○ Carpooling ○ Free WiFi ○ Home automation ○ Smart electricity metering ○ Smart lighting ○ Innovative material for potable water distribution network ○ Smart irrigation systems ○ Smart water metering ○ Urban gardens ○ Fitness area ○ Healthy corner |
Indicators | Planet Smart City Macro-Area | Description | Unit | Assessment Method | Data Source | Level of Difficulty |
---|---|---|---|---|---|---|
Energy Usage | Ecosystem Resources | Total electrical energy reduction | kWh/house/yr kWh/m2/yr | Measured; Estimated from the literature | [30] | Medium |
Water Usage | Total domestic water consumption reduction | M3/house/day M3/garden/yr | Measured; Estimated from the literature | [31] | Medium | |
Public and Green Spaces | Built Environment | Square meters of public and green spaces (outdoor spaces only per capita) | M2/capita | Derived from the GIS | Digital cartography | Low |
Internet Connections | Technological Systems | The number of internet connections per 100,000 population | # of connection s/100 (%) | Estimated from the literature | [32] | Medium |
Key Public Service Availability | Society | The % of residential buildings located within 800 m of key public services | % of residential buildings | Derived from the GIS | Digital cartography | Low |
Economic Savings | The solution generated cost savings | EUR/home/yr | Estimated from the literature | [33] | High |
Disclaimer/Publisher’s Note: The statements, opinions and data contained in all publications are solely those of the individual author(s) and contributor(s) and not of MDPI and/or the editor(s). MDPI and/or the editor(s) disclaim responsibility for any injury to people or property resulting from any ideas, methods, instructions or products referred to in the content. |
© 2024 by the authors. Licensee MDPI, Basel, Switzerland. This article is an open access article distributed under the terms and conditions of the Creative Commons Attribution (CC BY) license (https://creativecommons.org/licenses/by/4.0/).
Share and Cite
Torabi Moghadam, S.; Al Mamlouk, D.; Lombardi, P. Spatial Web-Interactive Impact Assessment Tool: Affordable Smart City Real Estate. Sustainability 2024, 16, 8592. https://doi.org/10.3390/su16198592
Torabi Moghadam S, Al Mamlouk D, Lombardi P. Spatial Web-Interactive Impact Assessment Tool: Affordable Smart City Real Estate. Sustainability. 2024; 16(19):8592. https://doi.org/10.3390/su16198592
Chicago/Turabian StyleTorabi Moghadam, Sara, Dana Al Mamlouk, and Patrizia Lombardi. 2024. "Spatial Web-Interactive Impact Assessment Tool: Affordable Smart City Real Estate" Sustainability 16, no. 19: 8592. https://doi.org/10.3390/su16198592
APA StyleTorabi Moghadam, S., Al Mamlouk, D., & Lombardi, P. (2024). Spatial Web-Interactive Impact Assessment Tool: Affordable Smart City Real Estate. Sustainability, 16(19), 8592. https://doi.org/10.3390/su16198592