Prerpints.org logo
Preprint
Article

Temporal Dynamics of Citizen-Reported Urban Challenges: A Comprehensive Time Series Analysis

Altmetrics

Downloads

122

Views

35

Comments

0

A peer-reviewed article of this preprint also exists.

Submitted:

31 January 2024

Posted:

31 January 2024

You are already at the latest version

Alerts
Abstract
In an epoch characterized by the swift pace of digitalization and urbanization, the essence of community well-being hinges on the efficacy of urban management. As cities burgeon and transform, the need for astute strategies to navigate the complexities of urban life becomes in-creasingly paramount. This study employs time series analysis to scrutinize citizen interactions with the coordinate-based problem mapping platform in the Municipality of Patras in Greece. The research explores the temporal dynamics of reported urban issues, with a specific focus on identifying recurring patterns through the lens of seasonality. The analysis, employing the sea-sonal decomposition technique, dissects time series data to expose trends in reported issues and areas of the city that might be obscured in raw big data. It accentuates a distinct seasonal pattern, with concentrations peaking during the summer months. The study extends its approach to forecasting, providing insights into the anticipated evolution of urban issues over time. Projec-tions for the coming years show a consistent upward trend in both overall city issues and those reported in specific areas, with distinct seasonal variations. This comprehensive exploration of time series analysis and seasonality provides valuable insights for city stakeholders, enabling informed decision-making and predictions regarding future urban challenges.
Keywords: 
Subject: Computer Science and Mathematics  -   Data Structures, Algorithms and Complexity

1. Introduction

In an epoch marked by escalating urbanization and digital transformation, adeptly handling civic challenges emerges as a critical axis for the enduring well-being of communities. The burgeoning complexities of urban life necessitate meticulous strategies and smart management to navigate the multifaceted landscape of communal prosperity. Urban big data analysis, when grounded in the powerful framework of time series methodology, offers a sophisticated and insightful lens to examine the sequential data points accumulated over time. This temporal-driven approach transcends the superficial analysis of data, immersing itself in the dynamic narrative of urban transformation. As urban landscapes undergo continuous metamorphosis, the emphasis on seasonality within this analytical framework becomes not merely advantageous but indispensable. Seasonal patterns in data can reveal a diverse range of recurring variations, influenced by external factors. These variations can range from predictable changes associated with different seasons and holidays to subtle fluctuations driven by broader economic cycles [1,2,3,4,5].
The ramifications of unearthing such temporal insights extend far beyond the confines of statistical analysis. Indeed, the value inherent in these revelations resonates deeply within the realms of urban governance, planning, and decision-making. By discerning the cyclical patterns that characterize urban phenomena, policymakers gain a nuanced understanding of the ebb and flow of various elements within the urban landscape. Urban planners, armed with this temporal awareness, can tailor strategies that align with the rhythm of the city, ensuring that interventions and developments are synchronized with the evolving needs of the community. Local authorities stand to benefit immensely from this temporal perspective as they navigate the intricacies of resource allocation, infrastructure development, and policy formulation [4,5,6,7,8,9].
The temporal nature of urban data, with its inherent seasonality, serves as a strategic compass for those steering the course of urban development. It not only allows for retrospective analyses that unveil historical patterns but also empowers decision-makers to project into the future. By making informed predictions based on the cyclical nature of ur-ban data, policymakers can anticipate trends, prepare for challenges, and proactively design interventions that align with the city's temporal rhythm. In essence, the emphasis on seasonality within urban data analysis transcends statistical methodologies; it becomes a visionary tool that equips those shaping urban futures with the foresight needed to navigate the complexities of dynamic cityscapes [3,7,9,10,11,12].
The research embarks on a journey through the time series data related to citizens' issues reported over distinct time intervals. The objective is twofold: to identify recurring patterns or trends within specific time frames and to gain insights into the temporal dynamics of reported urban issues. To achieve these goals, the study employs the seasonal decomposition technique, a method that dissects time series data into its fundamental components of trend and seasonality. This analytical approach facilitates the unveiling of hidden patterns within the raw time series data, offering a deeper understanding of the contributing factors to reported issues.
Furthermore, the study extends its scope beyond retrospective analysis, venturing into the realm of forecasting. By projecting how urban issues are anticipated to evolve over time, this research equips city stakeholders with a comprehensive view, allowing for proactive decision-making and strategic planning. The inclusion of a 7-day moving average in the analysis enhances the ability to discern underlying trends by smoothing out seasonal fluctuations, thus providing a clearer picture of the evolving urban landscape.
The subsequent sections of this paper delve into the intricacies of the time series analysis, unveiling the patterns in reported city issues and the areas affected. Notably, the study explores the impact of external factors such as major weather events, construction projects, and changes in government policies. Through a meticulous examination of seasonal patterns, trends, and projections, this research contributes to a holistic understanding of how urban challenges manifest over time, fostering a data-driven approach to urban management.
To this end, the methodology section outlines the systematic approach employed in the study. It begins with data collection from the Municipality of Patras' problem mapping platform, establishing the empirical foundation for subsequent analyses. The core of the methodology lies in time series analysis, featuring the application of a 7-day moving average and the seasonal decomposition technique. These tools facilitate the identification of patterns, trends, and seasonality within the reported urban issues. The forecasting component extends the analysis into the future, providing a forward-looking perspective. The use of statistical tools and Python programming enhances the rigor and precision of the methodology. The results section unfolds the insights derived from the time series analysis. It commences with an exploration of daily areas, revealing a general upward trend in reported issues with distinct seasonal fluctuations. The application of a 7-day moving average refines this analysis, highlighting contributing factors and offering a clearer view of underlying trends. The seasonal decomposition technique dissects city areas and reported issues, unveiling stable seasonal patterns and a growing prevalence of reported issues over time. Projections for future urban challenges further reinforce the findings. Visual aids, including time-series plots and seasonal decomposition analyses, enhance the interpretability of the results.
Section 4 initiates the discussion that digs into the nuanced interpretation of the results. It elaborates on the implications of seasonality, the impact of external factors on fluctuations, and the dynamic interplay between city-wide trends and area-specific characteristics. The forecasting component is scrutinized for its relevance to urban management, offering insights into resource allocation and policy formulation. The discussion not only underscores the value of the findings for city stakeholders but also acknowledges the study's limitations, paving the way for future research directions. Ultimately, the discussion synthesizes the multifaceted aspects of the research, providing a comprehensive understanding of the temporal dynamics of citizen-reported urban issues.
The conclusion, in Section 5, serves as the culmination of the research, summarizing key findings and their implications. It reiterates the importance of a data-driven approach to urban management, emphasizing how the study contributes to this evolving field. The concluding remarks reflect on the broader significance of the research for policymakers, urban planners, and local authorities. The limitations are acknowledged, encouraging future research to refine methodologies and enhance the precision of urban issue forecasting. Overall, the conclusion reinforces the transformative potential of time series analysis and seasonality in unraveling the intricate web of citizen-reported urban challenges in the Municipality of Patras.

1.1. Related Work

