EFK Portfolio

Esad Kopru

Geospatial Data Engineering, GIS Software Development & Spatial Data Science

10+ years connecting spatial data, analytical methods, and GIS applications to support practical decisions.

  • Python
  • SQL
  • GIS applications
  • ETL pipelines
  • Spatial optimization
All projects

Highlighted work

Three projects across geospatial analysis, data delivery, and public-facing software.

Data engineering

Structure Inspection Data Pipeline

Flight tracks identify nearby structure candidatesIllustration with invented geometry. Ordered GPS points form a flight line with a shaded proximity band. Solid squares represent nearby structure candidates; hollow squares lie outside the band. Proximity does not confirm an inspection. No geographic distance is shown. Flight path Nearby structures
Illustration · Candidate coverage

Automating flight-track processing and structure inspection data updates in enterprise GIS.

80% less refresh processing time per run

  • Python
  • Selenium
  • ArcPy
Read case study: Structure Inspection Data Pipeline

All projects

Start with selected case studies in each area. Expand a collection to browse more projects and historical examples.

Spatial & Data Analysis

  1. Historical Property Value Analysis

    Compare nearby and surrounding home-value growth, with sensitivity checks for sample composition.

  2. Park Accessibility & Investment Prioritization

    Compare walking-zone needs and park condition to inform investment priorities.

  3. Crime Analysis

    Connect GIS dashboards to automated record updates and address enrichment.

More projects (5) in Spatial & Data Analysis
  1. Ground Patrol Analytics and Inspection Priorities

    Turn inspection records into consistent work priorities and reporting views.

  2. ArcGIS Enterprise and Online

    Migrate map services and modernize enterprise GIS delivery.

  3. Spatial Analysis

    Explore historical neighborhood data, terrain, land cover, and parcel screening.

  4. QGIS

    Prepare OpenStreetMap data and map a five-waypoint driving route.

  5. Code Enforcement Violations

    Compare recorded code violations at rental and non-rental properties.

ML / Optimization

  1. Building Footprints Comparison: SAM 3 vs ESRI

    Compare two building-footprint models using shared cleanup and evaluation rules.

  2. Traveling Salesman

    Compare routing algorithms and the tradeoff between solution quality and runtime.

  3. Lead Pipe Prediction Prototype

    Test model evaluation and review queues using synthetic service-line records.

More projects (2) in ML / Optimization
  1. Water Conservation Routes

    Explore archived inspection routes, geographic groups, and a later Python routing workflow.

  2. Income Level Prediction Using R

    Compare R classification models for predicting income categories.

Development & ETL

  1. Structure Inspection Data Pipeline

    Automate flight-track processing and structure inspection data updates in enterprise GIS.

  2. SQL Server to ArcGIS Online

    Prepare spatial data contracts and publish private ArcGIS Online snapshots.

  3. Work Order Mapping and GIS Integration

    Link maintenance work orders to GIS assets and shared reporting data.

More projects (6) in Development & ETL
  1. Python Scripts & Notebooks

    Browse historical automation examples and selected current application views.

  2. Impervious Surface Update & Recovery

    Update enterprise and hosted surface data with staged checks, verified backups, and recovery reporting.

  3. SQL Server and GIS Data Integration

    Prepare synthetic address, parcel, and reporting data through documented SQL workflows.

  4. Road Network Building with PostGIS and pgRouting

    Build synthetic directed road graphs for shortest paths and time-budget reachability.

  5. Automated Parcel Integration and Publishing

    Automate parcel updates with checks before publishing shared GIS data.

  6. Web AppBuilder Migration Assistant

    Inspect legacy web apps and prepare migration plans for human review.

Applications

  1. Public Web GIS and Application Modernization

    Build public mapping tools and modernize the browser interface.

  2. Coordinate Fetcher

    Reuse known address coordinates and identify unresolved CSV matches.

  3. Interactive Workforce Atlas

    Compare U.S. state labor-market patterns through linked maps and monthly trends.

More projects (4) in Applications
  1. Geospatial Web Applications

    Explore standalone JavaScript mapping applications using synthetic demonstration data.

  2. ArcGIS Pro Cartography Add-Ins

    Automate cartographic tasks with ArcGIS Pro add-ins.

  3. School-Zone Sign Evidence Explorer

    Organize candidate sign imagery and location evidence for field review.

  4. Worksite Coordinate Engine

    Convert geographic positions into local worksite coordinates and calibrate site grids.

Image viewer

100%