Current Project Description :

Currently, the LA Bureau of Engineering stores all of their photos in a folder and renames them to keep track of any associated metadata. The Los Angeles Photo Archive (LAPA) allows users to easily tag and upload photos to an Azure blob storage and store associated metadata in an Azure SQL database. The LAPA has the following features:

 

• LAPA uploads photos to an Azure cloud blob storage.
• LAPA uploads metadata tags to an Azure SQL server database.
• LAPA allows users to select images from their phone or camera for upload.
• LAPA allows users to select whether or not to use Wifi or Cell Data to upload photos.
• LAPA allows users to choose how long images will be stored on their phone.
• LAPA allows users to launch the application via a specific URL containing metadata parameters.
• LAPA allows users to view all photos taken filtered by categories.

Once implemented, city workers will be able to easily upload and tag photos, as well as keep track of any photos taken for a given category. Database admins will also be able to progammatically generate a link that will launch their app with the associated metadata for simpler photo tagging.

 

 

Project Description as Described By Customer:

The LA City Bureau of Engineering has asked us to finish the implementation of last year's LAPA (LA Photo Archive) Android Application and integrate it with their Sidewalk Repair metadata categories.  We are going to design an Azure backend and modify the currently existing Android application and use the actual categories the Bureau of Engineering is using to store metadata.  All the backend code will be managed by Visual Studio and published to an Azure Web application. 

 

I did some brainstorming with Julie Sauter, the Deputy City Engineer over our sidewalk program and we think we have a pretty good idea of what we would like to do.  We already have a database of the repair locations and display them in GIS, but what we have struggled with is how to make an efficient process for the recording of before/after photos for each site.  I think that we could leverage the application that was completed last year for taking the photos, but for this year's project we thought that it might be a good idea to start with last year's project and automate the passage of information from our existing application that is used in the field to record other site information and automatically pass the parameters from that application to the photo application.  We were thinking that there will likely be a few bugs or enhancements needed to last year's base application that will be discovered in the process so it would essentially be two parts 1) the implementation of last year's application for the sidewalk program and 2) the enhancement of the application to automatically receive parameters from a calling application or web application and also to note before photos vs after for the sidewalk program.

 

As a Senior Design Project last year a student team from the CSULA Dept. of Computer Science developed a Photo Archive application (PABOE) for the BOE. PABOE, consists of apps that run on both Android and iOS devices. It allows users -- BOE engineering staff and others -- to take photos, tag them with identifying data, and upload them to a database on the BOE's Microsoft Azure Cloud Server. Backend code, also developed by the team, runs on the Azure server to support the upload task

 

---

TEAM MEMBERS

Brian Kan - Project Leader - brian.a.kan@gmail.com

Phillip Han - Android Project Leader - naphilhan@gmail.com

Araceli Lopez - QAQC Lead - lopez_araceli1@sbcglobal.net

Kaila Mayho - Requirements/Documentation Lead - kaila9511@gmail.com

Bernard Bollinger III - Liaison Contact - bernardbollinger@gmail.com

Patricia Luz - iOS Project Leader - triciamaeluz@rocketmail.com

Sharon Lake - Backend Leader - parallaxplace@gmail.com 

 

 

---

---

LIAISON CONTACTS

City Of Los Angeles Bureau Of Public Works - Department of Engineering:

Ted Allen - ted.allen@lacity.org

Ray Uyemura - ray.uyemura@lacity.org

Alisa Blake - alisa.blake@lacity.org

Raul Virgen - raul.virgen@lacity.org

 

---

This year the BOE requests that a Senior Design team from the CSULA Dept. of Computer Science enhance PABOE as follows:

1. Construct an interface between PABOE and the existing BOE Sidewalk Database System so that PABOE can import data from that system and link photos to repair tasks.

2. Provide a means to link and identify the before-photo(s) and after-photo(s) for each repair task.



Meeting time: Fridays 12-1.

 

---

 

Team Resources