WebGIS-Application with animated radiologic data (4D) using Cesium
Our aim is show the radiologic data in the web of the country of Germany taking the data in a database using Flask to connect the database and the web.
Behrouz Hasanzadeh - (habe1015@hs-karlsruhe.de)
David Arenas Serrano - (daarser@upv.es)
David Montalvá España - (damones2@upv.es)
Juan Pedro Carbonell Rivera - (juacarri@upv.es)
The data used in this project are provided by GDR Germany - Federal Office for Radiation Protection. The data consists of all originally measured values from about 1800 sensors in a time interval of between 2015-10-12 00:00:00 and 2015-10-16 00:00:00, measurements are made each ten minutes. The file format is CSV. http://odlinfo.bfs.de/
- Notepad++ 6.8.8
- Pycharm 4.0.1
- Apache 2.2.22
- QGIS 2.12.3 'Lyon'
- PgAdminIII with Postgres 1.22.0
Note: If you are using OSGEO-Live 9.0 the three last programs are pre-installed.
- Python 2.7
- JavaScript 1.8
- HTML5
- CSS3
- Flask 0.10.1 (Python) http://flask.pocoo.org/
- sqlalchemy 1.0.11 (Python) http://www.sqlalchemy.org/
- pyscogp2 2.6.1 (Python) https://pypi.python.org/pypi/psycopg2
- Cesium 1.17
- jQuery UI 1.10.3
- D3 v3.0
#Structure of folders
Folder name | Description |
---|---|
static | contains the static part to WSGI Web site |
/3rdParty | contains js libraries (Cesium, D3 and JQuery) |
/css | contains style sheet language |
/fonts | contains leters types |
/img | contains all necessary image-files |
/js | contains all necessary javascript-files |
templates | contains all html files |
-
In pgAdminIII create a table named hska_exp in the postgres database. To make work easier is provided a SQL query in the repository, you can change the default database by your own database.
-
Import the data from the CSV file in the created table. The parameters to import the Radiation.CSV file into the table are:
Format: CSV Encoding: ISO _8859_5 Delimiter: ";"
-
Install the Python libraries. You can use the links provided in the External libraries chapter.
-
Download Cesium repository and put it in:
static/3rdParty/cesium
-
In the index.py file edit the line 17 with your own user and password (if you create the hska_exp table in a different database you must change in this step):
engine = create_engine('postgresql://name:password@localhost/databasename')
Note: You need to adapt your server to use wsgi.
Copyright (c) 2016, EurOpenSource Company.
see LICENSE.txt