Close

Kuang-Cheng Cheng

Civil Engineer/GIS Developer/Spatial Data Analyst

Download Resume

About Me

As an experienced civil engineer turned GIS professional, I possess a diverse skill set that extends beyond transportation and traffic data. My expertise in GIS enables me to integrate and analyze complex datasets, providing valuable insights for problem-solving in the field. I have honed my communication skills through my experience working in public agencies as an engineer, effectively engaging with stakeholders, consultants, and design companies. With a strong foundation in engineering, I am equipped to design solutions that meet the needs of various parties involved. Pursuing a Master's degree in GIS and Cartography has further sharpened my analytical skills, empowering me to tackle challenges in the data science industry. My professional is not limited to only GIS software but also Big data analysis or GeoAI which is innately contained in the geospatial field. I am excited to leverage my skills and expertise as a skilled GIS developer and data scientist to make meaningful contributions to the industry.

Experience

Houston Public Works

GIS Analyst

  • Develop a data quality improvement plan to fix the existing data issues.
  • Create Python script for geoprocessing in order to speed up the processing time and reduce human error.
  • Create, maintain, update geospatial data for telecommunication data on ArcGIS enterprise database.
  • Ensure data quality of telecommunication data.
  • Design and create maps for Infrastructure Design Manual (IDM) using ArcGIS Pro.
  • Improve current workflow for tabular data ETL.
  • Coordinate the GIS projects for different engineering groups so they have a sufficient amount of support.

URISA's GISCorps

GIS Volunteer

  • Test and help with the development of the user interface (UI) of Underpass, a ReactJS library, for the Humanitarian OpenStreetMap Team.
  • Collect street-level images in support of the creation of smart map data for Mapilio, a map platform.
  • Edit buildings on satellite photos for Humanitarian OpenStreetMap Team projects.

University of Wisconsin-Madison

GIS Metadata Technician

  • Assessed LiDAR data inventory statuses
  • Created original ISO metadata for around 400 new yearly Wisconsin county datasets
  • Added interactive tile indexes for Wisconsin LiDAR-derivative data resources
  • Edited Wisconsin V8 county parcel data

Ministry of Transportation and Communication, Taiwan

Assistant Engineer

  • Coordinated the mask distribution (logistics) project for COVID-19
  • Processed mask demand and accounting data, and analyzed the mask demand trend
  • Evaluated communication task guidelines for air, shipping, and road transportation
  • Updated, maintained, and delivered routine mobilization data from 9 agencies
  • Arranged the annual training program for senior officers and project leaders

Freeway Bureau, Taiwan

Junior Engineer

  • Examined and revised environmental impact assessment reports
  • Participated in safety and health training courses about freeway maintenance
  • Held environmental education events to educate all employees
  • Digitized Taiwan’s freeway historical slides and photos

Education

University of Wisconsin-Madison

Sept 2021 - May 2023

Master of Science in Geographic Informaiton System (GIS) and Cartography

In my Master's degree in GIS, I gained comprehensive knowledge of GIS Analysis, geocomputing (Big Data and Machine Learning), spatial database design, and cartography design. Building on my engineering problem-solving skills and the professional knowledge gained from my work experience and undergraduate courses, I developed a strong aptitude for applying GIS tools to solve complex spatial problems. This program deepened my understanding of the technical and analytical aspects of GIS and allowed me to explore new areas of interest in this dynamic field. With this knowledge, I am well-equipped to tackle real-world challenges and make meaningful contributions to the GIS and spatial data community.

National Central University

Sept 2011 - June 2015

Bachelor of Science in Civil Engineering

During my undergraduate studies in Civil Engineering, I took courses in Surveying, Surveying Practice, Photogrammetry, Engineering Statistics, Programming for Engineering, Numerical Analysis, Transportation Engineering, and Construction Management. These courses helped me develop a strong foundation of knowledge and skills that have been essential to my professional development in the field of Data Analysis. In particular, they sparked my interest in GIS, which led me to pursue a Master's degree in this area. Today, my undergraduate education continues to serve as a solid base upon which I build my career.

Projects