In this comprehensive literature review, several studies contribute valuable insights into the spatiotemporal dynamics of critical challenges in different urban sectors. The study of [13] investigates the spatio-temporal dynamics of the combination of Information and Communication Technology in households and for individuals (ICT-H + i) and socio-economic Sustainable Development Goals (SDGs) in European regions from 2011 to 2020. Amidst the European Union's rapid digital transformation, especially post-COVID-19, the study reveals significant progress in the implementation of ICT-H + i and SDG achievements across regions. Notably, the COVID-19 pandemic altered ICT-H + i usage and impacted SDGs in economic and social dimensions, leading to regional differences in 2020, primarily driven by sustainable development indicators. The research emphasizes the importance of in-depth analysis of ICTs' contribution to sustainability, given the shortage of regional indicators for Europe. It underscores the relevance of this study for regional policy development within Europe's digital transformation strategy and the imperative to advance toward smarter and more sustainable regional development. The credit roles highlight the authors' key contributions in conceptualization, methodology, analysis, and project administration, providing valuable insights at the intersection of ICT, sustainability, and regional development. The [14] research introduces an innovative spatio-temporal methodology aimed at tackling the urgent global need for sustainable resources, particularly amid a growing population, with a specific emphasis on renewable feedstock. This comprehensive approach evaluates overall feasibility, considering the influence of both geographical and temporal factors on process viability. The spatio-temporal model integrates a dynamic assessment of processes with geospatial data, determining optimal locations and configurations with a focus on minimizing costs. The study emphasizes the critical importance of incorporating both geographical and temporal characteristics for building a sustainable case. Furthermore, it encourages the exploration of various scenarios to analyze the temporal impact on decisions, extending the applicability of the methodology to different scenarios, frameworks, and processing technologies.
In the study of [15], the authors employ the impervious surface aggregation-density method to extract urban built-up areas across 12 major cities in China from 1995 to 2015, examining the spatio-temporal evolution of urban expansion. The GeoDectector statistical method is employed to analyze the influence of economic, transportation, natural, and social factors on urban expansion. The spatio-temporal analysis exposes significant differences in the area growth and expansion rate of southern and northern cities, urging policy adjustments at both regional and national levels. GeoDectector reveals that economic development and increasing population density are the primary influencers of urbanization in both regions. The findings provide a valuable spatio-temporal reference for global urbanization research, emphasizing the importance of sustainable development concepts in future urban policies. The article [16] incorporates a time series analysis to examine the spatio-temporal evolution of urban resilience in 110 prefecture-level cities within the Yangtze River Economic Belt in China from 2005 to 2018. By assessing the urban resilience levels over this period, the study reveals a slow but consistent upward trend, indicating an improvement in the area's ability to withstand unknown risks. The analysis also uncovers fluctuations in the resilience gap between cities and highlights the dominant role of economic factors in influencing spatial differentiation. The findings emphasize the need for ongoing attention to the temporal dynamics of urban resilience, providing valuable insights for enhancing regional and national sustainable development policies.
This study [17] conducted in the Xiangjiang River Basin (XJRB) from 1990 to 2020 investigates the spatial and temporal distributions of ecosystem services (ESs) in the context of urbanization factors. The four ESs examined are water yield (WY), soil conservation (SC), nitrogen export (NE), and habitat quality (HQ), while urbanization is represented by construction land percentage, economic density, population density, and nighttime lighting. The research implements space-for-time and change-over-time methods to explore the impacts of urbanization on ESs at both sub-watershed and county levels. Key findings include dynamic fluctuations in WY, SC, and NE, with HQ experiencing a significant decline, while urbanization factors consistently increase over the study period. Each urbanization factor significantly influences the spatial heterogeneity of ESs, with county-level contributions exceeding those at the sub-watershed level. The study identifies a nonlinear relationship between urbanization and ESs, with distinct thresholds indicating changes in this relationship. The change-over-time method highlights key periods of change (1992–1995 and 2008–2013) in the urbanization-ESs relationship. The impact of urbanization on ESs is revealed to be spatially heterogeneous, influenced by both natural and anthropogenic drivers. The study concludes by emphasizing the relevance of these findings for decision-making in urban planning, recognizing the intricate interplay between urbanization and ESs for sustainable development.
The researchers in [18] employ a comprehensive approach to uncover shifts in spatio-temporal activity patterns during the last pandemic, placing a strong emphasis on time series analysis. Utilizing a participatory GIS platform, citizens from three districts of a Dutch city mapped their activity routines both before and during the lockdown, facilitating the observation of evolving behavioral trends. The spatio-temporal analysis reveals the formation and evolution of activity over time, offering crucial insights into the dynamics of urban social resilience throughout a prolonged crisis. This temporal perspective provides a nuanced understanding of how citizen behavior evolves across different phases of the pandemic, offering valuable input for urban planning and resilience strategies. The research underscores district-specific variations, underscoring the influence of local amenities, green spaces, and socio-economic factors on social resilience. The findings challenge the notion of a one-size-fits-all urban response, highlighting the importance of adopting principles such as health, ecological sustainability, and justice for community well-being. The study advocates for equitable resource distribution, functional flexibility, and thoughtful urban planning to address future challenges.
Another research [19] performs a comprehensive approach to analyze the spatial-temporal evolution of ecological quality in Chinese urban agglomerations using others, GIS and GeoDetectos. The research reveals varying annual change rates in ecological quality, with higher levels in the east compared to the west. Spatial analysis identifies significant agglomeration patterns, emphasizing the dominant role of factors such as elevation, population density, nighttime light index, arable land area, real income per capita, precipitation, and built-up urban area. The study highlights the importance of understanding time-varying drivers and spatial expressions in providing a scientific basis for urban policies. In the comprehensive work of [20], the authors apply a multidisciplinary approach to examine the early evolution of the last pandemic in 14 South American urban sites. Using a spatio-temporal framework, it analyzes daily new case incidence rates with meteorological and climatic variables as independent factors. Significant associations are found between pandemic rates and temperatures, relative humidity, precipitation, and demographic factors like population size, age, and the masculinity index. The study emphasizes that temporal analysis can reveal that epidemiological dynamics are more tied to sociodemographic factors than meteorological ones and stresses the importance of ongoing temporal research for a comprehensive understanding of transmissions in South America.
The study of [21] examines the relationship between urban growth and vegetation greenness in 340 Chinese cities using consistent multi-temporal remotely sensed data. Despite vegetation greenness generally lagging behind urban growth, a trend of consistent acceleration is observed. Over 85% of the cities show an increase in vegetation greenness along with urban growth, challenging assumptions about inevitable vegetation loss during urbanization. The study categorizes cities based on the dynamics between urban growth and vegetation health, emphasizing the need for a balance between urban expansion and greenery protection for sustainable development. The temporal analysis leads the authors to conclude that even though some cities are experiencing vegetation degradation, the findings offer optimism for environmental sustainability amid rapid urbanization. The paper [22] focuses on the 11th Sustainable Development Goal (SDG) related to sustainable cities, examining its interconnection with health, well-being, and climate action. The research proposes a method to create temporal building height maps, correlating them with environmental variables derived from remote sensing satellites. Using this temporal technique, the research shows significant improvements over existing maps in Berlin and London. The study further explores the correlation between environmental variables and height map features in neighborhoods, revealing notable spatial and temporal patterns. The research also discusses the relationship between air pollution and building height, introducing insights for urban planning and development. Overall, the study highlights the applicability of the findings to different time-geographical contexts, offering valuable insights into sustainable urban development.
Researchers in [23] address the urgent need to reduce carbon emissions globally, with a specific focus on the urban public transportation system (UPTS) during the COVID-19 pandemic. Despite the importance of UPTS in carbon reduction, there is a surprising lack of analyses in this context. The research conducts a spatio-temporal analysis of UPTS carbon footprints in Beijing using smart card data, introducing a novel multi-layer urban rail network model for estimating passenger volume and trip trajectories. Key findings include lower emissions during holidays, significant contributions from peak hours, and a positive correlation between bus and urban rail transit carbon footprints. Peak hours contribute approximately half of the total daily UPTS emissions, and there are distinct variations in carbon footprint distribution among different districts. The study's contribution lies in estimating UPTS carbon footprints and offering insights for emission reduction strategies. In the research of [24], the authors introduce a novel framework for fine-grained information extraction and dynamic spatial-temporal awareness in disaster-stricken areas using social media data. The framework is applied to a case study of urban floods in Anhui, China, revealing significant spatial and temporal consistency between flooding hotspots and rainfall centers. The conclusion highlights the feasibility of obtaining temporal data and real-time, refined information from social media during disasters, showcasing the framework's validity in a flood event. The study identifies time correlations between rainfall, topography, and flooding severity and proposes future work on incorporating multi-source data for a comprehensive understanding of urban flood events.
The article [25] explores the influence of urbanization on coastal processes and Sea Surface Temperature (SST) along Mumbai's coast over a 20-year period. Using meteorological and air quality parameters, the research identifies a rising trend in SST through time-series analysis and modeling with Autoregressive Integrated Moving Average (ARIMA) and Neural Network Autoregression (NNAR). A polynomial regression model indicates a positive correlation between urban climatic factors and SST. The findings reveal significant warming along Mumbai's coastline, emphasizing the city's impact on coastal waters. Forecasting suggests a continued warming trend, and the study proposes a regional algorithm for predicting SST based on urban climatic variables. The study [26] in Pune, India, explores the impact of ambient temperatures on mortality, a crucial aspect often studied in developed nations but lacking in the Indian context. Applying a time series regression model, the research spans from 2004 to 2012, analyzing daily mean temperature and all-cause mortality records. The study recommends public education on the adverse impacts of cool temperatures, especially for populations exposed to moderately cold conditions. The findings suggest the need for a weather-related early warning system to protect vulnerable groups, signaling the importance of further investigations into weather's incremental impact on health.
The primary objective of the paper [27] is to critically examine the impact of Urban Heat Islands (UHIs) within the framework of global warming and the burgeoning urban population, focusing on five major cities in Spain. Employing time series analysis, the study investigates how UHIs influence both maximum (Tmax) and minimum daily temperatures (Tmin) in urban and non-urban observatories, specifically delving into their repercussions on morbidity and mortality during heatwaves in Spain. The research's primary findings underscore the heightened influence of UHIs on Tmin, particularly in coastal cities compared to their inland and densely populated counterparts. Notably, the temporal study brings to light a substantial correlation between Tmax and adverse health outcomes during heatwaves in inland cities. In contrast, coastal cities exhibit this association with Tmin, highlighting the UHI effect as a pivotal factor influencing morbidity and mortality. The conclusion drawn from the study emphasizes the imperative need for localized investigations to inform population adaptation strategies in the face of rising temperatures and broader climate change. Utilizing time series analysis, the research [28] investigates how urban heat islands (UHIs) impact temperature-related mortality in eight Swiss cities. The study, focusing on UHIs, residential greenness, and neighborhood socioeconomic position as key socio-environmental factors, examines individual death records spanning from 2003 to 2016. Findings indicate an escalation of mortality risk within the temperature range of 22.5 ◦C to 35 ◦C during the warm season. Of note is the finding that UHI areas show an increased risk of heat-related issues at 35 ◦C compared to non-UHI areas. The research underscores the significance of comprehensive urban planning approaches extending beyond green spaces and advocates for the development of tailored early warning systems suited to specific urban conditions.

