README.md

nurses-earnings

Collecting and visualising data about earnings among Polish nurses.

Plans for the future:

• allow users to add a few working places at a time, with more details
• allow users to modify the data they entered
• create an interactive dashboard allowing to check wages depending on years of experience, sex, age, education, regions, workplace, etc

Virtual environment

To activate this environment, use

conda activate nurses-earnings

To deactivate an active environment, use

conda deactivate

Install requirements.txt

conda install --file requirements.txt

Python version

Python 3.8.2

Run Flask application

Ubuntu

cd website
export FLASK_APP=app.py
flask run

Windows - PowerShell

cd website
$env:FLASK_APP = "app.py"
$env:FLASK_ENV = "development"  # trigger reloader on file changes
flask run

Resources

• Maps of Poland with voivodeships and counties in geojson format: https://github.com/ppatrzyk/polska-geojson
• Table with information about powiats: Source: Wikipedia -> "Lista powiatów w Polsce" accessed on 02/09/2020, CC BY-SA 3.0

Database

Add the postgresql bin directory path to the path environment variable

Configuring postreSQL PATH variable on Windows 7

Create database

psql --username=postgres -f db.sql

Add new table to database

psql --username=postgres -d nurses_earnings_db -f tables.sql