Welcome to my digital portfolio! 🎉 🎊 🎈

Summary 😎 (This is generated from the ChatGPT after I showed it this page! 😂)

Hi, I’m Yanfu Zhou. I’ve been working in the geospatial industry for more than 10 years, and I’m passionate about geospatial technologies and building systems that turn complex spatial data into practical, scalable solutions.

This portfolio highlights selected projects across LiDAR processing, UAV imagery, routing engines, IoT/GPS tracking, and cloud-native spatial infrastructure using tools such as Python, PostGIS, AWS, and GCP. Throughout my career in government, agriculture, and enterprise environments, I’ve focused on transforming research-driven and manual workflows into efficient, production-ready platforms.

If you’re looking for someone who combines deep geospatial expertise with strong engineering execution, I’d be happy to connect.(LinkedIn)

Here are the key words on this page! 🔑

3D print, 3D trajactory, A*, Algorithm, AngularJS, Apache Cordova, ArcGIS Enterprise Server, ArcGIS Javascripts API, ArcGIS Server Restful API, Bambu Lab X-1 Carbon, CH, Compass, CSS3, DEM, Dijkstra, DSM, ESRI’s geodatabase, GDAL, GeoMesa, GeoServer, GeoTrillis, Google Earth, Government Tech, GPS, H3, HTML5, kubernetes, LasTools, LiDAR, Linux, MLD, Mobile GIS, Neo4J, Numpy, Openlayers, OSRM, PDAL, pgRouting, Planter, PostGIS, Postgres, PyTorch, QGIS, Raspiberry PI, Spark, State-of-Art, Tensorflow, UAV, vector tiles, viewshed, VNC, Web Mercator

Things that I want to show… 👀

LiDAR Point Cloud - H3 Hexagon & Digital Elevation Model & 3D Printing 🛰️

• How to 3D Print My Neighorhood on Bambu Lab X-1 Carbon
• A data science tool for generate hexagonal DEM from LiDAR (build by PDAL, NumPy and more)
• Why need to use hexagonal Digital Surface Model (DSM)?
• H3 hexagon visualization on Google Earth pro
• Mapping H3 in Web Mercator projection
• Simple LiDAR Data Visualization Tool (Wine + LasTools) - YouTube Demo

Map Routing - Navigation & Geocoding 🗺️

• Learning pgRouting (A*, Dijkstra) in PostGIS
• [Reference link] - Most popular routing engine - OSRM (Contraction Hierarchies (CH), Multi-Level Dijkstra (MLD)) (demo)
• [Reference link] - Open Street Map (OSM) Wiki Reference
• [Reference link] - OSRM Project Page
• [Reference link] - Parallel Routing Analysis using OSRM and Postgres in Spark
• [Reference link] - OSRM + H3 + Spark - A New Routing Estimation Method
• [Reference link] - Alternative Routing Engine besides pgRouting and OSRM - the “Neo4J”

ESRI’s Geospatial Platform - ArcGIS Enterprise Server (If budget isn’t your consideration…) 😊

*Note: start from the ArcGIS Enterprise Server 11 for Linux, the required packages may less than before (just need this gettext* package group), you can check detail here

• Dockerize ArcGIS Enterprise Server 10.0 SP5 For Linux
• [Reference link] - Required packages for install ArcGIS Enterprise Server 10.x for Linux on CentOS
• [Reference link] - How to install ArcGIS Enterprise Server for Linux Silently
• [Reference link] - The ArcGIS Enterprise Server Life Cycle

Potential ways for migrate from ArcGIS Enterprise Server to GeoServer without breaking the frontend:

• [Reference link] - How to make GeoServer mimick the ArcGIS Server Restful API
• [Reference link] - Letting GeoServer to use the ESRI’s Geodatabase

OpenSource Cloud Native Geospatial Platform - GeoServer (If budget tight and is your consideration…) 🙁

• Online Viewshed App (3D trajectory analysis) - YouTube Demo
• Dockerize GeoServer with GDAL/Vector Tiles plugins and using GeoMesa datastore
• Accessing GeoTrellis image server and dynamic tile stitching
• Map Visualization Using GeoServer and OpenLayers - YouTube Demo
• A Mobile GIS App By AngularJS - YouTube Demo
• Map Publishing on GeoServer - YouTube Demo

Data Visualization - Water Resources Planning & Bioinformatics 💧

• [State-of-Art/Government Tech] - Integrated Network of Scientific Information & GeoHydrologic Tools (backend: ArcGIS Server) (ArcGIS Javascripts API + C3.js + + HTML5/CSS3)
• A data science tool for grouping proteins in different pathways (build by D3js)

Drone Image Stitching - UAV Breeding Crops 🛩️

• Direct georeferencing UAV images
• Quadrilateral Transformation Algorithm

Realtime GPS+GLONASS Tracking - Digital Farming & IoT 🌎

• The world’s 1st RC Cassette Planter
• DIYMall DY-880TTL GPS module on Raspiberry PI
• QMC5883L Magnet Compass

School Projects - Enviromental Planning Research 🏫

• School Lab Project: Volunteered Geographic Information (VGI) Website (backend: ArcGIS Server) - YouTube Demo
• School Lab Project: A Mobile GIS App For Environmental Data Collection (backend: ArcGIS Server) - YouTube Demo (ArcGIS Javascripts API + Apache Cordova + HTML5/CSS3)

Random Geospatial Works & Self Exploration 🏞️

• Dockerize Geoserver with GDAL/Vector Tiles plugins
• How to Add BaseMap in QGIS - YouTube Demo
• P.E.A.N Stack - YouTube Demo

Motion Pictures - Urban Planning & Architecture 🌆

• School Lab Project: Cornhusker Corridor LiNK to LNK Plan 2013

Linux Hardware - Machine Learning & AI 🤖

• A budget build eGPU on Linux for Tensorflow, PyTorch development

Tricky Things - Cloud Linux & CI/CD Pipeline 🥷

• Programmatically setup VNC password
• Passing local environment variables to Kubernetes