2. Materials and Methods

In a contemporary landscape marked by the swift advancements of smart urban methodologies and the transformative waves of digital evolution, a pivotal focus is arising on the necessity to confront challenges faced by citizens. The intricate network of urban life demands adaptable strategies and astute management to traverse the diverse landscape of community concerns. Leveraging urban big data analysis within the robust framework of time series methodology unveils a nuanced perspective, facilitating the meticulous exploration of successive data points gathered over time. This time-centric approach transcends conventional data analysis, delving into the dynamic realm of urban transformation.
This study centers its exploration within the vibrant urban landscape of the Municipality of Patras, Greece, a locale contending with the multifaceted challenges and prospects that accompany rapid urban growth. The research utilizes a dataset comprising 144 text files containing 93,053 citizen reports obtained through the API from the Sense City platform. This service has been available to the public since 2018, providing a valuable resource for understanding the community's perspectives on various issues. These reports provide direct feedback on matters spanning infrastructure, services, and various facets of urban life.
Formatted in JSON, each report is comprised of essential details, including a distinctive report identifier (_id), a bug identifier (bug_id), the present status of the reported issue (status), geographical coordinates (loc), the type of reported issue (issue), a bilingual description in both Greek and English (value_desc), and the timestamp indicating when the report was submitted (reported). These particulars contribute to a comprehensive comprehension of reported incidents, covering aspects such as nature, location, and reporting status. Below is an exemplar of a solitary report from an individual citizen in JSON format:
{
        "_id": "65185ddc679a5c9c140e1ca3",
        "bug_id": 143041,
        "status": "CONFIRMED",
        "loc": {
            "type": "Point",
            "coordinates": [
               21.7293576,
               38.2445062
            ]
        },
        "issue": "lighting",
        "value_desc": "\u039a\u03b1\u03bc\u03bc\u03ad\u03bd\u03bf\u03c2 \u039b\u03b1\u03bc\u03c0\u03c4\u03ae\u03c1\u03b1\u03c2",
        "reported": "2023-09-30T17:41:50.558Z"
    },
