<!DOCTYPE article PUBLIC "-//NLM//DTD JATS (Z39.96) Journal Archiving and Interchange DTD v1.0 20120330//EN" "JATS-archivearticle1.dtd">
<article xmlns:xlink="http://www.w3.org/1999/xlink">
  <front>
    <journal-meta />
    <article-meta>
      <title-group>
        <article-title>Developing a Decision Support System with a Georeferenced Smart City Security Index (SCSI): A Case Study of Messina</article-title>
      </title-group>
      <contrib-group>
        <contrib contrib-type="author">
          <string-name>Giuseppe Accardo</string-name>
          <email>gi.accardo@almaviva.it</email>
          <xref ref-type="aff" rid="aff0">0</xref>
          <xref ref-type="aff" rid="aff1">1</xref>
        </contrib>
        <contrib contrib-type="author">
          <string-name>Roberta Marino</string-name>
          <email>r.marino@almaviva.it</email>
          <xref ref-type="aff" rid="aff0">0</xref>
          <xref ref-type="aff" rid="aff1">1</xref>
        </contrib>
        <contrib contrib-type="author">
          <string-name>Valentina Esposito</string-name>
          <email>v.esposito@almaviva.it</email>
          <xref ref-type="aff" rid="aff0">0</xref>
          <xref ref-type="aff" rid="aff1">1</xref>
        </contrib>
        <aff id="aff0">
          <label>0</label>
          <institution>Data Jam srl, Centro Direzionale Isola F8</institution>
          ,
          <addr-line>Via F. Lauria, Naples, 80143</addr-line>
          ,
          <country country="IT">Italy</country>
        </aff>
        <aff id="aff1">
          <label>1</label>
          <institution>Ital-IA 2024: 4th National Conference on Artificial Intelligence</institution>
          ,
          <addr-line>organized by CINI</addr-line>
        </aff>
      </contrib-group>
      <abstract>
        <p>With the rapid growth of urban population, cities are facing increasing challenges in terms of mobility, sustainability, and living conditions. Smart cities leverage advanced technologies to improve urban efficiency and citizens' quality of life. This work aims to empower the Public Administration (PA) of Messina, a medium-sized Italian city, with a georeferenced Smart City Security Index (SCSI) to monitor urban security and inform decision-making processes. To achieve this, we trained a Random Forest Regressor using open data alongside territory specific key performance indicators (KPIs) and insecurity indicators. The model assigns a security score from 0 to 100 to each city area, achieving a Root Mean Squared Error (RMSE) of 5.6 on the test set. Furthermore, integrating the model with a Decision Support System (DSS) allows PA members to assess changes in the SCSI in response to adjustments made to the input factors, supporting decision-making.</p>
      </abstract>
      <kwd-group>
        <kwd>eol&gt;smart city</kwd>
        <kwd>open data</kwd>
        <kwd>decision support system 1</kwd>
      </kwd-group>
    </article-meta>
  </front>
  <body>
    <sec id="sec-1">
      <title>1. Introduction</title>
      <p>This work aims to leverage Artificial Intelligence (AI)
to develop a specific smart city index for monitoring
urban security in Messina, ultimately contributing to
a smarter city.</p>
      <p>The concept of a "smart city" encompasses the
integration of technology and urban planning to
enhance a city's sustainability, efficiency, and
innovation. Several Smart City Indices (SCIs) have
been developed in the literature to assess and
quantify these aspects. These indices typically
consider a range of services and projects that
contribute to a city's "smartness," encompassing
areas like public safety (e.g., reduced traffic accidents)
and environmental sustainability.
SCIs function by aggregating multiple variables and
indicators into a single score, providing a statistical
summary of a city's overall performance. Monitoring
this score over time allows for evaluation of a city's
progress in achieving its "smart city" goals.
Table 1 summarizes some of the most widely
recognized SCIs from the literature.</p>
      <p>AI, on the other hand, has become a crucial tool for
researchers in smart city initiatives. This, coupled
with the open data movement, has spurred further
research using these sophisticated techniques to
unlock the potential of data in realizing smart city
goals.</p>
      <p>
        There is some evidence of positive impacts in the
