PHP Developer for GIS Platform by Sheng YuPHP Developer for GIS Platform by Sheng Yu

PHP Developer for GIS Platform

Sheng Yu

Sheng Yu

$17K+ earned

Field Inspection Platform for Utilities

Short description: Built new features for Golden Retriever, a 12-year-old asset inspection platform that utility crews use to document pole inspections in the field.
Project overview: Golden Retriever helps utility companies collect and manage pole inspection data. For the platform’s 12th year, the team invested in modernizing the product and expanding what inspectors can do in the field. I contributed to that work across the admin portal and the field app.
What I built:
Redesigned admin portal. I rebuilt the admin interface with a new layout, a new color palette and a cleaner design. Customers can now find and manage their inspection data faster.
Pole strength calculator. I built an in-app cross-section calculator. It starts with a round pole, subtracts the damaged or missing wood, and computes the remaining area, moment of inertia and section modulus. It can attach an image of the results to the inspection record automatically. It also stores the inspector’s raw inputs separately, so the result can be checked later with another approved tool.
Geospatial data converter. I built a converter inside the admin portal that turns Shapefile, GeoJSON, KML/KMZ and GPX files into WGS84 CSV, ready to import. Before this, customers needed separate GIS software for the same task.
Impact:
Customers no longer need outside GIS tools to prepare imports
Field strength calculations are documented and auditable, at no extra license cost
The admin experience is cleaner and faster for daily use
Tools: React, TypeScript, Node.js, PostGIS / GDAL, PHP
Like this project

What the client had to say

Working with Sheng was a great experience. They’re a talented developer who tackles complex problems with creativity and calm. Reliable, collaborative, and genuinely easy to work with. Highly recommended.

Dave Umrysh, Umycode Technologies

Nov 28, 2025, Client

Posted Feb 19, 2025

Built new features for Golden Retriever, a 12-year-old asset inspection platform that utility crews use to document pole inspections in the field.

Likes

5

Views

129

Earned

$17K+

Timeline

Jul 15, 2024 - Nov 28, 2025

Clients

Umycode Technologies