FRONT END DESIGN OF THE APP - ANDROID APP
We have used Appsheet to design the front end of the app. The app has three main views in the main view of the app.
1. Menu View - We have three options under the menu list, first one is all location which provides a list of all locations arranged in alphabetical order, the second is waypoint which provides a list of waypoints arranged in the most recently accessed stack form, and lastly timestamp log option which provides a list of timestamp logs grouped by locations.
2. Site View - This view provides a list of all the sites arranged in alphabetical order, and each site contains a list of locations.
3. Map View - This view provides a visualized map view of all the geotagged locations in red color and geotagged waypoints in pink color, along with a navigation option to the site.
.
BACK END DESIGN OF THE APP - GOOGLE SHEETS
We have used Google Sheets as the backend of our app. We have created five spreadsheet structures.
1. Site Sheet - This sheet contains 5 columns, a row number, a unique key-id which is autogenerated making each site unique, a site name, site description, and a list of site locations.
2. Location Sheet - This sheet contains 7 columns, row number, a unique key-id which is autogenerated making each location unique, a location name, a location description explaining the significance of the location, latitude and longitude point on the map, location image, photos of the location, and location log entries consisting on time-stamped data.
3. Waypoint Sheet - The sheet contains 5 columns, row number name of the waypoint, latitude, and longitude point of the waypoint, a key which is a unique id distinguishing each waypoint, and description of the waypoint.
4. Location Time Stamp Sheet - The sheet contains 8 columns, a unique key id which is auto-generated that makes each location timestamp entry unique, a note with a description of timestamp, name of the person entering the timestamp, and image file, text file, an audio file, video file and timestamp entry with date and time of logged entry.
5. Location Photos Sheet - The location photos sheet contains 3 columns, row number, the location where the photo was taken, and the photo itself.
0 Comments