An app for the forest service to track animals for an environmental impact study.
The Forest Service is considering a proposal from a timber company to clearcut a nearby forest of Douglas Fir. Before this proposal may be approved, they must complete an environmental impact study. This application was developed to allow Rangers to track wildlife sightings in the area.
To create the necessary databases, launch postgres, then psql, and run the following commands:
CREATE DATABASE wildlife_tracker;\c wildlife_tracker;CREATE TABLE animals (id serial PRIMARY KEY, name varchar);CREATE TABLE endangered_animals (id serial PRIMARY KEY, name varchar, health varchar, age varchar);CREATE TABLE sightings (id serial PRIMARY KEY, animal_id int, location varchar, ranger_name varchar, endangered boolean, sighting_occured timestamp);CREATE TABLE rangers (id serial PRIMARY KEY, name varchar, badgenumber int, email varchar, phonenumber int);CREATE DATABASE wildlife_tracker_test WITH TEMPLATE wildlife_tracker;
Copyright (c) 2017 MIT License