GIS Analyst

LULU LIU

Transit & GIS Analyst

Expert in sustainable transportation and GIS, with a strong focus on active travel, multimodal transportation, and environmental justice. Skilled in leveraging modeling, machine learning, and GIS tools to deliver insights and innovative solutions for transportation challenges. Experience

CALSTART Sep-Now 2024

Clean Transportation Data Research Intern

- Led validation and updates of a global zero-emission vehicle database (ELT): scraping data by Python script and building a streamlined pipeline across different platforms: Python, PostgreSQL and AWS. Conducted data analytics and update new tableau interface.

- Designed and deployed an interactive web map dashboard using JavaScript, HTML, and CSS, visualizing endorsers and manufacturers’ distribution. Built pipeline from dataset to visualization board.

- Led global Green Road Corridors Project’s data collection, traffic volume analysis and interactive map dashboard for zero emission medium- and heavy-duty vehicles. Supported related policy research across countries in Asia.

- Supported endorser engagement and built connection with related organization, government and manufacturer. SMART CITIES RESEARCH CENTER, LAWRENCE BERKELEY NATIONAL LABORATORY Jan-Sep 2024 Research Assistant

- Completed the data validation project of 'Mobiliti' platform by comparing model simulation results with Replica data and real-world data like ADT, sensor data (Government Portal and Caltrans PeMS) by Linear Regression R2, Correlation, MSE and Symmetric Absolute Error. Finished the analysis result into reports and maps. Helped the underline model improve performance and accuracy in the future.

- Provided transportation analysis for Caltrans focus on bridge and tunnel congestion investigation based on running ‘Mobiliti’ under different scenarios and parameters.

- Led HOV line volume and LOS estimation study in Bay Area based on ‘Mobiliti’ result and mathematic model. Constructed python script to estimate 3643 HOV line average flow, speed and LOS during peak hours automatically.

- Built San Jose mobility geodatabase by spatial matching road links from different data sources OSM and complete map content validation. Conducted spatial data analysis and created high-quality interactive maps for the Bay Area Mobility Map using ArcGIS, QGIS and Python.

- Developed and maintained a spatial analysis and visualization pipeline in JavaScript and Kepler.gl. Collaborated on the geospatial database management using Git for version control. UNIVERSITY OF CALIFORNIA, BERKELEY Aug 2023-May 2024 GIS Teaching Assistant: Geographic Information Science, Quantitative Methods in Environmental Planning

- Led the design and execution of software operation lab sessions focused on Esri Software

- Designed new parts of the lab course facing new functions and advanced skills in ArcGIS Pro (ArcGIS Online Data Management, Web Map, Jupyter Notebook in ArcGIS)

DEPARTMENT OF PUBLIC WORKS, CITY AND COUNTY OF SAN FRANCISCO July-Oct 2023 Urban Design Intern

- Participated in Lakeview Steps, 1550 Evans Marketplace, and Yosemite Creek projects in San Francisco

- Helped with the master plan (Photoshop), community meeting material(InDesign), rendering, and construction drawings (Civil 3D)(Including material details, irrigation detail, vegetation details.) HASSELL SHANGHAI STUDIO Feb-April 2022

Urban Design & Planning Intern

- Participated in large scale urban design projects in Shanghai including green planning and commercial projects

- Modeled landscape features and walls, modified design models in Rhino, and used Photoshop to create renderings, Illustrator to generate analytical maps, and InDesign to format project reports ********@********.*** +1-415-***-**** Personal Website LinkedIn GitHub Education

UNIVERSITY OF CALIFORNIA, BERKELEY Aug 2022 - May 2024 Master of Landscape Architecture (STEM) GPA: 3.85

Focus on GIS and Urban Spatial Analysis

Courses: Geographic Information Science, Data Science for Smart Cities, Human Mobility and Network Science, Principles and Techniques of Data Science, Quantitative Methods in Environmental Planning ZHEJIANG UNIVERSITY Sep 2018 - Jun 2022

Bachelor of Agriculture GPA: 3.82

Core Courses: Applied Statistics, Urban Planning for Green System, Ecology and Experiment(B) Skill

Spatial Data Analysis: ArcGIS Pro (Raster and Vector processing, 3d analysis, Network Analysis), QGIS, Python

(Geopandas, NumPy, Pandas), SQL (PostgreSQL, MySQL), Google Earth Engine, Machine Learning, Fast-API Programming: Python, JavaScript, HTML, CSS

Visualization: Tableau, PowerBI, Kepler.gl, Python (Matplotlib, Seaborn), ArcGIS Online, Adobe Suite (Photoshop, Illustrator, InDesign)

Data Management: AWS, Git, PostgreSQL, ArcGIS Enterprise, Excel Certificate

Google Data Analytics Professional Certificate

IBM Machine Learning Professional Certificate

Graduate Certificate of Geographic Information Science and Technology (UC Berkeley) Graduate Certificate of Applied Data Science (UC Berkeley) Research Project

GREEN PATH: San Francisco Street Environment Evaluation Based on GSV Image Classification. Sep-Dec 2024

- Processing about 10,000 google street images to evaluate San Francisco Downtown Area’s street tree canopy and research street green justice from pedestrian's perspective.

- Build a toolbox to help governments develop phased strategies to determine which road networks need to be upgraded first under limited budgets

CHARGING FOR ALL: Network Analysis for Expanding Service Range of EV Charging Stations in SF Feb-Apr 2023

- Proposed a GIS framework that integrates demographic data, network analysis, and policy insights to ensure equitable access to EV charging infrastructure.

- Modeled future demand to identify underserved areas and optimize site selection for public charging stations. SCENERIES ON THE ROAD: Impact of Tree Seasonal Changes on Active Travel March 2020 - March 2021

- Used GPS travel trajectories to determine whether street plants are dominated by deciduous trees through the Normalized Vegetation Index (NDVI),and uses ArcGIS multiple linear regression to study the impact of street seasonal changes on people's active travel behavior. Reference

Lu Liang

Associate Professor in Geospatial Science, University of California, Berkeley *******@********.***, 510-***-****

Jane Macfarlane

Executive Director Smart Cities, Institute of Transportation Studies, University of California Berkeley Lawrence Berkeley National Laboratory

**************@********.***, 510-***-****

Contact this candidate