The detailed report encompasses the following key elements:: _id: "65185ddc679a5c9c140e1ca3"( Unique identifier for the report), bug_id: 143041 (Bug identifier associated with the report), status: "CONFIRMED" (Current status of the reported issue, indicating that it has been confirmed), loc: {"type": "Point", "coordinates": [21.7293576, 38.2445062]} (Location information for the reported issue, specifying that it is a point on the Earth's surface with latitude 38.2445062 and longitude 21.7293576), issue: " lighting" (Type or category of the reported issue, indicating a problem related to lighting), value_desc: "Καμμένος Λαμπτήρας" (It is encoded using Unicode escape sequences specifically in Greek. When decoded, it represents the text " Καμμένος Λαμπτήρας", which translates to "Burnt Lamp" in English. This is a common method of representing non-ASCII characters in a Unicode string using escape sequences.), reported: "2023-09-30T17:41:50.558Z " (Date and time when the issue was reported, which is September 30, 2023, at 17:41:50 UTC).
This report offers comprehensive information regarding a confirmed issue concerning the lighting in a public area within a neighborhood. The reported problem specifically pertains to a burnt lamp. The report includes crucial details such as location coordinates, current status, and a timestamp indicating when the issue was reported. Both the bug_id and _id function as unique identifiers, enabling efficient tracking and referencing of the report. The reports cover a wide range of locations in Patras, demonstrating the diversity of citizen concerns across the city. This spatial distribution offers valuable insights into localized challenges and contributes to a deeper understanding of the dynamics of urban issues. Categorizing reported problems in the "issue" field highlights the breadth of concerns raised by citizens, ranging from road construction to public space issues.
From an anonymity perspective, the provided JSON structure appears to prioritize the details of the reported issue and its location, avoiding the disclosure of personal information about the reporting citizen. Specifically, the "bug_id" and "_id" fields function as unique identifiers for the reported issue, essential for tracking and management, without divulging the personal details of the reporting individual. The "loc" field offers coordinates (latitude and longitude) pinpointing the reported issue's location, providing specific geographic information without directly revealing the reporter's identity. The "issue" field denotes the type of problem reported, such as "road-constructor" in the sample, offering insights into the issue's nature without disclosing personal details. The "value_desc" (description) field supplements information about the issue but doesn't expose personal information. The "reported" field signifies the date and time of the report, aiding in tracking and management without compromising the anonymity of the reporting individual.
Embarking on our exploration of the intricate mosaic of urban life, the study delves deep into the neighborhood level, where the temporal transformative influence of citizen report analytics and predictive modeling takes center stage. This study seamlessly integrates Extract, Transform, Load (ETL) processes, placing a profound emphasis on time series analysis and leveraging the capabilities of Python programming language. Time series analysis stands out as a foundational methodology within this framework, methodically revealing temporal patterns and trends woven into sequential data. This analytical approach empowers researchers to extract invaluable insights, make informed predictions, and cultivate a profound understanding of the dynamic nature inherent in urban issues. As we immerse ourselves in time series analysis for both urban and region-specific issues, our overarching objective is to furnish policymakers with a robust toolbox for deciphering the concealed underlying patterns within the data.
The methodology gets underway with an examination of daily reported issues extracted and processed from a vast data repository. An initial time series plot unveils the underlying trends, providing a foundational understanding of the issue landscape. Subsequently, the paper employs a 7-day moving average to smooth out the granular fluctuations, revealing subtler patterns and assisting in identifying discernible trends. These techniques effectively illustrate the ebb and flow of reported issues on a daily basis, establishing a solid foundation for further in-depth analyses.
Moving beyond the basics, this methodology incorporates seasonal decomposition for a detailed understanding of cyclical patterns within the data. This process breaks down the time series into components—trend, seasonality, and residuals—providing a comprehensive picture of the underlying dynamics. In addition, this paper extends the analysis to urban areas, recognizing that the dynamics of the mentioned issues may differ significantly between different areas. Using similar time series techniques, it gains insight into the temporal dynamics of both urban issues and neighborhoods, providing a holistic picture of the challenges facing the city.
In this neighborhood-centric approach, the article also incorporates prediction techniques such as Triple Exponential Smoothing Holt-Winters. This enables the projection of future values, facilitating proactive decision-making based on expected trends. Through this multifaceted methodology, researchers can not only visualize historical patterns but also anticipate future challenges and opportunities, ultimately contributing to more efficient urban planning and resource allocation. Exploration through time series analysis is part of the initial stage in uncovering the complexity of urban issues and regions. Figure 1 illustrates the time series analysis methodology.
Table 1 serves as a comprehensive statistical summary of the output from the data lake, providing a detailed overview of the entities within the dataset, encompassing distribution, central tendency, and variability of the numerical columns. The terminal output furnishes a statistical breakdown of the generated data, and the following is an elaborate explanation of each segment:
Count: Latitude, Longitude, Areas, Areas_int, issue, issue_int, reported_date_time, year, month, day, hour, minute, issue_Probability: These columns represent the number of non-null entries in the dataset. For instance, there are 93053 entries for each of these columns, indicating the total number of records in the dataset.
Unique: Latitude, Longitude, Areas, Areas_int, issue, issue_int, reported_date_time, year, month, day, hour, minute, issue_Probability: This shows the number of unique values in each column. For example, there are 162 unique areas, 8 unique issue categories, and 89003 unique reported date and time entries.
Top: Areas, issue, reported_date_time: Indicates the most frequently occurring value in each column. For instance, "Agyia" is the most common area, "garbage" is the most common issue, and "2019-10-14 07:32:00" is the most common reported date and time.
Freq: Areas, issue, reported_date_time: Represents the frequency of the top value. For example, "Agyia" appears 5881 times in the "Areas" column.
Mean: Latitude, Longitude, Areas_int, issue_int, year, month, day, hour, minute, issue_Probability: Represents the mean (average) value for each numeric column.
Std: Latitude, Longitude, Areas_int, issue_int, year, month, day, hour, minute, issue_Probability: Represents the standard deviation, a measure of the amount of variation or dispersion in each numeric column.
Min: Latitude, Longitude, Areas_int, issue_int, year, month, day, hour, minute, issue_Probability: Represents the minimum value in each numeric column.
25%, 50%, 75%: Latitude, Longitude, Areas_int, issue_int, year, month, day, hour, minute, issue_Probability: These values represent the quartiles, indicating the distribution of the data. For example, 25% of the reported dates and times fall on or before the 57th minute.
Max: Latitude, Longitude, Areas_int, issue_int, year, month, day, hour, minute, issue_Probability: Represents the maximum value in each numeric column.
The table presents a valuable initial overview, facilitating the identification of common areas and prevalent issues through the 'Top' and 'Freq' columns. Stakeholders can discern the areas most frequently reported and the predominant issues in the dataset. Moreover, the statistical measures—such as mean, standard deviation, and quartiles—offer insights into the distribution and variability of numeric columns. For instance, examining the spread of reported dates and times through quartiles provides a nuanced understanding of when issues are more likely to be reported.
Essentially, this section has delineated the methodological framework utilized in examining the temporal dynamics of citizen-reported urban challenges. It includes a Time Series Analysis focusing on neighborhood issues derived from citizen reports across various city areas. The detailed presentation elucidates the nature and distribution of the data, providing readers with a solid foundation as they progress to the subsequent section for a deeper exploration of the study's outcomes.

3. Results

The section presents the results of the previous methodologies to analyze data derived from citizen interaction with the coordinate-based problem mapping platform of the Municipality of Patras.
Time series analysis is a powerful statistical technique used to analyze sequential data points collected over time. This method provides meaningful insights, identifies patterns, and makes predictions based on the temporal order of observations. One key aspect of time series data is seasonality, a recurring pattern that occurs at regular intervals. Seasonality refers to the periodic fluctuations or patterns that repeat over a specific time frame, often influenced by external factors such as seasons, holidays, or business cycles. Understanding seasonality is crucial for various fields, including finance, economics, meteorology, and, in this case, urban data analysis.
In this analysis, the work delves into the time series data related to citizens’ issues reported over time. The paper explores the concept of seasonality, investigating whether there are recurring patterns or trends within specific time intervals. The goal is to gain insights into the temporal dynamics of reported urban issues, helping us identify regularities, anomalies, and potential factors contributing to the observed patterns.
To accomplish this, we will employ the seasonal decomposition technique, a method that breaks down a time series into its components—trend, seasonality, and residuals. By dissecting the data in this manner, we aim to uncover underlying patterns in reported city issues and city areas that may be obscured in the raw time series.
Furthermore, we extend our analysis to include forecasting, providing a comprehensive view of how urban issues are anticipated to evolve over time. By examining the temporal nature of the data, this exploration of time series analysis with a focus on seasonality equips us to make informed decisions and predictions regarding future urban challenges. This analysis will provide a holistic view of how urban issues vary over time, enabling city stakeholders to make informed decisions and predictions based on the temporal nature of the data.
Let's begin this exploration of time series analysis with a focus on seasonality and forecasting to unravel the dynamics of urban issues over distinct time intervals.
Figure 2 generates a time series plot of the sum of areas by day, for the entire time span of the data. The plot shows that there has been a general increase in the sum of areas over time, with some seasonal fluctuations. The seasonal fluctuations are likely due to the fact that some types of issues are more common during certain times of year (e.g., some issues are more common during the summer months). The plot also shows that there have been some spikes in the sum of areas at certain points in time. These spikes could be due to a number of factors, such as: Major weather events (e.g., storms, floods, etc.), Construction projects, Changes in government policy or regulations, Increased awareness of the platform and its features.
The simple time analysis of daily areas shows a general upward trend in the sum of areas over time. This indicates that the total number of issues being reported to the SenseCity platform is increasing. However, the simple time analysis does not provide any insights into the underlying causes of this trend or the seasonal fluctuations in the data. The time series plot of daily areas with a 7-day moving average reveals a more nuanced picture of the data (Figure 3). The general upward trend is confirmed, but the 7-day moving average helps to smooth out the seasonal fluctuations. This makes it easier to identify spikes in the data, which can be helpful for identifying potential contributing factors.
The key difference between the simple time analysis and the time series plot with a 7-day moving average lies in their ability to reveal the underlying trend and seasonal fluctuations in the data. The simple time analysis only shows the raw values of the data, which can make it difficult to see the overall trend or the impact of seasonal factors. The time series plot with a 7-day moving average, on the other hand, effectively smooths out the seasonal fluctuations and highlights the spikes in the data, making it easier to identify potential contributing factors.
The time series plot of daily areas with a 7-day moving average shows a clearer upward trend in the sum of areas over time compared to the time series plot of daily areas. This is because the 7-day moving average smooths out the seasonal fluctuations in the data, allowing us to focus on the overall trend. In addition, the time series plot of daily areas with a 7-day moving average highlights the spikes in the data. These spikes can be helpful for identifying potential contributing factors, such as weather events, construction projects, or public awareness campaigns. Here is a more detailed analysis of the spikes in the time series plots:
January 2021: This spike could be attributed to a combination of factors, such as Increased awareness of the SenseCity platform: The SenseCity platform was launched in early 2021, and this period could have coincided with an initial surge in user registrations and issue reporting. Weather events: The winter of 2021 was particularly harsh in Greece, with heavy snowfall and icy conditions. This could have led to an increase in road and infrastructure issues that were reported through the SenseCity platform.
September 2021: This spike could be associated with Construction projects: Patras is a city undergoing significant infrastructure development, and construction projects could have contributed to the increase in reported issues. Government policy changes: The Greek government implemented new environmental regulations in 2021, which may have led to increased reporting of environmental issues. These regulations are expected to have a significant impact on the environment in Greece in the coming years. For example: a) Regulation (EU) 2020/852 on the establishment of a framework for the sustainable use of natural resources (also known as the Circular Economy Package) aims to reduce the environmental impact of the manufacturing and consumption of goods. The regulation sets a target for recycling and reuse of materials and establishes a new system for managing waste electrical and electronic equipment (WEEE). b) Law 4818/2021 on the Prevention and Control of Air Pollution aims to improve air quality in Greece. The law sets stricter limits on air pollutants and establishes a new system for monitoring and reporting air pollution. c)Law 4936/2022 on Environmental Impact Assessment strengthens the environmental impact assessment process for major infrastructure projects. The law requires more detailed assessments and public participation in the process.
July 2022: This spike could be attributed to Tourist season: Patras is a popular tourist destination, and the summer months see a significant influx of visitors. This could have increased issues related to tourism, such as littering and public safety concerns. Extreme weather events: The summer of 2022 was characterized by extreme weather events, including heat waves and wildfires. These events could have led to an increase in issues related to infrastructure damage and environmental pollution.
November 2022: This spike could be associated with Public awareness campaigns: The city of Patras may have implemented public awareness campaigns to encourage residents to report issues through the city platform. This could have led to a temporary surge in reported issues. Improved access to the platform: The city platform may have been made more accessible to residents, such as through increased public outreach or mobile app development. This could have led to a larger number of people reporting issues.
The time series plot of Figure 4 shows the number of issues reported to the platform in Patras, Greece, from 2018 to 2023. The absence of the 7-day moving average in the analysis of daily city issues returns the general trend of the number of issues reported to the city platform time and is a useful way to see the overall trend of issue reporting, but it can be difficult to see the smaller fluctuations in the data. The trend is generally upward, with some seasonal fluctuations and spikes. This suggests that the number of issues being reported to the platform is increasing over time. The presence of the 7-day moving average analysis, Figure 5, is a useful way to confirm the overall trend of the issue report and the fluctuations in the data. This means that it calculates the average of the issue for each day, taking the previous 7 days into account. In summary, it plots the number of issues reported each day and applies a smoothing technique to visualize trends. The blue line represents the original time series, and the red line represents the 7-day moving average. The plot shows that there has been a general increase in the number of issues reported over time. There are also some seasonal fluctuations, with more issues being reported during the summer months. The 7-day moving average helps to smooth out these fluctuations and reveal the underlying trend. The following are some key observations from the plot: the number of issues reported has been increasing steadily over time, there are some seasonal fluctuations, with more issues being reported during the summer months, the 7-day moving average shows a more gradual increase in the number of issues reported, there were some peaks in the number of issues reported in early 2021 and mid-2022.
The seasonal fluctuations are likely due to a variety of factors, such as the weather, tourism (especially domestic tourism), and the availability of outdoor activities. For example, there are more issues reported during the summer months, when there are more tourists in Patras and people are more likely to be spending time outdoors. The spikes in the data could be due to a number of factors, such as construction projects, public awareness campaigns, and changes in government policy or regulation. For example, there was a spike in the data in early 2021, which could be due to the increased awareness of the platform following its updates in late 2020. Overall, the time series plot suggests that the number of issues being reported to the city platform in Patras is increasing. This is a positive sign, as it indicates that the platform is being used more regularly by residents and that the city is becoming more aware of the issues that need to be addressed. The following is a detailed analysis of the spikes in the time series analysis of the number of issues.
Spike 1: January 2021. This spike could be due to a number of factors, including increased awareness of the SenseCity platform following its update in late 2020, increased use of the platform during the winter months when people are more likely to be staying indoors and using technology, and the winter weather conditions in Greece, which could have led to an increase in the number of reported issues related to infrastructure, such as potholes and blocked drains.
Spike 2: September 2021: This rise may be due to the return of tourists to Patras (as Patras is the port gateway to Italy) as well as citizens returning to normality after the COVID-19 pandemic, increased construction projects in the city, and the implementation of new government policies or regulations related to urban development (as mentioned in the time series analyses for areas).
Spike 3: July 2022. This increase is probably due to the summer season when people move more often in the city and discover things, but also to the extreme weather phenomena that occurred in Greece in the summer. Greece experienced a number of extreme weather events during the summer of 2022, including floods, storms, and fires. These events can damage infrastructure, create dangerous conditions, and force people to evacuate their homes. This can lead to an increase in the number of reported problems such as damaged roads, fallen trees, and power outages leading to lighting problems. In addition to the direct impact of weather events, the consequences of these events can also contribute to the increase in reports. For example, residents may be more likely to report problems if they are concerned about the safety or well-being of themselves or others. They may also be more likely to report issues if they are frustrated by a lack of response from the authorities. Also, as a tourist season, tourists often contribute to an increase in reported issues such as lighting, littering, and vandalism, especially when tourism is domestic. Extreme weather events such as floods, storms, and fires can also lead to an increase in the number of reported problems.
Spike 4: November 2022. This spike could be due to public awareness campaigns and/or improved access to the city platform. The city of Patras may have implemented public awareness campaigns to encourage residents to report issues or the platform may have been made more accessible to residents, such as through new features or improved user interfaces.
Time series analysis of the number of issues reported on the city platform shows a general upward trend, with some seasonal fluctuations and peaks. The time series analysis of areas, on the other hand, shows a stronger upward trend, with fewer seasonal fluctuations and peaks. This suggests that the number of issues reported on the city platform is growing at a faster rate than the number of areas with high concentrations of reported issues. The time series analysis of areas shows that the number of areas with high concentrations of reported issues is increasing at a slower rate than the number of issues being reported to the city platform. This suggests that the issues in the city are becoming more widespread, with more areas experiencing issues. This could be due to a number of factors, such as Increased urbanization, as the city becomes more densely populated, it is more likely for issues to arise. Changes in demographics, the city's demographics are changing, with an increasing proportion of elderly residents and young families. These groups may be more likely to experience certain types of issues, such as accessibility. Changes in the built environment, the city's built environment is changing, with new development projects and infrastructure upgrades. These changes may also lead to new issues.
The following analysis improves understanding of the underlying patterns of city areas and issues as reported by citizens, including any trends, seasonality, and residual patterns. The ‘seasonal_decompose’ function from ‘statsmodels.tsa.seasonal’ decomposes the time series into these components, making it easier to analyze and interpret the individual contributions to the overall behavior. Figure 6 presents a seasonal decomposition time series analysis for the city areas and highlights that there is a clear seasonal pattern in the area data. The number of areas with high concentrations of reported issues is typically higher during the summer months and lower during the winter months. This is likely due to a number of factors, such as increased external and internal tourism, increased construction activity, and changes in weather patterns. The trend component of the time series analysis shows that there is a general upward trend in the number of areas with high concentrations of reported issues. This suggests that the problem of areas with high concentrations of reported issues is becoming more widespread. The seasonal component of the time series analysis shows that the seasonal pattern in the data is relatively stable over time. The residual component of the time series analysis shows that there is some variability in the data that is not explained by the trend or seasonal components. This variability could be due to a number of factors, such as random events.
Figure 7 illustrates the time series analysis of the issues and highlights that there is a clear seasonal pattern in the data and, in general, is in alignment with the seasonally decomposed time series analysis of areas. The number of issues reported to the platform is typically higher during the summer months and lower during the winter months. The trend component shows that there is a general upward trend in the number of issues. This suggests that the problem of issues in Patras is becoming more widespread over time.
The seasonal component of the time series analysis shows that the seasonal pattern in the data is relatively stable over time. The residual component of the time series analysis shows that there is some variability in the data that is not explained by trend or seasonal components and may be due to random events. Figure 8 and Figure 9 present the analysis of the time interval of 3 and 6-months for the city issues.
The main difference between the two images is that the cyclical component of the data in the 6-month image is a little more pronounced than the one in the 3-month image. This could suggest that cyclical fluctuations in the data occur over a longer period of time than previously thought. Another difference between the two images is that the trend component of the data in the 6-month image is more upward-sloping than the trend component of the data in the 3-month image. This likely suggests that the number of issues reported on the city's platform is increasing at a faster rate than previously thought.
Figure 10 and Figure 11 present the analysis of the time interval of 3 and 6-months for the city issues. Both graphs show that the number of areas reported is steadily increasing and provides strong seasonal but more stable trends in area-specific reports compared to issues. The residual component of the time series analysis in images shows that the variability in the data is due to random events such as various annotations of instructions or other markings made by citizens.
Because of the trends depicted in the data set, researchers extend the time series analysis by applying the Holt-Winters method, which is particularly useful when dealing with trending time series data. More specifically, this work uses Holt-Winters Triple Exponential Smoothing, a time series forecasting technique that extends the Holt-Winters method to handle trend and seasonality as well. The result provides a visual representation of the original time series and the forecasted values, allowing somebody to capture future trends and seasonality in the data. Figure 12 and Figure 13 highlight the projected values of city and town issues over the coming years.
An initial observation reveals a consistent upward trend in both the overall issues reported in the city and the issues reported in specific areas over the next few years. For the city-wide problems, the seasonal variations exhibit a constant pattern, marked by pronounced peaks during the summer months. This suggests a recurring pattern of increased reporting during these warmer seasons. In contrast, when examining issues within specific regions, the seasonality is intricately woven into the overall trend. The trend reflects the dynamic nature of areas in reporting problems, highlighting fluctuations that align with the unique characteristics of each neighborhood. This nuanced approach captures the interplay between the overarching trend and the seasonal dynamics of reported issues in different areas.

