A SPARLab project.
A database driven webapp that allows users to submit bike accidents and near-misses. Data is analyzed to detect areas/routes with high traffic and rates of incidents.
- Python 2.7
- Postgres 9.3 + PostGIS
- psycopg2
- Django 1.7
The development settings require a Postgres database called "bikeDB" accessible by user "postgres" that is not password protected. Be sure to add the postGIS extension. From the terminal, run:
createdb -U postgres bikeDB
psql -U postgres -d bikeDB -c "CREATE EXTENSON postgis;"
Syncing the tables from the Django app requires running
./manage.py makemigrations
./manage.py migrate
Additionally, the forum Django app "Spirit" (located at http://spirit-project.com/ and developed by Esteban Castro Borsani) requires it's own cachetable and fixture data be installed
./manage.py createcachetable spirit_cache
./manage.py loaddata spirit_init
A full list of required python packages can be found in requirements.txt and can be installed via pip
pip install -r requirements.txt
If all dependancies have been met, running ./manage.py runserver should start the development server at 127.0.0.1:8000
Note: There are additional requirements for serving this application in a production setting, and the relevant Django documentation should be consulted in this scenario. This repo does not provide production settings for security reasons.
Data is output by loggin into an admin account and selecting "Data to GeoJson" under the user dropdown menu in the navbar This geojson data can be used directly by QGis or converted to a shapefile using ogr2ogr tools. The easiest method to convert the output geojson text to a shapefile is to copy it from the webpage and past into the "Convert from GeoJSON" box at http://ogre.adc4gis.com/
- Dr. Trisalyn Nelson (Project Lead)
- Taylor Denouden (Developer)
- James Stephaniuk (Developer)