transportation, sustainability, or security fields [
        <xref ref-type="bibr" rid="ref7">7</xref>
        ][
        <xref ref-type="bibr" rid="ref8">8</xref>
        ]
[
        <xref ref-type="bibr" rid="ref9">9</xref>
        ][
        <xref ref-type="bibr" rid="ref10">10</xref>
        ][
        <xref ref-type="bibr" rid="ref11">11</xref>
        ][
        <xref ref-type="bibr" rid="ref12">12</xref>
        ].
© 2024 Copyright for this paper by its authors. Use permitted under
Creative Commons License Attribution 4.0 International (CC BY 4.0).
      </p>
      <p>This work aims to equip the Public Administration
(PA) of Messina with a tool for monitoring urban
security and informing decision-making processes.
This tool leverages a georeferenced and machine
learning-based Smart City Security Index (SCSI)</p>
    </sec>
    <sec id="sec-2">
      <title>2. Materials and Methods</title>
      <p>This section details the data sources utilized for this
study. We describe the steps involved in constructing
the variables that will be employed by the machine
learning (ML) model. Additionally, we present an
overview of the exploratory analyses conducted to
gain insights into the characteristics of the dataset.
The city is subdivided into 287 spatial units (tiles),
each encompassing an area of 1 km². The SCSI will be
used to assess the security level of each tile over time.
It follows that each feature within the dataset must
adhere to a specific structure, consisting of a unique
triad: geometry_id, month, and year. The year and
month fields represent the reference time, while the
geometry_id field uniquely identifies a tile.</p>
      <sec id="sec-2-1">
        <title>2.1. Open data</title>
        <p>We utilized open data from the city of
Messina, which are described in the
following section.</p>
        <p>
          Municipal Police measures gather data on
accidents involving traffic violations.
As an initial data preprocessing step, we
addressed missing geospatial coordinates.
We leveraged the Nominatim open-source
API [
          <xref ref-type="bibr" rid="ref13">13</xref>
          ] to geocode these locations using the
information provided in the "Luogo
Incidente" (incident location) text column.
Prior to geocoding, the text data underwent
cleaning procedures using natural language
processing (NLP) techniques. This process
successfully assigned geographic
coordinates to 84% of the previously
unknown locations. Next, we extracted the
variables of interest by aggregating the data
by geometry_id, year and month based on
the articles of traffic violation, according to
the regulation in Italy.
        </p>
        <p>This resulted in the following features:
•
•
•
•
•
•
“prov_precedenza” (precedence)
obtained as the sum of incidents
with violations of articles 145 and
150.
“prov_velocita” (speed) considers
only the violation of Article 141.
“prov_posizione” (position)
obtained as the sum of articles 154,
149, 143, 148 and 144.
“prov_documenti” (documents) as
the sum of Articles 80, 193, 116,
180, 126, 94 and 93.
“prov_sosta” (stop) derived as the
sum of articles 158 and 157.
“prov_segnaletica” (signals)
derived as the sum of incidents
with violation of Articles 40, 41
and 146.</p>
        <p>Like the approach used for Municipal Police
measures data, we addressed missing
geospatial coordinates within the Lighting
Points data. We employed the Nominatim
open-source API for geocoding, using the
information provided in the "Ubicazione
toponomastica" (toponomastic location)
text column. As with the previous data
source, text cleaning procedures were
necessary prior to geocoding, leveraging
NLP techniques. This process successfully
assigned geographic coordinates to 78% of
the locations where coordinates were
previously missing. Next, the feature of
interest, namely the number of public
lighting poles present in a certain time tile
(“n_pali_luce”), was calculated by summing
the poles falling by geospatial coordinates in
the analyzed tile.</p>
        <p>Urban Video surveillance details the
closedcircuit television (CCTV) system operating
within the Municipality. The data concern
only administration-owned cameras, all of
which are georeferenced, and have no
missing values. Here, the variable of interest
is the number of cameras present in a
specific time tile (“n_telecamere”). We
obtained this value by summing the CCTVs
that fall within the analyzed tile, based on
their geospatial coordinates.</p>
      </sec>
      <sec id="sec-2-2">
        <title>2.2. Digital exhaust data</title>
      </sec>
      <sec id="sec-2-3">
        <title>2.3. Data Preparation</title>
        <p>For the construction of the features, in
