Athletics Results Visualization is a Django app built to visualize athletics results of individual athletes It curretnly uses data from the HKSSF website. It uses chart.js as the javascript plotting tool.
- Start Django Project
django-admin startproject ath_res_vis_project
cd ath_res_vis_project
- Clone the git repository
git clone https://github.com/cameronlai/ath_res_vis
- Edit settings.py in your project folder
cd ath_res_vis_project
nano settings.py
Add 'ath_res_vis' in INSTALLED_APPS Add 'ath_res_vis/static/', in STATICFILES_DIR
- Edit urls.py in your project folder
nano urls.py
Add url(r'$^', include('ath_res_vis.urls')), to urlpatterns
- Run migrations with manage.py
cd ../
python manage.py migrate
-
Dump athletics results data into Database
- The data used are in PDF formats and they are copied into text files.
- process_data.py parses the data into a sqlite database format.
- export_sql.py copies the data from one database file to another.
- Data can be found from this link.
- You may write your own parser and reuse the web visualization part for other data.
- Run server
python manage.py runserver
- Launch web browser, enter correct IP address (Default is 127.0.0.1:8000) and your app is running.
The database is in the following format as in models.py
Field Name | Description |
---|---|
Name | Name of the athelete |
School | Name of the school the athlete is representing |
Event | Name of the event the athelete completed (e.g. 100m) |
Sex | Sex of the atehlete |
Result | Results of the athelete (either in seconds or meteres) |
Date | Date of the event completion |
IsTrack | True = Track event, False = field event |
- Chart.js
The app is released under the MIT License and more information can be found in the LICENSE file.
ath_res_vis is a project to help people visualize athletics results more easier, instead of looking up multiple PDF / old text formats. Contributions for improvements and bug fixes are sincerely welcome!