4. Discussion

The authors of this study highlight the importance of temporal analysis of citizen engagement in tackling urban issues. They emphasize the transformative power of time series analysis in comprehending the temporal patterns of citizen-reported concerns. This investigation delves into this contemporary context, focusing on the dynamic fabric of civic life within the Municipality of Patras, Greece—a setting navigating the intricate interplay of smart challenges and opportunities brought about by the rapid digital and urban growth taking place within its borders. By introducing the concept of seasonality, the groundwork is laid for a detailed exploration of recurring patterns and trends within the dataset derived from the city heart.
The time series analysis, facilitated by a custom Python solution, reflects a commitment to tailoring technology to the specific needs of the city. Aligned with existing literature [4,6,7,8,9,10,11,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28], which highlights the significance of temporal analysis of urban data in informing planning and decision-making, this study utilizes similar time series methodologies to analyze and visualize urban challenges. A detailed analysis of various components of this effort follows.
Understanding Temporal Dynamics: The time series analysis reveals a compelling narrative of how citizen-reported urban issues in the Municipality of Patras have evolved over time. The general upward trend in reported issues suggests a growing engagement of citizens with the problem-mapping platform. However, the true richness of the insights lies in the ability to discern underlying patterns and seasonality.
Impact of Seasonality on Urban Issues: The seasonal decomposition analysis sheds light on the impact of seasonality on reported urban issues. The recurring patterns, characterized by elevated levels in the summer months and reduced concentrations in winter, underscore the influence of external factors. Increased tourism, construction activity, and shifts in weather patterns contribute to these seasonal variations, enriching our understanding of the multifaceted nature of urban challenges.
Contributing Factors to Fluctuations: The application of a 7-day moving average proves instrumental in identifying contributing factors to fluctuations in reported issues. Major weather events, changes in government policies, and heightened awareness campaigns emerge as potential influencers. The nuanced approach provided by the moving average allows for a more refined analysis, enabling stakeholders to discern the genuine trends amid the noise.
City-Wide vs. Specific Area Analysis: Distinguishing between city-wide and specific area analyses reveals intriguing insights into the dynamic nature of urban issues. While the overall trend showcases a consistent upward trajectory, the specific area analysis highlights the interplay between the overarching trend and unique characteristics of each neighborhood. This nuanced perspective is vital for tailoring interventions to the distinct needs of different areas.
Projection and Forecasting: The forecasting aspect of our analysis extends the temporal lens, offering a glimpse into the future trajectory of urban issues. The consistent upward trend in both overall city issues and those reported in specific areas suggests a sustained need for civic engagement and proactive urban management. The projections, rooted in historical data, provide a valuable tool for city stakeholders to anticipate challenges and allocate resources efficiently.
Implications for Urban Management: The findings of this study have significant implications for urban management and policy formulation. By unraveling the temporal dynamics of citizen-reported urban issues, stakeholders gain a comprehensive understanding of when and where challenges are likely to emerge. This knowledge empowers proactive decision-making, enabling the allocation of resources based on anticipated needs and contributing to the development of targeted interventions.
Limitations and Future Directions: While our analysis provides valuable insights, it is essential to acknowledge certain limitations. The dataset's completeness and representativeness, as well as the potential biases in citizen reporting, could influence the results. Future research could delve into the refinement of forecasting models, incorporating additional variables, and refining the granularity of area-specific analyses for more precise insights.