addition to the open data, we derived the
following geolocated indicators that can
characterize tiles in the city of Messina.
The “sentiment” index is a measure of
sentiment calculated on online content from
the analysis period within the selected tile. It
ranges from 0 to 100.</p>
        <p>The “footfall” score is an absolute, and
unlimited index that measures the foot
traffic and popularity of a tile. This indicator
considers various factors, such as the
number of geolocated reviews, content on
social media and aggregated and
anonymized data originated from mobile
devices.</p>
        <p>The remaining features: "degrado"
(degradation), "incendio" (arson),
"incidente" (accident), and "crimini"
(crimes), sum up the number of events
linked to each of these categories per tile,
year, and month. We collected this
information by web-scraping from open and
licensed/authorized closed sources such as
websites blogs, social media and Police.
After integrating the data described in the
previous sections into a single table, we
obtained a dataset with 12628 records, each
representing a unique triad of geometry_id,
month, and year.</p>
        <p>The dataset refers to the time frame January
2019-August 2022, extremes included.
We then proceeded to analyze the content of
this dataset, focusing initially on the target
variable for the machine learning model,
namely the "Security_Target".</p>
        <p>This variable, is a weighted average of a
qualitative and a quantitative index,
representing the security level of each tile.
The qualitative index considers the
sentiment of online reviews related to
security falling within each tile, while the
quantitative index reflects the number of
crimes committed. The qualitative index is
weighted by the number of reviews in each
tile, normalized between 0 and 1, while the
quantitative index has a constant weight of
1. Values of the target variable range from 0
(lowest security) to 100 (highest security).
Figure 1 illustrates that for specific month
and year, the target variable often takes the
value of 100, which corresponds to the
highest security level. Furthermore, as
shown in Figure 2, the distribution of the
target variable, considering the entire
dataset, exhibits a significant imbalance,
with the value 100 being the most frequent
by a considerable margin.</p>
        <p>To further explore the distribution of the
target variable, we visualized it after
excluding tiles with the highest security
level (value 100). As shown in Figure 3, the
remaining values exhibited a wider range,
suggesting a more informative distribution
for analysis.</p>
        <p>Nevertheless, it was necessary to consider
how to correct the imbalance in the values
assumed by the target.</p>
        <p>To understand the cause of this imbalance,
we examined the features associated with
tiles having the highest “Security_Target”
(value 100). Interestingly, we discovered
that 7812 records possessed identical
features. In all these cases, the feature values
were either 0 (indicating no events like for
instance arson) or NaN (meaning data on
factors like footfall and sentiment was
unavailable). Due to these missing or
noninformative features, we opted to remove
these duplicate rows.</p>
        <p>We obtained a dataset with 4816 records,
3398 of which were with target 100.
Following the initial data exploration, we
analyzed the prevalence of missing values
across all features (percentages shown in
Table 2). To address this issue, we excluded
observations where both sentiment and
footfall data were missing. This exclusion
step resulted in a dataset of 4654 records.
Subsequently, the data was split into
training and test sets. The training set
comprised 3257 records, while the test set
contained 1397 records.</p>
      </sec>
    </sec>
    <sec id="sec-3">
      <title>3. Results</title>
      <p>
        This section details the ML model which was selected
to compute the SCSI. This is a random forest regressor
from the library scikit-learn, whose hyperparameters
are indicated in Table 3. Analyzing the performance
metrics of the ML model in Table 4, the residuals in the
test set in Table 5 and the distribution of observed and
predicted values in Figure 4 we assessed its goodness.
Having established the validity of the chosen model,
we proceeded to analyze the impact of each feature on
the target variable. Shapley Additive exPlanations
(SHAP) values provide a useful graphical
representation of these feature importances [
        <xref ref-type="bibr" rid="ref14">14</xref>
        ]. A
