Trent Pingenot

Recent Startup

For the last few years, I have been assisting a startup company to create a highly dynamic serverless mapping and natural language processing application. This project uses several core AWS Services including CloudFront, Lambda, RDS, S3, Athena and API Gateway. The project includes serverless ETL of Census and OSM data, an API, dynamic Mapbox Vector Tiles (MVT) directly from PostGIS and a Python web application using Mapbox.

Educational Nonprofit

A nonprofit client needed help aggregating usage metrics from their social media accounts to capture their reach. I built tools to pull daily metrics from several social media APIs including Facebook, Mailchimp, Google Analytics and Twitter. The Python tools run nightly in the AWS serverless environment to feed a private dashboard in Google Data Studio.

GeoLens

GeoLens provides parcel management tools to builders and land developers through Software as a Service (SaaS). During the last decade, I built numerous web mapping applications using AWS, Google Maps, Open Layers, MapServer, PostGIS, Python, Django and Mapbox. I was the primary developer for responsive web applications, native iOS and Android applications, and APIs to support projects in many disciplines including transportation, land development, building management and oil and gas. Their software played a key role in CDOT's Colorado 2013 Flood Recovery response and was specifically utilized in a retaining wall inspection application.

BillTracK50

Since 2011, I have developed web scrapers and parsers for BillTrack50, culling information from various state legislature and agency websites. The parsing involves Beautiful Soup in Python and regular expressions to accommodate a variety of encoding and formatting implementations. The project started in Python 2 but has mostly migrated to Python 3. The code is stored in Subversion and uses Microsoft SQL Server.

The Timoney Group

In partnership with Brian Timoney of the The Timoney Group , I built Google Earth and Microsoft Virtual Earth applications for the oil and gas industry. We utilized MapServer, GeoServer and MapGuide to serve regionated KML and WMS images. I wrote programs and data loading scripts in Python, PHP, VBA and .NET to serve data from Access, PostgreSQL, MS SQL Server and Oracle.

Colorado Counties Inc.

Over the years, I have produced a variety of maps for Colorado Counties, Inc. These maps help inform the broader public and include information on locally adopted marijuana regulations, broadband deployment activities, COVID-19 regulations and county commissioner names. Initially, I used ESRI ArcMap but now use QGIS. To automate the update process, Python code reads Excel or Google Sheets of data by county and updates the data in SQLite or GeoJSON.

HostGIS

In 2014, I assisted graduate students analyzing Junco bird sightings in the western USA. The project involved extensive Python and Bash scripting to download and reference raster PRISM historical climate data from the late 1800s to today. The process required examining each sighting location based on the day and year and looking five years before and after and recording various point and polygon statistics. The academic results can be found here.

LeadNDT

LeadNDT is an oil and gas pipe inspection company. Since 2013, I have created and maintained several applications. The first project created a website to load and manage pipe inspections in a PostgreSQL database. The website is built in JQuery and uses PHP to allow users to load and view inspections and review charts of pipe metrics over time. I also created a web application to load and share job invoices and documents.

Geowest

Several years ago, I assisted Geowest with supporting an urban planning project using the ESRI ArcMap suite of products. I worked to automate their proprietary geoprocessing workflow using ArcGIS, Python and Microsoft VBA. The project involved creating and ingesting Excel files for mobile field collection as well as syncing data between GIS and Microsoft Access. We used ArcMap, Microsoft Excel and MS Access to create maps and reports in Crystal Reports.

ESRI Chile

While living in Chile, I consulted on the system design for Chile's National Online Atlas and GeoPortal. This required researching and documenting current world trends of geospatial portals and NSDIs. I wrote sections of functional, implementation and architectural design documents. The project culminated with a prototype portal using ESRI’s Geoportal Toolkit 3.1.

National Institute of Biodiversity (INBIO)

I was fortunate to work in the GIS section of INBO. While there, I created ArcObjects tools for custom geographic datum transformations in Costa Rica. I wrote ArcGIS ModelBuilder Python scripts and models for data processing and analysis. I helped analyze plant and animal species locations for grant reports and assisted INBIO GIS staff with problem solving and technical assistance.

Destiny Resources

I created VB.NET, VB6, VBA applications using Microsoft objects and ArcObjects for environmental remediation and infrastructure planning projects. I analyzed environmental data through 3D interpolation and other geostatistical models. My work involved creating animations and complex figures of modeled environmental data using C Tech EVS and ESRI products. I was responsible for managing multiple projects including troubleshooting and GIS problem solving.

ESRI Denver

I worked as a Graduate Research Assistant in the ESRI Denver consulting group. While there, I created ArcObjects based tools for clients and assisted with application development and support for ArcIMS and ArcGIS. This involved helping develop training materials for GeoDatabase Jump Starts. I was able to complete training courses in ESRI software including ArcObjects, ArcGIS and ArcSDE.

Landscape Analysis Lab - University of the South

After college, I spent a year studying logging activity in the Cumberland Plateau. I was responsible for image scanning, rectification and land-use delineation. I performed analysis of tabular, coverage and image data to determine changes in land use. I trained and assisted staff and professors in basic GIS operations. I presented research results at conferences and in academic publications.

University of Denver