React Dashboard Demo

This is a demo for building a dashboard using ReactJS. I used different professional open-sourced libraries to build this page, showcasing my ability to visualize the data in different ways including simple functional calendars, charts, and maps for geographic data.
More information about this, please check the README file in the repository.

View Project Repository
View Dashboard

React Website Demo

This is a demo for building a multi-page website using ReactJS. It includes the use of ReactJS, Leaflet(map), React Router, and the GitHub Deployment library. If you are interest in how I build a website, please come in and check.
More information about this, please check the README file in the repository.

View Project Repository
View Website

Yearly Ridership Data Visualization And Analysis For The Taipei Metro System In Taiwan

Presenting a novel project aimed at providing public transport agency personnel with a new approach to analyzing ridership trends using the Taipei Metro System as an example. This project incorporates a workflow designed to enable new GIS analysts to aggregate and visualize data simultaneously, utilizing both a 3D map in Jupyter Notebook and a 2D web map. The project focuses on time-series mapping, with the dataset covering the period from 2015 to 2022.

View Project Repository
View Web Map

Metro Transit Redesign Evaluation 2022

This project aims to evaluate proposed route redesigns for the Metro Transit system in Madison. Using Python and geocomputing techniques, this project performs analysis of current bus stop performance. The map is created using Folium, while data analysis is carried out using geospatial packages such as pandas and geopandas. Additionally, OSMnx and NetworkX are utilized to calculate and display the shortest path. Furthermore, Matplotlib and Shapely are used to highlight important areas relevant to the ongoing discussion between the Metro Transit company and the local community.

View Project Repository

Spatial Database Design

This project is a collaborative project. In this project, we went through the relational model design for the database, data integration, and data query including spatial and traditional data queries using SQL in PostgreSQL to answer the questions. I was mainly responsible for processing and integrating different national parks' tabular visitation data into one. For more information, check out our project report or my repository.

View Project Repository
Project Report

UI/UX Design - Interactive Map

This project is a collaborative project. The goal is to demonstrate the yearly variations in United States export data sourced from OEC, with the aim of enabling residents to comprehend the evolving export scenario in the country. I was mainly responsible to write the code to create this page, and participate the design including layout, fonts and color use. This page was using JavaScript/HTML/CSS with Leaflet library.

View Map

Automation/Data Collection - Web Scraping

This repository contains the code that I wrote in my Geocomputing (spatial data analysis) course. It is a practice to collect data by building a web scraper in Python. The goal is to automate the process of retrieving housing data from Redfin and exporting a list of information including prices, addresses, photos, etc.

View Project Repository

Vector GeoData | Clustering | Machine-learning

This repository contains the code that I wrote in my Geocomputing (spatial data analysis) course. It includes my customized K-means clustering and demonstrates my ability to use a machine-learning package (Scikit-learn).

View Project Repository

Road Salt Use Impact on Sensitive Areas In Marathon County Metropolitan

This project is a GIS analysis project that evaluates the environmental impact of road salt use in the metropolitan area of Marathon County. It was referred by the course instructor and UniverCity Alliance, the project involved several steps of spatial data analysis and visualization. Through this project, I gained valuable hands-on experience in applying GIS technology to solve real-world problems.

View Project Repository
View Map

GIS Analysis - Bank Branch Management

This project is a task in a GIS analysis course that involves mapping the current situation of bank branches and examining the correlation between customer demographic trends and branch performance. Ultimately, we need to provide recommendations on whether to close existing branches or open new ones based on the analysis results.

View Project Repository

Public Transportation Infrastructure in Taiwan

This map is the final project map in the Cartograpy design course. I utilized both ArcGIS Pro and Adobe Illustrator to create a map showing the public transportation infrastructure in Taiwan. It allows the visitors to swiftly and effectively understand which counties or cities are more visitor-friendly in terms of accessible public transportation options, catering specifically to those who prefer relying on local services rather than renting a car. For more maps, check out the Map Gallery.

View Map
View Map Gallery

GIS Software

Data Manipulation and Database Management

Front-end Design

Engineering Drawing, Model Building, and Others