See the site at http://spectro.geol.wwu.edu

About the site:

• The primary use of the site is to search through a database containing VIS-NIR spectroscopy data, select samples from the search results, and then view the samples as a line/scatter plot. The users can also choose to download selected spectra in a zip file to perform any additional analysis. Some metadata about the samples, including a sample description is also available to view through the site, and is included with the downloaded sample data.

Technologies Used:

• Django/Python - Web Framework
• D3.js - JavaScript Graphing Library
• MaterializeCSS/Sass - Front end design
• PostgreSQL - Database
• HTML/JavaScript/JQuery - Responsive Elements

Database Setup:

• Install postgresql if you haven't

  sudo apt-get install python-pip python-dev libpq-dev postgresql postgresql-contrib

• Install psycopg2

• Set up the postgresql server with a user, myprojectuser with CREATEDB permissions, and set the password as specified in the settings.py file located in the djangoproject directory.

  psql CREATE USER myprojectuser WITH PASSWORD 'password' CREATEDB; \q #to exit the psql interactive terminal

• Prepare database migrations

  python manage.py makemigrations -initdb

• Migrate the database

  python manage.py migrate