Automating the boring stuff


What I do: GIS solutions, Python scripting, and AI-assisted development.

The Goal: Simple tools for complex GIS problems.

Mr Robotto avatar

Highlights

Featured work

Selected tools and games hosted on GitHub Pages.

Tools

Tool

List Genie

List Genie turns messy pasted text into a clean, de-duplicated, alphabetized list you can copy in the format you need (comma-delimited, definition query, or pipe-delimited query-builder style). It can optionally strip specific characters, split on whitespace or newlines, and treat values as case-sensitive or not. You can also compare two lists to see counts, duplicates, and which values match or are unique to each list.

Tool

Database Explorer

The Database Explorer is a ArcGIS Python tool that takes your GDB or SDE databases as the input and automatically generates interactive HTML documentation for all your tables and Feature Classes. It extracts comprehensive metadata including column names, data types, constraints, and relationships, then transforms this information into a clean, searchable web interface.

The generated HTML output provides an organized, user-friendly way to browse your database schema without needing direct database access or specialized tools. Users can quickly search across all tables and columns, view detailed field information, and understand the structure of your data—making it ideal for developers, analysts, and stakeholders who need to reference database documentation.

Tool

Overlap Oracle

The Overlap Oracle is a GIS due diligence tool designed for Planners to identify legal and non-legal constraints associated planned polygon and line features. It performs spatial analysis by comparing input features (such as cutblocks) against multiple reference layers defined in a processing spreadsheet, detecting both direct overlaps and features within specified buffer distances.

The tool generates three types of output reports: an Excel spreadsheet with color-coded overlap details organized by constraint category, an interactive HTML web map displaying the input feature and all overlapping layers with popup information, and optional GeoJSON files for use in ESRI Earth or other GIS viewers. Each report includes formatted attribute information, overlap area calculations (in hectares), and canned guidance statements to help planners track completion of required assessments and ensure compliance with applicable legislation and management practices.

Tool

THLB Genie

Automated Timber Harvesting Land Base Analysis tool for ArcGIS Pro

Transform complex constraint analysis into actionable forest management insights. Process multiple layers, apply buffers, and generate comprehensive THLB/CFLB classifications—all from a single tool.