5. Conclusions

This effort digs into the temporal dynamics of citizen-reported urban challenges within the vibrant Municipality of Patras, Greece. By emphasizing the significance of citizen engagement and leveraging digital platforms, particularly through the lens of time series analysis, the research sought to unravel the intricate patterns and trends inherent in civic concerns. Essentially, by adopting a robust methodology based on time series analysis, this study makes a substantial contribution to the evolving field of smart urban management. It provides a valuable road map for effectively addressing the dynamic and asynchronous nature of today's civic challenges.
Analyzing seasonality in the dataset unveiled variations in urban issues, peaking in summer and decreasing in winter, offering crucial insights into the influence of external factors like tourism, construction, and weather patterns. The utilization of a 7-day moving average played a key role in identifying factors contributing to reported issue fluctuations, encompassing major weather events and policy changes. Distinct analyses for city-wide and specific areas highlighted the dynamic relationship between overall trends and unique neighborhood characteristics, facilitating tailored interventions.
The forecasting component provided a forward-looking perspective, revealing a consistent upward trend in urban issues. This emphasized the enduring necessity for civic engagement and proactive urban management. Historical data-based projections emerged as a valuable tool, aiding city stakeholders in anticipating challenges and optimizing resource allocation efficiently. The implications of this study for urban management and policy formulation are substantial. Deciphering the temporal dynamics of citizen-reported urban issues provides stakeholders with a thorough comprehension of the likely timing and locations of challenges. This awareness empowers proactive decision-making, allowing for resource allocation in anticipation of needs and facilitating the implementation of targeted interventions.
While the analysis provides valuable insights, certain limitations, such as dataset completeness, representativeness, and potential biases in citizen reporting, have been acknowledged. Future research directions may involve refining forecasting models, incorporating additional variables, and enhancing the granularity of area-specific analyses for more precise insights. More specifically, the implementation of time series models in smart cities presents challenges that demand careful consideration for effective implementation. These models heavily rely on substantial amounts of high-quality data. In numerous instances, smart city data may exhibit sparsity, noise, or incompleteness. It is imperative to enhance data collection infrastructure, deploy data cleaning techniques, and explore methods to address missing data [29,30,31].
Managing sensitive data in smart cities introduces privacy concerns, as time series models have the potential to unveil personal information or patterns susceptible to misuse. Mitigating these risks involves implementing robust data anonymization techniques, encryption, and adopting privacy-preserving methodologies while ensuring compliance with data protection regulations. Certain time series models, particularly deep learning models, may be intricate and challenging to interpret. This becomes a significant concern in applications where decision-makers require a clear understanding of model outputs. Addressing this issue involves the development of interpretable models or methods to explain model predictions, fostering transparency and trust [30,31,32,33].
Smart city applications often demand real-time processing, and some time series models may pose challenges due to high computational demands, leading to latency issues. Addressing this involves optimizing algorithms for real-time processing, exploring edge computing solutions, and leveraging hardware acceleration where applicable [29,31,32].
With the growth of smart cities, the volume of data to be processed increases, and many time series models may not efficiently scale to handle this growing data load. Overcoming scalability challenges requires the design of scalable architectures, consideration of distributed computing frameworks, and exploration of cloud-based solutions. Smart city environments are dynamic, leading to changing patterns in data over time. Some time series models may struggle to adapt to these changes. Implementing adaptive models that can learn and adjust to changing patterns, along with regular updates based on the latest data, is essential. Smart city data originates from diverse sources and formats. Integrating heterogeneous data into time series models poses a challenge. Addressing this requires the development of data integration standards, utilization of interoperable data formats, and exploration of techniques for harmonizing data from different sources [30,31,32,33,34,35].

Author Contributions

Andreas F. Gkontzis, and Vassilios S. Verykios; methodology, Andreas F. Gkontzis.; software, Andreas F. Gkontzis; validation, Andreas F. Gkontzis, Sotiris Kontsiantis, Georgios Feretzakis, and Vassilios S. Verykios; formal analysis, Andreas F. Gkontzis.; investigation, Andreas F. Gkontzis, and Sotiris Kontsiantis; resources, Andreas F. Gkontzis; data curation, Andreas F. Gkontzis, Sotiris Kontsiantis, Georgios Feretzakis and Vassilios S. Verykios; writing—original draft preparation, Andreas F. Gkontzis, and Vassilios S. Verykios; visualization, Andreas F. Gkontzis, and Vassilios S. Verykios; supervision, Andreas F. Gkontzis.; project administration. All authors have read and agreed to the published version of the manuscript.

Funding

This research received no external funding.

Conflicts of Interest

The authors declare no conflict of interest.

References

  1. Gkontzis, A.F.; Kontsiantis, S.; Feretzakis, G.; Verykios, V.S. Enhancing Urban Resilience: Smart City Data Analyses, Forecasts, and Digital Twin Techniques at the Neighborhood Level. Future Internet 2024. (in press). [CrossRef]
  2. Arafet, K., & Berlanga, R. Digital Twins in Solar Farms: An Approach through Time Series and Deep Learning. Algorithms 2021, 14, 156. [CrossRef]
  3. Hu, W., He, Y., Liu, Z., Tan, J., Yang, M., & Chen, J. Toward a Digital Twin: Time Series Prediction Based on a Hybrid Ensemble Empirical Mode Decomposition and BO-LSTM Neural Networks. J. Mech. Des. 2020, 143. [CrossRef]
  4. Zhang, T., Liu, X., Luo, Z., Dong, F., & Jiang, Y. Time series behavior modeling with digital twin for Internet of Vehicles. EURASIP J. Wirel. Commun. Netw. 2019. [CrossRef]
  5. Wang, F. Does the construction of smart cities make cities green? Evidence from a quasi-natural experiment in China. Cities 2023, 140, 104436. [CrossRef]
  6. Fu, H., Hong, N., Liao, C. Spatio-temporal patterns of Chinese urban recovery and system resilience under the pandemic new normal. Cities 2023, 140, 104385. [CrossRef]
  7. Damianou, A., Vayona, A., Demetriou, G. An actionable maturity planning model for smart, circular cities. Cities 2023, 140, 104403. [CrossRef]
  8. Oh, J.; Seo, M. Measuring Citizens-Centric Smart City: Development and Validation of Ex-Post Evaluation Framework. Sustainability 2021, 13, 11497. [CrossRef]
  9. Mai, G., Huang, W., Sun, J. On the Opportunities and Challenges of Foundation Models for Geo-spatial, Artificial Intelligence. ACM 2018. [CrossRef]
  10. Nejadshamsi, S., Eicker, U., Wang, C., Bentahar, J. Data sources and approaches for building occupancy profiles at the urban scale – A review. Building and Environment 2023, 238, 110375. https://doi.org/10.1016/j.buildenv.2023.110375. Jingrui Ju, Luning Liu, Yuqiang Feng. (2018). Citizen-centered big data analysis-driven governance intelligence framework for smart cities. Telecommunications Policy, 42(10), 881-896. [CrossRef]
  11. Ju, J., Liu, L., Feng, Y. Citizen-centered big data analysis-driven governance intelligence framework for smart cities. Telecommunications Policy, Volume 42, Issue 10, 2018, Pages 881-896. ISSN 0308-5961. [CrossRef]
  12. Xu, X., Hu, X., Zhao, Y. Urban short-term traffic speed prediction with complicated information fusion on accidents. Expert Systems with Applications 2023, 224, 119887. [CrossRef]
  13. Lucendo-Monedero, Á.L.; Ruiz-Rodríguez, F.; González-Relaño, R. The information society and socio-economic sustainability in European regions. Spatio-temporal changes between 2011 and 2020. Technology in Society 2023, 75, 102337. [CrossRef]
  14. De Meyer, A.; Bastiaens, L.; Schoeters, F. Spatio-temporal techno-economic assessment of the al-gae-based supply chain: A proof-of-concept for North-West Europe. Algal Research 2023, 76, 103312. [CrossRef]
  15. Yin, C.; Meng, F.; Yang, X. Spatio-temporal evolution of urban built-up areas and analysis of driving factors —A comparison of typical cities in north and south China. Land Use Policy 2022, 117, 106114. [CrossRef]
  16. Ye, C.; Hu, M.; Lu, L. Spatio-temporal evolution and factor explanatory power analysis of urban resilience in the Yangtze River Economic Belt. Geography and Sustainability 2022, 3(4), 299-311. [CrossRef]
  17. Li, J.; Xie, B.; Dong, H. The impact of urbanization on ecosystem services: Both time and space are important to identify driving forces. Journal of Environmental Management 2023, 347, 119161. [CrossRef]
  18. Champlin, C.; Sirenko, M.; Comes, T. Measuring social resilience in cities: An exploratory spatio-temporal analysis of activity routines in urban spaces during Covid-19. Cities 2023, 135, 104220. [CrossRef]
  19. Zhang, L.; Fang, C.; Zhao, R. Spatial–temporal evolution and driving force analysis of eco-quality in urban agglomerations in China. Science of The Total Environment 2023, 866, 161465. [CrossRef]
  20. Mantilla Caicedo, G.C.; Rusticucci, M.; Suli, S. Spatio-temporal multidisciplinary analysis of socio-environmental conditions to explore the COVID-19 early evolution in urban sites in South America. Heliyon 2023, 9(5), e16056. [CrossRef]
  21. Yu, S.; Leichtle, T.; Zhang, Z. Does urban growth mean the loss of greenness? A multi-temporal analysis for Chinese cities. Science of The Total Environment 2023, 898, 166373. [CrossRef]
  22. Kakooei, M.; Baleghi, Y. Spatial-Temporal analysis of urban environmental variables using building height features. Urban Climate 2023, 52, 101736. [CrossRef]
  23. Shang, W.-L.; Chen, Y.; Yu, Q. Spatio-temporal analysis of carbon footprints for urban public transport systems based on smart card data. Applied Energy 2023, 352, 121859. [CrossRef]
  24. Yan, Z.; Guo, X.; Zhao, Z. Achieving fine-grained urban flood perception and spatio-temporal evolution analysis based on social media. Sustainable Cities and Society 2024, 101, 105077. [CrossRef]
  25. Bhattacharjee, S.; Lekshmi, K.; Bharti, R. Time series analysis of urbanisation impact on the temperature variations off Mumbai coast. Int. Arch. Photogramm. Remote Sens. Spatial Inf. Sci. 2021, XLIII-B3-2021, 31–37. [CrossRef]
  26. Ingole, V.; Sheridan, S.C.; Juvekar, S. Mortality risk attributable to high and low ambient temperature in Pune city, India: A time series analysis from 2004 to 2012. Environmental Research 2022, 204(Part C), 112304. [CrossRef]
  27. Cuerdo-Vilches, T.; Díaz, J.; López-Bueno, J.A.; Luna, M.Y.; Navas, M.A. Impact of urban heat islands on morbidity and mortality in heat waves: Observational time series analysis of Spain's five cities. Science of The Total Environment 2023, 890, 164412. [CrossRef]
  28. Wicki, B.; Flückiger, B.; Vienneau, D. Socio-environmental modifiers of heat-related mortality in eight Swiss cities: A case time series analysis. Environmental Research 2024, 246, 118116. [CrossRef]
  29. Gubareva R., Lopes R.P. Literature Review on the Smart City Resources Analysis with Big Data Methodologies. SN Computer Science 2024, 5(1), Article ID: 02457. [CrossRef]
  30. Gkontzis, A.F.; Kalles, D.; Paxinou, E.; Tsoni, R.; Verykios, V.S. A Big Data Analytics Conceptual Framework for a Smart City: A Case Study. In: Fitsilis, P. (eds) Building on Smart Cities Skills and Competences. Internet of Things. Springer, Cham, 2022. [CrossRef]
  31. Hammad S.S., Iskandaryan D., Trilles S. An unsupervised TinyML approach applied to the detection of urban noise anomalies under the smart cities environment (2023) Internet of Things (Netherlands), 23. [CrossRef]
  32. Kuang Z., Chen C. Research on smart city data encryption and communication efficiency improvement under federated learning framework (2023) Egyptian Informatics Journal, 24 (2), pp. 217 - 227. [CrossRef]
  33. Monje L., Carrasco R.A., Rosado C., Sánchez-Montañés M. Deep Learning XAI for Bus Passenger Forecasting: A Use Case in Spain (2022) Mathematics, 10 (9). [CrossRef]
  34. Nauman A., Alruwais N., Alabdulkreem E., Nemri N., Aljehane N.O., Dutta A.K., Assiri M., Khan W.U. Empowering smart cities: High-altitude platforms based Mobile Edge Computing and Wireless Power Transfer for efficient IoT data processing (2023) Internet of Things (Netherlands), 24. [CrossRef]
  35. Jnr B.A., Sylva W., Watat J.K., Misra S. A Framework for Standardization of Distributed Ledger Technologies for Interoperable Data Integration and Alignment in Sustainable Smart Cities (2023) Journal of the Knowledge Economy. [CrossRef]
