Wash U Doing Weekly Log

Note: From the week of January 27th to the week of February 17th, the group was pursuing a different project. The entries from the week of March 3rd and beyond reflect our work on our most recent project.

Week January 27th

In the first week, we formed our group of three members: Kristine Ehlinger, Carol Pazos, and Dylan Zubata. We decided to focus our project on creating an app that optimizes the walking distance across Wash U's campus.

Week February 3rd

This week we discussed the details of our project as we created our first Project Proposal. We met with our TA on Thursday and made various decisions about our project including: dividing the work, the programming language we plan to use, the resources we need for our project, and a project timeline.

Week February 10th

This week we began familiarizing ourselves with the ArcGIS tool and contacted the GIS department to discuss full features of ArcGIS. We also mapped out all of the destinations we intend to include in the app.

Week February 17th

After discussing with WUSTL employees, our group is waiting to be granted permission to use the WUSTL ArcGIS subscription. We also continued to annotate our map of Wash U's campus on ArcGIS and did further research into the optimization of our pathways. Specifically, we found an archive that describes how to "Find a Route," which can be utilized with our map.

Week February 24th

Permission has been granted to use WUSTL's ArcGIS subscription. ArcGIS's AppStudio has been downloaded to assist in incorporating our map into our app. We're currently trying to figure out the basics of AppStudio while other team members continue working on the map.

Week March 3rd

All: After reevaluating our initial proposal, we decided to look at new options for a project. We discussed a few different ideas, wrote mock proposals, and met with Natalie on Monday, February 27th. On Tuesday, we cemented our new idea: a platform to display events around campus. This website will be used by both students and organizations with an interactive map. On Thursday, we had our first evaluation, after which we used our notes to create a better understanding of our objectives for the website.

Kristine: Investigated the functions of Amazon Web Services, set up various trials of instances and websites, purchased the domain name "www.washudoing.com," linked domain name with website IP address

Carol: Renamed project page and weekly log page to reflect progress on new project, started labeling locations within the WUSTL campus on google maps, created test html code. In the process of trying to link event data with location "pop-up" descriptor.

Dylan: Updated Gantt Chart with individual job assignments, assured this and all future weekly logs are updated on time, came up with apt site name: "WashUDoing," began researching how to implement filters.

Week March 10th

All: We had a group meeting on Sunday to discuss the progress of our project and make decisions like whether to use ArcGIS or Google maps, how we want the website to look, etc.

Kristine: Looked for source code for a login page, created a DB to store username and password data, watched a video about coding a login page, practiced with source code from websites like ArcGIS and WashU's universal login

Carol: Added drop down menu for locations. In the process of using WUGO's source code to show events based on its relevance according to location.

Dylan: Continued research on HTML and finding source code. Began deciding on which filters to include on the site. Intend to include filters similar to those found on WUGO.

Week March 17th

All: Spring break

Kristine: Found source code for specific parts of a website such as drop-boxes, Learned from existing websites like BlackBoard, the WUSTL login page, etc. as to how to store and display our information, Contacted an AWS user/ professional for putting together SQL and linking the information input, the database, and the website output

Week March 24th

Kristine and Dylan: Met together to reevaluate project and create new Gantt chart

Kristine: Discussed SQL creation with professional, downloaded SQL, SQL workbench, and php

Dylan: Basically created the entire home page without links connecting within. Implemented header. Implemented calendar. Implemented checklist of filters. Ensured the two are seen side by side for aesthetic. Implemented option to create event that needs hyperlink. Embedded previously created map via arcGIS. See project wiki for screenshot of progress as of March 23rd.

Week March 31st

Kristine In order to create a functional website, I have begun familiarizing myself with the capabilities of mySQL and PHPMyAdmin. After downloading the software, I created a local host server (on my personal laptop) to begin creating the PHP that runs queries to and from the website and the SQL server on my laptop. The first step I did was figure out what data we want to store from our website: information about events including name, date, time, location, etc. I created an SQL table called "eventinfo" and am creating PHP to add and read information from that server.