beeswarm plot effectively visualizes the distribution
of SHAP values, highlighting the features that exert the
strongest influence on the model's predictions. Our
analysis in Figure 5 reveals that the "degrado" feature
has the greatest impact. High values of "degrado"
(represented by red in the beeswarm plot) are
associated with a lower SSCI, and vice versa. Similarly,
the "n_pali_luce" feature is the second most important,
with lower values corresponding to a reduced SSCI.
This analysis of feature importance provides key
insights into the behavior of the decision-support
system (DSS). Following model development, we
equipped the Public Administration of Messina with a
DSS that enables them to simulate the impact of
changes in the SSCI by modifying features within
selected city tiles (see Figure 6 and Figure 7). In
essence, these features function as controllable
parameters that can be adjusted to improve the
security level in specific areas.
      </p>
      <p>Building on a similar approach, we developed a
georeferenced green index (GI) for the PA of Messina
Hyperparameter
n_estimators
oob_score
criterion
max_depth
random_state
max_features
min_samples_split</p>
      <sec id="sec-3-1">
        <title>Value 100</title>
      </sec>
      <sec id="sec-3-2">
        <title>True 'squared_error’ None 0</title>
        <p>None
6
(see equation (1)). This index assigns a score between
0 and 100, quantifying the overall quality and quantity
of urban green space for each spatial unit. Similar to
the SCSI, the green index is designed for integration
with a DSS (see Figure 8 and Figure 9). However,
unlike the SCSI, it does not employ machine learning
techniques.</p>
        <p>Below the expression to calculate the GI:
 ( ) =
 1 ∗  +  2 ∗ ( + 
 1 +  2
∗  ∗ 100)
(1)</p>
      </sec>
      <sec id="sec-3-3">
        <title>Explanation of variables:</title>
        <p>1. UG (Urban green perception index): This
index reflects the perceived quality and user
experience of urban green spaces, derived
from analyzing online reviews.
2. HGA (Horizontal green area, m2):
Represents the area of gardens, parks, and
forests within the spatial unit.
3. TCA (Tree canopy area, m2): Calculated as
the sum of canopy area for all trees in the
spatial unit.
4. ELA (Emerged land area, m2): Represents
the total land area excluding water bodies
within the spatial unit.
5. α (Weight relative to the vegetative state of
the canopy area): Derived from Visual Tree
Assessment (VTA) data. It is calculated as
the weighted sum of the areas of tree crowns
within a tile, adjusted for their vegetative
state, divided by the total area of all tree
crowns in the tile.
6. w1 and w2: Weights assigned such that the
quantitative dimension (HGA and TCA)
contributes twice as much as the qualitative
dimension (UG) to the overall GI score.</p>
        <p>Overall, this project demonstrates the value of
