WalkSafe

##talk about adding PostGIS in PostGres here

Download PpgAdmin4 and csv file

1. Create a database 'walksafe'
2. Manually: Connect to walksafe, right click on extension add postGIS
3. In termial: psql -d walksafe -c "CREATE EXTENSION postgis;"

##Updating EC2 DB with seed file

1. SSH into EC2 DB
2. Filezilla to drop new csv files into /var/www/WalkSafe-server/db/csv folder
3. SSH into EC2 Server

npm run seed

##Updating EC2 DB by hand

1. Open up PSQL shell on local computer
2. Connect to EC2 DB with team username and password
3. use \copy command to upload csv files into the EC2 DB

##Updating RDS DB by hand

1. Open up PSQL shell on local computer
2. Connect to RDS DB with team username and password
3. use \copy command to upload csv files into the RDS DB