Merge pull request #15 from Sentido-Labs/spill-report

Spill report
Handle updated reports, delivering to the web interface only the final
version
Refactoring, clean-ups and improvements in main map code to allow
reloading the map after updates without having to reload the whole page
Better main map initial centering
Filter cleaned-up spills on request from user
Special marker for cleaned-up spills
Custom icon (exclamation point bubble) for unverified reports
Remove backgrounds from "about" page
Better vertical alignment for input fields, checkboxes, button
Remove CSV GoogleDocs output option because it's not being maintained
any more. It can be recovered later from the repository if needed.
Page data reloading with loadMap(), to show changes after adding or
updating a report without reloading the page
Corrected handling of update spillid references
Better feedback after submitting a report
Ported news and links page from the citizen reports application to the
oil monitoring platform application
Cleaned up and merged CSS
Split CSS for the stories page from the main style.css file
Linked up "News and links" placeholder from navigation
Corrected typo in spill data display
Only create new database files when the calling function specifies a schema
Use schema for users table
Extend users table schema to include e-mail address
Change database file names: now nosdra.csv is the application database,
nosdra-unverified.csv the unverified reports database, and the imported
nosdra database is stored at nosdra-legacy-db.csv
Fill-in incident report for updates when given the original spillid, not only
when selecting in on the map, so that also reports without coordinates
can be updated
Added status field, so adminstrators can mark reports as verified
New design and navigation for data administration pages, now called
Data Explorer
Display user role and name in the Data Explorer page
Sortable data tables in the Data Explorer page
Clickable values in Data Explorer, that load a data view filtered to have
only the rows that have the same value in that field
Simple mailto-based "write to all users in list" functionality for the users
data view
Removed need to specify the dataset in the URL for the main page
New bright blue markers for reports without amount value
New favicon from SDN
Label unverified reports with a yellow "unverified" tag
Clean-up of the CSS styles for the news page
Extend FormUtils to allow simple menus without option for free-text
"other" value
When filling-in the report form, clear the value for fields that are
undefined in the original report; otherwise data gets mixed
Added legend for the unverified reports symbol
Display the original spillid for updated reports, and report status
Clean-up of the data load function
Merge unverified reports layer with the other reports so that they
use the same infrastructure, and switch it from Google Docs to the
new back-end
Clean-up the main site.js file, removing some unused code and fixing bugs
like the ever-growing menus when the map was reloaded
Data import: set status to "verified" automatically since only administrators
can import database files
Correct mistake in base map layer (Sat/Reg) switch that got broken when
refactoring the map loading function in a previous commit
Small prose improvement in data upload form
Allow SQL queries for empty field values, so that we can find rows where
a specific field is empty
Merge branch 'gh-pages' of https://github.com/sdn4nigeria/monitoring-platform into spill-report
Merge pull request #16 from Sentido-Labs/spill-report

Back-end changes during May from Alberto, and web design changes by Rory.
Merge pull request #11 from Sentido-Labs/gh-pages

Back-end and map improvements since late April to late May.