Trent Pingenot

I am a geospatial developer with over 20 years of experience. I began by consulting and developing in the ESRI ecosystem for desktop and web applications. In 2007, I transitioned to Open Source software and have been primarily developing code in that environment ever since. I develop throughout the full web stack, including DevOps, ETL, server side code, databases, API creation and front end development. I am well versed in spatial and non-spatial data wrangling, analysis and application development.

I started GeoDevelopment in 2010 in order to work with multiple clients. I am a responsible and accountable professional with a history of independent service. I have strong communication and interpersonal skills and am adept at translating client needs and expectations into solutions. For me, geospatial development is both a career and a calling. I see the value and impact of software solutions in solving problems and I find that personally fulfilling.


Skills

Programming Languages & Tools
  • Python (2 & 3)
  • Django, Django Rest Framework, Pandas
  • PostgreSQL 8-12, PostGIS
  • AWS (EC2, RDS, Lambda, API Gateway, IAM, S3, Athena, Route53, more)
  • Mapbox, Google Maps API, Leaflet, OpenLayers
  • HTML, JavaScript, CSS, JQuery
  • Regular Expressions, Beautiful Soup
  • KML, GeoJSON, WMS, GeoPackages
  • Linux Administration and DevOps (Ubuntu, Redhat, Amazon Linux)
  • Git, Subversion, Ansible, Docker
  • Docker
  • QGIS, Tableau, Google Data Studio, Jupyter Notebooks, Google Earth
  • Spatial Analysis, Geographic Projections, Cartography
  • MapServer, GeoServer, PG_TileServ, TileCache
  • SQL including spatial SQL
  • PHP
  • MySQL, Microsoft SQL Server
  • SQLite, SpatiaLite

Experience

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.

2018 - Present

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.

2019 - Present

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.

2010 - Present

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.

2011 - Present

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.

2007 - 2011

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. Some work can be viewed here.

2007 - Present

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.

2014 - 2015

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.

2013 - Present

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.

2007 - 2009

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.

October 2006 - December 2006

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.

April 2006 - August 2006

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.

2003 - 2005

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.

2002 - 2003

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.

2000 - 2001

Education

University of Denver

Masters of Geographical Information Science
August 2001 - May 2003

Rhodes College

Bachelor of Arts in Urban Studies - Sociology
August 1996 - May 2000