- Adam Schmehl
Updated: Apr 4
This is an archived website page from 2016
This is our portfolio page, a collection of our full-stack solutions both in-house and for our clients across North America. Contact us if you’re interested in any of the solutions below, or you have a problem that requires a custom software solution; our team loves a good challenge.
Katapult Pro is a full-stack web application for pole data collection and processing software. Fully design, collect, and process your pole data for third-party attachments, make ready engineering, and pole loading analysis. Katapult Pro allows you to process and deliver your data in an easy-to-read and consumable format. Katapult Pro is simple to learn and allows new staff to thrive their first day in on the job and allows your most experienced engineers to analyze hundreds of poles each week remotely from the comfort of their office.
STREET LIGHTS PORTAL
The Street Lights Portal is an online tool for requesting, tracking, collaborating and processing street light and area light upgrades and installation requests. A utility customer with existing street lights or area lights can log in using their utility billing information to log in and request to convert their existing lights to LED lights or request additional lighting using a map-based interface directly in the browser. A third party contractor hired by the utility uses custom features in the portal to generate BOMs, navigate to light locations, and report conversions from the field using their smartphone to scan the QR code on the installed equipment, all in real time within the same interface. Custom exports from the interface are automatically transferred to the utility to update their internal database, keeping records up to date and maintaining a streamlined workflow.
POLE ATTACHMENT SERVICES FRONT END
The pole attachment services front end was built to manage all third-party pole attachment applications for attaching a new asset to a utility pole. This service integrates a live database of all utility poles eligible for attachment to a third party and allows them to submit an application to attach their property. That application then goes to the data collection company for field collection. Once the field data is collected and processed, the deliverable then gets posted to the front-end for the client to look at and is reviewed by the utility for permission to build.
PhotoHeight.com was a web-based photo processing software built to calibrate photos in order to measure heights of utility poles and their assets attached to them. Subscribers to this software would drag and drop photos of a pole and calibrate the image by clicking on targets of known heights on a leveling rod or it’s equivalent. PhotoHeight.com can then annotate and help the user engineer the pole and document the condition of the pole. The software took the image and created a Photo Form which the user could email, share, or print to deliver the data for construction or for a virtual rideout.
PMP (Photo Measure Program) was built as a high powered internal tool that can process and annotate lots of data in a photo. It worked in collaboration with a GIS system that connects photos of poles and their midspans as they are in the field so that users could bring the engineering back to the office from the field. The data was collected and sorted into PMP and then displayed as a Photo Form for delivery.
Coded in Java using SQLite as its data storage mechanism.
PMV (Photo Measure Viewer) was a web-based deliverable that could be accessed by the client to view their data after data collection and processing. Our internal programs created the dataset which PMV then displayed online. It incorporated a display on top of Google Maps in addition to the calibrated images, and it also had multiple supplemental photos giving a 360 degree perspective of the pole in the field. PMV was an interactive viewer that allowed the user to get additional measurements from the pole.
Photo First was a simple internal processing program that was built to allow remote processing of photos to leverage a crowdsourced workforce. Photos are labeled and calibrated offsite to expedite the processing and organization of data collected in the field. This tool is now a standard workflow in Katapult Pro Photos.
The OSP panel was a plugin built in QGIS, an open source GIS platform that uses a Spatialite database that can be taken in the field. The OSP panel streamlined the field user’s workflow by creating simple tools to design each job. The panel allowed the user to quickly input the field data and capture anything in the field that was important for the process back in the office.
A Python plugin architecture built atop QGIS (Quantum GIS). It accessed PostGIS and Spatialite for data storage.
This web application is a database search engine for poles in a database. This can be built for any pole owner with assets numbered uniquely in a database structure. You can then link the data for each pole to Katapult Pro to view and analyze the data on top of your design.
This Front-end web application was built to coordinate PennDOT data with PPL data and manage pole relocations from start to finish. Using this application, you can see what assets will need to be moved or re-engineered to make space for a change to the road system. Data can be collected, shared, and updated with a survey. Decisions made based on that data are tracked within this system.
ENVIRONMENTAL PERMIT TRACKER
The permit tracker web application is used to unify communication between contractors and project managers to coordinate work efficiently in environmentally protected areas. The project manager can schedule work months in advance in coordination with other departments and project managers sharing resources.
Mapper was a web-based GIS design program that allowed users to design and strand map in a live environment online. What the designer in the field is drawing could be seen live back at the office. Using GPS, aerial imagery and a set of design tools, this tiny app transformed OSP design.
Mobile Maps was a web-based GIS design program that allowed users to interact with Field Maps from a mobile device.
Utilities have thousands or tens of thousands of employees, so training needs to be done in a timely manner. Scheduler books locations and teachers based on their availability automatically and alerts everyone involved. This program takes out all of the headaches and allows you to focus on the quality of the training.
FEG Outage is a tool for planning large-scale grid maintenance and development projects. The program allows engineers and project managers to look into the future and anticipate when outages are planned, avoid scheduling conflicts and determine the best way to replace, build or maintain transmission lines.
FEG outage scheduler is coded in HTML and is based in Polymer software. Polymer links to a local server program called Deployd. Deployd is not cloud-based, making it a perfect solution for high-security backend purposes.