TO CREATE AND POPULATE THE DATABASE
# Compile and get permission to execute the file
chmod +x [FileLocation]/tsfCreateTables.sh
chmod +x [FileLocation]/tsfPopulateTables.sh
# Create psql db
createdb Group3
psql Group3
# Run shell scripts
\i [FileLocation]/tsfPopulateTables.sh
\i [FileLocation]/tsfCreateTables.sh
TO RUN OUR INTERFACE
#Download all files from our GitHub repository
#Run the following commands:
export FLASK_APP=app.py
flask run
You will see the following interface:
Potential outputs for user inputs:
The purpose of our database is to inform people about the increase of greenhouse gases in our environment, and how us people are playing a part in causing this increase. By viewing the data we collected, users become aware of places in New Jersey that are the largest contributers to greenhouse gas emissions, and they may also look at their own areas and see how they contribute to the crisis. This can promote change and spark an interest in people who are dedicated to improving the wellbeing of ourselves and our environment.