Sustainable, Innovative and Intelligent Societies and Cities

Preface
Acknowledgements
Contents
Part I Analytical, Descriptive and Predictive
Toward Data Lake Technologies for Intelligent Societies and Cities
1 Introduction
2 Methodology
3 Data Lake Architectures and Technologies
3.1 Ingestion
3.2 Distillation
3.3 Processing
3.4 Insights
3.5 Governance
4 Data Lakes for Smart City Applications
5 Cognitive Bias in the Decision-Making Process
6 Data Lake Architecture for Smart Societies
6.1 Data Ingestion
6.2 External Databases and Data Warehouses
6.3 Distributed File Systems and Storage Systems Monitor
6.4 Distributed Query Engines
6.5 Distributed Processing Engine
6.6 Metadata Management
6.7 User Interface
7 Case Study
8 Conclusion
References
An Analysis of Smart Cities' Initiatives in Portugal
1 Introduction
2 Background
2.1 Portuguese Demography
2.2 Overview of “Smart Cities” in Portugal
3 Material and Methods
3.1 Case Study Methodology
3.2 Benchmarking
4 Study
4.1 Experiment
4.2 Survey
4.3 Requirements Analysis
4.4 Historical Research
4.5 Case Study
5 Results
5.1 Events
5.2 Projects
6 Discussion
7 Conclusion
References
Intelligent Dashboards for Car Parking Flow Monitoring
1 Introduction
2 Background
2.1 Parking Management
2.2 Business Intelligence
2.3 Data Analytics
2.4 Extract, Transform and Load (ETL)
2.5 KPIs
2.6 Data Warehouse
2.7 OLAP
2.8 Related Works
2.9 ioCity
3 Material and Methods
3.1 Tools
3.2 Kimball's Methodology
4 Study
4.1 Project Planning
4.2 Project Management
4.3 Business Requirements Definition
4.4 Technology Track
4.5 Data Track
4.6 Business Intelligence Track
4.7 Deployment
5 Results
5.1 Areas with the Most Movement
5.2 Busiest Parks
5.3 Busiest Days
5.4 Parks with the Highest Capacity
5.5 Stocking Rate
5.6 Hours with the Most Affluence
6 Discussion
7 Conclusion
References
Tourist as a Smart Tourist: A Review
1 Introduction
2 Tourist's Behavior
3 Smart Tourism
4 Gamification
5 Smart Tourism Cities
6 Discussion
7 Conclusions
References
Part II Attractive, Engaging and Fun
Smart Tourism Design: Take Experience and Resource Integration as the Core
1 Introduction
2 Literature Review
2.1 Smart Tourism and Design
2.2 Tourist's Experience
3 Research Design
3.1 Meta-Synthesis
3.2 Data Collection
4 Research Results
4.1 Meta-Synthesis Results
4.2 Tourist's Experience
4.3 Stakeholders
4.4 Smart Tourism Destination System Path
5 Conclusions and Implications
5.1 Conclusions
5.2 Implications
5.2.1 Theoretical Implications
5.2.2 Practical Implications
References
Sustainable Mobility: How to Gamify and Factors to Better Success
1 Introduction
2 Methodology
3 Background
3.1 Gamified Solutions for Behaviour Change Towards Sustainable Urban Mobility
3.2 Gamification Frameworks for Gamified Mobility
4 Analysis of the Impact of Gamification on Supporting Behaviour Change Towards Sustainable Urban Mobility
5 Key Aspects That Block Mass Adoption of the Mobility as a Service Paradigm
6 Conclusion
References
How Do Citizens Want to Participate in Smart City Programs? Some Answers from Greece
1 Introduction
2 Literature Review
2.1 The Term Engagement
2.2 Citizen Engagement Toolkits
3 Research Methodology
4 Research Findings
4.1 Descriptive Statistics
4.2 Correlation for Citizen Participation and Influencing Factors
5 Conclusions
References
Sociable Smart Cities
1 Introduction
2 Research Questions
3 Is a Smart City a Sociable Smart City?
3.1 Defining the Sociable Smart City
3.2 Other Approaches
4 Transforming a City to a Sociable Smart City
4.1 Aspects of the Sociable Smart City Concept
4.2 City Exploration Methodology
5 Case Studies
5.1 CLIO (ColLective cIty memOry)
5.2 Participatory Budgeting
5.3 Mapography
5.4 Outdoor Museum Experiences
5.5 Addressing Research Questions
6 Challenges and Conclusions
References
Part III Healthy, Secure and Sustainable
Fostering Healthy Food Habits Through Video Games
1 Introduction
2 Related Works
3 Method
3.1 Problem Definition and Archetype of Solution Proposed
3.2 Archetype Workflow: The Game Design
3.3 Requirements Development
3.4 System Architecture
3.5 Software Design
4 Evaluation and Results
4.1 Evaluation Design
4.1.1 Scenarios and Sessions
4.2 Results of the Food Preference Questionnaire
4.3 Usability Test Results
5 Discussion
6 Conclusions and Future Work
References
Smart Solutions for Sustainability: RDI for Urban and Societal Transitions Requires Cross-Sectoral Experimentation Platforms
1 Moving Beyond Pioneering Initiatives
1.1 The Challenge of Sustainability Transitions Comes to Age
1.2 A Decades-Long Exploration of Potential Futures: Examples from Europe
1.3 Between Pasts and Futures
2 Transformative Projects Must Braid Science and Business
2.1 How to Achieve Systemic Change While Avoiding SystemFailures?
2.2 A Knowledge-Action Framework Model
3 Discussions
3.1 Further Insights from the Literature on Test and Experimentation Platforms
3.2 Insights from Past Projects
3.3 Mapping Specific Issues and Experiences with RDI in Smart City Projects
4 Conclusion
References
Protecting Organizations from Cyber Attacks: An Implemented Solution Based on CyberArk
1 Introduction
2 State of the Art
3 Solution Description
3.1 Existing Connection Components
3.2 Current State after Development
4 Implementation
5 Results
6 Conclusions
References
A Sustainable Framework to Manage Plastic Waste in Urban Environments Using Open Data
1 Introduction
1.1 Motivation
1.2 Background
1.2.1 Sensors
1.2.2 Open Data
1.2.3 Machine Learning
1.3 Towards the Design of an Intelligent Framework for Plastic Waste Management
2 Related Work
3 An Urban Plastic Waste Planning Approach Based on Open Data
3.1 Description of the Reference Cities
3.1.1 Reference City #1: Malaga
3.1.2 Reference City #2: Madrid
3.1.3 Reference City #3: Stavanger
3.1.4 Reference City #4: New York City
3.2 Description of the Target Cities: Quezon City, Punjab,and Gujarat
3.2.1 Target City #1: Quezon City, Philippines
3.2.2 Target City #2: Punjab and Gujarat, India
3.3 Statistical Methods Used in the Analysis of the Urban Planning Approach
3.4 Analysis for the Estimation of the Number of Bins
4 Evaluation of the Proposal as an Enabler for Sustainable Plastic Waste Collection
4.1 Evaluation Setting
4.2 Simulation Results
4.3 Evaluation Discussion
5 Conclusions and Future Work
References
Mapping Industry 4.0 onto Eco-city Transitions: A Knowledge –Action Matrix
1 History Shows, But Learning Is Up to Us
1.1 Human Society Evolved Between Technology Push and Market Pull
1.2 Where to from Here?
2 Potential Utility of Industry 4.0 for Sustainable Development
2.1 The Knowledge Basis Provided by Science
2.2 The Contribution of Policy: Making the Right Distinctions
2.3 Mapping Industry 4.0 onto Sustainability Transitions: Focus on Cities
3 Discussions
3.1 Where Does Industry 4.0 Fit into This Picture?
3.2 How Do Cities Fit In?
3.3 We Need a Science-Based Regard on Industry 4.0 to Re-make It or Break It
4 Conclusion and Outlook
References
Part IV Innovative, Connected and Monitored
Smart Roofs System: Moisture and Temperature Monitoring on Smart Roofs
1 Introduction
2 State of the Art
3 The New Smart Roof System
3.1 The Waterproof Membrane
3.1.1 Total Solar Reflectance
3.1.2 Color Coordinates
3.1.3 Thermography
3.2 The Reinforcement Textile
3.3 The Printed Sensors
3.3.1 Moisture Sensor
3.3.2 Temperature Sensor
4 Results and Discussion
4.1 Electronic System for Sensors Characterization
4.2 Membrane Thermal Performance
4.2.1 Total Solar Reflectance
4.2.2 Color Coordinates
4.2.3 Thermography
4.3 Reinforcement Textile
4.4 Printed Sensors Response
4.4.1 Moisture Sensor
4.4.2 Temperature Sensor
5 Conclusions
References
Next-Generation Fashion Ecosystem: A STVgoDigital Approach
1 Introduction
2 Fashion Ecosystem
3 Industry 4.0 in Textile Industry
4 The Impact of Digitization on the Sustainability of the Textile and Clothing Value Chain
5 Industry 4.0 Micro-factory for Textile and Clothing Industries
5.1 Data Model for an Industry 4.0 Microfactory
5.2 Enabling Machines for Industry 4.0
5.2.1 Sensing Systems
5.2.2 Smart Hub
5.3 Micro-factory Digital Platform
5.4 Advanced Customized Production Management and Control Systems
5.5 Size-Fitting Systems
6 Conclusions
References
Public Transportation Occupancy Rate
1 Introduction
2 State of the Art
3 System Overview
4 Technologies
4.1 Time of Flight (ToF)
4.2 BLE
5 System Architecture
5.1 Master and Slave Devices
5.2 Hardware Development
6 Tests and Validation
7 Discussion and Conclusions
8 Future Work and Known Issues
References
Remote Traffic Light System to Support Traffic Light Maintenance
1 Introduction
2 Traffic Flow Management: An Overview
3 Remote Traffic Light System
3.1 Sensing Systems
3.2 Gateway
3.3 Cloud Server
3.4 Web Interface
3.5 Validation
4 Conclusions
5 Issues
References
Index