Hello, World! This is Yanfu’s Geospatial portfolio 🗺️ 🧭 📍

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

• LinkedIn.

Here are the key words on this page! 🔑

I. My static pre-recorded demos……👀

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

Tech Stack: ArcGIS Server, ArcGIS Online, SQL Server, ArcGIS Javascripts API, ArcGIS SDK for iOS/Android, Apache Cordova, C3.js, HTML5/CSS3

• How to Run ArcGIS Server Anywhere: macOS and Unsupported Linux with Containers { Tutorials available soon!!! }
• No Kubernetes licensing ($50K/year) needed - Dockerize ArcGIS Enterprise Server 10.0 SP5 For Linux
• State-of-Art/Gov. Tech - Integrated Network of Scientific Information & GeoHydrologic Tools
• Lab Project - A Mobile GIS App For Environmental Data Collection - YouTube
• Lab Project - Volunteered Geographic Information (VGI) Website - YouTube
• Lab Project - All the ArcGIS based Environmental Mobile Apps developed in the Steve Jobs Era

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

Tech Stack: GeoServer, PostgresSQL/PostGIS, Flask, Apache Cordova, OpenLayers, HTML5/CSS3

• ArcGIS Enterprise alternative (Apache Accumulo) - Dockerize GeoServer with GDAL/Vector Tiles/GeoMesa plugins
• ArcGIS Enterprise alternative - Dockerize Geoserver with GDAL/Vector Tiles plugins
• Imager Server alternative - Accessing GeoTrellis image server and dynamic tile stitching
• ESRI offers this capability via Spatial/3D Analyst (~$650/year) - Interactive Viewshed App (3D trajectory analysis) - YouTube
• Map Visualization Using GeoServer and OpenLayers - YouTube
• A Mobile GIS App By AngularJS - YouTube
• Map Publishing on GeoServer - YouTube

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

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

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

Tech Stack: QGIS, LasTool, H3, NumPy, PDAL, GDAL, geopandas, shapely, scikit-learn, HTML5/CSS3

• 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
• Downtown Lincoln, Nebraska - Interactive 3D fly over app - YouTube
• Simple LiDAR Data Visualization Tool (Wine + LasTools) - YouTube

Map Routing - Navigation & Realtime GPS+GLONASS & Digital Farming & IoT 🌎

Tech Stack: QGIS, PostgresSQL/PostGIS, OSRM, Raspiberry PI

• Learning pgRouting (A*, Dijkstra) in PostGIS
• The world’s 1st RC Cassette Planter
• DIYMall DY-880TTL GPS module on Raspiberry PI
• QMC5883L Magnet Compass

Other popular routing methods:

• Reference - Parallel Routing Analysis using OSRM and Postgres in Spark
• Reference - Alternative Routing Engine besides pgRouting and OSRM - the “Neo4J”

Drone Image Stitching - UAV Breeding Crops 🛩️

Tech Stack: Three.js, OpenLayers, HTML5/CSS3

• Direct georeferencing UAV images - Cutting costs for ($$$) image stitching
• Quadrilateral Transformation Algorithm

II. My interactive live demos……👀

My interactive live demos are hosted on my personal device for development and testing. Because the system is not running 24/7, please use the Send Inquiry link to let me know when you plan to view the demos.

*Please be ware that the self-signed certificate will trigger security warnings in browsers when you visit my site, and there is a way to bypass that warnings documented in here:

How to temporarily bypass (Chrome, Edge, Firefox) warnings

• Google Chrome/Microsoft Edge: On the warning page, click the Advanced button, then scroll down and click the “Proceed to [website address](unsafe)” or “Continue to” link. A quick trick in Chrome is to simply type thisisunsafe anywhere on the error page.
• Mozilla Firefox: Click the Advanced button, then click Accept the Risk and Continue.

Access to my interactive live demos requires login credentials. I will provide the login details in my response email. The demos available for viewing are listed below.

• Georeferencing UAV Orthos Saving cost for your expensive ($$$) image stitching process
• Online Viewshed Analysis This functionality is available in ESRI’s Spatial/3D Analyst extensions (~$650/year for enterprise users)
• The ArcGIS Server Feature Service Published on ArcGIS Server for Linux running in a container, avoiding the ArcGIS Server on Kubernetes license (~$50K/year for 64 vCPUs).

For future road map, in the next few years……

• Changing all my existing demonstrations to use secured TCP protocol (HTTPS).
• Get a trusted certificate from Let’s encrypt (by doing this, security warnings in browsers will be gone).
• Purchase a used bare-metal server and host my demos on it so they can run 24/7. This would actually be cheaper and less maintenance work than renting an R5.4xlarge EC2 instance on AWS.

III. Miscellaneous works……👀

Data Visualization - Bioinformatics 🧬

• A data science tool for grouping proteins in different pathways (build by D3js)

Tricky Things - Cloud Linux & CI/CD Pipeline 🥷

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

Random Geospatial Works & Self Exploration 🏞️

• How to Add BaseMap in QGIS - YouTube
• A budget build eGPU on Linux for Tensorflow, PyTorch development
• P.E.A.N Stack - YouTube Demo

Motion Pictures - Urban Planning & Architecture 🌆

• Lab Project - Cornhusker Corridor LiNK to LNK Plan 2013 - YouTube
• Lab Project - Trailer 3 for Lincoln Cornhusker Highway Airport Corridor Plan Project - YouTube
• Lab Project - Trailer No.2 for CORNHUSKER HWY CORRIDOR LNK - YouTube

*NOTE: most of the code or data demonstrated here are published to public, if you’re interested, you can download them from:

• my Docker Hub & my GitHub Repo