Charts and Maps for Statistical Yearbooks of Fire and Rescue
Service of the Czech Republic

J 2020

Charts and Maps for Statistical Yearbooks of Fire and Rescue Service of the Czech Republic

ŠPULÁK, Pavel; Bohuslav JEŽEK a Zdeněk ČERVENKA

Základní údaje

Originální název

Charts and Maps for Statistical Yearbooks of Fire and Rescue Service of the Czech Republic

Autoři

ŠPULÁK, Pavel; Bohuslav JEŽEK a Zdeněk ČERVENKA

Vydání

8th International Conference on Cartography & GIS, 2020, 1314-0604

Další údaje

Jazyk

angličtina

Typ výsledku

Článek v odborném periodiku

Stát vydavatele

Bulharsko

Utajení

není předmětem státního či obchodního tajemství

Odkazy

URL

Označené pro přenos do RIV

Organizační jednotka

Přírodovědecká fakulta

UT WoS

000853257000034

Klíčová slova anglicky

map; chart; automation; data mining; Python; ArcPy; Matplotlib; Pandas; statistical yearbook

Štítky

RIV ne

Příznaky

Mezinárodní význam, Recenzováno

Změněno: 22. 11. 2022 20:55, Ing. Pavel Špulák, Ph.D.

Anotace

V originále

For many years, Fire and Rescue Service of the Czech Republic annually publishes its Statistical Yearbook. This publication provides an overview of the past year's activities of the Fire and Rescue Service. It serves as a valuable data source for the professionals and presents the Fire and Rescue Service to the common public. Two types of data visualization are presented in the Yearbook, the charts of various types (line, bar, stacked bar, grouped bar and pie charts) and choropleth and kernel density map. To make the process of data visualizations less time demanding and error-proof, we decided to automatize it with the Python program, which reads data from the database and according to instructions in configuration files create desired outputs. The process starts with the transfer of all required data to the local SQLite/SpatiaLite database. The data are copied from comma-separated files or the database of the Operational center of Fire and Rescue Service of the Czech Republic. The data are read from the local database to the Pandas DataFrame. The data processing is done during the data read operation from the database through the SQL query sent to the database. After that, the Matplotlib library is used for charts creation and the ArcPy library for maps creation. The outputs of the program are the maps or charts images of various formats according to the possibilities provided by the libraries mentioned above and application settings.

Citovat

ŠPULÁK, Pavel; Bohuslav JEŽEK a Zdeněk ČERVENKA. Charts and Maps for Statistical Yearbooks of Fire and Rescue Service of the Czech Republic. 8th International Conference on Cartography & GIS. 2020, s. 332-341. ISSN 1314-0604.

@article{2233578,
   author = {Špulák, Pavel and Ježek, Bohuslav and Červenka, Zdeněk},
   keywords = {map; chart; automation; data mining; Python; ArcPy; Matplotlib; Pandas; statistical yearbook},
   language = {eng},
   issn = {1314-0604},
   journal = {8th International Conference on Cartography & GIS},
   title = {Charts and Maps for Statistical Yearbooks of Fire and Rescue Service of the Czech Republic},
   url = {https://iccgis2020.cartography-gis.com/proceedings-vol-1/},
   year = {2020}
}

TY  - JOUR
ID  - 2233578
AU  - Špulák, Pavel - Ježek, Bohuslav - Červenka, Zdeněk
PY  - 2020
TI  - Charts and Maps for Statistical Yearbooks of Fire and Rescue Service of the Czech Republic
JF  - 8th International Conference on Cartography & GIS
SP  - 332-341
EP  - 332-341
SN  - 13140604
KW  - map
KW  - chart
KW  - automation
KW  - data mining
KW  - Python
KW  - ArcPy
KW  - Matplotlib
KW  - Pandas
KW  - statistical yearbook
UR  - https://iccgis2020.cartography-gis.com/proceedings-vol-1/
N2  - For many years, Fire and Rescue Service of the Czech Republic annually publishes its Statistical Yearbook. This publication provides an overview of the past year's activities of the Fire and Rescue Service. It serves as a valuable data source for the professionals and presents the Fire and Rescue Service to the common public. Two types of data visualization are presented in the Yearbook, the charts of various types (line, bar, stacked bar, grouped bar and pie charts) and choropleth and kernel density map. To make the process of data visualizations less time demanding and error-proof, we decided to automatize it with the Python program, which reads data from the database and according to instructions in configuration files create desired outputs. The process starts with the transfer of all required data to the local SQLite/SpatiaLite database. The data are copied from comma-separated files or the database of the Operational center of Fire and Rescue Service of the Czech Republic. The data are read from the local database to the Pandas DataFrame. The data processing is done during the data read operation from the database through the SQL query sent to the database. After that, the Matplotlib library is used for charts creation and the ArcPy library for maps creation. The outputs of the program are the maps or charts images of various formats according to the possibilities provided by the libraries mentioned above and application settings.
ER  -

ŠPULÁK, Pavel; Bohuslav JEŽEK a Zdeněk ČERVENKA. Charts and Maps for Statistical Yearbooks of Fire and Rescue Service of the Czech Republic. \textit{8th International Conference on Cartography \&{} GIS}. 2020, s.~332-341. ISSN~1314-0604.

Přehled o publikaci