Spectral Database

The database is a PostGIS/PostgreSQL object-relational database. This database holds data for the GIS data and for the blog. The GIS database holds two types of data: spectra and hyperspectral image. The database schema is below:

The data is grouped into datasets (e.g minerals). Inside datasets you can have samples and images. Each sample can have one or more spectra. Each spectrum has location data attached (gps). An image object holds a hyperspectra.

The blog database holds posts. There are few type of posts (research, news, department etc.).

On top of the database there is a website that list the posts for the blog, and for now only shows a table of spectra plots the spectra and shows on a map the location where the spectra were taken.

To add to the database, you must be logged in as an “admin”. As an admin you have access to admin area of the website where you can add users, add delete or modify data. Also, admin users can add posts to the website. You can also create users that can only add posts but cannot modify the data part of the database.

To add data through to the database however the preferred method is through a script, it is much faster and safer. For now, I created a script for the spectrophotometer, it reads the metadata extracting all the information including global positioning, converts the data to binary format for protection adds it to database. The only information the user must give is the sample’s name and the datasets it should go to.

For more info, please contact: