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