datadriven approaches in urban planning. The SCSI and
DSS empower the PA to make informed decisions
regarding security, and the future integration of
machine learning into the Green Index holds further
promise for comprehensive urban management.</p>
      </sec>
    </sec>
  </body>
  <back>
    <ref-list>
      <ref id="ref1">
        <mixed-citation>
          [1]
          <string-name>
            <surname>Arcadis.</surname>
          </string-name>
          (
          <year>2022</year>
          , June 21).
          <source>The Arcadis Sustainable Cities Index</source>
          <year>2022</year>
          . [Member Spotlight]. Retrieved from https://www.arcadis.com/en/knowledgehub/perspectives/global/sustainable-citiesindex.
        </mixed-citation>
      </ref>
      <ref id="ref2">
        <mixed-citation>
          [2]
          <fpage>2thinknow</fpage>
          . (
          <year>2023</year>
          ).
          <article-title>Innovation Cities™ Index. Retrieved from https://innovationcities.com/worlds-most-innovative-</article-title>
          <string-name>
            <surname>cities-</surname>
          </string-name>
          2022
          <string-name>
            <surname>- 2023-</surname>
          </string-name>
          city-rankings/26453/
        </mixed-citation>
      </ref>
      <ref id="ref3">
        <mixed-citation>
          [3]
          <string-name>
            <given-names>International</given-names>
            <surname>Organization</surname>
          </string-name>
          for Standardization. (
          <year>2018</year>
          ).
          <article-title>ISO 37120:2018 Sustainable development of communities - Indicators for city services and quality of life.</article-title>
        </mixed-citation>
      </ref>
      <ref id="ref4">
        <mixed-citation>
          [4]
          <string-name>
            <given-names>International</given-names>
            <surname>Telecommunication</surname>
          </string-name>
          <article-title>Union (ITU). (n.d.). The Telecommunication Standardization Sector (ITU-T)</article-title>
          . Retrieved from https://www.itu.int/en/ITUT/Pages/default.aspx
        </mixed-citation>
      </ref>
      <ref id="ref5">
        <mixed-citation>
          [5]
          <string-name>
            <surname>Ericsson. (n.d.</surname>
          </string-name>
          ).
          <source>Networked Society City Index. Retrieved</source>
          from https://www.ericsson.com/en/reports-andpapers/networked-society-insights
        </mixed-citation>
      </ref>
      <ref id="ref6">
        <mixed-citation>
          [6]
          <string-name>
            <surname>Siemens</surname>
            <given-names>AG</given-names>
          </string-name>
          . (n.d.).
          <source>Siemens Green City Index</source>
          . Retrieved from https://assets.new.siemens.com/siemens/asset s/api/uuid:cf26889b-3254
          <string-name>
            <surname>-</surname>
          </string-name>
          4dcb-bc50
          <article-title>- fef7e99cb3c7/gci-report-summary</article-title>
          .pdf
        </mixed-citation>
      </ref>
      <ref id="ref7">
        <mixed-citation>
          [7]
          <string-name>
            <surname>Agarwal</surname>
            ,
            <given-names>P. K.</given-names>
          </string-name>
          ,
          <string-name>
            <surname>Gurjar</surname>
            ,
            <given-names>J.</given-names>
          </string-name>
          ,
          <string-name>
            <surname>Agarwal</surname>
            ,
            <given-names>A. K.</given-names>
          </string-name>
          , &amp;
          <string-name>
            <surname>Birla</surname>
            ,
            <given-names>R.</given-names>
          </string-name>
          (
          <year>2015</year>
          ).
          <article-title>Application of artificial intelligence for development of intelligent transport system in smart cities</article-title>
          .
          <source>Journal of Traffic and Transportation Engineering</source>
          ,
          <volume>1</volume>
          (
          <issue>1</issue>
          ),
          <fpage>20</fpage>
          -
          <lpage>30</lpage>
          .
        </mixed-citation>
      </ref>
      <ref id="ref8">
        <mixed-citation>
          [8]
          <string-name>
            <surname>Bharadiya</surname>
            ,
            <given-names>J.</given-names>
          </string-name>
          (
          <year>2023</year>
          ).
          <article-title>Artificial intelligence in transportation systems a critical review</article-title>
          .
          <source>American Journal of Computing and Engineering</source>
          ,
          <volume>6</volume>
          (
          <issue>1</issue>
          ),
          <fpage>34</fpage>
          -
          <lpage>45</lpage>
          .
        </mixed-citation>
      </ref>
      <ref id="ref9">
        <mixed-citation>
          [9]
          <string-name>
            <given-names>De</given-names>
            <surname>Las Heras</surname>
          </string-name>
          ,
          <string-name>
            <given-names>A.</given-names>
            ,
            <surname>Luque-Sendra</surname>
          </string-name>
          ,
          <string-name>
            <given-names>A.</given-names>
            , &amp;
            <surname>ZamoraPolo</surname>
          </string-name>
          ,
          <string-name>
            <surname>F.</surname>
          </string-name>
          (
          <year>2020</year>
          ).
          <article-title>Machine learning technologies for sustainability in smart cities in the post-covid era</article-title>
          .
          <source>Sustainability</source>
          ,
          <volume>12</volume>
          (
          <issue>22</issue>
          ),
          <fpage>9320</fpage>
          .
        </mixed-citation>
      </ref>
      <ref id="ref10">
        <mixed-citation>
          [10]
          <string-name>
            <surname>Hassan</surname>
            ,
            <given-names>S. I.</given-names>
          </string-name>
          , &amp;
          <string-name>
            <surname>Agarwal</surname>
            ,
            <given-names>P.</given-names>
          </string-name>
          (
          <year>2020</year>
          ).
          <article-title>Analytical approach to sustainable smart city using IoT and machine learning</article-title>
          .
          <source>In Big Data, IoT, and Machine Learning</source>
          (pp.
          <fpage>277</fpage>
          -
          <lpage>294</lpage>
          ). CRC Press.
        </mixed-citation>
      </ref>
      <ref id="ref11">
        <mixed-citation>
          [11]
          <string-name>
            <surname>Lourenço</surname>
            ,
            <given-names>V.</given-names>
          </string-name>
          ,
          <string-name>
            <surname>Mann</surname>
            ,
            <given-names>P.</given-names>
          </string-name>
          ,
          <string-name>
            <surname>Guimaraes</surname>
            ,
            <given-names>A.</given-names>
          </string-name>
          ,
          <string-name>
            <surname>Paes</surname>
            ,
            <given-names>A.</given-names>
          </string-name>
          , &amp; de Oliveira,
          <string-name>
            <surname>D.</surname>
          </string-name>
          (
          <year>2018</year>
          ,
          <article-title>July)</article-title>
          .
          <article-title>Towards safer (smart) cities: Discovering urban crime patterns using logic-based relational machine learning</article-title>
          .
          <source>In 2018 International Joint Conference on Neural Networks (IJCNN)</source>
          (pp.
          <fpage>1</fpage>
          -
          <lpage>8</lpage>
          ). IEEE.
        </mixed-citation>
      </ref>
      <ref id="ref12">
        <mixed-citation>
          [12]
          <string-name>
            <surname>Butt</surname>
            ,
            <given-names>U. M.</given-names>
          </string-name>
          ,
          <string-name>
            <surname>Letchmunan</surname>
            ,
            <given-names>S.</given-names>
          </string-name>
          ,
          <string-name>
            <surname>Hassan</surname>
            ,
            <given-names>F. H.</given-names>
          </string-name>
          ,
          <string-name>
            <surname>Ali</surname>
            ,
            <given-names>M.</given-names>
          </string-name>
          ,
          <string-name>
            <surname>Baqir</surname>
            ,
            <given-names>A.</given-names>
          </string-name>
          ,
          <string-name>
            <surname>Koh</surname>
            ,
            <given-names>T. W.</given-names>
          </string-name>
          , &amp;
          <string-name>
            <surname>Sherazi</surname>
            ,
            <given-names>H. H. R.</given-names>
          </string-name>
          (
          <year>2021</year>
          ).
          <article-title>Spatio-temporal crime predictions by leveraging artificial intelligence for citizens security in smart cities</article-title>
          .
          <source>IEEE Access</source>
          ,
          <volume>9</volume>
          ,
          <fpage>47516</fpage>
          -
          <lpage>47529</lpage>
          .
        </mixed-citation>
      </ref>
      <ref id="ref13">
        <mixed-citation>
          [13]
          <article-title>OpenStreetMap contributors, "Nominatim,"</article-title>
          <source>OpenStreetMap wiki</source>
          ,
          <year>2023</year>
          , https://nominatim.openstreetmap.org/.
        </mixed-citation>
      </ref>
      <ref id="ref14">
        <mixed-citation>
          [14]
          <string-name>
            <surname>Scott</surname>
            <given-names>M.</given-names>
          </string-name>
          <string-name>
            <surname>Lundberg</surname>
          </string-name>
          and
          <string-name>
            <surname>Su-In Lee</surname>
          </string-name>
          .
          <year>2017</year>
          .
          <article-title>A unified approach to interpreting model predictions</article-title>
          .
          <source>In Proceedings of the 31st International Conference on Neural Information Processing Systems (NIPS'17)</source>
          . Curran Associates Inc.,
          <string-name>
            <surname>Red</surname>
            <given-names>Hook</given-names>
          </string-name>
          ,
          <string-name>
            <surname>NY</surname>
          </string-name>
          , USA,
          <fpage>4768</fpage>
          -
          <lpage>4777</lpage>
          .
        </mixed-citation>
      </ref>
    </ref-list>
  </back>
</article>