Preprints 97802 g001
Figure 1. Time series analysis methods.
Figure 1. Time series analysis methods.
Preprints 97802 g001
Preprints 97802 g002
Figure 2. Time analysis of daily areas.
Figure 2. Time analysis of daily areas.
Preprints 97802 g002
Preprints 97802 g003
Figure 3. Time analysis of daily areas with a 7-day moving average.
Figure 3. Time analysis of daily areas with a 7-day moving average.
Preprints 97802 g003
Preprints 97802 g004
Figure 4. Time analysis of daily city issues.
Figure 4. Time analysis of daily city issues.
Preprints 97802 g004
Preprints 97802 g005
Figure 5. Time series analysis: daily issues with a 7-day moving average.
Figure 5. Time series analysis: daily issues with a 7-day moving average.
Preprints 97802 g005
Preprints 97802 g006
Figure 6. A seasonally decomposed time series analysis for areas.
Figure 6. A seasonally decomposed time series analysis for areas.
Preprints 97802 g006
Preprints 97802 g007
Figure 7. A seasonally decomposed time series analysis for issues.
Figure 7. A seasonally decomposed time series analysis for issues.
Preprints 97802 g007
Preprints 97802 g008
Figure 8. The seasonal component indicates a 3-month cyclical behavior for issues.
Figure 8. The seasonal component indicates a 3-month cyclical behavior for issues.
Preprints 97802 g008
Preprints 97802 g009
Figure 9. The seasonal component indicates a 6-month cyclical behavior for issues.
Figure 9. The seasonal component indicates a 6-month cyclical behavior for issues.
Preprints 97802 g009
Preprints 97802 g010
Figure 10. The seasonal component indicates a 3-month cyclical behavior for Areas.
Figure 10. The seasonal component indicates a 3-month cyclical behavior for Areas.
Preprints 97802 g010
Preprints 97802 g011
Figure 11. The seasonal component indicates a 6-month cyclical behavior for Areas.
Figure 11. The seasonal component indicates a 6-month cyclical behavior for Areas.
Preprints 97802 g011
Preprints 97802 g012
Figure 12. The Holt-Winters Triple Exponential Smoothing Forecast for city issues.
Figure 12. The Holt-Winters Triple Exponential Smoothing Forecast for city issues.
Preprints 97802 g012
Preprints 97802 g013
Figure 13. Τhe Holt-Winters Triple Exponential Smoothing Forecast for city areas.
Figure 13. Τhe Holt-Winters Triple Exponential Smoothing Forecast for city areas.
Preprints 97802 g013
Table 1. The statistical summary of the generated data.
Table 1. The statistical summary of the generated data.
COUNT UNIQUE TOP FREQ MEAN STD MIN 0,25 0,5 0,75 MAX
LATITUDE 93053 162 Agyia 5881 38 0 38 38 38 38 38
LONGITUDE 93053 8 garbage 31836 21 0 21 21 21 21 21
AREAS 93043 89003 43752 4 NaN NaN NaN NaN NaN NaN NaN
AREAS_INT 93053 0,3138 90 53 1 41 89 144 171
ISSUE 93053 NaN NaN NaN NaN NaN NaN NaN
ISSUE_INT 93053 2 1 1 1 2 4 8
REPORTED_DATE_TIME 93053 nan nan nan nan nan nan nan
YEAR 93053 2020 1 2018 2019 2021 2022 2023
MONTH 93053 6 3 1 4 7 9 12
DAY 93053 15 8 1 8 16 23 31
HOUR 93053 10 4 0 7 9 12 23
MINUTE 93053 29 17 0 15 30 45 59
ISSUE_PROBABILITY 93053 69 17 23 57 72 84 100
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.
Copyright: This open access article is published under a Creative Commons CC BY 4.0 license, which permit the free download, distribution, and reuse, provided that the author and preprint are cited in any reuse.
Prerpints.org logo

Preprints.org is a free preprint server supported by MDPI in Basel, Switzerland.

facebook logotwitter logolinkedin logo
MDPI Initiatives
Important Links
Subscribe

Disclaimer

Terms of Use

Privacy Policy

© 2024 MDPI (Basel, Switzerland) unless otherwise stated