Mapping COVID-19 epidemic data using FOSS
This is a modal window.
The media could not be loaded, either because the server or network failed or because the format is not supported.
Formal Metadata
| Title |
| |
| Title of Series | ||
| Number of Parts | 266 | |
| Author | ||
| License | CC Attribution 3.0 Germany: You are free to use, adapt and copy, distribute and transmit the work or content in adapted or unchanged form for any legal purpose as long as the work is attributed to the author in the manner specified by the author or licensor. | |
| Identifiers | 10.5446/66468 (DOI) | |
| Publisher | ||
| Release Date | ||
| Language |
Content Metadata
| Subject Area | ||
| Genre | ||
| Abstract |
|
00:08
Civil engineeringIntegrated development environmentInformationAngular resolutionPattern languageLocal GroupTemporal logicDistribution (mathematics)DivisorData managementPhysical systemDatabaseComputer fileDatabaseServer (computing)Software maintenanceOperator (mathematics)LoginTable (information)GeometryWKB-MethodeRepresentation (politics)Parameter (computer programming)Component-based software engineeringOpen sourceClient (computing)Revision controlScripting languageLibrary (computing)Web pageArtistic renderingBasis <Mathematik>Variable (mathematics)Fluid staticsMathematical analysisVisual systemCluster samplingSpacetimeExecution unit9K33 OsaReading (process)View (database)Sign (mathematics)Convex hullAsynchronous Transfer ModeBookmark (World Wide Web)Data typeDecision theoryComputer wormTime domainProbability density functionTexture mappingOpen sourceDialectInterface (computing)Bootstrap aggregatingLevel (video gaming)Server (computing)Web 2.0Pattern recognitionGroup actionCoprocessorSpacetimeSet (mathematics)Front and back endsData managementTable (information)MappingConnectivity (graph theory)Physical systemComputer configurationGeometryRepresentation (politics)WebsiteVideoconferencingVariable (mathematics)DatabasePosition operatorParameter (computer programming)Presentation of a groupSoftware maintenanceForcing (mathematics)Temporal logicVisualization (computer graphics)Image resolutionGene clusterNumberProjective planePattern languageBoundary value problemLibrary (computing)Distribution (mathematics)Autonomic computingMathematical analysisRevision controlDivisorOperator (mathematics)Angular resolutionLoginFitness functionProcedural programmingData structureDependent and independent variablesState of matterTwitterClient (computing)Computer animationXML
02:41
Image resolutionSource code
02:49
Level (video gaming)QuicksortDistribution (mathematics)Observational studyRepresentation (politics)Point (geometry)CASE <Informatik>AreaNumberGraphical user interfaceData structureMoment (mathematics)Different (Kate Ryan album)Integrated development environmentInterface (computing)StatisticsVideoconferencingComputer animation
05:08
Data typeComputer animation
Transcript: English(auto-generated)
00:10
Okay, this is my presentation, is mapping COVID-19 epidemic data using FOSS. The detection of spatial and temporal patterns in epidemic distribution is an important
00:21
factor in determining policy approaches to pandemic management, containment, and eradication. The national databases usually publish data only at regional level, but they aren't fit for pattern detection. The spatial resolution is not so high. And for this reason, the data set collecting the official number of the infected, infected in healthy residence, clearly recovered, the deceased and their age group for the autonomous
00:44
region of Trentino in Italy, where we work, was developed. The data set contains daily data at the medicinal level starting from the beginning of the COVID-19 epidemic in March 2020 until the whole 2022. The backend of the systems runs a database management system which organizes the data
01:01
including the spatial components, web server, which provides access to the user, and the DBMs. MS runs on MySQL with tables containing data, tables containing geometry, service tables for the representation parameters, login credential for maintenance operators, and custom procedures in PHP that allow the update of the data set from CSV files.
01:22
The Web GIS is entirely client side using the open source leaflet JavaScript libraries and the bootstrap library version 4.4.1 is used for the front-end picture structuring. This approach ensures flexibility and responsiveness on desktop and mobile services. Cartographic data include background maps from the OpenStreetMap project and a map
01:43
of municipality boundaries from Trento. It is possible to choose a week under a slider in the interface, which is an interactive interface. We will see in one minute. The Web GIS provides a simple way to interact with the special representation of the spreading of the COVID-19 pandemic and the associated variables in the Trentino province.
02:02
The advance of static maps is self-evident and state exploration across space and time allows the visualization of clusters and trends. The significant flexibility offered by for spatial analysis such as QGIS, MySQL, and the leaflet or bootstrap libraries as well as the simplicity of the combined use has
02:21
been important for the installation and setup of the system. The Web GIS is available at the site that you see here and also in the paper. And I will go for a short video here, which is if I am able to go back to okay,
02:42
which is without audio, but just to see, okay, the solution is not fantastic, but let's see. We see that actually you can move interactively from one point to another and you see in the area, or you should see actually because it is not so clear, you can move in this
03:04
case is the cases, the week cases each 100,000 people and you can have the movement both at a spatial level and at a statistical level in the same moment in this graphical interface. And you can also have the same interface which is used to display the data in different
03:25
other situations like this is new deceased people for each week always on every 100,000 people and it is both the statistical level and the graphical level with the distribution on the different municipalities.
03:41
And the same applies, this is the new people who are actually recovered each week for each 100,000 people and again, it is a graphical and statistical representation on that. And in this case, we have the representation on a municipal level on the territory and
04:00
how many people are, how many cases are active on each 100,000 people inhabitants. Again, we have this structure in which you can see for each municipality how many people are actually affected in the region.
04:21
And this is a sort of way in which we can see the things graphically, but they are also very easy to consult and to share also in different kind of environments. Last thing is how many people are recovered in the accumulate numbers of the people recovered
04:42
in percentage and you see that is the number is accumulating until the end of the video of the video interested by the study. And that's it, you can actually consult some things specifically on the map.
05:03
I think it's okay.