top of page
Project | 01
San Francisco International Airport (SFO) - Terminal Gate Map 

SFO previously had no spatial base layer for the airport terminals on record. Thus, I collaborated with engineers and designers to use their work on Autodesk, and transformed and converted CAD drawings. I then overlayed and highlighted terminals and brought it into our GIS system.

Tool: ArcGIS Desktop, Online and Server, AutoCAD
Project | 02
Precipitation and Evaporation Changes in California in the Month of December.pdf

The California drought has been going on for years. However, 2015-2016 has been known as an El Niño year and, according to scientists, 2015 was the hottest year in historical record. El Niño is a climate pattern that describes the unusual warming of surface waters in the eastern tropical Pacific Ocean, and the El Niño years can involve excessive rainfall compared to normal years in California. During the peak of winter this past December, California experienced more rain than had been seen for decades. I am comparing precipitation and evaporation during the month of December between 2014 and 2015. The following is my calculation: Percent change = (New value – Old value) / Old value * 100. From December 2014 to December 2015, the results show that precipitation had increased dramatically in Central and Northern California. However, evaporation had recorded in negative values, which meant that Northern and Central California were very wet because of more rainfall and less evaporation. In contrast, Southern California had tremendously increased in evaporation but was drier with very little precipitation.

Tool: ArcGIS Desktop, Adobe Illustrator
Project | 03
SFO - Elevators, Escalators and People Movers

SFO had no visuals on their elevators, escalators and people movers. The solution was I built a database to keep the details and the locations of the infrastructure for the maintenance team to maintain existing infrastructure.  I also used added floor plans on ArcGIS app to track the infrastructure for QA/QC.

Tool: ArcGIS Desktop, Online, Server, ModelBuilder and  WepApp Builder

Project | 04
SFO - Cell Phone Tower Locations

Mobile network providers have unstable coverage near the SFO. Therefore, I built an SFO cell phone tower coverage using buffer ring analysis to show a 10-mile (increment of 1-mile) distance of each of the mobile providers' coverage towers to show network coverage. I looked for overlap  coverages between Sprint, Verizon and AT&T cell phone tower locations around SFO as provided to SFO IIM. The distance calculation was not meant to model a cell phone tower signal propagation.

Tool: ArcGIS Desktop

Project | 05
SFO - Terminal Furniture

Over 60k Airport furniture had been stolen every year. The solution was to build a spatial database to track all new furniture that included the conditions and costs of each furniture for the maintenance team to repair and renew them. I utilized ArcGIS app to track and label furniture attributes on iPad so I could do cost analysis on new and existing furniture to forecast new inventory cost.

Tool: ArcGIS Desktop, Online, Server, ModelBuilder and Survey123, Prezi